AROITEMS – Acct Receivables Transaction

System: Accounts Receivable (AR)
Prefix: ARO
Primary key: COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ
Fields: 95
Updated by: 4 programs
Referenced by: 20 programs

AROITEMS is the Acct Receivables Transaction table in Lawson Accounts Receivable (prefix ARO). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ (AROSET1); alternate indexes: AROSET10, AROSET11, AROSET12, AROSET13, AROSET14, AROSET2, AROSET3, AROSET4 and 5 more. It is related 1:1 to ARAPSELECT, ARARHUF, ARCOMP, ARCUSTOMER, ARITEMAUD, AROIHDR, ARPROCLEVL, ARSAPPLIED and 3 more and 1:M to ACHISTHDR, ACPMHSTHDR, ARADJUST, ARAPPLIED, ARDISPUTE and ARSADJUST. It is updated by AR12.1, AR12.2, ARLL.1 and CB06.2 and referenced by AC56.1, AC560, AR01.1, AR09.1, AR09.4, AR10.1, AR11.1, AR13.1 and 12 more. The table has 95 fields, 14 indexes and 18 documented relations.

About AROITEMS

The open items transaction file contains open item records consisting of one of three types of transactions; credits (Transaction Type "C"), debits (Transaction Type "D") or invoices (Transaction Type "I"). Records in this file may be unapplied, partially applied or fully applied. Historical transactions remain in this file.

Fields (95)

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

Field / column	Type	Description & values	Updated by
`ARO-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1
`ARO-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	Indicates the type of transaction. Valid values are: `C` Credit Memo `D` Debit Memo `I` Invoice	ARLL.1
`ARO-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	ARLL.1
`ARO-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	Sequence number used for record uniqueness. This number may relate to an invoice line number, payment schedule, line sub grouping, or many other examples. Based on the terms of sale, this field is used as a counter to keep track of multiple payment obligations. Example - a sale of a $50,000 item: Customer to pay 10,000 at the end of the first month, 30,000 the second month, and 10,000 the third month. Thus, three open item records would be created. This field would be used to keep the three obligations unique.	ARLL.1
`ARO-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	The customer number representing a unique customer number.	ARLL.1
`ARO-STATUS` STATUS	Numeric 1	The status indicating where this record is in the processing flow. Valid values are: entry) 1 = Open transaction `0` Unreleased transaction (Batch `2` Select for BOE Application `5` Application by BOE AcAct = N `6` Application by BOE AcAct = Y `7` Fully applied transaction `8` Closed transaction `9` Historical transaction	ARLL.1, CB06.2
`ARO-LAST-STA-DATE` LAST_STA_DATE	Numeric 8 (yyyymmdd)	The date of the last statement that listed this transaction.	ARLL.1
`ARO-TRANS-DATE` TRANS_DATE	Numeric 8 (yyyymmdd)	The date assigned to the transaction.	ARLL.1
`ARO-TRAN-AMT` TRAN_AMT	Signed 18.2	The transaction amount in the company base currency.	ARLL.1
`ARO-APPLD-AMT` APPLD_AMT	Signed 18.2	The total amount applied to the transaction in the company base currency.	ARLL.1, CB06.2
`ARO-APPLIED-SEQ` APPLIED_SEQ	Numeric 7	Number of applications made for this open item.	ARLL.1
`ARO-ADJ-AMT` ADJ_AMT	Signed 18.2	The total amount of adjustments that have been made against the transaction.	CB06.2
`ARO-DISPUTE-SEQ` DISPUTE_SEQ	Numeric 3	The number of dispute records for this open item.	—
`ARO-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	The due date of the open item.	ARLL.1
`ARO-LAST-FC-DATE` LAST_FC_DATE	Numeric 8 (yyyymmdd)	The date of the last finance charge calculation for this open item.	ARLL.1
`ARO-DISC-DATE` DISC_DATE	Numeric 8 (yyyymmdd) Occurs 3 Times ×3	The discount date of the open item.	ARLL.1
`ARO-DISC-PCT` DISC_PCT	Percent 7.5 (Percent) Occurs 3 Times ×3	Discount percent.	ARLL.1
`ARO-DISC-PCT1` DISC_PCT1	Derived	Redefinition of discount percent occurs value one; for use in the discount one compute amount field.	—
`ARO-DISC-PCT2` DISC_PCT2	Derived	Redefinition of discount percent occurs two field; for use in the discount two compute amount field.	—
`ARO-DISC-PCT3` DISC_PCT3	Derived	Redefinition of discount percent occurs value three; for use in the discount three compute amount field.	—
`ARO-ORIG-AMT` ORIG_AMT	Signed 18.2	The original transaction amount for the records. This amount will converted to the company base currency for a non-base currency transaction.	ARLL.1
`ARO-ORIG-APP-AMT` ORIG_APP_AMT	Signed 18.2	Payment amount. The amount applied to the open item in the currency of the transaction.	ARLL.1, CB06.2
`ARO-ORIG-ADJ-AMT` ORIG_ADJ_AMT	Signed 18.2	Transaction adjustment amount. The amount of the open item that has been adjusted in the transaction currency of the open item.	CB06.2
`ARO-OPEN-AMOUNT` OPEN_AMOUNT	Derived	This field is used as a compute field to calculate open amount. No data is stored in this field. Please refer to the Universe documentation for more information on compute fields.	—
`ARO-APPL-DISP` APPL_DISP	Derived	Derived indicator for application amount existing.	—
`ARO-DISC-AMT1` DISC_AMT1	Derived	Derived value for discount amount one.	—
`ARO-DISC-AMT2` DISC_AMT2	Derived	Derived value for discount amount two.	—
`ARO-DISC-AMT3` DISC_AMT3	Derived	Derived value for discount amount three.	—
`ARO-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the transaction.	ARLL.1
`ARO-ITEM-USER1` ITEM_USER1	Alpha 20	The User 1 value associated with the line item.	ARLL.1
`ARO-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	ARLL.1
`ARO-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the activity.	ARLL.1
`ARO-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number.	ARLL.1
`ARO-LINE-TYPE` LINE_TYPE	Alpha 1	Indicates the Billing system line type of the line item. Valid values are `Blank` Non-Lawson BL generated `A` Add on charges item `I` Inventoried item `N` Non stock item `X` Special order item	ARLL.1
`ARO-LINE-SEQ` LINE_SEQ	Numeric 3	The sequence number of the Billing system transaction's line item.	—
`ARO-ITEM` ITEM	Alpha 32	This field contains the item identifier.	ARLL.1
`ARO-EFT-NOTE` EFT_NOTE	Numeric 1	Indicates the status of the EFT note. Valid values are: `0` Prenote not sent `1` Prenote sent `2` Final note sent `9` Note printed	—
`ARO-EFT-EXTRACT` EFT_EXTRACT	Numeric 1	Indicates the status of an EFT adjustment. Valid values are: `0` Not extracted `8` Adjustment made `9` Extracted	—
`ARO-EFT-ACTION` EFT_ACTION	Alpha 1	Indicates the action taken on an EFT transaction. Valid values are: `Blank` Not within due date range `0` Eligible `1` Added `2` Postponed `3` Deleted `5` Added postponed `6` Hold	—
`ARO-GAINLOS-AMT` GAINLOS_AMT	Signed 18.2	The amount of gain or loss from the last run of the Unrealized Gain Loss Report.	—
`ARO-ALT-TYPE` ALT_TYPE	Alpha 1	The transaction type of the associated transaction header record. `C` Credit Memo `D` Debit Memo `I` Invoice `M` Mixed	ARLL.1
`ARO-AR-CUST-PO-NBR` AR_CUST_PO_NBR	Derived	String field to derive purchase order number.	—
`ARO-AR-TERM` AR_TERM	Derived	String field to derive terms code value.	—
`ARO-HIST-PER` HIST_PER	Numeric 2	The number of updates from being processed by AR198 Transaction Status Update.	CB06.2
`ARO-INVL-OBJ-ID` INVL_OBJ_ID	Numeric 12	—	—
`ARO-CUST-PO-NBR` CUST_PO_NBR	Alpha 22	The customer purchase order number.	ARLL.1
`ARO-TRANS-USER1` TRANS_USER1	Alpha 10	User-defined field 1. Can be used as a selection criteria or for sorting in the Lawson Accounts Receivable system. Primarily used as an open item sort within cash aplication.	ARLL.1
`ARO-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	ARLL.1
`ARO-SORT-AMOUNT` SORT_AMOUNT	Numeric 17	—	ARLL.1, CB06.2
`ARO-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
`ARO-BANK-INST-TYPE` BANK_INST_TYPE	Alpha 1	Payment code. Indicates the payment type. Valid values are: `C` Cash `D` Bill of Exchange	ARLL.1
`ARO-SORT-1` SORT_1	Alpha 32 (Lower Case)	User sort 1 field used in cash application and credit manangement inquiry.	ARLL.1
`ARO-SORT-2` SORT_2	Alpha 32 (Lower Case)	User sort 2 field used in cash application and credit manangement inquiry.	ARLL.1
`ARO-SORT-3` SORT_3	Alpha 32 (Lower Case)	User sort 2 field used in cash application and credit manangement inquiry.	ARLL.1
`ARO-SORT-4` SORT_4	Alpha 32 (Lower Case)	User sort 2 field used in cash application and credit manangement inquiry.	ARLL.1
`ARO-ORIG-CURRENCY` ORIG_CURRENCY	Alpha 5	Transaction currency. The currency in which the transaction was added to the system.	ARLL.1
`ARO-ORIG-ND` ORIG_ND	Numeric 1	The number of decimals defined for the transaction currency in the Lawson Currency system.	ARLL.1
`ARO-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. The rate is maintained in the Lawson Currency system, and an option exists at the company level to override the rate at entry time.	ARLL.1
`ARO-BATCH-NBR` BATCH_NBR	Numeric 6	The batch number associated with the invoice or debit memo.	ARLL.1
`ARO-CURR-MUDV` CURR_MUDV	Alpha 1	The currency multiplier or divider. Mathematical technique used in conjunction with the currency exchange rate to convert a non-base currency transaction amount to the company base currency.	ARLL.1
`ARO-SUM-LINE` SUM_LINE	Alpha 1	— `N` No `Y` Yes	ARLL.1
`ARO-GL-DATE` GL_DATE	Numeric 8 (yyyymmdd)	The general ledger posting date assigned to the invoice or debit memo.	ARLL.1
`ARO-AR-CODE` AR_CODE	Alpha 4	The accounts receivable code that identifies the accounts receivable general ledger account for this transaction. The general ledger account that this code represents will be credited during cash application.	ARLL.1
`ARO-REVALUE-FL` REVALUE_FL	Alpha 1	Indicates whether this invoice or debit memo is subject to revaluation if its currency differs from the company currency. Valid values are: `N` No - Do not revalue `Y` Yes - Revalue	ARLL.1
`ARO-CANCEL-FLAG` CANCEL_FLAG	Alpha 1	—	ARLL.1
`ARO-DESC` DESC	Alpha 30 (Lower Case)	Free text description or reason for invoice, debit memo, or credit memo.	ARLL.1
`ARO-GROUP-RATE` GROUP_RATE	Signed 14.7	The currency exchange rate used to convert a transaction amount from a currency that differs from the customer group currency to the customer group currency.	ARLL.1
`ARO-GROUP-MUDV` GROUP_MUDV	Alpha 1	The currency multiplier or divider. Mathematical technique used in conjunction with the currency exchange rate to convert a non-base currency transaction amount to the customer group currency.	ARLL.1
`ARO-SALESMAN` SALESMAN	Numeric 4	Sales representative for this invoice or debit memo.	ARLL.1
`ARO-XREF-COMPANY` XREF_COMPANY	Numeric 4	The cross reference company of the cross referenced transaction.	ARLL.1
`ARO-XREF-TYPE` XREF_TYPE	Alpha 1	This will identify what type of item is being cross referenced. This will work with the cross reference number field. Valid values are: `C` Credit Memo `D` Debit Mmeo `I` Invoice `O` Other	ARLL.1
`ARO-XREF-NBR` XREF_NBR	Alpha 22	The Cross Reference Number field is an informational field that can be used when entering an invoice or debit memo to cross reference a particular record. It could also be used for example, as the order entry order number for this invoice or debit memo.	ARLL.1
`ARO-ORIG-CODE` ORIG_CODE	Alpha 1	Identifies where the transaction originated. Valid values are: `B` AR generated invoice (AR42) `C` Chargeback (Memo) `F` Finance charges `L` Converted records (Lawson) `M` Memo (AR40) `O` External Order Entry `R` Returned Payment `G` Grouping `E` Chargebacks (Summary/Detail)	ARLL.1
`ARO-TERMS-CD` TERMS_CD	Alpha 5	Terms code for this invoice, or debit memo, or credit memo. Must be a valid terms code.	ARLL.1
`ARO-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
`ARO-ADJ-FL` ADJ_FL	Alpha 1	category cannot be entered on the aradjust record. `If the field` Y, activity and acct	ARLL.1
`ARO-LATE-CH-FL` LATE_CH_FL	Alpha 1	Late Charge Flag. Indicate if late charge is to be applied to the invoice.	ARLL.1
`ARO-LST-DUNLTR-STM` LST_DUNLTR_STM	Numeric 2	Level of the last dunning letter sent.	ARLL.1
`ARO-LAST-LTR-DATE` LAST_LTR_DATE	Numeric 8 (yyyymmdd)	Date last dunning letter was sent for the invoice.	ARLL.1
`ARO-LST-LTRTEXT-CD` LST_LTRTEXT_CD	Alpha 6	Text Code for last Dunning Letter sent on this invoice.	ARLL.1
`ARO-SENT-FOR-COLL` SENT_FOR_COLL	Alpha 1	Sent for collection. This indicates whether the invoice has been sent for collection (Yes or No).	ARLL.1
`ARO-ASSESS-DUN-FEE` ASSESS_DUN_FEE	Alpha 1	Specifies whether to assess a dunning letter fee.	ARLL.1
`ARO-DUN-LTR-IND` DUN_LTR_IND	Alpha 1	Specifies whether the advanced dunning letter process is to be used.	ARLL.1
`ARO-ORIG-DISC-AMT` ORIG_DISC_AMT	Signed 18.2 Occurs 3 Times ×3	—	ARLL.1
`ARO-CONTRACT` CONTRACT	Alpha 15	Activity Management contract.	ARLL.1
`ARO-ACTIVITY-GRP` ACTIVITY_GRP	Alpha 15	The activity group is the overall project.	ARLL.1
`ARO-NA-LST-ST-DATE` NA_LST_ST_DATE	Numeric 8 (yyyymmdd)	—	—
`ARO-REASON-CODE` REASON_CODE	Alpha 4	—	ARLL.1
`ARO-GRANT` GRANT	Alpha 30	—	ARLL.1
`ARO-DEST-COUNTRY` DEST_COUNTRY	Alpha 2	—	ARLL.1
`ARO-ORIGIN-COUNTRY` ORIGIN_COUNTRY	Alpha 2	—	ARLL.1
`ARO-BILL-TO` BILL_TO	Numeric 4	—	ARLL.1
`ARO-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	—
`ARO-TEMP-HOLD` TEMP_HOLD	Alpha 1	— `A` Approved by Engine `S` Sent for Approval	—
`ARO-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	—

Indexes (14)

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
`AROSET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	Primary, KeyChange		AC56.1, AC560, AR01.1, AR09.1, AR09.4, AR10.1, AR11.1, AR12.1 +16 more
`AROSET10`	`COMPANY`, `CUSTOMER`, `SORT-AMOUNT*`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	—
`AROSET11`	`COMPANY`, `CUSTOMER`, `CUST-PO-NBR`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	—
`AROSET12`	`COMPANY`, `CUSTOMER`, `TRANS-USER1`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	—
`AROSET13`	`COMPANY`, `CUSTOMER`, `PROCESS-LEVEL`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	ARLL.1
`AROSET14`	`ACTIVITY`, `STATUS`, `TRANS-DATE`, `COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange		—
`AROSET2`	`COMPANY`, `CUSTOMER`, `DUE-DATE`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1 Or STATUS = 2	—
`AROSET3`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	AR12.1, AR12.2, ARLL.1
`AROSET4`	`COMPANY`, `CUSTOMER`, `TRANS-DATE`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS > Zeroes And STATUS < 9	—
`AROSET5`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange		AR10.1, AR301, ARLL.1
`AROSET6`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS > Zeroes And STATUS < 9	—
`AROSET7`	`COMPANY`, `CUSTOMER`, `ACTIVITY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	—
`AROSET8`	`COMPANY`, `ALT-TYPE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange		ARLL.1
`AROSET9`	`COMPANY`, `TRANS-TYPE`, `DUE-DATE`, `INVOICE`, `PAYMENT-SEQ`	KeyChange, Subset	Where STATUS = 1	—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Field map
Arapselect	ARAPSELECT	Not Required	`ARO-COMPANY` → `AAI-COMPANY (AAISET2)`, `ARO-TRANS-TYPE` → `AAI-TRANS-TYPE`, `ARO-INVOICE` → `AAI-INVOICE`, `ARO-PAYMENT-SEQ` → `AAI-PAYMENT-SEQ`
Ararhuf	ARARHUF	Not Required	`ARO-COMPANY` → `TUF-COMPANY`, `ARO-ALT-TYPE` → `TUF-TRANS-TYPE`, `ARO-INVOICE` → `TUF-INVOICE`
Arcomp	ARCOMP	Required	`ARO-COMPANY` → `ACO-COMPANY`
Arcustomer	ARCUSTOMER	Required	`ARO-COMPANY` → `ACM-COMPANY`, `ARO-CUSTOMER` → `ACM-CUSTOMER`
Aritemaud	ARITEMAUD	Not Required	`ARO-COMPANY` → `ARZ-COMPANY`, `ARO-TRANS-TYPE` → `ARZ-TRANS-TYPE`, `ARO-INVOICE` → `ARZ-INVOICE`, `ARO-PAYMENT-SEQ` → `ARZ-PAYMENT-SEQ`
Aroihdr	AROIHDR	Required	`ARO-COMPANY` → `ARH-COMPANY`, `ARO-ALT-TYPE` → `ARH-TRANS-TYPE`, `ARO-INVOICE` → `ARH-INVOICE`
Arprlev	ARPROCLEVL	Required	`ARO-COMPANY` → `APV-COMPANY`, `ARO-PROCESS-LEVEL` → `APV-PROCESS-LEVEL`
Arsapplied	ARSAPPLIED	Not Required	`ARO-COMPANY` → `ASG-COMPANY`, `ARO-TRANS-TYPE` → `ASG-TRANS-TYPE`, `ARO-INVOICE` → `ASG-INVOICE`, `ARO-PAYMENT-SEQ` → `ASG-PAYMENT-SEQ`
Arusersort	ARUSERSORT	Not Required	`ARO-COMPANY` → `USS-COMPANY`, `ARO-TRANS-TYPE` → `USS-TRANS-TYPE`, `ARO-INVOICE` → `USS-INVOICE`, `ARO-PAYMENT-SEQ` → `USS-PAYMENT-SEQ`
Cbbankinst	CBBANKINST	Required	`ARO-BANK-INST-CODE` → `CBI-BANK-INST-CODE`
Custdesc	CUSTDESC	Required	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `ARO-CUSTOMER` → `CUD-CUSTOMER`

One to many (7) — child tables

Relation	Table	Rules	Condition	Field map
Achisthdr	ACHISTHDR		Valid When ARO-CONTRACT != "SPACES"	`ARO-CONTRACT` → `HIH-CONTRACT`, `ARO-COMPANY` → `HIH-COMPANY`, `ARO-CUSTOMER` → `HIH-CUSTOMER`, `ARO-AC-CUSTOMER-ID` → `HIH-AC-CUSTOMER-ID`, `ARO-INVOICE` → `HIH-INVOICE`, → `HIH-OBJ-ID`
Acpmhsthdr	ACPMHSTHDR		Valid When ARO-CONTRACT != "SPACES"	`ARO-CONTRACT` → `PMH-CONTRACT`, `ARO-COMPANY` → `PMH-COMPANY`, `ARO-CUSTOMER` → `PMH-CUSTOMER`, `ARO-AC-CUSTOMER-ID` → `PMH-AC-CUSTOMER-ID`, `ARO-INVOICE` → `PMH-INVOICE`, → `PMH-OBJ-ID`
Aradjust	ARADJUST	Delete Restricted		`ARO-COMPANY` → `ADJ-COMPANY`, `ARO-TRANS-TYPE` → `ADJ-TRANS-TYPE`, `ARO-INVOICE` → `ADJ-INVOICE`, `ARO-PAYMENT-SEQ` → `ADJ-PAYMENT-SEQ`, `ARH-BATCH-NBR` → `ADJ-BATCH-NBR`, → `ADJ-APP-SEQ`, → `ADJ-ADJ-SEQ`
Arapplied	ARAPPLIED	Delete Restricted		`ARO-COMPANY` → `ARA-COMPANY`, `ARO-TRANS-TYPE` → `ARA-TRANS-TYPE`, `ARO-INVOICE` → `ARA-INVOICE`, `ARO-PAYMENT-SEQ` → `ARA-PAYMENT-SEQ`, `ARH-BATCH-NBR` → `ARA-BATCH-NBR`, → `ARA-APP-SEQ`
Ardispute	ARDISPUTE	Delete Cascades		`ARO-COMPANY` → `ADP-COMPANY`, `ARO-CUSTOMER` → `ADP-CUSTOMER`, `ARO-TRANS-TYPE` → `ADP-TRANS-TYPE`, `ARO-INVOICE` → `ADP-INVOICE`, `ARO-PAYMENT-SEQ` → `ADP-PAYMENT-SEQ`, → `ADP-SEQ`
Arsadjust	ARSADJUST			`ARO-COMPANY` → `ASJ-COMPANY`, `ARO-TRANS-TYPE` → `ASJ-TRANS-TYPE`, `ARO-INVOICE` → `ASJ-INVOICE`, `ARO-PAYMENT-SEQ` → `ASJ-PAYMENT-SEQ`, `ARO-BATCH-NBR` → `ASJ-BATCH-NBR`, → `ASJ-ADJ-SEQ`
Crapplied	ARAPPLIED			`ARO-COMPANY` → `ARA-CR-COMPANY`, `ARO-CUSTOMER` → `ARA-CR-CUSTOMER`, `ARO-TRANS-TYPE` → `ARA-CR-TYPE`, `ARO-INVOICE` → `ARA-CR-NBR`, `ARO-PAYMENT-SEQ` → `ARA-CR-PYMNT-SEQ`, `ARH-BATCH-NBR` → `ARA-CR-BATCH`, → `ARA-CR-SUFFIX`, → `ARA-CR-CANCEL-SEQ`, → `ARA-CR-APP-SEQ`

Programs

Updated by (4)

AR12.1 National Account
AR12.2 National Account Speed Entry
ARLL.1 AR Transaction Interface
CB06.2 Bank Statement Detail Entry

Referenced by (20)

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
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
CB191 Bank Statement Close
TX140 Vertex Geocode Update
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location