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. |
|
||
ARU-CUSTOMER Element: Customer | Alpha 9 (Right Justified) Required. Customer number. |
|
||
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 |
|
||
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. |
|
||
ARU-HOLD-CODE Element: Hold Code | Alpha 4 Hold code assessed to this customer. |
|
||
ARU-CONTACT Element: Primary Contact | Alpha 20 Name of the primary contact. |
|
||
ARU-INT-PREFIX Element: International Prefix | Alpha 6 International telephone prefix. |
|
||
ARU-PHONE-NMBR Element: Telephone Number | Alpha 15 Telephone number. |
|
||
ARU-PHONE-EXT Element: Telephone Extension | Alpha 5 This field contains the telephone extension number. |
|
||
ARU-TELEX-NBR Element: Telex Number | Alpha 15 Phone number. |
|
||
ARU-EDI-NBR Element: EDI Number | Alpha 15 Electronic Data Interchange number. |
|
||
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. |
|
||
ARU-ALT-EDI-TYPE Element: Alternate EDI Type | Alpha 5 Indicates the type of the alternate EDI number. |
|
||
ARU-FAX-NMBR Element: Fax Number | Alpha 15 Fax number. |
|
||
ARU-FAX-EXT Element: Fax Extension | Alpha 5 This field contains the telephone extension number. |
|
||
ARU-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Origin date or starting date of business with this customer. |
|
||
ARU-CREDIT-ANLYST Element: Credit Analyst | Alpha 4 Credit analyst code assigned to this customer. If left blank, will default from customer defaults code. |
|
||
ARU-CURRENCY-CD Element: Currency Code | Alpha 5 Customer default invoice currency code. |
|
||
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. |
|
||
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. |
|
||
ARU-DEFAULT-CODE Element: Default Code | Alpha 5 Customer default code. Required. |
|
||
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. |
|
||
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. |
|
||
ARU-OPEN-ORDS Element: Total Open Orders | Signed 18.2 Total amount of open orders for this customer. Must be a positive amount. |
|
||
ARU-ORDER-LIM Element: Open Order Limit | Signed 15.0 Order limit amount for the total amount of open orders for this customer. |
|
||
ARU-CREDIT-LIM Element: Credit Limit | Signed 15.0 Total amount of credit for this customer. |
|
||
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. |
|
||
ARU-CREDIT-REVDAYS Element: Credit Review Days | Signed 3.0 Number of days that determine the intervals between credit limit reviews. |
|
||
ARU-LAST-PMT-AMT Element: Last Payment Amount | Signed 18.2 Amount of last payment in company base currency. |
|
||
ARU-LAST-PMT-DATE Element: Last Payment Date | Numeric 8 (yyyymmdd) Date of last payment to this company for this customer. |
|
||
ARU-LAST-INV-DATE Element: Last Invoice Date | Numeric 8 (yyyymmdd) Last invoice date. |
|
||
ARU-LAST-INV-AMT Element: Intl Amt | Signed 18.2 |
|
||
ARU-LAST-STA-DATE Element: Last Statement Date | Numeric 8 (yyyymmdd) Date of last statement for this customer. |
|
||
ARU-LAST-STA-BAL Last Statement Balance | Signed 18.2 Last statement balance for this customer in company base currency. |
|
||
ARU-REVIEW-DATE Element: Review Date | Numeric 8 (yyyymmdd) Last date the customer was set for review. System date defaults if left blank. |
|
||
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 |
|
||
ARU-HIGH-BAL Highest Customer Balance | Signed 15.0 Occurs 13 Times Highest customer balance for this company for this period. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
ARU-DISC-GRACE-PD Discount Grace Period | Numeric 2 Grace days added to discount date to allow or disallow discount during cash application. |
|
||
ARU-CR-VAR-PCT Credit Variance Percent | Numeric 3 Override percent used for customer credit limit selections. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
ARU-STATEMENT-REQ Element: Statement Required | Alpha 1 Statement required option. Valid values are: N = No statements required Y = Statements required |
|
||
ARU-STMNT-CYCLE Element: Statement Cycle | Alpha 2 Statement cycle code used to group customers for statement processing. |
|
||
ARU-LOCK-BOX Element: Lock Box | Alpha 2 Remit to location for payment receipts. If left blank, the company address will be used. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
ARU-DISC-REAS-CD Element: Discount Reason Code | Alpha 4 Default discount reason code for earned discounts during cash application. |
|
||
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. |
|
||
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 |
|
||
ARU-AR-CODE Accounts Receivable Code | Alpha 4 Accounts receivable general ledger account used as a default for transaction record creation. |
|
||
ARU-TERMS-CD Element: Terms Code | Alpha 5 Default terms code to be used for invoicing for this customer. |
|
||
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. |
|
||
ARU-DBT-PR-YR Element: Previous Year DBT | Signed 3.0 Last year's Days Beyond Terms indicator. |
|
||
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. |
|
||
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). |
|
||
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 |
|
||
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 |
|
||
ARU-FIN-CHRG-CD Element: Finance Charge Code | Alpha 2 Finance charge code containing a percentage rate used for finance charge calculations. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
ARU-TERRITORY Element: Sales Territory | Alpha 4 Sales Territory. |
|
||
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 |
|
||
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. |
|
||
ARU-ADDR1 Element: Address 1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
ARU-ADDR2 Element: Address 2 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
ARU-ADDR3 Element: Address 3 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
ARU-ADDR4 Element: Address 4 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
ARU-CITY Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||
ARU-STATE Element: State or Province | Alpha 2 This field contains the two-character state or province code of the address. |
|
||
ARU-ZIP Element: Postal Code | Alpha 10 This field contains the postal code of the address. |
|
||
ARU-COUNTY Element: County | Alpha 25 (Lower Case) This field contains the county of the address. |
|
||
ARU-DUNN-CD Dun and Bradstreet Code | Alpha 3 Dun and Bradstreet rating code. |
|
||
ARU-DUNN-DATE Dunn and Bradstreet Date | Numeric 8 (yyyymmdd) The date the Dunn Code was established. |
|
||
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. |
|
||
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. |
|
||
ARU-CRED-LIM-GRP Element: Group Credit Limit | Signed 15.0 Credit limit at the customer group level for all companies. |
|
||
ARU-HOLD-CODE-GRP Element: Group Hold Code | Alpha 4 Hold code at the customer group level. |
|
||
ARU-TITLE Element: Contact Title | Alpha 30 (Lower Case) Contact title. |
|
||
ARU-NAT-COMPANY National Account Company | Numeric 4 National account company for this customer. Must be entered if a national account customer is entered. |
|
||
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. |
|
||
ARU-CUST-USER1 Element: Customer User 1 | Alpha 10 Customer 1 user field |
|
||
ARU-CUST-USER2 Element: Customer User 2 | Alpha 18 Customer 2 user field. |
|
||
ARU-CUST-USER3 Element: Customer User 3 | Signed 18.2 Customer user 3 field. |
|
||
ARU-CUST-USER4 Element: Customer User 4 | Signed 18.2 Customer user 4 field. |
|
||
ARU-CUST-USER5 Element: Customer User 5 | Numeric 9 Customer user 5 field. |
|
||
ARU-CUST-USER6 Element: Customer User 6 | Alpha 30 Customer user 6 field. |
|
||
ARU-CUST-USER7 Element: Customer User 7 | Alpha 30 Customer user 7 field. |
|
||
ARU-CUST-USER8 Element: Customer User 8 | Numeric 8 (yyyymmdd) Customer user 8 field. Date format, YYYYMMDD. |
|
||
ARU-CUST-USER9 Element: Customer User 9 | Numeric 3 Customer user 9 field. |
|
||
ARU-CUST-USER10 Element: Customer User 10 | Alpha 3 Customer user 10 field. |
|
||
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. |
|
||
ARU-FIN-CYCLE Finance Charge Cycle Code | Alpha 2 Finance charge cycle code. |
|
||
ARU-DUN-CYCLE Element: Dunning Cycle Code | Alpha 2 Dunning cycle code. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
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. |
|
||
ARU-VAT-CUST-TYPE Element: Vat Cust Type | Alpha 2 The VAT customer type. |
|
||
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). |
|
||
ARU-BANK-ENTITY Element: Bank Entity | Alpha 15 Represents a bank institution location. |
|
||
ARU-BANK-ACCT-NBR Element: Bank Acct Nbr | Alpha 35 The bank-assigned account number identification to be used for the cash code. |
|
||
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). |
|
||
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) |
|
||
ARU-DUN-LTR-IND Element: Dun Ltr Ind | Alpha 1 Specifies whether the advanced dunning letter process is to be used. |
|
||
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. |
|
||
ARU-ASSESS-DUN-FEE Element: Assess Dun Fee | Alpha 1 Specifies whether to assess a dunning letter fee. |
|
||
ARU-CU-NAME Element: Cu Name | Alpha 30 Credit Union Name. |
|
||
ARU-CU-ADDR1 Element: Cu Addr1 | Alpha 30 (Lower Case) Credit Union Address Line 1. |
|
||
ARU-CU-ADDR2 Element: Cu Addr2 | Alpha 30 (Lower Case) Credit Union Address Line 2. |
|
||
ARU-CU-ADDR3 Element: Cu Addr3 | Alpha 30 (Lower Case) Credit union address line 3. |
|
||
ARU-CU-ADDR4 Element: Cu Addr4 | Alpha 30 (Lower Case) Credit union address line 4. |
|
||
ARU-CU-CITY Element: Cu City | Alpha 18 (Lower Case) Credit Union City. |
|
||
ARU-CU-STATE Element: Cu State | Alpha 2 Credit Union State. |
|
||
ARU-CU-POSTAL-CODE Element: Cu Postal Code | Alpha 12 Credit Union Postal Code. |
|
||
ARU-CU-COUNTRY-CD Element: Cu Country Cd | Alpha 2 Credit Union Country Code. |
|
||
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 |
|
||
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. |
|
||
ARU-USR-FLD-02 Element: Usr Fld 02 | Alpha 20 Extra user field 2. |
|
||
ARU-USR-FLD-03 Element: Usr Fld 03 | Alpha 20 Extra user field 3. |
|
||
ARU-USR-FLD-04 Element: Usr Fld 04 | Alpha 20 Extra user field 4. |
|
||
ARU-USR-FLD-05 Element: Usr Fld 05 | Alpha 20 Extra user field 5. |
|
||
ARU-E-MAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) Email address of customer. |
|
||
ARU-URL-ADDR Element: Url Addr | Alpha 60 (Lower Case) URL address of customer. |
|
||
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 |
|
||
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. |
|
||
ARU-RIBKEY Element: Ribkey | Numeric 2 This field contains the Ribkey value for the bank account number. |
|
||
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. |
|
||
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. |
|
||
ARU-PAY-AUTO-AMT Element: Intl Amt | Signed 18.2 |
|
||
ARU-PAY-AUTO-PCT Element: Max Auto Pct | Signed 5.5 |
|
||
ARU-PAY-REAS-CD Element: Auto Reas Cd | Alpha 4 |
|
||
ARU-MULT-DUN-LTR Element: Flag | Alpha 1 " " N = No Y = Yes |
|
||
ARU-CU-COUNTY Element: County | Alpha 25 (Lower Case) |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
ARUSET1 |
COMPANY CUSTOMER |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Arccust2 | ARCCUST2 |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.