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