     SO_SalesDailyRecapWork                SO Sales Daily Recap Work       Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                         "MAS_"+%C$+"/SO"+%C$+"/SO_SalesDailyRecapWork"+%S$+".M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+ItemType+ProductLine+WarehouseCode
     KITEM: ItemCode
     KPRODUCTLINE: ProductLine
     KWAREHOUSE: WarehouseCode
     KWHSEITEM: WarehouseCode+ItemCode
     KWHSEPRODLINE: WarehouseCode+ProductLine
     KITEMTYPE: ItemType
     KCUSTOMER: ARDivisionNo+CustomerNo
     KDIVISION: ARDivisionNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
       2  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC
       3  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
       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  SalesAmt. . . . . . . . . . . 13.2  NNN  Sales Amount. . . . . . . . . .
                                                    Mask:###,###,###.00-
       8  CostOfGoodsSoldAmt. . . . . . 13.2  NNN  Cost of Goods Sold Amount . . .AMOUNT
                                                    Mask:###,###,###.00
       9  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      10  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      11  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-