ARCUSTOMER FILE
AR Company Customer
AR Company Customer
REFERENCED BY
AC115 AC15.2 AC450 AR01.1 AR09.1 AR100
AR105 AR11.1 AR110 AR132 AR136 AR140
AR155 AR160 AR191 AR196 AR209 AR210
AR211 AR217 AR222 AR227 AR229 AR230
AR232 AR233 AR234 AR235 AR245 AR25.1
AR250 AR251 AR253 AR255 AR258 AR260
AR261 AR274 AR275 AR286 AR290 AR291
AR292 AR294 AR50.1 AR504 AR53.1 AR58.1
AR72.1 AR73.1 AR74.1 AR75.1 AR80.1 AR80.2
AR90.1 AR954 AR976 BL04.1 BL120 BL121
BL122 BL123 BL130 BL20.1 BL20.3 BL202
BL204 BL21.2 BL21.3 BL21.4 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
BL520 BL546 BL80.1 BL80.3 BL802 BL81.1
BL820 BL85.1 BL85.2 BL90.1 BL902 BL940
CB06.2 DT161 DT190 DT270 DT280 DT42.1
DT95.1 IC531 IN120 IN20.1 OE112 OE130
OE230 OE254 OE260 OE270 OE271 OE272
OE284 OE285 OE286 OE290 OE291 OE292
OE293 OE294 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE330 OE53.1
OE54.1 OE60.1 OE80.1 OE80.2 OE81.1 OE81.2
OE830 OE85.1 OE90.1 OE90.2 OE950 PBIP.1
SA03.1 SA100 SA252 SA254 SA256 SA261
SA271 SA281 SA291 SA300 SA80.2 SA90.2
TX125 TX40.1 WH110 WH120 WH21.2 WH224
AR04.1 AR06.1 AR271
UPDATED BY
AR10.1 AR10.2 AR115 AR12.1 AR12.2 AR124
AR13.1 AR13.2 AR130 AR131 AR135 AR137
AR141 AR145 AR150 AR161 AR17.1 AR17.2
AR170 AR180 AR190 AR194 AR199 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR28.1 AR29.1
AR29.2 AR29.3 AR30.1 AR30.2 AR30.3 AR30.4
AR30.8 AR301 AR31.6 AR35.1 AR35.2 AR37.1
AR37.2 AR37.3 AR37.4 AR37.5 AR37.6 AR37.7
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR45.1 AR501 AR502 AR503 AR505 AR506
AR550 AR560 AR570 AR575 AR580 AR70.2
AR700 AR82.1 AR951 AR973 BL02.1 BL92.1
CB191 DT150 DT155 DT160 DT165 DT166
DT170 DT180 DT181 DT30.1 DT30.2 DT40.1
DT45.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT85.1 DT85.2 DT90.1 DT92.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
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810
OE920 TX140 WH130 WH132 WH190 WH20.7
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACM-COMPANY Numeric 4 AR10.1 AR501
Company The accounts receivable company AR550 AR951
assigned to the customer. AR973 BL02.1
DT150
ACM-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Customer The unique identifier assigned to the AR550 AR951
customer. AR973 BL02.1
DT150
ACM-ACTIVE-STATUS Alpha 1 AR10.1 AR501
Active Status Indicates the status of the customer. AR550 AR951
Valid values are: AR973 BL02.1
A = Active
I = Inactive
D = Set for deletion
ACM-NAT-FLAG Alpha 1 AR10.1 AR12.1
National Account Indicates whether the customer is a AR12.2 AR301
Flag national account customer. If a customer AR501 AR550
is a national account customer, it AR951 AR973
cannot be an invoiced customer to BL02.1
another national account. Valid values
are:
I = Invoiced customer
N = National account
Blank = Not part of a national account
ACM-SEARCH-NAME Alpha 30 AR10.1 AR501
Search Name The search name for the customer. AR550 AR951
Reports can be sequenced using this AR973 BL02.1
field. If left blank when adding the
customer, the search name defined in
AR09.1 (Customer Group Address)
defaults.
ACM-HOLD-CODE Alpha 4 AR10.1 AR501
Hold Code Indicates whether a customer is on AR550 AR70.2
hold. AR951 AR973
BL02.1
ACM-CONTACT Alpha 20 AR10.1 AR501
Primary Contact Primary contact name for this customer. AR550 AR951
AR973 BL02.1
ACM-INT-PREFIX Alpha 6 AR10.1 AR501
International The international telephone number AR550 AR951
Telephone Prefix prefix. AR973 BL02.1
ACM-PHONE-NMBR Alpha 15 AR10.1 AR501
Telephone Number The telephone number for this customer. AR550 AR951
AR973 BL02.1
ACM-PHONE-EXT Alpha 5 AR10.1 AR501
Telephone Extension The telephone extension number for the AR550 AR951
customer. AR973 BL02.1
ACM-TELEX-NBR Alpha 15 AR10.1 AR501
Telex Number The telex number for the customer. AR550 AR951
AR973 BL02.1
ACM-EDI-NBR Alpha 15 AR10.1 AR501
EDI Number The electronic data interchange (EDI) AR550 AR951
number assigned to the customer. Used by AR973 BL02.1
the Lawson Order Entry system or
external order processing systems.
ACM-ALT-EDI-NBR Alpha 95 AR10.1 AR501
Alternate EDI Number This is a free-form field to AR550 AR973
accommodate an alternate EDI number or
address.
ACM-ALT-EDI-TYPE Alpha 5 AR10.1 AR501
Alternate EDI Type Indicates the type of the alternate EDI AR550 AR973
number.
ACM-FAX-NMBR Alpha 15 AR10.1 AR501
Fax Number The customer's fax number. AR550 AR951
AR973 BL02.1
ACM-FAX-EXT Alpha 5 AR10.1 AR501
Fax Extension The customer's fax extension. AR550 AR951
AR973 BL02.1
ACM-START-DATE Numeric 8 (yyyymmdd) AR10.1 AR501
Start Date The date the customer first began doing AR550 AR951
business with the company. If left blank AR973 BL02.1
when adding a customer, the system date
defaults.
ACM-CREDIT-ANLYST Alpha 4 AR10.1 AR501
Credit Analyst The credit analyst code assigned to AR550 AR951
this customer. AR973 BL02.1
ACM-CURRENCY-CD Alpha 5 AR10.1 AR501
Currency Code The default currency in which the AR550 AR951
customer will be invoiced. If the AR973 BL02.1
company has Yes selected the Currency
Override field in AR01.2 (Company
Options 1), this default currency can be
overridden during invoice entry. If the
company has No selected, the customer
can be invoiced in this default currency
only.
ACM-SALESMAN Numeric 4 AR10.1 AR501
Sales Rep The primary sales representative for AR550 AR951
this customer. This salesrep is used on AR973 BL02.1
various programs for selection and
sorting.
ACM-RISK-CD Alpha 1 AR10.1 AR501
Risk Code The risk code is used for risk AR550 AR951
analysis. Defaults from the company. AR973 BL02.1
ACM-DEFAULT-CODE Alpha 5 AR10.1 AR501
Default Code The customer default code is used to AR550 AR951
default values and options into the AR973 BL02.1
customer record when the customer is
added into the system. This field is
required and must be a valid default
code defined in AR08 (Customer
Defaults).
ACM-MAJ-CLASS Alpha 4 AR10.1 AR501
Major Class The major class assigned to this AR550 AR951
customer. AR973 BL02.1
ACM-MIN-CLASS Alpha 4 AR10.1 AR501
Minor Class The minor class assigned to this AR550 AR951
customer. AR973 BL02.1
ACM-CURR-BAL Signed 15.2 AR115 AR12.1
Current Balance The current balance for the customer. AR12.2 AR124
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR29.2
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR505
AR560 AR570
AR575 AR580
AR82.1 AR951
AR973 CB191
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
...
ACM-DRAFT-BAL Signed 15.2 AR115 AR12.1
Bill of Exchange The bill of exchange balance for this AR12.2 AR13.1
Balance customer. AR13.2 AR130
AR131 AR135
AR137 AR180
AR190 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR505 AR560
AR82.1 AR951
AR973 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
...
ACM-OPEN-ORDS Signed 15.2 AR501 AR502
Open Order Total The total amount of orders that have AR560 AR951
been entered into an external order AR973 BL92.1
processing system but have not yet been OE10.1 OE10.2
invoiced. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH130 WH132
WH190 WH20.7
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
ACM-ORDER-LIM Signed 15.0 AR10.1 AR501
Open Order Limit The limit for the total amount of open AR550 AR951
orders allowed for this customer. Zero AR973 BL02.1
means the order amount is not limited.
This value is maintained in the Lawson
Accounts Receivable system and is used
by external order processing systems.
ACM-CREDIT-LIM Signed 15.0 AR10.1 AR501
Credit Limit Total amount of credit extended to a AR550 AR951
customer. Zero means unlimited credit is AR973 BL02.1
extended to this customer. This value is
maintained in the Lawson Accounts
Receivable system but is meant to be
edited by order entry systems.
For example: An order may be placed on
hold if the amount of the order will
cause the customer balance to exceed the
credit limit defined in this field.
ACM-CREDIT-LIM-DAT Numeric 8 (yyyymmdd) AR10.1 AR501
Credit Limit Date The date the credit limit was defined AR550 AR70.2
or last reviewed. AR951 AR973
BL02.1
ACM-CREDIT-REVDAYS Signed 3.0 AR10.1 AR501
Credit Review Days The number of days between the credit AR550 AR951
limit reviews for the customer. AR973 BL02.1
ACM-LAST-PMT-AMT Signed 15.2 AR115 AR124
Last Payment Amount The amount of the last payment made by AR20.1 AR21.1
this customer. AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR30.2 AR30.4
AR501 AR503
AR570 AR575
AR580 AR951
AR973 CB191
DT170 DT180
DT181
ACM-LAST-PMT-DATE Numeric 8 (yyyymmdd) AR115 AR124
Last Payment Date The date of the last payment made by AR20.1 AR21.1
the customer. AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR30.2 AR30.4
AR501 AR503
AR570 AR575
AR580 AR951
AR973 CB191
DT170 DT180
DT181
ACM-LAST-INV-DATE Numeric 8 (yyyymmdd) AR115 AR13.1
Last Invoice Date The date of the last invoice for this AR13.2 AR130
customer. AR131 AR135
AR137 AR180
AR190 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR501
AR502 AR560
AR82.1 AR951
AR973 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ACM-LAST-STA-DATE Numeric 8 (yyyymmdd) AR150 AR501
Last Statement Date The date of the last statement for this AR951 AR973
customer.
ACM-LAST-STA-BAL Signed 15.2 AR150 AR501
Last Statement The customer's balance on their last AR951 AR973
Balance statement.
ACM-REVIEW-DATE Numeric 8 (yyyymmdd) AR17.1 AR501
Review Date The last date the customer was defined AR70.2 AR951
for review. AR17 (Comments) and AR70 AR973 BL02.1
(Analyst Customer Review) are used to
define this date. AR170 (Customer Review
Selection) selects the customer when
this date is reached.
ACM-REVIEW-CODE Alpha 1 AR17.1 AR170
Review Code Indicates the status of the customer's AR501 AR70.2
review record. Valid values are: AR951 AR973
BL02.1
O = Open
R = Reviewed
ACM-HIGH-BAL Signed 15.0 Occurs 13 Times AR115 AR13.1
Highest Balance The highest balance for the customer AR13.2 AR130
for the period. AR131 AR135
AR137 AR180
AR190 AR199
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR501 AR502
AR560 AR82.1
AR951 AR973
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
...
ACM-PER-RTMS Signed 3.0 Occurs 13 Times AR115 AR13.1
Period RTMs Period Return-to-Maker debit memos. The AR13.2 AR130
number of payments that have been AR131 AR135
returned to the customer for the period. AR137 AR180
AR190 AR199
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR501 AR502
AR560 AR82.1
AR951 AR973
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
...
ACM-PAID-PRMPT Signed 5.0 Occurs 12 Times AR190 AR194
Paid Prompt The number of invoices that were paid AR199 AR501
in full within the due date of the AR951 AR973
invoice (incorporating grace days).
Invoices cleared by chargebacks are not
considered.
ACM-INV-PAID Signed 5.0 Occurs 12 Times AR190 AR194
Paid Invoices A count of invoices fully paid within AR199 AR501
the period. This will be used in the AR951 AR973
Invoice Payment Average (IPA) and Days
Beyond Terms (DBT) calculations for each
customer.
ACM-COLLECT-DAYS Signed 3.0 Occurs 11 Times AR194 AR501
Collect Days A collection ratio of days to collect AR951 AR973
those invoices that have been fully paid
in a specific period. It will include
invoices and only debit memos generated
from chargebacks. This will be a
weighted calculation based on the amount
of invoice.
ACM-CURR-CASH Signed 15.2 AR190 AR194
Current Cash The cash paid amount from fully paid AR501 AR951
transactions. At the end of a current AR973
period, it will be used to calculate the
ratio for the Collect Days field.
ACM-CURR-CSH-DAYS Signed 15.2 AR190 AR194
Current Cash Days The Flow of Funds Cash Days calculated AR501 AR951
value (paid amount multiplied by the AR973
number of days to fully pay) for the
current period.
ACM-YTD-CASH Signed 15.2 AR190 AR199
Year-to-Date Cash The year-to-date total of cash for AR501 AR951
fully paid transactions. AR973
ACM-YTD-CSH-DAYS Signed 15.2 AR190 AR199
Year-to-Date Cash The year to date calculation of cash AR501 AR951
Days paid and applied to an open item times AR973
the number of days it took to fully pay
the transactions.
ACM-YEAR-2-DAYS Signed 3.0 AR199 AR501
Previous Year IPA The weighted invoice payment average AR951 AR973
for the year previous to the totals
being tallied in "COLLECT DAYS" period
buckets.
ACM-STATIC-CUR Signed 15.2 AR194 AR501
Current Static The static current portion of a AR951 AR973
Balance customer's balance as of the last
running of AR194 (Audit Summary).
ACM-AGING Signed 15.2 Occurs 5 Times AR194 AR501
Aging These aging buckets carry the static AR951 AR973
past-due amounts in each aging period
for a given customer. These fields are
updated by AR194 (Audit Summary).
ACM-LAST-CMT-SEQ Numeric 4 AR141 AR161
Last Comment Sequence number of the last comment AR17.1 AR17.2
Sequence Number added for a customer. AR29.1 AR29.3
AR501 AR503
AR506 AR560
AR951 AR973
ACM-DISP-NBR Signed 3.0 AR190 AR45.1
Disputed Items The number of open items currently in AR506 AR951
dispute. AR973
ACM-DISP-AMT Signed 15.2 AR190 AR45.1
Disputed Amount The total amount in dispute for this AR506 AR951
customer. AR973
ACM-PL-EXCL-FL Alpha 1 AR10.2 AR951
Process Level Indicates if the invoices being entered AR973
Restrictions on this customer's account should be
checked for inclusions or exclusions for
the specified process level. Valid
values are:
Blank = No process level restrictions
I = Process level restriction
ACM-AGE-DISPUTES Alpha 1 AR10.1 AR501
Age Disputes Specifies how disputed invoices will be AR550 AR951
aged. Valid values are: AR973 BL02.1
N = Not aged - aged in current column
Y = Aged respective to GL date
ACM-DISPUTES-FIN Alpha 1 AR10.1 AR501
Finance Disputes Specifies if disputed invoices are AR550 AR951
exempt from being assessed finance AR973 BL02.1
charges. Valid values are:
N = No; not subject to finance charges
Y = Yes; subject to finance charges
ACM-AUTO-APP-FL Alpha 1 AR10.1 AR501
Automatic Automatic cash application indicator. AR550 AR951
Application Valid values are: AR973 BL02.1
N = No; no automatic application
Y = Yes; allows automatic application
ACM-AUTO-DUNN-FL Alpha 1 AR10.1 AR501
Automatic Dunning Indicates whether or not automatic AR550 AR951
Letters selection for dunning letters will be AR973 BL02.1
allowed. Valid values are:
N = No; no automatic selection
Y = Yes; allow automatic selection
ACM-DISC-GRACE-PD Numeric 2 AR10.1 AR501
Discount Grace Grace days added to discount date to AR550 AR951
Period allow or disallow discount during cash AR973 BL02.1
application.
ACM-CR-VAR-PCT Numeric 3 AR10.1 AR501
Credit Variance Contains an optional override percent AR550 AR951
Percent that will be used in customer credit AR973 BL02.1
limit selections. If left blank,
selection will be based on report
parameter entered percentage. If the
field contains a percent, this will
override the report parameter.
ACM-MEMO-TERM Alpha 5 AR10.1 AR501
Memo Terms Memo terms code. Must be a valid net or AR550 AR951
prepayment type terms code defined in AR973 BL02.1
the Lawson Terms system.
ACM-CHRGBK-PRT-FL Alpha 1 AR10.1 AR501
Print Chargebacks Specifies whether chargebacks will be AR550 AR951
printed. Valid values are: AR973 BL02.1
N = No; don't print chargeback debit
memo
Y = Yes; print chargeback debit memos
ACM-OPEN-BAL-FWD Alpha 1 AR10.1 AR501
Open Item/Balance Processing of receivable records by AR550 AR951
Forward either open item or balance forward AR973 BL02.1
methods. Valid values are:
B = Balance forward processing
O = Open Item processing
ACM-STATEMENT-REQ Alpha 1 AR10.1 AR501
Statement Required Statement required option. If AR550 AR951
statements are required, the default AR973 BL02.1
selection criteria will include current,
past due and credit open items. Zero
balance statements will not be produced.
Individual statement options may
override this set of default criteria.
Valid values are:
N = No statements required
Y = Statements required
ACM-STMNT-CYCLE Alpha 2 AR10.1 AR501
Statement Cycle Used to group customers with like AR550 AR951
statement cycles for statement AR973 BL02.1
processing. The statement cycle code
will be assigned for balance forward
type customers via the first letter of
the company customer level search name.
ACM-LOCK-BOX Alpha 2 AR10.1 AR501
Lock Box The remit-to location of a lock box, AR550 AR951
used for payment receipts. If entered, AR973 BL02.1
it must be a valid lock box code. If
left blank, the company name and address
will be used for the remit-to address on
Accounts Receivable external forms. For
the Lawson Order Entry system, the
process level name and address for the
process level of the invoice will be
used if left blank.
ACM-ZERO-STMNT-FL Alpha 1 AR10.1 AR501
Zero Statements Zero balance statement option. AR550 AR951
Determines whether or not a customer AR973 BL02.1
will receive a statement when there is
no unapplied transactions and a balance
of zero. Valid values are:
N = No; don't produce zero statements
Y = Yes; produce zero statements
ACM-CRED-STMNT-FL Alpha 1 AR10.1 AR501
Credit Statements Credit balance statement option. AR550 AR951
Determines whether or not a customer AR973 BL02.1
should receive a statement if their
balance nets to a credit amount. Valid
values are:
N = No; don't produce credit statements
Y = Yes; produce credit statements
ACM-PAST-STMNT-FL Alpha 1 AR10.1 AR501
Past Due Statements Past due open items only statement AR550 AR951
option. If this option is Yes, only past AR973 BL02.1
due open items will print on the
customer's statement. Valid values are:
N = Do not produce only past-due
statements
Y = Produce only past-due statements
ACM-OVER-STMNT-FL Alpha 1 AR10.1 AR501
Over Credit Limit Over credit limit statement option. AR550 AR951
Statements If Yes is chosen, statements will only AR973 BL02.1
be printed for customers whose balances
exceed their credit limit. Valid values
are:
N = Do not produce only balance
exceeding credit limit statements
Y = Produce only balance exceeding
credit limit statements
ACM-MAX-AUTO-AMT Signed 15.2 Occurs 3 Times AR10.1 AR501
Max Automatic Write The maximum amount a payment may be AR550 AR951
Off Amount short of a particular invoice during AR973 BL02.1
cash application and the system will
automatically write-off the difference
to the default reason code associated
with this amount.
There may be three levels for these
allowances for each customer. If
multiple shortage amounts are used, they
must be in ascending order.
ACM-MAX-AUTO-PCT Signed 5.5 Occurs 3 Times AR10.1 AR501
Max Auto Write Off The maximum percentage allowed shortage AR550 AR951
Percent amount during cash application that will AR973 BL02.1
be automatically adjusted. This is one
of three fields that may be used for
this purpose. If multiple allowed
shortage percentages are used, they must
be in ascending percent sequence.
ACM-AUTO-REAS-CD Alpha 4 Occurs 3 Times AR10.1 AR501
Auto Write Off This reason code is required if there AR550 AR951
Reason Code is a short amount or percent allowed for AR973 BL02.1
automatic write-offs for the customer.
This will allow tracking adjustment
records by their reason codes.
ACM-DISC-REAS-CD Alpha 4 AR10.1 AR501
Discount Reason Code The default reason code for earned AR550 AR951
discounts for the customer. This must be AR973 BL02.1
a valid code in AR15 (Operational Codes
(Reason)).
ACM-BANK-INST-CODE Alpha 3 AR10.1 AR501
Payment Code This will be the users normal method of AR550 AR951
payment. It will edit to the AR973 BL02.1
user-defined Cash Ledger payment code
file. It must be a payment type of cash
payment, or bills of exchange to be a
valid default payment.
ACM-DRAFT-FLAG Alpha 1 AR10.1 AR501
Bill of Exchange If the customer has a default payment AR550 AR951
Creation code type of D (Bill of Exchange), this AR973 BL02.1
flag will indicate if the bills of
exchange should be created in summary or
individually (1 BOE for 1 Invoice).
Valid values are:
Blank = Not paying by BOE, Default
I = Individual
S = Summary
ACM-AR-CODE Alpha 4 AR10.1 AR501
Accounts Receivable Default accounts receivable code for AR550 AR951
Code this customer used for record entry. AR973 BL02.1
ACM-TERMS-CD Alpha 5 AR10.1 AR501
Terms Code The default terms code to be used AR550 AR951
during invoicing for this customer. AR973 BL02.1
ACM-TERMS-CASH Signed 15.2 AR190 AR194
Cash Paid Amount The cash paid amount from fully paid AR501 AR951
transactions. At the end of a current AR973
period, it will be used to calculate DBT
(Days Beyond Terms).
ACM-TERMS-CSH-DAYS Signed 15.2 AR190 AR194
Cash Days The flow of funds cash days calculated AR501 AR951
value (paid amount multiplied by the AR973
number of days from due date to fully
pay) for the current period.
ACM-DBT-RATIO Signed 3.0 Occurs 11 Times AR194 AR501
Days Beyond Terms Days Beyond Terms Indicator. Used in AR951 AR973
customer credit analysis. Calculation is
identical to IPA calculation, however
invoice due date is used instead of
invoice date.
Calculations:
GL Date of last application minus Due
Date of Invoice equals Days Outstanding.
Days Outstanding multiplied by Dollars
Paid equals DBT.
ACM-DBT-PR-YR Signed 3.0 AR199 AR501
Previous Year DBT This year's Days Beyond Terms indicator AR951 AR973
calculated at the end of the year by
AR199 (Period Closing).
ACM-DBT-YTD-CASH Signed 15.2 AR190 AR199
DBT YTD Cash Paid The cash paid amount from fully paid AR501 AR951
Amount transactions for the year. AR973
ACM-DBT-YTD-DAYS Signed 15.2 AR190 AR199
DBT YTD Cash Days A running total of the year's Flow of AR501 AR951
Fund Cash Days calculated value (paid AR973
invoice amount multiplied by the number
of days from Due Date to fully paid).
ACM-LATE-PAY-FL Alpha 1 AR10.1 AR501
Finance Charge Type Finance Charge Type. Indicates what AR550 AR951
type of charges will be assessed. Valid AR973 BL02.1
values are:
Blank = No charges
F = Finance charges assessed
L = Late payment charges assessed
B = Both finance and late payment
charges assessed.
ACM-FIN-CALC-TYPE Alpha 1 AR10.1 AR501
Finance Charge Indicates what type of calculation will AR550 AR951
Calculation be used in calculating finance charges. AR973 BL02.1
Valid values are:
D = Detail calculation method
N = Net calculation method
ACM-FIN-CHRG-CD Alpha 2 AR10.1 AR501
Finance Charge Code Finance charge code. This code must be AR550 AR951
predefined on AR07 (Finance Charge) and AR973 BL02.1
will contain a monthly finance charge
percentage rate.
ACM-FIN-GRAC-DAYS Numeric 2 AR10.1 AR501
Finance Charge The number of grace days added to due AR550 AR951
Grace Days date before finance charges will be AR973 BL02.1
assessed.
ACM-FIN-MIN-CHRG Signed 7.2 AR10.1 AR501
Minimum Finance The minimum finance charge amount AR550 AR951
Charge assessed if calculated finance charge is AR973 BL02.1
less than minimum. If minimum is zero,
there will be no override.
ACM-FIN-DOC-PRNT Alpha 1 AR10.1 AR501
Print Finance Specifies whether or not finance charge AR550 AR951
Charge Documents documents are required to be printed. AR973 BL02.1
Valid values are:
N = No; do not print finance charge
documents
Y = Yes; print finance charge document
ACM-LAST-DUNN Numeric 2 AR161 AR501
Last Dunning Number The last dunning letter number produced AR951 AR973
for the customer.
ACM-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR161 AR501
Last Dunning Date The date of the last dunning letter AR951 AR973
produced for the customer.
ACM-TAX-EXEMPT-CD Alpha 1 AR10.1 AR501
Tax Exempt Code Determines whether a customer is tax AR550 AR951
exempt or not. Used by the Lawson Order AR973 BL02.1
Entry system. Valid values are:
T = Taxable
E = Exempt
ACM-TAX-CODE Alpha 10 AR10.1 AR501
Tax Code User-defined code which identifies the AR550 AR951
default taxing authority this customer AR973 BL02.1
pays taxes to. Used by Lawson Order TX140
Entry system. Must be valid in the
Lawson Tax system.
ACM-TERRITORY Alpha 4 AR10.1 AR501
Sales Territory Sales territory. Used by Lawson AR550 AR951
Accounts Receivable, Order Entry and AR973 BL02.1
Sales Analysis systems.
ACM-AGING-CODE Numeric 2 AR10.1 AR501
Aging Code Aging code. Indicates if there is a AR550 AR951
customer level aging override present. AR973
If this field is greater than zero, the
customer's aging code will override the
company default aging periods and aging
rules in selected programs.
ACM-REVALUE-FL Alpha 1 AR10.1 AR501
Revalue Flag Indicates whether to revalue AR550 AR951
transaction currencies against the AR973
company base currency to account for
exchange rate fluctuations. Valid values
are:
N = No
Y = Yes
ACM-CURR-DRAFT-BAL Derived
Bill of Exchange A derived field containing the total
Balance amount of a customer's balance and bill
of exchange balance.
ACM-DISHONORED Signed 5.0 AR951 AR973
Dishonored BOEs The total number of customer bills of DT90.1
exchange that have been dishonored.
ACM-DISHONORED-AMT Signed 15.2 AR951 AR973
Dishonored BOE The total amount of the customer's DT90.1
Amount dishonored bills of exchange.
ACM-RECONCILE-CASH Signed 5.0 AR951 AR973
Reconciled BOEs The number of dishonored bills of DT92.1
exchange that have been reconciled by
means of a cash payment.
ACM-RECONCILE-RNEG Signed 5.0 AR951 AR973
Rengotiated BOEs The total number of dishonored bills of DT92.1
exchange that have been reconciled by
means of renegotiation.
ACM-RECONCILE-WO Signed 5.0 AR951 AR973
Written Off BOEs The total number of dishonored bills of DT92.1
exchange that have been reconciled by
means of a write-off to a bad debt
account.
ACM-MINIMUM Alpha 1 AR10.1 AR501
Minimum Finance Used to determine if minimum finance AR550 AR951
Charge charges are to be used. Valid values AR973 BL02.1
are:
Y = Use minimum amount if calculated
amount is less than minimum amount.
N = No charge if calculated amount is
less than minimum amount. If minimum
amount is blank, then calculated amount
is charged.
ACM-FIN-CYCLE Alpha 2 AR10.1 AR501
Finance Charge Finance charge cycle code. Lets you AR550 AR951
Cycle Code control customer selection when you AR973 BL02.1
generate finance charges.
ACM-DUN-CYCLE Alpha 2 AR10.1 AR501
Dunning Cycle Code Dunning cycle code. Lets you control AR550 AR951
customer selection when you generate AR973 BL02.1
dunning notices.
ACM-AUTO-METHOD Alpha 1 AR10.1 AR501
Auto Cash Indicates the automatic cash AR550 AR951
Application Method application method for this customer. AR973 BL02.1
Valid values are:
A = Algorithm
B = Balance forward
L = Last statement
R = Remittance
ACM-AUTO-REMOVE Alpha 1 AR10.1 AR501
Automatic This field determines whether payments AR550 AR700
Transaction Removal and transactions can be removed AR951 AR973
automatically. Valid values are:
N = No
Y = Yes
ACM-I-FIN-MIN-CHRG Signed 7.2 AR10.1 AR501
Inv Minimum Finance Minimum finance charge amount for an AR550 AR951
Charge invoice.
ACM-VAT-CUST-TYPE Alpha 2 AR10.1 AR501
VAT Customer Type Indicates the type of customer for VAT AR550
reporting. This field is required for
all customers if the AR company
indicates that VAT Reporting is
required. Values are:
DM = Domestic
ER = EEC Registered
EU = EEC Unregistered
XP = Export
VX = VAT Exempt
ACM-VAT-REG-NBR Alpha 12 AR10.1 AR501
VAT Registration The number component of the VAT AR550
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
ACM-VAT-REG-CTRY Alpha 2 AR10.1 AR501
VAT Registration The country component of the VAT AR550
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
ACM-VAT-NBR Derived
VAT Number The concatenation of the VAT
Registration Country and VAT
Registration Number fields, used as VAT
reporting ID.
ACM-DUN-LTR-IND Alpha 1 AR10.1 AR501
Dunning Letter Dunning Letters in use for customer. AR550
Indicator Yes or No. This refers to the advanced
dunning letter process.
ACM-DUN-PROCESS-CD Alpha 6 AR10.1 AR501
Dunning Process Code Dunning letter process code. A unique AR550
code that represents a combination of
Dunning Letter options.
ACM-LANGUAGE-CODE Alpha 10 AR10.1 AR501
Preferred Language The language code (locale) representing AR550
Code the customer's preferred language. If
no language code is specified, the
environment base language is assumed.
ACM-LST-DUNLTR-STM Numeric 2 AR10.1 AR145
Last Dunning Letter Dunning level of the last dunning letter AR951
Statement sent. Refers to a level of processing
within the dunning process code.
ACM-LAST-LTR-DATE Numeric 8 (yyyymmdd) AR145 AR951
Last Dunning Letter Date last dunning letter was sent for
Date the invoice.
ACM-LST-LTRTEXT-CD Alpha 6 AR10.1 AR145
Last Dunning Letter Text Code for last Dunning Letter sent
Text Code on this invoice.
ACM-ASSESS-DUN-FEE Alpha 1 AR10.1 AR501
Assess Dunning Fee Dunning letter fee charged. Yes or NO. AR550
Indicator Y = Yes
N = No
ACM-CU-NAME Alpha 30 AR10.1
Credit Agency Name Optional credit agency name. Used if
you are required to send a dunning
letter to a customer's credit agency.
ACM-CU-ADDR1 Alpha 30 (Lower Case) AR10.1
Credit Agency Credit agency address line 1.
Address Line 1
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR10.1
Credit Agency Credit agency address line 2.
Address Line 2
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR10.1
Credit Agency Credit agency address line 3.
Address Line 3
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR10.1
Credit Agency Credit agency address line 4.
Address Line 4
ACM-CU-CITY Alpha 18 (Lower Case) AR10.1
Credit Agency City Credit agency city.
ACM-CU-STATE Alpha 2 AR10.1
Credit Agency State Credit agency state.
ACM-CU-POSTAL-CODE Alpha 12 AR10.1
Credit Agency Credit agency postal code.
Postal Code
ACM-CU-COUNTRY-CD Alpha 2 AR10.1
Credit Agency Credit agency Country cde.
Country Code
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR10.1
Credit Agency Credit agency country.
Country
ARCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACMSET1 COMPANY This is the primary path used to access AC115 AC15.2
CUSTOMER customer records. AC450 AR01.1
AR09.1 AR10.1
AR10.2 AR100
AR105 AR11.1
AR110 AR115
AR12.1 AR12.2
AR124 AR13.1
AR13.2 AR130
AR131 AR132
AR135 AR136
AR137 AR140
AR141 AR145
AR150 AR155
AR160 AR161
...
ACMSET2 COMPANY This path is used to access customer AR209 AR210
SEARCH-NAME records in search name order. AR301
CUSTOMER KeyChange
ACMSET3 CUSTOMER This path is used to access records AR301 AR58.1
COMPANY with the same customer number in
different companies.
ACMSET6 COMPANY This path is used for accessing
CUSTOMER customer records by language preference
LANGUAGE-CODE code.
KeyChange
ACMSET7 COMPANY This path is used to access customer AR04.1 AR150
STMNT-CYCLE records by statement cycle.
CUSTOMER KeyChange
ACMSET8 COMPANY This path is used to access customer AR06.1 AR170
CREDIT-ANLYST records by credit analyst. AR217 AR271
CUSTOMER KeyChange AR292
ACMSET9 COMPANY This path is used to access customer AC115 AC15.2
EDI-NBR records by EDI number. AC450 AR10.1
KeyChange, Subset AR501 AR550
Where EDI-NBR != Spaces AR575 BL02.1
BL02.2 BL04.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL202
BL204 BL21.2
BL21.5 BL220
BL231 BL246
BL29.1 BL29.2
BL290 BL291
BL31.1 BL31.2
...
ARCUSTOMER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ACM-COMPANY -> ACO-COMPANY
Arcustflds ARCUSTFLDS Not Required, Delete Cascades
ACM-COMPANY -> ACF-COMPANY
ACM-CUSTOMER -> ACF-CUSTOMER
Arreason ARREASON Required
When ACM-AUTO-REAS-CD != Spaces
ACM-COMPANY -> ARR-COMPANY
"AD" -> ARR-TYPE
ACM-AUTO-REAS-CD -> ARR-REASON-CODE
Cbbankinst CBBANKINST Required
ACM-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cranalyst CRANALYST Required
ACM-COMPANY -> CAN-COMPANY
ACM-CREDIT-ANLYST -> CAN-CREDIT-ANLYST
Custdeflts CUSTDEFLTS Required
ACM-COMPANY -> CDF-COMPANY
ACM-DEFAULT-CODE -> CDF-DEFAULT-CODE
Customerdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ACM-CUSTOMER -> CUD-CUSTOMER
Holdcodes HOLDCODES Required
When ACM-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
ACM-HOLD-CODE -> HDD-HOLD-CODE
ARCUSTOMER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomment3 ARCOMMENT
ACM-COMPANY -> CMT-COMPANY
ACM-CUSTOMER -> CMT-CUSTOMER
CMT-SYS-DATE
CMT-SYS-TIME
CMT-SEQ-NBR
Arcomments ARCOMMENT
ACM-COMPANY -> CMT-COMPANY
ACM-CUSTOMER -> CMT-CUSTOMER
CMT-SEQ-NBR
Arcontacts ARCONTACTS Delete Cascades
ACM-COMPANY -> CON-COMPANY
ACM-CUSTOMER -> CON-CUSTOMER
CON-RESP-CODE
Arcustpayment ARPAYMENT Delete Restricted
ACM-COMPANY -> APM-COMPANY
ACM-CUSTOMER -> APM-CUSTOMER
APM-TRANS-TYPE
APM-TRANS-NBR
APM-BATCH-NBR
Arcustper ARCUSTPER Delete Cascades
ACM-COMPANY -> ARP-COMPANY
ACM-CUSTOMER -> ARP-CUSTOMER
ARP-YEAR
Ardispute ARDISPUTE Delete Restricted
ACM-COMPANY -> ADP-COMPANY
ACM-CUSTOMER -> ADP-CUSTOMER
ADP-TRANS-TYPE
ADP-TRANS-NBR
ADP-PAYMENT-SEQ
ADP-SEQ
Ardrafts ARDRAFTS Delete Restricted
ACM-COMPANY -> ARD-COMPANY
ACM-CUSTOMER -> ARD-CUSTOMER
ARD-DRAFT-NBR
ARD-SUFFIX
ARD-CANCEL-SEQ
ARD-DRAFT-SOURCE
Armicrcust ARMICRCUST
ACM-COMPANY -> AMX-COMPANY
ACM-CUSTOMER -> AMX-CUSTOMER
AMX-BANK-ENTITY
AMX-BANK-ACCT-NBR
Aroihdr AROIHDR Delete Restricted
ACM-COMPANY -> ARH-COMPANY
ACM-CUSTOMER -> ARH-CUSTOMER
ARH-TRANS-TYPE
ARH-TRANS-NBR
Aroitems AROITEMS Delete Restricted
ACM-COMPANY -> ARO-COMPANY
ACM-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-TYPE
ARO-TRANS-NBR
ARO-PAYMENT-SEQ
Aroitemsopen AROITEMS Delete Restricted
ACM-COMPANY -> ARO-COMPANY
ACM-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-TYPE
ARO-TRANS-NBR
ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Delete Restricted
ACM-COMPANY -> APM-COMPANY
ACM-CUSTOMER -> APM-CUSTOMER
APM-GL-DATE
APM-BATCH-NBR
APM-SEQ-NBR
Billto BILLTO
CUD-CUST-GROUP -> ABS-CUST-GROUP
ACM-CUSTOMER -> ABS-CUSTOMER
ABS-BILL-TO
Customertotals ARCUSTTOTS Delete Cascades
ACM-COMPANY -> CUT-COMPANY
ACM-CUSTOMER -> CUT-CUSTOMER
CUT-PROCESS-LEVEL
Dtcustbank DTCUSTBANK
CUD-CUST-GROUP -> DTB-CUST-GROUP
ACM-CUSTOMER -> DTB-CUSTOMER
DTB-BANK-ENTITY
DTB-BANK-ACCT-NBR
Frcontmast FRCONTMAST
ACM-COMPANY -> FRM-COMPANY
ACM-CUSTOMER -> FRM-CUSTOMER
FRM-SHIP-TO
FRM-CONTR-NBR
Ftcustgrp FTCUSTGRP
CUD-CUST-GROUP -> FTG-CUST-GROUP
ACM-CUSTOMER -> FTG-CR-CUSTOMER
FTG-CUSTOMER
Natacct NATACCT Required
When ACM-NAT-FLAG = "N"
ACM-COMPANY -> NAC-NAT-COMPANY
ACM-CUSTOMER -> NAC-NAT-CUSTOMER
NAC-COMPANY
NAC-CUSTOMER
Pbclient PBCLIENT
ACM-COMPANY -> PCC-POST-COMPANY
ACM-CUSTOMER -> PCC-CUSTOMER
PCC-COMPANY
PCC-PROCESS-LEVEL
|