Acct Receivables Trans 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
AC56.1 | AC560 | AR01.1 | AR09.1 | AR09.4 | AR10.1 |
AR11.1 | AR12.1 | AR12.2 | AR13.1 | AR13.2 | AR210 |
AR301 | AR501 | AR550 | BR11.1 | BR48.1 | CB06.2 |
CB191 | GL235 | TX140 | WH20.2 | WH20.7 | AR17.1 |
ARLL.1 | TX101 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
ARH-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
||
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 |
|
||
ARH-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||
ARH-STATUS Element: Transaction Status | Numeric 1 This field contains the status of the transaction. Valid values are 0 = Unreleased 1 = Released |
|
||
ARH-CUSTOMER Element: Customer | Alpha 9 (Right Justified) Customer number. |
|
||
ARH-BATCH-NBR Element: Batch Number | Numeric 6 This identifies the batch the entered invoices and debit memos are part of. |
|
||
ARH-PROCESS-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||
ARH-TRANS-DATE Element: Transaction Date | Numeric 8 (yyyymmdd) This field contains the date of the transaction. |
|
||
ARH-GL-DATE Element: General Ledger Date | Numeric 8 (yyyymmdd) This field contains the general ledger posting date. |
|
||
ARH-ORIG-CURRENCY Element: Transaction Currency | Alpha 5 The transaction currency code. |
|
||
ARH-ORIG-ND Element: Number of Decimals | Numeric 1 Currency decimal indicator. |
|
||
ARH-ORIG-AMT Element: Transaction Amount | Signed 18.2 The amount of the transaction in transaction currency. |
|
||
ARH-TRAN-AMT Element: Base Amount | Signed 18.2 The total amount of the transaction in the company base currency. |
|
||
ARH-CUST-PO-NBR Element: Customer PO Number | Alpha 22 The customer purchase order number assigned to the invoice. |
|
||
ARH-XREF-COMPANY Cross Reference Company | Numeric 4 The company associated with the cross referenced transaction. |
|
||
ARH-XREF-CUSTOMER Cross Reference Customer | Alpha 9 (Right Justified) The customer associated with the cross referenced transaction. |
|
||
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 |
|
||
ARH-XREF-NBR Cross Reference Number | Alpha 22 The cross reference number entered when the transaction was created. |
|
||
ARH-XREF-PYMT-SEQ Element: Xref Pymt Seq | Numeric 6 The sequence number of the cross reference transaction. |
|
||
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. |
|
||
ARH-DESC Element: Description | Alpha 30 (Lower Case) The description of invoice or debit memo. |
|
||
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. |
|
||
ARH-TRANS-USER2 Element: Transaction User 2 | Alpha 15 Transaction 2 user-defined field. |
|
||
ARH-TRANS-USER3 Element: Transaction User 3 | Numeric 8 (yyyymmdd) Transaction 3 user-defined field. |
|
||
ARH-TRANS-USER4 Element: Transaction User 4 | Numeric 9 Transaction 4 user-defined field. |
|
||
ARH-TRANS-USER5 Element: Transaction User 5 | Signed 18.2 Transaction 5 user-defined field. |
|
||
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. |
|
||
ARH-SALESMAN Element: SalesRep | Numeric 4 The sales representative. Defaults from AR Company Customer file. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
ARH-GROUP-MUDV Group Multiply/Divide | Alpha 1 The group currency multiply/divide indicator. |
|
||
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. |
|
||
ARH-BANK-INST-TYPE Element: Bank Inst Type | Alpha 1 This categorizes the type of bank instrument. C = Cash Payment D = Bill of Exchange |
|
||
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. |
|
||
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. |
|
||
ARH-DIST-SEQ Distribution Sequence Number | Numeric 4 The last distribution sequence number assigned to the transaction. |
|
||
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 |
|
||
ARH-BILL-TO Element: Bill To | Numeric 4 The bill to location for the open item. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
ARH-JRNL-BOOK-NBR Element: Journal Book Number | Alpha 12 This field contains the journal book number for this transaction header record. |
|
||
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 |
|
||
ARH-LATE-CH-FL Element: Late Ch Fl | Alpha 1 Late Charge Flag. Indicate if late charge is to be applied to the invoice. |
|
||
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 |
|
||
ARH-SUM-LINE Element: Sum Line | Alpha 1 N = No Y = Yes |
|
||
ARH-SYSTEM Element: System | Alpha 2 A two-character code representing an application used within the Lawson system. (i.e.: BR = Billing & Revenue). |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
ARH-FOR-ECON-CODE Element: Code | Alpha 10 |
|
||
ARH-GLBL-DOC-TYPE Element: Glbl Doc Type | Alpha 10 |
|
||
ARH-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ARHSET1 |
COMPANY TRANS-TYPE INVOICE |
|
| ||||||||||||||||||||||||||||||||
ARHSET2 |
CUST-PO-NBR COMPANY CUSTOMER TRANS-TYPE INVOICE |
|
|||||||||||||||||||||||||||||||||
ARHSET3 |
COMPANY BATCH-NBR CUSTOMER TRANS-TYPE INVOICE |
|
| ||||||||||||||||||||||||||||||||
ARHSET4 |
COMPANY CUSTOMER TRANS-TYPE INVOICE |
|
| ||||||||||||||||||||||||||||||||
ARHSET5 |
ALT-TYPE INVOICE COMPANY |
|
| ||||||||||||||||||||||||||||||||
ARHSET6 |
COMPANY ALT-TYPE INVOICE |
|
| ||||||||||||||||||||||||||||||||
ARHSET7 |
COMPANY CUSTOMER TRANS-TYPE INVOICE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Accntract | ACCNTRACT |
Not Required
| |||||||||
Arcode | ARCODE |
Required
| |||||||||
Arcomp | ARCOMP |
Required
| |||||||||
Arcustomer | ARCUSTOMER |
Required
| |||||||||
Arproclevl | ARPROCLEVL |
Required
| |||||||||
Aruoihdr | ARUOIHDR |
Not Required
| |||||||||
Blinvhdr | BLINVHDR |
Required
| |||||||||
Cbbankinst | CBBANKINST |
Required
| |||||||||
Custdesc | CUSTDESC |
Required
| |||||||||
Salesrep | SALESREP |
Required
| |||||||||
Terms | TERMS |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Achisthdr | ACHISTHDR |
| |||||||||||||||||||||||||||
Acpmhsthdr | ACPMHSTHDR |
| |||||||||||||||||||||||||||
Aradjust | ARADJUST |
| |||||||||||||||||||||||||||
Arapplied | ARAPPLIED |
| |||||||||||||||||||||||||||
Arappliedcr | ARAPPLIED |
| |||||||||||||||||||||||||||
Arcomment | ARCOMMENT |
Delete Cascades
| |||||||||||||||||||||||||||
Ardistrib | ARDISTRIB |
Delete Cascades
| |||||||||||||||||||||||||||
Aroitems | AROITEMS |
Delete Cascades
| |||||||||||||||||||||||||||
Arsapplied | ARSAPPLIED |
| |||||||||||||||||||||||||||
Arusersort | ARUSERSORT |
|
All trademarks and registered trademarks are the property of their
respective owners.