PO_PurchaseOrderWrk PO Purchase Order Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_PurchaseOrderPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_PurchaseOrderWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 9 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 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 10 VendorTelephoneNo . . . . . . 17 SNN Vendor Telephone Number . . . . 11 VendorFaxNo . . . . . . . . . 17 SNN Vendor Fax Number . . . . . . . 12 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 13 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . . 14 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . . 15 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . . 16 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . . 17 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . . 18 PurchaseZipCode . . . . . . . 10 SNN Purchase Zip Code . . . . . . . 19 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . . 20 PurchaseCountryName . . . . . 30 SNN Purchase Country Name . . . . . 21 PurchaseAddressCode . . . . . 4 SNN Purchase Address Code . . . . . 22 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 23 ShipToName. . . . . . . . . . 30 SNN ShipTo Name . . . . . . . . . . 24 ShipToAddress1. . . . . . . . 30 SNN ShipTo Address 1. . . . . . . . 25 ShipToAddress2. . . . . . . . 30 SNN ShipTo Address 2. . . . . . . . 26 ShipToAddress3. . . . . . . . 30 SNN ShipTo Address 3. . . . . . . . 27 ShipToCity. . . . . . . . . . 20 SNN ShipTo City . . . . . . . . . . 28 ShipToState . . . . . . . . . 2 SNN ShipTo State. . . . . . . . . . 29 ShipToZipCode . . . . . . . . 10 SNN ShipTo Zip Code . . . . . . . . 30 ShipToCountryCode . . . . . . 3 SNN ShipTo Country Code . . . . . . 31 ShipToCountryName . . . . . . 30 SNN ShipTo Country Name . . . . . . 32 OrderStatus . . . . . . . . . 1 SNN Order Status. . . . . . . . . . 33 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 34 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . 35 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 37 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number If Drop Ship 38 CustomerNo. . . . . . . . . . 20 SNN Customer Number If Drop Ship P/ 39 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 40 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 41 PrepaidCheckNo. . . . . . . . 10 SNN Prepaid Check Number. . . . . . 42 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 43 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 44 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 45 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 46 RequisitorName. . . . . . . . 30 SNN Requisitor Name . . . . . . . . 47 RequisitorDepartment. . . . . 30 SNN Requisitor Department . . . . . 48 ExemptionNo1. . . . . . . . . 20 SNN Exemption Number 1. . . . . . . 49 ExemptionNo2. . . . . . . . . 20 SNN Exemption Number 2. . . . . . . 50 ExemptionNo3. . . . . . . . . 20 SNN Exemption Number 3. . . . . . . 51 ExemptionNo4. . . . . . . . . 20 SNN Exemption Number 4. . . . . . . 52 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 53 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 54 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 55 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 56 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 57 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 58 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . . 59 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . . 60 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE 61 PurchasesAcctKey. . . . . . . 9 SNN Purchases Account Key . . . . . 62 PurchasesAccount. . . . . . . 41 SNN Fully Formatted Purchases Accou 63 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 64 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 65 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 66 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 67 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 68 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 69 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 70 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 71 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 72 SubStepPrefix . . . . . . . . 1 SNN Sub-Step Prefix . . . . . . . . 73 SubStepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . 74 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 75 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 76 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 77 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 78 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 79 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 80 PLPrint . . . . . . . . . . . 1 SNN Paperless Office Print Vendor . 81 PLEmail . . . . . . . . . . . 1 SNN Paperless Office E-Mail Vendor. 82 PLFax . . . . . . . . . . . . 1 SNN Paperless Office Fax Vendor . . 83 PLPDF . . . . . . . . . . . . 1 SNN Paperless Office Create PDF . . 84 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . . 85 PrepaidAmt. . . . . . . . . . 13.2 NNN Prepaid Amount. . . . . . . . . 86 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 87 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . . 88 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 89 TaxAmt1 . . . . . . . . . . . 12.2 NNN Tax Amount 1. . . . . . . . . . 90 TaxAmt2 . . . . . . . . . . . 12.2 NNN Tax Amount 2. . . . . . . . . . 91 TaxAmt3 . . . . . . . . . . . 12.2 NNN Tax Amount 3. . . . . . . . . . 92 TaxAmt4 . . . . . . . . . . . 12.2 NNN Tax Amount 4. . . . . . . . . . 93 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 94 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . . 95 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . . 96 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 97 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 98 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 99 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . . 100 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . . 101 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To Date 102 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 103 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .