AROIHDR – Acct Receivables Trans Header

System: Accounts Receivable (AR)
Prefix: ARH
Primary key: COMPANY, TRANS-TYPE, INVOICE
Fields: 83
Updated by: 2 programs
Referenced by: 24 programs

AROIHDR is the Acct Receivables Trans Header table in Lawson Accounts Receivable (prefix ARH). It is indexed by COMPANY, TRANS-TYPE, INVOICE (ARHSET1); alternate indexes: ARHSET2, ARHSET3, ARHSET4, ARHSET5, ARHSET6 and ARHSET7. It is related 1:1 to ACCNTRACT, ARCODE, ARCOMP, ARCUSTOMER, ARPROCLEVL, ARUOIHDR, BLINVHDR, CBBANKINST and 3 more and 1:M to ACHISTHDR, ACPMHSTHDR, ARADJUST, ARAPPLIED, ARCOMMENT, ARDISTRIB, AROITEMS, ARSAPPLIED and 1 more. It is updated by ARLL.1 and TX101 and referenced by AC56.1, AC560, AR01.1, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1 and 16 more. The table has 83 fields, 7 indexes and 21 documented relations.

About AROIHDR

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.

Fields (83)

Column = COBOL field name without the ARH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ARH-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1
`ARH-TRANS-TYPE` PK TRANS_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` PK INVOICE	Alpha 22	Used to identify the invoice.	ARLL.1
`ARH-STATUS` STATUS	Numeric 1	This field contains the status of the transaction. Valid values are `0` Unreleased `1` Released	ARLL.1
`ARH-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	Customer number.	ARLL.1
`ARH-BATCH-NBR` BATCH_NBR	Numeric 6	This identifies the batch the entered invoices and debit memos are part of.	ARLL.1
`ARH-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	ARLL.1
`ARH-TRANS-DATE` TRANS_DATE	Numeric 8 (yyyymmdd)	This field contains the date of the transaction.	ARLL.1
`ARH-GL-DATE` GL_DATE	Numeric 8 (yyyymmdd)	This field contains the general ledger posting date.	ARLL.1
`ARH-ORIG-CURRENCY` ORIG_CURRENCY	Alpha 5	The transaction currency code.	ARLL.1
`ARH-ORIG-ND` ORIG_ND	Numeric 1	Currency decimal indicator.	ARLL.1
`ARH-ORIG-AMT` ORIG_AMT	Signed 18.2	The amount of the transaction in transaction currency.	ARLL.1
`ARH-TRAN-AMT` TRAN_AMT	Signed 18.2	The total amount of the transaction in the company base currency.	ARLL.1
`ARH-CUST-PO-NBR` CUST_PO_NBR	Alpha 22	The customer purchase order number assigned to the invoice.	ARLL.1
`ARH-XREF-COMPANY` XREF_COMPANY	Numeric 4	The company associated with the cross referenced transaction.	ARLL.1
`ARH-XREF-CUSTOMER` XREF_CUSTOMER	Alpha 9 (Right Justified)	The customer associated with the cross referenced transaction.	ARLL.1
`ARH-XREF-TYPE` XREF_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` XREF_NBR	Alpha 22	The cross reference number entered when the transaction was created.	ARLL.1
`ARH-XREF-PYMT-SEQ` XREF_PYMT_SEQ	Numeric 6	The sequence number of the cross reference transaction.	ARLL.1
`ARH-XREF-DUE-DATE` XREF_DUE_DATE	Numeric 8 (yyyymmdd)	The due date of the cross referenced transaction.	—
`ARH-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	Indicates if the transaction is eligible for automatic cash application.	ARLL.1
`ARH-DESC` DESC	Alpha 30 (Lower Case)	The description of invoice or debit memo.	ARLL.1
`ARH-TRANS-USER1` TRANS_USER1	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` TRANS_USER2	Alpha 15	Transaction 2 user-defined field.	ARLL.1
`ARH-TRANS-USER3` TRANS_USER3	Numeric 8 (yyyymmdd)	Transaction 3 user-defined field.	ARLL.1
`ARH-TRANS-USER4` TRANS_USER4	Numeric 9	Transaction 4 user-defined field.	ARLL.1
`ARH-TRANS-USER5` TRANS_USER5	Signed 18.2	Transaction 5 user-defined field.	ARLL.1
`ARH-AR-CODE` AR_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` SALESMAN	Numeric 4	The sales representative. Defaults from AR Company Customer file.	ARLL.1
`ARH-ORIG-RATE` ORIG_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` CURR_MUDV	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` 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_MUDV	Alpha 1	The group currency multiply/divide indicator.	ARLL.1
`ARH-BASE-DETAIL` 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` BANK_INST_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` BANK_INST_TYPE	Alpha 1	This categorizes the type of bank instrument. `C` Cash Payment `D` Bill of Exchange	ARLL.1
`ARH-TERMS-CD` TERMS_CD	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` PAYMENT_SEQ	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` DIST_SEQ	Numeric 4	The last distribution sequence number assigned to the transaction.	ARLL.1
`ARH-ORIG-CODE` ORIG_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` BILL_TO	Numeric 4	The bill to location for the open item.	ARLL.1
`ARH-REVALUE-FL` REVALUE_FL	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` 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` NOTICE_FL	Alpha 1	Identifies whether to print notices.	—
`ARH-CB-REASON` CB_REASON	Alpha 4	The chargeback reason code.	—
`ARH-CB-ORIG-COMP` CB_ORIG_COMP	Numeric 4	The chargeback company.	—
`ARH-CB-SEQ-NBR` CB_SEQ_NBR	Numeric 4	The sequence number of the chargeback.	—
`ARH-CANCEL-FLAG` CANCEL_FLAG	Alpha 1	Indicates if the open item has been has been transferred to another customer. Valid values are: transferred `Y` Open item has been transferred `Blank` Open item has not been	—
`ARH-REASON-CODE` REASON_CODE	Alpha 4	Indicates the reason for memos.	ARLL.1
`ARH-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	This field contains the journal book number for this transaction header record.	ARLL.1
`ARH-TAX-FL` TAX_FL	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` 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` LATE_CH_TR_NBR	Alpha 10 (Right Justified)	The transaction number of the late payment charge invoice.	—
`ARH-LATE-CH-OR-AMT` LATE_CH_OR_AMT	Signed 18.2	—	—
`ARH-LATE-CH-TR-AMT` LATE_CH_TR_AMT	Signed 18.2	—	—
`ARH-ALT-TYPE` ALT_TYPE	Alpha 1	— `C` Credit Memo `D` Debit Memo `I` Invoice	ARLL.1
`ARH-SUM-LINE` SUM_LINE	Alpha 1	— `N` No `Y` Yes	ARLL.1
`ARH-SYSTEM` 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` 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` OVERIDE_DUNPRC	Alpha 1	Override Dunning Process.	—
`ARH-DUN-PROCESS-CD` 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` 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` LAST_LTR_DATE	Numeric 8 (yyyymmdd)	Date last dunning letter was sent for the invoice.	—
`ARH-LST-LTRTEXT-CD` LST_LTRTEXT_CD	Alpha 6	Text Code for last Dunning Letter sent on this invoice.	—
`ARH-SENT-FOR-COLL` 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` ASSESS_DUN_FEE	Alpha 1	Specifies whether to assess a dunning letter fee.	—
`ARH-INV-OBJ-ID` INV_OBJ_ID	Numeric 12	—	—
`ARH-AC-CUSTOMER-ID` 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` TAX_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` FOB_CODE	Alpha 3	The user defined Free On Board Code.	—
`ARH-PORT-CD` PORT_CD	Alpha 5	The Intrastat port code. Must be defined in IN04.1 (Port Maintenance)	—
`ARH-NOTC` NOTC	Alpha 2	The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	—
`ARH-STAT-PROC` 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` ORIGIN_COUNTRY	Alpha 2	The country from which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance)	ARLL.1
`ARH-DEST-COUNTRY` DEST_COUNTRY	Alpha 2	The country to which the goods were shipped. Must be a valid country in IN01.1 (Country Maintenance).	ARLL.1
`ARH-ORIGIN-REGION` 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` 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` 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` 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` GRANT	Alpha 30	—	ARLL.1
`ARH-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	—
`ARH-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	—
`ARH-TAX-AMT` TAX_AMT	Signed 18.2	—	—

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ARHSET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`	Primary, KeyChange		AC56.1, AC560, AR01.1, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1 +17 more
`ARHSET2`	`CUST-PO-NBR`, `COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`	KeyChange		—
`ARHSET3`	`COMPANY`, `BATCH-NBR`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`	KeyChange		ARLL.1
`ARHSET4`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`	KeyChange		AR10.1, AR17.1, TX101
`ARHSET5`	`ALT-TYPE`, `INVOICE`, `COMPANY`	KeyChange		AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2, WH20.7
`ARHSET6`	`COMPANY`, `ALT-TYPE`, `INVOICE`	KeyChange		AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR48.1, WH20.2, WH20.7
`ARHSET7`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`	Subset	Where NOTICE-FL = Spaces And ORIG-CODE = "C" Or ORIG-CODE = "E"	—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Field map
Accntract	ACCNTRACT	Not Required	`ARH-TRANS-USER1` → `CNT-CONTRACT (CNTSET1)`
Arcode	ARCODE	Required	`ARH-COMPANY` → `RCD-COMPANY`, `ARH-AR-CODE` → `RCD-AR-CODE`
Arcomp	ARCOMP	Required	`ARH-COMPANY` → `ACO-COMPANY`
Arcustomer	ARCUSTOMER	Required	`ARH-COMPANY` → `ACM-COMPANY`, `ARH-CUSTOMER` → `ACM-CUSTOMER`
Arproclevl	ARPROCLEVL	Required	`ARH-COMPANY` → `APV-COMPANY`, `ARH-PROCESS-LEVEL` → `APV-PROCESS-LEVEL`
Aruoihdr	ARUOIHDR	Not Required	`ARH-COMPANY` → `UIH-COMPANY`, `ARH-TRANS-TYPE` → `UIH-TRANS-TYPE`, `ARH-INVOICE` → `UIH-INVOICE`
Blinvhdr	BLINVHDR	Required	`ARH-COMPANY` → `BLH-COMPANY`, `ARH-BATCH-NBR` → `BLH-BATCH-NBR`
Cbbankinst	CBBANKINST	Required	`ARH-BANK-INST-CODE` → `CBI-BANK-INST-CODE`
Custdesc	CUSTDESC	Required	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `ARH-CUSTOMER` → `CUD-CUSTOMER`
Salesrep	SALESREP	Required	`ARH-COMPANY` → `SAW-COMPANY`, `ARH-SALESMAN` → `SAW-SALESMAN`
Terms	TERMS	Required	`ARH-TERMS-CD` → `TMS-TERMS-CD`

One to many (10) — child tables

Relation	Table	Rules	Field map
Achisthdr	ACHISTHDR		`ARH-TRANS-USER1` → `HIH-CONTRACT`, `ARH-COMPANY` → `HIH-COMPANY`, `ARH-CUSTOMER` → `HIH-CUSTOMER`, `CNT-AC-CUSTOMER-ID` → `HIH-AC-CUSTOMER-ID`, `ARH-INVOICE` → `HIH-INVOICE`, → `HIH-OBJ-ID`
Acpmhsthdr	ACPMHSTHDR		`ARH-TRANS-USER1` → `PMH-CONTRACT`, `ARH-COMPANY` → `PMH-COMPANY`, `ARH-CUSTOMER` → `PMH-CUSTOMER`, `CNT-AC-CUSTOMER-ID` → `PMH-AC-CUSTOMER-ID`, `ARH-INVOICE` → `PMH-INVOICE`, → `PMH-OBJ-ID`
Aradjust	ARADJUST		`ARH-COMPANY` → `ADJ-COMPANY`, `ARH-TRANS-TYPE` → `ADJ-TRANS-TYPE`, `ARH-INVOICE` → `ADJ-INVOICE`, → `ADJ-PAYMENT-SEQ`, → `ADJ-BATCH-NBR`, → `ADJ-APP-SEQ`, → `ADJ-ADJ-SEQ`
Arapplied	ARAPPLIED		`ARH-COMPANY` → `ARA-COMPANY`, `ARH-TRANS-TYPE` → `ARA-TRANS-TYPE`, `ARH-INVOICE` → `ARA-INVOICE`, → `ARA-PAYMENT-SEQ`, → `ARA-BATCH-NBR`, → `ARA-APP-SEQ`
Arappliedcr	ARAPPLIED		`ARH-COMPANY` → `ARA-CR-COMPANY`, `ARH-CUSTOMER` → `ARA-CR-CUSTOMER`, `ARH-TRANS-TYPE` → `ARA-CR-TYPE`, `ARH-INVOICE` → `ARA-CR-NBR`, → `ARA-CR-PYMNT-SEQ`, → `ARA-CR-BATCH`, → `ARA-CR-SUFFIX`, → `ARA-CR-CANCEL-SEQ`, → `ARA-CR-APP-SEQ`
Arcomment	ARCOMMENT	Delete Cascades	`ARH-COMPANY` → `CMT-COMPANY`, `ARH-CUSTOMER` → `CMT-CUSTOMER`, `"T"` → `CMT-CMMT-TYPE`, `ARH-TRANS-TYPE` → `CMT-TRANS-TYPE`, `ARH-INVOICE` → `CMT-INVOICE`, → `CMT-BEG-DATE`, → `CMT-SEQ-NUMBER`
Ardistrib	ARDISTRIB	Delete Cascades	`ARH-COMPANY` → `AMD-COMPANY`, `ARH-BATCH-NBR` → `AMD-BATCH-NBR`, `ARH-TRANS-TYPE` → `AMD-TRANS-TYPE`, `ARH-INVOICE` → `AMD-INVOICE`, `ARH-CUSTOMER` → `AMD-CUSTOMER`, → `AMD-DIST-SEQ`
Aroitems	AROITEMS	Delete Cascades	`ARH-COMPANY` → `ARO-COMPANY`, `ARH-TRANS-TYPE` → `ARO-ALT-TYPE`, `ARH-INVOICE` → `ARO-INVOICE`, → `ARO-PAYMENT-SEQ`
Arsapplied	ARSAPPLIED		`ARH-COMPANY` → `ASG-COMPANY`, `ARH-TRANS-TYPE` → `ASG-TRANS-TYPE`, `ARH-INVOICE` → `ASG-INVOICE`, → `ASG-PAYMENT-SEQ`
Arusersort	ARUSERSORT		`ARH-COMPANY` → `USS-COMPANY`, `ARH-TRANS-TYPE` → `USS-TRANS-TYPE`, `ARH-INVOICE` → `USS-INVOICE`, → `USS-PAYMENT-SEQ`

Programs

Updated by (2)

ARLL.1 AR Transaction Interface
TX101 Journal File Create

Referenced by (24)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AR01.1 Company
AR09.1 Customer Group Address
AR09.4 Bill To
AR10.1 Customer
AR11.1 Customer Contacts
AR12.1 National Account
AR12.2 National Account Speed Entry
AR13.1 MICR Customer
AR13.2 Customer MICR
AR17.1 Comments
AR210 Customer Listing
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
BR11.1 Customer
BR48.1 Customer Template
CB06.2 Bank Statement Detail Entry
CB191 Bank Statement Close
GL235 AR Currency Rounding GL Report
TX140 Vertex Geocode Update
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location