 |
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 AR01.1 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 BL04.1 BL121 BL123 BL125
BL202 BL204 BL217 BL220 BL231 BL246
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 BL530 BL546 BL80.1 BL80.3
BL802 BL81.1 BL82.1 BL85.1 BL85.2 BL90.1
BR10.1 BR11.1 BR120 BR121 BR210 BR211
BR220 BR420 BR450 BRIP.1 CB06.2 DT161
DT190 DT270 DT280 DT42.1 DT95.1 IC02.1
IC531 PR197 IN120 IN20.1 TX125 TX40.1
WH110 WH120 WH130 WH21.2 WH224 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 AR04.1
AR06.1 AR271
UPDATED BY
AR115 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
BL02.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACM-COMPANY Numeric 4 AR501 AR550
Company The accounts receivable company BL02.1 DT150
assigned to the customer.
ACM-CUSTOMER Alpha 9 (Right Justified) AR501 AR550
Customer The unique identifier assigned to the BL02.1 DT150
customer.
ACM-ACTIVE-STATUS Alpha 1 AR301 AR501
Active Status Indicates the status of the customer. AR550 BL02.1
Valid values are:
A = Active
I = Inactive
D = Set for deletion
ACM-NAT-FLAG Alpha 1 AR301 AR501
National Account Indicates whether the customer is a AR550 BL02.1
Flag national account customer. If a customer
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 AR501 AR550
Search Name The search name for the customer. BL02.1
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 AR501 AR550
Hold Code Indicates whether a customer is on AR70.2 BL02.1
hold.
ACM-CONTACT Alpha 20 AR501 AR550
Primary Contact Primary contact name for this customer. BL02.1
ACM-INT-PREFIX Alpha 6 AR501 AR550
International The international telephone number BL02.1
Telephone Prefix prefix.
ACM-PHONE-NMBR Alpha 15 AR501 AR550
Telephone Number The telephone number for this customer. BL02.1
ACM-PHONE-EXT Alpha 5 AR501 AR550
Telephone Extension The telephone extension number for the BL02.1
customer.
ACM-TELEX-NBR Alpha 15 AR501 AR550
Telex Number The telex number for the customer. BL02.1
ACM-EDI-NBR Alpha 15 AR501 AR550
EDI Number The electronic data interchange (EDI) BL02.1
number assigned to the customer. Used by
the Lawson Order Entry system or
external order processing systems.
ACM-ALT-EDI-NBR Alpha 95 AR501 AR550
Alternate EDI Number This is a free-form field to
accommodate an alternate EDI number or
address.
ACM-ALT-EDI-TYPE Alpha 5 AR501 AR550
Alternate EDI Type Indicates the type of the alternate EDI
number.
ACM-FAX-NMBR Alpha 15 AR501 AR550
Fax Number The customer's fax number. BL02.1
ACM-FAX-EXT Alpha 5 AR501 AR550
Fax Extension The customer's fax extension. BL02.1
ACM-START-DATE Numeric 8 (yyyymmdd) AR501 AR550
Start Date The date the customer first began doing BL02.1
business with the company. If left blank
when adding a customer, the system date
defaults.
ACM-CREDIT-ANLYST Alpha 4 AR501 AR550
Credit Analyst The credit analyst code assigned to BL02.1
this customer.
ACM-CURRENCY-CD Alpha 5 AR501 AR550
Currency Code The default currency in which the BL02.1
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 AR501 AR550
SalesRep The primary sales representative for BL02.1
this customer. This salesrep is used on
various programs for selection and
sorting.
ACM-RISK-CD Alpha 1 AR501 AR550
Risk Code The risk code is used for risk BL02.1
analysis. Defaults from the company.
ACM-DEFAULT-CODE Alpha 5 AR501 AR550
Default Code The customer default code is used to BL02.1
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 AR501 AR550
Major Class The major class assigned to this BL02.1
customer.
ACM-MIN-CLASS Alpha 4 AR501 AR550
Minor Class The minor class assigned to this BL02.1
customer.
ACM-CURR-BAL Signed 15.2 AR115 AR124
Current Balance The current balance for the customer. 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
DT30.2 DT40.1
...
ACM-DRAFT-BAL Signed 15.2 AR115 AR129
Bill of Exchange The bill of exchange balance for this AR13.1 AR13.2
Balance 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 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
DT90.1 DT92.1
ACM-OPEN-ORDS Signed 15.2 AR501 AR502
Open Order Total The total amount of orders that have AR560
been entered into an external order
processing system but have not yet been
invoiced.
ACM-ORDER-LIM Signed 15.0 AR501 AR550
Open Order Limit The limit for the total amount of open BL02.1
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 AR501 AR550
Credit Limit Total amount of credit extended to a BL02.1
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) AR501 AR550
Credit Limit Date The date the credit limit was defined AR70.2 BL02.1
or last reviewed.
ACM-CREDIT-REVDAYS Signed 3.0 AR501 AR550
Credit Review Days The number of days between the credit BL02.1
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 BL02.1
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: BL02.1
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
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 AR501 AR550
Age Disputes Specifies how disputed invoices will be BL02.1
aged. Valid values are:
N = Not aged - aged in current column
Y = Aged respective to GL date
ACM-DISPUTES-FIN Alpha 1 AR501 AR550
Finance Disputes Specifies if disputed invoices are BL02.1
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 AR501 AR550
Automatic Automatic cash application indicator. BL02.1
Application Valid values are:
N = No; no automatic application
Y = Yes; allows automatic application
ACM-AUTO-DUNN-FL Alpha 1 AR501 AR550
Automatic Dunning Indicates whether or not automatic BL02.1
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 AR501 AR550
Discount Grace Grace days added to discount date to BL02.1
Period allow or disallow discount during cash
application.
ACM-CR-VAR-PCT Numeric 3 AR501 AR550
Credit Variance Contains an optional override percent BL02.1
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 AR501 AR550
Memo Terms Memo terms code. Must be a valid net or BL02.1
prepayment type terms code defined in
the Lawson Terms system.
ACM-CHRGBK-PRT-FL Alpha 1 AR501 AR550
Print Chargebacks Specifies whether chargebacks will be BL02.1
printed. Valid values are:
N = No; don't print chargeback debit
memo
Y = Yes; print chargeback debit memos
ACM-OPEN-BAL-FWD Alpha 1 AR501 AR550
Open Item/Balance Processing of receivable records by BL02.1
Forward either open item or balance forward
methods. Valid values are:
B = Balance forward processing
O = Open Item processing
ACM-STATEMENT-REQ Alpha 1 AR501 AR550
Statement Required Statement required option. If BL02.1
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 AR501 AR550
Statement Cycle Used to group customers with like BL02.1
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 AR501 AR550
Lock Box The remit-to location of a lock box, BL02.1
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 AR501 AR550
Zero Statements Zero balance statement option. BL02.1
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 AR501 AR550
Credit Statements Credit balance statement option. BL02.1
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 AR501 AR550
Past Due Statements Past due open items only statement BL02.1
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 AR501 AR550
Over Credit Limit Over credit limit statement option. BL02.1
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 AR501 AR550
Max Automatic Write The maximum amount a payment may be BL02.1
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 AR501 AR550
Max Auto Write Off The maximum percentage allowed shortage BL02.1
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 AR501 AR550
Auto Write Off This reason code is required if there BL02.1
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 AR501 AR550
Discount Reason Code The default reason code for earned BL02.1
discounts for the customer. This must be
a valid code in AR15 (Operational Codes
(Reason)).
ACM-BANK-INST-CODE Alpha 3 AR501 AR550
Payment Code This will be the users normal method of BL02.1
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 AR501 AR550
Bill of Exchange If the customer has a default payment BL02.1
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 AR501 AR550
Accounts Receivable Default accounts receivable code for BL02.1
Code this customer used for record entry.
ACM-TERMS-CD Alpha 5 AR501 AR550
Terms Code The default terms code to be used BL02.1
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 AR501 AR550
Finance Charge Type Finance Charge Type. Indicates what BL02.1
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 AR501 AR550
Finance Charge Indicates what type of calculation will BL02.1
Calculation be used in calculating finance charges.
Valid values are:
D = Detail calculation method
N = Net calculation method
ACM-FIN-CHRG-CD Alpha 2 AR501 AR550
Finance Charge Code Finance charge code. This code must be BL02.1
predefined on AR07 (Finance Charge) and
will contain a monthly finance charge
percentage rate.
ACM-FIN-GRAC-DAYS Numeric 2 AR501 AR550
Finance Charge The number of grace days added to due BL02.1
Grace Days date before finance charges will be
assessed.
ACM-FIN-MIN-CHRG Signed 7.2 AR501 AR550
Minimum Finance The minimum finance charge amount BL02.1
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 AR501 AR550
Print Finance Specifies whether or not finance charge BL02.1
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 AR501 AR550
Tax Exempt Code Determines whether a customer is tax BL02.1
exempt or not. Used by the Lawson Order
Entry system. Valid values are:
T = Taxable
E = Exempt
ACM-TAX-CODE Alpha 10 AR501 AR550
Tax Code User-defined code which identifies the BL02.1 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 AR501 AR550
Sales Territory Sales territory. Used by Lawson BL02.1
Accounts Receivable, Order Entry and
Sales Analysis systems.
ACM-AGING-CODE Numeric 2 AR501 AR550
Aging Code Aging code. Indicates if there is a
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 AR501 AR550
Revalue Flag Indicates whether to revalue
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 AR501 AR550
Minimum Finance Used to determine if minimum finance BL02.1
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 AR501 AR550
Finance Charge Finance charge cycle code. Lets you BL02.1
Cycle Code control customer selection when you
generate finance charges.
ACM-DUN-CYCLE Alpha 2 AR501 AR550
Dunning Cycle Code Dunning cycle code. Lets you control BL02.1
customer selection when you generate
dunning notices.
ACM-AUTO-METHOD Alpha 1 AR501 AR550
Auto Cash Indicates the automatic cash BL02.1
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 AR501 AR550
Auto Remove This field determines whether payments AR700 BL02.1
and transactions can be removed
automatically.
N = No
Y = Yes
ACM-I-FIN-MIN-CHRG Signed 7.2 AR501 AR550
I Fin Min Chrg Minimum finance charge amount for an
invoice.
ACM-CB-DTL-DATE Alpha 1 AR501 AR550
Cb Dtl Date This field will be used to determine BL02.1
which dates are used to calculate
transaction and due dates for detail
chargebacks.
I = Invoice
P = Payment
ACM-VAT-CUST-TYPE Alpha 2 AR501 AR550
Vat Cust Type Indicates the type of customer for VAT BL02.1
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 AR501 AR550
Vat Reg Nbr The number component of the VAT BL02.1
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
ACM-VAT-REG-CTRY Alpha 2 AR501 AR550
Vat Reg Ctry The country component of the VAT BL02.1
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 AR501 AR550
Dun Ltr Ind Dunning letters in use for customer. BL02.1
Yes or No. This refers to the advanced
dunning letter process.
Y = Yes
N = No
ACM-DUN-PROCESS-CD Alpha 6 AR501 AR550
Dun Process Cd Dunning letter process code. A unique BL02.1
code that represents a combination of
Dunning Letter options.
ACM-LANGUAGE-CODE Alpha 10 AR501 AR550
Language Code The language code (locale) representing BL02.1
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 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 AR145
Lst Ltrtext Cd Text Code for last Dunning Letter sent
on this invoice.
ACM-ASSESS-DUN-FEE Alpha 1 AR501 AR550
Assess Dun Fee Dunning letter fee charged. Yes or No. BL02.1
Y = Yes
N = No
ACM-CU-NAME Alpha 30 AR501 AR550
Cu Name Optional credit agency name. Used if BL02.1
you are required to send a dunning
letter to a customer's credit agency.
ACM-CU-ADDR1 Alpha 30 (Lower Case) AR501 AR550
Cu Addr1 Credit Union Address Line 1. BL02.1
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR501 AR550
Cu Addr2 Credit Union Address Line 2. BL02.1
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR501 AR550
Cu Addr3 Credit union address line 3. BL02.1
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR501 AR550
Cu Addr4 Credit union address line 4. BL02.1
ACM-CU-CITY Alpha 18 (Lower Case) AR501 AR550
Cu City Credit Union City. BL02.1
ACM-CU-STATE Alpha 2 AR501 AR550
Cu State Credit Union State. BL02.1
ACM-CU-POSTAL-CODE Alpha 12 AR501 AR550
Cu Postal Code Credit Union Postal Code. BL02.1
ACM-CU-COUNTRY-CD Alpha 2 AR501 AR550
Cu Country Cd Credit Union Country Code. BL02.1
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR501 AR550
Cu Country Credit Union Country. BL02.1
ACM-THIRD-PARTY Alpha 1 AR501 AR550
Third Party N = No third party payment BL02.1
Y = Third party payment allowed
ACM-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR501 AR550
E Mail Address
ACM-URL-ADDR Alpha 60 (Lower Case) AR501 AR550
Url Addr
ARCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACMSET1 COMPANY This is the primary path used to access AC551 AR01.1
CUSTOMER customer records. AR100 AR105
AR11.1 AR110
AR115 AR124
AR129 AR13.1
AR13.2 AR130
AR131 AR132
AR135 AR136
AR137 AR140
AR141 AR145
AR150 AR155
AR160 AR161
AR17.1 AR170
AR180 AR190
AR191 AR194
...
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 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 AR219
EDI-NBR records by EDI number. AR48.1 AR48.3
KeyChange, Subset AR501 AR550
Where EDI-NBR != Spaces AR575 BL02.1
BL04.1 BL121
BL123 BL125
BL202 BL204
BL217 BL220
BL231 BL246
BL290 BL291
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL33.1
BL331 BL34.1
...
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
|