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 . . . . . .