ARCUSTOMER – AR Company Customer

System
Accounts Receivable (AR)
Prefix
ACM
Primary key
COMPANY, CUSTOMER
Fields
152
Updated by
16 programs
Referenced by
303 programs

ARCUSTOMER is the AR Company Customer table in Lawson Accounts Receivable (prefix ACM). It is indexed by COMPANY, CUSTOMER (ACMSET1); alternate indexes: ACMSET2, ACMSET3, ACMSET4, ACMSET7, ACMSET8 and ACMSET9. It is related 1:1 to ARCOMP, ARCUSTBOD, ARCUSTFLDS, ARREASON, CBBANKINST, CRANALYST, CUSTDEFLTS, CUSTDESC and 2 more and 1:M to ARCOMMENT, ARCONTACTS, ARPAYMENT, ARCUSTPER, ARDISPUTE, ARDRAFTS, ARMICRCUST, AROIHDR and 6 more. It is updated by AR09.1, AR10.1, AR10.2, AR12.1, AR12.2, AR13.1, AR13.2, AR17.1 and 8 more and referenced by AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 and 295 more. The table has 152 fields, 7 indexes and 27 documented relations.

About ARCUSTOMER

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.

Fields (152)

Column = COBOL field name without the ACM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ACM-COMPANY PK
COMPANY		Numeric 4The accounts receivable company assigned to the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)The unique identifier assigned to the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates the status of the customer. Valid values are:
  • A Active
  • I Inactive
  • D Set for deletion
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-NAT-FLAG
NAT_FLAG		Alpha 1Indicates 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
AR09.1, AR10.1, AR12.1, AR12.2, AR301, AR501, AR550, TX140
ACM-SEARCH-NAME
SEARCH_NAME		Alpha 30The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-HOLD-CODE
HOLD_CODE		Alpha 4Indicates whether a customer is on hold.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CONTACT
CONTACT		Alpha 20Primary contact name for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-INT-PREFIX
INT_PREFIX		Alpha 6The international telephone number prefix.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PHONE-NMBR
PHONE_NMBR		Alpha 15The telephone number for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PHONE-EXT
PHONE_EXT		Alpha 5The telephone extension number for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TELEX-NBR
TELEX_NBR		Alpha 15The telex number for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-EDI-NBR
EDI_NBR		Alpha 15The electronic data interchange (EDI) number assigned to the customer. Used by the Lawson Order Entry system or external order processing systems.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-ALT-EDI-NBR
ALT_EDI_NBR		Alpha 95This is a free-form field to accommodate an alternate EDI number or address.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-ALT-EDI-TYPE
ALT_EDI_TYPE		Alpha 5Indicates the type of the alternate EDI number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FAX-NMBR
FAX_NMBR		Alpha 15The customer's fax number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FAX-EXT
FAX_EXT		Alpha 5The customer's fax extension.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-START-DATE
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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CREDIT-ANLYST
CREDIT_ANLYST		Alpha 4The credit analyst code assigned to this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CURRENCY-CD
CURRENCY_CD		Alpha 5The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-SALESMAN
SALESMAN		Numeric 4The primary sales representative for this customer. This salesrep is used on various programs for selection and sorting.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-RISK-CD
RISK_CD		Alpha 1The risk code is used for risk analysis. Defaults from the company.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DEFAULT-CODE
DEFAULT_CODE		Alpha 5The 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).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MAJ-CLASS
MAJ_CLASS		Alpha 4The major class assigned to this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MIN-CLASS
MIN_CLASS		Alpha 4The minor class assigned to this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CURR-BAL
CURR_BAL		Signed 18.2The current balance for the customer.AR12.1, AR12.2, AR13.1, AR13.2, ARLL.1, CB06.2, CB191
ACM-DRAFT-BAL
DRAFT_BAL		Signed 18.2The bill of exchange balance for this customer.AR12.1, AR12.2, AR13.1, AR13.2, ARLL.1, CB06.2
ACM-OPEN-ORDS
OPEN_ORDS		Signed 18.2The total amount of orders that have been entered into an external order processing system but have not yet been invoiced.AR09.1, AR10.1, AR301, AR501, AR550, ARLL.1, TX140, WH20.7
ACM-ORDER-LIM
ORDER_LIM		Signed 15.0The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CREDIT-LIM
CREDIT_LIM		Signed 15.0Total 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CREDIT-LIM-DAT
CREDIT_LIM_DAT		Numeric 8 (yyyymmdd)The date the credit limit was defined or last reviewed.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CREDIT-REVDAYS
CREDIT_REVDAYS		Signed 3.0The number of days between the credit limit reviews for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-PMT-AMT
LAST_PMT_AMT		Signed 18.2The amount of the last payment made by this customer.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, CB191 +1 more
ACM-LAST-PMT-DATE
LAST_PMT_DATE		Numeric 8 (yyyymmdd)The date of the last payment made by the customer.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, CB191 +1 more
ACM-LAST-INV-DATE
LAST_INV_DATE		Numeric 8 (yyyymmdd)The date of the last (most recent date) invoice for this customer.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, ARLL.1 +2 more
ACM-LAST-INV-AMT
LAST_INV_AMT		Signed 18.2The amount of the last (most recent date) invoice for this customer.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, ARLL.1 +2 more
ACM-LAST-STA-DATE
LAST_STA_DATE		Numeric 8 (yyyymmdd)The date of the last statement for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-STA-BAL
LAST_STA_BAL		Signed 18.2The customer's balance on their last statement.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-REVIEW-DATE
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.AR09.1, AR10.1, AR17.1, AR301, AR501, AR550, TX140
ACM-REVIEW-CODE
REVIEW_CODE		Alpha 1Indicates the status of the customer's review record. Valid values are:
  • O Open
  • R Reviewed
AR09.1, AR10.1, AR17.1, AR301, AR501, AR550, TX140
ACM-HIGH-BAL
HIGH_BAL		Signed 15.0 Occurs 13 Times ×13The highest balance for the customer for the period.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, ARLL.1 +2 more
ACM-PER-RTMS
PER_RTMS		Signed 3.0 Occurs 13 Times ×13Period Return-to-Maker debit memos. The number of payments that have been returned to the customer for the period.AR09.1, AR10.1, AR13.1, AR13.2, AR301, AR501, AR550, ARLL.1 +2 more
ACM-PAID-PRMPT
PAID_PRMPT		Signed 5.0 Occurs 12 Times ×12The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-INV-PAID
INV_PAID		Signed 5.0 Occurs 12 Times ×12A 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-COLLECT-DAYS
COLLECT_DAYS		Signed 3.0 Occurs 11 Times ×11A 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CURR-CASH
CURR_CASH		Signed 18.2The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CURR-CSH-DAYS
CURR_CSH_DAYS		Signed 18.2The Flow of Funds Cash Days calculated value (paid amount multiplied by the number of days to fully pay) for the current period.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-YTD-CASH
YTD_CASH		Signed 18.2The year-to-date total of cash for fully paid transactions.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-YTD-CSH-DAYS
YTD_CSH_DAYS		Signed 18.2The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-YEAR-2-DAYS
YEAR_2_DAYS		Signed 3.0The weighted invoice payment average for the year previous to the totals being tallied in "COLLECT DAYS" period buckets.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-STATIC-CUR
STATIC_CUR		Signed 18.2The static current portion of a customer's balance as of the last running of AR194 (Audit Summary).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AGING
AGING		Signed 18.2 Occurs 5 Times ×5These aging buckets carry the static past-due amounts in each aging period for a given customer. These fields are updated by AR194 (Audit Summary).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-COMMENT
LAST_COMMENT		Numeric 6The last sequence number for comment uniqueness purposes.AR13.1, AR13.2, AR17.1, ARLL.1, CB06.2
ACM-DISP-NBR
DISP_NBR		Signed 3.0The number of open items currently in dispute.—
ACM-DISP-AMT
DISP_AMT		Signed 18.2The total amount in dispute for this customer.—
ACM-PL-EXCL-FL
PL_EXCL_FL		Alpha 1Indicates 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
AR09.1, AR10.1, AR10.2, AR301, AR501, AR550, TX140
ACM-AGE-DISPUTES
AGE_DISPUTES		Alpha 1Specifies how disputed invoices will be aged. Valid values are:
  • N Not aged - aged in current column
  • Y Aged respective to GL date
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DISPUTES-FIN
DISPUTES_FIN		Alpha 1Specifies 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AUTO-APP-FL
AUTO_APP_FL		Alpha 1Automatic cash application indicator. Valid values are:
  • N No; no automatic application
  • Y Yes; allows automatic application
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AUTO-DUNN-FL
AUTO_DUNN_FL		Alpha 1Indicates whether or not automatic selection for dunning letters will be allowed. Valid values are:
  • N No; no automatic selection
  • Y Yes; allow automatic selection
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DISC-GRACE-PD
DISC_GRACE_PD		Numeric 2Grace days added to discount date to allow or disallow discount during cash application.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CR-VAR-PCT
CR_VAR_PCT		Numeric 3Contains 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MEMO-TERM
MEMO_TERM		Alpha 5Memo terms code. Must be a valid terms code defined in the Lawson Terms system.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CHRGBK-PRT-FL
CHRGBK_PRT_FL		Alpha 1Specifies whether chargebacks will be printed. Valid values are: memo
  • N No; don't print chargeback debit
  • Y Yes; print chargeback debit memos
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-OPEN-BAL-FWD
OPEN_BAL_FWD		Alpha 1Processing of receivable records by either open item or balance forward methods. Valid values are:
  • B Balance forward processing
  • O Open Item processing
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-STATEMENT-REQ
STATEMENT_REQ		Alpha 1Statement 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-STMNT-CYCLE
STMNT_CYCLE		Alpha 2Used 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LOCK-BOX
LOCK_BOX		Alpha 2The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-ZERO-STMNT-FL
ZERO_STMNT_FL		Alpha 1Zero 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CRED-STMNT-FL
CRED_STMNT_FL		Alpha 1Credit 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PAST-STMNT-FL
PAST_STMNT_FL		Alpha 1Past 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: statements
  • N Do not produce only past-due
  • Y Produce only past-due statements
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-OVER-STMNT-FL
OVER_STMNT_FL		Alpha 1Over credit limit statement option. If Yes is chosen, statements will only be printed for customers whose balances exceed their credit limit. Valid values are: exceeding credit limit statements credit limit statements
  • N Do not produce only balance
  • Y Produce only balance exceeding
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MAX-AUTO-AMT
MAX_AUTO_AMT		Signed 18.2 Occurs 3 Times ×3The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MAX-AUTO-PCT
MAX_AUTO_PCT		Signed 5.5 Occurs 3 Times ×3The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AUTO-REAS-CD
AUTO_REAS_CD		Alpha 4 Occurs 3 Times ×3This 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DISC-REAS-CD
DISC_REAS_CD		Alpha 4The default reason code for earned discounts for the customer. This must be a valid code in AR15 (Operational Codes (Reason)).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DRAFT-FLAG
DRAFT_FLAG		Alpha 1If 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AR-CODE
AR_CODE		Alpha 4Default accounts receivable code for this customer used for record entry.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TERMS-CD
TERMS_CD		Alpha 5The default terms code to be used during invoicing for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TERMS-CASH
TERMS_CASH		Signed 18.2The cash paid amount from fully paid transactions. At the end of a current period, it will be used to calculate DBT (Days Beyond Terms).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TERMS-CSH-DAYS
TERMS_CSH_DAYS		Signed 18.2The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DBT-RATIO
DBT_RATIO		Signed 3.0 Occurs 11 Times ×11Days 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DBT-PR-YR
DBT_PR_YR		Signed 3.0This year's Days Beyond Terms indicator calculated at the end of the year by AR199 (Period Closing).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DBT-YTD-CASH
DBT_YTD_CASH		Signed 18.2The cash paid amount from fully paid transactions for the year.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DBT-YTD-DAYS
DBT_YTD_DAYS		Signed 18.2A 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).AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LATE-PAY-FL
LATE_PAY_FL		Alpha 1Finance Charge Type. Indicates what type of charges will be assessed. Valid values are: charges assessed.
  • Blank No charges
  • F Finance charges assessed
  • L Late payment charges assessed
  • B Both finance and late payment
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-CALC-TYPE
FIN_CALC_TYPE		Alpha 1Indicates what type of calculation will be used in calculating finance charges. Valid values are:
  • D Detail calculation method
  • N Net calculation method
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-CHRG-CD
FIN_CHRG_CD		Alpha 2Finance charge code. This code must be predefined on AR07 (Finance Charge) and will contain a monthly finance charge percentage rate.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-GRAC-DAYS
FIN_GRAC_DAYS		Numeric 2The number of grace days added to due date before finance charges will be assessed.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-MIN-CHRG
FIN_MIN_CHRG		Signed 7.2The minimum finance charge amount assessed if calculated finance charge is less than minimum. If minimum is zero, there will be no override.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-DOC-PRNT
FIN_DOC_PRNT		Alpha 1Specifies whether or not finance charge documents are required to be printed. Valid values are: documents
  • N No; do not print finance charge
  • Y Yes; print finance charge document
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-DUNN
LAST_DUNN		Numeric 2The last dunning letter number produced for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-DUN-DATE
LAST_DUN_DATE		Numeric 8 (yyyymmdd)The date of the last dunning letter produced for the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-DUN-AMT
LAST_DUN_AMT		Signed 18.2The amount of the last duning letter.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Determines whether a customer is tax exempt or not. Used by the Lawson Order Entry system. Valid values are:
  • T Taxable
  • E Exempt
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TAX-CODE
TAX_CODE		Alpha 10User-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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-TERRITORY
TERRITORY		Alpha 4Sales territory. Used by Lawson Accounts Receivable, Order Entry and Sales Analysis systems.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AGING-CODE
AGING_CODE		Numeric 2Aging 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-REVALUE-FL
REVALUE_FL		Alpha 1Indicates whether to revalue transaction currencies against the company base currency to account for exchange rate fluctuations. Valid values are:
  • N No
  • Y Yes
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CURR-DRAFT-BAL
CURR_DRAFT_BAL		DerivedA derived field containing the total amount of a customer's balance and bill of exchange balance.—
ACM-DISHONORED
DISHONORED		Signed 5.0The total number of customer bills of exchange that have been dishonored.—
ACM-DISHONORED-AMT
DISHONORED_AMT		Signed 18.2The total amount of the customer's dishonored bills of exchange.—
ACM-RECONCILE-CASH
RECONCILE_CASH		Signed 5.0The number of dishonored bills of exchange that have been reconciled by means of a cash payment.—
ACM-RECONCILE-RNEG
RECONCILE_RNEG		Signed 5.0The total number of dishonored bills of exchange that have been reconciled by means of renegotiation.—
ACM-RECONCILE-WO
RECONCILE_WO		Signed 5.0The 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		Alpha 1Used to determine if minimum finance charges are to be used. Valid values are: amount is less than minimum amount. less than minimum amount. If minimum amount is blank, then calculated amount is charged.
  • Y Use minimum amount if calculated
  • N No charge if calculated amount is
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-FIN-CYCLE
FIN_CYCLE		Alpha 2Finance charge cycle code. Lets you control customer selection when you generate finance charges.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DUN-CYCLE
DUN_CYCLE		Alpha 2Dunning cycle code. Lets you control customer selection when you generate dunning notices.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AUTO-METHOD
AUTO_METHOD		Alpha 1Indicates the automatic cash application method for this customer. Valid values are: " " = None
  • A Algorithm
  • B Balance forward
  • L Last statement
  • R Remittance
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AUTO-REMOVE
AUTO_REMOVE		Alpha 1This field determines whether payments and transactions can be removed automatically.
  • N No
  • Y Yes
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-I-FIN-MIN-CHRG
I_FIN_MIN_CHRG		Signed 7.2Minimum finance charge amount for an invoice.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CB-DTL-DATE
CB_DTL_DATE		Alpha 1This field will be used to determine which dates are used to calculate transaction and due dates for detail chargebacks.
  • I Invoice
  • P Payment
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-VAT-CUST-TYPE
VAT_CUST_TYPE		Alpha 2Indicates 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-VAT-REG-NBR
VAT_REG_NBR		Alpha 12The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-VAT-REG-CTRY
VAT_REG_CTRY		Alpha 2The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-VAT-NBR
VAT_NBR		DerivedThe concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID.—
ACM-DUN-LTR-IND
DUN_LTR_IND		Alpha 1Dunning letters in use for customer. Yes or No. This refers to the advanced dunning letter process.
  • Y Yes
  • N No
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-DUN-PROCESS-CD
DUN_PROCESS_CD		Alpha 6Dunning letter process code. A unique code that represents a combination of Dunning Letter options.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LANGUAGE-CODE
LANGUAGE_CODE		Alpha 10The 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LST-DUNLTR-STM
LST_DUNLTR_STM		Numeric 2Dunning level of the last dunning letter sent. Refers to a level of processing within the dunning process code.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-LAST-LTR-DATE
LAST_LTR_DATE		Numeric 8 (yyyymmdd)Date last dunning letter was sent for the invoice.—
ACM-LST-LTRTEXT-CD
LST_LTRTEXT_CD		Alpha 6Text Code for last Dunning Letter sent on this invoice.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-ASSESS-DUN-FEE
ASSESS_DUN_FEE		Alpha 1Dunning letter fee charged. Yes or No.
  • Y Yes
  • N No
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-NAME
CU_NAME		Alpha 30Optional credit agency name. Used if you are required to send a dunning letter to a customer's credit agency.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-ADDR1
CU_ADDR1		Alpha 30 (Lower Case)Credit Union Address Line 1.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-ADDR2
CU_ADDR2		Alpha 30 (Lower Case)Credit Union Address Line 2.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-ADDR3
CU_ADDR3		Alpha 30 (Lower Case)Credit union address line 3.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-ADDR4
CU_ADDR4		Alpha 30 (Lower Case)Credit union address line 4.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-CITY
CU_CITY		Alpha 18 (Lower Case)Credit Union City.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-STATE
CU_STATE		Alpha 2Credit Union State.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-POSTAL-CODE
CU_POSTAL_CODE		Alpha 12Credit Union Postal Code.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-COUNTRY-CD
CU_COUNTRY_CD		Alpha 2Credit Union Country Code.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-COUNTRY
CU_COUNTRY		Alpha 30 (Lower Case)Credit Union Country.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-THIRD-PARTY
THIRD_PARTY		Alpha 1Indicates 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)The Email address for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-URL-ADDR
URL_ADDR		Alpha 60 (Lower Case)The URL address for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CUST-AUDIT
CUST_AUDIT		Alpha 1Indicates whether customer changes will be tracked. Valid values are:
  • N No customer audit
  • Y Customer audit
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-APPLY-MIXED
APPLY_MIXED		Alpha 1Indicates 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
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-OBJ-ID
OBJ_ID		Numeric 12This 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.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PAY-AUTO-AMT
PAY_AUTO_AMT		Signed 18.2—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PAY-AUTO-PCT
PAY_AUTO_PCT		Signed 5.5—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-PAY-REAS-CD
PAY_REAS_CD		Alpha 4—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-MULT-DUN-LTR
MULT_DUN_LTR		Alpha 1" "
  • N No
  • Y Yes
AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CU-COUNTY
CU_COUNTY		Alpha 25 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-AFFILIATE-FL
AFFILIATE_FL		Alpha 1—AR10.1
ACM-FOR-ECON-CODE
FOR_ECON_CODE		Alpha 10—AR10.1
ACM-SOCIAL-ID1
SOCIAL_ID1		Alpha 80 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-SOCIAL-ID2
SOCIAL_ID2		Alpha 80 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-SOCIAL-ID3
SOCIAL_ID3		Alpha 80 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-SOCIAL-ID4
SOCIAL_ID4		Alpha 80 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-SOCIAL-ID5
SOCIAL_ID5		Alpha 80 (Lower Case)—AR09.1, AR10.1, AR301, AR501, AR550, TX140
ACM-CARRIER-FLAG
CARRIER_FLAG		Alpha 1—AR09.1, AR10.1, AR301, AR501, AR550, TX140

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACMSET1COMPANY, CUSTOMERPrimaryAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
ACMSET2COMPANY, SEARCH-NAME, CUSTOMERKeyChangeAR209, AR210
ACMSET3CUSTOMER, COMPANYAR09.1, AR12.1, AR12.2, AR301
ACMSET4OBJ-IDSubsetWhere OBJ-ID != ZeroesAR210, AR211, AR217, AR23.3, AR23.4, AR301, MX123, MX223 +4 more
ACMSET7COMPANY, STMNT-CYCLE, CUSTOMERKeyChangeAR04.1
ACMSET8COMPANY, CREDIT-ANLYST, CUSTOMERKeyChangeAR06.1, AR217
ACMSET9COMPANY, EDI-NBRKeyChange, SubsetWhere EDI-NBR != SpacesAC56.1, AC560, AR10.1, AR501, AR550, BR00.1, BR00.2, BR02.3 +22 more (list truncated in source)

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredACM-COMPANY → ACO-COMPANY
ArcustbodARCUSTBODNot Required, Delete CascadesACM-COMPANY → YBM-COMPANY, ACM-CUSTOMER → YBM-CUSTOMER
ArcustfldsARCUSTFLDSNot Required, Delete CascadesACM-COMPANY → ACF-COMPANY, ACM-CUSTOMER → ACF-CUSTOMER
ArreasonARREASONRequiredWhen ACM-AUTO-REAS-CD != SpacesACM-COMPANY → ARR-COMPANY, "AD" → ARR-TYPE, ACM-AUTO-REAS-CD → ARR-REASON-CODE
CbbankinstCBBANKINSTRequiredACM-BANK-INST-CODE → CBI-BANK-INST-CODE
CranalystCRANALYSTRequiredACM-COMPANY → CAN-COMPANY, ACM-CREDIT-ANLYST → CAN-CREDIT-ANLYST
CustdefltsCUSTDEFLTSRequiredACM-COMPANY → CDF-COMPANY, ACM-DEFAULT-CODE → CDF-DEFAULT-CODE
CustomerdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, ACM-CUSTOMER → CUD-CUSTOMER
HoldcodesHOLDCODESRequiredWhen ACM-HOLD-CODE != SpacesACO-CUST-GROUP → HDD-CUST-GROUP, ACM-HOLD-CODE → HDD-HOLD-CODE
Natacct InvNATACCTRequiredWhen ACM-NAT-FLAG = "I"ACM-COMPANY → NAC-COMPANY, ACM-CUSTOMER → NAC-CUSTOMER, Zeroes → NAC-NAT-COMPANY, Spaces → NAC-NAT-CUSTOMER

One to many (17) — child tables

RelationTableRulesConditionField map
Arcomment3ARCOMMENTACM-COMPANY → CMT-COMPANY, ACM-CUSTOMER → CMT-CUSTOMER, → CMT-SYS-DATE, → CMT-SYS-TIME, → CMT-SEQ-NUMBER
ArcommentsARCOMMENTACM-COMPANY → CMT-COMPANY, ACM-CUSTOMER → CMT-CUSTOMER, → CMT-SEQ-NUMBER
ArcontactsARCONTACTSDelete CascadesACM-COMPANY → CON-COMPANY, ACM-CUSTOMER → CON-CUSTOMER, → CON-RESP-CODE
ArcustpaymentARPAYMENTDelete RestrictedACM-COMPANY → APM-COMPANY, ACM-CUSTOMER → APM-CUSTOMER, → APM-TRANS-TYPE, → APM-TRANS-NBR, → APM-BATCH-NBR
ArcustperARCUSTPERDelete CascadesACM-COMPANY → ARP-COMPANY, ACM-CUSTOMER → ARP-CUSTOMER, → ARP-YEAR
ArdisputeARDISPUTEDelete RestrictedACM-COMPANY → ADP-COMPANY, ACM-CUSTOMER → ADP-CUSTOMER, → ADP-TRANS-TYPE, → ADP-INVOICE, → ADP-PAYMENT-SEQ, → ADP-SEQ
ArdraftsARDRAFTSDelete RestrictedACM-COMPANY → ARD-COMPANY, ACM-CUSTOMER → ARD-CUSTOMER, → ARD-AR-DRAFT-NBR, → ARD-SUFFIX, → ARD-CANCEL-SEQ, → ARD-DRAFT-SOURCE
ArmicrcustARMICRCUSTACM-COMPANY → AMX-COMPANY, ACM-CUSTOMER → AMX-CUSTOMER, → AMX-BANK-ENTITY, → AMX-BANK-ACCT-NBR
AroihdrAROIHDRDelete RestrictedACM-COMPANY → ARH-COMPANY, ACM-CUSTOMER → ARH-CUSTOMER, → ARH-TRANS-TYPE, → ARH-INVOICE
AroitemsAROITEMSDelete RestrictedACM-COMPANY → ARO-COMPANY, ACM-CUSTOMER → ARO-CUSTOMER, → ARO-TRANS-TYPE, → ARO-INVOICE, → ARO-PAYMENT-SEQ
AroitemsopenAROITEMSDelete RestrictedACM-COMPANY → ARO-COMPANY, ACM-CUSTOMER → ARO-CUSTOMER, → ARO-TRANS-TYPE, → ARO-INVOICE, → ARO-PAYMENT-SEQ
ArpaymentARPAYMENTDelete RestrictedACM-COMPANY → APM-COMPANY, ACM-CUSTOMER → APM-CUSTOMER, → APM-GL-DATE, → APM-BATCH-NBR, → APM-PAYMENT-SEQ
BilltoBILLTOCUD-CUST-GROUP → ABS-CUST-GROUP, ACM-CUSTOMER → ABS-CUSTOMER, → ABS-BILL-TO
CustomertotalsARCUSTTOTSDelete CascadesACM-COMPANY → CUT-COMPANY, ACM-CUSTOMER → CUT-CUSTOMER, → CUT-PROCESS-LEVEL
DtcustbankDTCUSTBANKCUD-CUST-GROUP → DTB-CUST-GROUP, ACM-COMPANY → DTB-COMPANY, ACM-CUSTOMER → DTB-CUSTOMER, → DTB-BANK-ENTITY, → DTB-BANK-ACCT-NBR
FtcustgrpFTCUSTGRPCUD-CUST-GROUP → FTG-CUST-GROUP, ACM-COMPANY → FTG-COMPANY, ACM-CUSTOMER → FTG-CR-CUSTOMER, → FTG-CUSTOMER
NatacctNATACCTRequiredWhen ACM-NAT-FLAG = "N"ACM-COMPANY → NAC-NAT-COMPANY, ACM-CUSTOMER → NAC-NAT-CUSTOMER, → NAC-COMPANY, → NAC-CUSTOMER

Programs

Updated by (16)

Referenced by (303)