产品成本核算后台表结构

1、T_CB_PROORDERTYPE(成本对象类型归集存储表)

2、T_CB_PROORDERDIME(生产订单维度表)

3、T_CB_INPUTQTYENTRY（投入产量归集）

4、关联关系及生成时机

select  *

  from T_CB_PROORDERTYPE type1

       inner join T_BD_MATERIAL mat on mat.FMATERIALID=type1.FPRODUCTID

       inner join T_CB_PROORDERDIME dime1

       on type1.FPROORDERTYPE=dime1.FPROORDERTYPE and type1.FCOSTCENTERID=dime1.FCOSTCENTERID

       and mat.FMASTERID=dime1.FPRODUCTID and type1.FNUMBER=dime1.FP