SO_LastPurchaseHistory SO Last Purchase History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_CustomerLastPurchase_bus SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_LastPurchaseHistory.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+DocumentType
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {SOQ$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {SOQ$(3,7)} 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {SOQ$(10,15)} 4 DocumentType. . . . . . . . . 1 SYY Document Type . . . . . . . . . Valid:Q,O,I Notes: Q=Quote, O=Order, I=Invoice {SOQ$(25, 1)} 5 LastPurchaseDate. . . . . . . 8 SNN Last Purchase Date. . . . . . .DATE ChngTag:Max Notes: {SOQ$(26, 6)} 6 LastPurchaseQty . . . . . . . 16.6 NNN Last Purchase Quantity. . . . .QUANTITY Mask:##,###,###.000000- ChngTag:CopyMax/LastPurchaseD ate$ Notes: {SOQ[0]} 7 LastUnitPrice . . . . . . . . 16.6 NNN Last Unit Price . . . . . . . .PRICE Mask:##,###,###.000000- ChngTag:CopyMax/LastPurchaseD ate$ Notes: {SOQ[1]} 8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 10 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$