PO_ReturnMatRqTierCostCalcWork PO Return Material Req Tier Cost CalRel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReturnMatRqTierCostCalcWork.M4T"
KPRIMARY: ItemCode+WarehouseCode+TierType+ReceiptDate+ReceiptNo
KINVERSE: ItemCode+WarehouseCode+TierType+ReceiptDate(d)+ReceiptNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
Notes: {POK$(1,15)}
2 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{POK$(21,3)}
3 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . .
Valid:1,2 Notes: {POK$(24,
1)}1=Fifo, 2=Lifo
4 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
Notes: {POK$(25,6)}
5 ReceiptNo . . . . . . . . . . 7 SYN Receipt Number. . . . . . . . .RECEIPTNO
Mask:0000000 Notes: {POK$(31,
8)}
6 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {POK[0]}
7 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {POK[1]}
8 QuantityCommitted . . . . . . 16.6 NNN Quantity Committed. . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {POK[2]}