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. |
|
||
CUS-NAME Element: Name | Alpha 30 (Lower Case) Customer name. This name will appear on screens and reports. |
|
||
CUS-ADDR1 Element: Address 1 | Alpha 30 (Lower Case) The first line of address information. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
CUS-TAX-ID Element: Tax ID | Alpha 20 Customer tax identification number. |
|
||
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 |
|
||
CUS-SEARCH-NAME2 Element: Search Name 2 | Alpha 30 Company customer search name. |
|
||
CUS-HOLD-CODE Element: Hold Code | Alpha 4 Hold code. Must be a valid hold code. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
CUS-FAX-NMBR Element: Fax Number | Alpha 15 Fax number |
|
||
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. |
|
||
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. |
|
||
CUS-CREDIT-ANLYST Element: Credit Analyst | Alpha 4 Credit analyst code. Must be a valid credit analyst. |
|
||
CUS-CURRENCY-CD Element: Currency Code | Alpha 5 Default invoice currency code. |
|
||
CUS-SALESMAN Element: SalesRep | Numeric 4 Sales representative. Must be a valid salesrep. |
|
||
CUS-RISK-CD Element: Risk Code | Alpha 1 Risk code. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
CUS-MIN-CLASS Element: Minor Class | Alpha 4 Minor class code. Must be a valid minor class. |
|
||
CUS-ORDER-LIM Element: Order Limit | Signed 15.0 Company customer order limit amount. |
|
||
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. |
|
||
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. |
|
||
CUS-CREDIT-REVDAYS Credit Limit Review Days | Signed 3.0 Credit limit review days. |
|
||
CUS-AGE-DISPUTES Element: Age Disputes | Alpha 1 Age disputes indicator. Valid values are: N = Disputes in current column Y = Age disputed items |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
CUS-CR-VAR-PCT Element: Credit Override | Numeric 3 Override percent that will be used in customer credit limit selections. |
|
||
CUS-MEMO-TERM Element: Memo Terms Code | Alpha 5 Memo terms code. Must be a valid terms code in the Lawson Terms system. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
CUS-STATEMENT-REQ Element: Statement Required | Alpha 1 Statement required option. Valid values are: N = Do not create statements Y = Create statements |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
CUS-FIN-CHRG-CD Element: Finance Charge Code | Alpha 2 Finance charge code. Must be a valid finance charge code. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
CUS-TERRITORY Element: Sales Territory | Alpha 4 Territory code. Must be a valid territory code. |
|
||
CUS-AGING-CODE Element: Aging Code | Numeric 2 Aging code used in a single customer aging. |
|
||
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. |
|
||
CUS-AR-CODE Account Receivable Code | Alpha 4 The default accounts receivable code for transaction processing. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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. |
|
||
CUS-AUTO-REMOVE Element: Auto Remove | Alpha 1 N = No Y = Yes |
|
||
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 |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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). |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
CUS-CU-STATE-CHG Element: Cu State Chg | Numeric 1 |
|
||
CUS-CU-POSTAL-CODE Element: Cu Postal Code | Alpha 12 Credit Union Postal Code. |
|
||
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. |
|
||
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 |
|
||
CUS-USR-FLD-01 Element: Usr Fld 01 | Alpha 20 |
|
||
CUS-UF01-CHG Element: Uf01 Chg | Numeric 1 |
|
||
CUS-USR-FLD-02 Element: Usr Fld 02 | Alpha 20 |
|
||
CUS-UF02-CHG Element: Uf02 Chg | Numeric 1 |
|
||
CUS-USR-FLD-03 Element: Usr Fld 03 | Alpha 20 |
|
||
CUS-UF03-CHG Element: Uf03 Chg | Numeric 1 |
|
||
CUS-USR-FLD-04 Element: Usr Fld 04 | Alpha 20 |
|
||
CUS-UF04-CHG Element: Uf04 Chg | Numeric 1 |
|
||
CUS-USR-FLD-05 Element: Usr Fld 05 | Alpha 20 |
|
||
CUS-UF05-CHG Element: Uf05 Chg | Numeric 1 |
|
||
CUS-E-MAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) Email address for this customer. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
CUS-PAY-AUTO-PCT Element: Max Auto Pct | Signed 5.5 |
|
||
CUS-PAY-REAS-CD Element: Auto Reas Cd | Alpha 4 |
|
||
CUS-MLT-DUN-LT-CH Element: Mlt Dun Lt Ch | Numeric 1 |
|
||
CUS-MULT-DUN-LTR Element: Flag | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
CUSSET1 |
COMPANY CUSTOMER ACTION-CD |
|
|
All trademarks and registered trademarks are the property of their
respective owners.