SO_RecapByWarehouse SO Recap By Warehouse Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_RecapByWarehouse.M4T"
KPRIMARY: WarehouseCode+Year+Period
KYEARWHSE: Year+Period+WarehouseCode
Fld Column Name M/L TUR Description/Notes Class
1 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
2 Year. . . . . . . . . . . . . 4 SNY Fiscal or Calendar. . . . . . .YEAR
Mask:0000
3 Period. . . . . . . . . . . . 2 SNY Fiscal or Calendar. . . . . . .FISCALPERIOD
Mask:00
4 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
5 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY
Mask:##,###,###.000000-
6 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . .AMOUNT
Mask:###,###,###.00
7 CostOfGoodsSold . . . . . . . 15.2 NNN Cost Of Goods Sold. . . . . . .AMOUNT
Mask:###,###,###.00
8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
10 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .