替代料YWD1YWB=1YWD1YWC=2YWDxcck006xcck007xcck008xcck009xcck010xcck013xcck014xcck020异动单号项次项序出入库码料号异动日期异动时间CNJ-P71-201506010001111YWB6/1/201517:21101CNJ-P71-201506010001211YWC6/1/201517:21101CNJ-P71-201506010001311YWD6/1/201517:21101CNJ-P31-20150602000111-1YWB6/2/201518:16302CNJ-P31-20150602000121-1YWD6/2/201518:16302CNJ-P31-20150602000131-1YWC6/2/201518:16302CNJ-P31-20150602000141-1YWD6/2/201518:16302CNJ-Y34-201506030002111YWA6/3/201518:20110CNJ-P71-201506100001111YWB6/10/201518:23101CNJ-P71-201506100001111YWC6/10/201518:23101CNJ-P71-201506100001111YWD6/10/201518:23101CNJ-P31-20150611000111-1YWB6/11/201518:26302CNJ-P31-20150611000121-1YWD6/11/201518:26302CNJ-P31-20150611000131-1YWC6/11/201518:26302CNJ-P31-20150611000141-1YWD6/11/201518:26302CNJ-Y34-201506120001111YWA6/12/20159:33110xccu数量单价金额料件编号数量金额YWB200102000YWB2002000YWC200122400YWC2002400YWD200132600YWD2002600xccu数量单价金额料件编号数量金额YWB5010500YWB1501500YWD(YWB)5013650YWC1001200YWC100121200YWD50650YWD(YWC)100131300工单入库成本1710本期投入数本期投入成本已转出数已转出成本剩余数量剩余成本本笔转出数量YWB505000050500-50YWD(YWB)506500050650-10YWC1001200001001200-90YWD(YWC)10013000010013000xccu数量单价金额料件编号数量金额★移动加权+在制：库存异动类型杂收6/1杂收6/1发料6/250套发料6/2工单入库6/330套杂收6/10杂收6/10YWA(主件）YWBQPA:2YWCQPA:3YWB100121200YWB2502700YWC100151500YWC2002700YWD150203000YWD2003650xccu数量单价金额料件编号数量金额YWB6010.8648YWB1902052YWD(YWB)4018.25730YWC1201620YWC8013.51080YWD20365YWD(YWC)14018.252555工单入库成本4400.5本期投入数本期投入成本已转出数已转出成本剩余数量剩余成本本笔转出数量YWB1101148-50-50060648-60YWD(YWB)901380-10-130801250-40YWC1802280-90-1080901200-90YWD(YWC)2403855002403855-120xcck006xcck007xcck008xcck009xcck010xcck013xcck014xcck020异动单号项次项序出入库码料号异动日期异动时间CNJ-P71-201506010001111YWB6/1/201517:21101CNJ-P71-201506010001211YWC6/1/201517:21101CNJ-P71-201506010001311YWD6/1/201517:21101CNJ-P31-20150602000111-1YWB6/2/201518:16302CNJ-P31-20150602000121-1YWD6/2/201518:16302CNJ-P31-20150602000131-1YWC6/2/201518:16302CNJ-P31-20150602000141-1YWD6/2/201518:16302CNJ-Y34-201506030002111YWA6/3/201518:20110CNJ-P71-201506100001111YWB6/10/201518:23101CNJ-P71-201506100001111YWC6/10/201518:23101CNJ-P71-201506100001111YWD6/10/201518:23101CNJ-P31-20150611000111-1YWB6/11/201518:26302CNJ-P31-20150611000121-1YWD6/11/201518:26302CNJ-P31-20150611000131-1YWC6/11/201518:26302CNJ-P31-20150611000141-1YWD6/11/201518:26302CNJ-Y34-201506120001111YWA6/12/20159:33110黄色的部分总入库数量总入库金额平均单价YWB300320010.67YWC300390013YWD350560016绿色的部分主件入库数量入库成本6233.7紫色部分本期投入数本期投入成本本笔转出数量本笔转出成本结余数量结余成本YWB1101173.7-110-1173.700YWD(YWB)901440-50-80040640发料6/1150套发料6/11工单入库6/1250套★月加权+在制：库存异动类型(1)计算料件的月加权平均单价(2)计算出项的成本(3)计算在制在制投入套数100套80套YWC1802340-180-234000YWD(YWC)2403840-120-19201201920(4)xcccxccc006xccc211xccc212xccc280xccc301xccc302xccc901xccc902料号期末结存数量YWB300320010.67-110-1173.71902027.3YWC300390013-180-23401201560YWD350560016-330-528020320YWA806233.777.9200806233.6wip_del()若在制无期初，无投入，无转出，无结余时，则在制的资料删除6.wip_del()wip4_tmp1工单项次应发数量已入库数量SFBADOCNOSFBASEQSFBA013SFAA012QPAXCCD301QTYCNJ-P10-20150601000110200100.000000280160本期杂项入库数量本期杂项入库成本本期平均单价工单领用数量工单领用成本期末结存金额老TT时，在制的逻辑wip_1()主件处理1.g_xccd变量赋值（各数量为0）2.结转上期的期末资料至本期期初3.计算xccd200(本期投入工时）4.计算xccd201(本期投入套数)5.计算xccd301(主件的本期入库数量(考虑联产品比例）)6.将xccd插入TABLE中wip_2()本期投入1.wip_2_1()xcce上期资料结转至本期2.wip_2_2()材料投入3.wip_2_3()DL+OH+SUB投入4.wip_2_4()ADJUST投入wip_3()xccz处理为了替代料的缘故，在xcce的下面又设计了一个TABLE，用于明细记录替代料是具体替代哪个工单项次的(老TT没有这个）1.结转上期的xccz资料2.本期的发退料明细记录至xcczwip_4()下阶料转出1.下阶料按照主件入库数量*QPA的方式进行转出（特别注意有替代料时，同一工单项次下不同的项序视做一个量，进行总量匹配）2.人工制费按S-FIN-6014&axct200的设定进行转出3.加工费按入库套数与投入套数的比值进行转出4.工单结案时，按S-FIN-6008参数来决定未结转的部分是结转至工单入库上还是结转至工单差异上wip_5()下阶料投入汇总至主件1.SUM（xcce)更新至xccd中T100时的在制逻辑wip_part1(无视成本阶）1.wip_1()主件处理2.wip_2_1()xcce上期资料结转至本期3.wip_3()xccz处理4.wip_4_1()在制转出（仅数量）wip(考虑成本阶）1.wip_2_2()材料投入2.wip_2_3()DL+OH+SUB投入3.wip_2_4()ADJUST投入4.wip_4_2()在制转出（仅成本）5.wip_5()下阶料投入汇总至主件☉月加权在制转出效能版详细示列说明:按工单+项次为角度，计算下阶料的应转出数量生产主件数量对主件的QPA本次应转出总量CNJ-P10-20150601000120300100.000000380240wip4_tmp2工单项次项序成本域发料料号特征批次SFBADOCNOSFBASEQSFBASEQ1SEQ2XCCE002XCCE007XCCE008XCCE009CNJ-P10-2015060100011001YWBCNJ-P10-2015060100011012YWDCNJ-P10-2015060100012003YWCCNJ-P10-2015060100012014YWD工单项次项序成本域发料料号特征批次SFBADOCNOSFBASEQSFBASEQ1SEQ2XCCE002XCCE007XCCE008XCCE009CNJ-P10-2015060100011001YWBCNJ-P10-2015060100011012YWDCNJ-P10-2015060100012003YWCCNJ-P10-2015060100012014YWD工单项次项序成本域发料料号特征批次SFBADOCNOSFBASEQSFBASEQ1SEQ2XCCE002XCCE007XCCE008XCCE009CNJ-P10-2015060100011001YWBCNJ-P10-2015060100011012YWDCNJ-P10-2015060100012003YWCCNJ-P10-2015060100012014YWD工单项次项序成本域发料料号特征批次SFBADOCNOSFBASEQSFBASEQ1SEQ2XCCE002XCCE007XCCE008XCCE009CNJ-P10-2015060100011001YWBCNJ-P10-2015060100011012YWDCNJ-P10-2015060100012003YWCCNJ-P10-2015060100012014YWD工单项次项序成本域发料料号特征批次SFBADOCNOSFBASEQSFBASEQ1SEQ2XCCE002XCCE007XCCE008XCCE009CNJ-P10-2015060100011001YWBCNJ-P10-2015060100011012YWDCNJ-P10-2015060100012003YWCCNJ-P10-2015060100012014YWD按工单+项次+项序为角度，计算各细项的转出数量(1)明细发料量更新序号（用于计算累计已发量）(2)BY工单+项次，计算累计发料量序号（用于计算累计已发量）(3)参照wip4_tmp1中的应转出数量，若累计发料量小于应转出数量的行，则全部转出序号（用于计算累计已发量）(4)SUM（qty4)
