HFM 经典模式表结构

转载外网+自己理解

科目

1、表名中 HFM_ 是应用名称

2、如果出现重复数据是因为hfm_account_desc表中存在多种语言，筛选语言即可去重

select  par.label FPARENT,           -- Parent
        ch.label FCHILD,             -- Child
        de.description FDESCRIPTION, -- Description
        decode(ch.accounttype, 0, 'Revenue', 
                               1, 'Expense', 
                               2, 'Asset',
                               3, 'Liability',
                               4, 'Balance',
                               5, 'Flow',
                               7, 'CurrencyRate',
                               '') FACCTTYPE,
        decode(ch.iscalculated, 0, 'False', 'True') FISCALCULATED,      -- HFM IsCalculated
        decode(ch.isconsolidated, 0, 'False', 'True') FISCONSOL,        -- HFM IsConsolidated
        decode(ch.isicp, 0, 'N', 'Y') FISICP,                           -- HFM IsICP
        plg.label FPLUG,                                                -- HFM PlugAccount    
        ch.numdecimalplaces FDEC,                                       -- HFM DecimalPlaces
        decode(ch.useslineitems, 0, 'False', 'True') FLINEITEMS,        -- HFM UsesLineItems         
        ch.userdefined1