SO_PackageTrackingByItem SO Package Tracking by Item Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_PackageTrackingByItem_bus SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_PackageTrackingByItem.M4T"
KPRIMARY: InvoiceNo+PackageNo+ItemCode KITEM: InvoiceNo+ItemCode+PackageNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {SO_36$(1,7)} 2 PackageNo . . . . . . . . . . 4 SNY Package Number. . . . . . . . . Mask:0000 FmtType:ZEROFILL Notes: {SO_36$(8,4)} 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {SO_36$(12,15)} 4 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,5 Notes: 1=Inventor y Item, 2=Special Item, 5=Miscellaneous Item 5 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {SO_36$(28,30)} 6 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . Notes: {SO_36$(58,30)} 7 Quantity. . . . . . . . . . . 16.6 NNN Quantity. . . . . . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {SO_36[0]}