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-