|
|
ARCOMP FILE
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
that company. Prior to adding a company to this file, the company must be a
valid company in the Lawson General Ledger or General Ledger Interface system.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR02.1 AR03.1 AR03.2 AR04.1
AR06.1 AR06.2 AR06.3 AR06.4 AR08.1 AR08.2
AR09.1 AR09.4 AR10.1 AR10.2 AR10.3 AR100
AR105 AR11.1 AR110 AR112 AR12.1 AR12.2
AR124 AR129 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 AR170 AR18.1
AR180 AR19.4 AR19.5 AR19.6 AR19.7 AR191
AR194 AR196 AR198 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
AR219 AR220 AR222 AR223 AR227 AR228
AR229 AR23.1 AR23.3 AR23.4 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 AR285 AR286 AR287
AR29.1 AR29.2 AR29.3 AR290 AR291 AR292
AR293 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 AR48.1
AR48.2 AR48.3 AR48.4 AR50.1 AR501 AR504
AR506 AR507 AR515 AR520 AR53.1 AR550
AR58.1 AR58.2 AR70.1 AR70.2 AR72.1 AR72.2
AR74.1 AR75.1 AR80.1 AR80.2 AR90.1 AR90.2
AR95.1 BL00.1 BL01.1 BL02.1 BL04.1 BL05.1
BL120 BL121 BL122 BL123 BL125 BL13.1
BL130 BL20.1 BL20.3 BL20.6 BL200 BL201
BL202 BL204 BL21.2 BL21.5 BL217 BL220
BL231 BL232 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 BL530 BL546 BL80.1
BL80.3 BL802 BL81.1 BL82.1 BL820 BL85.1
BL85.2 BL85.3 BL90.1 BL91.1 BL92.1 BR00.1
BR00.2 BR02.3 BR10.1 BR11.1 BR120 BR121
BR122 BR140 BR145 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.1 BR21.2 BR210 BR211 BR216 BR217
BR220 BR245 BR300 BR400 BR420 BR45.1
BR450 BR46.1 BR46.2 BR46.4 BR521 BRIP.1
CB191 DT170 DT181 DT185 DT190 DT220
DT270 DT280 DT42.1 DT52.1 DT90.1 DT90.3
DT95.1 GL286 GL287 IC02.1 IC28.1 IC531
MA180 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.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 OE111 OE112
OE113 OE114 OE116 OE129 OE13.1 OE13.2
OE13.3 OE13.5 OE13.6 OE130 OE14.3 OE14.4
OE16.1 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 OE530
OE54.1 OE60.1 OE80.1 OE80.2 OE81.1 OE81.2
OE810 OE830 OE85.1 OE85.3 OE86.1 OE90.1
OE90.2 PBIP.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 PR197
RQ10.1 RQ10.2 SA03.1 SA100 SA252 SA254
SA256 SA261 SA271 SA281 SA291 SA300
SA80.2 SA90.2 SACU.1 SALD.1 SATE.1 IN20.1
TX100 TX101 TX130 TX140 TX301 TX40.1
WH110 WH120 WH130 WH132 WH190 WH20.1
WH20.2 WH20.7 WH21.2 WH224 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO235 WO30.1 WO35.1 AR00.1 AR200
AR260 AR261 AR505
UPDATED BY
AR01.1 AR115 AR130 AR137 AR140 AR141
AR145 AR190 AR20.1 AR30.1 AR30.8 AR33.3
AR34.1 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR502 AR503 AR560 AR570 AR575
AR580 AR82.1 ARLL.1 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
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ACO-CUST-GROUP Alpha 5 AR01.1 AR35.1
Element: Customer GroupCustomer group assigned to this TX130
company. Only customers initially
defined with this customer group are
eligible to be customers of this
company.
ACO-NAME Alpha 30 (Lower Case) AR01.1
Element: Company Name The name or description of the accounts
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
Element: Address 1 First line of address information.
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
Element: Address 2 Second line of address information.
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
Element: Address 3 Third line of address information.
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
Element: Address 4 Fourth line of address information.
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
Element: City City Name. Defaults from the general
ledger or interface company address and
will be maintainable once it is
initially added.
ACO-STATE Alpha 2 AR01.1
Element: State or ProviState or province abbreviation.
Defaults from the general ledger or
interface company address, and will be
maintainable once it is initially added.
ACO-ZIP Alpha 10 AR01.1
Element: Postal Code Postal code. Defaults from the general
ledger or interface company address, and
will be maintainable once it is
initially added.
ACO-COUNTRY Alpha 30 (Lower Case) AR01.1
Element: Country or othCountry name. Defaults from the general
ledger or interface company address, and
will be maintainable once it is
initially added.
ACO-COUNTY Alpha 25 (Lower Case) AR01.1
Element: County County. Defaults from the general ledger
or interface company address, and will
be maintainable once it is initially
added.
ACO-PHONE-NMBR Alpha 15 AR01.1
Element: Telephone NumbThe company phone number.
ACO-FAX-NMBR Alpha 15 AR01.1
Element: Fax Number The company fax number.
ACO-CHRG-BACK-NBR Numeric 7 AR01.1 AR130
Element: Chargeback NumThis field will contain the last used AR190 AR30.1
transaction number for created AR30.8 AR33.3
chargebacks. The chargebacks will be in AR34.1
the form of debit memos in the open item
file. This number will be prefixed by
"CB-".
ACO-INV-BTCH-FL Alpha 1 AR01.1
Auto Number Trans Specifies whether the manual invoice
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
Batch Number manual invoice entry.
ACO-INV-BTCH-TL Alpha 1 AR01.1
Trans Batch Control This option allows system batch totals
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
Auto Number Cash This option will specify whether or not
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 ARLL.1
Note: This number sequence will also be CB06.2 DT150
used for lock box interfaced cash. 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
Cash Batch Control This cash option allows system batch
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
Element: Summary Batch The last system-assigned batch number AR82.1
used when creating chargeback records.
ACO-LAST-RTM-NBR Numeric 7 AR01.1 AR82.1
Element: Last RTM NumbeReturn-to-maker debit memo number. This DT92.1
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.
ACO-LAST-CONV-BTCH Numeric 3 AR503
Last Converted The last payment batch number the
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
Element: Risk Code The default risk code that will be
assigned to all new customers being
added for this company.
ACO-OFFSET-FL Alpha 1 AR01.1
Automatic Specifies if application will occur for
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
Element: AR Code The default accounts receivable code
for the company level.
ACO-NOT-APPLD-CD Alpha 4 AR01.1
Received Not The default received not applied code
Applied Code at the company level.
ACO-PRE-PAY-CODE Alpha 4 AR01.1
Element: Prepayment CodPrepayment 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.
ACO-CUST-RETEN Numeric 3 AR01.1
Last Customer The number of months that must elapse,
Activity after the last customer activity date,
before a customer can be automatically
deleted.
ACO-AGE-CREDITS Alpha 1 AR01.1
Element: Age Credits 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
ACO-AGE-PYMNT Alpha 1 AR01.1
Element: Age Payment 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
ACO-AGE-DISPUTES Alpha 1 AR01.1
Element: Age Disputes Specifies how disputed transactions
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
Element: Age Type Default aging method respecting either
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
Element: Age Current 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).
ACO-AGE-PERIODS Numeric 3 Occurs 4 Times AR01.1
Element: Age Periods 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.
ACO-DISPUTES-FIN Alpha 1 AR01.1
Element: Finance DisputSpecifies 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
ACO-OI-DISP-SEQ Alpha 1 AR01.1
Element: Oi Disp Seq 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
ACO-AUDIT-APP-FL Alpha 1 AR01.1
Cash Application Indicates if the operator code field is
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
Memo/Invoice Indicates if operator code is required
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
Element: Application ReIndicates 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
ACO-DISC-GRACE-PD Numeric 2 AR01.1
Discount Grade Number of grace days added to discount
Period date to allow automatic discount during
cash application.
ACO-LATE-PAY-FL Alpha 1 AR01.1
Late Payment & Indicates what type of charges will be
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
Finance Charge Determines how finance charges will be
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
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
Element: Finance ChargeFinance charge code. This code must be
predefined and will contain a monthly
finance charge percentage rates.
ACO-FIN-GRAC-DAYS Numeric 2 AR01.1
Finance Charge The number of grace days added to a
Grace Days transaction's due date before finance
charges will be assessed.
ACO-FIN-MIN-CHRG Signed 7.2 AR01.1
Minimum Finance Override minimum finance charge amount
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
Element: Fin Doc Prnt 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
ACO-FIN-GL-CODE Alpha 4 AR01.1
Element: Finance GL CodThis 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.
ACO-CURRENCY-CD Alpha 5 AR01.1
Element: Currency Code 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.
ACO-MULTI-CURR-FL Alpha 1 AR01.1
Element: Multi CurrencyDetermines if transactions in
currencies differing from company base
currency will be allowed.
N = Not Multi Currency
Y = Multi Currency
ACO-RATE-OVR-FL Alpha 1 AR01.1
Conversion Rate Determines whether or not user will be
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
Invoice Currency Indicates whether users will be able to
Override override the default customer invoice
currency code when entering manual
invoices.
N = No
Y = Yes
ACO-VERIFY-GLDATE Alpha 1 AR01.1
Element: Verify GL DateEstablishes 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
ACO-DFLT-APP-DATE Alpha 1 AR01.1
Default Application Defines what default general ledger
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
Element: Hold Code 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.
ACO-OVER-APP-FL Alpha 1 AR01.1
Over Application Determines whether users should be able
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
Discount Display Determines if past-due discount amounts
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
Update Trans Date / Determines if transactions will be
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
Element: Incomplete ComIndicates that the AR company is only
partially set up.
ACO-BASE-ND Numeric 1 AR01.1
Base Number of The number of decimal positions defined
Decimals for the company base currency.
ACO-DISPLAY-DATE Alpha 1 AR01.1
Element: Display Date 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)
ACO-TRANS-SEQUENCE Alpha 1 AR01.1
Element: Transaction SeTransaction 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
ACO-BANK-RISK-OPT Alpha 1 AR01.1
Element: Bank Risk OptiBank 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
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
Element: BOE AcceptanceBill 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
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
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
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 ARLL.1
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 DT160
Element: Remittance NumRemittance number. This will be used if DT161 DT165
the company is processing bills of DT166 DT180
exchange. If so, this will contain the DT60.1 DT60.2
last remittance number assigned for the DT70.1 DT70.3
company. DT80.1
ACO-REASSIGN-NBR Numeric 7 AR01.1 AR44.3
Element: Reassignment NReassignment 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
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
Element: Deposit Code Default deposit bank code. Must be a
valid bank service transaction code in
the Lawson Cash Ledger system.
ACO-RTM-INST-CODE Alpha 3 AR01.1
Element: RTM Payment CoDefault return-to-maker payment code.
Must be a valid bank service transaction
code in the Lawson Cash Ledger system.
ACO-ADJ-INST-CODE Alpha 3 AR01.1
Additional Bank Default additional bank charges code.
Charges Must be a valid bank service transaction
code in the Lawson Cash Ledger system.
ACO-EFT-INST-CODE Alpha 3 AR01.1
Element: Deposit PaymenThe EFT deposit payment code.
ACO-EFTPAY-INST-CD Alpha 3 AR01.1
Element: Credit PaymentThe EFT credit payment code.
ACO-DSC-REMIT-INST Alpha 3 AR01.1
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
Element: Payment GL IntDetail 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.
ACO-DTL-APPL Alpha 1 AR01.1
Application GL Detail application accrual general
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
Finance Charge GL Detail finance charge accrual general
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
Minimum Finance Determines if a minimum finance charge
Charge will be assessed. Valid values are
Y = Use minimum amount
N = Minimum amount not used
ACO-FIN-CYCLE Alpha 2 AR01.1
Finance Charge Finance charge cycle code.
Cycle Code
ACO-HIST-PER Numeric 2 AR01.1
Element: History PeriodThe number of periods until the status
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).
01
12
ACO-CASH-CODE Alpha 4 AR01.1
Element: 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
Element: Credit Cash CoThe credit cash code. Must be a valid
cash code in the Lawson Cash Ledger
system.
ACO-ACH-COMP-ID Alpha 10 AR01.1
Element: EFT Company IDEFT 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
Element: Currency DisplYou can choose to display transaction
amounts 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
Element: Edit RemittancDetermines the remittance editing logic.
N = No
Y = Yes
ACO-SUM-LINE Alpha 1 AR01.1
Element: Summary Line Determines whether to display open items
in detail or summary.
N = No
Y = Yes
ACO-THIRD-PARTY Alpha 1 AR01.1
Element: Third Party N = No third party payment
Y = Third party payment allowed
ACO-INT-BY-DATE-FL Alpha 1 AR01.1
Element: Int By Date FlInterest Charges By Date Flag. If
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, instead of using just the current
rate.
ACO-DUN-CYCLE-ID Numeric 6 AR01.1 AR140
Element: Dun Cycle Id 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).
ACO-DUN-CYCLE-STAT Alpha 1 AR140 AR141
Element: Dun Cycle StatThe dunning cycle status. Values are: AR145
1 = Selected (after running AR140)
2 = Printed (after running AR141)
3 = Dunning History Produced
4 = Cycle complete (after running AR145)
ACO-OB-DRF-FL Alpha 1 AR01.1
Element: Ob Drf Fl 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
ACO-REMIT-CNTL Alpha 1 AR01.1
Element: Remit Cntl Y = Process Draft on Remittance
N = Do Not process Draft on remitt
ACO-DISC-TAX-RCV Alpha 1 AR01.1
Element: All Flag
ACO-COUNTRY-CODE Alpha 2 AR01.1
Element: Country Code Indicate whether the amount of 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-REGION Alpha 2 AR01.1
Element: Region Code The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
ACO-LATE-CH-RND-FL Alpha 1 AR01.1
Element: Late Ch Rnd FlInterest by date charges rounding
preference. If set to "Y", any
resulting interest charge invoices will
be rounded to the nearest currency unit.
ACO-VEN-CLASS Alpha 3 AR01.1
Element: Vendor Class A user-defined code representing a
subset of vendors within a vendor group.
ACO-VEND-AR-TO-AP Alpha 1 AR01.1
Element: Vend Ar To Ap 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
ACO-EFT-PROCESS Alpha 1 AR01.1
Element: Eft Process Indicates whether this company will
process EFt tranascations. Valid values
are:
N = No EFT processing
Y = EFT processing
ACO-CALENDAR Alpha 15 AR01.1
Element: Calendar The calendar used for EFT processing.
The calendar must be defined in the
Universe calendar definition program.
ACO-DUE-DAYS Numeric 3 AR01.1
Element: Vendor Due DayThe number of days used to calculate the
ending due date range in EFT processing.
ACO-DUE-TYPE Alpha 1 AR01.1
Element: Due Type 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
ACO-GL-DAYS Numeric 3 AR01.1
Element: General LedgerThe number of days used to calculate the
ending GL date range.
ACO-GL-TYPE Alpha 1 AR01.1
Element: Gl Type The type of days used to calculate the
ending GL date range. Valid values are:
A = Actual Days
M = Marked Days
ACO-DEPOSIT-DAYS Numeric 3 AR01.1
Element: Deposit Days The number of days used to calculate the
end deposit days date range.
ACO-DEPOSIT-TYPE Alpha 1 AR01.1
Element: Deposit Type The type of days used to calculate the
ending deposit days date reange. Valid
values are:
A = Actual Days
M = Marked Days
ACO-CUST-AUDIT Alpha 1 AR01.1
Element: Cust Audit
ACO-NA-TRAN-FL Alpha 1 AR01.1
Element: Flag
ACO-PROCURE-GROUP Alpha 4 AR01.1
Element: Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
ARCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACOSET1 COMPANY This is the primary path used to access AP125 AP126
company records. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR01.1 AR02.1
AR03.1 AR03.2
AR04.1 AR06.1
AR06.2 AR06.3
AR06.4 AR08.1
AR08.2 AR09.1
AR09.4 AR10.1
AR10.2 AR10.3
AR100 AR105
AR11.1 AR110
AR112 AR115
...
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 AR130
AR180 AR200
AR232 AR235
AR25.1 AR250
AR260 AR261
AR292 AR30.1
AR30.6 AR33.1
AR34.1 AR34.2
AR50.1 AR505
AR80.1 AR80.2
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-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
|
