PO_ReturnOrderWrk PO Return Order Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReturnOrderPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReturnOrderWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 ReturnType. . . . . . . . . . 1 SNN Return Type . . . . . . . . . . 3 ReturnNo. . . . . . . . . . . 6 SNN Return Number . . . . . . . . . 4 ReturnDate. . . . . . . . . . 8 SNN Return Date . . . . . . . . . .DATE 5 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 7 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 8 VendorTelephoneNo . . . . . . 17 SNN Vendor Telephone Number . . . . 9 VendorFaxNo . . . . . . . . . 17 SNN Vendor Fax Number . . . . . . . 10 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 11 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . . 12 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . . 13 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . . 14 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . . 15 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . . 16 PurchaseZipCode . . . . . . . 10 SNN Purchase Zip Code . . . . . . . 17 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . . 18 PurchaseCountryName . . . . . 30 SNN Purchase Country Name . . . . . 19 PurchaseAddressCode . . . . . 4 SNN Purchase Address Code . . . . . 20 ShipToCode. . . . . . . . . . 4 SNN Ship To Code. . . . . . . . . . 21 ShipToName. . . . . . . . . . 30 SNN ShipTo Name . . . . . . . . . . 22 ShipToAddress1. . . . . . . . 30 SNN ShipTo Address 1. . . . . . . . 23 ShipToAddress2. . . . . . . . 30 SNN ShipTo Address 2. . . . . . . . 24 ShipToAddress3. . . . . . . . 30 SNN ShipTo Address 3. . . . . . . . 25 ShipToCity. . . . . . . . . . 20 SNN ShipTo City . . . . . . . . . . 26 ShipToState . . . . . . . . . 2 SNN ShipTo State. . . . . . . . . . 27 ShipToZipCode . . . . . . . . 10 SNN ShipTo Zip Code . . . . . . . . 28 ShipToCountryCode . . . . . . 3 SNN ShipTo Country Code . . . . . . 29 ShipToCountryName . . . . . . 30 SNN ShipTo Country Name . . . . . . 30 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE 31 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 32 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . 33 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 34 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 35 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 36 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 37 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 38 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . . 39 ReturnAuthorizationNo . . . . 15 SNN Return Authorization Number . . 40 ReturnedDepRef. . . . . . . . 6 SNN Returned Deposit Reference. . . 41 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . . 42 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 43 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 44 ExemptionNo1. . . . . . . . . 20 SNN Exemption Number 1. . . . . . . 45 ExemptionNo2. . . . . . . . . 20 SNN Exemption Number 2. . . . . . . 46 ExemptionNo3. . . . . . . . . 20 SNN Exemption Number 3. . . . . . . 47 ExemptionNo4. . . . . . . . . 20 SNN Exemption Number 4. . . . . . . 48 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 49 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 50 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 51 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 52 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 53 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 54 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . . 55 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . . 56 LineRequiredDate. . . . . . . 8 SNN Line Required Date. . . . . . .DATE 57 ReturnsAcctKey. . . . . . . . 9 SNN Returns Account Key . . . . . . 58 ReturnsAccount. . . . . . . . 41 SNN Fully Formatted Returns Account 59 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 60 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 61 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 62 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 63 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 64 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 65 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 66 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 67 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 68 SubStepPrefix . . . . . . . . 1 SNN Sub-Step Prefix . . . . . . . . 69 SubStepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . 70 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 71 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 72 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 73 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 74 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 75 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . . 76 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 77 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 78 PLPrint . . . . . . . . . . . 1 SNN Paperless Office Print Vendor . 79 PLEmail . . . . . . . . . . . 1 SNN Paperless Office E-Mail Vendor. 80 PLFax . . . . . . . . . . . . 1 SNN Paperless Office Fax Vendor . . 81 PLPDF . . . . . . . . . . . . 1 SNN Paperless Office Create PDF . . 82 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . . 83 ReturnedDepositAmt. . . . . . 13.2 NNN Returned Deposit Amount . . . . 84 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 85 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . . 86 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 87 TaxAmt1 . . . . . . . . . . . 12.2 NNN Tax Amount 1. . . . . . . . . . 88 TaxAmt2 . . . . . . . . . . . 12.2 NNN Tax Amount 2. . . . . . . . . . 89 TaxAmt3 . . . . . . . . . . . 12.2 NNN Tax Amount 3. . . . . . . . . . 90 TaxAmt4 . . . . . . . . . . . 12.2 NNN Tax Amount 4. . . . . . . . . . 91 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 92 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . . 93 TotalMiscChargeAmt. . . . . . 13.2 NNN Total Miscellaneous Charge Amou 94 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . . 95 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 96 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 97 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . . 98 OriginalQtyOrdered. . . . . . 16.6 NNN Original Quantity Ordered . . . 99 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 100 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 101 LotSerialQuantityReturned . . 16.6 NNN Lot Serial Quantity Returned. .