Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ARICST FILE

                         AR Interface Customer

The AR Interface Customer file is used to interface customer records from an
external system. Records in this file will be processed by AR550 (Customer
Interface).

UPDATED BY

AR550

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CUS-COMPANY          Numeric 4
Company              Required. Company number.

CUS-CUSTOMER         Alpha 9  (Right Justified)
Customer             Required. Customer number.

CUS-ACTION-CD        Alpha 1
Action Code          Action code to determine whether to
                     perform a change or add function. Valid
                     values are:

                     A = Add a customer
                     C = Change a customer

CUS-SEARCH-NAME      Alpha 30                                    AR550
Seach Name           Name used for customer searches.
                     Customer searches are conducted by
                     search name and display name.

CUS-NAME             Alpha 30  (Lower Case)                      AR550
Name                 Customer name. This name will appear on
                     screens and reports.

CUS-ADDR1            Alpha 30  (Lower Case)                      AR550
Address 1            The first line of address information.

CUS-ADDR1-CHG        Numeric 1
Address 1 Change     Address line 1 change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-ADDR2            Alpha 30  (Lower Case)                      AR550
Address 2            The second line of address information.

CUS-ADDR2-CHG        Numeric 1
Address 2 Change     Address line 2 change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-ADDR3            Alpha 30  (Lower Case)                      AR550
Address 3            Third line of address information.

CUS-ADDR3-CHG        Numeric 1
Address 3 Change     Address line 3 change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-ADDR4            Alpha 30  (Lower Case)                      AR550
Address 4            Fourth line of address information.

CUS-ADDR4-CHG        Numeric 1
Address 4 Change     Address line 4 change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-CITY             Alpha 18  (Lower Case)                      AR550
City                 City/province name.

CUS-CITY-CHG         Numeric 1
City Change          City/province change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-STATE            Alpha 2                                     AR550
State                This field contains the two-character
                     code of the state or province.

CUS-STATE-CHG        Numeric 1
State Change         State abbreviation change indicator.
                     Valid values are:

                     0 = No change
                     1 = Change this field

CUS-ZIP              Alpha 10                                    AR550
Postal Code          Postal code.

CUS-ZIP-CHG          Numeric 1
Postal Code Change   Postal code change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-COUNTRY          Alpha 30  (Lower Case)                      AR550
Country or Other     This field contains the country of the
                     address, or it can be used for
                     additional information such as an
                     attention name.

CUS-COUNTRY-CHG      Numeric 1
Country or Other     Country change indicator. Valid values
Change               are:

                     0 = No change
                     1 = Change this field

CUS-COUNTY           Alpha 25  (Lower Case)                      AR550
County               This field contains the county of the
                     address, or it can be used for
                     additional information such as an
                     attention name.

CUS-COUNTY-CHG       Numeric 1
County Change        County change indicator. Valid values
                     are:

                     0 = No change
                     1 = Change this field

CUS-CONTACT-GROUP    Alpha 20                                    AR550
Contact              Contact name for customer.

CUS-CONT-GROUP-CHG   Numeric 1
Contact Change       Contact name change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-TITLE            Alpha 30  (Lower Case)                      AR550
Contact Title        Contact name title.

CUS-TITLE-CHG        Numeric 1
Contact Title Change Contact name title change indicator.
                     Valid values are:

                     0 = No change
                     1 = Change this field

CUS-INT-PREFIX       Alpha 6                                     AR550
International        International telephone prefix.
Telephone Prefix

CUS-INT-PREFIX-CHG   Numeric 1
Intl Telephone       International telephone prefix change
Prefix Change        indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-PHONE-NMBR       Alpha 15                                    AR550
Telephone Number     Telephone number. Note: Use consistent
                     format since customer searches can be
                     done via telephone number.

CUS-PHONE-NMBR-CHG   Numeric 1
Telephone Number     Telephone number change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-PHONE-EXT        Alpha 5                                     AR550
Telephone Extension  Telephone extension number.

CUS-PHONE-EXT-CHG    Numeric 1
Telephone Extension  Telephone extension change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-DUNN-CD          Alpha 3                                     AR550
Dun and Bradstreet   Dun code, used to represent the Dun and
Code                 Bradstreet customer rating code.

CUS-DUNN-CD-CHG      Numeric 1
Dun and Bradstreet   Dun code change indicator. Valid values
Code Change          are:

                     0 = No change
                     1 = Change this field

CUS-DUNN-DATE        Numeric 8  (yyyymmdd)                       AR550
DB Rating Code Date  Dun and Bradstreet rating code date.

CUS-DUNN-DATE-CHG    Numeric 1
DB rating Code Date  Dun date change indicator. Valid values
Change               are:

                     0 = No change
                     1 = Change this field

CUS-DUNN-NUMBER      Numeric 9                                   AR550
Dun and Bradstreet   Dun and Bradstreet customer number.
Customer

CUS-DUNN-NBR-CHG     Numeric 1
DB Customer Change   Dun number change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-HOLD-CODE-GRP    Alpha 4                                     AR550
Hold Code            Hold code. Must be a valid hold code.

CUS-HC-GRP-CHG       Numeric 1
Hold Code Change     Hold code change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-ORDER-LIM-GRP    Signed 15.0                                 AR550
Order Limit          Order limit amount.

CUS-OL-GRP-CHG       Numeric 1
Order Limit Change   Order limit amount change indicator.
                     Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CREDIT-LIM-GRP   Signed 15.0                                 AR550
Credit Limit         Credit limit amount.

CUS-CL-GRP-CHG       Numeric 1
Credit Limit Change  Credit limit amount change indicator.
                     Valid values are:

                     0 = No change
                     1 = Change this field

CUS-OVR-ADDR-FL      Alpha 1                                     AR550
Address Override     Address override flag. Used for Order
                     Entry processing

CUS-TAX-ID           Alpha 20                                    AR550
Tax ID               Customer tax identification number.

CUS-TAX-ID-CHG       Numeric 1
Tax ID Change        Customer tax identification number
                     change indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-ACTIVE-STATUS    Alpha 1                                     AR550
Active Status        The status of a customer record. Valid
                     values are:

                     A = Active - Default
                     I = Inactive - Prevents invoicing
                     D = Set for deletion

CUS-SEARCH-NAME2     Alpha 30                                    AR550
Search Name 2        Company customer search name.

CUS-HOLD-CODE        Alpha 4                                     AR550
Hold Code            Hold code. Must be a valid hold code.

CUS-HOLD-CODE-CHG    Numeric 1
Hold Code Change     Hold code change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-CONTACT          Alpha 20                                    AR550
Primary Contact      This is the name of the main contact.

CUS-CONTACT-CHG      Numeric 1
Primary Contact      Customer contact change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-INT-PREFIX2      Alpha 6                                     AR550
Intl Telephone       Company customer international
Prefix 2             telephone number.

CUS-INT-PRFIX2-CHG   Numeric 1
Intl Telephone       Company customer international
Prefix 2             telephone prefix change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-PHONE-NMBR2      Alpha 15                                    AR550
Telephone Number 2   Company customer telephone number.

CUS-PHN-NMBR2-CHG    Numeric 1
Telephone Number 2   Company customer telephone number
Change               change indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-PHONE-EXT2       Alpha 5                                     AR550
Telephone Extension  Company customer telephone number
2                    extension.

CUS-PHONE-EXT2-CHG   Numeric 1
Telephone Extension  Company customer telephone extension
2 Change             number change indicator. Valid values
                     are:

                     0 = No change
                     1 = Change this field

CUS-TELEX-NBR        Alpha 15                                    AR550
Telex Number         Telex number.

CUS-TELEX-NBR-CHG    Numeric 1
Telex Number Change  Telex number change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-EDI-NBR          Alpha 15                                    AR550
EDI Number           EDI number.

CUS-FAX-NMBR         Alpha 15                                    AR550
Fax Number           Fax number

CUS-FAX-NMBR-CHG     Numeric 1
Fax Number Change    Fax number change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-FAX-EXT          Alpha 5                                     AR550
Fax Number Extension Fax number extension.

CUS-FAX-EXT-CHG      Numeric 1
Fax Number           Fax number extension change indicator.
Extension Change     Valid values are:

                     0 = No change
                     1 = Change this field

CUS-START-DATE       Numeric 8  (yyyymmdd)                       AR550
Start Date           Start or origination date of customer.

CUS-CREDIT-ANLYST    Alpha 4                                     AR550
Credit Analyst       Credit analyst code. Must be a valid
                     credit analyst.

CUS-CURRENCY-CD      Alpha 5                                     AR550
Currency Code        Default invoice currency code.

CUS-SALESMAN         Numeric 4                                   AR550
SalesRep             Sales representative. Must be a valid
                     salesrep.

CUS-RISK-CD          Alpha 1                                     AR550
Risk Code            Risk code.

CUS-RISK-CD-CHG      Numeric 1
Risk Code Change     Risk code change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-DEFAULT-CODE     Alpha 5                                     AR550
Default Code         Default code. Must be a valid default
                     code.

CUS-NAT-COMPANY      Numeric 4
National Company     National account company.

CUS-NAT-CUSTOMER     Alpha 9  (Right Justified)
National Customer    National account customer

CUS-CUST-USER1       Alpha 10                                    AR550
Customer User 1      Customer user1 field.

CUS-CUST-USER1-CHG   Numeric 1
Customer User 1      Customer user1 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER2       Alpha 18                                    AR550
Customer User 2      Customer user2 field.

CUS-CUST-USER2-CHG   Numeric 1
Customer User 2      Customer user2 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER3       Signed 15.2                                 AR550
Customer User 3      Customer user3 field

CUS-CUST-USER3-CHG   Numeric 1
Customer User 3      Customer user3 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER4       Signed 15.2                                 AR550
Customer User 4      Customer user4 field

CUS-CUST-USER4-CHG   Numeric 1
Customer User 4      Customer user4 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER5       Numeric 9                                   AR550
Customer User 5      Customer user5 field

CUS-CUST-USER5-CHG   Numeric 1
Customer User 5      Customer user5 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER6       Alpha 30                                    AR550
Customer User 6      Customer user6 field

CUS-CUST-USER6-CHG   Numeric 1
Customer User 6      Customer user6 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER7       Alpha 30                                    AR550
Customer User 7      Customer user7 field

CUS-CUST-USER7-CHG   Numeric 1
Customer User 7      Customer user7 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER8       Numeric 8  (yyyymmdd)                       AR550
Customer User 8      Customer user8 field

CUS-CUST-USER8-CHG   Numeric 1
Customer User 8      Customer user8 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER9       Numeric 3                                   AR550
Customer User 9      Customer user9 field

CUS-CUST-USER9-CHG   Numeric 1
Customer User 9      Customer user9 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CUST-USER10      Alpha 3                                     AR550
Customer User 10     Customer user10 field

CUS-CUST-USR10-CHG   Numeric 1
Customer User 10     Customer user10 field change indicator.
Change               Valid values are:

                     0 = No change
                     1 = Change this field

CUS-MAJ-CLASS        Alpha 4                                     AR550
Major Class          Major class code. Must be a valid major
                     class.

CUS-MIN-CLASS        Alpha 4                                     AR550
Minor Class          Minor class code. Must be a valid minor
                     class.

CUS-ORDER-LIM        Signed 15.0                                 AR550
Order Limit          Company customer order limit amount.

CUS-ORDER-LIM-CHG    Numeric 1
Order Limit Change   Company customer order limit amount
                     change indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CREDIT-LIM       Signed 15.0                                 AR550
Credit Limit         The credit limit amount for this
                     customer.

CUS-CREDIT-LIM-CHG   Numeric 1
Credit Limit Change  Company customer credit limit amount
                     change indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-CREDIT-LIM-DAT   Numeric 8  (yyyymmdd)                       AR550
Credit Limit Date    Credit limit date.

CUS-CREDIT-REVDAYS   Signed 3.0                                  AR550
Credit Limit Review  Credit limit review days.
Days

CUS-AGE-DISPUTES     Alpha 1                                     AR550
Age Disputes         Age disputes indicator. Valid values
                     are:

                     N = Disputes in current column
                     Y = Age disputed items

CUS-DISPUTES-FIN     Alpha 1                                     AR550
Disputes Financed    Disputed items subject to finance
                     charges indicator. Valid values are:

                     N = Not subject to finance charges
                     Y = Subject to finance charges

CUS-AUTO-APP-FL      Alpha 1                                     AR550
Auto Application     Automatic cash application indicator.
                     Valid values are:

                     N = Not subject to auto cash
                     application Y = Subject to auto cash
                     application

CUS-AUTO-DUNN-FL     Alpha 1                                     AR550
Auto Dunning         Automatic dunning notice indicator.
                     Valid values are:

                     N = Not subject to auto dunning
                     Y = Subject to auto dunning

CUS-DISC-GRACE-PD    Numeric 2                                   AR550
Discount Grace       Discount grace days. This value will be
Period               added to an invoice's discount date for
                     comparison to payment date.

CUS-CR-VAR-PCT       Numeric 3                                   AR550
Credit Override      Override percent that will be used in
                     customer credit limit selections.

CUS-MEMO-TERM        Alpha 5                                     AR550
Memo Terms Code      Memo terms code. Must be a valid terms
                     code in the Lawson Terms system.

CUS-CHRGBK-PRT-FL    Alpha 1                                     AR550
Print Chargebacks    Chargeback printing indicator. Valid
                     values are:

                     N = Do not print chargeback documents
                     Y = Print chargeback documents

CUS-OPEN-BAL-FWD     Alpha 1                                     AR550
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

CUS-DISC-REAS-CD     Alpha 4                                     AR550
Discount Reason Code Discount reason code for use in
                     automatic and manual cash application.
                     Must be a valid adjustment reason code.

CUS-STATEMENT-REQ    Alpha 1                                     AR550
Statement Required   Statement required option. Valid values
                     are:

                     N = Do not create statements
                     Y = Create statements

CUS-STMNT-CYCLE      Alpha 2                                     AR550
Statement Cycle      Allows grouping of customers for
                     producing statements that have a like
                     statement cycle code. Must be a valid
                     statement cycle code.
                     This field value will be assigned when
                     adding balance forward customers if
                     statement required flag = Y. This field
                     is required for open item type customers
                     if statement required flag = Y.

CUS-LOCK-BOX         Alpha 2                                     AR550
Lock Box             This is the remit-to location if a lock
                     box is being used for payment receipts.
                     Must be a valid lock box code.

CUS-LOCK-BOX-CHG     Numeric 1
Lox Box Change       Lock box change indicator. Valid values
                     are:

                     0 = No change
                     1 = Change this field

CUS-ZERO-STMNT-FL    Alpha 1                                     AR550
Zero Statement       Zero balance statement option. Valid
                     values are:

                     N = Do not create zero statements
                     Y = Create zero balance statements

CUS-CRED-STMNT-FL    Alpha 1                                     AR550
Credit Statement     Credit balance statement option. Valid
                     values are:

                     N = Do not create credit bal statement
                     Y = Create credit balance statement

CUS-PAST-STMNT-FL    Alpha 1                                     AR550
Past Due Statement   Past due open items only statement
                     option. Valid values are:

                     N = No past due only statements
                     Y = Create only past due statements

CUS-OVER-STMNT-FL    Alpha 1                                     AR550
Over Credit Limit    Over credit limit statement option.
                     Valid values are:

                     N = No credit limit balance checking
                     Y = Statement only if balance is
                     greater than credit limit

CUS-MAX-AUTO-AMT     Signed 15.2 Occurs 3 Times                  AR550
Maximum Automatic    The maximum amount a payment may be
Amount               short of a single invoice during cash
                     application, and the system will
                     automatically write-off the difference
                     to the default reason code associated
                     with this amount. Must be ascending
                     amounts.

CUS-MAX-AUTO-PCT     Signed 5.5 Occurs 3 Times                   AR550
Maximum Automatic    The maximum percentage allowed shortage
Percent              for a single invoice that will
                     automatically be adjusted during cash
                     application. Percentages must be in
                     ascending order.

CUS-AUTO-REAS-CD     Alpha 4 Occurs 3 Times                      AR550
Automatic Reason     This reason code is required if there
Code                 is a short amount or percent allowed for
                     automatic adjustments.

CUS-AUTO-CHG         Numeric 1
Automatic Change     Automatic adjustment reason code change
                     indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-TERMS-CD         Alpha 5                                     AR550
Terms Code           Default terms code. Must be a valid
                     terms code.

CUS-LATE-PAY-FL      Alpha 1                                     AR550
Late Payment         Late Payment flag. Indicates if late
                     payment charges will be calculated.
                     Valid values are:

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

CUS-FIN-CALC-TYPE    Alpha 1                                     AR550
Finance Charge Type  Finance charge type indicator. Valid
                     values are:

                     D = Detail (per invoice) calculation
                     N = Net balance calculation

CUS-FIN-CHRG-CD      Alpha 2                                     AR550
Finance Charge Code  Finance charge code. Must be a valid
                     finance charge code.

CUS-FIN-GRAC-DAYS    Numeric 2                                   AR550
Finance Charge       The number of grace days to be added to
Grace Period         due date before finance charges will be
                     assessed.

CUS-FIN-GRC-DY-CHG   Numeric 1
Fin. Charge Grace    Finance grace days change indicator.
Per. Change          Valid values are:

                     0 = No change
                     1 = Change this field

CUS-FIN-MIN-CHRG     Signed 7.2                                  AR550
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.

CUS-FIN-MIN-CG-CHG   Numeric 1
Minimum Finance      Finance minimum charge amount change
Charge Code          indicator. Valid values are:

                     0 = No change
                     1 = Change this amount

CUS-FIN-DOC-PRNT     Alpha 1                                     AR550
Print Finance        Finance charge print document
Charge Documents     indicator. Valid values are:

                     N = No finance charge documents printed
                     Y = Print finance charge document

CUS-TERRITORY        Alpha 4                                     AR550
Sales Territory      Territory code. Must be a valid
                     territory code.

CUS-AGING-CODE       Numeric 2                                   AR550
Aging Code           Aging code used in a single customer
                     aging.

CUS-AGING-CODE-CHG   Numeric 1
Aging Code Change    Aging code change indicator. Valid
                     values are:

                     0 = No change
                     1 = Change this field

CUS-BANK-INST-CODE   Alpha 3                                     AR550
Payment Code         This is a user-defined value
                     representing a specific banking
                     transaction. There are three categories
                     of bank transactions: cash payments,
                     bill of exchange payments, and
                     miscellaneous non-payment bank
                     transactions.

CUS-AR-CODE          Alpha 4                                     AR550
Account Receivable   The default accounts receivable code
Code                 for transaction processing.

CUS-DRAFT-FLAG       Alpha 1                                     AR550
Bill of Exchange     If the customer has a default payment
Flag                 code type of D (Bill of Exchange), this
                     flag will indicate if the bills of
                     exchange should be created in summary or
                     individually (1 BOE for 1 Invoice).
                     Valid values are:

                     Blank = Not paying by BOE, Default
                     I = Individual
                     S = Summary

CUS-MINIMUM          Alpha 1                                     AR550
Minimum Finance      Used to determine if minimum finance
Charge               charges are to be used.  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.
                     Blank = Finance amount on detail

CUS-MINIMUM-CHG      Numeric 1
Minimum Finance      Minimum  finance charge change
Charge Type          indicator. Valid values are:

                     0 = No change
                     1 = Change this field

CUS-FIN-CYCLE        Alpha 2                                     AR550
Finance Charge       Finance charge cycle code.
Cycle Code

CUS-DUN-CYCLE        Alpha 2
Dunning Cycle Code   Dunning cycle code.

CUS-AUTO-METHOD      Alpha 1                                     AR550
Auto Cash            Automatic cash application method.
Application Method

CUS-ALT-EDI-NBR      Alpha 95
Alternate EDI Number This is a free-form field to
                     accommodate an alternate EDI number or
                     address.

CUS-ALT-EDI-TYPE     Alpha 5
Alternate EDI Type   The type of alternate EDI number
                     entered for the customer.

CUS-TAX-EXEMPT-CD    Alpha 1                                     AR550
Tax Exempt Code      Determines whether a customer is tax
                     exempt or not. Valid values are:

                     T = Taxable
                     E = Exempt

CUS-TAX-CODE         Alpha 10                                    AR550
Tax Code             User-defined code which identifies the
                     default taxing authority this customer
                     pays taxes to. Must be a valid tax code
                     in the Lawson Tax or 3rd party tax
                     system.  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.

CUS-AUTO-REMOVE      Alpha 1                                     AR550
Auto Remove          N = No
                     Y = Yes

CUS-CB-DTL-DATE      Alpha 1                                     AR550
Cb Dtl Date          This field will determine which dates
                     are to be used in calculating
                     transaction and due dates for detail
                     chargebacks.
                     I = Invoice
                     P = Payment

CUS-VAT-REG-CTRY     Alpha 2
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.


CUS-VAT-R-CTRY-CHG   Numeric 1
Vat R Ctry Chg       The VAT Registration Country change
                     indicator. Valid values are:

                     0 = No change
                     1 = Change this code

CUS-VAT-REG-NBR      Alpha 12
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.

CUS-VAT-R-NBR-CHG    Numeric 1
Vat R Nbr Chg        The VAT Registration Number change
                     indicator.  Values are:

                     0 = No change
                     1 = Change this number

CUS-VAT-CUST-TYPE    Alpha 2
Vat Cust Type        The VAT customer type.

CUS-BANK-ENTITY      Alpha 15
Bank                 Represents a bank institution location.


CUS-BANK-ACCT-NBR    Alpha 17
Bank Account Number  The bank-assigned account number
                     identification to be used for the cash
                     code.


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


CUS-COUNTRY-CD-CHG   Numeric 1
Country Cd Chg       The country coe change indicator.
                     Values are:
                     0 = No
                     1 = Change this code

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

CUS-REGION-CHG       Numeric 1
Region Chg           The region code changed indicator. Valid
                     values are:
                     0 = No change
                     1 = Change this code

CUS-DUN-LTR-IND      Alpha 1                                     AR550
Dun Ltr Ind          Specifies whether the advanced dunning
                     letter process is to be used.


CUS-DUN-LTR-IND-CH   Numeric 1
Dun Ltr Ind Ch       0 = No Change
                     1 = Change this field

CUS-DUN-PROCESS-CD   Alpha 6                                     AR550
Dun Process Cd       Dunning letter process code.  A unique
                     code that represents a combination of
                     Dunning Letter options.


CUS-DUN-PROC-CD-CH   Numeric 1
Dun Proc Cd Ch       0 = No change
                     1 = Change this field

CUS-LANGUAGE-CODE    Alpha 10                                    AR550
Language Code        Language Code (LOCALE).

CUS-LANG-CODE-CHG    Numeric 1
Lang Code Chg        0 = No change
                     1 = Change this field

CUS-ASSESS-DUN-FEE   Alpha 1                                     AR550
Assess Dun Fee       Specifies whether to assess a dunning
                     letter fee.


CUS-DUN-FEE-CHG      Numeric 1
Dun Fee Chg          0 = No change
                     1 = Change this field

CUS-CU-NAME          Alpha 30                                    AR550
Cu Name              Credit Union Name.

CUS-CU-NAME-CHG      Numeric 1
Cu Name Chg          0 = No change
                     1 = Change this field

CUS-CU-ADDR1         Alpha 30  (Lower Case)                      AR550
Cu Addr1             Credit Union Address Line 1.

CUS-CU-ADDR1-CHG     Numeric 1
Cu Addr1 Chg         0 = No change
                     1 = Change this field

CUS-CU-ADDR2         Alpha 30  (Lower Case)                      AR550
Cu Addr2             Credit Union Address Line 2.

CUS-CU-ADDR2-CHG     Numeric 1
Cu Addr2 Chg         0 = No change
                     1 = Change this field

CUS-CU-ADDR3         Alpha 30  (Lower Case)                      AR550
Cu Addr3             Credit union address line 3.

CUS-CU-ADDR3-CHG     Numeric 1
Cu Addr3 Chg         0 = No change
                     1 = Change this field

CUS-CU-ADDR4         Alpha 30  (Lower Case)                      AR550
Cu Addr4             Credit union address line 4.

CUS-CU-ADDR4-CHG     Numeric 1
Cu Addr4 Chg         0 = No change
                     1 = Change this field

CUS-CU-CITY          Alpha 18  (Lower Case)                      AR550
Cu City              Credit Union City.

CUS-CU-CITY-CHG      Numeric 1
Cu City Chg          0 = No change
                     1 = Change this field

CUS-CU-STATE         Alpha 2                                     AR550
Cu State             Credit Union State.

CUS-CU-STATE-CHG     Numeric 1
Cu State Chg

CUS-CU-POSTAL-CODE   Alpha 12                                    AR550
Cu Postal Code       Credit Union Postal Code.

CUS-CU-POST-CD-CHG   Numeric 1
Cu Post Cd Chg       0 = No change
                     1 = Change this field

CUS-CU-COUNTRY       Alpha 30  (Lower Case)                      AR550
Cu Country           Credit Union Country.

CUS-CU-CTRY-CHG      Numeric 1
Cu Ctry Chg          0 = No change
                     1 = Change this field

CUS-CU-COUNTRY-CD    Alpha 2                                     AR550
Cu Country Cd        Credit Union Country Code.

CUS-CU-CTRY-CD-CHG   Numeric 1
Cu Ctry Cd Chg       0 = No change
                     1 = Change this field

CUS-THIRD-PARTY      Alpha 1                                     AR550
Third Party          N = No third party payment
                     Y = Third party payment allowed

CUS-USR-FLD-01       Alpha 20                                    AR550
Usr Fld 01

CUS-UF01-CHG         Numeric 1
Uf01 Chg

CUS-USR-FLD-02       Alpha 20                                    AR550
Usr Fld 02

CUS-UF02-CHG         Numeric 1
Uf02 Chg

CUS-USR-FLD-03       Alpha 20                                    AR550
Usr Fld 03

CUS-UF03-CHG         Numeric 1
Uf03 Chg

CUS-USR-FLD-04       Alpha 20                                    AR550
Usr Fld 04

CUS-UF04-CHG         Numeric 1
Uf04 Chg

CUS-USR-FLD-05       Alpha 20                                    AR550
Usr Fld 05

CUS-UF05-CHG         Numeric 1
Uf05 Chg

CUS-E-MAIL-ADDRESS   Alpha 60  (Lower Case)                      AR550
E Mail Address

CUS-E-MAIL-CHG       Alpha 1
E Mail Chg

CUS-URL-ADDR         Alpha 60  (Lower Case)                      AR550
Url Addr

CUS-URL-ADDR-CHG     Alpha 1
Url Addr Chg

                         ARICST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CUSSET1   COMPANY       The path is used to keep the records     AR550
          CUSTOMER      unique.
          ACTION-CD     KeyChange