     RA_ReceiptsHistoryDetail               RA Receipts History Detail     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: RA_ReceiptsHistoryDetail_bus,RA_GenerateTransactions_upd
     SQL Def: Y  SysDB: N                              "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryDetail.M4T"

     KPRIMARY: RMANo+ReceiptSeqNo+ReceiptDetailSeqNo
     KEXTENDEDDESC: ExtendedDescriptionKey+RMANo+ReceiptDetailSeqNo+ReceiptSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:CHARNUM
       2  ReceiptDetailSeqNo. . . . . .     6 SNN  Receipt Detail Sequence Number.
                                                    Mask:000000 FmtType:ZEROFILL
       3  ReceiptSeqNo. . . . . . . . .     6 SNN  Receipt Sequence Number . . . .
       4  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM
       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 SYN  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0
       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
      10  ExtendedDescriptionKey. . . .    10 SYN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y
      11  CustomerAction. . . . . . . .     1 SYN  Customer Action . . . . . . . .
                                                    Valid:C,P,R Notes: C=Credit,
                                                    P=rePlacement, R=Repair
      12  ItemAction. . . . . . . . . .     1 SYN  Item Action . . . . . . . . . .
                                                    Valid:S,P,R Notes: S=Stock,
                                                    P=scraP, R=Repair
      13  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
      14  ReplacementItemCode . . . . .    30 SYN  Replacement Item Code . . . . .ITEMCODE
                                                    ChngTag:Replace0
      15  ReplacementItemType . . . . .     1 SYN  Replacement 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
      16  VendorAction. . . . . . . . .     1 SYN  Vendor Action . . . . . . . . .
                                                    Valid:C,P,N Notes: C=Credit,
                                                    P=rePlacement, N=None
      17  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      18  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$
      19  ReturnReasonCode. . . . . . .    10 SYN  Return Reason Code. . . . . . .RETURNREASONCODE
      20  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
      21  DropShip. . . . . . . . . . .     1 SYN  Drop Ship . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      22  CrossShip . . . . . . . . . .     1 SYN  Cross Ship. . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      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 SNN  Alias Item Number . . . . . . .
      26  WarrantyCode. . . . . . . . .    10 SYN  Warranty Code . . . . . . . . .WARRANTYCODE
      27  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
      28  ExpirationDateOverridden. . .     1 SYN  Expiration Date Overridden. . .YESNO
                                                    DfltVal:N Valid:Y,N
      29  SOCostOverridden. . . . . . .     1 SYN  SO Cost Overridden. . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      30  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
      31  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
      32  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
      33  BillOption1 . . . . . . . . .     2 SYN  Bill Option 1 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      34  BillOption2 . . . . . . . . .     2 SYN  Bill Option 2 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      35  BillOption3 . . . . . . . . .     2 SYN  Bill Option 3 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      36  BillOption4 . . . . . . . . .     2 SYN  Bill Option 4 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      37  BillOption5 . . . . . . . . .     2 SYN  Bill Option 5 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      38  BillOption6 . . . . . . . . .     2 SYN  Bill Option 6 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      39  BillOption7 . . . . . . . . .     2 SYN  Bill Option 7 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      40  BillOption8 . . . . . . . . .     2 SYN  Bill Option 8 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      41  BillOption9 . . . . . . . . .     2 SYN  Bill Option 9 . . . . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      42  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
      43  ExplodedKitItem . . . . . . .     1 SYN  Exploded Kit Item . . . . . . .
                                                    DfltVal:N Valid:Y,N,C Notes:
                                                    Y=Yes, N=No,C=Component
      44  StandardKitBill . . . . . . .     1 SYN  Standard/Kit Bill . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      45  BackorderKitCompLines . . . .     1 SYN  Backorder Kit Component Lines .YESNO
                                                    DfltVal:N Valid:Y,N
      46  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      47  ApplyCommentsToAll. . . . . .     1 SYN  Apply Comments to All . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      48  ApplyToCustomerRMA. . . . . .     1 SYN  Apply to Customer RMA . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      49  ApplyToRMAReceiver. . . . . .     1 SYN  Apply to RMA Receiver . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      50  ApplyToSalesOrder . . . . . .     1 SYN  Apply to Sales Order. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      51  ApplyToCreditMemo . . . . . .     1 SYN  Apply to Credit Memo. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      52  VendorRMANo . . . . . . . . .    10 SYN  Vendor RMA Number . . . . . . .
                                                    FmtType:CHARNUM
      53  InvoiceNotOnFile. . . . . . .     1 SYN  Invoice Not On File . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      54  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM
      55  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
      56  ReplacementRevision . . . . .     3 SNN  Replacement Bill Revision Code.
      57  ReplacementRepairBillOption1.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      58  ReplacementRepairBillOption2.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      59  ReplacementRepairBillOption3.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      60  ReplacementRepairBillOption4.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      61  ReplacementRepairBillOption5.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      62  ReplacementRepairBillOption6.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      63  ReplacementRepairBillOption7.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      64  ReplacementRepairBillOption8.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      65  ReplacementRepairBillOption9.     2 SYN  Replacement Repair Bill Option BILLOPTION
                                                    FmtType:CHARNUM
      66  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    FmtType:CHARNUM
      67  Valuation . . . . . . . . . .     1 SYN  Valuation . . . . . . . . . . .
                                                    Valid:1,2,3,4,5,6 Notes:
                                                    1=Std, 2=Avg, 3=Fifo, 4=Lifo,
                                                     5=Lot, 6=Serial
      68  XpressGeneratedSONo . . . . .     7 SYN  Xpress/Generated SO Number. . .SALESORDERNO
                                                    FmtType:CHARNUM
      69  GeneratedCMInvoiceNo. . . . .     7 SYN  Generated CM Invoice Number . .INVOICE
                                                    FmtType:MASTERNUM
      70  GeneratedPurchaseOrderNo. . .     7 SYN  Generated Purchase Order Number
                                                    FmtType:CHARNUM
      71  GeneratedPOReturnNo . . . . .     7 SYN  Generated PO Return Number. . .
                                                    FmtType:CHARNUM
      72  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      73  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM
      74  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      75  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      76  QuantityRemaining . . . . . . 16.6  NNN  Quantity Remaining. . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      77  InvoiceUnitPrice. . . . . . . 16.6  NNN  Invoice Unit Price. . . . . . .PRICE
                                                    Mask:##,###,###.000000-
      78  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00
      79  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .
                                                    Mask:###,###.000-
      80  InvoiceUnitCost . . . . . . . 16.6  NNN  Invoice Unit Cost . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: Average/Standard
      81  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000
      82  QuantityPerBill . . . . . . . 16.6  NNN  Quantity Per Bill . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-