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