     SO_SalesHistory                        SO Sales History               Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd,SO_SalesHistory_bus
     SQL Def: Y  SysDB: N                                       "MAS_"+%C$+"/SO"+%C$+"/SO_SalesHistory.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+ItemType+ProductLine+WarehouseCode+PostingDate+InvoiceDate
     KITEM: ItemCode
     KPRODUCTLINE: ProductLine
     KWAREHOUSE: WarehouseCode
     KWHSEITEM: WarehouseCode+ItemCode
     KWHSEPRODLINE: WarehouseCode+ProductLine
     KTRANSDATE: InvoiceDate
     KPOSTINGDATE: PostingDate
     KITEMPLWHSE: ItemCode+ProductLine+WarehouseCode
     KPRODLNWHSE: ProductLine+WarehouseCode
     KITEMTYPE: ItemType
     KCUSTOMER: ARDivisionNo+CustomerNo
     KDIVISION: ARDivisionNo
     KCUSTPRODLINE: ARDivisionNo+CustomerNo+ProductLine

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
       2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$
       3  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0
       4  ItemType. . . . . . . . . . .     1 SNY  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,4,5 Notes:
                                                    1=Regular Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item
       5  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    FmtType:CHARNUM
       6  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
       7  PostingDate . . . . . . . . .     8 SNN  Posting Date. . . . . . . . . .DATE
       8  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
       9  DollarsSold . . . . . . . . . 15.2  NNN  Dollars Sold. . . . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ChngTag:Sum
      10  CostOfGoodsSold . . . . . . . 15.2  NNN  Cost Of Goods Sold. . . . . . .AMOUNT
                                                    Mask:##,###,###,###.00
                                                    ChngTag:Sum
      11  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ChngTag:Sum
      12  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ChngTag:Sum
      13  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      14  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      15  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Max/DateUpdated$