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-