 |
Lawson Insight Technical Documentation |
|
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 AP25.1 AP25.2
AP26.1 AP27.1 AR01.1 AR09.1 AR09.7 AR100
AR105 AR11.1 AR110 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 DA90.1
DA91.1 BR10.1 BR11.1 BR120 BR121 BR210
BR211 BR220 BR420 BR450 BRIP.1 CB06.2
DT161 DT190 DT270 DT280 DT42.1 DT95.1
DA290 IC02.1 IC28.1 IC531 MX223 MA180
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1
PBIP.1 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.1 POII.1 POIJ.1 PR160 PR180
PR197 PR80.2 RQ10.1 RQ10.2 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
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
Company The accounts receivable company AR550 DT150
assigned to the customer.
ACM-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Customer The unique identifier assigned to the AR550 DT150
customer.
ACM-ACTIVE-STATUS Alpha 1 AR10.1 AR301
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
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
Hold Code Indicates whether a customer is on AR550 AR70.2
hold.
ACM-CONTACT Alpha 20 AR10.1 AR501
Primary Contact Primary 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
Telephone Number The telephone number for this customer. AR550
ACM-PHONE-EXT Alpha 5 AR10.1 AR501
Telephone Extension The telephone extension number for the AR550
customer.
ACM-TELEX-NBR Alpha 15 AR10.1 AR501
Telex Number The telex number for the customer. AR550
ACM-EDI-NBR Alpha 15 AR10.1 AR501
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
Alternate EDI Number This is a free-form field to AR550
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
number.
ACM-FAX-NMBR Alpha 15 AR10.1 AR501
Fax Number The customer's fax number. AR550
ACM-FAX-EXT Alpha 5 AR10.1 AR501
Fax Extension The customer's fax extension. AR550
ACM-START-DATE Numeric 8 (yyyymmdd) AR10.1 AR501
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
Credit Analyst The credit analyst code assigned to AR550
this customer.
ACM-CURRENCY-CD Alpha 5 AR10.1 AR501
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
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
Risk Code The risk code is used for risk AR550
analysis. Defaults from the company.
ACM-DEFAULT-CODE Alpha 5 AR10.1 AR501
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
Major Class The major class assigned to this AR550
customer.
ACM-MIN-CLASS Alpha 4 AR10.1 AR501
Minor Class The minor class assigned to this AR550
customer.
ACM-CURR-BAL Signed 15.2 AR115 AR12.1
Current Balance The 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 AR501 AR502
Open Order Total The total amount of orders that have AR560 WH20.7
been entered into an external order
processing system but have not yet been
invoiced.
ACM-ORDER-LIM Signed 15.0 AR10.1 AR501
Open Order Limit The 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
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
Credit Limit Date The date the credit limit was defined AR550 AR70.2
or last reviewed.
ACM-CREDIT-REVDAYS Signed 3.0 AR10.1 AR501
Credit Review Days The number of days between the credit AR550
limit reviews for the customer.
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 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 CB191
DT170 DT180
DT181
ACM-LAST-INV-DATE Numeric 8 (yyyymmdd) AR115 AR129
Last Invoice Date The 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
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
Last Statement Date The 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
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
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
Highest Balance The 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
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
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
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
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
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
Current Cash Days The 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
Year-to-Date Cash The 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
Previous Year IPA 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
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 AR141 AR161
Last Comment AR17.1 AR29.1
AR503 AR506
AR560 ARI1.1
ACM-DISP-NBR Signed 3.0 AR190 AR45.1
Disputed Items The number of open items currently in AR506
dispute.
ACM-DISP-AMT Signed 15.2 AR190 AR45.1
Disputed Amount The total amount in dispute for this AR506
customer.
ACM-PL-EXCL-FL Alpha 1 AR10.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
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
Finance Disputes Specifies 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
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
Print Chargebacks Specifies 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
Statement Required Statement 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
Statement Cycle Used 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
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
Zero Statements Zero 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
Credit Statements Credit 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
Past Due Statements Past 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
Discount Reason Code The 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
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
Terms Code The default terms code to be used AR550
during invoicing for this customer.
ACM-TERMS-CASH Signed 15.2 AR190 AR194
Cash Paid Amount The 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
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
Days Beyond Terms Days 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
Previous Year DBT 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
DBT YTD Cash Days A 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
Finance Charge Type Finance 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
Finance Charge Code Finance 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
Last Dunning Number The last dunning letter number produced
for the customer.
ACM-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR141 AR161
Last Dunning Date The date of the last dunning letter AR501
produced for the customer.
ACM-LAST-DUN-AMT Signed 15.2 AR141 AR161
Last Dun Amt AR501
ACM-TAX-EXEMPT-CD Alpha 1 AR10.1 AR501
Tax Exempt Code Determines 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
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
Sales Territory Sales territory. Used by Lawson AR550
Accounts Receivable, Order Entry and
Sales Analysis systems.
ACM-AGING-CODE Numeric 2 AR10.1 AR501
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
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
Dishonored BOEs The 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
Reconciled BOEs The number of dishonored bills of
exchange that have been reconciled by
means of a cash payment.
ACM-RECONCILE-RNEG Signed 5.0 DT92.1
Rengotiated BOEs The total number of dishonored bills of
exchange that have been reconciled by
means of renegotiation.
ACM-RECONCILE-WO Signed 5.0 DT92.1
Written Off BOEs The 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
Dunning Cycle Code 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
Auto Remove 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
I Fin Min Chrg Minimum finance charge amount for an AR550
invoice.
ACM-CB-DTL-DATE Alpha 1 AR10.1 AR501
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
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
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
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
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
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
Dun Process Cd Dunning letter process code. A unique AR550
code that represents a combination of
Dunning Letter options.
ACM-LANGUAGE-CODE Alpha 10 AR10.1 AR501
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
Lst Dunltr Stm Dunning 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
Last Ltr Date Date last dunning letter was sent for
the invoice.
ACM-LST-LTRTEXT-CD Alpha 6 AR10.1 AR145
Lst Ltrtext Cd Text Code for last Dunning Letter sent
on this invoice.
ACM-ASSESS-DUN-FEE Alpha 1 AR10.1 AR501
Assess Dun Fee Dunning letter fee charged. Yes or No. AR550
Y = Yes
N = No
ACM-CU-NAME Alpha 30 AR10.1 AR501
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
Cu Addr1 Credit Union Address Line 1. AR550
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR10.1 AR501
Cu Addr2 Credit Union Address Line 2. AR550
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR10.1 AR501
Cu Addr3 Credit union address line 3. AR550
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR10.1 AR501
Cu Addr4 Credit union address line 4. AR550
ACM-CU-CITY Alpha 18 (Lower Case) AR10.1 AR501
Cu City Credit Union City. AR550
ACM-CU-STATE Alpha 2 AR10.1 AR501
Cu State Credit Union State. AR550
ACM-CU-POSTAL-CODE Alpha 12 AR10.1 AR501
Cu Postal Code Credit Union Postal Code. AR550
ACM-CU-COUNTRY-CD Alpha 2 AR10.1 AR501
Cu Country Cd Credit Union Country Code. AR550
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR10.1 AR501
Cu Country Credit Union Country. AR550
ACM-THIRD-PARTY Alpha 1 AR10.1 AR501
Third Party N = No third party payment AR550
Y = Third party payment allowed
ACM-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR10.1 AR501
E Mail Address AR550
ACM-URL-ADDR Alpha 60 (Lower Case) AR10.1 AR501
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
AP25.1 AP25.2
AP26.1 AP27.1
AR01.1 AR09.1
AR09.7 AR10.1
AR10.2 AR100
AR105 AR11.1
AR110 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR132 AR135
AR136 AR137
...
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 AR10.1
COMPANY with the same customer number in AR301 AR58.1
different companies.
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
BR210 BR211
BR220 BR420
BR450 BRIP.1
CB06.2 IC02.1
IC531 MX223
PBIP.1 PR197
TX140 TX40.1
WH110 WH120
WH130 WH132
...
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
Abassign ABASSIGN
ACM-COMPANY -> ASN-AR-COMPANY
ACM-CUSTOMER -> ASN-CUSTOMER
ASN-ASSIGNMENT
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
|