     SO_RecapByProductLineWhse          SO Recap By Product Line Warehouse Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd
     SQL Def: Y  SysDB: N                             "MAS_"+%C$+"/SO"+%C$+"/SO_RecapByProductLineWhse.M4T"

     KPRIMARY: ProductLine+WarehouseCode+Year+Period
     KYEARPRODLINE: Year+Period+ProductLine+WarehouseCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ProductLine . . . . . . . . .     4 SYY  Product Line. . . . . . . . . .PRODUCTLINE
       2  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
       3  Year. . . . . . . . . . . . .     4 SNY  Fiscal or Calendar. . . . . . .YEAR
                                                    Mask:0000
       4  Period. . . . . . . . . . . .     2 SNY  Fiscal or Calendar. . . . . . .FISCALPERIOD
                                                    Mask:00
       5  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
       6  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
       7  DollarsSold . . . . . . . . . 15.2  NNN  Dollars Sold. . . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
       8  CostOfGoodsSold . . . . . . . 15.2  NNN  Cost Of Goods Sold. . . . . . .AMOUNT
                                                    Mask:###,###,###.00
       9  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
      10  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
      11  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .