SO_LotSerialHistory SO Lot/Serial History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd,SO_LotSerialHistory_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_LotSerialHistory.M4T"
KPRIMARY: ItemCode+LotSerialNo+ARDivisionNo+CustomerNo+InvoiceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{SOE$(1,15)}
2 LotSerialNo . . . . . . . . . 15 SYY Lot Serial Number . . . . . . .LOTSERIALNO
Notes: {SOE$(21,15)}
3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {SOE$(36,2)}
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{SOE$(38,7)}
5 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SOE$(45,7)}
6 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {SOE$(52,5)}
7 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .
Notes: {SOE$(57,30)}
8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
Notes: {SOE$(87,6)}
9 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {SOE$(93,4)}
10 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
ChngTag:Sum Notes: {SOE[0]}
11 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
12 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
13 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL