SO_InvoiceTracking SO Invoice Tracking Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/SO"+%C$+"/SO_InvoiceTracking.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: SO_InvoiceTracking_bus
KPRIMARY: InvoiceNo+PackageNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {SO_19$(1,7)} 2 PackageNo . . . . . . . . . . 4 SNY Package Number. . . . . . . . . Mask:0000 FmtType:ZEROFILL Notes: {SO_19$(8,4)} 3 TrackingID. . . . . . . . . . 30 SNN Tracking ID . . . . . . . . . . Notes: {SO_19$(12,30)} 4 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {SO_19$(42,30)} 5 StarshipShipVia . . . . . . . 15 SYN Starship Ship Via . . . . . . .SHIPCODE Notes: {SO_19$(78,15)} 6 UpdatedFromStarship . . . . . 1 SYN Updated From Starship . . . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_19$(93,1)} 7 SendPackageToStarship . . . . 1 SYN Send Package to Starship. . . .YESNO DfltVal:N Valid:Y,N Notes: {SO_19$(94,1)} 8 Weight. . . . . . . . . . . . 13.2 NNN Weight. . . . . . . . . . . . . Mask:###,###,###.00- Notes: {SO_19[0]} 9 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . Mask:##,###,###.00- Notes: {SO_19[1]} 10 FreightAmtAddedToInv. . . . . 12.2 NNN Freight Amount Added to Invoice Mask:##,###,###.00- Notes: {SO_19[2]}