|
|
ARICST FILE
AR Interface Customer
AR Interface Customer
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
Search 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 AR550
County For use in a future release.
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
Dunn 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
Sales Rep 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 appl.
Y = Subject to auto cash appl.
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
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
Automatic Determines whether payments and
Transaction Removal transactions can be removed
automatically. Valid values are:
N = No
Y = Yes
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 Code Change The country code 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 only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
CUS-REGION-CHG Numeric 1
Region Code Change The region code changed indicator. Valid
Indicator values are:
0 = No change
1 = Change this code
CUS-VAT-REG-CTRY Alpha 2
VAT Registration The country component of the VAT
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
CUS-VAT-R-CTRY-CHG Numeric 1
VAT Reg Country Chg The VAT Registration Country change
Indicator indicator. Valid values are:
0 = No change
1 = Change this code
CUS-VAT-REG-NBR Alpha 12
VAT Registration The number component of the VAT
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
CUS-VAT-R-NBR-CHG Numeric 1
VAT Reg Nbr Change The VAT Registration Number change
Indicator indicator. Values are:
0 = No change
1 = Change this number
CUS-VAT-CUST-TYPE Alpha 2
VAT Customer Type The VAT customer type.
DM = Domestic
ER = EEC-Registered
EU = EEC-Unregistered
XP = Export
VX = VAT Exempt
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.
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
|