PO_OpenPurchaseOrderWrk PO Open Purchase Order Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_OpenPurchaseOrderReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_OpenPurchaseOrderWrk"+%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 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE 5 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . . 6 MasterRepeatingOrderNo. . . . 7 SNN Master Repeating Order Number . 7 RequiredExpireDate. . . . . . 8 SNN Required/Expire Date. . . . . .DATE 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 10 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 11 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 12 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 13 ShipToName. . . . . . . . . . 30 SNN ShipTo Name . . . . . . . . . . 14 OrderStatus . . . . . . . . . 1 SNN Order Status. . . . . . . . . . 15 OnHold. . . . . . . . . . . . 1 SNN On Hold . . . . . . . . . . . . 16 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 17 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 18 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 19 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 20 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE 21 LastInvoiceNo . . . . . . . . 10 SNN Last AP Invoice Number. . . . . 22 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 23 LastIssueDate . . . . . . . . 8 SNN Last Issue Date . . . . . . . .DATE 24 LastPurchaseOrderDate . . . . 8 SNN Last PO Date. . . . . . . . . .DATE 25 LastReceiptNo . . . . . . . . 7 SNN Last Receipt Number . . . . . . 26 LastIssueNo . . . . . . . . . 7 SNN Last Issue Number . . . . . . . 27 LastPurchaseOrderNo . . . . . 7 SNN Last PO Number. . . . . . . . . 28 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 29 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 30 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 31 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . . 32 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . . 33 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 34 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 35 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 36 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 37 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 38 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . . 39 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE 40 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 41 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 42 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 43 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 44 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 45 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 46 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 47 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 48 SubStepPrefix . . . . . . . . 1 SNN Sub-Step Prefix . . . . . . . . 49 SubStepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . 50 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 51 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 52 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 53 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 54 PrepaidAmt. . . . . . . . . . 13.2 NNN Prepaid Amount. . . . . . . . . 55 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 56 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . . 57 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 58 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 59 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 60 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 61 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 62 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . . 63 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . . 64 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To Date 65 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . . 66 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 67 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . . 68 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 69 InvoicedAmt . . . . . . . . . 12.2 NNN Invoiced Amount . . . . . . . . 70 UseTaxAmt . . . . . . . . . . 12.2 NNN Use Tax Amount. . . . . . . . . 71 TaxAmt. . . . . . . . . . . . 12.2 NNN Tax Amount. . . . . . . . . . .