     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