SO_SalesDailyRecapWrk SO Sales Daily Recap Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_SalesJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesDailyRecapWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 15 SNN Group Field . . . . . . . . . .
3 GroupFieldDesc. . . . . . . . 75 SNN Group Field Description . . . .
4 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
5 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . .DESCRIPTION
Notes: {ARB$(3,30)}
6 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .
8 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . .
Notes: {AR1$(281,4)}
9 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . .
Notes: {AR1$(285,1)}
10 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
FmtType:CHARNUM
11 ItemCodeDesc. . . . . . . . . 30 SNN Item Description. . . . . . . .DESCRIPTION
12 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
13 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:ALPHANUM
14 ProductLineDesc . . . . . . . 25 SNN Description . . . . . . . . . .
15 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
16 WarehouseDesc . . . . . . . . 30 SNN Description . . . . . . . . . .
17 SalesAmt. . . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . .
Mask:##,###,###,###.00-
18 CostOfGoodsSoldAmt. . . . . . 13.2 NNN Cost Of Goods Sold Amount . . .AMOUNT
Mask:###,###,###.00
19 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
20 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE
Mask:##,###,###.000000-
21 GrossProfit . . . . . . . . . 13.2 NNN Gross Profit. . . . . . . . . .AMOUNT
Mask:###,###,###.00
22 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY
Mask:##,###,###.000000-
23 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY
Mask:##,###,###.000000-
24 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY
Mask:##,###,###.000000-
25 QuantityShippedPTD. . . . . . 16.6 NNN Quantity Shipped Period To DateQUANTITY
Mask:##,###,###.000000-
26 SalesAmtPTD . . . . . . . . . 13.2 NNN Sales Amount Period To Date . .AMOUNT
Mask:###,###,###.00
27 ProfitPTD . . . . . . . . . . 13.2 NNN Profit Period To Date . . . . .AMOUNT
Mask:###,###,###.00
28 QuantityShippedYTD. . . . . . 16.6 NNN Quantity Shipped Year To Date .QUANTITY
Mask:##,###,###.000000-
29 SalesAmtYTD . . . . . . . . . 13.2 NNN Sales Amount Year To Date . . .AMOUNT
Mask:###,###,###.00
30 ProfitYTD . . . . . . . . . . 13.2 NNN Profit Year To Date . . . . . .AMOUNT
Mask:###,###,###.00