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$