AR_InvoiceHistoryTracking AR Invoice History Tracking Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryTracking.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: SO_SalesJournal_upd AR_InvoiceHistoryTracking_bus
KPRIMARY: InvoiceNo+HeaderSeqNo+PackageNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR_19$(1,7)} 2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {AR_19$(8,3)} 3 PackageNo . . . . . . . . . . 4 SNY Package Number. . . . . . . . . Mask:0000 FmtType:ZEROFILL Notes: {AR_19$(11,4)} 4 TrackingID. . . . . . . . . . 30 SNN Tracking ID . . . . . . . . . . Notes: {AR_19$(15,30)} 5 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {AR_19$(45,30)} 6 StarshipShipVia . . . . . . . 15 SYN Starship Ship Via . . . . . . .SHIPCODE Notes: {AR_19$(81,15)} 7 UpdatedFromStarship . . . . . 1 SYN Updated From Starship . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR_19$(96,1)} 8 SendPackageToStarship . . . . 1 SYN Send Package to Starship. . . .YESNO DfltVal:N Valid:Y,N Notes: {AR_19$(97,1)} 9 Weight. . . . . . . . . . . . 13.2 NNN Weight. . . . . . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {AR_19[0]} 10 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {AR_19[1]} 11 FreightAmtAddedToInv. . . . . 12.2 NNN Freight Amount Added to InvoiceMISCAMOUNT Mask:##,###,###.00- Notes: {AR_19[2]}