|
|
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
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
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 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 AR120
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 AR195 AR196 AR197 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 AR237
AR238 AR239 AR24.1 AR242 AR245 AR25.1
AR25.2 AR250 AR251 AR252 AR253 AR255
AR256 AR257 AR258 AR264 AR265 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 AR296
AR300 AR301 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 AR38.1 AR38.2 AR38.3
AR38.4 AR38.5 AR39.1 AR39.2 AR39.3 AR39.4
AR45.1 AR46.1 AR48.1 AR48.2 AR48.3 AR48.4
AR50.1 AR501 AR504 AR506 AR507 AR515
AR520 AR525 AR53.1 AR55.1 AR550 AR58.1
AR58.2 AR70.1 AR70.2 AR72.1 AR72.2 AR74.1
AR75.1 AR80.1 AR80.2 AR800 AR90.1 AR90.2
AR95.1 AR96.1 AR99.6 BL00.1 BL01.1 BL02.1
BL04.1 BL05.1 BL10.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 BL98.1 BR00.1 BR00.2 BR02.3
BR10.1 BR10.9 BR11.1 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 BR48.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 DT170
DT181 DT185 DT190 DT220 DT270 DT280
DT42.1 DT52.1 DT90.1 DT90.3 DT95.1 GL286
GL287 IC02.1 ICLM.1 MX123 MX500 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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 POI3.1
POID.1 POII.1 POIJ.1 PW110 PW550 RQ10.1
RQ10.2 IN20.1 TX100 TX101 TX130 TX140
TX226 TX301 TX40.1 WH110 WH120 WH130
WH132 WH190 WH20.1 WH20.2 WH20.7 WH21.2
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 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 AR00.1
AR200 AR260 AR261 AR505
UPDATED BY
AR01.1 AR115 AR130 AR137 AR140 AR141
AR145 AR190 AR20.1 AR30.1 AR30.8 AR32.1
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 The number representing an AR company.
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 General Ledger unless you override
it in Accounts Receivable.
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 AR32.1
chargebacks. The chargebacks will be in AR33.3 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 AR190 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 (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
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 if payment remittance will be
edited against existing transactions.
N = No
Y = Yes
ACO-SUM-LINE Alpha 1 AR01.1
Element: Summary Line Determines whether to display multi line
open items in detail or summary.
N = No
Y = Yes
ACO-THIRD-PARTY Alpha 1 AR01.1
Element: Third Party 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
ACO-INT-BY-DATE-FL Alpha 1 AR01.1
Element: Int By Date FlIndicates 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.
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 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
ACO-COUNTRY-CODE Alpha 2 AR01.1
Element: Country Code The country code representing the
country of the company.
Y = Yes recover tax on discount
N = Do not recover tax on discount
ACO-REGION Alpha 2 AR01.1
Element: Region 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: Ven Class A user-defined code representing a
subset of vendors within a vendor group.
Used in AR48 AR to AP Interface.
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: Due Days The 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: Gl Days The 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 Indicates whether customer changes will
be tracked at the company level.
Valid values are:
N = No changes audited
Y = Changes audited
ACO-NA-TRAN-FL Alpha 1 AR01.1
Element: Flag 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
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.
ACO-CREDIT-CB-PRFX Alpha 2 AR01.1
Element: Credit Cb Prfx
ACO-CREDIT-CB-NBR Numeric 7 AR01.1 AR190
Element: Credit Cb Nbr
ACO-INTRF-DST-CREA Alpha 1 AR01.1
Element: Flag 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
ACO-INTRF-DST-SUM Alpha 1 AR01.1
Element: Flag Indicates whether interface transactions
will create historical AR Code based
distribution records in detail or in
summary.
" " = Space
N = No
Y = Yes
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 AR01.1
AR02.1 AR03.1
AR03.2 AR04.1
AR06.1 AR06.2
AR06.3 AR06.4
AR08.1 AR08.2
...
ACOSET2 CUST-GROUP AR00.1 AR01.1
COMPANY AR09.1 AR100
AR105 AR110
AR115 AR130
AR180 AR200
AR232 AR235
AR237 AR239
AR25.1 AR250
AR260 AR261
AR292 AR30.1
AR30.6 AR301
AR32.1 AR33.1
AR34.1 AR50.1
AR505 AR80.1
AR80.2 DT170
...
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
|
