ARICST

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) and may be maintained by AR96 Interface Customer.
UPDATED BY
AR550

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUS-COMPANY
Element: Company
Numeric 4
Required. Company number.
CUS-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Required. Customer number.
CUS-ACTION-CD
Element: Action Code
Alpha 1
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
Element: Seach Name
Alpha 30
Name used for customer searches. Customer searches are conducted by search name and display name.
AR550
CUS-NAME
Element: Name
Alpha 30 (Lower Case)
Customer name. This name will appear on screens and reports.
AR550
CUS-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
The first line of address information.
AR550
CUS-ADDR1-CHG
Element: Address 1 Change
Numeric 1
Address line 1 change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
The second line of address information.
AR550
CUS-ADDR2-CHG
Element: Address 2 Change
Numeric 1
Address line 2 change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
Third line of address information.
AR550
CUS-ADDR3-CHG
Element: Address 3 Change
Numeric 1
Address line 3 change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
Fourth line of address information.
AR550
CUS-ADDR4-CHG
Element: Address 4 Change
Numeric 1
Address line 4 change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CITY
Element: City
Alpha 18 (Lower Case)
City/province name.
AR550
CUS-CITY-CHG
Element: City Change
Numeric 1
City/province change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-STATE
Element: State
Alpha 2
This field contains the two-character code of the state or province.
AR550
CUS-STATE-CHG
Element: State Change
Numeric 1
State abbreviation change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ZIP
Element: Postal Code
Alpha 10
Postal code.
AR550
CUS-ZIP-CHG
Element: Postal Code Change
Numeric 1
Postal code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-COUNTY
Element: County
Alpha 25 (Lower Case)
This field contains the county of the address, or it can be used for additional information such as an attention name.
AR550
CUS-COUNTY-CHG
Element: County Change
Numeric 1
County change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CONTACT-GROUP
Element: Contact
Alpha 20
Contact name for customer.
AR550
CUS-CONT-GROUP-CHG
Element: Contact Change
Numeric 1
Contact name change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-TITLE
Element: Contact Title
Alpha 30 (Lower Case)
Contact name title.
AR550
CUS-TITLE-CHG
Element: Contact Title Change
Numeric 1
Contact name title change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-INT-PREFIX
International
Telephone Prefix
Alpha 6
International telephone prefix.
AR550
CUS-INT-PREFIX-CHG
Intl Telephone
Prefix Change
Numeric 1
International telephone prefix change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-PHONE-NMBR
Element: Telephone Number
Alpha 15
Telephone number. Note: Use consistent format since customer searches can be done via telephone number.
AR550
CUS-PHONE-NMBR-CHG
Telephone Number
Change
Numeric 1
Telephone number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-PHONE-EXT
Element: Telephone Extension
Alpha 5
Telephone extension number.
AR550
CUS-PHONE-EXT-CHG
Telephone Extension
Change
Numeric 1
Telephone extension change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-DUNN-CD
Dun and Bradstreet
Code
Alpha 3
Dun code, used to represent the Dun and Bradstreet customer rating code.
AR550
CUS-DUNN-CD-CHG
Dun and Bradstreet
Code Change
Numeric 1
Dun code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-DUNN-DATE
Element: DB Rating Code Date
Numeric 8 (yyyymmdd)
Dun and Bradstreet rating code date.
AR550
CUS-DUNN-DATE-CHG
DB rating Code Date
Change
Numeric 1
Dun date change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-DUNN-NUMBER
Dun and Bradstreet
Customer
Numeric 9
Dun and Bradstreet customer number.
AR550
CUS-DUNN-NBR-CHG
Element: DB Customer Change
Numeric 1
Dun number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-HOLD-CODE-GRP
Element: Hold Code
Alpha 4
Hold code. Must be a valid hold code.
AR550
CUS-HC-GRP-CHG
Element: Hold Code Change
Numeric 1
Hold code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ORDER-LIM-GRP
Element: Order Limit
Signed 15.0
Order limit amount.
AR550
CUS-OL-GRP-CHG
Element: Order Limit Change
Numeric 1
Order limit amount change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CREDIT-LIM-GRP
Element: Credit Limit
Signed 15.0
Credit limit amount.
AR550
CUS-CL-GRP-CHG
Element: Credit Limit Change
Numeric 1
Credit limit amount change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-OVR-ADDR-FL
Element: Address Override
Alpha 1
Address override flag. Used for Order Entry processing
AR550
CUS-TAX-ID
Element: Tax ID
Alpha 20
Customer tax identification number.
AR550
CUS-TAX-ID-CHG
Element: Tax ID Change
Numeric 1
Customer tax identification number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of a customer record. Valid values are: A = Active - Default I = Inactive - Prevents invoicing D = Set for deletion
AR550
CUS-SEARCH-NAME2
Element: Search Name 2
Alpha 30
Company customer search name.
AR550
CUS-HOLD-CODE
Element: Hold Code
Alpha 4
Hold code. Must be a valid hold code.
AR550
CUS-HOLD-CODE-CHG
Element: Hold Code Change
Numeric 1
Hold code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CONTACT
Element: Primary Contact
Alpha 20
This is the name of the main contact.
AR550
CUS-CONTACT-CHG
Primary Contact
Change
Numeric 1
Customer contact change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-INT-PREFIX2
Intl Telephone
Prefix 2
Alpha 6
Company customer international telephone number.
AR550
CUS-INT-PRFIX2-CHG
Intl Telephone
Prefix 2
Numeric 1
Company customer international telephone prefix change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-PHONE-NMBR2
Element: Telephone Number 2
Alpha 15
Company customer telephone number.
AR550
CUS-PHN-NMBR2-CHG
Telephone Number 2
Change
Numeric 1
Company customer telephone number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-PHONE-EXT2
Telephone Extension
2
Alpha 5
Company customer telephone number extension.
AR550
CUS-PHONE-EXT2-CHG
Telephone Extension
2 Change
Numeric 1
Company customer telephone extension number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-TELEX-NBR
Element: Telex Number
Alpha 15
Telex number.
AR550
CUS-TELEX-NBR-CHG
Element: Telex Number Change
Numeric 1
Telex number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-EDI-NBR
Element: EDI Number
Alpha 15
EDI number.
AR550
CUS-FAX-NMBR
Element: Fax Number
Alpha 15
Fax number
AR550
CUS-FAX-NMBR-CHG
Element: Fax Number Change
Numeric 1
Fax number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-FAX-EXT
Element: Fax Number Extension
Alpha 5
Fax number extension.
AR550
CUS-FAX-EXT-CHG
Fax Number
Extension Change
Numeric 1
Fax number extension change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Start or origination date of customer.
AR550
CUS-CREDIT-ANLYST
Element: Credit Analyst
Alpha 4
Credit analyst code. Must be a valid credit analyst.
AR550
CUS-CURRENCY-CD
Element: Currency Code
Alpha 5
Default invoice currency code.
AR550
CUS-SALESMAN
Element: SalesRep
Numeric 4
Sales representative. Must be a valid salesrep.
AR550
CUS-RISK-CD
Element: Risk Code
Alpha 1
Risk code.
AR550
CUS-RISK-CD-CHG
Element: Risk Code Change
Numeric 1
Risk code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-DEFAULT-CODE
Element: Default Code
Alpha 5
Default code. Must be a valid default code.
AR550
CUS-NAT-COMPANY
Element: National Company
Numeric 4
National account company.
CUS-NAT-CUSTOMER
Element: National Customer
Alpha 9 (Right Justified)
National account customer
CUS-CUST-USER1
Element: Customer User 1
Alpha 10
Customer user1 field.
AR550
CUS-CUST-USER1-CHG
Customer User 1
Change
Numeric 1
Customer user1 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER2
Element: Customer User 2
Alpha 18
Customer user2 field.
AR550
CUS-CUST-USER2-CHG
Customer User 2
Change
Numeric 1
Customer user2 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER3
Element: Customer User 3
Signed 18.2
Customer user3 field
AR550
CUS-CUST-USER3-CHG
Customer User 3
Change
Numeric 1
Customer user3 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER4
Element: Customer User 4
Signed 18.2
Customer user4 field
AR550
CUS-CUST-USER4-CHG
Customer User 4
Change
Numeric 1
Customer user4 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER5
Element: Customer User 5
Numeric 9
Customer user5 field
AR550
CUS-CUST-USER5-CHG
Customer User 5
Change
Numeric 1
Customer user5 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER6
Element: Customer User 6
Alpha 30
Customer user6 field
AR550
CUS-CUST-USER6-CHG
Customer User 6
Change
Numeric 1
Customer user6 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER7
Element: Customer User 7
Alpha 30
Customer user7 field
AR550
CUS-CUST-USER7-CHG
Customer User 7
Change
Numeric 1
Customer user7 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER8
Element: Customer User 8
Numeric 8 (yyyymmdd)
Customer user8 field
AR550
CUS-CUST-USER8-CHG
Customer User 8
Change
Numeric 1
Customer user8 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER9
Element: Customer User 9
Numeric 3
Customer user9 field
AR550
CUS-CUST-USER9-CHG
Customer User 9
Change
Numeric 1
Customer user9 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CUST-USER10
Element: Customer User 10
Alpha 3
Customer user10 field
AR550
CUS-CUST-USR10-CHG
Customer User 10
Change
Numeric 1
Customer user10 field change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-MAJ-CLASS
Element: Major Class
Alpha 4
Major class code. Must be a valid major class.
AR550
CUS-MIN-CLASS
Element: Minor Class
Alpha 4
Minor class code. Must be a valid minor class.
AR550
CUS-ORDER-LIM
Element: Order Limit
Signed 15.0
Company customer order limit amount.
AR550
CUS-ORDER-LIM-CHG
Element: Order Limit Change
Numeric 1
Company customer order limit amount change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CREDIT-LIM
Element: Credit Limit
Signed 15.0
The credit limit amount for this customer.
AR550
CUS-CREDIT-LIM-CHG
Element: Credit Limit Change
Numeric 1
Company customer credit limit amount change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-CREDIT-LIM-DAT
Element: Credit Limit Date
Numeric 8 (yyyymmdd)
Credit limit date.
AR550
CUS-CREDIT-REVDAYS
Credit Limit Review
Days
Signed 3.0
Credit limit review days.
AR550
CUS-AGE-DISPUTES
Element: Age Disputes
Alpha 1
Age disputes indicator. Valid values are: N = Disputes in current column Y = Age disputed items
AR550
CUS-DISPUTES-FIN
Element: Disputes Financed
Alpha 1
Disputed items subject to finance charges indicator. Valid values are: N = Not subject to finance charges Y = Subject to finance charges
AR550
CUS-AUTO-APP-FL
Element: Auto Application
Alpha 1
Automatic cash application indicator. Valid values are: N = Not subject to auto cash application Y = Subject to auto cash application
AR550
CUS-AUTO-DUNN-FL
Element: Auto Dunning
Alpha 1
Automatic dunning notice indicator. Valid values are: N = Not subject to auto dunning Y = Subject to auto dunning
AR550
CUS-DISC-GRACE-PD
Discount Grace
Period
Numeric 2
Discount grace days. This value will be added to an invoice's discount date for comparison to payment date.
AR550
CUS-CR-VAR-PCT
Element: Credit Override
Numeric 3
Override percent that will be used in customer credit limit selections.
AR550
CUS-MEMO-TERM
Element: Memo Terms Code
Alpha 5
Memo terms code. Must be a valid terms code in the Lawson Terms system.
AR550
CUS-CHRGBK-PRT-FL
Element: Print Chargebacks
Alpha 1
Chargeback printing indicator. Valid values are: N = Do not print chargeback documents Y = Print chargeback documents
AR550
CUS-OPEN-BAL-FWD
Open Item/Balance
Forward
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
AR550
CUS-DISC-REAS-CD
Element: Discount Reason Code
Alpha 4
Discount reason code for use in automatic and manual cash application. Must be a valid adjustment reason code.
AR550
CUS-STATEMENT-REQ
Element: Statement Required
Alpha 1
Statement required option. Valid values are: N = Do not create statements Y = Create statements
AR550
CUS-STMNT-CYCLE
Element: Statement Cycle
Alpha 2
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.
AR550
CUS-LOCK-BOX
Element: Lock Box
Alpha 2
This is the remit-to location if a lock box is being used for payment receipts. Must be a valid lock box code.
AR550
CUS-LOCK-BOX-CHG
Element: Lox Box Change
Numeric 1
Lock box change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-ZERO-STMNT-FL
Element: Zero Statement
Alpha 1
Zero balance statement option. Valid values are: N = Do not create zero statements Y = Create zero balance statements
AR550
CUS-CRED-STMNT-FL
Element: Credit Statement
Alpha 1
Credit balance statement option. Valid values are: N = Do not create credit bal statement Y = Create credit balance statement
AR550
CUS-PAST-STMNT-FL
Element: Past Due Statement
Alpha 1
Past due open items only statement option. Valid values are: N = No past due only statements Y = Create only past due statements
AR550
CUS-OVER-STMNT-FL
Element: Over Credit Limit
Alpha 1
Over credit limit statement option. Valid values are: N = No credit limit balance checking Y = Statement only if balance is greater than credit limit
AR550
CUS-MAX-AUTO-AMT
Maximum Automatic
Amount
Signed 18.2 Occurs 3 Times
The maximum amount a payment may be 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.
AR550
CUS-MAX-AUTO-PCT
Maximum Automatic
Percent
Signed 5.5 Occurs 3 Times
The maximum percentage allowed shortage for a single invoice that will automatically be adjusted during cash application. Percentages must be in ascending order.
AR550
CUS-AUTO-REAS-CD
Automatic Reason
Code
Alpha 4 Occurs 3 Times
This reason code is required if there is a short amount or percent allowed for automatic adjustments.
AR550
CUS-AUTO-CHG
Element: Automatic Change
Numeric 1
Automatic adjustment reason code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-TERMS-CD
Element: Terms Code
Alpha 5
Default terms code. Must be a valid terms code.
AR550
CUS-LATE-PAY-FL
Element: Late Payment
Alpha 1
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
AR550
CUS-FIN-CALC-TYPE
Element: Finance Charge Type
Alpha 1
Finance charge type indicator. Valid values are: D = Detail (per invoice) calculation N = Net balance calculation
AR550
CUS-FIN-CHRG-CD
Element: Finance Charge Code
Alpha 2
Finance charge code. Must be a valid finance charge code.
AR550
CUS-FIN-GRAC-DAYS
Finance Charge
Grace Period
Numeric 2
The number of grace days to be added to due date before finance charges will be assessed.
AR550
CUS-FIN-GRC-DY-CHG
Fin. Charge Grace
Per. Change
Numeric 1
Finance grace days change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-FIN-MIN-CHRG
Minimum Finance
Charge
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.
AR550
CUS-FIN-MIN-CG-CHG
Minimum Finance
Charge Code
Numeric 1
Finance minimum charge amount change indicator. Valid values are: 0 = No change 1 = Change this amount
CUS-I-FIN-MIN-CHRG
Element: I Fin Min Chrg
Signed 7.2
Minimum finance charge amount for an invoice.
AR550
CUS-I-FIN-MIN-CHG
Element: I Fin Min Chg
Numeric 1
Finance minimum charge change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-FIN-DOC-PRNT
Print Finance
Charge Documents
Alpha 1
Finance charge print document indicator. Valid values are: N = No finance charge documents printed Y = Print finance charge document
AR550
CUS-TERRITORY
Element: Sales Territory
Alpha 4
Territory code. Must be a valid territory code.
AR550
CUS-AGING-CODE
Element: Aging Code
Numeric 2
Aging code used in a single customer aging.
AR550
CUS-AGING-CODE-CHG
Element: Aging Code Change
Numeric 1
Aging code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-BANK-INST-CODE
Element: Payment 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.
AR550
CUS-AR-CODE
Account Receivable
Code
Alpha 4
The default accounts receivable code for transaction processing.
AR550
CUS-DRAFT-FLAG
Bill of Exchange
Flag
Alpha 1
If the customer has a default payment 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
AR550
CUS-MINIMUM
Minimum Finance
Charge
Alpha 1
Used to determine if minimum finance 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
AR550
CUS-MINIMUM-CHG
Minimum Finance
Charge Type
Numeric 1
Minimum finance charge change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-FIN-CYCLE
Finance Charge
Cycle Code
Alpha 2
Finance charge cycle code.
AR550
CUS-DUN-CYCLE
Element: Dunning Cycle Code
Alpha 2
Dunning cycle code.
CUS-AUTO-METHOD
Auto Cash
Application Method
Alpha 1
Automatic cash application method.
AR550
CUS-ALT-EDI-NBR
Element: Alternate EDI Number
Alpha 95
This is a free-form field to accommodate an alternate EDI number or address.
CUS-ALT-EDI-TYPE
Element: Alternate EDI Type
Alpha 5
The type of alternate EDI number entered for the customer.
CUS-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Determines whether a customer is tax exempt or not. Valid values are: T = Taxable E = Exempt
AR550
CUS-TAX-CODE
Element: Tax Code
Alpha 10
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.
AR550
CUS-AUTO-REMOVE
Element: Auto Remove
Alpha 1

N = No
Y = Yes
AR550
CUS-CB-DTL-DATE
Element: Cb Dtl Date
Alpha 1
This field will determine which dates are to be used in calculating transaction and due dates for detail chargebacks.
I = Invoice
P = Payment
AR550
CUS-VAT-REG-CTRY
Element: 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.
AR550
CUS-VAT-R-CTRY-CHG
Element: Vat R Ctry Chg
Numeric 1
VAT country change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-VAT-REG-NBR
Element: 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.
AR550
CUS-VAT-R-NBR-CHG
Element: Vat R Nbr Chg
Numeric 1
VAT number change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-VAT-CUST-TYPE
Element: Vat Cust Type
Alpha 2
Indicates the type of customer for VAT reporting.
AR550
CUS-BANK-ENTITY
Element: Bank Entity
Alpha 15
Represents a bank institution location.
CUS-BANK-ACCT-NBR
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification for the related bank entity.
CUS-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR550
CUS-COUNTRY-CD-CHG
Element: Country Cd Chg
Numeric 1
Country code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
CUS-REGION-CHG
Element: Region Chg
Numeric 1
Region code change indicator. Valid values are: 0 = No change 1 = Change this field
CUS-DUN-LTR-IND
Element: Dun Ltr Ind
Alpha 1
Specifies whether the advanced dunning letter process is to be used.
AR550
CUS-DUN-LTR-IND-CH
Element: Dun Ltr Ind Ch
Numeric 1
Dunning letter change indicator. Valid values are:
0 = No Change
1 = Change this field
CUS-DUN-PROCESS-CD
Element: Dun Process Cd
Alpha 6
Dunning letter process code. A unique code that represents a combination of Dunning Letter options.
AR550
CUS-DUN-PROC-CD-CH
Element: Dun Proc Cd Ch
Numeric 1
Dunning process code change indicator. Valid values are:
0 = No change
1 = Change this field
CUS-LANGUAGE-CODE
Element: Language Code
Alpha 10
Language Code value.
AR550
CUS-LANG-CODE-CHG
Element: Lang Code Chg
Numeric 1
Language code change indicator. Valid values are:
0 = No change
1 = Change this field
CUS-ASSESS-DUN-FEE
Element: Assess Dun Fee
Alpha 1
Specifies whether to assess a dunning letter fee.
AR550
CUS-DUN-FEE-CHG
Element: Dun Fee Chg
Numeric 1
Assess dunning fee change indicator. Valid values are:
0 = No change
1 = Change this field
CUS-CU-NAME
Element: Cu Name
Alpha 30
Credit Union Name.
AR550
CUS-CU-NAME-CHG
Element: Cu Name Chg
Numeric 1
Credit Union Name change indicator. Valid values are:
0 = No change
1 = Change this field
CUS-CU-ADDR1
Element: Cu Addr1
Alpha 30 (Lower Case)
Credit Union Address Line 1.
AR550
CUS-CU-ADDR1-CHG
Element: Cu Addr1 Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-ADDR2
Element: Cu Addr2
Alpha 30 (Lower Case)
Credit Union Address Line 2.
AR550
CUS-CU-ADDR2-CHG
Element: Cu Addr2 Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-ADDR3
Element: Cu Addr3
Alpha 30 (Lower Case)
Credit union address line 3.
AR550
CUS-CU-ADDR3-CHG
Element: Cu Addr3 Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-ADDR4
Element: Cu Addr4
Alpha 30 (Lower Case)
Credit union address line 4.
AR550
CUS-CU-ADDR4-CHG
Element: Cu Addr4 Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-CITY
Element: Cu City
Alpha 18 (Lower Case)
Credit Union City.
AR550
CUS-CU-CITY-CHG
Element: Cu City Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-STATE
Element: Cu State
Alpha 2
Credit Union State.
AR550
CUS-CU-STATE-CHG
Element: Cu State Chg
Numeric 1
CUS-CU-POSTAL-CODE
Element: Cu Postal Code
Alpha 12
Credit Union Postal Code.
AR550
CUS-CU-POST-CD-CHG
Element: Cu Post Cd Chg
Numeric 1

0 = No change
1 = Change this field
CUS-CU-COUNTRY-CD
Element: Cu Country Cd
Alpha 2
Credit Union Country Code.
AR550
CUS-CU-CTRY-CD-CHG
Element: Cu Ctry Cd Chg
Numeric 1

0 = No change
1 = Change this field
CUS-THIRD-PARTY
Element: Third Party
Alpha 1

N = No third party payment
Y = Third party payment allowed
AR550
CUS-USR-FLD-01
Element: Usr Fld 01
Alpha 20
AR550
CUS-UF01-CHG
Element: Uf01 Chg
Numeric 1
CUS-USR-FLD-02
Element: Usr Fld 02
Alpha 20
AR550
CUS-UF02-CHG
Element: Uf02 Chg
Numeric 1
CUS-USR-FLD-03
Element: Usr Fld 03
Alpha 20
AR550
CUS-UF03-CHG
Element: Uf03 Chg
Numeric 1
CUS-USR-FLD-04
Element: Usr Fld 04
Alpha 20
AR550
CUS-UF04-CHG
Element: Uf04 Chg
Numeric 1
CUS-USR-FLD-05
Element: Usr Fld 05
Alpha 20
AR550
CUS-UF05-CHG
Element: Uf05 Chg
Numeric 1
CUS-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
Email address for this customer.
AR550
CUS-E-MAIL-CHG
Element: E Mail Chg
Alpha 1
CUS-URL-ADDR
Element: Url Addr
Alpha 60 (Lower Case)
URL address for this customer.
AR550
CUS-URL-ADDR-CHG
Element: Url Addr Chg
Alpha 1
CUS-CUST-AUDIT
Element: Cust Audit
Alpha 1
Indicates whether customer changes will be tracked. Valid values are: N = No customer audit Y = Customer audit
AR550
CUS-APPLY-MIXED
Element: Apply Mixed
Alpha 1
Indicates if transactions with mixed signed line items will have credit lines applied to debit lines upon transaction release or transaction interface. Valid values are: N = No Y = Yes
CUS-EFT-BNK-ENTITY
Element: Bank Entity
Alpha 15
Represents a bank institution location.
CUS-EFT-BNK-ACCT
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification.
CUS-EFT-RIBKEY
Element: Ribkey
Numeric 2
This field contains the EFT Ribkey value for the related bank account number.
CUS-EFT-VBNK-IDENT
Element: Alphadata1
Alpha 1
This field indicates if the bank account number is an IBAN number that requires an account validation check.
CUS-BNK-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
The start date for EFT selection for the associated bank account.
CUS-BNK-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for EFT selection for the associated bank acount.
CUS-BNK-PRENOTE
Element: Prenote
Numeric 8 (yyyymmdd)
This is the date the prenotification was sent to the customer for EFT processing.
CUS-FT-TYPE
Element: Ft Type
Alpha 1
This is the type of bank account. Valid values are: Blank = Debit and Credit account C = Credit Account D = Debit Account
CUS-BNK-PRE-NOTE
Element: Pre Note
Alpha 1
Indicates if sending a prenote for this bank account is required.
CUS-BNK-PRNT-STAT
Element: Prenote Status
Numeric 1
Status of the prenote for this bank account. Valid values are: 0 = Not Prenoted (default) 1 = Printed 9 = EFT record sent
CUS-CUST-ACCT-TYPE
Element: Cust Acct Type
Alpha 1
The type of account the customer has: C = Check S = Savings
CUS-RIBKEY
Element: Ribkey
Numeric 2
This field contains the Ribkey value for the bank account number.
CUS-CUST-PRE-NOTE
Element: Cust Pre Note
Alpha 1
Indicates if customers are prenotified of EFt transactions. Valid values are: N = No Y = Yes
CUS-CUST-NOTE-METH
Element: Cust Note Meth
Alpha 1
Indicates the method used to deliver pre or final EFT notification to a customer. A = Alternate EDI E = EDI F = Fax
CUS-ADJ-NOTE-METH
Element: Adj Note Meth
Alpha 1
The method used to deliver the EFT adjustment notification to the customer. Valid values are: A = Alterante EDI E = EDI F = Fax
CUS-USER1-FIELD
Element: User1 Field
Alpha 5
CUS-USER2-FIELD
Element: User2 Field
Alpha 10
CUS-PAYMENT-FORMAT
Element: Payment Format
Alpha 1
Determines the payment format of the file output for EFT transactions. Valid values are: A = ACH B = BACS N = Non formatted
S = SEPA
CUS-VBANK-IDENT
Element: Alphadata1
Alpha 1
CUS-BANK-TRAN-CD
Element: Bank Tran Cd
Alpha 2
This field contains the bank transaction code for the bank account number.
CUS-MX-TMPLT-NAME
Element: 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 enables this customer to be part of a customer list for reporting prposes.
CUS-PAY-AUTO-AMT
Element: Intl Amt
Signed 18.2
AR550
CUS-PAY-AUTO-PCT
Element: Max Auto Pct
Signed 5.5
AR550
CUS-PAY-REAS-CD
Element: Auto Reas Cd
Alpha 4
AR550
CUS-MLT-DUN-LT-CH
Element: Mlt Dun Lt Ch
Numeric 1
CUS-MULT-DUN-LTR
Element: Flag
Alpha 1
AR550
CUS-CU-COUNTY
Element: County
Alpha 25 (Lower Case)
AR550
CUS-LEGAL-NAME
Element: Legal Name
Alpha 80 (Lower Case)
The legal name for customers that contain the city and/or county information on it.
AR550
CUS-CU-COUNTY-CHG
Element: Auto Chg
Numeric 1
CUS-FOR-ECON-CODE
Element: Code
Alpha 10
CUS-CARRIER-FLAG
Element: All Flag
Alpha 1
CUS-CHK-DIG-TYPE
Element: Alpha 10
Alpha 10
AR550
CUS-CU-DIG-TY-CHG
Element: Auto Chg
Numeric 1
CUS-BIC-ID
Element: Swift Id
Alpha 12


ARICST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUSSET1 COMPANY
CUSTOMER
ACTION-CD
KeyChange
AR550


File created: Thu Jun 09 02:09:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.