|
|
ARCOMP FILE
AR Company
AR Company
REFERENCED BY
AC115 AC15.2 AC450 AR02.1 AR03.1 AR03.2
AR04.1 AR06.1 AR06.2 AR06.3 AR06.4 AR08.1
AR08.2 AR09.4 AR09.1 AR10.1 AR10.2 AR10.3
AR100 AR105 AR11.1 AR110 AR12.1 AR12.2
AR124 AR13.1 AR13.2 AR131 AR132 AR135
AR136 AR14.1 AR15.1 AR15.2 AR15.3 AR15.4
AR15.5 AR15.6 AR15.7 AR15.8 AR150 AR155
AR160 AR161 AR17.1 AR17.2 AR170 AR18.1
AR180 AR19.4 AR19.5 AR19.6 AR19.7 AR191
AR194 AR196 AR199 AR201 AR203 AR204
AR206 AR208 AR209 AR21.1 AR21.2 AR21.3
AR21.4 AR21.5 AR21.6 AR21.7 AR210 AR211
AR212 AR213 AR215 AR217 AR218 AR220
AR222 AR227 AR228 AR229 AR230 AR232
AR233 AR234 AR235 AR24.1 AR242 AR245
AR25.1 AR25.2 AR250 AR251 AR252 AR253
AR255 AR256 AR258 AR271 AR274 AR275
AR28.1 AR28.2 AR28.3 AR28.4 AR28.5 AR28.6
AR28.7 AR28.8 AR282 AR286 AR287 AR29.1
AR29.2 AR29.3 AR290 AR291 AR292 AR294
AR295 AR300 AR301 AR31.1 AR31.5 AR31.6
AR35.1 AR35.2 AR36.1 AR36.2 AR37.1 AR37.2
AR37.3 AR37.4 AR37.5 AR37.6 AR37.7 AR37.8
AR37.9 AR45.1 AR46.1 AR50.1 AR501 AR504
AR506 AR507 AR53.1 AR550 AR58.1 AR70.1
AR70.2 AR72.1 AR72.2 AR73.1 AR73.2 AR74.1
AR75.1 AR80.1 AR80.2 AR90.1 AR90.2 AR95.1
AR971 AR976 AR980 BL00.1 BL01.1 BL02.1
BL02.2 BL04.1 BL05.1 BL120 BL121 BL122
BL123 BL130 BL20.1 BL20.3 BL201 BL202
BL204 BL21.2 BL21.5 BL220 BL231 BL246
BL29.1 BL29.2 BL290 BL291 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.3 BL32.4 BL33.1
BL331 BL34.1 BL46.1 BL46.2 BL47.1 BL520
BL546 BL80.1 BL80.3 BL802 BL81.1 BL820
BL85.1 BL85.2 BL85.3 BL90.1 BL902 BL91.1
BL92.1 BL940 CB191 DT170 DT181 DT185
DT190 DT220 DT270 DT280 DT42.1 DT52.1
DT90.1 DT90.3 DT95.1 GL286 GL287 IN20.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE112 OE113 OE114 OE129 OE13.1
OE130 OE14.3 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE230 OE254 OE260
OE270 OE271 OE272 OE280 OE281 OE284
OE285 OE286 OE287 OE290 OE291 OE292
OE293 OE294 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE330 OE510
OE53.1 OE54.1 OE60.1 OE80.1 OE80.2 OE81.1
OE81.2 OE810 OE830 OE85.1 OE90.1 OE90.2
OE920 OE950 PBIP.1 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 SAA2.1 TX130 TX140
TX225 TX40.1 WH110 WH120 WH130 WH132
WH190 WH20.2 WH20.7 WH21.2 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WO235 WO35.1
AR00.1 AR200 AR260 AR261 AR505
UPDATED BY
AR01.1 AR115 AR130 AR137 AR140 AR141
AR145 AR190 AR20.1 AR30.1 AR30.2 AR30.4
AR30.8 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR502 AR503 AR560 AR570 AR575
AR580 AR700 AR82.1 AR952 AR970 CB06.2
DT150 DT155 DT160 DT161 DT165 DT166
DT180 DT30.1 DT30.2 DT40.1 DT45.1 DT520
DT60.1 DT60.2 DT70.1 DT70.3 DT80.1 DT85.1
DT85.2 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACO-COMPANY Numeric 4 AR01.1 AR952
Company The company number represents an AR970
established company and is entered on
all function codes.
ACO-CUST-GROUP Alpha 5 AR01.1 AR35.1
Customer Group Customer group assigned to this AR952 AR970
company. Only customers initially TX130
defined with this customer group are
eligible to be customers of this
company.
ACO-NAME Alpha 30 (Lower Case) AR01.1 AR952
Company Name The name or description of the accounts AR970
receivable company. The name defaults
from the Lawson General Ledger system
unless you override it in the Lawson
Accounts Receivable system.
ACO-ADDR1 Alpha 30 (Lower Case) AR01.1 AR952
Address 1 First line of address information. AR970
Defaults from the general ledger or
interface company address and will be
maintainable once it is initially added.
ACO-ADDR2 Alpha 30 (Lower Case) AR01.1 AR952
Address 2 Second line of address information. AR970
Defaults from the general ledger or
interface company address, and will be
maintainable once it is initially added.
ACO-ADDR3 Alpha 30 (Lower Case) AR01.1 AR952
Address 3 Third line of address information. AR970
Defaults from the general ledger or
interface company address, and will be
maintainable once it is initially added.
ACO-ADDR4 Alpha 30 (Lower Case) AR01.1 AR952
Address 4 Fourth line of address information. AR970
Defaults from the general ledger or
interface company address, and will be
maintainable once it is initially added.
ACO-CITY Alpha 18 (Lower Case) AR01.1 AR952
City City Name. Defaults from the general AR970
ledger or interface company address and
will be maintainable once it is
initially added.
ACO-STATE Alpha 2 AR01.1 AR952
State or Province State or province abbreviation. AR970
Defaults from the general ledger or
interface company address, and will be
maintainable once it is initially added.
ACO-ZIP Alpha 10 AR01.1 AR952
Postal Code Postal code. Defaults from the general AR970
ledger or interface company address, and
will be maintainable once it is
initially added.
ACO-COUNTRY Alpha 30 (Lower Case) AR01.1 AR952
Country or other Country name. Defaults from the general AR970
ledger or interface company address, and
will be maintainable once it is
initially added.
ACO-COUNTY Alpha 25
County For use in a future release.
ACO-PHONE-NMBR Alpha 15 AR01.1 AR952
Telephone Number The company phone number. AR970
ACO-FAX-NMBR Alpha 15 AR01.1 AR952
Fax Number The company fax number. AR970
ACO-CHRG-BACK-NBR Numeric 7 AR01.1 AR130
Chargeback Number This field will contain the last used AR190 AR30.1
transaction number for created AR30.2 AR30.4
chargebacks. The chargebacks will be in AR30.8 AR952
the form of debit memos in the open item AR970
file. This number will be prefixed by
"CB-".
ACO-INV-BTCH-FL Alpha 1 AR01.1 AR952
Auto Number Trans Specifies whether the manual invoice AR970
Batches batches will be automatically assigned.
Valid values are:
N = No automatic batch numbering
Y = Automatic batch numbering
ACO-INV-BTCH-NBR Numeric 6 AR01.1 AR42.1
Last Transaction The last batch number assigned for AR952 AR970
Batch Number manual invoice entry.
ACO-INV-BTCH-TL Alpha 1 AR01.1 AR952
Trans Batch Control This option allows system batch totals AR970
Totals to be force balanced to header totals
prior to release. Valid values are:
N = No total balancing required
Y = Total balancing required
ACO-AUTO-BTCH-FL Alpha 1 AR01.1 AR952
Auto Number Cash This option will specify whether or not AR970
Batches automatic batch numbering will be used
in cash entry. Valid values are:
N = No automatic batch numbering
Y = Automatic batch numbering
ACO-AUTO-BAT-NBR Numeric 6 AR01.1 AR115
Last Auto Batch The last number assigned for the AR20.1 AR42.1
Number Used payment batch header. When a new batch AR42.2 AR42.6
is assigned, 1 will be added to this AR42.7 AR43.1
number and used to create the new batch AR44.3 AR502
record. This number can be maintained AR503 AR560
but cannot be changed to a value less AR570 AR575
than the highest batch number used. AR580 AR952
Note: This number sequence will also be AR970 CB06.2
used for lock box interfaced cash. DT150 DT155
DT160 DT165
DT166 DT180
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
ACO-BTCH-CNTRL-TL Alpha 1 AR01.1 AR952
Cash Batch Control This cash option allows system batch AR970
Total totals to be force balanced to control
totals. Valid values are:
N = No total balancing required
Y = Control balancing required
ACO-SUMM-BTCH-NBR Numeric 6 AR01.1 AR137
Summary Batch Number The last system-assigned batch number AR82.1 AR952
used when creating chargeback records. AR970
ACO-LAST-RTM-NBR Numeric 7 AR01.1 AR82.1
Last RTM Number Return-to-maker debit memo number. This AR952 AR970
is the numeric portion of the last RTM DT92.1
document to be generated by the system.
RTM debit memos are identified by a
preceding "RM-" followed by this
ascending seven digit number.
ACO-LAST-CONV-BTCH Numeric 3 AR503 AR952
Last Converted The last payment batch number the AR970
Batch Number 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 Alpha 1 AR01.1 AR952
Risk Code The default risk code that will be AR970
assigned to all new customers being
added for this company.
ACO-OFFSET-FL Alpha 1 AR01.1 AR952
Automatic Specifies if application will occur for AR970
Application cross referenced debits from a credit
memo. Valid values are:
N = No automatic memo application
Y = Automatic memo application allowed
ACO-AR-CODE Alpha 4 AR01.1 AR952
AR Code The default accounts receivable code AR970
for the company level.
ACO-NOT-APPLD-CD Alpha 4 AR01.1 AR952
Received Not The default received not applied code AR970
Applied Code at the company level.
ACO-PRE-PAY-CODE Alpha 4 AR01.1 AR952
Prepayment Code Prepayment code. This is the default AR970
code to be used for a check entered as a
prepayment. This will be the offset
instead of RNA to cash.
ACO-CUST-RETEN Numeric 3 AR01.1 AR952
Last Customer The number of months that must elapse, AR970
Activity after the last customer activity date,
before a customer can be automatically
deleted.
ACO-AGE-CREDITS Alpha 1 AR01.1 AR952
Age Credits Specifies how credit memos should be AR970
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
ACO-AGE-PYMNT Alpha 1 AR01.1 AR952
Age Payment Specifies how payments should be aged. AR970
Valid values are:
L = Aged to last debit-containing
column
N = Not aged - aged in current column
R = Aged respective to payment date
ACO-AGE-DISPUTES Alpha 1 AR01.1 AR952
Age Disputes Specifies how disputed transactions AR970
will be aged. Valid values are:
N = Not aged - aged in current column
Y = Aged respective to transaction date
ACO-AGE-TYPE Alpha 1 AR01.1 AR952
Age Type Default aging method respecting either AR970
invoice date or due date. Valid values
are:
D = Age by due date
T = Age by transaction date
ACO-AGE-CURRENT Numeric 3 AR01.1 AR952
Age Current This field will be used to define the AR970
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).
ACO-AGE-PERIODS Numeric 3 Occurs 4 Times AR01.1 AR952
Age Periods Aging periods established by entering AR970
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.
ACO-DISPUTES-FIN Alpha 1 AR01.1 AR952
Finance Disputes Specifies if disputed transactions are AR970
exempt from being assessed finance
charges. Valid values are:
N = No finance charges on disputed
items
Y = Yes, subject to finance charges
ACO-OI-DISP-SEQ Alpha 2 AR01.1 AR952
Open Item Display Indicates the default display sequence AR970
Sequence of the open items.
Valid values are:
1 = Company/Customer
2 = Customer PO
3 = Trans User-One
4 = Type/Trans Nbr
5 = Trans Amount
6 = Process Level
7 = Invoice Date
8 = Discount Date
9 = Due Date
10 = Activity
ACO-AUDIT-APP-FL Alpha 1 AR01.1 AR952
Cash Application Indicates if the operator code field is AR970
Operator Code 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
ACO-AUDIT-MEMO-FL Alpha 1 AR01.1 AR952
Memo/Invoice Indicates if operator code is required AR970
Operator Code 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
ACO-APP-REVIEW-FL Alpha 1 AR01.1 AR952
Application Review Indicates if applications are required AR970
to go through an audit listing prior to
applications being posted to the general
ledger. Valid values are:
N = No
Y = Yes
ACO-DISC-GRACE-PD Numeric 2 AR01.1 AR952
Discount Grade Number of grace days added to discount AR970
Period date to allow automatic discount during
cash application.
ACO-LATE-PAY-FL Alpha 1 AR01.1 AR952
Late Payment & Indicates what type of charges will be AR970
Finance Charges 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
ACO-FIN-CALC-TYPE Alpha 1 AR01.1 AR952
Finance Charge Determines how finance charges will be AR970
Calculation 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
ACO-FIN-AUTO-NBR Numeric 7 AR01.1 AR137
Last Finance Charge This field will hold the last finance AR952 AR970
Number 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-".
ACO-FIN-CHRG-CD Alpha 2 AR01.1 AR952
Finance Charge Code Finance charge code. This code must be AR970
predefined and will contain a monthly
finance charge percentage rates.
ACO-FIN-GRAC-DAYS Numeric 2 AR01.1 AR952
Finance Charge The number of grace days added to a AR970
Grace Days transaction's due date before finance
charges will be assessed.
ACO-FIN-MIN-CHRG Signed 7.2 AR01.1 AR952
Minimum Finance Override minimum finance charge amount AR970
Charge assessed if calculated finance charge is
less than this minimum amount. If a
minimum is zero, no override will occur.
ACO-FIN-DOC-PRNT Alpha 1 AR01.1 AR952
Print Finance This option will specify whether or not AR970
Charge Documents finance charge documents are required to
be printed. Valid values are:
N = No finance charge documents printed
Y = Yes, print finance charge documents
ACO-FIN-GL-CODE Alpha 4 AR01.1 AR952
Finance GL Code This is the default GL code to be used AR970
for finance charges at the company
level. It is tied to the finance charge
general ledger account.
ACO-CURRENCY-CD Alpha 5 AR01.1 AR952
Currency Code The base currency defined for the AR970
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.
ACO-MULTI-CURR-FL Alpha 1 AR01.1 AR952
Multi Currency Flag Determines if transactions in AR970
currencies differing from company base
currency will be allowed.
ACO-RATE-OVR-FL Alpha 1 AR01.1 AR952
Conversion Rate Determines whether or not user will be AR970
Override able to override conversion rate
tolerances when adding non company-based
currency transactions. Valid values are:
N = No
Y = Yes
ACO-INV-CUR-OVR Alpha 1 AR01.1 AR952
Invoice Currency Indicates whether users will be able to AR970
Override override the default customer invoice
currency code when entering manual
invoices.
ACO-VERIFY-GLDATE Alpha 1 AR01.1 AR952
Verify GL Date Establishes whether the system should AR970
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
ACO-DFLT-APP-DATE Alpha 1 AR01.1 AR952
Default Application Defines what default general ledger AR970
Date date the application records should
have. Valid values are:
P = Payment general ledger date
S = System date
ACO-HOLD-CODE Alpha 4 AR01.1 AR952
Hold Code The Hold Code found on the company AR970
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.
ACO-OVER-APP-FL Alpha 1 AR01.1 AR952
Over Application Determines whether users should be able AR970
Flag 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
ACO-DISC-DSP-FL Alpha 1 AR01.1 AR952
Discount Display Determines if past-due discount amounts AR970
Flag will display during cash application.
Valid values are:
N = No past due discount amounts
displayed
Y = Display past due discounts
ACO-UPD-DUE-DATE Alpha 1 AR01.1 AR952
Update Trans Date / Determines if transactions will be AR970
Due Date 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
ACO-INCOMPLETE-FL Alpha 1 AR01.1 AR952
Incomplete Company Indicates that the AR company is only AR970
partially set up.
ACO-BASE-ND Numeric 1 AR01.1 AR952
Base Number of The number of decimal positions defined AR970
Decimals for the company base currency.
ACO-DISPLAY-DATE Alpha 1 AR01.1 AR952
Display Date Display date. This field will control AR970
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)
ACO-TRANS-SEQUENCE Alpha 1 AR01.1 AR952
Transaction Sequence Transaction sequence. This field will AR970
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
ACO-BANK-RISK-OPT Alpha 1 AR01.1 AR952
Bank Risk Option 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
ACO-ACCEPT-ACCTING Alpha 1 AR01.1 AR952
Acceptance Acceptance accounting. This option is
Accounting 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
ACO-DT-ACCPT-CODE Alpha 4 AR01.1 AR952
BOE Acceptance Code 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.
ACO-FIN-REV-CODE Alpha 4 AR01.1 AR952
Financial Revenue Financial revenue code. This will be
Code 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.
ACO-FIN-EXP-CODE Alpha 4 AR01.1 AR952
Financial Expense Financial expense code. This code will
Code 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.
ACO-DIS-EXP-CODE Alpha 4 AR01.1 AR952
Dishonored Expense Dishonored expense code. This code will
Code 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.
ACO-LAST-DRAFT-NBR Numeric 10 AR01.1 AR42.1
Last Bill of Last bill of exchange number assigned. AR42.2 AR42.6
Exchange Number This will be used only if the company AR42.7 AR43.1
will be processing bills of exchange. AR44.3 AR502
If so, it will contain the last bill of AR560 AR952
exchange number assigned for this DT150 DT40.1
company if bill of exchange numbers are DT520 DT92.1
to be automatically assigned.
ACO-REMIT-NUMBER Numeric 7 AR01.1 AR952
Remittance Number Remittance number. This will be used if DT160 DT161
the company is processing bills of DT165 DT166
exchange. If so, this will contain the DT180 DT60.1
last remittance number assigned for the DT60.2 DT70.1
company. DT70.3 DT80.1
ACO-REASSIGN-NBR Numeric 7 AR01.1 AR952
Reassignment Number Reassignment number. Contains the last
DB number used in the reassignment of
open obligations. It will have a prefix
of "GP-".
ACO-DRAFT-NBR-OPT Alpha 1 AR01.1 AR952
Bill of Exchange Indicates the type of bill of exchange
Numbering numbering that will be used for the
company. Valid values are:
A = Automatic BOE numbering
M = Manual BOE numbering
ACO-DEP-INST-CODE Alpha 3 AR01.1 AR952
Deposit Code Default deposit bank code. Must be a AR970
valid bank service transaction code in
the Lawson Cash Ledger system.
ACO-RTM-INST-CODE Alpha 3 AR01.1 AR952
RTM Payment Code Default return-to-maker payment code. AR970
Must be a valid bank service transaction
code in the Lawson Cash Ledger system.
ACO-ADJ-INST-CODE Alpha 3 AR01.1 AR952
Additional Bank Default additional bank charges code. AR970
Charges Must be a valid bank service transaction
code in the Lawson Cash Ledger system.
ACO-EFT-INST-CODE Alpha 3 AR01.1
Deposit Payment Code The EFT deposit payment code.
ACO-EFTPAY-INST-CD Alpha 3 AR01.1
Credit Payment Code The EFT credit payment code.
ACO-DSC-REMIT-INST Alpha 3 AR01.1 AR952
Discounted Default payment code when a discounted
Remittance remittance is cashed. Must be a valid
bank service transaction code in the
Lawson Cash Ledger system.
ACO-DTL-PAYMENT Alpha 1 AR01.1 AR952
Payment GL Interface Detail payment accrual general ledger AR970
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.
ACO-DTL-APPL Alpha 1 AR01.1 AR952
Application GL Detail application accrual general AR970
Interface 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.
ACO-DTL-FIN-CHRG Alpha 1 AR01.1 AR952
Finance Charge GL Detail finance charge accrual general AR970
Interface 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.
ACO-MINIMUM Alpha 1 AR01.1 AR952
Minimum Finance Determines if a minimum finance charge AR970
Charge will be assessed. Valid values are
Y = Use minimum amount
N = Minimum amount not used
ACO-FIN-CYCLE Alpha 2 AR01.1 AR952
Finance Charge Finance charge cycle code. AR970
Cycle Code
ACO-HIST-PER Numeric 2 AR01.1 AR952
History Periods The number of periods until the status AR970
of a 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
remains in the system for a number of
periods equal to two times the value of
this field until it becomes historical.
A period is closed by running AR199
(Period Closing).
ACO-HIST-PER-CLS Numeric 2
History Periods The number of times AR199 (Period
Closing Closing) has updated the status of
transactions payments.
ACO-CASH-CODE Alpha 4 AR01.1
Cash Code 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.
ACO-CR-CASH-CODE Alpha 4 AR01.1
Credit Cash Code The credit cash code. Must be a valid
cash code in the Lawson Cash Ledger
system.
ACO-ACH-COMP-ID Alpha 10 AR01.1
EFT Company ID EFT company ID number. Used for ACH
processing to identify the entity that
is sending or receiving funds.
ACO-LAST-EFT-NBR Numeric 7 AR01.1 AR115
Last EFT Debit Memo Last EFT debit memo number. Used for
Number 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.
ACO-CURR-DISPLAY Alpha 1 AR01.1 AR700
Currency Display You can choose to display transaction AR952
amount throughout the system in base
currency or transaction currency.
Valid values are:
B = Base currency
T = Transaction currency
ACO-EDIT-REMIT Alpha 1 AR01.1 AR700
Edit Remittance Determines the remittance editing logic. AR952
Valid values are:
N = No
Y = Yes
ACO-SUM-LINE Alpha 1 AR01.1 AR700
Summarize Open Item Determines whether to display open items AR952
Line Items in detail or summary. Valid values are:
N = No
Y = Yes
ACO-OB-DRF-FL Alpha 1 AR01.1 AR952
Open Balance This field specifies whether to include
Includes Draft Fl or not items covered by Bills of
Exchange in the open balances. If Yes,
open items covered by bills of exchange
are deducted from the total balance due.
Y = Include BOE items
N = Do not include BOE items
ACO-REMIT-CNTL Alpha 1 AR01.1 AR952
Remittance Control Specifies whether use the remittance
control feature to create BOE
remittances that contain all the BOE
presented for cashing to a bank for a
single day.
ACO-INT-BY-DATE-FL Alpha 1 AR01.1
Interest Rate by Interest Charges By Date Flag. If
Date selected, and interest finance rates
change several times between the due
date and the late paid date, use each
rate in effect between the due date
and the late paid date, as defined in
AR07.2 (Finance Charge Rates).
Y = Yes
N = No
ACO-VAT-RPTG-RQD Alpha 1 AR01.1
VAT Reporting Indicates whether VAT reporting is
Required required for the AR company.
ACO-DISC-TAX-RCV Alpha 1 AR01.1
Tax Recovery on Indicates whether the amount of discount
Discount attributable to tax can be subtracted
from the amount of tax that is due the
government.
Y = Yes recover tax on discount
N = Do not recover tax on discount
ACO-COUNTRY-CODE Alpha 2 AR01.1
Country Code The country code. Required for VAT and
Intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
ACO-REGION Alpha 2 AR01.1
Region The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
ACO-NOTC Alpha 2
Nature of The Nature Of Transaction Code. This
Transaction Code code must be defined in IN07.1 (NOTC
Maintenance).
ACO-DUN-CYCLE-ID Numeric 6 AR01.1 AR140
Dunning Cycle ID Last Dunning Letter Cycle ID. Gets AR952
incremented by 1 when you run AR140
(Dunning Letter Selection). You can
view the last dunning cycle ID on AR01.1
(Company).
ACO-DUN-CYCLE-STAT Alpha 1 AR140 AR141
Dunning Cycle Status The dunning cycle status. AR145
1 = Selected (after running AR140)
2 = Printed (after running AR141)
3 = Dunning History Produced
4 = Cycle Complete (after AR145)
ACO-LATE-CH-RND-FL Alpha 1 AR01.1
Late Charge Interest by date charges rounding
Rounding Flag preference. If set to "Y", any
resulting interest charge invoices will
be rounded to the nearest currency unit.
Y = Yes
N = No
ARCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACOSET1 COMPANY This is the primary path used to access AC115 AC15.2
company records. AC450 AR01.1
AR02.1 AR03.1
AR03.2 AR04.1
AR06.1 AR06.2
AR06.3 AR06.4
AR08.1 AR08.2
AR09.4 AR10.1
AR10.2 AR10.3
AR100 AR105
AR11.1 AR110
AR115 AR12.1
AR12.2 AR124
AR13.1 AR13.2
AR130 AR131
...
ACOSET2 CUST-GROUP This path is used to access company AR00.1 AR01.1
COMPANY records by customer group. AR09.1 AR100
AR105 AR110
AR115 AR200
AR232 AR235
AR25.1 AR250
AR260 AR261
AR292 AR30.1
AR30.2 AR30.3
AR30.4 AR30.6
AR50.1 AR505
DT160 DT170
DT270
ARCOMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP -> ACG-CUST-GROUP
ARCOMP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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-TRANS-NBR
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
Reverse REVERSE Delete Cascades
ACO-COMPANY -> RVH-COMPANY
RVH-CUSTOMER
RVH-TRANS-TYPE
RVH-TRANS-NBR
RVH-BATCH-NBR
RVH-PAYMENT-SEQ
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
|