《TIPTOP成本计算逻辑axcp500DECODING》由会员分享，可在线阅读，更多相关《TIPTOP成本计算逻辑axcp500DECODING（12页珍藏版）》请在金锄头文库上搜索。
1、成本阶：99 原料无工单(采购料件) ima08=P/V/Z98 原料有工单有BOM97 成品或半成品有工单无BOM0-96 成品或半成品有工单有BOMcca_file 库存成本期初ccb_file 库存成本当月入库调整金额ccc_file 库存月加权成本ccg_file 每月工单主件在制成本（依工单别的分批在制成本） 即工单上阶成本cch_file 每月工单元件在制成本 即工单下阶成本计算范围：有下列情况之一的料件，均纳入计算范围：1 tlf档当期有异动的料件 tlf2当期有投入工时的料件 ccj3有工单备料且有投入工时的料件 sfa/sfb/ccj4当期有上阶在制成本的料件(ccg有余额)
2、5当期有下阶在制成本的料件（cch未余额）6有库存期初开帐的料件cca7当期工单有期初在制开帐金额的料件 ccf8当期工单有在制调整金额的料件ccl9当期工单有工单发退料异动的料件sfb/tlf select 成本阶ima57,料号ima01,须计算重工否ccd03,低阶码ima16,来源码ima08,分群码ima06,其他分群码ima09-11,成本分群码ima12,where ima料号=tlf 料号 and tlf异动日期为当前期间 and tlf902仓库不为JIT仓库 and 仓库不为0 #tlf档当期有异动的料件UNIONWhere ima料号=工单档sfb料号 and 投入工时c
3、cj01在当期期间 and ccj04工单号=工单档工单号sfb01 #当期有投入工时的料件UNIONWhere ima料号=备料档料号sfa03 and 投入工时ccj01在当期期间 and ccj04工单号=工单档工单号sfb01 and sfa备料档料号=sfb工单档料号 #有工单备料且有投入工时的料件UNIONWhere ima料号=在制成本档料号ccg and 在制成本为当期 and ccg91/92当期在制成本数量或单价不为零 #当期有上阶在制成本的料件UNIONWhere ima料号=在制成本元件档cch料号 and 在制成本为当期 and cch91/92当期在制成本数量或单价
4、不为零 #当期有下阶在制成本的料件UNIONWhere ima料号=库存期初开帐料号cca #有库存期初开帐的料件UNIONWhere ccf 期初在制开帐金额档料号=工单档料号sfb and ima料号=sfb工单料号 and 期初在制开帐金额不为零 #当期工单有期初在制开帐金额的料件UNIONWhere ccl当期在制调整金额料号=工单料号ima and ima 料号=工单料号sfb #当期工单有在制调整金额的料件UNIONWhere (未结案工单sfb38 is null or结案日在当前期间内) and ima料号=工单料号sfb05 and tlf单据日期在当前期间内 and tlf
5、工单单号=sfb工单单号 and tlf13异动命令代号为“asfi5*” #当期工单有工单发退料异动的料件例如：SELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file,tlf_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ima01 = tlf01 AND tlf06 BETWEEN 00/01/01 AND 00/01/31 AND tlf902 NOT
6、IN (SELECT jce02 FROM jce_file) AND tlf907 != 0 GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file, ccj_file,sfb_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ima01 = sfb05 AND ccj01 BETWEEN 00
7、/01/01 AND 00/01/31 AND ccj04 = sfb01 GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file, ccj_file,sfb_file,sfa_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ima01 = sfa03 AND ccj01 BETWEEN 00/
8、01/01 AND 00/01/31 AND ccj04 = sfb01 AND sfb01 = sfa01 GROUP BY 1,2,3,4,5,6,7, 8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file, ccg_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ima01 = ccg04 AND ccg02= 1999 AND c
9、cg03= 12 AND (ccg91 !=0 OR ccg92 !=0 OR ccg92a !=0 OR ccg92b !=0 OR ccg92c!=0 OR ccg92d !=0 OR ccg92e !=0 ) GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file,cch_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MA
10、TCHES MISC* AND ima01 = cch04 AND cch02=1999 AND cch03=12 AND (cch91!=0 OR cch92 !=0 OR cch92a!=0 OR cch92b !=0 OR cch92c!=0 OR cch92d !=0 OR cch92e !=0 ) GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file,cca_file,OUTER ccd_file WHERE
11、ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ima01=cca01 AND cca02= 1999 AND cca03= 12 GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file,ccf_file,sfb_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01
12、 NOT MATCHES MISC* AND ccf01=sfb01 AND ima01 = sfb05 AND ccf02=1999 AND ccf03=12AND (ccf11 !=0 OR ccf12!=0 OR ccf12a !=0 OR ccf12b !=0 OR ccf12c !=0 OR ccf12d !=0 OR ccf12e !=0 ) GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06, ima09,ima10,ima11,ima12FROM ima_file,ccl_fi
13、le,sfb_file,OUTER ccd_fileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND ccl01 = sfb01 AND ima01 = sfb05 AND ccl02= 2000 AND ccl03= 1 GROUP BY 1,2,3,4,5,6,7,8,9,10UNIONSELECT ima57,ima01,ccd03,ima16,ima08,ima06,ima09,ima10,ima11,ima12FROM ima_file,tlf_file,sfb_file,OUTER ccd_f
14、ileWHERE ima57=ccd01 AND ima01 matches * AND ima01 NOT MATCHES MISC* AND (sfb38 BETWEEN 00/01/01 AND 00/01/31 OR sfb38 IS NULL ) AND ima01 = sfb05 AND tlf06 BETWEEN 00/01/01 AND 00/01/31 AND tlf62 = sfb01 and tlf131,5 = asfi5 GROUP BY 1,2,3,4,5,6,7,8,9,10INTO TEMP tlf_temp WITH NO LOG计算过程：排序方式：UNIQUE ima57,ima01,ccd03,ima16 ima57 desc/ima16/ima01成本阶为99 ：1、ccc清零，取上期结存转本期期初2、由tlf 计算入出库数量，由apb101计算入库（采购）成本3、加上入库调整金额4、计算所有出库成本及结存5、更新ccc-file成本阶不为99：1、处理当前成本阶所有料件重工2、ccc清零，取上期结存转本期期初3、处理WIP在制成本4、由tlf 计算入出库数量，入库成本(外购料件)5、加上入库调整金额6、加上WIP入库金额7、计算所有出库成本及结存8、更新ccc-file处理重工
