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-