Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCCUST


                              ARCCUST FILE

                         AR Customer Conversion

The AR Customer Conversion file is used to convert customer records from an
external source. Records in this file have been populated from an external
source and will be loaded into the Accounts Receivable system via AR501
(Customer Conversion).

Field data populated into this file may be accessed and maintained in program
AR98 (Conversion Customer).

UPDATED BY

AR501     AR98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARU-COMPANY            Numeric 4                                 AR98.1
Element: Company       The number representing an AR company.

ARU-CUSTOMER           Alpha 9  (Right Justified)                AR98.1
Element: Customer      Required. Customer number.

ARU-ACTIVE-STATUS      Alpha 1                                   AR98.1
Element: Customer StatuCustomer 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

ARU-SEARCH-NAME        Alpha 30                                  AR98.1
Element: Search Name   Search name assigned to this customer
                       for search and sorting capabilities.
                       Defaults from customer name if not
                       present.

ARU-HOLD-CODE          Alpha 4                                   AR98.1
Element: Hold Code     Hold code assessed to this customer.

ARU-CONTACT            Alpha 20                                  AR98.1
Element: Primary ContacName of the primary contact.

ARU-INT-PREFIX         Alpha 6                                   AR98.1
Element: International International telephone prefix.

ARU-PHONE-NMBR         Alpha 15                                  AR98.1
Element: Telephone NumbTelephone number.

ARU-PHONE-EXT          Alpha 5                                   AR98.1
Element: Telephone ExteThis field contains the telephone
                       extension number.

ARU-TELEX-NBR          Alpha 15                                  AR98.1
Element: Telex Number  Phone number.

ARU-EDI-NBR            Alpha 15                                  AR98.1
Element: EDI Number    Electronic Data Interchange number.

ARU-ALT-EDI-NBR        Alpha 95                                  AR98.1
Element: Alternate EDI This is a free-form field to
                       accommodate an alternate EDI number or
                       electronic address.

ARU-ALT-EDI-TYPE       Alpha 5                                   AR98.1
Element: Alternate EDI Indicates the type of the alternate EDI
                       number.

ARU-FAX-NMBR           Alpha 15                                  AR98.1
Element: Fax Number    Fax number.

ARU-FAX-EXT            Alpha 5                                   AR98.1
Element: Fax Extension This field contains the telephone
                       extension number.

ARU-START-DATE         Numeric 8  (yyyymmdd)                     AR98.1
Element: Start Date    Origin date or starting date of
                       business with this customer.

ARU-CREDIT-ANLYST      Alpha 4                                   AR98.1
Element: Credit AnalystCredit analyst code assigned to this
                       customer. If left blank, will default
                       from customer defaults code.

ARU-CURRENCY-CD        Alpha 5                                   AR98.1
Element: Currency Code Customer default invoice currency code.

ARU-SALESMAN           Numeric 4                                 AR98.1
Element: SalesRep      This field contains the code that
                       represents the primary sales
                       representative for this customer. If
                       left blank, this defaults from the
                       customer defaults code.

ARU-RISK-CD            Alpha 1                                   AR98.1
Element: Risk Code     User-defined risk code used for
                       customer reporting selections. If left
                       blank, company defined risk code will
                       default.

ARU-DEFAULT-CODE       Alpha 5                                   AR98.1
Element: Default Code  Customer default code. Required.

ARU-MAJ-CLASS          Alpha 4                                   AR98.1
Element: Major Class   Major class used for customer reporting
                       and processing for this customer. If
                       left blank, will default from customer
                       default code.

ARU-MIN-CLASS          Alpha 4                                   AR98.1
Element: Minor Class   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.

ARU-OPEN-ORDS          Signed 18.2                               AR98.1
Element: Total Open OrdTotal amount of open orders for this
                       customer. Must be a positive amount.

ARU-ORDER-LIM          Signed 15.0                               AR98.1
Element: Open Order LimOrder limit amount for the total amount
                       of open orders for this customer.

ARU-CREDIT-LIM         Signed 15.0                               AR98.1
Element: Credit Limit  Total amount of credit for this
                       customer.

ARU-CREDIT-LIM-DAT     Numeric 8  (yyyymmdd)                     AR98.1
Element: Credit Limit DThe date the credit limit was
                       established. System date will default if
                       left blank.

ARU-CREDIT-REVDAYS     Signed 3.0                                AR98.1
Element: Credit Review Number of days that determine the
                       intervals between credit limit reviews.

ARU-LAST-PMT-AMT       Signed 18.2                               AR98.1
Element: Last Payment AAmount of last payment in company base
                       currency.

ARU-LAST-PMT-DATE      Numeric 8  (yyyymmdd)                     AR98.1
Element: Last Payment DDate of last payment to this company
                       for this customer.

ARU-LAST-INV-DATE      Numeric 8  (yyyymmdd)                     AR98.1
Element: Last Invoice DLast invoice date.

ARU-LAST-INV-AMT       Signed 18.2                               AR98.1
Element: Intl Amt

ARU-LAST-STA-DATE      Numeric 8  (yyyymmdd)                     AR98.1
Element: Last StatementDate of last statement for this
                       customer.

ARU-LAST-STA-BAL       Signed 18.2                               AR98.1
Last Statement         Last statement balance for this
Balance                customer in company base currency.

ARU-REVIEW-DATE        Numeric 8  (yyyymmdd)                     AR98.1
Element: Review Date   Last date the customer was set for
                       review. System date defaults if left
                       blank.

ARU-REVIEW-CODE        Alpha 1                                   AR98.1
Element: Review Code   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

ARU-HIGH-BAL           Signed 15.0 Occurs 13 Times               AR98.1
Highest Customer       Highest customer balance for this
Balance                company for this period.

ARU-PER-RTMS           Signed 3.0 Occurs 13 Times
Element: Period RTMs   Period return-to-maker payment
                       occurrences.

ARU-PAID-PRMPT         Signed 5.0 Occurs 12 Times
Element: Paid Prompt   The number of invoices paid prompt for
                       this period. Invoices cleared by
                       chargebacks are not considered.

ARU-INV-PAID           Signed 5.0 Occurs 12 Times
Element: Paid Invoices 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       Signed 3.0 Occurs 11 Times                AR98.1
Element: Collect Days  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.

ARU-CURR-CASH          Signed 18.2
Element: Current Cash  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      Signed 18.2
Element: Current Cash DThis 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           Signed 18.2                               AR98.1
Element: YTD Cash      Year to date total of cash for fully
                       paid transactions.

ARU-YTD-CSH-DAYS       Signed 18.2                               AR98.1
Element: YTD Cash Days Year to date calculation of cash paid
                       and applied to an open item multiplied
                       by the number of days to fully pay the
                       transactions.

ARU-YEAR-2-DAYS        Signed 3.0                                AR98.1
Element: Previous Year Weighted invoice payment average for
                       the year previous to the totals being
                       summed in Collect Days occurrences.

ARU-STATIC-CUR         Signed 18.2
Element: Current StaticStatic aged current portion of a
                       customer's balance.

ARU-AGING              Signed 18.2 Occurs 5 Times
Element: Aging         Static aged past due amounts in company
                       base currency for this customer.

ARU-AGE-DISPUTES       Alpha 1                                   AR98.1
Element: Age Disputes  Specifies how disputed invoices will be
                       aged. Valid values are:

                       N = Not aged - aged in current column
                       Y = Age respective to date

ARU-DISPUTES-FIN       Alpha 1                                   AR98.1
Element: Finance DisputSpecifies if disputed invoices are
                       exempt from being assessed finance
                       charges. Valid values are:

                       Y = Finance charges on disputed items
                       N = No finance charges on disputed
                       items

ARU-AUTO-APP-FL        Alpha 1                                   AR98.1
Element: Auto ApplicatiAutomatic cash application indicator.
                       Valid values are:

                       N = Not subject to automatic
                       application
                       Y = Subject to automatic application

ARU-AUTO-DUNN-FL       Alpha 1                                   AR98.1
Element: Auto Dunning  Indicates whether or not automatic
                       selection of dunning letters will be
                       allowed. Valid values are:

                       N = No automatic dunning
                       Y = Automatic dunning

ARU-DISC-GRACE-PD      Numeric 2                                 AR98.1
Discount Grace         Grace days added to discount date to
Period                 allow or disallow discount during cash
                       application.

ARU-CR-VAR-PCT         Numeric 3                                 AR98.1
Credit Variance        Override percent used for customer
Percent                credit limit selections.

ARU-MEMO-TERM          Alpha 5                                   AR98.1
Element: Memo Terms CodMemo terms code. Must be a valid
                       net or prepayment type terms code
                       defined in the Lawson Terms system.

ARU-CHRGBK-PRT-FL      Alpha 1                                   AR98.1
Element: Print ChargebaSpecifies whether chargebacks will be
                       printed. Valid values are:

                       N = Do not print chargebacks
                       Y = Print chargebacks

ARU-OPEN-BAL-FWD       Alpha 1                                   AR98.1
Open Item - Balance    Processing of receivable records by
Forward                either open item or balance forward
                       methods. Valid values are:

                       B = Balance forward processing
                       O = Open item processing

ARU-STATEMENT-REQ      Alpha 1                                   AR98.1
Element: Statement RequStatement required option. Valid values
                       are:

                       N = No statements required
                       Y = Statements required

ARU-STMNT-CYCLE        Alpha 2                                   AR98.1
Element: Statement CyclStatement cycle code used to group
                       customers for statement processing.

ARU-LOCK-BOX           Alpha 2                                   AR98.1
Element: Lock Box      Remit to location for payment receipts.
                       If left blank, the company address will
                       be used.

ARU-ZERO-STMNT-FL      Alpha 1                                   AR98.1
Element: Zero StatementDetermines 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

ARU-CRED-STMNT-FL      Alpha 1                                   AR98.1
Element: Credit StatemeDetermines 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

ARU-PAST-STMNT-FL      Alpha 1                                   AR98.1
Element: Past Due StatePast due open items only statements.
                       Valid values are:

                       N = No open item only past due
                       statements
                       Y = Open item only past due statements

ARU-OVER-STMNT-FL      Alpha 1                                   AR98.1
Credit Exceeded        Over credit limit statement option.
Statements             Valid values are:

                       N = No only balance exceeding credit
                       limit statements.
                       Y = Produce only balance exceeding
                       credit limit statements.

ARU-MAX-AUTO-AMT       Signed 18.2 Occurs 3 Times                AR98.1
Maximum Automatic      Maximum open item shortage amount
Amount                 during cash application that may be
                       automatically written off. Multiple
                       amounts must be in ascending order.


ARU-MAX-AUTO-PCT       Signed 5.5 Occurs 3 Times                 AR98.1
Maximum Automatic      Maximum open item percentage amount
Percent                during cash application that may be
                       automatically written off.  Multiple
                       percentages must be in ascending order.

ARU-AUTO-REAS-CD       Alpha 4 Occurs 3 Times                    AR98.1
Automatic Reason       This reason code is required if there
Code                   is a shortage amount or shortage
                       percentage entered.

ARU-DISC-REAS-CD       Alpha 4                                   AR98.1
Element: Discount ReasoDefault discount reason code for earned
                       discounts during cash application.

ARU-BANK-INST-CODE     Alpha 3                                   AR98.1
Element: Payment Code  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.

ARU-DRAFT-FLAG         Alpha 1                                   AR98.1
Bill of Exchange       If the customer has a bill of exchange
Flag                   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

ARU-AR-CODE            Alpha 4                                   AR98.1
Accounts Receivable    Accounts receivable general ledger
Code                   account used as a default for
                       transaction record creation.

ARU-TERMS-CD           Alpha 5                                   AR98.1
Element: Terms Code    Default terms code to be used for
                       invoicing for this customer.

ARU-TERMS-CASH         Signed 18.2
Element: Paid Amount   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     Signed 18.2
Element: Paid Cash DaysThis 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          Signed 3.0 Occurs 11 Times                AR98.1
Element: DBT Ratio     Days Beyond Terms indicator for this
                       period.  Used in customer credit
                       analysis.


ARU-DBT-PR-YR          Signed 3.0                                AR98.1
Element: Previous Year Last year's Days Beyond Terms
                       indicator.

ARU-DBT-YTD-CASH       Signed 18.2                               AR98.1
Element: YTD Cash Paid This field contains the cash paid
                       amount for fully paid transactions for
                       the year.

ARU-DBT-YTD-DAYS       Signed 18.2                               AR98.1
Element: YTD Cash Days 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).

ARU-LATE-PAY-FL        Alpha 1                                   AR98.1
Element: Late Payment FLate payment flag. It will indicate if
                       finance charges and/or late payment
                       charges will be calculated. Valid values
                       are:

                       B = Both finance charges and late
                       payment charges
                       F = Finance charges only
                       L = Late payment charges only
                       Blank = No charges

ARU-FIN-CALC-TYPE      Alpha 1                                   AR98.1
Finance Calculation    Determines the method of finance charge
Type                   calculations. Valid values are:

                       D = Detail per open item finance
                       charges N = Net balance finance charges

ARU-FIN-CHRG-CD        Alpha 2                                   AR98.1
Element: Finance ChargeFinance charge code containing a
                       percentage rate used for finance charge
                       calculations.

ARU-FIN-GRAC-DAYS      Numeric 2                                 AR98.1
Element: Finance Grace The number of grace days added to due
                       date before finance charges will be
                       assessed.

ARU-FIN-MIN-CHRG       Signed 7.2                                AR98.1
Minimum Finance        The minimum finance charge amount
Charge                 assessed if calculated finance charge is
                       less than minimum. If the minimum amount
                       is zero, there will be no override.

ARU-FIN-DOC-PRNT       Alpha 1                                   AR98.1
Print Finance          Specifies whether or not finance charge
Charge Documents       documents are required to be printed.
                       Valid values are:

                       N = No finance charge documents
                       required Y = Finance charge documents
                       printed

ARU-LAST-DUNN          Numeric 2
Element: Last Dunning  The last dunning letter number produced
                       for the customer.

ARU-LAST-DUN-DATE      Numeric 8  (yyyymmdd)
Element: Last Dunning DThe date of the last dunning letter
                       produced for this customer.

ARU-TAX-EXEMPT-CD      Alpha 1                                   AR98.1
Element: Tax Exempt CodUsed by the Lawson Order Entry system.
                       Determines whether this customer is tax
                       exempt or not. Valid values are:

                       E = Exempt
                       T = Taxable

ARU-TAX-CODE           Alpha 10                                  AR98.1
Element: Tax Code      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
                       value = "T" and using the Lawson tax
                       system, tax code is required.

ARU-TERRITORY          Alpha 4                                   AR98.1
Element: Sales TerritorSales Territory.

ARU-AGING-CODE         Numeric 2
Element: Aging Code    Aging code providing aging rules for a
                       single customer aging.

ARU-REVALUE-FL         Alpha 1                                   AR98.1
Element: Revalue Flag  Default revalue indicator for non-base
                       currency transactions. Valid values are:

                       N = No revaluation
                       Y = Revalue

ARU-DISHONORED         Signed 5.0
Element: Dishonored BOEThis field contains the total number of
                       dishonored Bills of Exchange since the
                       customer was added.

ARU-DISHONORED-AMT     Signed 18.2
Dishonored BOE         This field contains the total amount of
Amount                 dishonored Bills of Exchange that has
                       accumulated since the customer was
                       added.

ARU-RECONCILE-CASH     Signed 5.0
Element: Reconcile CashThis 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     Signed 5.0
Reconcile              This field will give a count of total
Renegotiations         number of dishonored Bills of Exchange
                       that have been renegotiated.

ARU-RECONCILE-WO       Signed 5.0
Element: Reconcile WritThis field will give a total count of
                       dishonored Bills of Exchange that have
                       been written off as a bad debt.

ARU-NAME               Alpha 30  (Lower Case)                    AR98.1
Element: Customer Name Customer name. Required.

ARU-ADDR1              Alpha 30  (Lower Case)                    AR98.1
Element: Address 1     This field contains the first line of
                       address information.

ARU-ADDR2              Alpha 30  (Lower Case)                    AR98.1
Element: Address 2     This field contains the first line of
                       address information.

ARU-ADDR3              Alpha 30  (Lower Case)                    AR98.1
Element: Address 3     This field contains the first line of
                       address information.

ARU-ADDR4              Alpha 30  (Lower Case)                    AR98.1
Element: Address 4     This field contains the first line of
                       address information.

ARU-CITY               Alpha 18  (Lower Case)                    AR98.1
Element: City          This field contains the city of the
                       address.

ARU-STATE              Alpha 2                                   AR98.1
Element: State or ProviThis field contains the two-character
                       state or province code of the address.

ARU-ZIP                Alpha 10                                  AR98.1
Element: Postal Code   This field contains the postal code of
                       the address.






ARU-COUNTY             Alpha 25  (Lower Case)                    AR98.1
Element: County        This field contains the county of the
                       address.

ARU-DUNN-CD            Alpha 3                                   AR98.1
Dun and Bradstreet     Dun and Bradstreet rating code.
Code

ARU-DUNN-DATE          Numeric 8  (yyyymmdd)                     AR98.1
Dunn and Bradstreet    The date the Dunn Code was established.
Date

ARU-LAST-DUN-AMT       Signed 18.2
Element: Intl Amt      The date o fthe last dunning letter
                       produced for the customer.

ARU-DUNN-NUMBER        Numeric 9                                 AR98.1
Dunn and Bradstreet    The Dunn and Bradstreet cross reference
Number                 number for this customer.

ARU-OVR-ADDR-FL        Alpha 1
Override Address       Used by the Lawson Order Entry system
Flag                   for one time customers. Valid values
                       are:

                       N = No address override allowed
                       Y = Address override allowed

ARU-TAX-ID             Alpha 20
Element: Tax ID        Tax identification number.

ARU-ORDER-LIM-GRP      Signed 15.0                               AR98.1
Element: Group Order LiOrder limit amount for the total amount
                       of open orders at the customer group
                       level for all companies.

ARU-CRED-LIM-GRP       Signed 15.0                               AR98.1
Element: Group Credit LCredit limit at the customer group
                       level for all companies.

ARU-HOLD-CODE-GRP      Alpha 4                                   AR98.1
Element: Group Hold CodHold code at the customer group level.

ARU-TITLE              Alpha 30  (Lower Case)                    AR98.1
Element: Contact Title Contact title.

ARU-NAT-COMPANY        Numeric 4                                 AR98.1
National Account       National account company for this
Company                customer. Must be entered if a national
                       account customer is entered.

ARU-NAT-CUSTOMER       Alpha 9  (Right Justified)                AR98.1
National Account       National account customer for this
Customer               customer. Must be entered if a national
                       account company is entered.

ARU-CUST-USER1         Alpha 10                                  AR98.1
Element: Customer User Customer 1 user field

ARU-CUST-USER2         Alpha 18                                  AR98.1
Element: Customer User Customer 2 user field.

ARU-CUST-USER3         Signed 18.2                               AR98.1
Element: Customer User Customer user 3 field.

ARU-CUST-USER4         Signed 18.2                               AR98.1
Element: Customer User Customer user 4 field.

ARU-CUST-USER5         Numeric 9                                 AR98.1
Element: Customer User Customer user 5 field.

ARU-CUST-USER6         Alpha 30                                  AR98.1
Element: Customer User Customer user 6 field.

ARU-CUST-USER7         Alpha 30                                  AR98.1
Element: Customer User Customer user 7 field.

ARU-CUST-USER8         Numeric 8  (yyyymmdd)                     AR98.1
Element: Customer User Customer user 8 field.  Date format,
                       YYYYMMDD.

ARU-CUST-USER9         Numeric 3                                 AR98.1
Element: Customer User Customer user 9 field.

ARU-CUST-USER10        Alpha 3                                   AR98.1
Element: Customer User Customer user 10 field.

ARU-MINIMUM            Alpha 1                                   AR98.1
Minimum Finance        Determines if minimum finance charges
Charges                are assessed.

                       Valid values are

                       Y = Use minimum amount if calculated
                       amount is less than minimum amount.
                       N = No charge if calculated amount is
                       less than minimum amount.  If minimum
                       amount is blank, then calculated amount
                       is charged.

ARU-FIN-CYCLE          Alpha 2                                   AR98.1
Finance Charge         Finance charge cycle code.
Cycle Code

ARU-DUN-CYCLE          Alpha 2                                   AR98.1
Element: Dunning Cycle Dunning cycle code.

ARU-AUTO-METHOD        Alpha 1                                   AR98.1
Auto Cash              Automatic cash application method.
Application Method     Valid values are:

                       A = Algorithm
                       B = Balance forward
                       L = Last statement
                       R = Remittance

ARU-AUTO-REMOVE        Alpha 1
Element: Auto Remove   N = No
                       Y = Yes

ARU-CB-DTL-DATE        Alpha 1                                   AR98.1
Element: Cb Dtl Date   This field will determine which dates
                       are used in calculating the transaction
                       and due dates of detail chargebacks.
                       I = Invoice
                       P = Payment

ARU-VAT-REG-CTRY       Alpha 2                                   AR98.1
Element: Vat Reg Ctry  The country component of the VAT
                       Registration Number. This field,
                       together with the Registration Number
                       for the company on the tax transaction.

ARU-VAT-REG-NBR        Alpha 12                                  AR98.1
Element: Vat Reg Nbr   The number component of the VAT
                       Registration Number. This field together
                       with the Registration Country field make
                       up the VAT Registration Number.

ARU-VAT-CUST-TYPE      Alpha 2                                   AR98.1
Element: Vat Cust Type The VAT customer type.

ARU-LANGUAGE-CODE      Alpha 10                                  AR98.1
Element: Language Code 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).

ARU-BANK-ENTITY        Alpha 15                                  AR98.1
Element: Bank Entity   Represents a bank institution location.

ARU-BANK-ACCT-NBR      Alpha 35                                  AR98.1
Element: Bank Acct Nbr The bank-assigned account number
                       identification to be used for the cash
                       code.

ARU-COUNTRY-CODE       Alpha 2                                   AR98.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

ARU-REGION             Alpha 2                                   AR98.1
Element: Region        The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

ARU-DUN-LTR-IND        Alpha 1                                   AR98.1
Element: Dun Ltr Ind   Specifies whether the advanced dunning
                       letter process is to be used.

ARU-DUN-PROCESS-CD     Alpha 6                                   AR98.1
Element: Dun Process CdDunning letter process code.  A unique
                       code that represents a combination of
                       Dunning Letter options.

ARU-ASSESS-DUN-FEE     Alpha 1                                   AR501   AR98.1
Element: Assess Dun FeeSpecifies whether to assess a dunning
                       letter fee.

ARU-CU-NAME            Alpha 30                                  AR98.1
Element: Cu Name       Credit Union Name.

ARU-CU-ADDR1           Alpha 30  (Lower Case)                    AR98.1
Element: Cu Addr1      Credit Union Address Line 1.

ARU-CU-ADDR2           Alpha 30  (Lower Case)                    AR98.1
Element: Cu Addr2      Credit Union Address Line 2.

ARU-CU-ADDR3           Alpha 30  (Lower Case)                    AR98.1
Element: Cu Addr3      Credit union address line 3.

ARU-CU-ADDR4           Alpha 30  (Lower Case)                    AR98.1
Element: Cu Addr4      Credit union address line 4.

ARU-CU-CITY            Alpha 18  (Lower Case)                    AR98.1
Element: Cu City       Credit Union City.

ARU-CU-STATE           Alpha 2                                   AR98.1
Element: Cu State      Credit Union State.

ARU-CU-POSTAL-CODE     Alpha 12                                  AR98.1
Element: Cu Postal CodeCredit Union Postal Code.

ARU-CU-COUNTRY-CD      Alpha 2                                   AR98.1
Element: Cu Country Cd Credit Union Country Code.

ARU-THIRD-PARTY        Alpha 1                                   AR98.1
Element: Third Party   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

ARU-FILLER99           Alpha 99
Element: Filler99      Used for table splitting considerations.

ARU-USR-FLD-01         Alpha 20                                  AR98.1
Element: Usr Fld 01    Extra user field 1.

ARU-USR-FLD-02         Alpha 20                                  AR98.1
Element: Usr Fld 02    Extra user field 2.

ARU-USR-FLD-03         Alpha 20                                  AR98.1
Element: Usr Fld 03    Extra user field 3.

ARU-USR-FLD-04         Alpha 20                                  AR98.1
Element: Usr Fld 04    Extra user field 4.

ARU-USR-FLD-05         Alpha 20                                  AR98.1
Element: Usr Fld 05    Extra user field 5.

ARU-E-MAIL-ADDRESS     Alpha 60  (Lower Case)                    AR98.1
Element: Email Address Email address of customer.

ARU-URL-ADDR           Alpha 60  (Lower Case)                    AR98.1
Element: Url Addr      URL address of customer.

ARU-CUST-AUDIT         Alpha 1                                   AR501   AR98.1
Element: Cust Audit    This field indicates if customer
                       changes will be audited.  Valid values
                       are:

                       N = No changes audited
                       Y = Changes audited

ARU-APPLY-MIXED        Alpha 1                                   AR98.1
Element: Apply Mixed   This field indicates if transactions
                       with mixed signed line items will have
                       credit lines applied to debit lines upon
                       transaction interface and transaction
                       release.

ARU-RIBKEY             Numeric 2                                 AR98.1
Element: Ribkey        This field contains the Ribkey value
                       for the bank account number.

ARU-VBANK-IDENT        Alpha 1                                   AR98.1
Element: Alphadata1    This field indicates if the  bank
                       account  number is an IBAN number that
                       requires  an account validation check.

ARU-BANK-TRAN-CD       Alpha 2
Element: Bank Tran Cd  This field contains the bank transaction
                       code for the bank account number.

ARU-MX-TMPLT-NAME      Alpha 12                                  AR98.1
Element: Mx Tmplt Name 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.

ARU-PAY-AUTO-AMT       Signed 18.2                               AR98.1
Element: Intl Amt

ARU-PAY-AUTO-PCT       Signed 5.5                                AR98.1
Element: Max Auto Pct

ARU-PAY-REAS-CD        Alpha 4                                   AR98.1
Element: Auto Reas Cd

                         ARCCUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARUSET1   COMPANY                                                AR501   AR98.1
          CUSTOMER