产品成本核算后台表结构

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.FPRODUCTNO and type1.FSEQ=dime1.FBILLSEQ

       inner join T_CB_PROORDERINFO info on info.FPRODUCTDIMEID= dime1.FPRODUCTDIMEID

       inner join T_CB_COSTCALEXPENSE exp1 on exp1.FID=info.FID

   inner join T_CB_COSTCALEXPENSEDETAIL exp1detail on exp1.FENTRYID=exp1detail.FENTRYID ;