ARCOMP – Accounts Receivable Company

System: Accounts Receivable (AR)
Prefix: ACO
Primary key: COMPANY
Fields: 124
Updated by: 3 programs
Referenced by: 376 programs

ARCOMP is the Accounts Receivable Company table in Lawson Accounts Receivable (prefix ACO). It is indexed by COMPANY (ACOSET1); alternate indexes: ACOSET2. It is related 1:1 to ARCUSTGRP and 1:M to AGINGCODE, ARCATEGORY, ARCHGBAKTX, ARCODE, ARCOMPAUD, ARCUSTOMER, AROITEMS, ARPAYNOTTX and 11 more. It is updated by AR01.1, ARLL.1 and CB06.2 and referenced by AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 and 368 more. The table has 124 fields, 2 indexes and 20 documented relations.

About ARCOMP

The AR Company file contains the accounts receivable company records. A company record contains the highest set of processing rules that are used for customers that have been identified with that company. Prior to adding a company to this file, the same company number must be a valid company in the Lawson General Ledger or General Ledger Interface system.

Fields (124)

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

Field / column	Type	Description & values	Updated by
`ACO-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR01.1
`ACO-CUST-GROUP` CUST_GROUP	Alpha 5	Customer group assigned to this company. Only customers initially defined with this customer group are eligible to be customers of this company.	AR01.1, TX130
`ACO-NAME` NAME	Alpha 30 (Lower Case)	The name or description of the Accounts Receivable company. The name defaults from General Ledger unless you override it in Accounts Receivable.	AR01.1
`ACO-ADDR1` ADDR1	Alpha 30 (Lower Case)	First line of address information. Defaults from the general ledger or interface company address and will be maintainable once it is initially added.	AR01.1
`ACO-ADDR2` ADDR2	Alpha 30 (Lower Case)	Second line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-ADDR3` ADDR3	Alpha 30 (Lower Case)	Third line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-ADDR4` ADDR4	Alpha 30 (Lower Case)	Fourth line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-CITY` CITY	Alpha 18 (Lower Case)	City Name. Defaults from the general ledger or interface company address and will be maintainable once it is initially added.	AR01.1
`ACO-STATE` STATE	Alpha 2	State or province abbreviation. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-ZIP` ZIP	Alpha 10	Postal code. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-COUNTRY` COUNTRY	Alpha 30 (Lower Case)	Country name. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-COUNTY` COUNTY	Alpha 25 (Lower Case)	County. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added.	AR01.1
`ACO-PHONE-NMBR` PHONE_NMBR	Alpha 15	The company phone number.	AR01.1
`ACO-FAX-NMBR` FAX_NMBR	Alpha 15	The company fax number.	AR01.1
`ACO-CHRG-BACK-NBR` CHRG_BACK_NBR	Numeric 7	This field will contain the last used transaction number for created chargebacks. The chargebacks will be in the form of debit memos in the open item file. This number will be prefixed by "CB-".	AR01.1
`ACO-INV-BTCH-FL` INV_BTCH_FL	Alpha 1	Specifies whether the manual invoice batches will be automatically assigned. Valid values are: `N` No automatic batch numbering `Y` Automatic batch numbering	AR01.1
`ACO-INV-BTCH-NBR` INV_BTCH_NBR	Numeric 6	The last batch number assigned for manual invoice entry.	AR01.1
`ACO-INV-BTCH-TL` INV_BTCH_TL	Alpha 1	This option allows system batch totals to be force balanced to header totals prior to release. Valid values are: `N` No total balancing required `Y` Total balancing required	AR01.1
`ACO-AUTO-BTCH-FL` AUTO_BTCH_FL	Alpha 1	This option will specify whether or not automatic batch numbering will be used in cash entry. Valid values are: `N` No automatic batch numbering `Y` Automatic batch numbering	AR01.1
`ACO-AUTO-BAT-NBR` AUTO_BAT_NBR	Numeric 6	The last number assigned for the payment batch header. When a new batch is assigned, 1 will be added to this number and used to create the new batch record. This number can be maintained but cannot be changed to a value less than the highest batch number used. Note: This number sequence will also be used for lock box interfaced cash.	AR01.1, ARLL.1, CB06.2
`ACO-BTCH-CNTRL-TL` BTCH_CNTRL_TL	Alpha 1	This cash option allows system batch totals to be force balanced to control totals. Valid values are: `N` No total balancing required `Y` Control balancing required	AR01.1
`ACO-SUMM-BTCH-NBR` SUMM_BTCH_NBR	Numeric 6	The last system-assigned batch number used when creating chargeback records.	AR01.1
`ACO-LAST-RTM-NBR` LAST_RTM_NBR	Numeric 7	Return-to-maker debit memo number. This is the numeric portion of the last RTM document to be generated by the system. RTM debit memos are identified by a preceding "RM-" followed by this ascending seven digit number.	AR01.1
`ACO-LAST-CONV-BTCH` LAST_CONV_BTCH	Numeric 3	The last payment batch number the system assigned to converted payments. The last 999 batch numbers (999000 - 999999) are reserved for this purpose. The system will not allow users to use batch numbers greater that 999000.	—
`ACO-RISK-CD` RISK_CD	Alpha 1	The default risk code that will be assigned to all new customers being added for this company.	AR01.1
`ACO-OFFSET-FL` OFFSET_FL	Alpha 1	Specifies if application will occur for cross referenced debits from a credit memo. Valid values are: `N` No automatic memo application `Y` Automatic memo application allowed	AR01.1
`ACO-AR-CODE` AR_CODE	Alpha 4	The default accounts receivable code for the company level.	AR01.1
`ACO-NOT-APPLD-CD` NOT_APPLD_CD	Alpha 4	The default received not applied code at the company level.	AR01.1
`ACO-PRE-PAY-CODE` PRE_PAY_CODE	Alpha 4	Prepayment code. This is the default code to be used for a check entered as a prepayment. This will be the offset instead of RNA to cash.	AR01.1
`ACO-CUST-RETEN` CUST_RETEN	Numeric 3	The number of months that must elapse, after the last customer activity date, before a customer can be automatically deleted.	AR01.1
`ACO-AGE-CREDITS` AGE_CREDITS	Alpha 1	Specifies how credit memos should be aged. Valid values are: column `L` Aged to last debit-containing `column N` Not aged - aged in current `R` Aged respective to credit memo date	AR01.1
`ACO-AGE-PYMNT` AGE_PYMNT	Alpha 1	Specifies how payments should be aged. Valid values are: `L` Aged to last debit-containing column `N` Not aged - aged in current column `R` Aged respective to payment date	AR01.1
`ACO-AGE-DISPUTES` AGE_DISPUTES	Alpha 1	Specifies how disputed transactions will be aged. Valid values are: `N` Not aged - aged in current column `Y` Aged respective to transaction date	AR01.1
`ACO-AGE-TYPE` AGE_TYPE	Alpha 1	Default aging method respecting either invoice date or due date. Valid values are: `D` Age by due date `T` Age by transaction date	AR01.1
`ACO-AGE-CURRENT` AGE_CURRENT	Numeric 3	This field will be used to define the transactions going into the "current" and "future" aging buckets. This provides the ability to have two aging columns (current and future) that reflect transactions that are not past invoice (for an invoice date based aging) or not past due (for a due date based aging).	AR01.1
`ACO-AGE-PERIODS` AGE_PERIODS	Numeric 3 Occurs 4 Times ×4	Aging periods established by entering the last day of each period in these fields. If left blank, these periods will default from this company's assigned customer group. Future and current aging periods will be defined with a separate field.	AR01.1
`ACO-DISPUTES-FIN` DISPUTES_FIN	Alpha 1	Specifies if disputed transactions are exempt from being assessed finance charges. Valid values are: items `N` No finance charges on disputed `Y` Yes, subject to finance charges	AR01.1
`ACO-OI-DISP-SEQ` OI_DISP_SEQ	Alpha 1	Indicates the default display sequence of the open items. Valid values are: `1` Trans Type Number `2` Due Date `3` Open Amount `4` Process Level `5` Trans User 1 `6` Activity `7` Customer PO	AR01.1
`ACO-AUDIT-APP-FL` AUDIT_APP_FL	Alpha 1	Indicates if the operator code field is required during the entry of cash and during the application of cash. Valid values are: `N` No - operator code not required `Y` Yes - operator code required	AR01.1
`ACO-AUDIT-MEMO-FL` AUDIT_MEMO_FL	Alpha 1	Indicates if operator code is required during the entry of debit/credit memos or the entry of invoices. Valid values are: `N` No - operator code not required `Y` Yes - operator code required	AR01.1
`ACO-APP-REVIEW-FL` APP_REVIEW_FL	Alpha 1	Indicates if applications are required to go through an audit listing prior to applications being posted to the general ledger. Valid values are: `N` No `Y` Yes	AR01.1
`ACO-DISC-GRACE-PD` DISC_GRACE_PD	Numeric 2	Number of grace days added to discount date to allow automatic discount during cash application.	AR01.1
`ACO-LATE-PAY-FL` LATE_PAY_FL	Alpha 1	Indicates what type of charges will be assessed. This option can be overridden at the default codes and customer levels. Valid values are: charges will be assessed `Blank` No charges `F` Finance charges assessed `L` Late payments charges assessed `B` Both finance and late payment	AR01.1
`ACO-FIN-CALC-TYPE` FIN_CALC_TYPE	Alpha 1	Determines how finance charges will be calculated. Depending upon this calculation type, finance charges will either be assessed individually for each overdue open item (Detail option) or one summary charge for the net amount of overdue open items (Net option). Valid values are: `D` Detail calculation `N` Net calculation	AR01.1
`ACO-FIN-AUTO-NBR` FIN_AUTO_NBR	Numeric 7	This field will hold the last finance charge number used by the system. It will contain an ascending seven digit number. The finance charge debit memo number will be prefixed with "FC-".	AR01.1
`ACO-FIN-CHRG-CD` FIN_CHRG_CD	Alpha 2	Finance charge code. This code must be predefined and will contain a monthly finance charge percentage rates.	AR01.1
`ACO-FIN-GRAC-DAYS` FIN_GRAC_DAYS	Numeric 2	The number of grace days added to a transaction's due date before finance charges will be assessed.	AR01.1
`ACO-FIN-MIN-CHRG` FIN_MIN_CHRG	Signed 7.2	Override minimum finance charge amount assessed if calculated finance charge is less than this minimum amount. If a minimum is zero, no override will occur.	AR01.1
`ACO-FIN-DOC-PRNT` FIN_DOC_PRNT	Alpha 1	This option will specify whether or not finance charge documents are required to be printed. Valid values are: `N` No finance charge documents printed `Y` Yes, print finance charge documents	AR01.1
`ACO-FIN-GL-CODE` FIN_GL_CODE	Alpha 4	This is the default GL code to be used for finance charges at the company level. It is tied to the finance charge general ledger account.	AR01.1
`ACO-CURRENCY-CD` CURRENCY_CD	Alpha 5	The base currency defined for the company in the Lawson General Ledger system. Used by the accounts receivable company for processing and reporting. Transactions entered in a non-base currency retain their original, transaction amounts and are converted to the company base currency.	AR01.1
`ACO-MULTI-CURR-FL` MULTI_CURR_FL	Alpha 1	Determines if transactions in currencies differing from company base currency will be allowed. `N` Not Multi Currency `Y` Multi Currency	AR01.1
`ACO-RATE-OVR-FL` RATE_OVR_FL	Alpha 1	Determines whether or not user will be able to override conversion rate tolerances when adding non company-based currency transactions. Valid values are: `N` No `Y` Yes	AR01.1
`ACO-INV-CUR-OVR` INV_CUR_OVR	Alpha 1	Indicates whether users will be able to override the default customer invoice currency code when entering manual invoices. `N` No `Y` Yes	AR01.1
`ACO-VERIFY-GLDATE` VERIFY_GLDATE	Alpha 1	Establishes whether the system should edit transaction's GL date against the GL date range set up in IF01 (System Control). Valid values are: `N` No - do not general date editing `Y` Yes - edit general ledger date	AR01.1
`ACO-DFLT-APP-DATE` DFLT_APP_DATE	Alpha 1	Defines what default general ledger date the application records should have. Valid values are: `P` Payment general ledger date `S` System date	AR01.1
`ACO-HOLD-CODE` HOLD_CODE	Alpha 4	The Hold Code found on the company record is the default Hold Code to be used by AR70.2 (Analyst Review Detail). This code is available to be used by order processing systems to help make a decision on whether or not to process a particular customer's orders.	AR01.1
`ACO-OVER-APP-FL` OVER_APP_FL	Alpha 1	Determines whether users should be able to over apply a short payment to fully exhaust an invoice and create a chargeback for the remaining portion of the invoice. Valid values are: `N` No, over-application not allowed `Y` Yes, over-application allowed	AR01.1
`ACO-DISC-DSP-FL` DISC_DSP_FL	Alpha 1	Determines if past-due discount amounts will display during cash application. Valid values are: displayed `N` No past due discount amounts `Y` Display past due discounts	AR01.1
`ACO-UPD-DUE-DATE` UPD_DUE_DATE	Alpha 1	Determines if transactions will be allowed to have their transaction or due date changed. This affects AR42.6 (Obligations), AR45.1 (Disputes), and DT42.1 (Bill of Exchange Maintenance). Valid values are: `N` No, due date change not allowed `Y` Yes, due date change allowed	AR01.1
`ACO-INCOMPLETE-FL` INCOMPLETE_FL	Alpha 1	Indicates that the AR company is only partially set up.	AR01.1
`ACO-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AR01.1
`ACO-DISPLAY-DATE` DISPLAY_DATE	Alpha 1	Display date. This field will control the open obligation data displayed on the aging reports. It will work independently from the date used for aging. The transaction date will be the default with an option to display the due date. Payments and credits will always use GL date. Valid values are: `T` Transaction date `D` Due date (obligations only)	AR01.1
`ACO-TRANS-SEQUENCE` TRANS_SEQUENCE	Alpha 1	Transaction sequence. This field will control the display sequence of the transactions in aging reports. This is within the runtime indicated report sequence. The due date option will use due dates from open obligation and GL dates from payments and credits. Valid values are: `T` Transaction sequence `D` Due date sequence	AR01.1
`ACO-BANK-RISK-OPT` BANK_RISK_OPT	Alpha 1	Bank risk option. This field will be used if the company is using bill of exchange processing. If so, this option will indicate if bank risk processing should be done. Valid values are: `N` No; don't check bank risk `Y` Yes; check bank risk	AR01.1
`ACO-ACCEPT-ACCTING` ACCEPT_ACCTING	Alpha 1	Acceptance accounting. This option is only used if the company is doing bill of exchange processing. If so, the options are to post to bill of exchange receivable upon acceptance or to level the value in accounts receivable. Valid values are: `Y` Yes; GL required at acceptance `N` No; GL not required at acceptance	AR01.1
`ACO-DT-ACCPT-CODE` DT_ACCPT_CODE	Alpha 4	Bill of exchange acceptance code. This option is only used if the company is processing bills of exchange. If so, this code will be required if the accept accounting option is equal to yes. It represents the BOE receivable account. This will edit to the GL Codes file in AR.	AR01.1
`ACO-FIN-REV-CODE` FIN_REV_CODE	Alpha 4	Financial revenue code. This will be used if the company is processing bills of exchange. If so, this code will edit to the AR Codes file and will be used to post financial revenue.	AR01.1
`ACO-FIN-EXP-CODE` FIN_EXP_CODE	Alpha 4	Financial expense code. This code will be used if the company is processing bills of exchange. If so, the code will edit to the AR GL Code file and be used to post the financial expenses to GL.	AR01.1
`ACO-DIS-EXP-CODE` DIS_EXP_CODE	Alpha 4	Dishonored expense code. This code will be used if the company is processing bills of exchange. If so, the code will be used to post to GL any dishonored bill of exchange expenses.	AR01.1
`ACO-LAST-DRAFT-NBR` LAST_DRAFT_NBR	Numeric 10	Last bill of exchange number assigned. This will be used only if the company will be processing bills of exchange. If so, it will contain the last bill of exchange number assigned for this company if bill of exchange numbers are to be automatically assigned.	AR01.1, ARLL.1
`ACO-REMIT-NUMBER` REMIT_NUMBER	Numeric 7	Remittance number. This will be used if the company is processing bills of exchange. If so, this will contain the last remittance number assigned for the company.	AR01.1
`ACO-REASSIGN-NBR` REASSIGN_NBR	Numeric 7	Reassignment number. Contains the last DB number used in the reassignment of open obligations. It will have a prefix of "GP-".	AR01.1
`ACO-DRAFT-NBR-OPT` DRAFT_NBR_OPT	Alpha 1	Indicates the type of bill of exchange numbering that will be used for the company. Valid values are: `A` Automatic BOE numbering `M` Manual BOE numbering	AR01.1
`ACO-DEP-INST-CODE` DEP_INST_CODE	Alpha 3	Default deposit bank code. Must be a valid bank service transaction code in the Lawson Cash Ledger system.	AR01.1
`ACO-RTM-INST-CODE` RTM_INST_CODE	Alpha 3	Default return-to-maker payment code. Must be a valid bank service transaction code in the Lawson Cash Ledger system.	AR01.1
`ACO-ADJ-INST-CODE` ADJ_INST_CODE	Alpha 3	Default additional bank charges code. Must be a valid bank service transaction code in the Lawson Cash Ledger system.	AR01.1
`ACO-EFT-INST-CODE` EFT_INST_CODE	Alpha 3	The EFT deposit payment code.	AR01.1
`ACO-EFTPAY-INST-CD` EFTPAY_INST_CD	Alpha 3	The EFT credit payment code.	AR01.1
`ACO-DSC-REMIT-INST` DSC_REMIT_INST	Alpha 3	Default payment code when a discounted remittance is cashed. Must be a valid bank service transaction code in the Lawson Cash Ledger system.	AR01.1
`ACO-DTL-PAYMENT` DTL_PAYMENT	Alpha 1	Detail payment accrual general ledger interface record option. Valid values are: interface records not created. Default. ledger interface records. `N` No; detail payment general ledger `Y` Yes; create detail payment general	AR01.1
`ACO-DTL-APPL` DTL_APPL	Alpha 1	Detail application accrual general ledger interface record option. Valid values are: general ledger interface records not created. Default. accrual general ledger interface records. `N` No; detail application accrual `Y` Yes; create detail application	AR01.1
`ACO-DTL-FIN-CHRG` DTL_FIN_CHRG	Alpha 1	Detail finance charge accrual general ledger interface record option. Valid values are: general ledger interface records not created. Default. accrual general ledger interface records. `N` No; detail finance charge accrual `Y` Yes; create detail finance charge	AR01.1
`ACO-MINIMUM` MINIMUM	Alpha 1	Determines if a minimum finance charge will be assessed. Valid values are `Y` Use minimum amount `N` Minimum amount not used	AR01.1
`ACO-FIN-CYCLE` FIN_CYCLE	Alpha 2	Finance charge cycle code.	AR01.1
`ACO-HIST-PER` HIST_PER	Numeric 2	The number of periods (as defined by the run requency of AR198 Transaction Status Update) before the status of a fully applied payment or transaction is updated. This has two results: 1. This value is the number of periods until the status of a payment or transaction will be updated from Fully Applied to Closed. 2. This value is also the number of periods until the status of a payment or transaction will be updated from Closed to Historical. Therefore, a payment or transaction is elgible for "as of reporting" for the number of periods equal to two times the value of this field. 01 12	AR01.1
`ACO-CASH-CODE` CASH_CODE	Alpha 4	A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.	AR01.1
`ACO-CR-CASH-CODE` CR_CASH_CODE	Alpha 4	The credit cash code. Must be a valid cash code in the Lawson Cash Ledger system.	AR01.1
`ACO-ACH-COMP-ID` ACH_COMP_ID	Alpha 10	EFT company ID number. Used for ACH processing to identify the entity that is sending or receiving funds.	AR01.1
`ACO-LAST-EFT-NBR` LAST_EFT_NBR	Numeric 7	Last EFT debit memo number. Used for cash application purposes for credit balance processing. As funds are withdrawn or sent to a customer for a credit balance, a zero check is created with a corresponding debit memo for the funds amount. This is used for accounting purposes, and as a balancing record to complete the cash application/removal process of a credit balance.	AR01.1
`ACO-CURR-DISPLAY` CURR_DISPLAY	Alpha 1	You can choose to display transaction amounts throughout the system in base currency or transaction currency. Valid values are: `B` Base currency `T` Transaction currency	AR01.1
`ACO-EDIT-REMIT` EDIT_REMIT	Alpha 1	Determines if payment remittance will be edited against existing transactions. `N` No `Y` Yes	AR01.1
`ACO-SUM-LINE` SUM_LINE	Alpha 1	Determines whether to display multi line open items in detail or summary. `N` No `Y` Yes	AR01.1
`ACO-THIRD-PARTY` 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	AR01.1
`ACO-INT-BY-DATE-FL` INT_BY_DATE_FL	Alpha 1	Indicates if finance charegs will be assessed by potentailly multiple finance charge rates, over a period of time, for a past due or paid late transaction.	AR01.1
`ACO-DUN-CYCLE-ID` DUN_CYCLE_ID	Numeric 6	Last Dunning Letter Cycle ID. Gets incremented by 1 when you run AR140 (Dunning Letter Selection). You can view the last dunning cycle ID on AR01.1 (Company).	AR01.1
`ACO-DUN-CYCLE-STAT` DUN_CYCLE_STAT	Alpha 1	The dunning cycle status. Values are: `1` Selected (after running AR140) `2` Printed (after running AR141) `3` Dunning History Produced `4` Cycle complete (after running AR145)	—
`ACO-OB-DRF-FL` OB_DRF_FL	Alpha 1	Select whether to include or exclude BOE item balances. Yes means to include BOE items in balances. No means to exclude BOE items from balances. `Y` Include BOE items `N` Do not include BOE items	AR01.1
`ACO-REMIT-CNTL` REMIT_CNTL	Alpha 1	— `Y` Process Draft on Remittance `N` Do Not process Draft on remitt	AR01.1
`ACO-DISC-TAX-RCV` DISC_TAX_RCV	Alpha 1	Determines if a prorated amount of tax will be recognized from cash application discounting on transactions that have tax-based distribution records. Valid values are: `N` No `Y` Yes	AR01.1
`ACO-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code representing the country of the company. `Y` Yes recover tax on discount `N` Do not recover tax on discount	AR01.1
`ACO-REGION` REGION	Alpha 2	The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)	AR01.1
`ACO-LATE-CH-RND-FL` LATE_CH_RND_FL	Alpha 1	Interest by date charges rounding preference. If set to "Y", any resulting interest charge invoices will be rounded to the nearest currency unit.	AR01.1
`ACO-VEN-CLASS` VEN_CLASS	Alpha 3	A user-defined code representing a subset of vendors within a vendor group. Used in AR48 AR to AP Interface.	AR01.1
`ACO-VEND-AR-TO-AP` VEND_AR_TO_AP	Alpha 1	Controls if the interface between AR and AP is allowed, as well as the automatic vendor creation aspect of this interface. `Y` Allow Vendor creation AR to AP `N` No Vendor creation AR to AP	AR01.1
`ACO-EFT-PROCESS` EFT_PROCESS	Alpha 1	Indicates whether this company will process EFt tranascations. Valid values are: `N` No EFT processing `Y` EFT processing	AR01.1
`ACO-CALENDAR` CALENDAR	Alpha 15	The calendar used for EFT processing. The calendar must be defined in the Universe calendar definition program.	AR01.1
`ACO-DUE-DAYS` DUE_DAYS	Numeric 3	The number of days used to calculate the ending due date range in EFT processing.	AR01.1
`ACO-DUE-TYPE` DUE_TYPE	Alpha 1	The type of days used to calulate the ending due date range. Valid values are. `A` Actual Days `M` Marked Days `A` Actual Days `M` Marked Days	AR01.1
`ACO-GL-DAYS` GL_DAYS	Numeric 3	The number of days used to calculate the ending GL date range.	AR01.1
`ACO-GL-TYPE` GL_TYPE	Alpha 1	The type of days used to calculate the ending GL date range. Valid values are: `A` Actual Days `M` Marked Days	AR01.1
`ACO-DEPOSIT-DAYS` DEPOSIT_DAYS	Numeric 3	The number of days used to calculate the end deposit days date range.	AR01.1
`ACO-DEPOSIT-TYPE` DEPOSIT_TYPE	Alpha 1	The type of days used to calculate the ending deposit days date reange. Valid values are: `A` Actual Days `M` Marked Days	AR01.1
`ACO-CUST-AUDIT` CUST_AUDIT	Alpha 1	Indicates whether customer changes will be tracked at the company level. Valid values are: `N` No changes audited `Y` Changes audited	AR01.1
`ACO-NA-TRAN-FL` NA_TRAN_FL	Alpha 1	Indicates whether national account transaction records will be created or deleted in AR12 National Account, or in AR112 National Account Transaction Update. If a company will have national accounts with a very high number of open transactions amongst a national account relationship, for performance considerations, it is recommended that `this option` "Y". Valid values are: `N` AR12 will maintain transactions `Y` AR112 will maintain transactions	AR01.1
`ACO-PROCURE-GROUP` PROCURE_GROUP	Alpha 4	This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.	AR01.1
`ACO-CREDIT-CB-PRFX` CREDIT_CB_PRFX	Alpha 2	—	AR01.1
`ACO-CREDIT-CB-NBR` CREDIT_CB_NBR	Numeric 7	—	AR01.1
`ACO-INTRF-DST-CREA` INTRF_DST_CREA	Alpha 1	Indicates whether interface transactions will have a historical AR Code based distribution record created, used for reporting purposes in AR197 Self Balancing Report. " " = Space `N` No `Y` Yes	AR01.1
`ACO-INTRF-DST-SUM` INTRF_DST_SUM	Alpha 1	Indicates whether interface transactions will create historical AR Code based distribution records in detail or in summary. " " = Space `N` No `Y` Yes	AR01.1
`ACO-VERIFY-DEP-DTE` VERIFY_DEP_DTE	Alpha 1	— `Y` Yes `N` No	AR01.1
`ACO-DUNS-NUMBER` DUNS_NUMBER	Numeric 9	—	AR01.1
`ACO-EIN` EIN	Alpha 20	—	AR01.1
`ACO-FIN-CHG-PRFX` FIN_CHG_PRFX	Alpha 3	—	AR01.1

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`ACOSET1`	`COMPANY`	Primary		AC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
`ACOSET2`	`CUST-GROUP`, `COMPANY`			AR00.1, AR01.1, AR09.1, AR200, AR301

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcustgrp	ARCUSTGRP	Required		`ACO-CUST-GROUP` → `ACG-CUST-GROUP`

One to many (19) — child tables

Relation	Table	Rules	Field map
Agingcode	AGINGCODE		`ACO-COMPANY` → `AGE-COMPANY`, → `AGE-AGING-CODE`
Arcategory	ARCATEGORY		`ACO-COMPANY` → `ACA-COMPANY`, → `ACA-AR-CATEGORY`
Archgbaktx	ARCHGBAKTX	Delete Restricted	`ACO-COMPANY` → `AKT-COMPANY`, → `AKT-TEXT-CODE`, → `AKT-LANGUAGE-CODE`
Arcode	ARCODE	Delete Cascades	`ACO-COMPANY` → `RCD-COMPANY`, → `RCD-AR-CODE`
Arcompaud	ARCOMPAUD		`ACO-COMPANY` → `RAU-COMPANY`, → `RAU-UNIQUE-I-D`
Arcustomers	ARCUSTOMER	Delete Restricted	`ACO-COMPANY` → `ACM-COMPANY`, → `ACM-CUSTOMER`
Aroitems	AROITEMS	Delete Restricted	`ACO-COMPANY` → `ARO-COMPANY`, → `ARO-TRANS-TYPE`, → `ARO-INVOICE`, → `ARO-PAYMENT-SEQ`
Arpaynottx	ARPAYNOTTX	Delete Restricted	`ACO-COMPANY` → `ANT-COMPANY`, → `ANT-TEXT-CODE`, → `ANT-LANGUAGE-CODE`
Arproclevels	ARPROCLEVL	Delete Restricted	`ACO-COMPANY` → `APV-COMPANY`, → `APV-PROCESS-LEVEL`
Arpymntheaders	ARPYMNTHDR	Delete Restricted	`ACO-COMPANY` → `APH-COMPANY`, → `APH-BATCH-NBR`
Arreasons	ARREASON	Delete Cascades	`ACO-COMPANY` → `ARR-COMPANY`, → `ARR-TYPE`, → `ARR-REASON-CODE`
Arrtmtx	ARRTMTX	Delete Restricted	`ACO-COMPANY` → `RTX-COMPANY`, → `RTX-TEXT-CODE`, → `RTX-LANGUAGE-CODE`
Arstmprttx	ARSTMPRTTX	Delete Restricted	`ACO-COMPANY` → `ASX-COMPANY`, → `ASX-TEXT-CODE`, → `ASX-LANGUAGE-CODE`
Arsummary	ARSUMMARY	Delete Cascades	`ACO-COMPANY` → `ARS-COMPANY`, → `ARS-TYPE`, → `ARS-PROCESS-LEVEL`
Cranalyst	CRANALYST	Delete Restricted	`ACO-COMPANY` → `CAN-COMPANY`, → `CAN-CREDIT-ANLYST`
Cust Defaults	CUSTDEFLTS	Delete Cascades	`ACO-COMPANY` → `CDF-COMPANY`, → `CDF-DEFAULT-CODE`
Salesrep	SALESREP	Delete Cascades	`ACO-COMPANY` → `SAW-COMPANY`, → `SAW-SALESMAN`
Staticcust	STATICCUST		`ACO-COMPANY` → `STA-COMPANY`, → `STA-CUSTOMER`
Territory	TERITORY	Delete Cascades	`ACO-COMPANY` → `TRY-COMPANY`, → `TRY-TERRITORY`

Programs

Updated by (3)

AR01.1 Company
ARLL.1 AR Transaction Interface
CB06.2 Bank Statement Detail Entry

Referenced by (376)

AC56.1 Setup Interface Adjustment
AC560 Setup Interface
AP125 Batch Release
AP126 Mass Invoice Release
AP131 Chargeback
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.4 Invoice Cancel
AP510 Vendor Conversion
API1.1 Add Invoice
API2.1 Add Invoice
AR00.1 Customer Group
AR02.1 Process Level
AR03.1 Process Level Group
AR03.2 Process Level Report Group
AR04.1 Cycle Codes
AR06.1 Credit Analyst
AR06.2 Territory
AR06.3 Sales Representative
AR06.4 Operator
AR08.1 Customer Defaults
AR08.2 Billing Customer Fields
AR09.1 Customer Group Address
AR09.4 Bill To
AR10.1 Customer
AR10.2 Customer Process Level Inclusion
AR10.3 Billing
AR11.1 Customer Contacts
AR12.1 National Account
AR12.2 National Account Speed Entry
AR13.1 MICR Customer
AR13.2 Customer MICR
AR14.1 Lockbox
AR15.1 Adjustment Reasons
AR15.2 Expanded Reasons
AR15.3 Memo Reasons
AR15.4 Category
AR15.5 Dispute
AR15.6 Operator
AR15.7 GL Code
AR15.8 Aging Code
AR17.1 Comments
AR18.1 Dunning Text
AR200 Customer Group Listing
AR201 Company Process Level Listing
AR203 Report Group Listing
AR204 Cycle Listing
AR206 Operational Setup 1 Listing
AR208 Customer Defaults Listing
AR209 Customer Labels Print
AR210 Customer Listing
AR211 Customer Optional Fields Listing
AR212 National Account Listing
AR213 MICR Customer Listing
AR215 Operational Setup 2 Listing
AR217 Comments Listing
AR218 Dunning Text Listing
AR23.1 Customer Attributes
AR23.3 Customer View Preview
AR23.4 Manual Customer List
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
BR00.1 Activity Billing
BR00.2 Billing Detail
BR02.3 Retainer Invoice Entry
BR10.1 Contract Parameters
BR10.9 Product Contract Parameters
BR11.1 Customer
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR131 Revenue Realization
BR140 Billing and Revenue Backout
BR145 Invoice Control Maintenance
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR155 Maintenance Schedule Copy
BR156 Maintenance Quote
BR157 Maintenance Cancel
BR16.1 Service Location
BR16.2 Customer Maintenance Renew Date
BR17.1 Bill To Group
BR180 Location Vertex Geocode Update
BR19.1 Single Invoice Calculation
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR20.7 Invoice Header
BR21.1 Invoice Cancellation
BR21.2 Filter
BR210 Contract Listing
BR211 Activity Customer Listing
BR216 Service Location Listing
BR217 Bill To Group Listing
BR220 Invoice Audit Listing
BR245 Invoice Control Listing
BR251 Product Contract Listing
BR252 Maintenance Schedule Listing
BR253 Deferred Revenue Listing
BR288 Contract Audit Analysis Report
BR300 Invoice Purge
BR305 Contract Audit Analysis Purge
BR400 Invoice History
BR420 Billing Invoice Report
BR45.1 Invoice Control
BR450 Activity Aging
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR48.1 Customer Template
BR49.1 Invoice Adjustment Maintenance
BR51.1 Product Contract
BR51.2 Product Cost of Goods Sold
BR52.1 Maintenance Schedule
BR52.2 New Maintenance Schedule
BR521 Billing Import
BR53.1 Product Deferred Revenue Schedule
BR55.1 Maintenance Invoice Cancellation
BR55.2 Filter
BR70.1 Product Contract Interface Adjustment
BR70.2 Product Interface Cost of Goods Sold
BR91.1 Contract By Customer Inquiry
BRIP.1 Invoice Print Program
CB191 Bank Statement Close
CX05.1 Preference Template
CX05.2 Preference Template Diagnostics
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CX805 Template Card Conversion
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
GL286 AR Grand Livre Report - Period
GL287 AR Grand Livre Report - Date
IC02.1 Location
IC12.1 Item Location
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC243 Killed Item Report
IC330 Item Mass Change
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC83.1 Par Location Counts
ICLM.1 Build Location Matrix List
IN20.1 Intrastat Data Maintenance
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA66.2 Invoice Message - Details
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.5 Receipt Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MAI1.1 Invoke for MAMATCH Object
MX123 List Member Build
MX500 Attribute Value Population
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO136 Matched, Not Received Report
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO150 Bid Load to Contract or Catalog
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO25.1 Vendor Agreements
PO25.5 Vendor Agreement Item Add-On Cost
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO251 PO Buyer Message Listing
PO26.3 Vendor Agreement Commitments Spread
PO26.7 Mass Release of Vendor Agreements
PO26.9 Vendor Agreement Release
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO28.2 Vendor Agreement Line Detail List
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO36.1 Identify Lawson Items by Vendor Agreement Line
PO36.2 Vendor Agreement Import Manual Input
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO536 Vendor Price Agreement Load
PO54.5 PO Line Detail List
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
TX100 Tax Analysis Report
TX101 Journal File Create
TX130 European Community Sales Report
TX140 Vertex Geocode Update
TX226 Purchasing and Sales Journal
TX301 Journal Detail Purge
TX40.1 Tax Inquiry for Vertex
WH110 Batch Allocation
WH120 Route Creation
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.1 Inventoried Allocation
WH20.2 Nonstock and Special Allocation
WH20.3 Bin Allocation
WH20.4 Lot Allocation
WH20.5 Serial Allocation
WH20.6 UOM Allocation
WH20.7 Substitute Location
WH21.1 Routes
WH21.2 Stops
WH21.3 Stop Transfer
WH21.4 Document Transfer
WH210 Route File Listing
WH22.1 Kit Options
WH222 Shipments In Process
WH224 Packing List Print
WH226 Items on Backorder Report
WH25.1 Cancellation By Item
WH25.2 Cancellation By Document
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program