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-