SO_InvoiceTierDistribution SO Invoice Tier Distribution Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_InvoiceTierDistribution_bus,RA_GenerateTransactions_upd,BC_CommonImport
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceTierDistribution.M4T"
KPRIMARY: InvoiceNo+LineKey+LotSerialNo
KLOTSERIAL: LotSerialNo+TierType+InvoiceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO9$(1,7)}
2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SO9$(8,5)}
3 LotSerialNo . . . . . . . . . 15 SYY Lot Serial Number . . . . . . .LOTSERIALNO
Notes: {SO9$(13,15)}
4 TierType. . . . . . . . . . . 1 SYY Tier Type . . . . . . . . . . .
Valid:3,4 Notes: 3=Lot,
4=Serial {SO9$(28,1)}
5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
6 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
7 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {SO9[0]}
8 TierUnitCost. . . . . . . . . 16.6 NNN Tier Unit Cost. . . . . . . . .COST
Mask:##,###,###.000000-
Notes: (@ std U/M) {SO9[1]}
9 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000