SO_DailyShipment SO Daily Shipment Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_Shipping_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_DailyShipment.M4T"
KPRIMARY: InvoiceNo
KSHIPDATE: ShipDate+ShipVia+InvoiceNo
KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO_37$(1,7)}
2 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SO_37$(8,2)}
3 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{SO_37$(10,7)}
4 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_37$(17,7)}
5 ShipDate. . . . . . . . . . . 8 SNY Ship Date . . . . . . . . . . .DATE
Notes: {SO_37$(24,6)}
6 ShipVia . . . . . . . . . . . 15 SYY Ship Via. . . . . . . . . . . .SHIPCODE
Notes: {SO_37$(30,15)}
7 ShipperID . . . . . . . . . . 3 SYN Shipper ID. . . . . . . . . . .
Notes: {SO_37$(45,3)}
8 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
Mask:##,###,###.00- Notes:
{SO_37[0]}
9 InvoiceTotal. . . . . . . . . 13.2 NNN Invoice Total . . . . . . . . .
Mask:###,###,###.00 Notes:
{SO_37[1]}
10 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
11 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
12 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL