AR Transaction Header

The AR Transaction Header represents invoice, debit memo and credit memo header information. There will be subordinate records to this file that will carry individual attributes (due dates, amounts, etc...) for each of the "line items" of a transaction header. At least one "line item" will exist for each transaction header record.

REFERENCED BY

AR12.1

AR12.2

AR17.1

CB06.2

CB191

GL235

UPDATED BY

AC56.1	AC560	AR01.1	AR10.1	ARLL.1	BR11.1
BR48.1	TX101	WH20.2	WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ARH-COMPANY Element: Company	Numeric 4 The number representing an AR company.	ARLL.1
ARH-TRANS-TYPE Element: Transaction Type	Alpha 1 Indicates the type of transaction. Valid values are: C = Credit Memo D = Debit Memo I = Invoice M = Mixed	ARLL.1
ARH-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.	ARLL.1
ARH-STATUS Element: Transaction Status	Numeric 1 This field contains the status of the transaction. Valid values are 0 = Unreleased 1 = Released	ARLL.1
ARH-CUSTOMER Element: Customer	Alpha 9 (Right Justified) Customer number.	ARLL.1
ARH-BATCH-NBR Element: Batch Number	Numeric 6 This identifies the batch the entered invoices and debit memos are part of.	ARLL.1
ARH-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	ARLL.1
ARH-TRANS-DATE Element: Transaction Date	Numeric 8 (yyyymmdd) This field contains the date of the transaction.	ARLL.1
ARH-GL-DATE Element: General Ledger Date	Numeric 8 (yyyymmdd) This field contains the general ledger posting date.	ARLL.1
ARH-ORIG-CURRENCY Element: Transaction Currency	Alpha 5 The transaction currency code.	ARLL.1
ARH-ORIG-ND Element: Number of Decimals	Numeric 1 Currency decimal indicator.	ARLL.1
ARH-ORIG-AMT Element: Transaction Amount	Signed 18.2 The amount of the transaction in transaction currency.	ARLL.1
ARH-TRAN-AMT Element: Base Amount	Signed 18.2 The total amount of the transaction in the company base currency.	ARLL.1
ARH-CUST-PO-NBR Element: Customer PO Number	Alpha 22 The customer purchase order number assigned to the invoice.	ARLL.1
ARH-XREF-COMPANY Cross Reference Company	Numeric 4 The company associated with the cross referenced transaction.	ARLL.1
ARH-XREF-CUSTOMER Cross Reference Customer	Alpha 9 (Right Justified) The customer associated with the cross referenced transaction.	ARLL.1
ARH-XREF-TYPE Element: Cross Reference Type	Alpha 1 The type of cross reference. Used to identify the reference number being cross referenced in this transaction. Valid values are: I = Invoice D = Debit Memo C = Credit Memo	ARLL.1
ARH-XREF-NBR Cross Reference Number	Alpha 22 The cross reference number entered when the transaction was created.	ARLL.1
ARH-XREF-PYMT-SEQ Element: Xref Pymt Seq	Numeric 6 The sequence number of the cross reference transaction.	ARLL.1
ARH-XREF-DUE-DATE Cross Reference Due Date	Numeric 8 (yyyymmdd) The due date of the cross referenced transaction.
ARH-AUTO-APP-FL Automatic Application Flag	Alpha 1 Indicates if the transaction is eligible for automatic cash application.	ARLL.1
ARH-DESC Element: Description	Alpha 30 (Lower Case) The description of invoice or debit memo.	ARLL.1
ARH-TRANS-USER1 Element: Transaction User 1	Alpha 10 A user-defined field that is built with an access path to the transaction. This is used for sorting and selecting purposes.	ARLL.1
ARH-TRANS-USER2 Element: Transaction User 2	Alpha 15 Transaction 2 user-defined field.	ARLL.1
ARH-TRANS-USER3 Element: Transaction User 3	Numeric 8 (yyyymmdd) Transaction 3 user-defined field.	ARLL.1
ARH-TRANS-USER4 Element: Transaction User 4	Numeric 9 Transaction 4 user-defined field.	ARLL.1
ARH-TRANS-USER5 Element: Transaction User 5	Signed 18.2 Transaction 5 user-defined field.	ARLL.1
ARH-AR-CODE Accounts Receivable Code	Alpha 4 The accounts receivable code that identifies the accounts receivable general ledger account to be credited (or debited if a credit memo) during cash application.	ARLL.1
ARH-SALESMAN Element: SalesRep	Numeric 4 The sales representative. Defaults from AR Company Customer file.	ARLL.1
ARH-ORIG-RATE Element: Exchange Rate	Signed 14.7 The currency exchange rate used to convert a non-base currency transaction amount to the company base currency.	ARLL.1
ARH-CURR-MUDV Currency Multiply/Divide	Alpha 1 The currency multiply/divide indicator. Indicates whether the currency exchange rate is to be multiplied or divided by the original, transaction amount to calculate the base currency amount.	ARLL.1
ARH-GROUP-RATE Element: Group Rate	Signed 14.7 The group currency exchange rate. Used to convert a non-base currency transaction amount to the group currency.	ARLL.1
ARH-GROUP-MUDV Group Multiply/Divide	Alpha 1 The group currency multiply/divide indicator.	ARLL.1
ARH-BASE-DETAIL Element: Base Detail	Signed 18.2 This is a working field used to insure balancing non-base distributions in a rounding situation.
ARH-BANK-INST-CODE Element: Payment Code	Alpha 3 A transaction code representing a type of cash payment (with atributes for either receiving AP payments, or creating EFT payments), bill of exchange payment, or bank service transaction.	ARLL.1
ARH-BANK-INST-TYPE Element: Bank Inst Type	Alpha 1 This categorizes the type of bank instrument. C = Cash Payment D = Bill of Exchange	ARLL.1
ARH-TERMS-CD Element: Terms Code	Alpha 5 The terms code used in the generation of invoice obligations. Used to calculate prepayment discount dates and net due dates.	ARLL.1
ARH-PAYMENT-SEQ Element: Payment Sequence	Numeric 6 The last sequence number used in generating invoice obligations. An invoice may have multiple records with the same transaction number; each will have its own due date, but will be tied to the primary transaction number.	ARLL.1
ARH-DIST-SEQ Distribution Sequence Number	Numeric 4 The last distribution sequence number assigned to the transaction.	ARLL.1
ARH-ORIG-CODE Element: Origin Code	Alpha 1 A system-generated code that identifies where the record originated. Valid values are: B = AR invoice (AR42) C = Chargeback F = Finance and/or Late Payment Charges L = Converted data (Lawson) M = Memo (AR42) O = External Order Processing system R = Returned Payment G = Grouped Debit Memo E = Closing created chargeback P = Payment created credit memo	ARLL.1
ARH-BILL-TO Element: Bill To	Numeric 4 The bill to location for the open item.	ARLL.1
ARH-REVALUE-FL Element: Revaluation	Alpha 1 This field indicates if a currency revaluation is needed for this non-base invoice or debit memo. Valid values are: N = No; no revaluation needed Y = Yes; revaluation needed	ARLL.1
ARH-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 This is the customer tax exempt indicator. Used by the Lawson Order Entry system and AR invoice entry. Valid values are: T = Taxable E = Exempt	ARLL.1
ARH-NOTICE-FL Element: Notice Flag	Alpha 1 Identifies whether to print notices.
ARH-CB-REASON Element: Chargeback Reason	Alpha 4 The chargeback reason code.
ARH-CB-ORIG-COMP Element: Chargeback Company	Numeric 4 The chargeback company.
ARH-CB-SEQ-NBR Chargeback Sequence Number	Numeric 4 The sequence number of the chargeback.
ARH-CANCEL-FLAG Element: Cancellation Flag	Alpha 1 Indicates if the open item has been has been transferred to another customer. Valid values are: Y = Open item has been transferred Blank = Open item has not been transferred
ARH-REASON-CODE Element: Reason Code	Alpha 4 Indicates the reason for memos.	ARLL.1
ARH-JRNL-BOOK-NBR Element: Journal Book Number	Alpha 12 This field contains the journal book number for this transaction header record.	ARLL.1
ARH-TAX-FL Element: Tax Point	Alpha 1 Indicates tax point origin, used for tax calculation. Valid values are: N = No tax calculation Y = Payment origin	ARLL.1
ARH-LATE-CH-FL Element: Late Ch Fl	Alpha 1 Late Charge Flag. Indicate if late charge is to be applied to the invoice.	ARLL.1
ARH-LATE-CH-TR-NBR Element: Late Ch Tr Nbr	Alpha 10 (Right Justified) The transaction number of the late payment charge invoice.
ARH-LATE-CH-OR-AMT Element: Intl Amt	Signed 18.2
ARH-LATE-CH-TR-AMT Element: Intl Amt	Signed 18.2
ARH-ALT-TYPE Element: Alt Type	Alpha 1 C = Credit Memo D = Debit Memo I = Invoice	ARLL.1
ARH-SUM-LINE Element: Sum Line	Alpha 1 N = No Y = Yes	ARLL.1
ARH-SYSTEM Element: System	Alpha 2 A two-character code representing an application used within the Lawson system. (i.e.: BR = Billing & Revenue).	ARLL.1
ARH-DUN-LTR-IND Element: Dun Ltr Ind	Alpha 1 Dunning letters in use for customer. Yes or No. Specified in AR10.1 (customer). Applies only to the advanced dunning process.
ARH-OVERIDE-DUNPRC Element: Overide Dunprc	Alpha 1 Override Dunning Process.
ARH-DUN-PROCESS-CD Element: Dun Process Cd	Alpha 6 Dunning letter process code for thetransaction A unique code that represents a combinatioin of Dunning Letter options.
ARH-LST-DUNLTR-STM Element: Lst Dunltr Stm	Numeric 2 Level of the last dunning letter sent as if this transaction was dunned in isolation. I.E. As if it were the only overdue transaction on the letter.
ARH-LAST-LTR-DATE Element: Last Ltr Date	Numeric 8 (yyyymmdd) Date last dunning letter was sent for the invoice.
ARH-LST-LTRTEXT-CD Element: Lst Ltrtext Cd	Alpha 6 Text Code for last Dunning Letter sent on this invoice.
ARH-SENT-FOR-COLL Element: Sent For Coll	Alpha 1 Sent for collection. This indicates whether the invoice has been sent for collection (Yes or No).
ARH-ASSESS-DUN-FEE Element: Assess Dun Fee	Alpha 1 Specifies whether to assess a dunning letter fee.
ARH-INV-OBJ-ID Element: Inv Obj Id	Numeric 12
ARH-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5 This field enables a link to BR-created transactions and is used in Drill views.	ARLL.1
ARH-TAX-FLAG Element: All Flag	Alpha 1 This is the tax flag which indicates to the system whether this transaction has been interfaced into the Tax Report files or not.	TX101
ARH-FOB-CODE Element: Fob Code	Alpha 3 The user defined Free On Board Code.
ARH-PORT-CD Element: Port Cd	Alpha 5 The Intrastat port code. Must be defined in IN04.1 (Port Maintenance)
ARH-NOTC Element: Notc	Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
ARH-STAT-PROC Element: Stat Proc	Alpha 6 The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
ARH-ORIGIN-COUNTRY Element: Origin Country	Alpha 2 The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)
ARH-DEST-COUNTRY Element: Dest Country	Alpha 2 The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).
ARH-ORIGIN-REGION Element: Origin Region	Alpha 2 The region of the country from which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)
ARH-DEST-REGION Element: Dest Region	Alpha 2 The region of the country to which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)
ARH-DROP-SHIP-IND Element: Drop Ship Ind	Alpha 1 Specifies whether the shipment is a drop (triangulated) shipment, that is a shipment where goods are shipped from one EC country to another, but a principal in the transaction is based elsewhere.
ARH-TRANSPORT-MODE Element: Transport Mode	Alpha 1 The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel. 1 = Sea 2 = Rail 3 = Road 4 = Air 5 = Post 7 = Fixed Installation 8 = Inland Waterway 9 = Own Propulsion
ARH-GRANT Element: Grant	Alpha 30	ARLL.1

AROIHDR FILE INDEX

AROIHDR FILE RELATIONS

ONE TO ONE RELATIONS

AROIHDR FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.