ARCCUST

AR Customer Conversion

The AR Customer Conversion file is used to convert customer records from an external source. Records in this file have been populated from an external source and will be loaded into the Accounts Receivable system via AR501 (Customer Conversion). Field data populated 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
Element: Company
Numeric 4
The number representing an AR company.
AR98.1
ARU-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Required. Customer number.
AR98.1
ARU-ACTIVE-STATUS
Element: Customer Status
Alpha 1
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
AR98.1
ARU-SEARCH-NAME
Element: Search Name
Alpha 30
Search name assigned to this customer for search and sorting capabilities. Defaults from customer name if not present.
AR98.1
ARU-HOLD-CODE
Element: Hold Code
Alpha 4
Hold code assessed to this customer.
AR98.1
ARU-CONTACT
Element: Primary Contact
Alpha 20
Name of the primary contact.
AR98.1
ARU-INT-PREFIX
Element: International Prefix
Alpha 6
International telephone prefix.
AR98.1
ARU-PHONE-NMBR
Element: Telephone Number
Alpha 15
Telephone number.
AR98.1
ARU-PHONE-EXT
Element: Telephone Extension
Alpha 5
This field contains the telephone extension number.
AR98.1
ARU-TELEX-NBR
Element: Telex Number
Alpha 15
Phone number.
AR98.1
ARU-EDI-NBR
Element: EDI Number
Alpha 15
Electronic Data Interchange number.
AR98.1
ARU-ALT-EDI-NBR
Element: Alternate EDI Number
Alpha 95
This is a free-form field to accommodate an alternate EDI number or electronic address.
AR98.1
ARU-ALT-EDI-TYPE
Element: Alternate EDI Type
Alpha 5
Indicates the type of the alternate EDI number.
AR98.1
ARU-FAX-NMBR
Element: Fax Number
Alpha 15
Fax number.
AR98.1
ARU-FAX-EXT
Element: Fax Extension
Alpha 5
This field contains the telephone extension number.
AR98.1
ARU-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Origin date or starting date of business with this customer.
AR98.1
ARU-CREDIT-ANLYST
Element: Credit Analyst
Alpha 4
Credit analyst code assigned to this customer. If left blank, will default from customer defaults code.
AR98.1
ARU-CURRENCY-CD
Element: Currency Code
Alpha 5
Customer default invoice currency code.
AR98.1
ARU-SALESMAN
Element: SalesRep
Numeric 4
This field contains the code that represents the primary sales representative for this customer. If left blank, this defaults from the customer defaults code.
AR98.1
ARU-RISK-CD
Element: Risk Code
Alpha 1
User-defined risk code used for customer reporting selections. If left blank, company defined risk code will default.
AR98.1
ARU-DEFAULT-CODE
Element: Default Code
Alpha 5
Customer default code. Required.
AR98.1
ARU-MAJ-CLASS
Element: Major Class
Alpha 4
Major class used for customer reporting and processing for this customer. If left blank, will default from customer default code.
AR98.1
ARU-MIN-CLASS
Element: Minor Class
Alpha 4
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.
AR98.1
ARU-OPEN-ORDS
Element: Total Open Orders
Signed 18.2
Total amount of open orders for this customer. Must be a positive amount.
AR98.1
ARU-ORDER-LIM
Element: Open Order Limit
Signed 15.0
Order limit amount for the total amount of open orders for this customer.
AR98.1
ARU-CREDIT-LIM
Element: Credit Limit
Signed 15.0
Total amount of credit for this customer.
AR98.1
ARU-CREDIT-LIM-DAT
Element: Credit Limit Date
Numeric 8 (yyyymmdd)
The date the credit limit was established. System date will default if left blank.
AR98.1
ARU-CREDIT-REVDAYS
Element: Credit Review Days
Signed 3.0
Number of days that determine the intervals between credit limit reviews.
AR98.1
ARU-LAST-PMT-AMT
Element: Last Payment Amount
Signed 18.2
Amount of last payment in company base currency.
AR98.1
ARU-LAST-PMT-DATE
Element: Last Payment Date
Numeric 8 (yyyymmdd)
Date of last payment to this company for this customer.
AR98.1
ARU-LAST-INV-DATE
Element: Last Invoice Date
Numeric 8 (yyyymmdd)
Last invoice date.
AR98.1
ARU-LAST-INV-AMT
Element: Intl Amt
Signed 18.2
AR98.1
ARU-LAST-STA-DATE
Element: Last Statement Date
Numeric 8 (yyyymmdd)
Date of last statement for this customer.
AR98.1
ARU-LAST-STA-BAL
Last Statement
Balance
Signed 18.2
Last statement balance for this customer in company base currency.
AR98.1
ARU-REVIEW-DATE
Element: Review Date
Numeric 8 (yyyymmdd)
Last date the customer was set for review. System date defaults if left blank.
AR98.1
ARU-REVIEW-CODE
Element: Review Code
Alpha 1
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
AR98.1
ARU-HIGH-BAL
Highest Customer
Balance
Signed 15.0 Occurs 13 Times
Highest customer balance for this company for this period.
AR98.1
ARU-PER-RTMS
Element: Period RTMs
Signed 3.0 Occurs 13 Times
Period return-to-maker payment occurrences.
ARU-PAID-PRMPT
Element: Paid Prompt
Signed 5.0 Occurs 12 Times
The number of invoices paid prompt for this period. Invoices cleared by chargebacks are not considered.
ARU-INV-PAID
Element: Paid Invoices
Signed 5.0 Occurs 12 Times
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
Element: Collect Days
Signed 3.0 Occurs 11 Times
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.
AR98.1
ARU-CURR-CASH
Element: Current Cash
Signed 18.2
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
Element: Current Cash Days
Signed 18.2
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
Element: YTD Cash
Signed 18.2
Year to date total of cash for fully paid transactions.
AR98.1
ARU-YTD-CSH-DAYS
Element: YTD Cash Days
Signed 18.2
Year to date calculation of cash paid and applied to an open item multiplied by the number of days to fully pay the transactions.
AR98.1
ARU-YEAR-2-DAYS
Element: Previous Year IPA
Signed 3.0
Weighted invoice payment average for the year previous to the totals being summed in Collect Days occurrences.
AR98.1
ARU-STATIC-CUR
Element: Current Static Aged
Signed 18.2
Static aged current portion of a customer's balance.
ARU-AGING
Element: Aging
Signed 18.2 Occurs 5 Times
Static aged past due amounts in company base currency for this customer.
ARU-AGE-DISPUTES
Element: Age Disputes
Alpha 1
Specifies how disputed invoices will be aged. Valid values are: N = Not aged - aged in current column Y = Age respective to date
AR98.1
ARU-DISPUTES-FIN
Element: Finance Disputes
Alpha 1
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
AR98.1
ARU-AUTO-APP-FL
Element: Auto Application
Alpha 1
Automatic cash application indicator. Valid values are: N = Not subject to automatic application Y = Subject to automatic application
AR98.1
ARU-AUTO-DUNN-FL
Element: Auto Dunning
Alpha 1
Indicates whether or not automatic selection of dunning letters will be allowed. Valid values are: N = No automatic dunning Y = Automatic dunning
AR98.1
ARU-DISC-GRACE-PD
Discount Grace
Period
Numeric 2
Grace days added to discount date to allow or disallow discount during cash application.
AR98.1
ARU-CR-VAR-PCT
Credit Variance
Percent
Numeric 3
Override percent used for customer credit limit selections.
AR98.1
ARU-MEMO-TERM
Element: Memo Terms Code
Alpha 5
Memo terms code. Must be a valid net or prepayment type terms code defined in the Lawson Terms system.
AR98.1
ARU-CHRGBK-PRT-FL
Element: Print Chargebacks
Alpha 1
Specifies whether chargebacks will be printed. Valid values are: N = Do not print chargebacks Y = Print chargebacks
AR98.1
ARU-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
AR98.1
ARU-STATEMENT-REQ
Element: Statement Required
Alpha 1
Statement required option. Valid values are: N = No statements required Y = Statements required
AR98.1
ARU-STMNT-CYCLE
Element: Statement Cycle
Alpha 2
Statement cycle code used to group customers for statement processing.
AR98.1
ARU-LOCK-BOX
Element: Lock Box
Alpha 2
Remit to location for payment receipts. If left blank, the company address will be used.
AR98.1
ARU-ZERO-STMNT-FL
Element: Zero Statements
Alpha 1
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
AR98.1
ARU-CRED-STMNT-FL
Element: Credit Statements
Alpha 1
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
AR98.1
ARU-PAST-STMNT-FL
Element: Past Due Statements
Alpha 1
Past due open items only statements. Valid values are: N = No open item only past due statements Y = Open item only past due statements
AR98.1
ARU-OVER-STMNT-FL
Credit Exceeded
Statements
Alpha 1
Over credit limit statement option. Valid values are: N = No only balance exceeding credit limit statements. Y = Produce only balance exceeding credit limit statements.
AR98.1
ARU-MAX-AUTO-AMT
Maximum Automatic
Amount
Signed 18.2 Occurs 3 Times
Maximum open item shortage amount during cash application that may be automatically written off. Multiple amounts must be in ascending order.
AR98.1
ARU-MAX-AUTO-PCT
Maximum Automatic
Percent
Signed 5.5 Occurs 3 Times
Maximum open item percentage amount during cash application that may be automatically written off. Multiple percentages must be in ascending order.
AR98.1
ARU-AUTO-REAS-CD
Automatic Reason
Code
Alpha 4 Occurs 3 Times
This reason code is required if there is a shortage amount or shortage percentage entered.
AR98.1
ARU-DISC-REAS-CD
Element: Discount Reason Code
Alpha 4
Default discount reason code for earned discounts during cash application.
AR98.1
ARU-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.
AR98.1
ARU-DRAFT-FLAG
Bill of Exchange
Flag
Alpha 1
If the customer has a bill of exchange 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
AR98.1
ARU-AR-CODE
Accounts Receivable
Code
Alpha 4
Accounts receivable general ledger account used as a default for transaction record creation.
AR98.1
ARU-TERMS-CD
Element: Terms Code
Alpha 5
Default terms code to be used for invoicing for this customer.
AR98.1
ARU-TERMS-CASH
Element: Paid Amount
Signed 18.2
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
Element: Paid Cash Days
Signed 18.2
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
Element: DBT Ratio
Signed 3.0 Occurs 11 Times
Days Beyond Terms indicator for this period. Used in customer credit analysis.
AR98.1
ARU-DBT-PR-YR
Element: Previous Year DBT
Signed 3.0
Last year's Days Beyond Terms indicator.
AR98.1
ARU-DBT-YTD-CASH
Element: YTD Cash Paid
Signed 18.2
This field contains the cash paid amount for fully paid transactions for the year.
AR98.1
ARU-DBT-YTD-DAYS
Element: YTD Cash Days
Signed 18.2
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).
AR98.1
ARU-LATE-PAY-FL
Element: Late Payment Flag
Alpha 1
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
AR98.1
ARU-FIN-CALC-TYPE
Finance Calculation
Type
Alpha 1
Determines the method of finance charge calculations. Valid values are: D = Detail per open item finance charges N = Net balance finance charges
AR98.1
ARU-FIN-CHRG-CD
Element: Finance Charge Code
Alpha 2
Finance charge code containing a percentage rate used for finance charge calculations.
AR98.1
ARU-FIN-GRAC-DAYS
Element: Finance Grace Days
Numeric 2
The number of grace days added to due date before finance charges will be assessed.
AR98.1
ARU-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.
AR98.1
ARU-FIN-DOC-PRNT
Print Finance
Charge Documents
Alpha 1
Specifies whether or not finance charge documents are required to be printed. Valid values are: N = No finance charge documents required Y = Finance charge documents printed
AR98.1
ARU-LAST-DUNN
Element: Last Dunning
Numeric 2
The last dunning letter number produced for the customer.
ARU-LAST-DUN-DATE
Element: Last Dunning Date
Numeric 8 (yyyymmdd)
The date of the last dunning letter produced for this customer.
ARU-TAX-EXEMPT-CD
Element: Tax Exempt Code
Alpha 1
Used by the Lawson Order Entry system. Determines whether this customer is tax exempt or not. Valid values are: E = Exempt T = Taxable
AR98.1
ARU-TAX-CODE
Element: Tax Code
Alpha 10
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.
AR98.1
ARU-TERRITORY
Element: Sales Territory
Alpha 4
Sales Territory.
AR98.1
ARU-AGING-CODE
Element: Aging Code
Numeric 2
Aging code providing aging rules for a single customer aging.
ARU-REVALUE-FL
Element: Revalue Flag
Alpha 1
Default revalue indicator for non-base currency transactions. Valid values are: N = No revaluation Y = Revalue
AR98.1
ARU-DISHONORED
Element: Dishonored BOEs
Signed 5.0
This field contains the total number of dishonored Bills of Exchange since the customer was added.
ARU-DISHONORED-AMT
Dishonored BOE
Amount
Signed 18.2
This field contains the total amount of dishonored Bills of Exchange that has accumulated since the customer was added.
ARU-RECONCILE-CASH
Element: Reconcile Cash
Signed 5.0
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
Reconcile
Renegotiations
Signed 5.0
This field will give a count of total number of dishonored Bills of Exchange that have been renegotiated.
ARU-RECONCILE-WO
Element: Reconcile Write Offs
Signed 5.0
This field will give a total count of dishonored Bills of Exchange that have been written off as a bad debt.
ARU-NAME
Element: Customer Name
Alpha 30 (Lower Case)
Customer name. Required.
AR98.1
ARU-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR98.1
ARU-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR98.1
ARU-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR98.1
ARU-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR98.1
ARU-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AR98.1
ARU-STATE
Element: State or Province
Alpha 2
This field contains the two-character state or province code of the address.
AR98.1
ARU-ZIP
Element: Postal Code
Alpha 10
This field contains the postal code of the address.
AR98.1
ARU-COUNTY
Element: County
Alpha 25 (Lower Case)
This field contains the county of the address.
AR98.1
ARU-DUNN-CD
Dun and Bradstreet
Code
Alpha 3
Dun and Bradstreet rating code.
AR98.1
ARU-DUNN-DATE
Dunn and Bradstreet
Date
Numeric 8 (yyyymmdd)
The date the Dunn Code was established.
AR98.1
ARU-LAST-DUN-AMT
Element: Intl Amt
Signed 18.2
The date o fthe last dunning letter produced for the customer.
ARU-DUNN-NUMBER
Dunn and Bradstreet
Number
Numeric 9
The Dunn and Bradstreet cross reference number for this customer.
AR98.1
ARU-OVR-ADDR-FL
Override Address
Flag
Alpha 1
Used by the Lawson Order Entry system for one time customers. Valid values are: N = No address override allowed Y = Address override allowed
ARU-TAX-ID
Element: Tax ID
Alpha 20
Tax identification number.
ARU-ORDER-LIM-GRP
Element: Group Order Limit
Signed 15.0
Order limit amount for the total amount of open orders at the customer group level for all companies.
AR98.1
ARU-CRED-LIM-GRP
Element: Group Credit Limit
Signed 15.0
Credit limit at the customer group level for all companies.
AR98.1
ARU-HOLD-CODE-GRP
Element: Group Hold Code
Alpha 4
Hold code at the customer group level.
AR98.1
ARU-TITLE
Element: Contact Title
Alpha 30 (Lower Case)
Contact title.
AR98.1
ARU-NAT-COMPANY
National Account
Company
Numeric 4
National account company for this customer. Must be entered if a national account customer is entered.
AR98.1
ARU-NAT-CUSTOMER
National Account
Customer
Alpha 9 (Right Justified)
National account customer for this customer. Must be entered if a national account company is entered.
AR98.1
ARU-CUST-USER1
Element: Customer User 1
Alpha 10
Customer 1 user field
AR98.1
ARU-CUST-USER2
Element: Customer User 2
Alpha 18
Customer 2 user field.
AR98.1
ARU-CUST-USER3
Element: Customer User 3
Signed 18.2
Customer user 3 field.
AR98.1
ARU-CUST-USER4
Element: Customer User 4
Signed 18.2
Customer user 4 field.
AR98.1
ARU-CUST-USER5
Element: Customer User 5
Numeric 9
Customer user 5 field.
AR98.1
ARU-CUST-USER6
Element: Customer User 6
Alpha 30
Customer user 6 field.
AR98.1
ARU-CUST-USER7
Element: Customer User 7
Alpha 30
Customer user 7 field.
AR98.1
ARU-CUST-USER8
Element: Customer User 8
Numeric 8 (yyyymmdd)
Customer user 8 field. Date format, YYYYMMDD.
AR98.1
ARU-CUST-USER9
Element: Customer User 9
Numeric 3
Customer user 9 field.
AR98.1
ARU-CUST-USER10
Element: Customer User 10
Alpha 3
Customer user 10 field.
AR98.1
ARU-MINIMUM
Minimum Finance
Charges
Alpha 1
Determines if minimum finance 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.
AR98.1
ARU-FIN-CYCLE
Finance Charge
Cycle Code
Alpha 2
Finance charge cycle code.
AR98.1
ARU-DUN-CYCLE
Element: Dunning Cycle Code
Alpha 2
Dunning cycle code.
AR98.1
ARU-AUTO-METHOD
Auto Cash
Application Method
Alpha 1
Automatic cash application method. Valid values are: A = Algorithm B = Balance forward L = Last statement R = Remittance
AR98.1
ARU-AUTO-REMOVE
Element: Auto Remove
Alpha 1

N = No
Y = Yes
ARU-CB-DTL-DATE
Element: Cb Dtl Date
Alpha 1
This field will determine which dates are used in calculating the transaction and due dates of detail chargebacks.
I = Invoice
P = Payment
AR98.1
ARU-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.
AR98.1
ARU-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.
AR98.1
ARU-VAT-CUST-TYPE
Element: Vat Cust Type
Alpha 2
The VAT customer type.
AR98.1
ARU-LANGUAGE-CODE
Element: Language Code
Alpha 10
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).
AR98.1
ARU-BANK-ENTITY
Element: Bank Entity
Alpha 15
Represents a bank institution location.
AR98.1
ARU-BANK-ACCT-NBR
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification to be used for the cash code.
AR98.1
ARU-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR98.1
ARU-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AR98.1
ARU-DUN-LTR-IND
Element: Dun Ltr Ind
Alpha 1
Specifies whether the advanced dunning letter process is to be used.
AR98.1
ARU-DUN-PROCESS-CD
Element: Dun Process Cd
Alpha 6
Dunning letter process code. A unique code that represents a combination of Dunning Letter options.
AR98.1
ARU-ASSESS-DUN-FEE
Element: Assess Dun Fee
Alpha 1
Specifies whether to assess a dunning letter fee.
AR98.1
ARU-CU-NAME
Element: Cu Name
Alpha 30
Credit Union Name.
AR98.1
ARU-CU-ADDR1
Element: Cu Addr1
Alpha 30 (Lower Case)
Credit Union Address Line 1.
AR98.1
ARU-CU-ADDR2
Element: Cu Addr2
Alpha 30 (Lower Case)
Credit Union Address Line 2.
AR98.1
ARU-CU-ADDR3
Element: Cu Addr3
Alpha 30 (Lower Case)
Credit union address line 3.
AR98.1
ARU-CU-ADDR4
Element: Cu Addr4
Alpha 30 (Lower Case)
Credit union address line 4.
AR98.1
ARU-CU-CITY
Element: Cu City
Alpha 18 (Lower Case)
Credit Union City.
AR98.1
ARU-CU-STATE
Element: Cu State
Alpha 2
Credit Union State.
AR98.1
ARU-CU-POSTAL-CODE
Element: Cu Postal Code
Alpha 12
Credit Union Postal Code.
AR98.1
ARU-CU-COUNTRY-CD
Element: Cu Country Cd
Alpha 2
Credit Union Country Code.
AR98.1
ARU-THIRD-PARTY
Element: Third Party
Alpha 1
This field indicates if this customer's payments may be applied to any customer's open transactions.
N = No third party payment
Y = Third party payment allowed
AR98.1
ARU-FILLER99
Element: Filler99
Alpha 99
Used for table splitting considerations.
ARU-USR-FLD-01
Element: Usr Fld 01
Alpha 20
Extra user field 1.
AR98.1
ARU-USR-FLD-02
Element: Usr Fld 02
Alpha 20
Extra user field 2.
AR98.1
ARU-USR-FLD-03
Element: Usr Fld 03
Alpha 20
Extra user field 3.
AR98.1
ARU-USR-FLD-04
Element: Usr Fld 04
Alpha 20
Extra user field 4.
AR98.1
ARU-USR-FLD-05
Element: Usr Fld 05
Alpha 20
Extra user field 5.
AR98.1
ARU-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
Email address of customer.
AR98.1
ARU-URL-ADDR
Element: Url Addr
Alpha 60 (Lower Case)
URL address of customer.
AR98.1
ARU-CUST-AUDIT
Element: Cust Audit
Alpha 1
This field indicates if customer changes will be audited. Valid values are: N = No changes audited Y = Changes audited
AR501 AR98.1
ARU-APPLY-MIXED
Element: Apply Mixed
Alpha 1
This field indicates if transactions with mixed signed line items will have credit lines applied to debit lines upon transaction interface and transaction release.
AR98.1
ARU-RIBKEY
Element: Ribkey
Numeric 2
This field contains the Ribkey value for the bank account number.
AR98.1
ARU-VBANK-IDENT
Element: Alphadata1
Alpha 1
This field indicates if the bank account number is an IBAN number that requires an account validation check.
AR98.1
ARU-BANK-TRAN-CD
Element: Bank Tran Cd
Alpha 2
This field contains the bank transaction code for the bank account number.
ARU-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 enbales this customer to be part of a customer list for reporting purposes.
AR98.1
ARU-PAY-AUTO-AMT
Element: Intl Amt
Signed 18.2
AR98.1
ARU-PAY-AUTO-PCT
Element: Max Auto Pct
Signed 5.5
AR98.1
ARU-PAY-REAS-CD
Element: Auto Reas Cd
Alpha 4
AR98.1
ARU-MULT-DUN-LTR
Element: Flag
Alpha 1

" "
N = No
Y = Yes
AR98.1
ARU-CU-COUNTY
Element: County
Alpha 25 (Lower Case)
AR98.1
ARU-LEGAL-NAME
Element: Legal Name
Alpha 80 (Lower Case)
The legal name for customers that contain the city and/or county information on it.
AR98.1


ARCCUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARUSET1 COMPANY
CUSTOMER
AR501 AR98.1


ARCCUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arccust2 ARCCUST2 Required
ARU-COMPANY->AR2-COMPANY
ARU-CUSTOMER->AR2-CUSTOMER


File created: Thu Jun 09 02:08:58 2016

Home
Contact Us



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