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