     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$