SO_RecapByDivision SO Recap By Division Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_RecapByDivision.M4T"
KPRIMARY: ARDivisionNo+Year+Period
KYEARDIVISION: Year+Period+ARDivisionNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SYY AR Division Number. . . . . . .ARDIVISION
Mask:00
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 . . . . . .