EAS general ledger Memorandum

EAS general ledger memorandum subject 1----1 auxiliary account 1----1 .. N accounting project type creden1-1----1 .. N Credential Entry 1----0 .. N auxiliary account combination table: The t_bd_assistanthg horizontal table. Each accounting project type occupies one column, and each row represents the combination of each accounting project (specific auxiliary account ). Credential: t_gl_voucher credential entry: t_gl_voucherentry secondary account line: t_gl_voucherassistrecord, record amount, foreign key fassgrpid associated with the horizontal table FID (you can find a specific accounting item ). Accounting Project type: t_bd_asstacttype. fmappingfieldname indicates the column name of the Accounting Project in the horizontal table. Custom accounting project type: t_bd_generalasstacttypegroup custom accounting project: t_bd_generalasstacttype. After the EAS client defines the relationship, it is automatically included in t_bd_asstacttype. After BIM is released, fglasstacttypegrpid is set to the associated custom accounting project type. Account Balance Table: t_gl_accountbalance, which records the balance in a timely manner (including the original currency, standard currency, and Report currency). fbaltype table balance type: 1-saved balance, 5-post-account balance. Each record is stored in three rows: the original currency, the integrated standard currency, and the integrated report currency. Therefore, the storage space coefficient is 2x3 = 6. The virtual account balance view v_gl_virtualbalance. The original table t_gl_accountbalanceunion has been deprecated. Auxiliary account balance table: t_gl_1_balance foreign key fassistgrpid is associated with the horizontal table FID. The storage method is the same as above. Current Account: t_gl_acctcussent and fvchassistrecordid are associated with the auxiliary account line of the credential. Write-off relationship history: t_gl_acctcussenthistory subject: t_bd_accounttable accounting subject: t_bd_accountview Period type: t_bd_periodtype accounting period: t_bd_period (comprehensive standard currency) Glc @ # comprehensive report currency) GRC @ $ 22222222-2222-2222-2222-2222222222deb58fdc ------------------------- new custom accounting items: fund accounts, securities intermediary, investment products... ------------------------- Accounting Project Settings: (u) = Update, (+) = add) Bim perspective. Right-click the basic information to set it as an accounting project and publish the business unit. Code submission: (u) abstractassistanthginfo. java (u) t_bd_assistanthg.table (manually add database fields during deployment) (u) assistanthg. entity (+) r_assistanthg_xxx.relation (XXX is an added accounting item, which can be compared with CVS .) Deployment (Accounting Project): 1) t_bd_asstacttype: Add a system accounting project record, or log on to the system and add a new one in the accounting project. 2) manually modify t_bd_assistanthg and add the new accounting project field (fxxxid varchar (44 )). 3) Metadata packaging: t_bd_assistanthg.table and assistanthg. entity, r_assistanthg_xxx.relation 4) Class packaging: abstractassistanthginfo. class packaging ant script part: Class: <include name = "**/EAS/basedata/master/auxacct/abstractassistanthginfo. class "/> metadata: <include name = "**/EAS/basedata/master/auxacct/t_bd_assistanthg.table"/> <include name = "**/EAS/basedata/master/auxacct/APP/assistanthg. entity "/> <include name =" **/EAS/basedata/master/auxa CCT/APP/r_assistanthg_product.relation "/> <include name =" **/EAS/basedata/master/auxacct/APP/r_assistanthg_securitycompany.relation "/> <include name =" **/EAS/ basedata/master/auxacct/APP/r_assistanthg_capitalaccount.relation "/> deployment method: 1) Copy XXX. jar to Lib: The patch directory of the server and the patch directory of the client. 2) copy the xxx-metas.jar to the patches directory of metas: server and client. 3) execute the script for the set of books [modify the horizontal table of the accounting project. SQL], such as: ALTER TABLE t_bd_assistanthg add fproductid varchar (44); Create Table t_bd_product .... new items can appear in the accounting project: (apply for uploading an image, BS !)