ARICST – AR Interface Customer

System
Accounts Receivable (AR)
Prefix
CUS
Primary key
COMPANY, CUSTOMER, ACTION-CD
Fields
240
Updated by
1 program
Referenced by
0 programs

ARICST is the AR Interface Customer table in Lawson Accounts Receivable (prefix CUS). It is indexed by COMPANY, CUSTOMER, ACTION-CD (CUSSET1). It is updated by AR550. The table has 240 fields, 1 index and 0 documented relations.

About ARICST

No description in the Lawson data dictionary.

Fields (240)

Column = COBOL field name without the CUS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CUS-COMPANY PK
COMPANY		Numeric 4Required. Company number.—
CUS-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Required. Customer number.—
CUS-ACTION-CD PK
ACTION_CD		Alpha 1Action 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
SEARCH_NAME		Alpha 30Name used for customer searches. Customer searches are conducted by search name and display name.AR550
CUS-NAME
NAME		Alpha 30 (Lower Case)Customer name. This name will appear on screens and reports.AR550
CUS-ADDR1
ADDR1		Alpha 30 (Lower Case)The first line of address information.AR550
CUS-ADDR1-CHG
ADDR1_CHG		Numeric 1Address line 1 change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ADDR2
ADDR2		Alpha 30 (Lower Case)The second line of address information.AR550
CUS-ADDR2-CHG
ADDR2_CHG		Numeric 1Address line 2 change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ADDR3
ADDR3		Alpha 30 (Lower Case)Third line of address information.AR550
CUS-ADDR3-CHG
ADDR3_CHG		Numeric 1Address line 3 change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ADDR4
ADDR4		Alpha 30 (Lower Case)Fourth line of address information.AR550
CUS-ADDR4-CHG
ADDR4_CHG		Numeric 1Address line 4 change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CITY
CITY		Alpha 18 (Lower Case)City/province name.AR550
CUS-CITY-CHG
CITY_CHG		Numeric 1City/province change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-STATE
STATE		Alpha 2This field contains the two-character code of the state or province.AR550
CUS-STATE-CHG
STATE_CHG		Numeric 1State abbreviation change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ZIP
ZIP		Alpha 10Postal code.AR550
CUS-ZIP-CHG
ZIP_CHG		Numeric 1Postal code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-COUNTY
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
COUNTY_CHG		Numeric 1County change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CONTACT-GROUP
CONTACT_GROUP		Alpha 20Contact name for customer.AR550
CUS-CONT-GROUP-CHG
CONT_GROUP_CHG		Numeric 1Contact name change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-TITLE
TITLE		Alpha 30 (Lower Case)Contact name title.AR550
CUS-TITLE-CHG
TITLE_CHG		Numeric 1Contact name title change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-INT-PREFIX
INT_PREFIX		Alpha 6International telephone prefix.AR550
CUS-INT-PREFIX-CHG
INT_PREFIX_CHG		Numeric 1International telephone prefix change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-PHONE-NMBR
PHONE_NMBR		Alpha 15Telephone number. Note: Use consistent format since customer searches can be done via telephone number.AR550
CUS-PHONE-NMBR-CHG
PHONE_NMBR_CHG		Numeric 1Telephone number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-PHONE-EXT
PHONE_EXT		Alpha 5Telephone extension number.AR550
CUS-PHONE-EXT-CHG
PHONE_EXT_CHG		Numeric 1Telephone extension change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-DUNN-CD
DUNN_CD		Alpha 3Dun code, used to represent the Dun and Bradstreet customer rating code.AR550
CUS-DUNN-CD-CHG
DUNN_CD_CHG		Numeric 1Dun code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-DUNN-DATE
DUNN_DATE		Numeric 8 (yyyymmdd)Dun and Bradstreet rating code date.AR550
CUS-DUNN-DATE-CHG
DUNN_DATE_CHG		Numeric 1Dun date change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-DUNN-NUMBER
DUNN_NUMBER		Numeric 9Dun and Bradstreet customer number.AR550
CUS-DUNN-NBR-CHG
DUNN_NBR_CHG		Numeric 1Dun number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-HOLD-CODE-GRP
HOLD_CODE_GRP		Alpha 4Hold code. Must be a valid hold code.AR550
CUS-HC-GRP-CHG
HC_GRP_CHG		Numeric 1Hold code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ORDER-LIM-GRP
ORDER_LIM_GRP		Signed 15.0Order limit amount.AR550
CUS-OL-GRP-CHG
OL_GRP_CHG		Numeric 1Order limit amount change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CREDIT-LIM-GRP
CREDIT_LIM_GRP		Signed 15.0Credit limit amount.AR550
CUS-CL-GRP-CHG
CL_GRP_CHG		Numeric 1Credit limit amount change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-OVR-ADDR-FL
OVR_ADDR_FL		Alpha 1Address override flag. Used for Order Entry processingAR550
CUS-TAX-ID
TAX_ID		Alpha 20Customer tax identification number.AR550
CUS-TAX-ID-CHG
TAX_ID_CHG		Numeric 1Customer tax identification number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of a customer record. Valid values are:
  • A Active - Default
  • I Inactive - Prevents invoicing
  • D Set for deletion
AR550
CUS-SEARCH-NAME2
SEARCH_NAME2		Alpha 30Company customer search name.AR550
CUS-HOLD-CODE
HOLD_CODE		Alpha 4Hold code. Must be a valid hold code.AR550
CUS-HOLD-CODE-CHG
HOLD_CODE_CHG		Numeric 1Hold code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CONTACT
CONTACT		Alpha 20This is the name of the main contact.AR550
CUS-CONTACT-CHG
CONTACT_CHG		Numeric 1Customer contact change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-INT-PREFIX2
INT_PREFIX2		Alpha 6Company customer international telephone number.AR550
CUS-INT-PRFIX2-CHG
INT_PRFIX2_CHG		Numeric 1Company customer international telephone prefix change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-PHONE-NMBR2
PHONE_NMBR2		Alpha 15Company customer telephone number.AR550
CUS-PHN-NMBR2-CHG
PHN_NMBR2_CHG		Numeric 1Company customer telephone number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-PHONE-EXT2
PHONE_EXT2		Alpha 5Company customer telephone number extension.AR550
CUS-PHONE-EXT2-CHG
PHONE_EXT2_CHG		Numeric 1Company customer telephone extension number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-TELEX-NBR
TELEX_NBR		Alpha 15Telex number.AR550
CUS-TELEX-NBR-CHG
TELEX_NBR_CHG		Numeric 1Telex number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-EDI-NBR
EDI_NBR		Alpha 15EDI number.AR550
CUS-FAX-NMBR
FAX_NMBR		Alpha 15Fax numberAR550
CUS-FAX-NMBR-CHG
FAX_NMBR_CHG		Numeric 1Fax number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-FAX-EXT
FAX_EXT		Alpha 5Fax number extension.AR550
CUS-FAX-EXT-CHG
FAX_EXT_CHG		Numeric 1Fax number extension change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-START-DATE
START_DATE		Numeric 8 (yyyymmdd)Start or origination date of customer.AR550
CUS-CREDIT-ANLYST
CREDIT_ANLYST		Alpha 4Credit analyst code. Must be a valid credit analyst.AR550
CUS-CURRENCY-CD
CURRENCY_CD		Alpha 5Default invoice currency code.AR550
CUS-SALESMAN
SALESMAN		Numeric 4Sales representative. Must be a valid salesrep.AR550
CUS-RISK-CD
RISK_CD		Alpha 1Risk code.AR550
CUS-RISK-CD-CHG
RISK_CD_CHG		Numeric 1Risk code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-DEFAULT-CODE
DEFAULT_CODE		Alpha 5Default code. Must be a valid default code.AR550
CUS-NAT-COMPANY
NAT_COMPANY		Numeric 4National account company.—
CUS-NAT-CUSTOMER
NAT_CUSTOMER		Alpha 9 (Right Justified)National account customer—
CUS-CUST-USER1
CUST_USER1		Alpha 10Customer user1 field.AR550
CUS-CUST-USER1-CHG
CUST_USER1_CHG		Numeric 1Customer user1 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER2
CUST_USER2		Alpha 18Customer user2 field.AR550
CUS-CUST-USER2-CHG
CUST_USER2_CHG		Numeric 1Customer user2 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER3
CUST_USER3		Signed 18.2Customer user3 fieldAR550
CUS-CUST-USER3-CHG
CUST_USER3_CHG		Numeric 1Customer user3 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER4
CUST_USER4		Signed 18.2Customer user4 fieldAR550
CUS-CUST-USER4-CHG
CUST_USER4_CHG		Numeric 1Customer user4 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER5
CUST_USER5		Numeric 9Customer user5 fieldAR550
CUS-CUST-USER5-CHG
CUST_USER5_CHG		Numeric 1Customer user5 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER6
CUST_USER6		Alpha 30Customer user6 fieldAR550
CUS-CUST-USER6-CHG
CUST_USER6_CHG		Numeric 1Customer user6 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER7
CUST_USER7		Alpha 30Customer user7 fieldAR550
CUS-CUST-USER7-CHG
CUST_USER7_CHG		Numeric 1Customer user7 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER8
CUST_USER8		Numeric 8 (yyyymmdd)Customer user8 fieldAR550
CUS-CUST-USER8-CHG
CUST_USER8_CHG		Numeric 1Customer user8 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER9
CUST_USER9		Numeric 3Customer user9 fieldAR550
CUS-CUST-USER9-CHG
CUST_USER9_CHG		Numeric 1Customer user9 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CUST-USER10
CUST_USER10		Alpha 3Customer user10 fieldAR550
CUS-CUST-USR10-CHG
CUST_USR10_CHG		Numeric 1Customer user10 field change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-MAJ-CLASS
MAJ_CLASS		Alpha 4Major class code. Must be a valid major class.AR550
CUS-MIN-CLASS
MIN_CLASS		Alpha 4Minor class code. Must be a valid minor class.AR550
CUS-ORDER-LIM
ORDER_LIM		Signed 15.0Company customer order limit amount.AR550
CUS-ORDER-LIM-CHG
ORDER_LIM_CHG		Numeric 1Company customer order limit amount change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CREDIT-LIM
CREDIT_LIM		Signed 15.0The credit limit amount for this customer.AR550
CUS-CREDIT-LIM-CHG
CREDIT_LIM_CHG		Numeric 1Company customer credit limit amount change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CREDIT-LIM-DAT
CREDIT_LIM_DAT		Numeric 8 (yyyymmdd)Credit limit date.AR550
CUS-CREDIT-REVDAYS
CREDIT_REVDAYS		Signed 3.0Credit limit review days.AR550
CUS-AGE-DISPUTES
AGE_DISPUTES		Alpha 1Age disputes indicator. Valid values are:
  • N Disputes in current column
  • Y Age disputed items
AR550
CUS-DISPUTES-FIN
DISPUTES_FIN		Alpha 1Disputed 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
AUTO_APP_FL		Alpha 1Automatic cash application indicator. Valid values are: application Y = Subject to auto cash application
  • N Not subject to auto cash
AR550
CUS-AUTO-DUNN-FL
AUTO_DUNN_FL		Alpha 1Automatic dunning notice indicator. Valid values are:
  • N Not subject to auto dunning
  • Y Subject to auto dunning
AR550
CUS-DISC-GRACE-PD
DISC_GRACE_PD		Numeric 2Discount grace days. This value will be added to an invoice's discount date for comparison to payment date.AR550
CUS-CR-VAR-PCT
CR_VAR_PCT		Numeric 3Override percent that will be used in customer credit limit selections.AR550
CUS-MEMO-TERM
MEMO_TERM		Alpha 5Memo terms code. Must be a valid terms code in the Lawson Terms system.AR550
CUS-CHRGBK-PRT-FL
CHRGBK_PRT_FL		Alpha 1Chargeback printing indicator. Valid values are:
  • N Do not print chargeback documents
  • Y Print chargeback documents
AR550
CUS-OPEN-BAL-FWD
OPEN_BAL_FWD		Alpha 1Processing 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
DISC_REAS_CD		Alpha 4Discount reason code for use in automatic and manual cash application. Must be a valid adjustment reason code.AR550
CUS-STATEMENT-REQ
STATEMENT_REQ		Alpha 1Statement required option. Valid values are:
  • N Do not create statements
  • Y Create statements
AR550
CUS-STMNT-CYCLE
STMNT_CYCLE		Alpha 2Allows 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
LOCK_BOX		Alpha 2This 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
LOCK_BOX_CHG		Numeric 1Lock box change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ZERO-STMNT-FL
ZERO_STMNT_FL		Alpha 1Zero balance statement option. Valid values are:
  • N Do not create zero statements
  • Y Create zero balance statements
AR550
CUS-CRED-STMNT-FL
CRED_STMNT_FL		Alpha 1Credit balance statement option. Valid values are:
  • N Do not create credit bal statement
  • Y Create credit balance statement
AR550
CUS-PAST-STMNT-FL
PAST_STMNT_FL		Alpha 1Past 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
OVER_STMNT_FL		Alpha 1Over credit limit statement option. Valid values are: greater than credit limit
  • N No credit limit balance checking
  • Y Statement only if balance is
AR550
CUS-MAX-AUTO-AMT
MAX_AUTO_AMT		Signed 18.2 Occurs 3 Times ×3The 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
MAX_AUTO_PCT		Signed 5.5 Occurs 3 Times ×3The 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
AUTO_REAS_CD		Alpha 4 Occurs 3 Times ×3This reason code is required if there is a short amount or percent allowed for automatic adjustments.AR550
CUS-AUTO-CHG
AUTO_CHG		Numeric 1Automatic adjustment reason code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-TERMS-CD
TERMS_CD		Alpha 5Default terms code. Must be a valid terms code.AR550
CUS-LATE-PAY-FL
LATE_PAY_FL		Alpha 1Late 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
FIN_CALC_TYPE		Alpha 1Finance charge type indicator. Valid values are:
  • D Detail (per invoice) calculation
  • N Net balance calculation
AR550
CUS-FIN-CHRG-CD
FIN_CHRG_CD		Alpha 2Finance charge code. Must be a valid finance charge code.AR550
CUS-FIN-GRAC-DAYS
FIN_GRAC_DAYS		Numeric 2The number of grace days to be added to due date before finance charges will be assessed.AR550
CUS-FIN-GRC-DY-CHG
FIN_GRC_DY_CHG		Numeric 1Finance grace days change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-FIN-MIN-CHRG
FIN_MIN_CHRG		Signed 7.2The 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
FIN_MIN_CG_CHG		Numeric 1Finance minimum charge amount change indicator. Valid values are:
  • 0 No change
  • 1 Change this amount
—
CUS-I-FIN-MIN-CHRG
I_FIN_MIN_CHRG		Signed 7.2Minimum finance charge amount for an invoice.AR550
CUS-I-FIN-MIN-CHG
I_FIN_MIN_CHG		Numeric 1Finance minimum charge change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-FIN-DOC-PRNT
FIN_DOC_PRNT		Alpha 1Finance charge print document indicator. Valid values are:
  • N No finance charge documents printed
  • Y Print finance charge document
AR550
CUS-TERRITORY
TERRITORY		Alpha 4Territory code. Must be a valid territory code.AR550
CUS-AGING-CODE
AGING_CODE		Numeric 2Aging code used in a single customer aging.AR550
CUS-AGING-CODE-CHG
AGING_CODE_CHG		Numeric 1Aging code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A 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
AR_CODE		Alpha 4The default accounts receivable code for transaction processing.AR550
CUS-DRAFT-FLAG
DRAFT_FLAG		Alpha 1If 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		Alpha 1Used to determine if minimum finance charges are to be used. Valid values are: amount is less than minimum amount. less than minimum amount. If minimum amount is blank, then calculated amount is charged.
  • Y Use minimum amount if calculated
  • N No charge if calculated amount is
  • Blank Finance amount on detail
AR550
CUS-MINIMUM-CHG
MINIMUM_CHG		Numeric 1Minimum finance charge change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-FIN-CYCLE
FIN_CYCLE		Alpha 2Finance charge cycle code.AR550
CUS-DUN-CYCLE
DUN_CYCLE		Alpha 2Dunning cycle code.—
CUS-AUTO-METHOD
AUTO_METHOD		Alpha 1Automatic cash application method.AR550
CUS-ALT-EDI-NBR
ALT_EDI_NBR		Alpha 95This is a free-form field to accommodate an alternate EDI number or address.—
CUS-ALT-EDI-TYPE
ALT_EDI_TYPE		Alpha 5The type of alternate EDI number entered for the customer.—
CUS-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Determines whether a customer is tax exempt or not. Valid values are:
  • T Taxable
  • E Exempt
AR550
CUS-TAX-CODE
TAX_CODE		Alpha 10User-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
AUTO_REMOVE		Alpha 1—
  • N No
  • Y Yes
AR550
CUS-CB-DTL-DATE
CB_DTL_DATE		Alpha 1This 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
VAT_REG_CTRY		Alpha 2The 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
VAT_R_CTRY_CHG		Numeric 1VAT country change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-VAT-REG-NBR
VAT_REG_NBR		Alpha 12The 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
VAT_R_NBR_CHG		Numeric 1VAT number change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-VAT-CUST-TYPE
VAT_CUST_TYPE		Alpha 2Indicates the type of customer for VAT reporting.AR550
CUS-BANK-ENTITY
BANK_ENTITY		Alpha 15Represents a bank institution location.—
CUS-BANK-ACCT-NBR
BANK_ACCT_NBR		Alpha 35The bank-assigned account number identification for the related bank entity.—
CUS-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AR550
CUS-COUNTRY-CD-CHG
COUNTRY_CD_CHG		Numeric 1Country code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)—
CUS-REGION-CHG
REGION_CHG		Numeric 1Region code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-DUN-LTR-IND
DUN_LTR_IND		Alpha 1Specifies whether the advanced dunning letter process is to be used.AR550
CUS-DUN-LTR-IND-CH
DUN_LTR_IND_CH		Numeric 1Dunning letter change indicator. Valid values are:
  • 0 No Change
  • 1 Change this field
—
CUS-DUN-PROCESS-CD
DUN_PROCESS_CD		Alpha 6Dunning letter process code. A unique code that represents a combination of Dunning Letter options.AR550
CUS-DUN-PROC-CD-CH
DUN_PROC_CD_CH		Numeric 1Dunning process code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-LANGUAGE-CODE
LANGUAGE_CODE		Alpha 10Language Code value.AR550
CUS-LANG-CODE-CHG
LANG_CODE_CHG		Numeric 1Language code change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-ASSESS-DUN-FEE
ASSESS_DUN_FEE		Alpha 1Specifies whether to assess a dunning letter fee.AR550
CUS-DUN-FEE-CHG
DUN_FEE_CHG		Numeric 1Assess dunning fee change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CU-NAME
CU_NAME		Alpha 30Credit Union Name.AR550
CUS-CU-NAME-CHG
CU_NAME_CHG		Numeric 1Credit Union Name change indicator. Valid values are:
  • 0 No change
  • 1 Change this field
—
CUS-CU-ADDR1
CU_ADDR1		Alpha 30 (Lower Case)Credit Union Address Line 1.AR550
CUS-CU-ADDR1-CHG
CU_ADDR1_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-ADDR2
CU_ADDR2		Alpha 30 (Lower Case)Credit Union Address Line 2.AR550
CUS-CU-ADDR2-CHG
CU_ADDR2_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-ADDR3
CU_ADDR3		Alpha 30 (Lower Case)Credit union address line 3.AR550
CUS-CU-ADDR3-CHG
CU_ADDR3_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-ADDR4
CU_ADDR4		Alpha 30 (Lower Case)Credit union address line 4.AR550
CUS-CU-ADDR4-CHG
CU_ADDR4_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-CITY
CU_CITY		Alpha 18 (Lower Case)Credit Union City.AR550
CUS-CU-CITY-CHG
CU_CITY_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-STATE
CU_STATE		Alpha 2Credit Union State.AR550
CUS-CU-STATE-CHG
CU_STATE_CHG		Numeric 1——
CUS-CU-POSTAL-CODE
CU_POSTAL_CODE		Alpha 12Credit Union Postal Code.AR550
CUS-CU-POST-CD-CHG
CU_POST_CD_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-CU-COUNTRY-CD
CU_COUNTRY_CD		Alpha 2Credit Union Country Code.AR550
CUS-CU-CTRY-CD-CHG
CU_CTRY_CD_CHG		Numeric 1—
  • 0 No change
  • 1 Change this field
—
CUS-THIRD-PARTY
THIRD_PARTY		Alpha 1—
  • N No third party payment
  • Y Third party payment allowed
AR550
CUS-USR-FLD-01
USR_FLD_01		Alpha 20—AR550
CUS-UF01-CHG
UF01_CHG		Numeric 1——
CUS-USR-FLD-02
USR_FLD_02		Alpha 20—AR550
CUS-UF02-CHG
UF02_CHG		Numeric 1——
CUS-USR-FLD-03
USR_FLD_03		Alpha 20—AR550
CUS-UF03-CHG
UF03_CHG		Numeric 1——
CUS-USR-FLD-04
USR_FLD_04		Alpha 20—AR550
CUS-UF04-CHG
UF04_CHG		Numeric 1——
CUS-USR-FLD-05
USR_FLD_05		Alpha 20—AR550
CUS-UF05-CHG
UF05_CHG		Numeric 1——
CUS-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)Email address for this customer.AR550
CUS-E-MAIL-CHG
E_MAIL_CHG		Alpha 1——
CUS-URL-ADDR
URL_ADDR		Alpha 60 (Lower Case)URL address for this customer.AR550
CUS-URL-ADDR-CHG
URL_ADDR_CHG		Alpha 1——
CUS-CUST-AUDIT
CUST_AUDIT		Alpha 1Indicates whether customer changes will be tracked. Valid values are:
  • N No customer audit
  • Y Customer audit
AR550
CUS-APPLY-MIXED
APPLY_MIXED		Alpha 1Indicates 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
EFT_BNK_ENTITY		Alpha 15Represents a bank institution location.—
CUS-EFT-BNK-ACCT
EFT_BNK_ACCT		Alpha 35The bank-assigned account number identification.—
CUS-EFT-RIBKEY
EFT_RIBKEY		Numeric 2This field contains the EFT Ribkey value for the related bank account number.—
CUS-EFT-VBNK-IDENT
EFT_VBNK_IDENT		Alpha 1This field indicates if the bank account number is an IBAN number that requires an account validation check.—
CUS-BNK-START-DATE
BNK_START_DATE		Numeric 8 (yyyymmdd)The start date for EFT selection for the associated bank account.—
CUS-BNK-END-DATE
BNK_END_DATE		Numeric 8 (yyyymmdd)The end date for EFT selection for the associated bank acount.—
CUS-BNK-PRENOTE
BNK_PRENOTE		Numeric 8 (yyyymmdd)This is the date the prenotification was sent to the customer for EFT processing.—
CUS-FT-TYPE
FT_TYPE		Alpha 1This is the type of bank account. Valid values are:
  • Blank Debit and Credit account
  • C Credit Account
  • D Debit Account
—
CUS-BNK-PRE-NOTE
BNK_PRE_NOTE		Alpha 1Indicates if sending a prenote for this bank account is required.—
CUS-BNK-PRNT-STAT
BNK_PRNT_STAT		Numeric 1Status of the prenote for this bank account. Valid values are:
  • 0 Not Prenoted (default)
  • 1 Printed
  • 9 EFT record sent
—
CUS-CUST-ACCT-TYPE
CUST_ACCT_TYPE		Alpha 1The type of account the customer has:
  • C Check
  • S Savings
—
CUS-RIBKEY
RIBKEY		Numeric 2This field contains the Ribkey value for the bank account number.—
CUS-CUST-PRE-NOTE
CUST_PRE_NOTE		Alpha 1Indicates if customers are prenotified of EFt transactions. Valid values are:
  • N No
  • Y Yes
—
CUS-CUST-NOTE-METH
CUST_NOTE_METH		Alpha 1Indicates the method used to deliver pre or final EFT notification to a customer.
  • A Alternate EDI
  • E EDI
  • F Fax
—
CUS-ADJ-NOTE-METH
ADJ_NOTE_METH		Alpha 1The method used to deliver the EFT adjustment notification to the customer. Valid values are:
  • A Alterante EDI
  • E EDI
  • F Fax
—
CUS-USER1-FIELD
USER1_FIELD		Alpha 5——
CUS-USER2-FIELD
USER2_FIELD		Alpha 10——
CUS-PAYMENT-FORMAT
PAYMENT_FORMAT		Alpha 1Determines 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
VBANK_IDENT		Alpha 1——
CUS-BANK-TRAN-CD
BANK_TRAN_CD		Alpha 2This field contains the bank transaction code for the bank account number.—
CUS-MX-TMPLT-NAME
MX_TMPLT_NAME		Alpha 12This 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
PAY_AUTO_AMT		Signed 18.2—AR550
CUS-PAY-AUTO-PCT
PAY_AUTO_PCT		Signed 5.5—AR550
CUS-PAY-REAS-CD
PAY_REAS_CD		Alpha 4—AR550
CUS-MLT-DUN-LT-CH
MLT_DUN_LT_CH		Numeric 1——
CUS-MULT-DUN-LTR
MULT_DUN_LTR		Alpha 1—AR550
CUS-CU-COUNTY
CU_COUNTY		Alpha 25 (Lower Case)—AR550
CUS-LEGAL-NAME
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
CU_COUNTY_CHG		Numeric 1——
CUS-FOR-ECON-CODE
FOR_ECON_CODE		Alpha 10——
CUS-CARRIER-FLAG
CARRIER_FLAG		Alpha 1——
CUS-CHK-DIG-TYPE
CHK_DIG_TYPE		Alpha 10—AR550
CUS-CU-DIG-TY-CHG
CU_DIG_TY_CHG		Numeric 1——
CUS-BIC-ID
BIC_ID		Alpha 12——

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CUSSET1COMPANY, CUSTOMER, ACTION-CDPrimary, KeyChangeAR550

Programs

Updated by (1)