     RA_ReceiptsDetail                      RA Receipts Detail             Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: RA_ReceiptsDetail_bus
     SQL Def: Y  SysDB: N                                     "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsDetail.M4T"

     KPRIMARY: RMANo+LineKey
     KDISPLAY: RMANo+LineSeqNo+LineKey
     KEXTENDEDDESC: ExtendedDescriptionKey+RMANo+LineKey
     KITEM: ItemCode+RMANo+LineKey
     KITEMWHSE: 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  LineKey . . . . . . . . . . . .
                                                    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
                                                    Notes: From ARN when Invoice
                                                    is available
       7  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    DepVal:REQUIRED
       8  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,4,5 Notes:
                                                    1=Inventory 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:NotComment,
                                                    ItemRequired,ItemTypes
      11  CustomerAction. . . . . . . .     1 SYN  Customer Action . . . . . . . .
                                                    DfltVal:N Valid:N,C,P,R
                                                    ValGroup:NotComment Notes:
                                                    N=None, C=Credit,P=rePlacemen
                                                    t,R=Repair
      12  ItemAction. . . . . . . . . .     1 SYN  Item Action . . . . . . . . . .
                                                    DfltVal:N Valid:N,S,P,R
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment Notes: N=None,
                                                    S=Stock,P=Scrap,R=Repair
      13  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:IMIn
                                                    tegrated,ItemRequired,
                                                    NotComment,MultiWarehouse,
                                                    RegularItem
      14  ReplacementItemCode . . . . .    30 SYN  Replacement Item Code . . . . .ITEMCODE
                                                    ValGroup:ReplacementRequired
      15  ReplacementItemType . . . . .     1 SNN  Replacement Item Type . . . . .
                                                    Valid:1,2,3,4,5 ValGroup:Repl
                                                    acementRequired Notes:
                                                    1=Inventory Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item
      16  VendorAction. . . . . . . . .     1 SYN  Vendor Action . . . . . . . . .
                                                    DfltVal:N Valid:C,P,N
                                                    ValGroup:POIntegrated,
                                                    ItemRequired,NotComment,
                                                    RegularItem Notes: C=Credit,
                                                    P=rePlacement, N=None
      17  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:POIntegrated,
                                                    VendorActionRequired
      18  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ValGroup:PO
                                                    Integrated,VendorActionRequir
                                                    ed ChngTag:Replace1/APDivisio
                                                    nNo$
      19  ReturnReasonCode. . . . . . .    10 SYN  Return Reason Code. . . . . . .RETURNREASONCODE
      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:ItemTypes
      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,
                                                    RegularItem
      26  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:ItemRequired,
                                                    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  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
      30  BillOption1 . . . . . . . . .     2 SYN  Bill Option 1 . . . . . . . . .BILLOPTION
                                                    FmtType: CHARNUM DepVal:REQUI
                                                    RED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      31  BillOption2 . . . . . . . . .     2 SYN  Bill Option 2 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      32  BillOption3 . . . . . . . . .     2 SYN  Bill Option 3 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      33  BillOption4 . . . . . . . . .     2 SYN  Bill Option 4 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      34  BillOption5 . . . . . . . . .     2 SYN  Bill Option 5 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      35  BillOption6 . . . . . . . . .     2 SYN  Bill Option 6 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      36  BillOption7 . . . . . . . . .     2 SYN  Bill Option 7 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      37  BillOption8 . . . . . . . . .     2 SYN  Bill Option 8 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      38  BillOption9 . . . . . . . . .     2 SYN  Bill Option 9 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,ItemRequired,
                                                    RegularItem
      39  CostOverridden. . . . . . . .     1 SYN  Cost Overridden . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      40  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
      41  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost of Goods Sold Account Key.ACCOUNT
                                                    ValGroup:ItemRequired,
                                                    ItemTypes
      42  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .ACCOUNT
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      43  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .
                                                    DfltVal:N Valid:Y,N,C
                                                    ValGroup:NotComment Notes:
                                                    Y=Yes,N=No,C=Component
      44  StandardKitBill . . . . . . .     1 SYN  Standard/Kit Bill . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      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  RMADetailLineKey. . . . . . .     6 SNN  RMA Detail Line Key . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
      47  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      48  ApplyCommentsToAll. . . . . .     1 SYN  Apply Comments To All . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      49  ApplyToCustomerRMA. . . . . .     1 SYN  Apply To Customer RMA . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      50  ApplyToRMAReceiver. . . . . .     1 SYN  Apply To RMA Receiver . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      51  ApplyToSalesOrder . . . . . .     1 SYN  Apply To Sales Order. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      52  ApplyToCreditMemo . . . . . .     1 SYN  Apply To Credit Memo. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      53  VendorRMANo . . . . . . . . .    10 SYN  Vendor RMA Number . . . . . . .
                                                    FmtType:CHARNUM ValGroup:POIn
                                                    tegrated
      54  InvoiceNotOnFile. . . . . . .     1 SYN  Invoice Not On File . . . . . .YESNO
                                                    DfltVal:Y Valid:Y,N
      55  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM
      56  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
      57  ReplacementRevision . . . . .     3 SNN  Replacement Bill Revision Code.
      58  ReplacementRepairBillOption1.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      59  ReplacementRepairBillOption2.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      60  ReplacementRepairBillOption3.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      61  ReplacementRepairBillOption4.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      62  ReplacementRepairBillOption5.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      63  ReplacementRepairBillOption6.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      64  ReplacementRepairBillOption7.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      65  ReplacementRepairBillOption8.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      66  ReplacementRepairBillOption9.     2 SYN  Replacement/Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:BMIntegrated,
                                                    UseOptionBills,RplItemRequire
                                                    d,RplRegularItem
      67  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    FmtType:CHARNUM ValGroup:NotC
                                                    omment
      68  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
      69  LotSerialFullyDistributed . .     1 SYN  Lot/Serial Fully Distributed. .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      70  Discount. . . . . . . . . . .     1 SYN  Discount. . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    ItemRequired,NotComponent
      71  PriceLevel. . . . . . . . . .     1 SYN  Price Level . . . . . . . . . .
                                                    ValGroup:IMIntegrated,
                                                    NotComment,ItemRequired,
                                                    RegularItem,NotComponent
      72  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    ValGroup:ARSalesTax,
                                                    NotComment
      73  SubjectToExemption. . . . . .     1 SYN  Subject to Exemption. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      74  Commissionable. . . . . . . .     1 SYN  Commissionable. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    SalespersonReporting,
                                                    NotComponent
      75  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:SalespersonReporting
                                                    ,OnFileInvoice
      76  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM ValGroup:Sale
                                                    spersonReporting,OnFileInvoic
                                                    e
      77  XpressSalesOrderNo. . . . . .     7 SYN  Xpress Sales Order Number . . .SALESORDERNO
                                                    FmtType:CHARNUM
      78  PriceOverridden . . . . . . .     1 SYN  Price Overridden. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment
      79  ReceiptSeqNo. . . . . . . . .     6 SNN  Receipt Sequence Number . . . .
                                                    Mask:000000 FmtType:ZEROFILL
      80  HistoryWarehouseCode. . . . .     3 SYN  History Warehouse Code. . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:IMIn
                                                    tegrated,OnFileInvoice,
                                                    ItemRequired,NotComment,
                                                    MultiWarehouse,RegularItem
      81  HistoryCOGSAcctKey. . . . . .     9 SYN  History COGS Account Key. . . .ACCOUNT
                                                    ValGroup:ItemRequired,
                                                    ItemTypes,OnFileInvoice
      82  SkipPrintCompLine . . . . . .     1 SYN  Skip Print of Component Line. .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment Notes:
                                                    in S/O
      83  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      84  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      85  QuantityRemaining . . . . . . 16.6  NNN  Quantity Remaining. . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      86  InvoiceUnitPrice. . . . . . . 16.6  NNN  Invoice Unit Price. . . . . . .PRICE
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes,
                                                    NotComponent
      87  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00-
                                                    ValGroup:NotComment,
                                                    ItemRequired
      88  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .
                                                    Mask:###,###.000- ValGroup:No
                                                    tComment,ItemRequired,
                                                    ItemTypes
      89  InvoiceUnitCost . . . . . . . 16.6  NNN  Invoice Unit Cost . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired Notes:
                                                    Average/Standard
      90  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000 ValGroup:Not
                                                    Comment
      91  QuantityPerBill . . . . . . . 16.6  NNN  Quantity Per Bill . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment
      92  OriginalPrice . . . . . . . . 16.6  NNN  Original Price. . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,OnFileInvoice
      93  OriginalCost. . . . . . . . . 16.6  NNN  Original Cost . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,OnFileInvoice
      94  InvoiceHistoryQty . . . . . . 16.6  NNN  Invoice History Quantity. . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,OnFileInvoice
      95  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percent . . . . .
                                                    Mask:###0.000- ValGroup:NotCo
                                                    mment,LineDiscount,ItemRequir
                                                    ed,ItemTypes