RA_CustomerRMAWrk RA Customer RMA Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_CustomerRMAPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_CustomerRMAWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 3 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE 4 ExpireDate. . . . . . . . . . 8 SNN Expire Date . . . . . . . . . .DATE 5 ReturnShipVia . . . . . . . . 15 SNN Return Ship Via . . . . . . . . 6 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 7 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 8 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . . 9 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 12 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 13 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 14 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . . 15 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . . 16 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . . 17 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . . 18 BillToState . . . . . . . . . 2 SNN Bill To State . . . . . . . . . 19 BillToZipCode . . . . . . . . 10 SNN Bill To Zip Code. . . . . . . . 20 BillToCountryCode . . . . . . 3 SNN Bill To Country Code. . . . . . 21 BillToCountryName . . . . . . 30 SNN Bill To Country Name. . . . . . 22 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 23 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 24 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 25 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 26 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 27 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 28 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 29 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 30 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 31 ReturnToName. . . . . . . . . 30 SNN Return To Name. . . . . . . . . 32 ReturnToAddress1. . . . . . . 30 SNN Return To Address 1 . . . . . . 33 ReturnToAddress2. . . . . . . 30 SNN Return To Address 2 . . . . . . 34 ReturnToAddress3. . . . . . . 30 SNN Return To Address 3 . . . . . . 35 ReturnToCity. . . . . . . . . 20 SNN Return To City. . . . . . . . . 36 ReturnToState . . . . . . . . 2 SNN Return To State . . . . . . . . 37 ReturnToZipCode . . . . . . . 10 SNN Return To Zip Code. . . . . . . 38 ReturnToCountryCode . . . . . 3 SNN Return To Country Code. . . . . 39 ReturnToCountryName . . . . . 30 SNN Return To Country Name. . . . . 40 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 41 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 42 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 43 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 44 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . 45 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 46 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 47 AliasItemNo . . . . . . . . . 30 SNN Alias Item Number . . . . . . . 48 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 49 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 50 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . . 51 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 52 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 53 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 54 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 55 ReturnReasonCode. . . . . . . 10 SNN Return Reason Code. . . . . . . 56 CustomerAction. . . . . . . . 1 SNN Customer Action . . . . . . . . 57 ItemAction. . . . . . . . . . 1 SNN Item Action . . . . . . . . . . 58 CrossShip . . . . . . . . . . 1 SNN Cross Ship. . . . . . . . . . . 59 DropShip. . . . . . . . . . . 1 SNN Drop Ship . . . . . . . . . . . 60 WarrantyCode. . . . . . . . . 10 SNN WarrantyCode. . . . . . . . . . 61 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE 62 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 63 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 64 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 65 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 66 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost Of Goods Sold Account Key. 67 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost Of Goods S 68 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 69 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Account N 70 HistoryCOGSAcctKey. . . . . . 9 SNN History Cost Of Goods Sold Acct 71 HistoryCOGSAccount. . . . . . 41 SNN Fully Formatted History Cost Of 72 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 73 VendorRMANo . . . . . . . . . 10 SNN Vendor RMA Number . . . . . . . 74 ReplacementItemCode . . . . . 30 SNN Replacement Item Code . . . . . 75 ReplacementItemType . . . . . 1 SNN Replacement Item Type . . . . . 76 ReplacementItemCodeDesc . . . 30 SNN Replacement Item Code Descripti 77 ReplacementRevision . . . . . 3 SNN Replacement Bill Revision Code. 78 ReplacementRepairBillOption1. 2 SNN Replacement Repair Bill Option 79 ReplacementOption1Desc. . . . 30 SNN Replacement Option 1 Descriptio 80 ReplacementRepairBillOption2. 2 SNN Replacement Repair Bill Option 81 ReplacementOption2Desc. . . . 30 SNN Replacement Option 2 Descriptio 82 ReplacementRepairBillOption3. 2 SNN Replacement Repair Bill Option 83 ReplacementOption3Desc. . . . 30 SNN Replacement Option 3 Descriptio 84 ReplacementRepairBillOption4. 2 SNN Replacement Repair Bill Option 85 ReplacementOption4Desc. . . . 30 SNN Replacement Option 4 Descriptio 86 ReplacementRepairBillOption5. 2 SNN Replacement Repair Bill Option 87 ReplacementOption5Desc. . . . 30 SNN Replacement Option 5 Descriptio 88 ReplacementRepairBillOption6. 2 SNN Replacement Repair Bill Option 89 ReplacementOption6Desc. . . . 30 SNN Replacement Option 6 Descriptio 90 ReplacementRepairBillOption7. 2 SNN Replacement Repair Bill Option 91 ReplacementOption7Desc. . . . 30 SNN Replacement Option 7 Descriptio 92 ReplacementRepairBillOption8. 2 SNN Replacement Repair Bill Option 93 ReplacementOption8Desc. . . . 30 SNN Replacement Option 8 Descriptio 94 ReplacementRepairBillOption9. 2 SNN Replacement Repair Bill Option 95 ReplacementOption9Desc. . . . 30 SNN Replacement Option 9 Descriptio 96 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 97 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 98 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 99 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . . 100 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . . 101 BatchFax. . . . . . . . . . . 1 SYN BatchFax. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 102 PLPrint . . . . . . . . . . . 1 SYN Paperless Office Print CustomerYESNO DfltVal:N Valid:Y,N 103 PLEmail . . . . . . . . . . . 1 SYN Paperless Office E-Mail CustomeYESNO DfltVal:N Valid:Y,N 104 PLFax . . . . . . . . . . . . 1 SYN Paperless Office Fax Customer .YESNO DfltVal:N Valid:Y,N 105 PLPDF . . . . . . . . . . . . 1 SYN Paperless Office Create PDF . .YESNO DfltVal:N Valid:Y,N 106 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . . 107 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 108 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . . 109 LotSerialQuantityReturned . . 16.6 NNN Lot Serial Quantity Returned. . 110 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . . 111 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 112 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . .