BM_TierCostCalcWork BM Tier Cost Calculation Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: N SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_TierCostCalcWork"+%S$+".M4T"
KPRIMARY: ComponentItemCode+WarehouseCode+TierType+ReceiptDate+ReceiptNo
KINVERSEDATE: ComponentItemCode+WarehouseCode+TierType+ReceiptDate(d)+ReceiptNo
Fld Column Name M/L TUR Description/Notes Class
1 ComponentItemCode . . . . . . 30 SYY Component Item Code . . . . . .ITEM
FmtType:ALPHANUM DepVal:REQUI
RED Notes: {BMD$(1,15)}
2 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {BMD$(21,3)}
3 TierType. . . . . . . . . . . 1 SYY Tier Type . . . . . . . . . . .
Notes: Costing Record
{BMD$(24,1)}
4 ReceiptDate . . . . . . . . . 8 SNY Receipt Date. . . . . . . . . .DATE
Notes: From {IM3$(43,6)}
5 ReceiptNo . . . . . . . . . . 8 SYY Receipt Number. . . . . . . . .
FmtType:CHARNUM Notes:
{BMD(31,8)}
6 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {BMD[0]}
7 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {BMD[1]}
8 QuantityCommitted . . . . . . 16.6 NNN Quantity Committed. . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {BMD[2]}