السلام عليكم و رحمه الله و بركاته

خلينا بندأ تحليل خاص بمشروع محاسبه عامه
لو قلنا مثلا ان العميل عنده منظمه و ان المنظمه بتتكون من عده شركات تمام و ان الشركات دى ليها عده فروع فى كذا دوله و فى كل دوله ليها فروع فى المدن بتاعتها و ان الفروع دى بتحتوى على اقسام و ان كل قسم بيحتوى على موظفين
تمام
و بعدين ان العمله الرئيسيه للمنظمه دى هى مثلا الجنيه المصرى او الدولار و ان كل شركه بتتعامل بعمله مختلفه و قيمتها حتكون مثلا كذا بالنسبه للعمله الرئيسيه و ان المنظمه دى ليها سنه ماليه و ان كل شركه وفرع بيقفل السنه الماليه بتعته اما كل ثلاثه اشهر او سته او اثنى عشر شهرا يعنى سنه و ان الحسابات دى انواع و قيود بتترحل من دفتر لدفتر لغايه الميزانيه العموميه و ان كل حساب هل حيأثر فى السنه الماليه و لا لاء ............................... الموضوع طويل جدا جدا جدا و على العموم انا حضع الجداول و نشرحها فى المره القادمه ان شاء الله جزء جزء و حقول ليه انا عملت كل حاجه بالفكره دى و نشوف انتم افكركم ايه

PROMPT Creating Table 'FISCALPERIODS' 
CREATE TABLE FISCALPERIODS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,STARTDATEG  DATE
 ,ENDDATEG  DATE
 ,DESCRIPTIONL  VARCHAR2(200);
 ,DESCRIPTIONA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,FIS_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,FIS_ORG_CODE  VARCHAR2(10); NOT NULL
 ,FIS_CODE  VARCHAR2(10); NOT NULL
 ,FIS_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,FIS_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN FISCALPERIODS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALPERIODS.NAMEL IS 'this Attribute is used to store the english name'
/

COMMENT ON COLUMN FISCALPERIODS.NAMEA IS 'this Attribute is used to store the arabic name'
/

COMMENT ON COLUMN FISCALPERIODS.STARTDATEG IS 'this Attribute is used to store the start date'
/

COMMENT ON COLUMN FISCALPERIODS.ENDDATEG IS 'this Attribute is used to store the end date'
/

COMMENT ON COLUMN FISCALPERIODS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN FISCALPERIODS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN FISCALPERIODS.CREATEBY IS 'this Attribute is used to store the creator date'
/

COMMENT ON COLUMN FISCALPERIODS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN FISCALPERIODS.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN FISCALPERIODS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN FISCALPERIODS.FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALPERIODS.FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALPERIODS.FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALPERIODS.FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALPERIODS.FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'INTERFACE_TABLES' 
CREATE TABLE INTERFACE_TABLES
 (TRANSACTIONNO  VARCHAR2(240); NOT NULL
 ,TRANSFERDATE  DATE NOT NULL
 ,TRANSFERTYPE  VARCHAR2(100); NOT NULL
 ,TRANSACTIONVALUE  NUMBER(20,2);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CRAETEBY  VARCHAR2(10);
 ,CRAETEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,SYS_SYS_ID  NUMBER(10,0); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,JOU_NO  VARCHAR2(10); NOT NULL
 ,AN_CODE  VARCHAR2(10); NOT NULL
 ,TS_TS_ID  NUMBER(10,0); NOT NULL
 );
/

COMMENT ON COLUMN INTERFACE_TABLES.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN INTERFACE_TABLES.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN INTERFACE_TABLES.CRAETEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN INTERFACE_TABLES.CRAETEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN INTERFACE_TABLES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN INTERFACE_TABLES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN INTERFACE_TABLES.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN INTERFACE_TABLES.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN INTERFACE_TABLES.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN INTERFACE_TABLES.JOU_NO IS 'this Attribute is used to store the journal number'
/

COMMENT ON COLUMN INTERFACE_TABLES.AN_CODE IS 'this Attribute is used to store the code of the account nature'
/

PROMPT Creating Table 'FISCALYEARS' 
CREATE TABLE FISCALYEARS
 (CODE  VARCHAR2(10); NOT NULL
 ,STARTDATEG  VARCHAR2(240);
 ,ENDDATEG  VARCHAR2(240);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,YFS_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN FISCALYEARS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALYEARS.STARTDATEG IS 'this Attribute is used to store the start date'
/

COMMENT ON COLUMN FISCALYEARS.ENDDATEG IS 'this Attribute is used to store the end date'
/

COMMENT ON COLUMN FISCALYEARS.REMARKL IS 'this Attribute is used to store the english name'
/

COMMENT ON COLUMN FISCALYEARS.REMARKA IS 'this Attribute is used to store the arabic name'
/

COMMENT ON COLUMN FISCALYEARS.CREATEBY IS 'this Attribute is used to store the craetor data'
/

COMMENT ON COLUMN FISCALYEARS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN FISCALYEARS.LASTUPDATEBY IS 'this Attribute is used to store the who last update the record'
/

COMMENT ON COLUMN FISCALYEARS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN FISCALYEARS.COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALYEARS.COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALYEARS.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALYEARS.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCALYEARS.YFS_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'YEAR_FISICAL_STATUSES' 
CREATE TABLE YEAR_FISICAL_STATUSES
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.NAMEL IS 'this Attribute is used to store the english name'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.NAMEA IS 'this Attribute is used to store the arabic name'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.LASTUPDATEBY IS 'this Attribute is used to store who last update this record'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_FISICAL_STATUSES.ORG_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'DAYBOOKS' 
CREATE TABLE DAYBOOKS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,REMARKA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN DAYBOOKS.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN DAYBOOKS.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN DAYBOOKS.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN DAYBOOKS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN DAYBOOKS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN DAYBOOKS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN DAYBOOKS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN DAYBOOKS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN DAYBOOKS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN DAYBOOKS.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DAYBOOKS.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'CLIENTS' 
CREATE TABLE CLIENTS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,ADDRESS  VARCHAR2(100);
 ,TELEPHONE  VARCHAR2(50);
 ,EMAIL  VARCHAR2(100);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CRAETEBY  VARCHAR2(10);
 ,CRAETEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 );
/

COMMENT ON COLUMN CLIENTS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN CLIENTS.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN CLIENTS.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN CLIENTS.ADDRESS IS 'this Attribute is used to store the address'
/

COMMENT ON COLUMN CLIENTS.TELEPHONE IS 'this Attribute is used to store the telephone'
/

COMMENT ON COLUMN CLIENTS.EMAIL IS 'this Attribute is used to store the electronic mail'
/

COMMENT ON COLUMN CLIENTS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN CLIENTS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN CLIENTS.CRAETEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN CLIENTS.CRAETEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN CLIENTS.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN CLIENTS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

PROMPT Creating Table 'TRANSACTION_STATUSES' 
CREATE TABLE TRANSACTION_STATUSES
 (TS_ID  NUMBER(10,0); NOT NULL
 ,CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 );
/

COMMENT ON COLUMN TRANSACTION_STATUSES.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN TRANSACTION_STATUSES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

PROMPT Creating Table 'ACCOUNT_ANALYSIS_DIMENSIONS' 
CREATE TABLE ACCOUNT_ANALYSIS_DIMENSIONS
 (REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,AD_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 );
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.CREATEDATE IS 'this Attribute is used to store the create date'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.LASTUPDATEBY IS 'this Attribute is used to store the update user data'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.AD_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_ANALYSIS_DIMENSIONS.ACC_CODE IS 'this Attribute is used to store the account code'
/

PROMPT Creating Table 'JOURNALS' 
CREATE TABLE JOURNALS
 (NO  VARCHAR2(10); NOT NULL
 ,ENTRYDATEG  VARCHAR2(240); NOT NULL
 ,DESCRIPTION  VARCHAR2(240);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,JS_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_FIS_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BP_BRA_CIT_COU_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_FIS_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_FIS_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BP_BRA_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BP_BRA_CIT_CODE  VARCHAR2(10); NOT NULL
 ,BP_BRA_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_FIS_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BP_BRA_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_CODE  VARCHAR2(10); NOT NULL
 ,BP_FIS2_FIS_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN JOURNALS.NO IS 'this Attribute is used to store the journal number'
/

COMMENT ON COLUMN JOURNALS.ENTRYDATEG IS 'this Attribute is used to store the entry date'
/

COMMENT ON COLUMN JOURNALS.DESCRIPTION IS 'this Attribute is used to store the description'
/

COMMENT ON COLUMN JOURNALS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN JOURNALS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN JOURNALS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN JOURNALS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN JOURNALS.LASTUPDATEBY IS 'this Attribute is used to store who last update this record'
/

COMMENT ON COLUMN JOURNALS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN JOURNALS.JS_CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALS.BP_FIS2_FIS_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'JOURNAL_STATUSES' 
CREATE TABLE JOURNAL_STATUSES
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,REMARKA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN JOURNAL_STATUSES.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN JOURNAL_STATUSES.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN JOURNAL_STATUSES.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN JOURNAL_STATUSES.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN JOURNAL_STATUSES.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN JOURNAL_STATUSES.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN JOURNAL_STATUSES.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN JOURNAL_STATUSES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN JOURNAL_STATUSES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN JOURNAL_STATUSES.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNAL_STATUSES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'BRANCH_ACCOUNTS' 
CREATE TABLE BRANCH_ACCOUNTS
 (TOBEANALYSED  VARCHAR2(10); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,BRA_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BRA_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BRA_CODE  VARCHAR2(10); NOT NULL
 ,BRA_CIT_CODE  VARCHAR2(10); NOT NULL
 ,BRA_CIT_COU_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.LASTUPDATEBY IS 'this Attribute is used to store the who last update the record'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_ACCOUNTS.BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'YEAR_ACCOUNT_BUDGETS' 
CREATE TABLE YEAR_ACCOUNT_BUDGETS
 (REMARKA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,YB_FIS_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,YB_FIS_CODE  VARCHAR2(10); NOT NULL
 ,YB_FIS_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,YB_FIS_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,YB_FIS_ORG_CODE  VARCHAR2(10); NOT NULL
 ,YB_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BUDGETS.YB_CODE IS 'this Attribute is used to store is used to store the code'
/

PROMPT Creating Table 'YEAR_ACCOUNT_BALANCES' 
CREATE TABLE YEAR_ACCOUNT_BALANCES
 (OPEN_BALANCE  NUMBER(10,2); NOT NULL
 ,CLOSED_BALANCE  NUMBER(10,2); NOT NULL
 ,CURRENT_BALANCE  NUMBER(10,2); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,FIS_CODE  VARCHAR2(10); NOT NULL
 ,FIS_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,FIS_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,FIS_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,FIS_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.OPEN_BALANCE IS 'this Attribute is used to store the account open balance'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.CLOSED_BALANCE IS 'this Attribute is used to store the closed balance'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.CURRENT_BALANCE IS 'this Attribute is used to store the account currenrt balance'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_ACCOUNT_BALANCES.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNTS' 
CREATE TABLE ACCOUNTS
 (CODE  VARCHAR2(20); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,DESCRIPTION  VARCHAR2(100);
 ,OPENDATEG  DATE
 ,OPENINGBALANCE  NUMBER(30,2);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LATUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC1_CODE  VARCHAR2(10); NOT NULL
 ,ACSTS_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20);
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10);
 ,ACC_COM_ORG_CODE  VARCHAR2(10);
 ,AN_CODE  VARCHAR2(10); NOT NULL
 ,AC1_AC1_ID  NUMBER(10,0); NOT NULL
 );
/

COMMENT ON COLUMN ACCOUNTS.CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN ACCOUNTS.NAMEL IS 'this Attribute is used to store the account full english name'
/

COMMENT ON COLUMN ACCOUNTS.NAMEA IS 'this Attribute is used to store the account full arabic name'
/

COMMENT ON COLUMN ACCOUNTS.DESCRIPTION IS 'this Attribute is used to store the account description'
/

COMMENT ON COLUMN ACCOUNTS.OPENDATEG IS 'this Attribute is used to store the account open date'
/

COMMENT ON COLUMN ACCOUNTS.OPENINGBALANCE IS 'this Attribute is used to store the account open balance'
/

COMMENT ON COLUMN ACCOUNTS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ACCOUNTS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ACCOUNTS.CREATEBY IS 'this Attribute is used to store the creator information'
/

COMMENT ON COLUMN ACCOUNTS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ACCOUNTS.LATUPDATEBY IS 'this Attribute is used to store the update user data'
/

COMMENT ON COLUMN ACCOUNTS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ACCOUNTS.COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTS.COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTS.ACC1_CODE IS 'this Attribute is used to store the code of tyhe account group'
/

COMMENT ON COLUMN ACCOUNTS.ACSTS_CODE IS 'this Attribute is used to store the account status code'
/

COMMENT ON COLUMN ACCOUNTS.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN ACCOUNTS.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTS.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTS.AN_CODE IS 'this Attribute is used to store the code of the account nature'
/

PROMPT Creating Table 'FISCAL_PERIOD_ACCOUNT_BALANCES' 
CREATE TABLE FISCAL_PERIOD_ACCOUNT_BALANCES
 (OPENBALANCE  VARCHAR2(240);
 ,CLOSEBALANCE  VARCHAR2(240);
 ,CURRENTBALANCE  VARCHAR2(240);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,FIS2_FIS_ORG_CODE  VARCHAR2(10); NOT NULL
 ,FIS2_FIS_CODE  VARCHAR2(10); NOT NULL
 ,FIS2_CODE  VARCHAR2(10); NOT NULL
 ,FIS2_FIS_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,FIS2_FIS_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,FIS2_FIS_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.OPENBALANCE IS 'this Attribute is used to store the open balance value'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.CLOSEBALANCE IS 'this Attribute is used to store the close balance'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.CURRENTBALANCE IS 'this Attribute is used to store the current balance'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.CREATEDATE IS 'this Attribute is used to store the craetion date'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.LASTUPDATEDATE IS 'this Attribute is used to store the last updatedate'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISCAL_PERIOD_ACCOUNT_BALANCES.FIS2_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNT_CONTROLS' 
CREATE TABLE ACCOUNT_CONTROLS
 (AC_ID  NUMBER(10,0); NOT NULL
 ,CODE  VARCHAR2(10); NOT NULL
 ,PARAMNAME  VARCHAR2(200); NOT NULL
 ,PARAMVALUE  VARCHAR2(200); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 );
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN ACCOUNT_CONTROLS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

PROMPT Creating Table 'COMPANY_CURRENCY_EXCHANGES' 
CREATE TABLE COMPANY_CURRENCY_EXCHANGES
 (DATEFROMG  DATE
 ,DATETOG  DATE
 ,EXCHANGERATE  NUMBER(10,2); NOT NULL
 ,REMARKA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,CC_OC_CUR_CODE  VARCHAR2(10); NOT NULL
 ,CC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,CC_OC_ORG_CODE  VARCHAR2(10); NOT NULL
 ,CC_OC_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,CC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.DATEFROMG IS 'this Attribute is used to store the date from'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.DATETOG IS 'this Attribute is used to store the date to'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.EXCHANGERATE IS 'this Attribute is used to store the exchange date'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CC_OC_CUR_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CC_OC_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CC_OC_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCY_EXCHANGES.CC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNTGROUPS' 
CREATE TABLE ACCOUNTGROUPS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CRAETEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN ACCOUNTGROUPS.CODE IS 'this Attribute is used to store the code of tyhe account group'
/

COMMENT ON COLUMN ACCOUNTGROUPS.NAMEA IS 'this Attribute is used to store the full arabic name of the account group'
/

COMMENT ON COLUMN ACCOUNTGROUPS.NAMEL IS 'the full english name of the account group'
/

COMMENT ON COLUMN ACCOUNTGROUPS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ACCOUNTGROUPS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ACCOUNTGROUPS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN ACCOUNTGROUPS.CRAETEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ACCOUNTGROUPS.L;ASTUPDATEBY IS 'this Attribute is used to store the last update user'
/

COMMENT ON COLUMN ACCOUNTGROUPS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ACCOUNTGROUPS.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTGROUPS.ORG_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ORGANIZATIONS' 
CREATE TABLE ORGANIZATIONS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100);
 ,NAMEA  VARCHAR2(100);
 ,DESCRIPTION  VARCHAR2(200);
 ,CONTACTPERSON  VARCHAR2(100);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,CLI_CODE  VARCHAR2(10); NOT NULL
 ,CUR_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN ORGANIZATIONS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ORGANIZATIONS.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN ORGANIZATIONS.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN ORGANIZATIONS.DESCRIPTION IS 'this Attribute is used to store the description'
/

COMMENT ON COLUMN ORGANIZATIONS.CONTACTPERSON IS 'this Attribute is used to store the contact person data'
/

COMMENT ON COLUMN ORGANIZATIONS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ORGANIZATIONS.REMARKA IS 'this Attribute is used to store the arbic remark'
/

COMMENT ON COLUMN ORGANIZATIONS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN ORGANIZATIONS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ORGANIZATIONS.LASTUPDATEBY IS 'this Attribute is used to store who last updat ethe record'
/

COMMENT ON COLUMN ORGANIZATIONS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ORGANIZATIONS.CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ORGANIZATIONS.CUR_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'JOURNAL_DETAIL_ANALYSIS_DIMENS' 
CREATE TABLE JOURNAL_DETAIL_ANALYSIS_DIMENS
 (DIMVALUE  NUMBER(10,2);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(240);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,AAD_ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,AAD_ACC_CODE  VARCHAR2(20); NOT NULL
 ,AAD_AD_CODE  VARCHAR2(10); NOT NULL
 ,AAD_ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,JOU1_SERIAL  VARCHAR2(50); NOT NULL
 ,JOU1_JOU_NO  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.DIMVALUE IS 'this Attribute is used to store the dimension valus'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.AAD_ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.AAD_ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.AAD_AD_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.AAD_ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.JOU1_SERIAL IS 'this Attribute is used to store the journal entry serial'
/

COMMENT ON COLUMN JOURNAL_DETAIL_ANALYSIS_DIMENS.JOU1_JOU_NO IS 'this Attribute is used to store the journal number'
/

PROMPT Creating Table 'COMPANIES' 
CREATE TABLE COMPANIES
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100);
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,DESCRIPTION  VARCHAR2(240);
 ,WEBADDRESS  VARCHAR2(240);
 ,EMAIL  VARCHAR2(240);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,COMPANYLOGO  LONG RAW
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,CUR_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN COMPANIES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANIES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN COMPANIES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN COMPANIES.DESCRIPTION IS 'this Attribute is used to store the description'
/

COMMENT ON COLUMN COMPANIES.WEBADDRESS IS 'this Attribute is used to store the web site address'
/

COMMENT ON COLUMN COMPANIES.EMAIL IS 'this Attribute is used to store the email'
/

COMMENT ON COLUMN COMPANIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN COMPANIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN COMPANIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN COMPANIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN COMPANIES.LASTUPDATEBY IS 'this Attribute is used to store who last update this record'
/

COMMENT ON COLUMN COMPANIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN COMPANIES.COMPANYLOGO IS 'this Attribute is used to store the company logo'
/

COMMENT ON COLUMN COMPANIES.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANIES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANIES.CUR_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNT_DETAILS' 
CREATE TABLE ACCOUNT_DETAILS
 (SERIAL  VARCHAR2(20); NOT NULL
 ,VALUE  VARCHAR2(200); NOT NULL
 ,REMARKA  VARCHAR2(200);
 ,REMARKL  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,ACA_CODE  VARCHAR2(10); NOT NULL
 ,ACC_CODE  VARCHAR2(20); NOT NULL
 ,ACC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,ACC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN ACCOUNT_DETAILS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.ACA_CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_DETAILS.ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'JOURNALENTRIES' 
CREATE TABLE JOURNALENTRIES
 (SERIAL  VARCHAR2(50); NOT NULL
 ,DESCRIPTION  VARCHAR2(200);
 ,ENTRYVALUE  NUMBER(15,2); NOT NULL
 ,EXCHANGRATE  NUMBER(20,2);
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,JOU_NO  VARCHAR2(10); NOT NULL
 ,BA_BRA_COM_ORG_CLI_CODE  VARCHAR2(10);
 ,BA_BRA_COM_ORG_CODE  VARCHAR2(10);
 ,BA_ACC_COM_ORG_CODE  VARCHAR2(10);
 ,BA_ACC_COM_ORG_CLI_CODE  VARCHAR2(10);
 ,BA_BRA_CODE  VARCHAR2(10);
 ,BA_BRA_CIT_CODE  VARCHAR2(10);
 ,BA_ACC_CODE  VARCHAR2(20);
 ,BA_BRA_CIT_COU_CODE  VARCHAR2(10);
 ,DAY_CODE  VARCHAR2(10); NOT NULL
 ,BC_CC_OC_CUR_CODE  VARCHAR2(10); NOT NULL
 ,BC_BRA_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BC_CC_OC_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BC_BRA_CIT_COU_CODE  VARCHAR2(10); NOT NULL
 ,BC_CC_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BC_CC_OC_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BC_BRA_CODE  VARCHAR2(10); NOT NULL
 ,BC_BRA_CIT_CODE  VARCHAR2(10); NOT NULL
 ,BC_CC_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,BC_BRA_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 ,AN_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN JOURNALENTRIES.SERIAL IS 'this Attribute is used to store the journal entry serial'
/

COMMENT ON COLUMN JOURNALENTRIES.DESCRIPTION IS 'this Attribute is used to store the entry description'
/

COMMENT ON COLUMN JOURNALENTRIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN JOURNALENTRIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN JOURNALENTRIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN JOURNALENTRIES.CREATEDATE IS 'this Attribute is used to store the creation data'
/

COMMENT ON COLUMN JOURNALENTRIES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN JOURNALENTRIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN JOURNALENTRIES.JOU_NO IS 'this Attribute is used to store the journal number'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_ACC_CODE IS 'this Attribute is used to store the account code'
/

COMMENT ON COLUMN JOURNALENTRIES.BA_BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.DAY_CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_CC_OC_CUR_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_CC_OC_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_CC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_CC_OC_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_CC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.BC_BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN JOURNALENTRIES.AN_CODE IS 'this Attribute is used to store the code of the account nature'
/

PROMPT Creating Table 'ORGANIZATION_CURRENCIES' 
CREATE TABLE ORGANIZATION_CURRENCIES
 (REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  VARCHAR2(240);
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,CUR_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CODE  VARCHAR2(10); NOT NULL
 ,ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.CUR_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ORGANIZATION_CURRENCIES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'DEPARTMENTS' 
CREATE TABLE DEPARTMENTS
 (CODE  VARCHAR2(10); NOT NULL
 ,NAMEL  VARCHAR2(100); NOT NULL
 ,NAMEA  VARCHAR2(100); NOT NULL
 ,REMARKL  VARCHAR2(200);
 ,REMARKA  VARCHAR2(200);
 ,CREATEBY  VARCHAR2(10);
 ,CREATEDATE  DATE
 ,LASTUPDATEBY  VARCHAR(10);
 ,LASTUPDATEDATE  DATE
 ,BRA_CIT_COU_CODE  VARCHAR2(10); NOT NULL
 ,BRA_CIT_CODE  VARCHAR2(10); NOT NULL
 ,BRA_COM_ORG_CODE  VARCHAR2(10); NOT NULL
 ,BRA_CODE  VARCHAR2(10); NOT NULL
 ,BRA_COM_ORG_CLI_CODE  VARCHAR2(10); NOT NULL
 );
/

COMMENT ON COLUMN DE

تم تعديل 25 سبتمبر 200718 سنة بواسطة Fabled Warrior

COMMENT ON COLUMN DEPARTMENTS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DEPARTMENTS.NAMEL IS 'this Attribute is used to store the english name'
/

COMMENT ON COLUMN DEPARTMENTS.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN DEPARTMENTS.REMARKL IS 'this Attribute is used to store the english remarl'
/

COMMENT ON COLUMN DEPARTMENTS.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN DEPARTMENTS.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN DEPARTMENTS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN DEPARTMENTS.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN DEPARTMENTS.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN DEPARTMENTS.BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DEPARTMENTS.BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DEPARTMENTS.BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DEPARTMENTS.BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN DEPARTMENTS.BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'SYSTEMS' 
CREATE TABLE SYSTEMS
(SYS_ID  NUMBER(10,0) NOT NULL
,CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,REMARKA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CODE  VARCHAR2(10) NOT NULL
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN SYSTEMS.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN SYSTEMS.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN SYSTEMS.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN SYSTEMS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN SYSTEMS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN SYSTEMS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN SYSTEMS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN SYSTEMS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN SYSTEMS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN SYSTEMS.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN SYSTEMS.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'CITIES' 
CREATE TABLE CITIES
(CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100)
,NAMEL  VARCHAR2(100)
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CRAETEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,COU_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN CITIES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN CITIES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN CITIES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN CITIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN CITIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN CITIES.CRAETEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN CITIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN CITIES.LASTUPDATEBY IS 'this Attribute is used to store who last update this record'
/

COMMENT ON COLUMN CITIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN CITIES.COU_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'YEAR_PER_ACC_BUDGET_VALUES' 
CREATE TABLE YEAR_PER_ACC_BUDGET_VALUES
(BUDGETVALUE  NUMBER(20,3) NOT NULL
,REMARKA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,FIS2_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_FIS_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_FIS_CODE  VARCHAR2(10) NOT NULL
,YAB1_ACC_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,YAB1_ACC_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_FIS_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_FIS_ORG_CODE  VARCHAR2(10) NOT NULL
,YAB1_YB_FIS_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,YAB1_ACC_CODE  VARCHAR2(20) NOT NULL
)
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.BUDGETVALUE IS 'this attribute is used to store the budget account value'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.FIS2_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_ACC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_ACC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_YB_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_PER_ACC_BUDGET_VALUES.YAB1_ACC_CODE IS 'this Attribute is used to store the account code'
/

PROMPT Creating Table 'BRANCH_CURRENCIES' 
CREATE TABLE BRANCH_CURRENCIES
(REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(240)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,CC_OC_ORG_CODE  VARCHAR2(10) NOT NULL
,CC_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,CC_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,CC_OC_CUR_CODE  VARCHAR2(10) NOT NULL
,CC_OC_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,BRA_CODE  VARCHAR2(10) NOT NULL
,BRA_CIT_COU_CODE  VARCHAR2(10) NOT NULL
,BRA_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,BRA_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,BRA_CIT_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN BRANCH_CURRENCIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CC_OC_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CC_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CC_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CC_OC_CUR_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.CC_OC_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_CURRENCIES.BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'COMPANY_CURRENCIES' 
CREATE TABLE COMPANY_CURRENCIES
(REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(240)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,COM_ORG_CODE  VARCHAR2(10) NOT NULL
,OC_CUR_CODE  VARCHAR2(10) NOT NULL
,OC_ORG_CODE  VARCHAR2(10) NOT NULL
,OC_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN COMPANY_CURRENCIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.OC_CUR_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.OC_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COMPANY_CURRENCIES.OC_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'YEAR_BUDGETS' 
CREATE TABLE YEAR_BUDGETS
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,BUDGETSTARTDATEG  VARCHAR2(240)
,REMARKA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,CREEATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,FIS_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,FIS_CODE  VARCHAR2(10) NOT NULL
,FIS_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN YEAR_BUDGETS.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN YEAR_BUDGETS.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN YEAR_BUDGETS.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN YEAR_BUDGETS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN YEAR_BUDGETS.CREEATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN YEAR_BUDGETS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN YEAR_BUDGETS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN YEAR_BUDGETS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN YEAR_BUDGETS.FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_BUDGETS.FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_BUDGETS.FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_BUDGETS.FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN YEAR_BUDGETS.FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNT_CLASS_ATTRIBUTES' 
CREATE TABLE ACCOUNT_CLASS_ATTRIBUTES
(CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,REMARKA  VARCHAR2(240)
,REMARKL  VARCHAR2(240)
,CREATEBY  VARCHAR2(240)
,CREATEDATE  VARCHAR2(240)
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,AC1_AC1_ID  NUMBER(10,0) NOT NULL
)
/

COMMENT ON COLUMN ACCOUNT_CLASS_ATTRIBUTES.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_CLASS_ATTRIBUTES.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN ACCOUNT_CLASS_ATTRIBUTES.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN ACCOUNT_CLASS_ATTRIBUTES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN ACCOUNT_CLASS_ATTRIBUTES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

PROMPT Creating Table 'BRANCH_PERIODS' 
CREATE TABLE BRANCH_PERIODS
(REMARKA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,BRA_CIT_COU_CODE  VARCHAR2(10) NOT NULL
,BRA_CODE  VARCHAR2(10) NOT NULL
,BRA_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,BRA_CIT_CODE  VARCHAR2(10) NOT NULL
,BRA_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_COM_ORG_CODE  VARCHAR2(10) NOT NULL
,FIS2_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,FIS2_FIS_CODE  VARCHAR2(10) NOT NULL
,FPS_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN BRANCH_PERIODS.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN BRANCH_PERIODS.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN BRANCH_PERIODS.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN BRANCH_PERIODS.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN BRANCH_PERIODS.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN BRANCH_PERIODS.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN BRANCH_PERIODS.BRA_CIT_COU_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.BRA_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.BRA_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.BRA_CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.BRA_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_FIS_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_FIS_COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_FIS_COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_FIS_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FIS2_FIS_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCH_PERIODS.FPS_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ANALYSIS_DIMENSIONS' 
CREATE TABLE ANALYSIS_DIMENSIONS
(CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NOTEL  VARCHAR2(200)
,NOTEA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,AD_CODE  VARCHAR2(10)
)
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.NOTEL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.NOTEA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.CREATEBY IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.LASTUPDATEBY IS 'this Attribute is used to store the last update by data'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.LASTUPDATEDATE IS 'this Attribute is used to store the last update by date'
/

COMMENT ON COLUMN ANALYSIS_DIMENSIONS.AD_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'CURRENCIES' 
CREATE TABLE CURRENCIES
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
)
/

COMMENT ON COLUMN CURRENCIES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN CURRENCIES.NAMEL IS 'this Attribute is used to store the full english  name'
/

COMMENT ON COLUMN CURRENCIES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN CURRENCIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN CURRENCIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN CURRENCIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN CURRENCIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN CURRENCIES.LASTUPDATEBY IS 'this Attribute is used to store who last update  the record'
/

COMMENT ON COLUMN CURRENCIES.LASTUPDATEDATE IS 'this Attribute is used to store  the last update date'
/

PROMPT Creating Table 'COUNTRIES' 
CREATE TABLE COUNTRIES
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,ORG_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN COUNTRIES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COUNTRIES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN COUNTRIES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN COUNTRIES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN COUNTRIES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN COUNTRIES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN COUNTRIES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN COUNTRIES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN COUNTRIES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN COUNTRIES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN COUNTRIES.ORG_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'FISICAL_PERIOD_STATUSES' 
CREATE TABLE FISICAL_PERIOD_STATUSES
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(240)
,CREATEBY  VARCHAR2(240)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CODE  VARCHAR2(10) NOT NULL
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.LASTUPDATEBY IS 'this Attribute is used to store who last update the record'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN FISICAL_PERIOD_STATUSES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'BRANCHES' 
CREATE TABLE BRANCHES
(CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100)
,NAMEL  VARCHAR2(100)
,ADDRESS  VARCHAR2(100)
,FAX  VARCHAR2(50)
,TELEPHONE  VARCHAR2(50)
,EMAIL  VARCHAR2(100)
,CONTACTPERSONE  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,COM_ORG_CODE  VARCHAR2(10) NOT NULL
,COM_ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,CIT_CODE  VARCHAR2(10) NOT NULL
,CIT_COU_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN BRANCHES.CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCHES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN BRANCHES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN BRANCHES.ADDRESS IS 'this Attribute is used to store the address'
/

COMMENT ON COLUMN BRANCHES.FAX IS 'this Attribute is used to store the fax number'
/

COMMENT ON COLUMN BRANCHES.TELEPHONE IS 'this Attribute is used to store the telephone number'
/

COMMENT ON COLUMN BRANCHES.EMAIL IS 'this Attribute is used to store the email'
/

COMMENT ON COLUMN BRANCHES.CONTACTPERSONE IS 'this Attribute is used to store the contact persone name'
/

COMMENT ON COLUMN BRANCHES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN BRANCHES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN BRANCHES.CREATEBY IS 'this Attribute is used to store the record creator data'
/

COMMENT ON COLUMN BRANCHES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN BRANCHES.LASTUPDATEBY IS 'this Attribute is used to store the data of who last update this record'
/

COMMENT ON COLUMN BRANCHES.LASTUPDATEDATE IS 'this Attribute is used to store the date of last update'
/

COMMENT ON COLUMN BRANCHES.COM_ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCHES.COM_ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCHES.CIT_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN BRANCHES.CIT_COU_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNT_CLASSES' 
CREATE TABLE ACCOUNT_CLASSES
(AC1_ID  NUMBER(10,0) NOT NULL
,CODE  VARCHAR2(10) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,REMARKA  VARCHAR2(200)
,REMARKL  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,ORG_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN ACCOUNT_CLASSES.CODE IS 'this Attribute is used to store is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.NAMEA IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.NAMEL IS 'this Attribute is used to store the full name'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.REMARKA IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.REMARKL IS 'this Attribute is used to store any remarks'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.CREATEBY IS 'this Attribute is used to store the name of the creator  of the record'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.CREATEDATE IS 'this Attribute is used to store the creation date of the record'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.LASTUPDATEBY IS 'this Attribute is used to store who update the record'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.LASTUPDATEDATE IS 'this Attribute is used to store the date of the update'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_CLASSES.ORG_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNTSTATUSES' 
CREATE TABLE ACCOUNTSTATUSES
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,REMARKL  VARCHAR2(200)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CODE  VARCHAR2(10) NOT NULL
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN ACCOUNTSTATUSES.CODE IS 'this Attribute is used to store the account status code'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.NAMEL IS 'this Attribute is used to store the full english name'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.NAMEA IS 'this Attribute is used to store the full arabic name'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.CREATEBY IS 'this Attribute is used to store the creator data'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.LASTUPDATEBY IS 'this Attribute is used to store the user who make the last update'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.ORG_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNTSTATUSES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

PROMPT Creating Table 'ACCOUNT_NATURES' 
CREATE TABLE ACCOUNT_NATURES
(CODE  VARCHAR2(10) NOT NULL
,NAMEL  VARCHAR2(100) NOT NULL
,NAMEA  VARCHAR2(100) NOT NULL
,REMARKL  VARCHAR2(240)
,REMARKA  VARCHAR2(200)
,CREATEBY  VARCHAR2(10)
,CREATEDATE  DATE
,LASTUPDATEBY  VARCHAR(10)
,LASTUPDATEDATE  DATE
,ORG_CLI_CODE  VARCHAR2(10) NOT NULL
,ORG_CODE  VARCHAR2(10) NOT NULL
)
/

COMMENT ON COLUMN ACCOUNT_NATURES.CODE IS 'this Attribute is used to store the code of the account nature'
/

COMMENT ON COLUMN ACCOUNT_NATURES.NAMEL IS 'this Attribute is used to store the full english name of the account nature'
/

COMMENT ON COLUMN ACCOUNT_NATURES.NAMEA IS 'this Attribute is used to store the full arabic name of teh account nature'
/

COMMENT ON COLUMN ACCOUNT_NATURES.REMARKL IS 'this Attribute is used to store the english remark'
/

COMMENT ON COLUMN ACCOUNT_NATURES.REMARKA IS 'this Attribute is used to store the arabic remark'
/

COMMENT ON COLUMN ACCOUNT_NATURES.CREATEBY IS 'this Attribute is used to store the creator of the record'
/

COMMENT ON COLUMN ACCOUNT_NATURES.CREATEDATE IS 'this Attribute is used to store the creation date'
/

COMMENT ON COLUMN ACCOUNT_NATURES.LASTUPDATEBY IS 'this Attribute is used to store the last update user'
/

COMMENT ON COLUMN ACCOUNT_NATURES.LASTUPDATEDATE IS 'this Attribute is used to store the last update date'
/

COMMENT ON COLUMN ACCOUNT_NATURES.ORG_CLI_CODE IS 'this Attribute is used to store the code'
/

COMMENT ON COLUMN ACCOUNT_NATURES.ORG_CODE IS 'this Attribute is used to store the code'
/

ياريت معلشى حد من الادمنيه ينقل الموضوع الى قسم تحليل النظم لانى غلط و كتبته فى قسم المشاريع

مشكور أخ Fabled Warrior
وأنا متابع معك أول بأول

اخى الفاضل الموضوع اكثر من رائع وقوى جدا بس ممكن شرح فائدة كل Table

مشكور اخى

جزاك الله كل خير

الاخ الكريم
الموضوع رائع و المجهود برضه بس ياريت تشرح فائدة و علاقة الحقول ببعضها و الجداول كمان
جزاك الله كل خير و الف شكر

اخي العزيز الموضوع ممتاز ولكن يا ريت شرح واضح للجداول والربط بينها .

بعتذر عن التأخير لظروف خاصه و راح ابدا غدا ان شاء الله فى شرح كل جزئيه و تصميم الشاشات الخاصه بها ايضا

اولا جزاك الله خيرا
لكن انا ليا راى
ازاى نحط الجدوال قبل ما نعمل تحليل للمشروع
يا ريت نعمل تحليل الاول وبعد كده نشوف الجداول المستخرجه واعمدتها وعلاقتها ببعضها البعض
ثم بعد ذلك ننشىء الجداول ونقوم بتصميم الشاشات حتى يكون لدينا برنامج قوى على اسس علميه سليمه تحليلا وتصميا ان شاء الله تعالى

انا معاك ان شاء الله اول باول ومتابع معك
وبصراحه هذا المشروع الذي ابحث عنه
وهو مهم جدا
للامام ونحن معك ان شاء الله

جميل جميل

وانا معكم

وانا معكم ان شاء الله بس ياريت من الاخ صاحب المشاركة ان يشرح لنا الحياه عامة ازاى اولا فى الانظمة المحاسبية وماهى الجداول المستخدمة مع الشرح؟ وطبيعة العمليات فى هذا النظام

فين ياجماعة الشرح واين صاحب الموضوع برجاء المشاركة !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!