本帖最后由 siantii 于 2011/11/29 10:31 编辑
a:adempiere新会计准则缺省科目账套模板(请试用)2楼
/////////////拷贝粘贴另存为csv格式即可/////////////////////
[Account_Value],[Account_Name],[Account_Description],[Account_Type],[Account_Sign],[Account_Document],[Account_Summary],[Default_Account],[Account_Parent],[Balance Sheet],[Balance Sheet_Name],[US 1120 Balance Sheet],[US 1120 Balance Sheet_Name],[Profit & Loss],[Profit & Loss_Name],[US 1120 Income Statement],[US 1120 Income Statement_Name],[Cash Flow],[Cash Flow_Name]
,,,,,,,,,,,,,,,,,,
1,资产类,,Asset,,,Yes,,,,,,,,,,,,
1001,库存现金,,Asset,Debit,,Yes,,1,,,,,,,,,,
100101,零用现金,,Asset,Debit,Yes,,CB_ASSET_ACCT,1001,,,,,,,,,,
100102,在途现金,,Asset,Debit,Yes,,CB_CASHTRANSFER_ACCT,1001,,,,,,,,,,
1002,银行存款,,Asset,Debit,,Yes,,1,,,,,,,,,,
100201,支票账户,,Asset,Debit,Yes,,B_ASSET_ACCT,1002,,,,,,,,,,
100202,在途支票,,Asset,Debit,Yes,,B_INTRANSIT_ACCT,1002,,,,,,,,,,
100203,未确认收款的支票,,Asset,Debit,Yes,,B_UNIDENTIFIED_ACCT,1002,,,,,,,,,,
100204,未分配收款的支票,,Asset,Debit,Yes,,B_UNALLOCATEDCASH_ACCT,1002,,,,,,,,,,
1122,应收账款,,Asset,Debit,,Yes,,1,,,,,,,,,,
112201,应收账款 - 贸易,,Asset,Debit,Yes,,C_RECEIVABLE_ACCT,1122,,,,,,,,,,
112204,应收账款 - 服务,,Asset,Debit,Yes,,C_RECEIVABLE_SERVICES_ACCT,1122,,,,,,,,,,
112205,应账收款 - 未开票,,Asset,Debit,Yes,,NOTINVOICEDRECEIVABLES_ACCT,1122,,,,,,,,,,
1123,预付账款,,Asset,,,Yes,,1,,,,,,,,,,
112301,预付账款 - 供应商,,Asset,Debit,Yes,,V_PREPAYMENT_ACCT,1123,,,,,,,,,,
112302,预付账款 - 预付职工工资,,Asset,Debit,Yes,,E_PREPAYMENT_ACCT,1123,,,,,,,,,,
1221,其他应收款,,Asset,Debit,,Yes,,1,,,,,,,,,,
122101,其他应收款 - 公司内部往来 - 资产,,Asset,Debit,Yes,,INTERCOMPANYDUEFROM_ACCT,1221,,,,,,,,,,
122102,其他应收款 - 应收税款,,Asset,Debit,Yes,,T_RECEIVABLES_ACCT,1221,,,,,,,,,,
1401,材料采购,,Asset,Debit,Yes,,P_ASSET_ACCT,1,,,,,,,,,,
1409,库存 - 作业现场库存,,Asset,Debit,Yes,,P_FLOORSTOCK_ACCT,1,,,,,,,,,,
1410,库存 - 在制品,,Asset,Debit,Yes,,P_WIP_ACCT,1,,,,,,,,,,
1420,库存 - 一般贸易?,,Asset,Debit,Yes,,W_INVENTORY_ACCT,1,,,,,,,,,,
1430,项目资产,,Asset,Debit,Yes,,PJ_ASSET_ACCT,1,,,,,,,,,,
1440,项目过程资产,,Asset,,Yes,,PJ_WIP_ACCT,1,,,,,,,,,,
2,负债类,,Liability,,,Yes,,,,,,,,,,,,
2202,应付账款,,Liability,Credit,,Yes,,2,,,,,,,,,,
220201,应付账款 - 贸易,,Liability,Credit,Yes,,V_LIABILITY_ACCT,2202,,,,,,,,,,
220202,应付账款 - 服务,,Liability,Credit,Yes,,V_LIABILITY_SERVICES_ACCT,2202,,,,,,,,,,
220203,应付账款 - 未******,,Liability,Credit,Yes,,NOTINVOICEDRECEIPTS_ACCT,2202,,,,,,,,,,
220204,付款选择,,Liability,Credit,Yes,,B_PAYMENTSELECT_ACCT,2202,,,,,,,,,,
2203,预收账款,,Liability,Credit,,Yes,,2,,,,,,,,,,
220301,预收账款 - 客户预付款,,Liability,Credit,Yes,,C_PREPAYMENT_ACCT,2203,,,,,,,,,,
2221,应交税费,应交税费,Liability,Credit,,Yes,,2,,,,,,,,,,
222101,应交增值税,应交税费→应交增值税 ,Liability,Credit,,Yes,,2221,,,,,,,,,,
22210101,进项税额,应交税费→应交增值税→进项税额,Liability,Debit,Yes,,T_CREDIT_ACCT,222101,,,,,,,,,,
22210102,销项税款,应交税费→应交增值税→己交税金,Liability,Debit,,,T_DUE_ACCT,222101,,,,,,,,,,
222102,所得税,应交税费→应交所得税,Liability,Credit,Yes,,T_LIABILITY_ACCT,2221,,,,,,,,,,
222103,代扣税款,,Liability,Credit,Yes,,WITHHOLDING_ACCT,2221,,,,,,,,,,
2241,其他应付款,,Liability,Credit,,Yes,,2,,,,,,,,,,
224101,公司内部往来,,Liability,Credit,Yes,,INTERCOMPANYDUETO_ACCT,2241,,,,,,,,,,
3,共同类,,,,,Yes,,,,,,,,,,,,
4,所有者权益,,Owner's equity,,,Yes,,,,,,,,,,,,
4103,本年利润,,Owner's equity,Credit,Yes,,RETAINEDEARNING_ACCT,4,,,,,,,,,,
5,成本类,,Expense,,,Yes,,,,,,,,,,,,
5001,生产成本,,Expense,,,Yes,,5,,,,,,,,,,
500101,基本生产成本,,Expense,,Yes,,P_COSTOFPRODUCTION_ACCT,5001,,,,,,,,,,
500102,辅助生产成本,,Expense,,Yes,,,5001,,,,,,,,,,
500110,产品成本调整,,Expense,,Yes,,P_COSTADJUSTMENT_ACCT,5001,,,,,,,,,,
500111,产品库存冲销,,Expense,,Yes,,P_INVENTORYCLEARING_ACCT,5001,,,,,,,,,,
500112,废品损失,,Expense,,Yes,,P_SCRAP_ACCT,5001,,,,,,,,,,
500113,外包费用,,Expense,,Yes,,P_OUTSIDEPROCESSING_ACCT,5001,,,,,,,,,,
500120,产品费用,,Expense,,Yes,,P_EXPENSE_ACCT,5001,,,,,,,,,,
5004,销货成本,,Expense,,Yes,,P_COGS_ACCT,5,,,,,,,,,,
5005,库存成本,,Expense,,,Yes,,5,,,,,,,,,,
500501,库存损耗,,Expense,,Yes,,W_DIFFERENCES_ACCT,5005,,,,,,,,,,
500502,库存调节,,Expense,,Yes,,W_INVACTUALADJUST_ACCT,5005,,,,,,,,,,
500503,库存重估,,Expense,,Yes,,W_REVALUATION_ACCT,5005,,,,,,,,,,
5006,销货成本差异,,Expense,,,Yes,,5,,,,,,,,,,
500601,发票价格差异,,Expense,,Yes,,P_INVOICEPRICEVARIANCE_ACCT,5006,,,,,,,,,,
500602,采购价格差异,,Expense,,Yes,,P_PURCHASEPRICEVARIANCE_ACCT,5006,,,,,,,,,,
500603,采购价格差异冲抵,,Expense,,Yes,,PPVOFFSET_ACCT,5006,,,,,,,,,,
500604,数量差异,,Expense,Debit,Yes,,P_USAGEVARIANCE_ACCT,5006,,,,,,,,,,
500605,方法规格变更差异,,Expense,,Yes,,P_METHODCHANGEVARIANCE_ACCT,5006,,,,,,,,,,
500606,工资率差异,,Expense,,Yes,,P_RATEVARIANCE_ACCT,5006,,,,,,,,,,
500607,混合差异,,Expense,Debit,Yes,,P_MIXVARIANCE_ACCT,5006,,,,,,,,,,
500608,平均成本差异,,Expense,,Yes,,P_AVERAGECOSTVARIANCE_ACCT,5006,,,,,,,,,,
5007,销货折扣,,Expense,,,Yes,,5,,,,,,,,,,
500701,销货折扣收入,,Expense,,Yes,,P_TRADEDISCOUNTREC_ACCT,5007,,,,,,,,,,
500702,付款折扣费用,,Expense,,Yes,,PAYDISCOUNT_REV_ACCT,5007,,,,,,,,,,
6,损益类,,Revenue,,,Yes,,,,,,,,,,,,
6001,主营业务收入,,Revenue,,,Yes,,6,,,,,,,,,,
600101,产品销售收入,,Revenue,,Yes,,P_REVENUE_ACCT,6001,,,,,,,,,,
600102,预收收入,,Revenue,,Yes,,UNEARNEDREVENUE_ACCT,6001,,,,,,,,,,
600103,未开*发*票*收入,,Revenue,,Yes,,NOTINVOICEDREVENUE_ACCT,6001,,,,,,,,,,
600104,销售折扣,,Revenue,,Yes,,P_TRADEDISCOUNTGRANT_ACCT,6001,,,,,,,,,,
600105,付款折扣费用,,Expense,,Yes,,PAYDISCOUNT_EXP_ACCT,6001,,,,,,,,,,
6061,外币汇率损益,,Revenue,,,Yes,,6,,,,,,,,,,
606101,银行外币重估获利,,Revenue,,Yes,,B_REVALUATIONGAIN_ACCT,6061,,,,,,,,,,
606102,银行外币结算盈利,,Revenue,,Yes,,B_SETTLEMENTGAIN_ACCT,6061,,,,,,,,,,
606103,未变现获利,,Revenue,,Yes,,UNREALIZEDGAIN_ACCT,6061,,,,,,,,,,
606104,已变现获利,,Revenue,,Yes,,REALIZEDGAIN_ACCT,6061,,,,,,,,,,
6301,营业外收入,,Revenue,,,Yes,,6,,,,,,,,,,
630101,利息收入,,Revenue,,Yes,,B_INTERESTREV_ACCT,6301,,,,,,,,,,
6401,主营业务成本,,Expense,,Yes,,,6,,,,,,,,,,
6403,营业税金及附加,,Expense,,Yes,,T_EXPENSE_ACCT,6,,,,,,,,,,
6602,管理费用,,Expense,,,Yes,,6,,,,,,,,,,
660201,差旅费,,Expense,,Yes,,E_EXPENSE_ACCT,6602,,,,,,,,,,
6603,财务费用,,Expense,,,Yes,,6,,,,,,,,,,
660301,银行手续费,,Expense,,Yes,,B_EXPENSE_ACCT,6603,,,,,,,,,,
6711,营业外支出,,Expense,,,Yes,,6,,,,,,,,,,
671103,利息支出,,Expense,,Yes,,B_INTERESTEXP_ACCT,6711,,,,,,,,,,
671110,货币损失,,Expense,,,Yes,,6711,,,,,,,,,,
67111001,货币平衡,,Expense,,Yes,,CURRENCYBALANCING_ACCT,671110,,,,,,,,,,
67111002,已实现跌价损失,,Expense,,Yes,,REALIZEDLOSS_ACCT,671110,,,,,,,,,,
67111003,未实现跌价损失,,Expense,,Yes,,UNREALIZEDLOSS_ACCT,671110,,,,,,,,,,
67111004,银行外币重估损失,,Expense,,Yes,,B_REVALUATIONLOSS_ACCT,671110,,,,,,,,,,
67111005,银行外币结算损失,,Expense,,Yes,,B_SETTLEMENTLOSS_ACCT,671110,,,,,,,,,,
6801,所得税,,Expense,,Yes,,,6,,,,,,,,,,
6901,以前年度损益调整,,Revenue,,Yes,,,6,,,,,,,,,,
6910,所得合计,,Revenue,,Yes,,INCOMESUMMARY_ACCT,6,,,,,,,,,,
7,暂记与其他类,,,,,Yes,,,,,,,,,,,,
7010,暂记账户,,Expense,,,Yes,,7,,,,,,,,,,
701001,默认暂记账户,,Expense,,Yes,,DEFAULT_ACCT,7010,,,,,,,,,,
701002,暂记余额,,Expense,,Yes,,SUSPENSEBALANCING_ACCT,7010,,,,,,,,,,
701003,暂记错误,,Expense,,Yes,,SUSPENSEERROR_ACCT,7010,,,,,,,,,,
701004,现金簿支出,,Expense,,Yes,,CB_EXPENSE_ACCT,7010,,,,,,,,,,
701005,现金簿收入,,Revenue,,Yes,,CB_RECEIPT_ACCT,7010,,,,,,,,,,
701006,杂费费用,,Expense,,Yes,,CH_EXPENSE_ACCT,7010,,,,,,,,,,
701007,杂费收入,,Revenue,,Yes,,CH_REVENUE_ACCT,7010,,,,,,,,,,
7020,其他费用,,,,,Yes,,7,,,,,,,,,,
702001,坏账冲销,,Expense,,Yes,,WRITEOFF_ACCT,7020,,,,,,,,,,
702002,零用现金盈亏,,Expense,,Yes,,CB_DIFFERENCES_ACCT,7020,,,,,,,,,,
83,已分摊支出,,Expense,,,Yes,,,,,,,,,,,,
8310,已分摊人工成本,,Expense,,Yes,,P_LABOR_ACCT,83,,,,,,,,,,
8320,已分摊间接费用,,Expense,,Yes,,P_BURDEN_ACCT,83,,,,,,,,,,
8330,已分摊制造费用,,Expense,,Yes,,P_OVERHEAD_ACCT,83,,,,,,,,,,
9,承诺确认,,,,,Yes,,,,,,,,,,,,
9101,采购承诺款,,,,Yes,,COMMITMENTOFFSET_ACCT,9,,,,,,,,,,
9102,销售承诺款,,,,Yes,,COMMITMENTOFFSETSALES_ACCT,9,,,,,,,,,,
|