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$