ARCCUST – AR Customer Conversion

System: Accounts Receivable (AR)
Prefix: ARU
Primary key: COMPANY, CUSTOMER
Fields: 174
Updated by: 2 programs
Referenced by: 0 programs

ARCCUST is the AR Customer Conversion table in Lawson Accounts Receivable (prefix ARU). It is indexed by COMPANY, CUSTOMER (ARUSET1). It is related 1:1 to ARCCUST2. It is updated by AR501 and AR98.1. The table has 174 fields, 1 index and 1 documented relation.

About ARCCUST

No description in the Lawson data dictionary.

Fields (174)

Column = COBOL field name without the ARU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`ARU-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR98.1
#`ARU-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	Required. Customer number.	AR98.1
#`ARU-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	Customer status. If this field is inactive, no invoicing can be done for this customer. Valid values are: `A` Active `D` Set for deletion `I` Inactive	AR98.1
#`ARU-SEARCH-NAME` SEARCH_NAME	Alpha 30	Search name assigned to this customer for search and sorting capabilities. Defaults from customer name if not present.	AR98.1
#`ARU-HOLD-CODE` HOLD_CODE	Alpha 4	Hold code assessed to this customer.	AR98.1
#`ARU-CONTACT` CONTACT	Alpha 20	Name of the primary contact.	AR98.1
#`ARU-INT-PREFIX` INT_PREFIX	Alpha 6	International telephone prefix.	AR98.1
#`ARU-PHONE-NMBR` PHONE_NMBR	Alpha 15	Telephone number.	AR98.1
#`ARU-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	AR98.1
#`ARU-TELEX-NBR` TELEX_NBR	Alpha 15	Phone number.	AR98.1
#`ARU-EDI-NBR` EDI_NBR	Alpha 15	Electronic Data Interchange number.	AR98.1
#`ARU-ALT-EDI-NBR` ALT_EDI_NBR	Alpha 95	This is a free-form field to accommodate an alternate EDI number or electronic address.	AR98.1
#`ARU-ALT-EDI-TYPE` ALT_EDI_TYPE	Alpha 5	Indicates the type of the alternate EDI number.	AR98.1
#`ARU-FAX-NMBR` FAX_NMBR	Alpha 15	Fax number.	AR98.1
#`ARU-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	AR98.1
#`ARU-START-DATE` START_DATE	Numeric 8 (yyyymmdd)	Origin date or starting date of business with this customer.	AR98.1
#`ARU-CREDIT-ANLYST` CREDIT_ANLYST	Alpha 4	Credit analyst code assigned to this customer. If left blank, will default from customer defaults code.	AR98.1
#`ARU-CURRENCY-CD` CURRENCY_CD	Alpha 5	Customer default invoice currency code.	AR98.1
#`ARU-SALESMAN` SALESMAN	Numeric 4	This field contains the code that represents the primary sales representative for this customer. If left blank, this defaults from the customer defaults code.	AR98.1
#`ARU-RISK-CD` RISK_CD	Alpha 1	User-defined risk code used for customer reporting selections. If left blank, company defined risk code will default.	AR98.1
#`ARU-DEFAULT-CODE` DEFAULT_CODE	Alpha 5	Customer default code. Required.	AR98.1
#`ARU-MAJ-CLASS` MAJ_CLASS	Alpha 4	Major class used for customer reporting and processing for this customer. If left blank, will default from customer default code.	AR98.1
#`ARU-MIN-CLASS` MIN_CLASS	Alpha 4	Minor class used for customer reporting and processing for this customer. If left blank, will default from customer default code. Must be entered if a major class is entered.	AR98.1
#`ARU-OPEN-ORDS` OPEN_ORDS	Signed 18.2	Total amount of open orders for this customer. Must be a positive amount.	AR98.1
#`ARU-ORDER-LIM` ORDER_LIM	Signed 15.0	Order limit amount for the total amount of open orders for this customer.	AR98.1
#`ARU-CREDIT-LIM` CREDIT_LIM	Signed 15.0	Total amount of credit for this customer.	AR98.1
#`ARU-CREDIT-LIM-DAT` CREDIT_LIM_DAT	Numeric 8 (yyyymmdd)	The date the credit limit was established. System date will default if left blank.	AR98.1
#`ARU-CREDIT-REVDAYS` CREDIT_REVDAYS	Signed 3.0	Number of days that determine the intervals between credit limit reviews.	AR98.1
#`ARU-LAST-PMT-AMT` LAST_PMT_AMT	Signed 18.2	Amount of last payment in company base currency.	AR98.1
#`ARU-LAST-PMT-DATE` LAST_PMT_DATE	Numeric 8 (yyyymmdd)	Date of last payment to this company for this customer.	AR98.1
#`ARU-LAST-INV-DATE` LAST_INV_DATE	Numeric 8 (yyyymmdd)	Last invoice date.	AR98.1
#`ARU-LAST-INV-AMT` LAST_INV_AMT	Signed 18.2	—	AR98.1
#`ARU-LAST-STA-DATE` LAST_STA_DATE	Numeric 8 (yyyymmdd)	Date of last statement for this customer.	AR98.1
#`ARU-LAST-STA-BAL` LAST_STA_BAL	Signed 18.2	Last statement balance for this customer in company base currency.	AR98.1
#`ARU-REVIEW-DATE` REVIEW_DATE	Numeric 8 (yyyymmdd)	Last date the customer was set for review. System date defaults if left blank.	AR98.1
#`ARU-REVIEW-CODE` REVIEW_CODE	Alpha 1	Indicates the status of the customer's review record. If left blank, reviewed status (R) defaults. Valid values are: `Blank` No review status `O` Open review `R` Reviewed	AR98.1
#`ARU-HIGH-BAL` HIGH_BAL	Signed 15.0 Occurs 13 Times ×13	Highest customer balance for this company for this period.	AR98.1
#`ARU-PER-RTMS` PER_RTMS	Signed 3.0 Occurs 13 Times ×13	Period return-to-maker payment occurrences.	—
#`ARU-PAID-PRMPT` PAID_PRMPT	Signed 5.0 Occurs 12 Times ×12	The number of invoices paid prompt for this period. Invoices cleared by chargebacks are not considered.	—
#`ARU-INV-PAID` INV_PAID	Signed 5.0 Occurs 12 Times ×12	The number of invoices fully paid for this period. This will be used in the Invoice Payment Average (IPA) and Days Beyond Terms (DBT) calculations for each customer.	—
#`ARU-COLLECT-DAYS` COLLECT_DAYS	Signed 3.0 Occurs 11 Times ×11	This is a collection ratio of days to collect those invoices that have been fully paid for this period. This is a weighted calculation based on the amount of the invoice.	AR98.1
#`ARU-CURR-CASH` CURR_CASH	Signed 18.2	This field contains cash paid amount from fully paid transactions. At the end of a period, it will be used to calculate the ratio for the Collect Days field.	—
#`ARU-CURR-CSH-DAYS` CURR_CSH_DAYS	Signed 18.2	This field contains the flow of funds cash days calculated value (paid amount multiplied by number of days to fully pay) for the current period.	—
#`ARU-YTD-CASH` YTD_CASH	Signed 18.2	Year to date total of cash for fully paid transactions.	AR98.1
#`ARU-YTD-CSH-DAYS` YTD_CSH_DAYS	Signed 18.2	Year to date calculation of cash paid and applied to an open item multiplied by the number of days to fully pay the transactions.	AR98.1
#`ARU-YEAR-2-DAYS` YEAR_2_DAYS	Signed 3.0	Weighted invoice payment average for the year previous to the totals being summed in Collect Days occurrences.	AR98.1
#`ARU-STATIC-CUR` STATIC_CUR	Signed 18.2	Static aged current portion of a customer's balance.	—
#`ARU-AGING` AGING	Signed 18.2 Occurs 5 Times ×5	Static aged past due amounts in company base currency for this customer.	—
#`ARU-AGE-DISPUTES` AGE_DISPUTES	Alpha 1	Specifies how disputed invoices will be aged. Valid values are: `N` Not aged - aged in current column `Y` Age respective to date	AR98.1
#`ARU-DISPUTES-FIN` DISPUTES_FIN	Alpha 1	Specifies if disputed invoices are exempt from being assessed finance charges. Valid values are: items `Y` Finance charges on disputed items `N` No finance charges on disputed	AR98.1
#`ARU-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	Automatic cash application indicator. Valid values are: application `N` Not subject to automatic `Y` Subject to automatic application	AR98.1
#`ARU-AUTO-DUNN-FL` AUTO_DUNN_FL	Alpha 1	Indicates whether or not automatic selection of dunning letters will be allowed. Valid values are: `N` No automatic dunning `Y` Automatic dunning	AR98.1
#`ARU-DISC-GRACE-PD` DISC_GRACE_PD	Numeric 2	Grace days added to discount date to allow or disallow discount during cash application.	AR98.1
#`ARU-CR-VAR-PCT` CR_VAR_PCT	Numeric 3	Override percent used for customer credit limit selections.	AR98.1
#`ARU-MEMO-TERM` MEMO_TERM	Alpha 5	Memo terms code. Must be a valid net or prepayment type terms code defined in the Lawson Terms system.	AR98.1
#`ARU-CHRGBK-PRT-FL` CHRGBK_PRT_FL	Alpha 1	Specifies whether chargebacks will be printed. Valid values are: `N` Do not print chargebacks `Y` Print chargebacks	AR98.1
#`ARU-OPEN-BAL-FWD` OPEN_BAL_FWD	Alpha 1	Processing of receivable records by either open item or balance forward methods. Valid values are: `B` Balance forward processing `O` Open item processing	AR98.1
#`ARU-STATEMENT-REQ` STATEMENT_REQ	Alpha 1	Statement required option. Valid values are: `N` No statements required `Y` Statements required	AR98.1
#`ARU-STMNT-CYCLE` STMNT_CYCLE	Alpha 2	Statement cycle code used to group customers for statement processing.	AR98.1
#`ARU-LOCK-BOX` LOCK_BOX	Alpha 2	Remit to location for payment receipts. If left blank, the company address will be used.	AR98.1
#`ARU-ZERO-STMNT-FL` ZERO_STMNT_FL	Alpha 1	Determines whether or not a customer will receive a statement when there is no unapplied transactions and a balance of zero. Valid values are: `N` No zero statements produced `Y` Zero statements produced	AR98.1
#`ARU-CRED-STMNT-FL` CRED_STMNT_FL	Alpha 1	Determines whether or not a customer will receive a statement if a net credit balance exists. Valid values are: `N` No credit statements produced `Y` Credit statements produced	AR98.1
#`ARU-PAST-STMNT-FL` PAST_STMNT_FL	Alpha 1	Past due open items only statements. Valid values are: statements `N` No open item only past due `Y` Open item only past due statements	AR98.1
#`ARU-OVER-STMNT-FL` OVER_STMNT_FL	Alpha 1	Over credit limit statement option. Valid values are: limit statements. credit limit statements. `N` No only balance exceeding credit `Y` Produce only balance exceeding	AR98.1
#`ARU-MAX-AUTO-AMT` MAX_AUTO_AMT	Signed 18.2 Occurs 3 Times ×3	Maximum open item shortage amount during cash application that may be automatically written off. Multiple amounts must be in ascending order.	AR98.1
#`ARU-MAX-AUTO-PCT` MAX_AUTO_PCT	Signed 5.5 Occurs 3 Times ×3	Maximum open item percentage amount during cash application that may be automatically written off. Multiple percentages must be in ascending order.	AR98.1
#`ARU-AUTO-REAS-CD` AUTO_REAS_CD	Alpha 4 Occurs 3 Times ×3	This reason code is required if there is a shortage amount or shortage percentage entered.	AR98.1
#`ARU-DISC-REAS-CD` DISC_REAS_CD	Alpha 4	Default discount reason code for earned discounts during cash application.	AR98.1
#`ARU-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.	AR98.1
#`ARU-DRAFT-FLAG` DRAFT_FLAG	Alpha 1	If the customer has a bill of exchange default payment type, this flag will indicate if the bills of exchange should be created in summary or individually. Valid values are: `Blank` Not paying by BOE method `I` Individual `S` Summary	AR98.1
#`ARU-AR-CODE` AR_CODE	Alpha 4	Accounts receivable general ledger account used as a default for transaction record creation.	AR98.1
#`ARU-TERMS-CD` TERMS_CD	Alpha 5	Default terms code to be used for invoicing for this customer.	AR98.1
#`ARU-TERMS-CASH` TERMS_CASH	Signed 18.2	This field contains the cash paid amount from fully paid transactions. At the end of a current period it will be used to calculate DBT (Days Beyond Terms)	—
#`ARU-TERMS-CSH-DAYS` TERMS_CSH_DAYS	Signed 18.2	This field contains the flow of funds cash days calculated value (paid amount multiplied by the number of days from due date to fully pay) for the current period.	—
#`ARU-DBT-RATIO` DBT_RATIO	Signed 3.0 Occurs 11 Times ×11	Days Beyond Terms indicator for this period. Used in customer credit analysis.	AR98.1
#`ARU-DBT-PR-YR` DBT_PR_YR	Signed 3.0	Last year's Days Beyond Terms indicator.	AR98.1
#`ARU-DBT-YTD-CASH` DBT_YTD_CASH	Signed 18.2	This field contains the cash paid amount for fully paid transactions for the year.	AR98.1
#`ARU-DBT-YTD-DAYS` DBT_YTD_DAYS	Signed 18.2	The running total of the year's Flow of Funds Cash Days calculated value (paid invoice amount multiplied by the number of days from due date to fully paid).	AR98.1
#`ARU-LATE-PAY-FL` LATE_PAY_FL	Alpha 1	Late payment flag. It will indicate if finance charges and/or late payment charges will be calculated. Valid values are: payment charges `B` Both finance charges and late `F` Finance charges only `L` Late payment charges only `Blank` No charges	AR98.1
#`ARU-FIN-CALC-TYPE` FIN_CALC_TYPE	Alpha 1	Determines the method of finance charge calculations. Valid values are: `D` Detail per open item finance `charges N` Net balance finance charges	AR98.1
#`ARU-FIN-CHRG-CD` FIN_CHRG_CD	Alpha 2	Finance charge code containing a percentage rate used for finance charge calculations.	AR98.1
#`ARU-FIN-GRAC-DAYS` FIN_GRAC_DAYS	Numeric 2	The number of grace days added to due date before finance charges will be assessed.	AR98.1
#`ARU-FIN-MIN-CHRG` FIN_MIN_CHRG	Signed 7.2	The minimum finance charge amount assessed if calculated finance charge is less than minimum. If the minimum amount is zero, there will be no override.	AR98.1
#`ARU-FIN-DOC-PRNT` FIN_DOC_PRNT	Alpha 1	Specifies whether or not finance charge documents are required to be printed. Valid values are: printed `N` No finance charge documents `required Y` Finance charge documents	AR98.1
#`ARU-LAST-DUNN` LAST_DUNN	Numeric 2	The last dunning letter number produced for the customer.	—
#`ARU-LAST-DUN-DATE` LAST_DUN_DATE	Numeric 8 (yyyymmdd)	The date of the last dunning letter produced for this customer.	—
#`ARU-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Used by the Lawson Order Entry system. Determines whether this customer is tax exempt or not. Valid values are: `E` Exempt `T` Taxable	AR98.1
#`ARU-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. Optionally required. If Tax Exempt Code value = "T" and using a 3rd party tax system, tax code is optional. If Tax Exempt Code system, tax code is required. `value` "T" and using the Lawson tax	AR98.1
#`ARU-TERRITORY` TERRITORY	Alpha 4	Sales Territory.	AR98.1
#`ARU-AGING-CODE` AGING_CODE	Numeric 2	Aging code providing aging rules for a single customer aging.	—
#`ARU-REVALUE-FL` REVALUE_FL	Alpha 1	Default revalue indicator for non-base currency transactions. Valid values are: `N` No revaluation `Y` Revalue	AR98.1
#`ARU-DISHONORED` DISHONORED	Signed 5.0	This field contains the total number of dishonored Bills of Exchange since the customer was added.	—
#`ARU-DISHONORED-AMT` DISHONORED_AMT	Signed 18.2	This field contains the total amount of dishonored Bills of Exchange that has accumulated since the customer was added.	—
#`ARU-RECONCILE-CASH` RECONCILE_CASH	Signed 5.0	This field will give a count of the number of dishonored Bills of Exchange that have been reconciled with the customer paying in cash for the dishonored BOE.	—
#`ARU-RECONCILE-RNEG` RECONCILE_RNEG	Signed 5.0	This field will give a count of total number of dishonored Bills of Exchange that have been renegotiated.	—
#`ARU-RECONCILE-WO` RECONCILE_WO	Signed 5.0	This field will give a total count of dishonored Bills of Exchange that have been written off as a bad debt.	—
#`ARU-NAME` NAME	Alpha 30 (Lower Case)	Customer name. Required.	AR98.1
#`ARU-ADDR1` ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR98.1
#`ARU-ADDR2` ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR98.1
#`ARU-ADDR3` ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR98.1
#`ARU-ADDR4` ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	AR98.1
#`ARU-CITY` CITY	Alpha 18 (Lower Case)	This field contains the city of the address.	AR98.1
#`ARU-STATE` STATE	Alpha 2	This field contains the two-character state or province code of the address.	AR98.1
#`ARU-ZIP` ZIP	Alpha 10	This field contains the postal code of the address.	AR98.1
#`ARU-COUNTY` COUNTY	Alpha 25 (Lower Case)	This field contains the county of the address.	AR98.1
#`ARU-DUNN-CD` DUNN_CD	Alpha 3	Dun and Bradstreet rating code.	AR98.1
#`ARU-DUNN-DATE` DUNN_DATE	Numeric 8 (yyyymmdd)	The date the Dunn Code was established.	AR98.1
#`ARU-LAST-DUN-AMT` LAST_DUN_AMT	Signed 18.2	The date o fthe last dunning letter produced for the customer.	—
#`ARU-DUNN-NUMBER` DUNN_NUMBER	Numeric 9	The Dunn and Bradstreet cross reference number for this customer.	AR98.1
#`ARU-OVR-ADDR-FL` OVR_ADDR_FL	Alpha 1	Used by the Lawson Order Entry system for one time customers. Valid values are: `N` No address override allowed `Y` Address override allowed	—
#`ARU-TAX-ID` TAX_ID	Alpha 20	Tax identification number.	—
#`ARU-ORDER-LIM-GRP` ORDER_LIM_GRP	Signed 15.0	Order limit amount for the total amount of open orders at the customer group level for all companies.	AR98.1
#`ARU-CRED-LIM-GRP` CRED_LIM_GRP	Signed 15.0	Credit limit at the customer group level for all companies.	AR98.1
#`ARU-HOLD-CODE-GRP` HOLD_CODE_GRP	Alpha 4	Hold code at the customer group level.	AR98.1
#`ARU-TITLE` TITLE	Alpha 30 (Lower Case)	Contact title.	AR98.1
#`ARU-NAT-COMPANY` NAT_COMPANY	Numeric 4	National account company for this customer. Must be entered if a national account customer is entered.	AR98.1
#`ARU-NAT-CUSTOMER` NAT_CUSTOMER	Alpha 9 (Right Justified)	National account customer for this customer. Must be entered if a national account company is entered.	AR98.1
#`ARU-CUST-USER1` CUST_USER1	Alpha 10	Customer 1 user field	AR98.1
#`ARU-CUST-USER2` CUST_USER2	Alpha 18	Customer 2 user field.	AR98.1
#`ARU-CUST-USER3` CUST_USER3	Signed 18.2	Customer user 3 field.	AR98.1
#`ARU-CUST-USER4` CUST_USER4	Signed 18.2	Customer user 4 field.	AR98.1
#`ARU-CUST-USER5` CUST_USER5	Numeric 9	Customer user 5 field.	AR98.1
#`ARU-CUST-USER6` CUST_USER6	Alpha 30	Customer user 6 field.	AR98.1
#`ARU-CUST-USER7` CUST_USER7	Alpha 30	Customer user 7 field.	AR98.1
#`ARU-CUST-USER8` CUST_USER8	Numeric 8 (yyyymmdd)	Customer user 8 field. Date format, YYYYMMDD.	AR98.1
#`ARU-CUST-USER9` CUST_USER9	Numeric 3	Customer user 9 field.	AR98.1
#`ARU-CUST-USER10` CUST_USER10	Alpha 3	Customer user 10 field.	AR98.1
#`ARU-MINIMUM` MINIMUM	Alpha 1	Determines if minimum finance charges are assessed. Valid values are amount is less than minimum amount. less than minimum amount. If minimum amount is blank, then calculated amount is charged. `Y` Use minimum amount if calculated `N` No charge if calculated amount is	AR98.1
#`ARU-FIN-CYCLE` FIN_CYCLE	Alpha 2	Finance charge cycle code.	AR98.1
#`ARU-DUN-CYCLE` DUN_CYCLE	Alpha 2	Dunning cycle code.	AR98.1
#`ARU-AUTO-METHOD` AUTO_METHOD	Alpha 1	Automatic cash application method. Valid values are: `A` Algorithm `B` Balance forward `L` Last statement `R` Remittance	AR98.1
#`ARU-AUTO-REMOVE` AUTO_REMOVE	Alpha 1	— `N` No `Y` Yes	—
#`ARU-CB-DTL-DATE` CB_DTL_DATE	Alpha 1	This field will determine which dates are used in calculating the transaction and due dates of detail chargebacks. `I` Invoice `P` Payment	AR98.1
#`ARU-VAT-REG-CTRY` VAT_REG_CTRY	Alpha 2	The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.	AR98.1
#`ARU-VAT-REG-NBR` VAT_REG_NBR	Alpha 12	The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.	AR98.1
#`ARU-VAT-CUST-TYPE` VAT_CUST_TYPE	Alpha 2	The VAT customer type.	AR98.1
#`ARU-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	The language code (locale) representing the conversion customer's preferred language. If no language code is specified, then U.S. English is assumed. NOTE spaces indicate U.S. English. First define the Language Code using the Lawson utility "locdef". Then define the Language Code via GL19.1 (Language Code Maintenance).	AR98.1
#`ARU-BANK-ENTITY` BANK_ENTITY	Alpha 15	Represents a bank institution location.	AR98.1
#`ARU-BANK-ACCT-NBR` BANK_ACCT_NBR	Alpha 35	The bank-assigned account number identification to be used for the cash code.	AR98.1
#`ARU-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	AR98.1
#`ARU-REGION` REGION	Alpha 2	The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)	AR98.1
#`ARU-DUN-LTR-IND` DUN_LTR_IND	Alpha 1	Specifies whether the advanced dunning letter process is to be used.	AR98.1
#`ARU-DUN-PROCESS-CD` DUN_PROCESS_CD	Alpha 6	Dunning letter process code. A unique code that represents a combination of Dunning Letter options.	AR98.1
#`ARU-ASSESS-DUN-FEE` ASSESS_DUN_FEE	Alpha 1	Specifies whether to assess a dunning letter fee.	AR98.1
#`ARU-CU-NAME` CU_NAME	Alpha 30	Credit Union Name.	AR98.1
#`ARU-CU-ADDR1` CU_ADDR1	Alpha 30 (Lower Case)	Credit Union Address Line 1.	AR98.1
#`ARU-CU-ADDR2` CU_ADDR2	Alpha 30 (Lower Case)	Credit Union Address Line 2.	AR98.1
#`ARU-CU-ADDR3` CU_ADDR3	Alpha 30 (Lower Case)	Credit union address line 3.	AR98.1
#`ARU-CU-ADDR4` CU_ADDR4	Alpha 30 (Lower Case)	Credit union address line 4.	AR98.1
#`ARU-CU-CITY` CU_CITY	Alpha 18 (Lower Case)	Credit Union City.	AR98.1
#`ARU-CU-STATE` CU_STATE	Alpha 2	Credit Union State.	AR98.1
#`ARU-CU-POSTAL-CODE` CU_POSTAL_CODE	Alpha 12	Credit Union Postal Code.	AR98.1
#`ARU-CU-COUNTRY-CD` CU_COUNTRY_CD	Alpha 2	Credit Union Country Code.	AR98.1
#`ARU-THIRD-PARTY` THIRD_PARTY	Alpha 1	This field indicates if this customer's payments may be applied to any customer's open transactions. `N` No third party payment `Y` Third party payment allowed	AR98.1
#`ARU-FILLER99` FILLER99	Alpha 99	Used for table splitting considerations.	—
#`ARU-USR-FLD-01` USR_FLD_01	Alpha 20	Extra user field 1.	AR98.1
#`ARU-USR-FLD-02` USR_FLD_02	Alpha 20	Extra user field 2.	AR98.1
#`ARU-USR-FLD-03` USR_FLD_03	Alpha 20	Extra user field 3.	AR98.1
#`ARU-USR-FLD-04` USR_FLD_04	Alpha 20	Extra user field 4.	AR98.1
#`ARU-USR-FLD-05` USR_FLD_05	Alpha 20	Extra user field 5.	AR98.1
#`ARU-E-MAIL-ADDRESS` E_MAIL_ADDRESS	Alpha 60 (Lower Case)	Email address of customer.	AR98.1
#`ARU-URL-ADDR` URL_ADDR	Alpha 60 (Lower Case)	URL address of customer.	AR98.1
#`ARU-CUST-AUDIT` CUST_AUDIT	Alpha 1	This field indicates if customer changes will be audited. Valid values are: `N` No changes audited `Y` Changes audited	AR501, AR98.1
#`ARU-APPLY-MIXED` APPLY_MIXED	Alpha 1	This field indicates if transactions with mixed signed line items will have credit lines applied to debit lines upon transaction interface and transaction release.	AR98.1
#`ARU-RIBKEY` RIBKEY	Numeric 2	This field contains the Ribkey value for the bank account number.	AR98.1
#`ARU-VBANK-IDENT` VBANK_IDENT	Alpha 1	This field indicates if the bank account number is an IBAN number that requires an account validation check.	AR98.1
#`ARU-BANK-TRAN-CD` BANK_TRAN_CD	Alpha 2	This field contains the bank transaction code for the bank account number.	—
#`ARU-MX-TMPLT-NAME` MX_TMPLT_NAME	Alpha 12	This field contains the user-defined MX system template name that this customer may have initial data values derived from. This enbales this customer to be part of a customer list for reporting purposes.	AR98.1
#`ARU-PAY-AUTO-AMT` PAY_AUTO_AMT	Signed 18.2	—	AR98.1
#`ARU-PAY-AUTO-PCT` PAY_AUTO_PCT	Signed 5.5	—	AR98.1
#`ARU-PAY-REAS-CD` PAY_REAS_CD	Alpha 4	—	AR98.1
#`ARU-MULT-DUN-LTR` MULT_DUN_LTR	Alpha 1	" " `N` No `Y` Yes	AR98.1
#`ARU-CU-COUNTY` CU_COUNTY	Alpha 25 (Lower Case)	—	AR98.1
#`ARU-LEGAL-NAME` LEGAL_NAME	Alpha 80 (Lower Case)	The legal name for customers that contain the city and/or county information on it.	AR98.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ARUSET1`	`COMPANY` `CUSTOMER`	Primary		AR501, AR98.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (1) — lookups and parents

Relation Table Rules Condition Field map

Arccust2

ARCCUST2

Required

`ARU-COMPANY`	→	`AR2-COMPANY`
`ARU-CUSTOMER`	→	`AR2-CUSTOMER`

Programs

Updated by (2)

AR501 Customer Conversion
AR98.1 Conversion Customer

ARCCUST – AR Customer Conversion

About ARCCUST

Fields (174) Copy as SQL

Indexes (1)

Relations

One to one (1) — lookups and parents

Programs

Updated by (2)

Fields (174)