Lawson Insight Technical Documentation |
|
ARCUSTOMER
ARCUSTOMER FILE
AR Company Customer
The AR Company Customer file will contain customer information that is
relevant to a specific company level customer. The customer processing rules
for the company key, are defined and maintained in this record. Statistical
fields and order processing fields are also contained on this record.
REFERENCED BY
AC551 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 AR01.1
AR09.1 AR09.7 AR09.4 AR100 AR105 AR11.1
AR110 AR112 AR132 AR136 AR140 AR155
AR160 AR191 AR196 AR209 AR210 AR211
AR217 AR219 AR222 AR223 AR227 AR228
AR229 AR230 AR232 AR233 AR234 AR235
AR245 AR25.1 AR25.2 AR250 AR251 AR253
AR255 AR258 AR260 AR261 AR274 AR275
AR286 AR290 AR291 AR292 AR293 AR294
AR50.1 AR504 AR53.1 AR58.1 AR72.1 AR74.1
AR75.1 AR80.1 AR80.2 AR90.1 BR10.1 BR11.1
BR120 BR121 BR122 BR123 BR15.1 BR151
BR152 BR155 BR156 BR16.1 BR16.2 BR210
BR211 BR215 BR220 BR251 BR252 BR253
BR420 BR450 BR51.1 BR51.2 BR52.1 BR52.2
BR521 BR53.1 BR55.2 BR91.1 BRIP.1 BRPI.1
CB06.2 DT161 DT190 DT270 DT280 DT42.1
DT95.1 IC02.1 IC28.1 IC531 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 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 PBIP.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 PR197 RQ10.1 RQ10.2 RQ10.3 RQIE.1
IN120 IN20.1 TX125 TX40.1 WH110 WH120
WH130 WH132 WH190 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 WO30.1 AR04.1 AR06.1 AR271
UPDATED BY
AR10.1 AR10.2 AR115 AR12.1 AR12.2 AR124
AR129 AR13.1 AR13.2 AR130 AR131 AR135
AR137 AR141 AR145 AR150 AR161 AR17.1
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 AR48.3 AR501 AR502 AR503 AR505
AR506 AR550 AR560 AR570 AR575 AR580
AR70.2 AR700 AR82.1 ARI1.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 TX140 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACM-COMPANY Numeric 4 AR10.1 AR501
Element: Company The accounts receivable company AR550 DT150
assigned to the customer.
ACM-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Element: Customer The unique identifier assigned to the AR550 DT150
customer.
ACM-ACTIVE-STATUS Alpha 1 AR10.1 AR301
Element: Active Status Indicates the status of the customer. AR501 AR550
Valid values are:
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
cannot be an invoiced customer to
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
Element: Search Name The search name for the customer. AR550
Reports can be sequenced using this
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
Element: Hold Code Indicates whether a customer is on AR550 AR70.2
hold.
ACM-CONTACT Alpha 20 AR10.1 AR501
Element: Primary ContacPrimary contact name for this customer. AR550
ACM-INT-PREFIX Alpha 6 AR10.1 AR501
International The international telephone number AR550
Telephone Prefix prefix.
ACM-PHONE-NMBR Alpha 15 AR10.1 AR501
Element: Telephone NumbThe telephone number for this customer. AR550
ACM-PHONE-EXT Alpha 5 AR10.1 AR501
Element: Telephone ExteThe telephone extension number for the AR550
customer.
ACM-TELEX-NBR Alpha 15 AR10.1 AR501
Element: Telex Number The telex number for the customer. AR550
ACM-EDI-NBR Alpha 15 AR10.1 AR501
Element: EDI Number The electronic data interchange (EDI) AR550
number assigned to the customer. Used by
the Lawson Order Entry system or
external order processing systems.
ACM-ALT-EDI-NBR Alpha 95 AR10.1 AR501
Element: Alternate EDI This is a free-form field to AR550
accommodate an alternate EDI number or
address.
ACM-ALT-EDI-TYPE Alpha 5 AR10.1 AR501
Element: Alternate EDI Indicates the type of the alternate EDI AR550
number.
ACM-FAX-NMBR Alpha 15 AR10.1 AR501
Element: Fax Number The customer's fax number. AR550
ACM-FAX-EXT Alpha 5 AR10.1 AR501
Element: Fax Extension The customer's fax extension. AR550
ACM-START-DATE Numeric 8 (yyyymmdd) AR10.1 AR501
Element: Start Date The date the customer first began doing AR550
business with the company. If left blank
when adding a customer, the system date
defaults.
ACM-CREDIT-ANLYST Alpha 4 AR10.1 AR501
Element: Credit AnalystThe credit analyst code assigned to AR550
this customer.
ACM-CURRENCY-CD Alpha 5 AR10.1 AR501
Element: Currency Code The default currency in which the AR550
customer will be invoiced. If the
company has Yes selected the Currency
Override field in AR01 (Company), 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
Element: SalesRep The primary sales representative for AR550
this customer. This salesrep is used on
various programs for selection and
sorting.
ACM-RISK-CD Alpha 1 AR10.1 AR501
Element: Risk Code The risk code is used for risk AR550
analysis. Defaults from the company.
ACM-DEFAULT-CODE Alpha 5 AR10.1 AR501
Element: Default Code The customer default code is used to AR550
default values and options into the
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
Element: Major Class The major class assigned to this AR550
customer.
ACM-MIN-CLASS Alpha 4 AR10.1 AR501
Element: Minor Class The minor class assigned to this AR550
customer.
ACM-CURR-BAL Signed 15.2 AR115 AR12.1
Element: Current BalancThe current balance for the customer. AR12.2 AR124
AR129 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 AR48.3
AR502 AR505
AR560 AR570
AR575 AR580
AR82.1 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 AR129
Balance customer. AR13.1 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
AR48.3 AR502
AR505 AR560
AR82.1 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 AR115 AR129
Element: Open Order TotThe total amount of orders that have AR130 AR131
been entered into an external order AR135 AR137
processing system but have not yet been AR180 AR190
invoiced. AR501 AR502
AR560 AR82.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT520
WH20.7
ACM-ORDER-LIM Signed 15.0 AR10.1 AR501
Element: Open Order LimThe limit for the total amount of open AR550
orders allowed for this customer. Zero
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
Element: Credit Limit Total amount of credit extended to a AR550
customer. Zero means unlimited credit is
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
Element: Credit Limit DThe date the credit limit was defined AR550 AR70.2
or last reviewed.
ACM-CREDIT-REVDAYS Signed 3.0 AR10.1 AR501
Element: Credit Review The number of days between the credit AR550
limit reviews for the customer.
ACM-LAST-PMT-AMT Signed 15.2 AR115 AR124
Element: Last Payment AThe amount of the last payment made by AR13.1 AR13.2
this customer. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR30.2 AR30.4
AR501 AR503
AR570 AR575
AR580 CB191
DT170 DT180
DT181
ACM-LAST-PMT-DATE Numeric 8 (yyyymmdd) AR115 AR124
Element: Last Payment DThe date of the last payment made by AR13.1 AR13.2
the customer. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR30.2 AR30.4
AR501 AR503
AR570 AR575
AR580 CB191
DT170 DT180
DT181
ACM-LAST-INV-DATE Numeric 8 (yyyymmdd) AR115 AR129
Element: Last Invoice DThe date of the last invoice for this AR13.1 AR13.2
customer. 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
AR48.3 AR501
AR502 AR560
AR82.1 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-INV-AMT Signed 15.2 AR115 AR129
Element: Last Inv Amt AR13.1 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
AR48.3 AR501
AR502 AR560
AR82.1 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
Element: Last StatementThe date of the last statement for this
customer.
ACM-LAST-STA-BAL Signed 15.2 AR150 AR501
Last Statement The customer's balance on their last
Balance statement.
ACM-REVIEW-DATE Numeric 8 (yyyymmdd) AR17.1 AR501
Element: Review Date The last date the customer was defined AR70.2
for review. AR17 (Comments) and AR70
(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
Element: Review Code Indicates the status of the customer's AR501 AR70.2
review record. Valid values are:
O = Open
R = Reviewed
ACM-HIGH-BAL Signed 15.0 Occurs 13 Times AR115 AR129
Element: Highest BalancThe highest balance for the customer AR13.1 AR13.2
for the period. AR130 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 AR48.3
AR501 AR502
AR560 AR82.1
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 AR129
Element: Period RTMs Period Return-to-Maker debit memos. The AR13.1 AR13.2
number of payments that have been AR130 AR131
returned to the customer for the period. 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 AR48.3
AR501 AR502
AR560 AR82.1
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
Element: Paid Prompt The number of invoices that were paid AR199 AR501
in full within the due date of the
invoice (incorporating grace days).
Invoices cleared by chargebacks are not
considered.
ACM-INV-PAID Signed 5.0 Occurs 12 Times AR190 AR194
Element: Paid Invoices A count of invoices fully paid within AR199 AR501
the period. This will be used in the
Invoice Payment Average (IPA) and Days
Beyond Terms (DBT) calculations for each
customer.
ACM-COLLECT-DAYS Signed 3.0 Occurs 11 Times AR194 AR501
Element: Collect Days A collection ratio of days to collect
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
Element: Current Cash The cash paid amount from fully paid AR501
transactions. At the end of a current
period, it will be used to calculate the
ratio for the Collect Days field.
ACM-CURR-CSH-DAYS Signed 15.2 AR190 AR194
Element: Current Cash DThe Flow of Funds Cash Days calculated AR501
value (paid amount multiplied by the
number of days to fully pay) for the
current period.
ACM-YTD-CASH Signed 15.2 AR190 AR199
Element: Year-to-Date CThe year-to-date total of cash for AR501
fully paid transactions.
ACM-YTD-CSH-DAYS Signed 15.2 AR190 AR199
Year-to-Date Cash The year to date calculation of cash AR501
Days paid and applied to an open item times
the number of days it took to fully pay
the transactions.
ACM-YEAR-2-DAYS Signed 3.0 AR199 AR501
Element: Previous Year The weighted invoice payment average
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
Balance customer's balance as of the last
running of AR194 (Audit Summary).
ACM-AGING Signed 15.2 Occurs 5 Times AR194 AR501
Element: Aging These aging buckets carry the static
past-due amounts in each aging period
for a given customer. These fields are
updated by AR194 (Audit Summary).
ACM-LAST-COMMENT Numeric 6 AR115 AR129
Element: Last Comment AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR141 AR161
AR17.1 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 AR48.3
AR502 AR503
AR506 AR560
AR82.1 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
...
ACM-DISP-NBR Signed 3.0 AR190 AR29.3
Element: Disputed ItemsThe number of open items currently in AR45.1 AR506
dispute.
ACM-DISP-AMT Signed 15.2 AR190 AR29.3
Element: Disputed AmounThe total amount in dispute for this AR45.1 AR506
customer.
ACM-PL-EXCL-FL Alpha 1 AR10.2
Process Level Indicates if the invoices being entered
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
Element: Age Disputes Specifies how disputed invoices will be AR550
aged. Valid values are:
N = Not aged - aged in current column
Y = Aged respective to GL date
ACM-DISPUTES-FIN Alpha 1 AR10.1 AR501
Element: Finance DisputSpecifies if disputed invoices are AR550
exempt from being assessed finance
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
Application Valid values are:
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
Letters selection for dunning letters will be
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
Period allow or disallow discount during cash
application.
ACM-CR-VAR-PCT Numeric 3 AR10.1 AR501
Credit Variance Contains an optional override percent AR550
Percent that will be used in customer credit
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
Element: Memo Terms Memo terms code. Must be a valid net or AR550
prepayment type terms code defined in
the Lawson Terms system.
ACM-CHRGBK-PRT-FL Alpha 1 AR10.1 AR501
Element: Print ChargebaSpecifies whether chargebacks will be AR550
printed. Valid values are:
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
Forward either open item or balance forward
methods. Valid values are:
B = Balance forward processing
O = Open Item processing
ACM-STATEMENT-REQ Alpha 1 AR10.1 AR501
Element: Statement RequStatement required option. If AR550
statements are required, the default
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
Element: Statement CyclUsed to group customers with like AR550
statement cycles for statement
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
Element: Lock Box The remit-to location of a lock box, AR550
used for payment receipts. If entered,
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
Element: Zero StatementZero balance statement option. AR550
Determines whether or not a customer
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
Element: Credit StatemeCredit balance statement option. AR550
Determines whether or not a customer
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
Element: Past Due StatePast due open items only statement AR550
option. If this option is Yes, only past
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
Statements If Yes is chosen, statements will only
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
Off Amount short of a particular invoice during
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
Percent amount during cash application that will
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
Reason Code is a short amount or percent allowed for
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
Element: Discount ReasoThe default reason code for earned AR550
discounts for the customer. This must be
a valid code in AR15 (Operational Codes
(Reason)).
ACM-BANK-INST-CODE Alpha 3 AR10.1 AR501
Element: Payment Code This will be the users normal method of AR550
payment. It will edit to the
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
Creation code type of D (Bill of Exchange), this
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
Code this customer used for record entry.
ACM-TERMS-CD Alpha 5 AR10.1 AR501
Element: Terms Code The default terms code to be used AR550
during invoicing for this customer.
ACM-TERMS-CASH Signed 15.2 AR190 AR194
Element: Cash Paid AmouThe cash paid amount from fully paid AR501
transactions. At the end of a current
period, it will be used to calculate DBT
(Days Beyond Terms).
ACM-TERMS-CSH-DAYS Signed 15.2 AR190 AR194
Element: Cash Days The flow of funds cash days calculated AR501
value (paid amount multiplied by the
number of days from due date to fully
pay) for the current period.
ACM-DBT-RATIO Signed 3.0 Occurs 11 Times AR194 AR501
Element: Days Beyond TeDays Beyond Terms Indicator. Used in
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
Element: Previous Year This year's Days Beyond Terms indicator
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
Amount transactions for the year.
ACM-DBT-YTD-DAYS Signed 15.2 AR190 AR199
Element: DBT YTD Cash DA running total of the year's Flow of AR501
Fund Cash Days calculated value (paid
invoice amount multiplied by the number
of days from Due Date to fully paid).
ACM-LATE-PAY-FL Alpha 1 AR10.1 AR501
Element: Finance ChargeFinance Charge Type. Indicates what AR550
type of charges will be assessed. Valid
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
Calculation be used in calculating finance charges.
Valid values are:
D = Detail calculation method
N = Net calculation method
ACM-FIN-CHRG-CD Alpha 2 AR10.1 AR501
Element: Finance ChargeFinance charge code. This code must be AR550
predefined on AR07 (Finance Charge) and
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
Grace Days date before finance charges will be
assessed.
ACM-FIN-MIN-CHRG Signed 7.2 AR10.1 AR501
Minimum Finance The minimum finance charge amount AR550
Charge assessed if calculated finance charge is
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
Charge Documents documents are required to be printed.
Valid values are:
N = No; do not print finance charge
documents
Y = Yes; print finance charge document
ACM-LAST-DUNN Numeric 2 AR161 AR501
Element: Last Dunning NThe last dunning letter number produced
for the customer.
ACM-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR141 AR161
Element: Last Dunning DThe date of the last dunning letter AR501
produced for the customer.
ACM-LAST-DUN-AMT Signed 15.2 AR141 AR161
Element: Last Dun Amt AR501
ACM-TAX-EXEMPT-CD Alpha 1 AR10.1 AR501
Element: Tax Exempt CodDetermines whether a customer is tax AR550
exempt or not. Used by the Lawson Order
Entry system. Valid values are:
T = Taxable
E = Exempt
ACM-TAX-CODE Alpha 10 AR10.1 AR501
Element: Tax Code User-defined code which identifies the AR550 TX140
default taxing authority this customer
pays taxes to. Used by Lawson Order
Entry system. Must be valid in the
Lawson Tax system.
ACM-TERRITORY Alpha 4 AR10.1 AR501
Element: Sales TerritorSales territory. Used by Lawson AR550
Accounts Receivable, Order Entry and
Sales Analysis systems.
ACM-AGING-CODE Numeric 2 AR10.1 AR501
Element: Aging Code Aging code. Indicates if there is a AR550
customer level aging override present.
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
Element: Revalue Flag Indicates whether to revalue AR550
transaction currencies against the
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 DT90.1
Element: Dishonored BOEThe total number of customer bills of
exchange that have been dishonored.
ACM-DISHONORED-AMT Signed 15.2 DT90.1
Dishonored BOE The total amount of the customer's
Amount dishonored bills of exchange.
ACM-RECONCILE-CASH Signed 5.0 DT92.1
Element: Reconciled BOEThe number of dishonored bills of
exchange that have been reconciled by
means of a cash payment.
ACM-RECONCILE-RNEG Signed 5.0 DT92.1
Element: Rengotiated BOThe total number of dishonored bills of
exchange that have been reconciled by
means of renegotiation.
ACM-RECONCILE-WO Signed 5.0 DT92.1
Element: Written Off BOThe total number of dishonored bills of
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
Charge charges are to be used. Valid values
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
Cycle Code control customer selection when you
generate finance charges.
ACM-DUN-CYCLE Alpha 2 AR10.1 AR501
Element: Dunning Cycle Dunning cycle code. Lets you control AR550
customer selection when you generate
dunning notices.
ACM-AUTO-METHOD Alpha 1 AR10.1 AR501
Auto Cash Indicates the automatic cash AR550
Application Method application method for this customer.
Valid values are:
A = Algorithm
B = Balance forward
L = Last statement
R = Remittance
" " = None
ACM-AUTO-REMOVE Alpha 1 AR10.1 AR501
Element: All Flag This field determines whether payments AR550 AR700
and transactions can be removed
automatically.
N = No
Y = Yes
ACM-I-FIN-MIN-CHRG Signed 7.2 AR10.1 AR501
Element: I Fin Min ChrgMinimum finance charge amount for an AR550
invoice.
ACM-CB-DTL-DATE Alpha 1 AR10.1 AR501
Element: Cb Dtl Date This field will be used to determine AR550
which dates are used to calculate
transaction and due dates for detail
chargebacks.
I = Invoice
P = Payment
ACM-VAT-CUST-TYPE Alpha 2 AR10.1 AR501
Element: Vat Cust 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.
DM = Domestic
ER = EEC-Registered
EU = EEC-Unregistered
XP = Export
ACM-VAT-REG-NBR Alpha 12 AR10.1 AR501
Element: Vat Reg Nbr The number component of the VAT AR550
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
Element: Vat Reg Ctry The country component of the VAT AR550
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
ACM-VAT-NBR Derived
Element: Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
ACM-DUN-LTR-IND Alpha 1 AR10.1 AR501
Element: Dun Ltr Ind Dunning letters in use for customer. AR550
Yes or No. This refers to the advanced
dunning letter process.
Y = Yes
N = No
ACM-DUN-PROCESS-CD Alpha 6 AR10.1 AR501
Element: Dun Process CdDunning letter process code. A unique AR550
code that represents a combination of
Dunning Letter options.
ACM-LANGUAGE-CODE Alpha 10 AR10.1 AR501
Element: Language Code The language code (locale) representing AR550
the customer's preferred language. If
no language code is specified, the
environment base language is assumed
which is always U.S. English.
ACM-LST-DUNLTR-STM Numeric 2 AR10.1 AR145
Element: Lst Dunltr StmDunning level of the last dunning
letter sent. Refers to a level of
processing within the dunning process
code.
ACM-LAST-LTR-DATE Numeric 8 (yyyymmdd) AR145
Element: Last Ltr Date Date last dunning letter was sent for
the invoice.
ACM-LST-LTRTEXT-CD Alpha 6 AR10.1 AR145
Element: Lst Ltrtext CdText Code for last Dunning Letter sent
on this invoice.
ACM-ASSESS-DUN-FEE Alpha 1 AR10.1 AR501
Element: Assess Dun FeeDunning letter fee charged. Yes or No. AR550
Y = Yes
N = No
ACM-CU-NAME Alpha 30 AR10.1 AR501
Element: Cu Name Optional credit agency name. Used if AR550
you are required to send a dunning
letter to a customer's credit agency.
ACM-CU-ADDR1 Alpha 30 (Lower Case) AR10.1 AR501
Element: Cu Addr1 Credit Union Address Line 1. AR550
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR10.1 AR501
Element: Cu Addr2 Credit Union Address Line 2. AR550
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR10.1 AR501
Element: Cu Addr3 Credit union address line 3. AR550
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR10.1 AR501
Element: Cu Addr4 Credit union address line 4. AR550
ACM-CU-CITY Alpha 18 (Lower Case) AR10.1 AR501
Element: Cu City Credit Union City. AR550
ACM-CU-STATE Alpha 2 AR10.1 AR501
Element: Cu State Credit Union State. AR550
ACM-CU-POSTAL-CODE Alpha 12 AR10.1 AR501
Element: Cu Postal CodeCredit Union Postal Code. AR550
ACM-CU-COUNTRY-CD Alpha 2 AR10.1 AR501
Element: Cu Country Cd Credit Union Country Code. AR550
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR10.1 AR501
Element: Cu Country Credit Union Country. AR550
ACM-THIRD-PARTY Alpha 1 AR10.1 AR501
Element: Third Party N = No third party payment AR550
Y = Third party payment allowed
ACM-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR10.1 AR501
Element: Email Address AR550
ACM-URL-ADDR Alpha 60 (Lower Case) AR10.1 AR501
Element: Url Addr AR550
ARCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACMSET1 COMPANY This is the primary path used to access AC551 AP125
CUSTOMER customer records. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR01.1
AR09.1 AR09.7
AR10.1 AR10.2
AR100 AR105
AR11.1 AR110
AR112 AR115
AR12.1 AR12.2
...
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 AR09.1 AR09.4
COMPANY with the same customer number in AR10.1 AR301
different companies. AR58.1
ACMSET6 COMPANY This path is used for accessing
CUSTOMER customer records by Soundex code.
LANGUAGE-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 AC551 AR10.1
EDI-NBR records by EDI number. AR219 AR48.1
KeyChange, Subset AR48.3 AR501
Where EDI-NBR != Spaces AR550 AR575
BR10.1 BR11.1
BR120 BR121
BR122 BR123
BR15.1 BR151
BR152 BR155
BR156 BR16.1
BR16.2 BR210
BR211 BR215
BR220 BR251
BR252 BR253
BR420 BR450
...
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
Natacct Inv NATACCT Required
When ACM-NAT-FLAG = "I"
ACM-COMPANY -> NAC-COMPANY
ACM-CUSTOMER -> NAC-CUSTOMER
Zeroes -> NAC-NAT-COMPANY
Spaces -> NAC-NAT-CUSTOMER
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-NUMBER
Arcomments ARCOMMENT
ACM-COMPANY -> CMT-COMPANY
ACM-CUSTOMER -> CMT-CUSTOMER
CMT-SEQ-NUMBER
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-INVOICE
ADP-PAYMENT-SEQ
ADP-SEQ
Ardrafts ARDRAFTS Delete Restricted
ACM-COMPANY -> ARD-COMPANY
ACM-CUSTOMER -> ARD-CUSTOMER
ARD-AR-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-INVOICE
Aroitems AROITEMS Delete Restricted
ACM-COMPANY -> ARO-COMPANY
ACM-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-TYPE
ARO-INVOICE
ARO-PAYMENT-SEQ
Aroitemsopen AROITEMS Delete Restricted
ACM-COMPANY -> ARO-COMPANY
ACM-CUSTOMER -> ARO-CUSTOMER
ARO-TRANS-TYPE
ARO-INVOICE
ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Delete Restricted
ACM-COMPANY -> APM-COMPANY
ACM-CUSTOMER -> APM-CUSTOMER
APM-GL-DATE
APM-BATCH-NBR
APM-PAYMENT-SEQ
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-COMPANY -> DTB-COMPANY
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-COMPANY -> FTG-COMPANY
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
|