ARCCUST FILE
AR Customer Conversion
The AR Customer Conversion file is used to convert customer records from an
external source. Records in this file have been converted from an external
source and will be loaded into the Accounts Receivable system via AR501
(Customer Conversion).
Field data converted into this file may be accessed and maintained in program
AR98 (Conversion Customer).
UPDATED BY
AR501 AR98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARU-COMPANY Numeric 4 AR98.1
Company Required. The customer company number.
ARU-CUSTOMER Alpha 9 (Right Justified) AR98.1
Customer Required. Customer number.
ARU-ACTIVE-STATUS Alpha 1 AR98.1
Customer Status Customer status. If this field is
inactive, no invoicing can be done for
this customer. Valid values are:
A = Active
D = Set for deletion
I = Inactive
ARU-SEARCH-NAME Alpha 30 AR98.1
Search Name Search name assigned to this customer
for search and sorting capabilities.
Defaults from customer name if not
present.
ARU-HOLD-CODE Alpha 4 AR98.1
Hold Code Hold code assessed to this customer.
ARU-CONTACT Alpha 20 AR98.1
Primary Contact Name of the primary contact.
ARU-INT-PREFIX Alpha 6 AR98.1
International Prefix International telephone prefix.
ARU-PHONE-NMBR Alpha 15 AR98.1
Telephone Number Telephone number.
ARU-PHONE-EXT Alpha 5 AR98.1
Telephone Extension This field contains the telephone
extension number.
ARU-TELEX-NBR Alpha 15 AR98.1
Telex Number Telex number.
ARU-EDI-NBR Alpha 15 AR98.1
EDI Number Electronic Data Interchange number.
ARU-ALT-EDI-NBR Alpha 95 AR98.1
Alternate EDI Number This is a free-form field to
accommodate an alternate EDI number or
electronic address.
ARU-ALT-EDI-TYPE Alpha 5 AR98.1
Alternate EDI Type Indicates the type of the alternate EDI
number.
ARU-FAX-NMBR Alpha 15 AR98.1
Fax Number Fax number.
ARU-FAX-EXT Alpha 5 AR98.1
Fax Extension This field contains the fax number
extension.
ARU-START-DATE Numeric 8 (yyyymmdd) AR98.1
Start Date Origin date or starting date of
business with this customer.
ARU-CREDIT-ANLYST Alpha 4 AR98.1
Credit Analyst Credit analyst code assigned to this
customer. If left blank, will default
from customer defaults code.
ARU-CURRENCY-CD Alpha 5 AR98.1
Currency Code Customer default invoice currency code.
ARU-SALESMAN Numeric 4 AR98.1
SalesRep This field contains the code that
represents the primary sales
representative for this customer. If
left blank, this defaults from the
customer defaults code.
ARU-RISK-CD Alpha 1 AR98.1
Risk Code User-defined risk code used for
customer reporting selections. If left
blank, company defined risk code will
default.
ARU-DEFAULT-CODE Alpha 5 AR98.1
Default Code Customer default code. Required.
ARU-MAJ-CLASS Alpha 4 AR98.1
Major Class Major class used for customer reporting
and processing for this customer. If
left blank, will default from customer
default code.
ARU-MIN-CLASS Alpha 4 AR98.1
Minor Class Minor class used for customer reporting
and processing for this customer. If
left blank, will default from customer
default code. Must be entered if a major
class is entered.
ARU-OPEN-ORDS Signed 15.2 AR98.1
Total Open Orders Total amount of open orders for this
customer. Must be a positive amount.
ARU-ORDER-LIM Signed 15.0 AR98.1
Open Order Limit Order limit amount for the total amount
of open orders for this customer.
ARU-CREDIT-LIM Signed 15.0 AR98.1
Credit Limit Total amount of credit for this
customer.
ARU-CREDIT-LIM-DAT Numeric 8 (yyyymmdd) AR98.1
Credit Limit Date The date the credit limit was
established. System date will default if
left blank.
ARU-CREDIT-REVDAYS Signed 3.0 AR98.1
Credit Review Days Number of days that determine the
intervals between credit limit reviews.
ARU-LAST-PMT-AMT Signed 15.2 AR98.1
Last Payment Amount Amount of last payment in company base
currency.
ARU-LAST-PMT-DATE Numeric 8 (yyyymmdd) AR98.1
Last Payment Date Date of last payment to this company
for this customer.
ARU-LAST-INV-DATE Numeric 8 (yyyymmdd) AR98.1
Last Invoice Date Last invoice date.
ARU-LAST-INV-AMT Signed 15.2 AR98.1
Last Inv Amt
ARU-LAST-STA-DATE Numeric 8 (yyyymmdd) AR98.1
Last Statement Date Date of last statement for this
customer.
ARU-LAST-STA-BAL Signed 15.2 AR98.1
Last Statement Last statement balance for this
Balance customer in company base currency.
ARU-REVIEW-DATE Numeric 8 (yyyymmdd) AR98.1
Review Date Last date the customer was set for
review. System date defaults if left
blank.
ARU-REVIEW-CODE Alpha 1 AR98.1
Review Code Indicates the status of the customer's
review record. If left blank, reviewed
status (R) defaults. Valid values are:
Blank = No review status
O = Open review
R = Reviewed
ARU-HIGH-BAL Signed 15.0 Occurs 13 Times AR98.1
Highest Customer Highest customer balance for this
Balance company for this period.
ARU-PER-RTMS Signed 3.0 Occurs 13 Times
Period RTMs Period return-to-maker payment
occurrences.
ARU-PAID-PRMPT Signed 5.0 Occurs 12 Times
Paid Prompt The number of invoices paid prompt for
this period. Invoices cleared by
chargebacks are not considered.
ARU-INV-PAID Signed 5.0 Occurs 12 Times
Paid Invoices The number of invoices fully paid for
this period. This will be used in the
Invoice Payment Average (IPA) and Days
Beyond Terms (DBT) calculations for each
customer.
ARU-COLLECT-DAYS Signed 3.0 Occurs 11 Times AR98.1
Collect Days This is a collection ratio of days to
collect those invoices that have been
fully paid for this period. This is a
weighted calculation based on the amount
of the invoice.
ARU-CURR-CASH Signed 15.2
Current Cash This field contains cash paid amount
from fully paid transactions. At the end
of a period, it will be used to
calculate the ratio for the Collect Days
field.
ARU-CURR-CSH-DAYS Signed 15.2
Current Cash Days This field contains the flow of funds
cash days calculated value (paid amount
multiplied by number of days to fully
pay) for the current period.
ARU-YTD-CASH Signed 15.2 AR98.1
YTD Cash Year to date total of cash for fully
paid transactions.
ARU-YTD-CSH-DAYS Signed 15.2 AR98.1
YTD Cash Days Year to date calculation of cash paid
and applied to an open item multiplied
by the number of days to fully pay the
transactions.
ARU-YEAR-2-DAYS Signed 3.0 AR98.1
Previous Year IPA Weighted invoice payment average for
the year previous to the totals being
summed in Collect Days occurrences.
ARU-STATIC-CUR Signed 15.2
Current Static Aged Static aged current portion of a
customer's balance.
ARU-AGING Signed 15.2 Occurs 5 Times
Aging Static aged past due amounts in company
base currency for this customer.
ARU-AGE-DISPUTES Alpha 1 AR98.1
Age Disputes Specifies how disputed invoices will be
aged. Valid values are:
N = Not aged - aged in current column
Y = Age respective to date
ARU-DISPUTES-FIN Alpha 1 AR98.1
Finance Disputes Specifies if disputed invoices are
exempt from being assessed finance
charges. Valid values are:
Y = Finance charges on disputed items
N = No finance charges on disputed items
ARU-AUTO-APP-FL Alpha 1 AR98.1
Auto Application Automatic cash application indicator.
Valid values are:
N = Not subject to automatic application
Y = Subject to automatic application
ARU-AUTO-DUNN-FL Alpha 1 AR98.1
Auto Dunning Indicates whether or not automatic
selection of dunning letters will be
allowed. Valid values are:
N = No automatic dunning
Y = Automatic dunning
ARU-DISC-GRACE-PD Numeric 2 AR98.1
Discount Grace Grace days added to discount date to
Period allow or disallow discount during cash
application.
ARU-CR-VAR-PCT Numeric 3 AR98.1
Credit Variance Override percent used for customer
Percent credit limit selections.
ARU-MEMO-TERM Alpha 5 AR98.1
Memo Terms Code Memo terms code. Must be a valid
net or prepayment type terms code
defined in the Lawson Terms system.
ARU-CHRGBK-PRT-FL Alpha 1 AR98.1
Print Chargebacks Specifies whether chargebacks will be
printed. Valid values are:
N = Do not print chargebacks
Y = Print chargebacks
ARU-OPEN-BAL-FWD Alpha 1 AR98.1
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
ARU-STATEMENT-REQ Alpha 1 AR98.1
Statement Required Statement required option. Valid values
are:
N = No statements required
Y = Statements required
ARU-STMNT-CYCLE Alpha 2 AR98.1
Statement Cycle Statement cycle code used to group
customers for statement processing.
ARU-LOCK-BOX Alpha 2 AR98.1
Lock Box Remit to location for payment receipts.
If left blank, the company address will
be used.
ARU-ZERO-STMNT-FL Alpha 1 AR98.1
Zero Statements Determines whether or not a customer
will receive a statement when there is
no unapplied transactions and a balance
of zero. Valid values are:
N = No zero statements produced
Y = Zero statements produced
ARU-CRED-STMNT-FL Alpha 1 AR98.1
Credit Statements Determines whether or not a customer
will receive a statement if a net credit
balance exists. Valid values are:
N = No credit statements produced
Y = Credit statements produced
ARU-PAST-STMNT-FL Alpha 1 AR98.1
Past Due Statements Past due open items only statements.
Valid values are:
N = No open item only past due
statements
Y = Open item only past due statements
ARU-OVER-STMNT-FL Alpha 1 AR98.1
Credit Exceeded Over credit limit statement option.
Statements Valid values are:
N = No only balance exceeding credit
limit statements.
Y = Produce only balance exceeding
credit limit statements.
ARU-MAX-AUTO-AMT Signed 15.2 Occurs 3 Times AR98.1
Maximum Automatic Maximum open item shortage amount
Amount during cash application that may be
automatically written off. Multiple
amounts must be in ascending order.
ARU-MAX-AUTO-PCT Signed 5.5 Occurs 3 Times AR98.1
Maximum Automatic Maximum open item percentage amount
Percent during cash application that may be
automatically written off. Multiple
percentages must be in ascending order.
ARU-AUTO-REAS-CD Alpha 4 Occurs 3 Times AR98.1
Automatic Reason This reason code is required if there
Code is a shortage amount or shortage
percentage entered.
ARU-DISC-REAS-CD Alpha 4 AR98.1
Discount Reason Code Default discount reason code for earned
discounts during cash application.
ARU-BANK-INST-CODE Alpha 3 AR98.1
Payment Code A transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
ARU-DRAFT-FLAG Alpha 1 AR98.1
Bill of Exchange If the customer has a bill of exchange
Flag default payment type, this flag will
indicate if the bills of exchange should
be created in summary or individually.
Valid values are:
Blank = Not paying by BOE method
I = Individual
S = Summary
ARU-AR-CODE Alpha 4 AR98.1
Accounts Receivable Accounts receivable general ledger
Code account used as a default for
transaction record creation.
ARU-TERMS-CD Alpha 5 AR98.1
Terms Code Default terms code to be used for
invoicing for this customer.
ARU-TERMS-CASH Signed 15.2
Paid Amount This field contains the cash paid
amount from fully paid transactions. At
the end of a current period it will be
used to calculate DBT (Days Beyond
Terms)
ARU-TERMS-CSH-DAYS Signed 15.2
Paid Cash Days This field contains the flow of funds
cash days calculated value (paid amount
multiplied by the number of days from
due date to fully pay) for the current
period.
ARU-DBT-RATIO Signed 3.0 Occurs 11 Times AR98.1
DBT Ratio Days Beyond Terms indicator for this
period. Used in customer credit
analysis.
ARU-DBT-PR-YR Signed 3.0 AR98.1
Previous Year DBT Last year's Days Beyond Terms
indicator.
ARU-DBT-YTD-CASH Signed 15.2 AR98.1
YTD Cash Paid This field contains the cash paid
amount for fully paid transactions for
the year.
ARU-DBT-YTD-DAYS Signed 15.2 AR98.1
YTD Cash Days The running total of the year's Flow of
Funds Cash Days calculated value (paid
invoice amount multiplied by the number
of days from due date to fully paid).
ARU-LATE-PAY-FL Alpha 1 AR98.1
Late Payment Flag Late payment flag. It will indicate if
finance charges and/or late payment
charges will be calculated. Valid values
are:
B = Both finance charges and late
payment charges
F = Finance charges only
L = Late payment charges only
Blank = No charges
ARU-FIN-CALC-TYPE Alpha 1 AR98.1
Finance Calculation Determines the method of finance charge
Type calculations. Valid values are:
D = Detail per open item finance charges
N = Net balance finance charges
ARU-FIN-CHRG-CD Alpha 2 AR98.1
Finance Charge Code Finance charge code containing a
percentage rate used for finance charge
calculations.
ARU-FIN-GRAC-DAYS Numeric 2 AR98.1
Finance Grace Days The number of grace days added to due
date before finance charges will be
assessed.
ARU-FIN-MIN-CHRG Signed 7.2 AR98.1
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.
ARU-FIN-DOC-PRNT Alpha 1 AR98.1
Print Finance Specifies whether or not finance charge
Charge Documents documents are required to be printed.
Valid values are:
N = No finance charge documents required
Y = Finance charge documents printed
ARU-LAST-DUNN Numeric 2
Last Dunning The last dunning letter number produced
for the customer.
ARU-LAST-DUN-DATE Numeric 8 (yyyymmdd)
Last Dunning Date The date of the last dunning letter
produced for this customer.
ARU-TAX-EXEMPT-CD Alpha 1 AR98.1
Tax Exempt Code Used by the Lawson Order Entry system.
Determines whether this customer is tax
exempt or not. Valid values are:
E = Exempt
T = Taxable
ARU-TAX-CODE Alpha 10 AR98.1
Tax Code This field contains a code representing
specific tax information. 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.
ARU-TERRITORY Alpha 4 AR98.1
Sales Territory Sales Territory.
ARU-AGING-CODE Numeric 2
Aging Code Aging code providing aging rules for a
single customer aging.
ARU-REVALUE-FL Alpha 1 AR98.1
Revalue Flag Default revalue indicator for non-base
currency transactions. Valid values are:
N = No revaluation
Y = Revalue
ARU-DISHONORED Signed 5.0
Dishonored BOEs This field contains the total number of
dishonored Bills of Exchange since the
customer was added.
ARU-DISHONORED-AMT Signed 15.2
Dishonored BOE This field contains the total amount of
Amount dishonored Bills of Exchange that has
accumulated since the customer was
added.
ARU-RECONCILE-CASH Signed 5.0
Reconcile Cash This field will give a count of the
number of dishonored Bills of Exchange
that have been reconciled with the
customer paying in cash for the
dishonored BOE.
ARU-RECONCILE-RNEG Signed 5.0
Reconcile This field will give a count of total
Renegotiations number of dishonored Bills of Exchange
that have been renegotiated.
ARU-RECONCILE-WO Signed 5.0
Reconcile Write Offs This field will give a total count of
dishonored Bills of Exchange that have
been written off as a bad debt.
ARU-NAME Alpha 30 (Lower Case) AR98.1
Customer Name Customer name. Required.
ARU-ADDR1 Alpha 30 (Lower Case) AR98.1
Address 1 This field contains the first line of
address information.
ARU-ADDR2 Alpha 30 (Lower Case) AR98.1
Address 2 This field contains the second line of
address information.
ARU-ADDR3 Alpha 30 (Lower Case) AR98.1
Address 3 This field contains the third line of
address information.
ARU-ADDR4 Alpha 30 (Lower Case) AR98.1
Address 4 This field contains the fourth line of
address information.
ARU-CITY Alpha 18 (Lower Case) AR98.1
City This field contains the city of the
address.
ARU-STATE Alpha 2 AR98.1
State or Province This field contains the two-character
state or province code of the address.
ARU-ZIP Alpha 10 AR98.1
Postal Code This field contains the postal code of
the address.
ARU-COUNTRY Alpha 30 (Lower Case) AR98.1
Country or Other This field contains the country of the
Info address, or it can be used for
additional information such as an
attention name.
ARU-COUNTY Alpha 25 (Lower Case) AR98.1
County This field contains the county of the
address.
ARU-DUNN-CD Alpha 3 AR98.1
Dun and Bradstreet Dun and Bradstreet rating code.
Code
ARU-DUNN-DATE Numeric 8 (yyyymmdd) AR98.1
Dunn and Bradstreet The date the Dunn Code was established.
Date
ARU-LAST-DUN-AMT Signed 15.2
Last Dun Amt
ARU-DUNN-NUMBER Numeric 9 AR98.1
Dunn and Bradstreet The Dunn and Bradstreet cross reference
Number number for this customer.
ARU-OVR-ADDR-FL Alpha 1
Override Address Used by the Lawson Order Entry system
Flag for one time customers. Valid values
are:
N = No address override allowed
Y = Address override allowed
ARU-TAX-ID Alpha 20
Tax ID Tax identification number.
ARU-ORDER-LIM-GRP Signed 15.0 AR98.1
Group Order Limit Order limit amount for the total amount
of open orders at the customer group
level for all companies.
ARU-CRED-LIM-GRP Signed 15.0 AR98.1
Group Credit Limit Credit limit at the customer group
level for all companies.
ARU-HOLD-CODE-GRP Alpha 4 AR98.1
Group Hold Code Hold code at the customer group level.
ARU-TITLE Alpha 30 (Lower Case) AR98.1
Contact Title Contact title.
ARU-NAT-COMPANY Numeric 4 AR98.1
National Account National account company for this
Company customer. Must be entered if a national
account customer is entered.
ARU-NAT-CUSTOMER Alpha 9 (Right Justified) AR98.1
National Account National account customer for this
Customer customer. Must be entered if a national
account company is entered.
ARU-CUST-USER1 Alpha 10 AR98.1
Customer User 1 Customer 1 user field
ARU-CUST-USER2 Alpha 18 AR98.1
Customer User 2 Customer 2 user field.
ARU-CUST-USER3 Signed 15.2 AR98.1
Customer User 3 Customer user 3 field.
ARU-CUST-USER4 Signed 15.2 AR98.1
Customer User 4 Customer user 4 field.
ARU-CUST-USER5 Numeric 9 AR98.1
Customer User 5 Customer user 5 field.
ARU-CUST-USER6 Alpha 30 AR98.1
Customer User 6 Customer user 6 field.
ARU-CUST-USER7 Alpha 30 AR98.1
Customer User 7 Customer user 7 field.
ARU-CUST-USER8 Numeric 8 (yyyymmdd) AR98.1
Customer User 8 Customer user 8 field. Date format,
YYYYMMDD.
ARU-CUST-USER9 Numeric 3 AR98.1
Customer User 9 Customer user 9 field.
ARU-CUST-USER10 Alpha 3 AR98.1
Customer User 10 Customer user 10 field.
ARU-MINIMUM Alpha 1 AR98.1
Minimum Finance Determines if minimum finance charges
Charges are assessed.
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.
ARU-FIN-CYCLE Alpha 2 AR98.1
Finance Charge Finance charge cycle code.
Cycle Code
ARU-DUN-CYCLE Alpha 2 AR98.1
Dunning Cycle Code Dunning cycle code.
ARU-AUTO-METHOD Alpha 1 AR98.1
Auto Cash Automatic cash application method.
Application Method Valid values are:
A = Algorithm
B = Balance forward
L = Last statement
R = Remittance
ARU-AUTO-REMOVE Alpha 1
Auto Remove N = No
Y = Yes
ARU-CB-DTL-DATE Alpha 1 AR98.1
Cb Dtl Date This field will determine which dates
are used in calculating the transaction
and due dates of detail chargebacks.
I = Invoice
P = Payment
ARU-VAT-REG-CTRY Alpha 2 AR98.1
Vat Reg Ctry The country component of the VAT
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
ARU-VAT-REG-NBR Alpha 12 AR98.1
Vat Reg Nbr The number component of the VAT
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
ARU-VAT-CUST-TYPE Alpha 2 AR98.1
Vat Cust Type The VAT customer type.
ARU-LANGUAGE-CODE Alpha 10 AR98.1
Language Code The language code (locale) representing
the conversion customer's preferred
language. If no language code is
specified, then U.S. English is assumed.
Note, spaces indicate U.S. English.
First define the Language Code using the
Lawson utility "locdef". Then define the
Language Code via GL19.1 (Language Code
Maintenance).
ARU-BANK-ENTITY Alpha 15 AR98.1
Bank Represents a bank institution location.
ARU-BANK-ACCT-NBR Alpha 17 AR98.1
Bank Account Number The bank-assigned account number
identification to be used for the cash
code.
ARU-COUNTRY-CODE Alpha 2 AR98.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
ARU-REGION Alpha 2 AR98.1
Region Code The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
ARU-DUN-LTR-IND Alpha 1 AR501 AR98.1
Dun Ltr Ind Specifies whether the advanced dunning
letter process is to be used.
ARU-DUN-PROCESS-CD Alpha 6 AR98.1
Dun Process Cd Dunning letter process code. A unique
code that represents a combination of
Dunning Letter options.
ARU-ASSESS-DUN-FEE Alpha 1 AR501 AR98.1
Assess Dun Fee Specifies whether to assess a dunning
letter fee.
ARU-CU-NAME Alpha 30 AR98.1
Cu Name Credit Union Name.
ARU-CU-ADDR1 Alpha 30 (Lower Case) AR98.1
Cu Addr1 Credit Union Address Line 1.
ARU-CU-ADDR2 Alpha 30 (Lower Case) AR98.1
Cu Addr2 Credit Union Address Line 2.
ARU-CU-ADDR3 Alpha 30 (Lower Case) AR98.1
Cu Addr3 Credit union address line 3.
ARU-CU-ADDR4 Alpha 30 (Lower Case) AR98.1
Cu Addr4 Credit union address line 4.
ARU-CU-CITY Alpha 18 (Lower Case) AR98.1
Cu City Credit Union City.
ARU-CU-STATE Alpha 2 AR98.1
Cu State Credit Union State.
ARU-CU-POSTAL-CODE Alpha 12 AR98.1
Cu Postal Code Credit Union Postal Code.
ARU-CU-COUNTRY Alpha 30 (Lower Case) AR98.1
Cu Country Credit Union Country.
ARU-CU-COUNTRY-CD Alpha 2 AR98.1
Cu Country Cd Credit Union Country Code.
ARU-THIRD-PARTY Alpha 1 AR98.1
Third Party N = No third party payment
Y = Third party payment allowed
ARU-USR-FLD-01 Alpha 20 AR98.1
Usr Fld 01
ARU-USR-FLD-02 Alpha 20 AR98.1
Usr Fld 02
ARU-USR-FLD-03 Alpha 20 AR98.1
Usr Fld 03
ARU-USR-FLD-04 Alpha 20 AR98.1
Usr Fld 04
ARU-USR-FLD-05 Alpha 20 AR98.1
Usr Fld 05
ARU-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR98.1
E Mail Address
ARU-URL-ADDR Alpha 60 (Lower Case) AR98.1
Url Addr
ARCCUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARUSET1 COMPANY This is the primary path used for AR501 AR98.1
CUSTOMER accessing converted customers.
|
