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