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