RA_ReturnDetail RA Return Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_ReturnDetail_bus,RA_GenerateTransactions_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReturnDetail.M4T"
KPRIMARY: RMANo+LineKey KDISPLAY: RMANo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+RMANo+LineKey KITEM: ItemCode+WarehouseCode+RMANo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYY RMA Number. . . . . . . . . . .RMANO Read Only:Y FmtType:CHARNUM 2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 4 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM DepVal:REQU IRED 5 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL 6 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL 7 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE DepVal:REQUIRED ChngTag:Repla ce0 8 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION ValGroup:ItemRequired 10 ExtendedDescriptionKey. . . . 10 SYN Extended Description Key. . . .EXTDESCKEY Read Only:Y DfltVal:000000000 0 ValGroup:ItemRequired, NotComment,ItemTypes 11 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE 12 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . DfltVal:N Valid:N,C,P,R ValGroup:NotComment Notes: N=None, C=Credit, P=rePlaceme nt, R=Repair 13 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . DfltVal:N Valid:N,S,P,R ValGroup:NotComment Notes: N=None, S=Stock, P=scraP, R=Repair 14 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM ValGroup:IMIn tegrated,ItemRequired, NotComment,MultiWarehouse, RegularItem 15 VendorAction. . . . . . . . . 1 SYN Vendor Action . . . . . . . . . DfltVal:N Valid:C,P,N ValGroup:POIntegrated, ItemRequired,NotComment, RegularItem Notes: C=Credit, P=rePlacement, N=None 16 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL ValGroup:POIntegrated, VendorActionRequired 17 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ValGroup:PO Integrated,VendorActionRequir ed ChngTag:Replace1/APDivisio nNo$ 18 ReplacementItemCode . . . . . 30 SYN Replacement Item Code . . . . .ITEMCODE ValGroup:ReplacementRequired ChngTag:Replace0 19 ReplacementItemType . . . . . 1 SYN Replacement Item Type . . . . . Valid:1,2,3,4,5 ValGroup:Repl acementRequired Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 20 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:ItemRequired, ItemTypes 21 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ItemTypes 22 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 23 CreditFreight . . . . . . . . 1 SYN Credit Freight. . . . . . . . .YESNO DfltVal:N Valid:Y,N 24 XpressSOCreated . . . . . . . 1 SYN Xpress SO Created . . . . . . .YESNO DfltVal:N Valid:Y,N 25 AliasItemNo . . . . . . . . . 30 SYN Alias Item Number . . . . . . . ValGroup:ItemRequired, ItemTypes 26 WarrantyCode. . . . . . . . . 10 SYN Warranty Code . . . . . . . . .WARRANTYCODE DepVal:REQUIRED ValGroup:Item Required,RegularItem, WarrantyTracking 27 ExpirationDate. . . . . . . . 8 SNN Expiration Date . . . . . . . .DATE ValGroup:ItemRequired, RegularItem,WarrantyTracking 28 ExpirationDateOverridden. . . 1 SYN Expiration Date Overridden. . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 29 CostOverridden. . . . . . . . 1 SYN SO Cost Overridden. . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 30 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.ACCOUNT ValGroup:ItemRequired, ItemTypes 31 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .ACCOUNT ValGroup:NotComment, ItemRequired,ItemTypes 32 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . Mask:000000 FmtType:ZEROFILL 33 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . . DfltVal:N Valid:Y,N,C ValGroup:NotComment Notes: Y=Yes, N=No,C=Component 34 StandardKitBill . . . . . . . 1 SYN Standard/Kit Bill . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 35 Revision. . . . . . . . . . . 3 SNN Bill Revision Code. . . . . . . 36 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 37 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 38 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 39 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 40 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 41 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 42 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 43 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 44 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,ItemRequired, RegularItem 45 BackorderKitCompLines . . . . 1 SYN Backorder Kit Component Lines .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: Kit Bckord=0, Comp Bckord>0, Flg=Y 46 ApplyCommentsToAll. . . . . . 1 SYN Apply Comments to All . . . . .YESNO DfltVal:N Valid:Y,N 47 ApplyToCustomerRMA. . . . . . 1 SYN Apply to Customer RMA . . . . .YESNO DfltVal:N Valid:Y,N 48 ApplyToRMAReceiver. . . . . . 1 SYN Apply to RMA Receiver . . . . .YESNO DfltVal:N Valid:Y,N 49 ApplyToSalesOrder . . . . . . 1 SYN Apply to Sales Order. . . . . .YESNO DfltVal:N Valid:Y,N 50 ApplyToCreditMemo . . . . . . 1 SYN Apply to Credit Memo. . . . . .YESNO DfltVal:N Valid:Y,N 51 VendorRMANo . . . . . . . . . 10 SYN Vendor RMA Number . . . . . . . FmtType:CHARNUM ValGroup:POIn tegrated 52 InvoiceNotOnFile. . . . . . . 1 SYN Invoice Not On File . . . . . .YESNO DfltVal:Y Valid:Y,N 53 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM 54 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO 55 ReplacementRevision . . . . . 3 SNN Replacement Bill Revision Code. 56 ReplacementRepairBillOption1. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 57 ReplacementRepairBillOption2. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 58 ReplacementRepairBillOption3. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 59 ReplacementRepairBillOption4. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 60 ReplacementRepairBillOption5. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 61 ReplacementRepairBillOption6. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 62 ReplacementRepairBillOption7. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 63 ReplacementRepairBillOption8. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 64 ReplacementRepairBillOption9. 2 SYN Replacement/Repair Bill Option BILLOPTION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:BMIntegrated, UseOptionBills,RplItemRequire d,RplRegularItem 65 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM ValGroup:NotC omment 66 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 ValGroup:No tComment Notes: 1=Std, 2=Avg, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial 67 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 68 Discount. . . . . . . . . . . 1 SYN Discount. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, ItemRequired,NotComponent 69 PriceLevel. . . . . . . . . . 1 SYN Price Level . . . . . . . . . . ValGroup:IMIntegrated, NotComment,ItemRequired, RegularItem,NotComponent 70 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS ValGroup:ARSalesTax, NotComment 71 SubjectToExemption. . . . . . 1 SYN Subject to Exemption. . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 72 Commissionable. . . . . . . . 1 SYN Commissionable. . . . . . . . .YESNO DfltVal:N Valid:Y,N 73 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:SalepersonReporting, OnFileInvoice 74 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM ValGroup:Sale spersonReporting,OnFileInvoic e 75 XpressSalesOrderNo. . . . . . 7 SYN Xpress Sales Order Number . . .SALESORDERNO FmtType:CHARNUM 76 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment 77 HistoryWarehouseCode. . . . . 3 SYN History Warehouse Code. . . . .WAREHOUSE FmtType:CHARNUM ValGroup:IMIn tegrated,OnFileInvoice, ItemRequired,NotComment, MultiWarehouse,RegularItem 78 HistoryCOGSAcctKey. . . . . . 9 SNN History COGS Account Key. . . .ACCOUNT ValGroup:ItemRequired, ItemTypes,OnFileInvoice 79 SkipPrintCompLine . . . . . . 1 SYN Skip Print of Component Line. .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment Notes: in S/O 80 QuantityReturned. . . . . . . 16.6 NNN Quantity Returned . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 81 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 82 QuantityRemaining . . . . . . 16.6 NNN Quantity Remaining. . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 83 InvoiceUnitPrice. . . . . . . 16.6 NNN Invoice Unit Price. . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotComponent 84 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . Mask:##,###,###.00- ValGroup:NotComment, ItemRequired 85 RestockingCharge. . . . . . . 11.3 NNN Restocking Charge . . . . . . . Mask:###,###.000- ValGroup:No tComment,ItemRequired, ItemTypes 86 InvoiceUnitCost . . . . . . . 16.6 NNN Invoice Unit Cost . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired Notes: Average/Standard 87 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 ValGroup:Not Comment 88 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment 89 OriginalPrice . . . . . . . . 16.6 NNN Original Price. . . . . . . . .PRICE Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice 90 OriginalCost. . . . . . . . . 16.6 NNN Original Cost . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice 91 InvoiceHistoryQty . . . . . . 16.6 NNN Invoice History Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,OnFileInvoice Notes: C=Credit, P=rePlacemen t, R=Repair 92 LineDiscountPercent . . . . . 9.3 NNN Line Discount Percent . . . . . Mask:#,##0.000- ValGroup:NotC omment,LineDiscount, ItemRequired,ItemTypes