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]}