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