AR Company Customer
The AR Company Customer file will contain customer information that is relevant to a specific company level customer. The customer processing rules for the company are defined and maintained in this record. Statistical fields and other processing fields are also contained on this record.
REFERENCED BY
| AR09.1 | AR10.1 | AR10.2 | AR12.1 | AR12.2 | AR13.1 |
| AR13.2 | AR17.1 | AR301 | AR501 | AR550 | ARLL.1 |
| CB06.2 | CB191 | TX140 | WH20.7 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACM-COMPANY Element: Company | Numeric 4 The accounts receivable company assigned to the customer. |
|
||||||||||
| ACM-CUSTOMER Element: Customer | Alpha 9 (Right Justified) The unique identifier assigned to the customer. |
|
||||||||||
| ACM-ACTIVE-STATUS Element: Active Status | Alpha 1 Indicates the status of the customer. Valid values are: A = Active I = Inactive D = Set for deletion |
|
||||||||||
| ACM-NAT-FLAG National Account Flag | Alpha 1 Indicates whether the customer is a national account customer. If a customer is a national account customer, it cannot be an invoiced customer to another national account. Valid values are: I = Invoiced customer N = National account Blank = Not part of a national account |
|
||||||||||
| ACM-SEARCH-NAME Element: Search Name | Alpha 30 The search name for the customer. Reports can be sequenced using this field. If left blank when adding the customer, the search name defined in AR09.1 (Customer Group Address) defaults. |
|
||||||||||
| ACM-HOLD-CODE Element: Hold Code | Alpha 4 Indicates whether a customer is on hold. |
|
||||||||||
| ACM-CONTACT Element: Primary Contact | Alpha 20 Primary contact name for this customer. |
|
||||||||||
| ACM-INT-PREFIX International Telephone Prefix | Alpha 6 The international telephone number prefix. |
|
||||||||||
| ACM-PHONE-NMBR Element: Telephone Number | Alpha 15 The telephone number for this customer. |
|
||||||||||
| ACM-PHONE-EXT Element: Telephone Extension | Alpha 5 The telephone extension number for the customer. |
|
||||||||||
| ACM-TELEX-NBR Element: Telex Number | Alpha 15 The telex number for the customer. |
|
||||||||||
| ACM-EDI-NBR Element: EDI Number | Alpha 15 The electronic data interchange (EDI) number assigned to the customer. Used by the Lawson Order Entry system or external order processing systems. |
|
||||||||||
| ACM-ALT-EDI-NBR Element: Alternate EDI Number | Alpha 95 This is a free-form field to accommodate an alternate EDI number or address. |
|
||||||||||
| ACM-ALT-EDI-TYPE Element: Alternate EDI Type | Alpha 5 Indicates the type of the alternate EDI number. |
|
||||||||||
| ACM-FAX-NMBR Element: Fax Number | Alpha 15 The customer's fax number. |
|
||||||||||
| ACM-FAX-EXT Element: Fax Extension | Alpha 5 The customer's fax extension. |
|
||||||||||
| ACM-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) The date the customer first began doing business with the company. If left blank when adding a customer, the system date defaults. |
|
||||||||||
| ACM-CREDIT-ANLYST Element: Credit Analyst | Alpha 4 The credit analyst code assigned to this customer. |
|
||||||||||
| ACM-CURRENCY-CD Element: Currency Code | Alpha 5 The default currency in which the customer will be invoiced. If the company has Yes selected the Currency Override field in AR01 (Company), this default currency can be overridden during invoice entry. If the company has No selected, the customer can be invoiced in this default currency only. |
|
||||||||||
| ACM-SALESMAN Element: SalesRep | Numeric 4 The primary sales representative for this customer. This salesrep is used on various programs for selection and sorting. |
|
||||||||||
| ACM-RISK-CD Element: Risk Code | Alpha 1 The risk code is used for risk analysis. Defaults from the company. |
|
||||||||||
| ACM-DEFAULT-CODE Element: Default Code | Alpha 5 The customer default code is used to default values and options into the customer record when the customer is added into the system. This field is required and must be a valid default code defined in AR08 (Customer Defaults). |
|
||||||||||
| ACM-MAJ-CLASS Element: Major Class | Alpha 4 The major class assigned to this customer. |
|
||||||||||
| ACM-MIN-CLASS Element: Minor Class | Alpha 4 The minor class assigned to this customer. |
|
||||||||||
| ACM-CURR-BAL Element: Current Balance | Signed 18.2 The current balance for the customer. |
|
||||||||||
| ACM-DRAFT-BAL Bill of Exchange Balance | Signed 18.2 The bill of exchange balance for this customer. |
|
||||||||||
| ACM-OPEN-ORDS Element: Open Order Total | Signed 18.2 The total amount of orders that have been entered into an external order processing system but have not yet been invoiced. |
|
||||||||||
| ACM-ORDER-LIM Element: Open Order Limit | Signed 15.0 The limit for the total amount of open orders allowed for this customer. Zero means the order amount is not limited. This value is maintained in the Lawson Accounts Receivable system and is used by external order processing systems. |
|
||||||||||
| ACM-CREDIT-LIM Element: Credit Limit | Signed 15.0 Total amount of credit extended to a customer. Zero means unlimited credit is extended to this customer. This value is maintained in the Lawson Accounts Receivable system but is meant to be edited by order entry systems. For example: An order may be placed on hold if the amount of the order will cause the customer balance to exceed the credit limit defined in this field. |
|
||||||||||
| ACM-CREDIT-LIM-DAT Element: Credit Limit Date | Numeric 8 (yyyymmdd) The date the credit limit was defined or last reviewed. |
|
||||||||||
| ACM-CREDIT-REVDAYS Element: Credit Review Days | Signed 3.0 The number of days between the credit limit reviews for the customer. |
|
||||||||||
| ACM-LAST-PMT-AMT Element: Last Payment Amount | Signed 18.2 The amount of the last payment made by this customer. |
|
||||||||||
| ACM-LAST-PMT-DATE Element: Last Payment Date | Numeric 8 (yyyymmdd) The date of the last payment made by the customer. |
|
||||||||||
| ACM-LAST-INV-DATE Element: Last Invoice Date | Numeric 8 (yyyymmdd) The date of the last (most recent date) invoice for this customer. |
|
||||||||||
| ACM-LAST-INV-AMT Element: Intl Amt | Signed 18.2 The amount of the last (most recent date) invoice for this customer. |
|
||||||||||
| ACM-LAST-STA-DATE Element: Last Statement Date | Numeric 8 (yyyymmdd) The date of the last statement for this customer. |
|
||||||||||
| ACM-LAST-STA-BAL Last Statement Balance | Signed 18.2 The customer's balance on their last statement. |
|
||||||||||
| ACM-REVIEW-DATE Element: Review Date | Numeric 8 (yyyymmdd) The last date the customer was defined for review. AR17 (Comments) and AR70 (Analyst Customer Review) are used to define this date. AR170 (Customer Review Selection) selects the customer when this date is reached. |
|
||||||||||
| ACM-REVIEW-CODE Element: Review Code | Alpha 1 Indicates the status of the customer's review record. Valid values are: O = Open R = Reviewed |
|
||||||||||
| ACM-HIGH-BAL Element: Highest Balance | Signed 15.0 Occurs 13 Times The highest balance for the customer for the period. |
|
||||||||||
| ACM-PER-RTMS Element: Period RTMs | Signed 3.0 Occurs 13 Times Period Return-to-Maker debit memos. The number of payments that have been returned to the customer for the period. |
|
||||||||||
| ACM-PAID-PRMPT Element: Paid Prompt | Signed 5.0 Occurs 12 Times The number of invoices that were paid in full within the due date of the invoice (incorporating grace days). Invoices cleared by chargebacks are not considered. |
|
||||||||||
| ACM-INV-PAID Element: Paid Invoices | Signed 5.0 Occurs 12 Times A count of invoices fully paid within the period. This will be used in the Invoice Payment Average (IPA) and Days Beyond Terms (DBT) calculations for each customer. |
|
||||||||||
| ACM-COLLECT-DAYS Element: Collect Days | Signed 3.0 Occurs 11 Times A collection ratio of days to collect those invoices that have been fully paid in a specific period. It will include invoices and only debit memos generated from chargebacks. This will be a weighted calculation based on the amount of invoice. |
|
||||||||||
| ACM-CURR-CASH Element: Current Cash | Signed 18.2 The cash paid amount from fully paid transactions. At the end of a current period, it will be used to calculate the ratio for the Collect Days field. |
|
||||||||||
| ACM-CURR-CSH-DAYS Element: Current Cash Days | Signed 18.2 The Flow of Funds Cash Days calculated value (paid amount multiplied by the number of days to fully pay) for the current period. |
|
||||||||||
| ACM-YTD-CASH Element: Year-to-Date Cash | Signed 18.2 The year-to-date total of cash for fully paid transactions. |
|
||||||||||
| ACM-YTD-CSH-DAYS Year-to-Date Cash Days | Signed 18.2 The year to date calculation of cash paid and applied to an open item times the number of days it took to fully pay the transactions. |
|
||||||||||
| ACM-YEAR-2-DAYS Element: Previous Year IPA | Signed 3.0 The weighted invoice payment average for the year previous to the totals being tallied in "COLLECT DAYS" period buckets. |
|
||||||||||
| ACM-STATIC-CUR Current Static Balance | Signed 18.2 The static current portion of a customer's balance as of the last running of AR194 (Audit Summary). |
|
||||||||||
| ACM-AGING Element: Aging | Signed 18.2 Occurs 5 Times These aging buckets carry the static past-due amounts in each aging period for a given customer. These fields are updated by AR194 (Audit Summary). |
|
||||||||||
| ACM-LAST-COMMENT Element: Last Comment | Numeric 6 The last sequence number for comment uniqueness purposes. |
|
||||||||||
| ACM-DISP-NBR Element: Disputed Items | Signed 3.0 The number of open items currently in dispute. |
|
||||||||||
| ACM-DISP-AMT Element: Disputed Amount | Signed 18.2 The total amount in dispute for this customer. |
|
||||||||||
| ACM-PL-EXCL-FL Process Level Restrictions | Alpha 1 Indicates if the invoices being entered on this customer's account should be checked for inclusions or exclusions for the specified process level. Valid values are: Blank = No process level restrictions I = Process level restriction |
|
||||||||||
| ACM-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 = Aged respective to GL date |
|
||||||||||
| ACM-DISPUTES-FIN Element: Finance Disputes | Alpha 1 Specifies if disputed invoices are exempt from being assessed finance charges. Valid values are: N = No; not subject to finance charges Y = Yes; subject to finance charges |
|
||||||||||
| ACM-AUTO-APP-FL Automatic Application | Alpha 1 Automatic cash application indicator. Valid values are: N = No; no automatic application Y = Yes; allows automatic application |
|
||||||||||
| ACM-AUTO-DUNN-FL Automatic Dunning Letters | Alpha 1 Indicates whether or not automatic selection for dunning letters will be allowed. Valid values are: N = No; no automatic selection Y = Yes; allow automatic selection |
|
||||||||||
| ACM-DISC-GRACE-PD Discount Grace Period | Numeric 2 Grace days added to discount date to allow or disallow discount during cash application. |
|
||||||||||
| ACM-CR-VAR-PCT Credit Variance Percent | Numeric 3 Contains an optional override percent that will be used in customer credit limit selections. If left blank, selection will be based on report parameter entered percentage. If the field contains a percent, this will override the report parameter. |
|
||||||||||
| ACM-MEMO-TERM Element: Memo Terms | Alpha 5 Memo terms code. Must be a valid terms code defined in the Lawson Terms system. |
|
||||||||||
| ACM-CHRGBK-PRT-FL Element: Print Chargebacks | Alpha 1 Specifies whether chargebacks will be printed. Valid values are: N = No; don't print chargeback debit memo Y = Yes; print chargeback debit memos |
|
||||||||||
| ACM-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 |
|
||||||||||
| ACM-STATEMENT-REQ Element: Statement Required | Alpha 1 Statement required option. If statements are required, the default selection criteria will include current, past due and credit open items. Zero balance statements will not be produced. Individual statement options may override this set of default criteria. Valid values are: N = No statements required Y = Statements required |
|
||||||||||
| ACM-STMNT-CYCLE Element: Statement Cycle | Alpha 2 Used to group customers with like statement cycles for statement processing. The statement cycle code will be assigned for balance forward type customers via the first letter of the company customer level search name. |
|
||||||||||
| ACM-LOCK-BOX Element: Lock Box | Alpha 2 The remit-to location of a lock box, used for payment receipts. If entered, it must be a valid lock box code. If left blank, the company name and address will be used for the remit-to address on Accounts Receivable external forms. For the Lawson Order Entry system, the process level name and address for the process level of the invoice will be used if left blank. |
|
||||||||||
| ACM-ZERO-STMNT-FL Element: Zero Statements | Alpha 1 Zero balance statement option. 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; don't produce zero statements Y = Yes; produce zero statements |
|
||||||||||
| ACM-CRED-STMNT-FL Element: Credit Statements | Alpha 1 Credit balance statement option. Determines whether or not a customer should receive a statement if their balance nets to a credit amount. Valid values are: N = No; don't produce credit statements Y = Yes; produce credit statements |
|
||||||||||
| ACM-PAST-STMNT-FL Element: Past Due Statements | Alpha 1 Past due open items only statement option. If this option is Yes, only past due open items will print on the customer's statement. Valid values are: N = Do not produce only past-due statements Y = Produce only past-due statements |
|
||||||||||
| ACM-OVER-STMNT-FL Over Credit Limit Statements | Alpha 1 Over credit limit statement option. If Yes is chosen, statements will only be printed for customers whose balances exceed their credit limit. Valid values are: N = Do not produce only balance exceeding credit limit statements Y = Produce only balance exceeding credit limit statements |
|
||||||||||
| ACM-MAX-AUTO-AMT Max Automatic Write Off Amount | Signed 18.2 Occurs 3 Times The maximum amount a payment may be short of a particular invoice during cash application and the system will automatically write-off the difference to the default reason code associated with this amount. There may be three levels for these allowances for each customer. If multiple shortage amounts are used, they must be in ascending order. |
|
||||||||||
| ACM-MAX-AUTO-PCT Max Auto Write Off Percent | Signed 5.5 Occurs 3 Times The maximum percentage allowed shortage amount during cash application that will be automatically adjusted. This is one of three fields that may be used for this purpose. If multiple allowed shortage percentages are used, they must be in ascending percent sequence. |
|
||||||||||
| ACM-AUTO-REAS-CD Auto Write Off Reason Code | Alpha 4 Occurs 3 Times This reason code is required if there is a short amount or percent allowed for automatic write-offs for the customer. This will allow tracking adjustment records by their reason codes. |
|
||||||||||
| ACM-DISC-REAS-CD Element: Discount Reason Code | Alpha 4 The default reason code for earned discounts for the customer. This must be a valid code in AR15 (Operational Codes (Reason)). |
|
||||||||||
| ACM-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. |
|
||||||||||
| ACM-DRAFT-FLAG Bill of Exchange Creation | Alpha 1 If the customer has a default payment code type of D (Bill of Exchange), this flag will indicate if the bills of exchange should be created in summary or individually (1 BOE for 1 Invoice). Valid values are: Blank = Not paying by BOE, Default I = Individual S = Summary |
|
||||||||||
| ACM-AR-CODE Accounts Receivable Code | Alpha 4 Default accounts receivable code for this customer used for record entry. |
|
||||||||||
| ACM-TERMS-CD Element: Terms Code | Alpha 5 The default terms code to be used during invoicing for this customer. |
|
||||||||||
| ACM-TERMS-CASH Element: Cash Paid Amount | Signed 18.2 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). |
|
||||||||||
| ACM-TERMS-CSH-DAYS Element: Cash Days | Signed 18.2 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. |
|
||||||||||
| ACM-DBT-RATIO Element: Days Beyond Terms | Signed 3.0 Occurs 11 Times Days Beyond Terms Indicator. Used in customer credit analysis. Calculation is identical to IPA calculation, however invoice due date is used instead of invoice date. Calculations: GL Date of last application minus Due Date of Invoice equals Days Outstanding. Days Outstanding multiplied by Dollars Paid equals DBT. |
|
||||||||||
| ACM-DBT-PR-YR Element: Previous Year DBT | Signed 3.0 This year's Days Beyond Terms indicator calculated at the end of the year by AR199 (Period Closing). |
|
||||||||||
| ACM-DBT-YTD-CASH DBT YTD Cash Paid Amount | Signed 18.2 The cash paid amount from fully paid transactions for the year. |
|
||||||||||
| ACM-DBT-YTD-DAYS Element: DBT YTD Cash Days | Signed 18.2 A running total of the year's Flow of Fund Cash Days calculated value (paid invoice amount multiplied by the number of days from Due Date to fully paid). |
|
||||||||||
| ACM-LATE-PAY-FL Element: Finance Charge Type | Alpha 1 Finance Charge Type. Indicates what type of charges will be assessed. Valid values are: Blank = No charges F = Finance charges assessed L = Late payment charges assessed B = Both finance and late payment charges assessed. |
|
||||||||||
| ACM-FIN-CALC-TYPE Finance Charge Calculation | Alpha 1 Indicates what type of calculation will be used in calculating finance charges. Valid values are: D = Detail calculation method N = Net calculation method |
|
||||||||||
| ACM-FIN-CHRG-CD Element: Finance Charge Code | Alpha 2 Finance charge code. This code must be predefined on AR07 (Finance Charge) and will contain a monthly finance charge percentage rate. |
|
||||||||||
| ACM-FIN-GRAC-DAYS Finance Charge Grace Days | Numeric 2 The number of grace days added to due date before finance charges will be assessed. |
|
||||||||||
| ACM-FIN-MIN-CHRG Minimum Finance Charge | Signed 7.2 The minimum finance charge amount assessed if calculated finance charge is less than minimum. If minimum is zero, there will be no override. |
|
||||||||||
| ACM-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; do not print finance charge documents Y = Yes; print finance charge document |
|
||||||||||
| ACM-LAST-DUNN Element: Last Dunning Number | Numeric 2 The last dunning letter number produced for the customer. |
|
||||||||||
| ACM-LAST-DUN-DATE Element: Last Dunning Date | Numeric 8 (yyyymmdd) The date of the last dunning letter produced for the customer. |
|
||||||||||
| ACM-LAST-DUN-AMT Element: Intl Amt | Signed 18.2 The amount of the last duning letter. |
|
||||||||||
| ACM-TAX-EXEMPT-CD Element: Tax Exempt Code | Alpha 1 Determines whether a customer is tax exempt or not. Used by the Lawson Order Entry system. Valid values are: T = Taxable E = Exempt |
|
||||||||||
| ACM-TAX-CODE Element: Tax Code | Alpha 10 User-defined code which identifies the default taxing authority this customer pays taxes to. Used by Lawson Order Entry system. Must be valid in the Lawson Tax system. |
|
||||||||||
| ACM-TERRITORY Element: Sales Territory | Alpha 4 Sales territory. Used by Lawson Accounts Receivable, Order Entry and Sales Analysis systems. |
|
||||||||||
| ACM-AGING-CODE Element: Aging Code | Numeric 2 Aging code. Indicates if there is a customer level aging override present. If this field is greater than zero, the customer's aging code will override the company default aging periods and aging rules in selected programs. |
|
||||||||||
| ACM-REVALUE-FL Element: Revalue Flag | Alpha 1 Indicates whether to revalue transaction currencies against the company base currency to account for exchange rate fluctuations. Valid values are: N = No Y = Yes |
|
||||||||||
| ACM-CURR-DRAFT-BAL Bill of Exchange Balance | Derived A derived field containing the total amount of a customer's balance and bill of exchange balance. |
|
||||||||||
| ACM-DISHONORED Element: Dishonored BOEs | Signed 5.0 The total number of customer bills of exchange that have been dishonored. |
|
||||||||||
| ACM-DISHONORED-AMT Dishonored BOE Amount | Signed 18.2 The total amount of the customer's dishonored bills of exchange. |
|
||||||||||
| ACM-RECONCILE-CASH Element: Reconciled BOEs | Signed 5.0 The number of dishonored bills of exchange that have been reconciled by means of a cash payment. |
|
||||||||||
| ACM-RECONCILE-RNEG Element: Rengotiated BOEs | Signed 5.0 The total number of dishonored bills of exchange that have been reconciled by means of renegotiation. |
|
||||||||||
| ACM-RECONCILE-WO Element: Written Off BOEs | Signed 5.0 The total number of dishonored bills of exchange that have been reconciled by means of a write-off to a bad debt account. |
|
||||||||||
| ACM-MINIMUM Minimum Finance Charge | Alpha 1 Used to determine if minimum finance 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. |
|
||||||||||
| ACM-FIN-CYCLE Finance Charge Cycle Code | Alpha 2 Finance charge cycle code. Lets you control customer selection when you generate finance charges. |
|
||||||||||
| ACM-DUN-CYCLE Element: Dunning Cycle Code | Alpha 2 Dunning cycle code. Lets you control customer selection when you generate dunning notices. |
|
||||||||||
| ACM-AUTO-METHOD Auto Cash Application Method | Alpha 1 Indicates the automatic cash application method for this customer. Valid values are: A = Algorithm B = Balance forward L = Last statement R = Remittance " " = None |
|
||||||||||
| ACM-AUTO-REMOVE Element: Auto Remove | Alpha 1 This field determines whether payments and transactions can be removed automatically. N = No Y = Yes |
|
||||||||||
| ACM-I-FIN-MIN-CHRG Element: I Fin Min Chrg | Signed 7.2 Minimum finance charge amount for an invoice. |
|
||||||||||
| ACM-CB-DTL-DATE Element: Cb Dtl Date | Alpha 1 This field will be used to determine which dates are used to calculate transaction and due dates for detail chargebacks. I = Invoice P = Payment |
|
||||||||||
| ACM-VAT-CUST-TYPE Element: Vat Cust Type | Alpha 2 Indicates the type of customer for VAT reporting. This field is required for all customers if the AR company indicates that VAT Reporting is required. DM = Domestic ER = EEC-Registered EU = EEC-Unregistered XP = Export |
|
||||||||||
| ACM-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. |
|
||||||||||
| ACM-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. |
|
||||||||||
| ACM-VAT-NBR Element: Vat Nbr | Derived The concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID. |
|
||||||||||
| ACM-DUN-LTR-IND Element: Dun Ltr Ind | Alpha 1 Dunning letters in use for customer. Yes or No. This refers to the advanced dunning letter process. Y = Yes N = No |
|
||||||||||
| ACM-DUN-PROCESS-CD Element: Dun Process Cd | Alpha 6 Dunning letter process code. A unique code that represents a combination of Dunning Letter options. |
|
||||||||||
| ACM-LANGUAGE-CODE Element: Language Code | Alpha 10 The language code (locale) representing the customer's preferred language. If no language code is specified, the environment base language is assumed which is always U.S. English. |
|
||||||||||
| ACM-LST-DUNLTR-STM Element: Lst Dunltr Stm | Numeric 2 Dunning level of the last dunning letter sent. Refers to a level of processing within the dunning process code. |
|
||||||||||
| ACM-LAST-LTR-DATE Element: Last Ltr Date | Numeric 8 (yyyymmdd) Date last dunning letter was sent for the invoice. |
|
||||||||||
| ACM-LST-LTRTEXT-CD Element: Lst Ltrtext Cd | Alpha 6 Text Code for last Dunning Letter sent on this invoice. |
|
||||||||||
| ACM-ASSESS-DUN-FEE Element: Assess Dun Fee | Alpha 1 Dunning letter fee charged. Yes or No. Y = Yes N = No |
|
||||||||||
| ACM-CU-NAME Element: Cu Name | Alpha 30 Optional credit agency name. Used if you are required to send a dunning letter to a customer's credit agency. |
|
||||||||||
| ACM-CU-ADDR1 Element: Cu Addr1 | Alpha 30 (Lower Case) Credit Union Address Line 1. |
|
||||||||||
| ACM-CU-ADDR2 Element: Cu Addr2 | Alpha 30 (Lower Case) Credit Union Address Line 2. |
|
||||||||||
| ACM-CU-ADDR3 Element: Cu Addr3 | Alpha 30 (Lower Case) Credit union address line 3. |
|
||||||||||
| ACM-CU-ADDR4 Element: Cu Addr4 | Alpha 30 (Lower Case) Credit union address line 4. |
|
||||||||||
| ACM-CU-CITY Element: Cu City | Alpha 18 (Lower Case) Credit Union City. |
|
||||||||||
| ACM-CU-STATE Element: Cu State | Alpha 2 Credit Union State. |
|
||||||||||
| ACM-CU-POSTAL-CODE Element: Cu Postal Code | Alpha 12 Credit Union Postal Code. |
|
||||||||||
| ACM-CU-COUNTRY-CD Element: Cu Country Cd | Alpha 2 Credit Union Country Code. |
|
||||||||||
| ACM-CU-COUNTRY Element: Cu Country | Alpha 30 (Lower Case) Credit Union Country. |
|
||||||||||
| ACM-THIRD-PARTY Element: Third Party | Alpha 1 Indicates if this customer's payments can be applied to open item transactions regardless of the customer involved. N = No third party payment Y = Third party payment allowed |
|
||||||||||
| ACM-E-MAIL-ADDRESS Element: Email Address | Alpha 60 (Lower Case) The Email address for this customer. |
|
||||||||||
| ACM-URL-ADDR Element: Url Addr | Alpha 60 (Lower Case) The URL address for this customer. |
|
||||||||||
| ACM-CUST-AUDIT Element: Cust Audit | Alpha 1 Indicates whether customer changes will be tracked. Valid values are: N = No customer audit Y = Customer audit |
|
||||||||||
| ACM-APPLY-MIXED Element: Apply Mixed | Alpha 1 Indicates if transactions with mixed signed line items will have credit lines applied to debit lines upon transaction interface and transaction release. Valid values are: N = No Y = Yes |
|
||||||||||
| ACM-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier that is used to relate to customer attributes. Customer attributes are used to help formulate customer lists used for reporting purposes. |
|
||||||||||
| ACM-PAY-AUTO-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||
| ACM-PAY-AUTO-PCT Element: Max Auto Pct | Signed 5.5 |
|
||||||||||
| ACM-PAY-REAS-CD Element: Auto Reas Cd | Alpha 4 |
|
||||||||||
| ACM-MULT-DUN-LTR Element: Flag | Alpha 1 " " N = No Y = Yes |
|
||||||||||
| ACM-CU-COUNTY Element: County | Alpha 25 (Lower Case) |
|
||||||||||
| ACM-AFFILIATE-FL Element: Flag | Alpha 1 |
|
||||||||||
| ACM-FOR-ECON-CODE Element: Code | Alpha 10 |
|
||||||||||
| ACM-SOCIAL-ID1 Element: Social Id1 | Alpha 80 (Lower Case) |
|
||||||||||
| ACM-SOCIAL-ID2 Element: Social Id2 | Alpha 80 (Lower Case) |
|
||||||||||
| ACM-SOCIAL-ID3 Element: Social Id3 | Alpha 80 (Lower Case) |
|
||||||||||
| ACM-SOCIAL-ID4 Element: Social Id4 | Alpha 80 (Lower Case) |
|
||||||||||
| ACM-SOCIAL-ID5 Element: Social Id5 | Alpha 80 (Lower Case) |
|
||||||||||
| ACM-CARRIER-FLAG Element: All Flag | Alpha 1 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACMSET1 |
COMPANY CUSTOMER |
|
|||||||||||||||||||||||||
| ACMSET2 |
COMPANY SEARCH-NAME CUSTOMER |
|
| ||||||||||||||||||||||||
| ACMSET3 |
CUSTOMER COMPANY |
|
| ||||||||||||||||||||||||
| ACMSET4 |
OBJ-ID |
|
| ||||||||||||||||||||||||
| ACMSET7 |
COMPANY STMNT-CYCLE CUSTOMER |
|
| ||||||||||||||||||||||||
| ACMSET8 |
COMPANY CREDIT-ANLYST CUSTOMER |
|
| ||||||||||||||||||||||||
| ACMSET9 |
COMPANY EDI-NBR |
|
|||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP |
Required
| ||||||||||||||||||
| Arcustbod | ARCUSTBOD |
Not Required, Delete Cascades
| ||||||||||||||||||
| Arcustflds | ARCUSTFLDS |
Not Required, Delete Cascades
| ||||||||||||||||||
| Arreason | ARREASON |
Required
| ||||||||||||||||||
| Cbbankinst | CBBANKINST |
Required
| ||||||||||||||||||
| Cranalyst | CRANALYST |
Required
| ||||||||||||||||||
| Custdeflts | CUSTDEFLTS |
Required
| ||||||||||||||||||
| Customerdesc | CUSTDESC |
Required
| ||||||||||||||||||
| Holdcodes | HOLDCODES |
Required
| ||||||||||||||||||
| Natacct Inv | NATACCT |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomment3 | ARCOMMENT |
| ||||||||||||||||||
| Arcomments | ARCOMMENT |
| ||||||||||||||||||
| Arcontacts | ARCONTACTS |
Delete Cascades
| ||||||||||||||||||
| Arcustpayment | ARPAYMENT |
Delete Restricted
| ||||||||||||||||||
| Arcustper | ARCUSTPER |
Delete Cascades
| ||||||||||||||||||
| Ardispute | ARDISPUTE |
Delete Restricted
| ||||||||||||||||||
| Ardrafts | ARDRAFTS |
Delete Restricted
| ||||||||||||||||||
| Armicrcust | ARMICRCUST |
| ||||||||||||||||||
| Aroihdr | AROIHDR |
Delete Restricted
| ||||||||||||||||||
| Aroitems | AROITEMS |
Delete Restricted
| ||||||||||||||||||
| Aroitemsopen | AROITEMS |
Delete Restricted
| ||||||||||||||||||
| Arpayment | ARPAYMENT |
Delete Restricted
| ||||||||||||||||||
| Billto | BILLTO |
| ||||||||||||||||||
| Customertotals | ARCUSTTOTS |
Delete Cascades
| ||||||||||||||||||
| Dtcustbank | DTCUSTBANK |
| ||||||||||||||||||
| Ftcustgrp | FTCUSTGRP |
| ||||||||||||||||||
| Natacct | NATACCT |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.