PO_OpenOrdersByWorkOrderWrk PO Open Orders By Work Order WorkRel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_OpenOrdersByWOReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_OpenOrdersByWorkOrderWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 3 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 4 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 5 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 6 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 7 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 8 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE 9 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 10 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 11 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 12 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 13 ItemBillDesc. . . . . . . . . 30 SNN Item/Bill Description . . . . . 14 StandardUnitOfMeasure . . . . 4 SNN Standard Unit of Measure. . . . 15 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 16 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE 17 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . . 18 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 19 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 20 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 21 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 22 ShipToName. . . . . . . . . . 30 SNN ShipTo Name . . . . . . . . . . 23 OrderStatus . . . . . . . . . 1 SNN Order Status. . . . . . . . . . 24 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 25 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 26 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 27 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . . 28 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . . 29 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . . 30 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To Date 31 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 32 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 33 InvoicedAmt . . . . . . . . . 12.2 NNN Invoiced Amount . . . . . . . . 34 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion Fact