qq_41206741的博客

–存储资产的基础信息SELECT * FROM fa_additions_b fab;–存储资产的事务处理历史(新增、转移、调整、报废、重建等)SELECT * FROM fa_transaction_headers fth;–存储资产成本变动信息SELECT * FROM fa_books fb;–存储资产的分配信息(员工、费用帐户、地点)SELECT * FROM fa_distribution_history fdh;–存储资产折旧汇总信息SELECT * FROM fa_deprn

SELECT c.segment1 资产大类 ,c.segment2 资产小类 ,gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7 || '.' || gcc.segment8 || '.' || gcc.s