SO_SalesDailyRecapWork SO Sales Daily Recap Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesDailyRecapWork"+%S$+".M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+ItemType+ProductLine+WarehouseCode KITEM: ItemCode KPRODUCTLINE: ProductLine KWAREHOUSE: WarehouseCode KWHSEITEM: WarehouseCode+ItemCode KWHSEPRODLINE: WarehouseCode+ProductLine KITEMTYPE: ItemType KCUSTOMER: ARDivisionNo+CustomerNo KDIVISION: ARDivisionNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 2 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC 3 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE 4 ItemType. . . . . . . . . . . 1 SNY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 5 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM 6 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 7 SalesAmt. . . . . . . . . . . 13.2 NNN Sales Amount. . . . . . . . . . Mask:###,###,###.00- 8 CostOfGoodsSoldAmt. . . . . . 13.2 NNN Cost of Goods Sold Amount . . .AMOUNT Mask:###,###,###.00 9 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- 10 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- 11 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000-