SO_DailyBackOrderRecapWrk SO Daily Back Order 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_DailyBackOrderRecapWrk"+%S$+".M4T"
KPRIMARY: ProductLine+ItemCode+InvoiceNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . .PRODUCTLINE 2 ProductLineDesc . . . . . . . 30 SNN Product Line Description. . . . 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE FmtType:CHARNUM 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Description. . . . . . . .DESCRIPTION 5 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 6 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . 7 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 8 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 9 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 10 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 11 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO 12 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 13 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 14 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 15 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE 16 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- 17 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- 18 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000-