ARCOMP

AR Company

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.

REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
AR06.1 AR06.2 AR06.3 AR06.4 AR08.1 AR08.2
AR10.1 AR10.2 AR10.3 AR11.1 AR12.1 AR12.2
AR13.1 AR13.2 AR15.1 AR15.2 AR15.3 AR15.4
AR15.5 AR15.6 AR15.7 AR15.8 AR17.1 AR18.1
AR210 AR211 AR217 AR23.1 AR23.3 AR23.4
AR501 AR550 BR00.1 BR00.2 BR02.3 BR10.1
BR10.9 BR120 BR121 BR122 BR123 BR131
BR140 BR145 BR151 BR152 BR155 BR156
BR157 BR16.1 BR16.2 BR17.1 BR180 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.1 BR21.2 BR210 BR211 BR216 BR217
BR220 BR245 BR251 BR252 BR253 BR300
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR49.1 BR51.1 BR51.2 BR52.1 BR52.2
BR521 BR53.1 BR55.1 BR55.2 BR70.1 BR70.2
BR91.1 BRIP.1 CB191 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC02.1 IC140 IC66.1 IC83.1
ICLM.1 MX123 MX500 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO28.2 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIF.1 TX101 TX140 TX40.1
WH110 WH120 WH130 WH132 WH190 WH21.2
WH222 WH224 WH226 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 ZW130 AR02.1 AR03.1 AR03.2
AR04.1 AR14.1 AR201 AR203 AR204 AR206
AR208 AR209 AR212 AR213 AR215 AR218
GL286 GL287 IN20.1 TX100 TX130 TX226
TX301 AR200


UPDATED BY
AC56.1 AC560 AR00.1 AR01.1 AR09.1 AR301
ARLL.1 BR11.1 BR48.1 CB06.2 WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACO-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR01.1
ACO-CUST-GROUP
Element: Customer 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
Element: Company 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
Element: Address 1
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
Element: Address 2
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
Element: Address 3
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
Element: Address 4
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
Element: 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
Element: State or Province
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
Element: Postal Code
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
Element: Country or other
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
Element: 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
Element: Telephone Number
Alpha 15
The company phone number.
AR01.1
ACO-FAX-NMBR
Element: Fax Number
Alpha 15
The company fax number.
AR01.1
ACO-CHRG-BACK-NBR
Element: Chargeback Number
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
Auto Number Trans
Batches
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
Last Transaction
Batch Number
Numeric 6
The last batch number assigned for manual invoice entry.
AR01.1
ACO-INV-BTCH-TL
Trans Batch Control
Totals
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 Number Cash
Batches
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
Last Auto Batch
Number Used
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
Cash Batch Control
Total
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
Element: Summary Batch Number
Numeric 6
The last system-assigned batch number used when creating chargeback records.
AR01.1
ACO-LAST-RTM-NBR
Element: Last RTM Number
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 Converted
Batch Number
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
Element: Risk Code
Alpha 1
The default risk code that will be assigned to all new customers being added for this company.
AR01.1
ACO-OFFSET-FL
Automatic
Application
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
Element: AR Code
Alpha 4
The default accounts receivable code for the company level.
AR01.1
ACO-NOT-APPLD-CD
Received Not
Applied Code
Alpha 4
The default received not applied code at the company level.
AR01.1
ACO-PRE-PAY-CODE
Element: Prepayment 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
Last Customer
Activity
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
Element: Age Credits
Alpha 1
Specifies how credit memos should be aged. Valid values are: L = Aged to last debit-containing column N = Not aged - aged in current column R = Aged respective to credit memo date
AR01.1
ACO-AGE-PYMNT
Element: Age Payment
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
Element: 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
Element: 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
Element: 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
Element: Age Periods
Numeric 3 Occurs 4 Times
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
Element: Finance Disputes
Alpha 1
Specifies if disputed transactions are exempt from being assessed finance charges. Valid values are: N = No finance charges on disputed items Y = Yes, subject to finance charges
AR01.1
ACO-OI-DISP-SEQ
Element: 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
Cash Application
Operator Code
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
Memo/Invoice
Operator Code
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
Element: Application Review
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
Discount Grade
Period
Numeric 2
Number of grace days added to discount date to allow automatic discount during cash application.
AR01.1
ACO-LATE-PAY-FL
Late Payment &
Finance Charges
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: Blank = No charges F = Finance charges assessed L = Late payments charges assessed B = Both finance and late payment charges will be assessed
AR01.1
ACO-FIN-CALC-TYPE
Finance Charge
Calculation
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
Last Finance Charge
Number
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
Element: Finance Charge Code
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
Finance Charge
Grace 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
Minimum Finance
Charge
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
Element: 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
Element: Finance 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
Element: Currency Code
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
Element: Multi Currency Flag
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
Conversion Rate
Override
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
Invoice Currency
Override
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
Element: Verify GL Date
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
Default Application
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
Element: 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 Application
Flag
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
Discount Display
Flag
Alpha 1
Determines if past-due discount amounts will display during cash application. Valid values are: N = No past due discount amounts displayed Y = Display past due discounts
AR01.1
ACO-UPD-DUE-DATE
Update Trans Date /
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
Element: Incomplete Company
Alpha 1
Indicates that the AR company is only partially set up.
AR01.1
ACO-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
AR01.1
ACO-DISPLAY-DATE
Element: 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
Element: Transaction 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
Element: Bank Risk Option
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
Acceptance
Accounting
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
Element: BOE Acceptance 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
Financial Revenue
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
Financial Expense
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
Dishonored Expense
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 Bill of
Exchange Number
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
Element: Remittance 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
Element: Reassignment Number
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
Bill of Exchange
Numbering
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
Element: Deposit 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
Element: RTM Payment 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
Additional Bank
Charges
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
Element: Deposit Payment Code
Alpha 3
The EFT deposit payment code.
AR01.1
ACO-EFTPAY-INST-CD
Element: Credit Payment Code
Alpha 3
The EFT credit payment code.
AR01.1
ACO-DSC-REMIT-INST
Discounted
Remittance
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
Element: Payment GL Interface
Alpha 1
Detail payment accrual general ledger interface record option. Valid values are: N = No; detail payment general ledger interface records not created. Default. Y = Yes; create detail payment general ledger interface records.
AR01.1
ACO-DTL-APPL
Application GL
Interface
Alpha 1
Detail application accrual general ledger interface record option. Valid values are: N = No; detail application accrual general ledger interface records not created. Default. Y = Yes; create detail application accrual general ledger interface records.
AR01.1
ACO-DTL-FIN-CHRG
Finance Charge GL
Interface
Alpha 1
Detail finance charge accrual general ledger interface record option. Valid values are: N = No; detail finance charge accrual general ledger interface records not created. Default. Y = Yes; create detail finance charge accrual general ledger interface records.
AR01.1
ACO-MINIMUM
Minimum Finance
Charge
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
Finance Charge
Cycle Code
Alpha 2
Finance charge cycle code.
AR01.1
ACO-HIST-PER
Element: History Periods
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
Element: 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
Element: Credit 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
Element: EFT Company 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 Debit Memo
Number
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
Element: Currency 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
Element: Edit Remittance
Alpha 1
Determines if payment remittance will be edited against existing transactions.
N = No
Y = Yes
AR01.1
ACO-SUM-LINE
Element: Summary Line
Alpha 1
Determines whether to display multi line open items in detail or summary.
N = No
Y = Yes
AR01.1
ACO-THIRD-PARTY
Element: Third Party
Alpha 1
This field indicates if this customer's payments may be applied to any customer's open transactions.
N = No third party payment
Y = Third party payment allowed
AR01.1
ACO-INT-BY-DATE-FL
Element: 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
Element: 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
Element: 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
Element: Ob Drf Fl
Alpha 1
This field specifies whether to include or exclude BOE item balances. "Y" means to include BOE items in balances. "N" means to exclude BOE items from balances.
Y = Include BOE items
N = Do not include BOE items
AR01.1
ACO-REMIT-CNTL
Element: Remit Cntl
Alpha 1

Y = Process Draft on Remittance
N = Do Not process Draft on remitt
AR01.1
ACO-DISC-TAX-RCV
Element: All Flag
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Due Days
Numeric 3
The number of days used to calculate the ending due date range in EFT processing.
AR01.1
ACO-DUE-TYPE
Element: 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
Element: Gl Days
Numeric 3
The number of days used to calculate the ending GL date range.
AR01.1
ACO-GL-TYPE
Element: 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
Element: Deposit Days
Numeric 3
The number of days used to calculate the end deposit days date range.
AR01.1
ACO-DEPOSIT-TYPE
Element: 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
Element: 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
Element: Flag
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
Element: 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
Element: Credit Cb Prfx
Alpha 2
AR01.1
ACO-CREDIT-CB-NBR
Element: Credit Cb Nbr
Numeric 7
AR01.1
ACO-INTRF-DST-CREA
Element: Flag
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
Element: Flag
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
Element: Flag
Alpha 1

Y = Yes
N = No
AR01.1
ACO-DUNS-NUMBER
Element: Duns Number
Numeric 9
AR01.1
ACO-EIN
Element: Emp Acct Nbr
Alpha 20
AR01.1


ARCOMP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACOSET1 COMPANY
...
AC56.1 AC560
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
AR01.1 AR02.1
AR03.1 AR03.2
AR04.1 AR06.1
AR06.2 AR06.3
AR06.4 AR08.1
ACOSET2 CUST-GROUP
COMPANY
AR00.1 AR01.1
AR09.1 AR200
AR301


ARCOMP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP->ACG-CUST-GROUP


ARCOMP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
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


File created: Thu Jun 09 11:08:56 2016

Home
Contact Us



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