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