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 are defined and maintained in this record. Statistical fields
and other processing fields are also contained on this record.
REFERENCED BY
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 AR01.1 AR100 AR105 AR11.1 AR110
AR132 AR136 AR140 AR155 AR160 AR191
AR196 AR209 AR210 AR211 AR217 AR219
AR222 AR223 AR227 AR228 AR229 AR23.1
AR23.2 AR23.3 AR23.4 AR230 AR232 AR233
AR234 AR235 AR237 AR238 AR239 AR245
AR25.1 AR25.2 AR250 AR251 AR253 AR255
AR257 AR258 AR260 AR261 AR264 AR265
AR271 AR274 AR275 AR282 AR285 AR286
AR290 AR291 AR292 AR293 AR294 AR296
AR300 AR50.1 AR504 AR510 AR515 AR53.1
AR58.1 AR72.1 AR74.1 AR75.1 AR90.1 BL04.1
BL10.1 BL121 BL123 BL125 BL202 BL204
BL217 BL220 BL231 BL232 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 BL81.1
BL82.1 BL85.1 BL85.2 BL90.1 BR00.1 BR00.2
BR02.1 BR02.3 BR10.1 BR10.9 BR11.1 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR155 BR156 BR16.1 BR16.2 BR17.1 BR180
BR19.1 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR20.7 BR21.1 BR21.2 BR210 BR211 BR216
BR217 BR220 BR251 BR252 BR253 BR400
BR420 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR51.1 BR51.2 BR52.1 BR52.2 BR521 BR53.1
BR55.1 BR55.2 BR56.1 BR70.1 BR70.2 BR91.1
BRIP.1 DT161 DT190 DT270 DT280 DT42.1
DT95.1 IC02.1 MX123 MX500 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POID.1
POII.1 POIJ.1 PW110 RQ10.1 RQ10.2 IN120
IN20.1 TX125 TX40.1 WH110 WH120 WH130
WH132 WH190 WH21.2 WH224 WH226 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 MX223 AR04.1 AR06.1
UPDATED BY
AR09.1 AR10.1 AR10.2 AR112 AR115 AR12.1
AR12.2 AR120 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.8 AR301 AR32.1 AR33.1 AR33.3 AR33.6
AR34.1 AR35.1 AR35.2 AR37.1 AR37.2 AR37.3
AR37.4 AR37.5 AR37.6 AR37.7 AR38.1 AR38.2
AR38.3 AR39.1 AR39.2 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR45.1 AR48.3 AR501
AR502 AR503 AR505 AR506 AR520 AR550
AR560 AR570 AR575 AR580 AR70.2 AR80.1
AR80.2 AR800 AR82.1 ARI1.1 ARLL.1 BL02.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL802 BL820
BL92.1 CB06.2 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 PW550 TX140 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACM-COMPANY Numeric 4 AR09.1 AR10.1
Element: Company The accounts receivable company AR301 AR501
assigned to the customer. AR550 BL02.1
BL802 DT150
PW550 TX140
ACM-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer The unique identifier assigned to the AR301 AR501
customer. AR550 BL02.1
BL802 DT150
PW550 TX140
ACM-ACTIVE-STATUS Alpha 1 AR09.1 AR10.1
Element: Active Status Indicates the status of the customer. AR120 AR301
Valid values are: AR501 AR550
BL02.1 BL802
A = Active PW550 TX140
I = Inactive
D = Set for deletion
ACM-NAT-FLAG Alpha 1 AR09.1 AR10.1
National Account Indicates whether the customer is a AR112 AR12.1
Flag national account customer. If a customer AR12.2 AR301
is a national account customer, it AR501 AR550
cannot be an invoiced customer to BL02.1 BL802
another national account. Valid values PW550 TX140
are:
I = Invoiced customer
N = National account
Blank = Not part of a national account
ACM-SEARCH-NAME Alpha 30 AR09.1 AR10.1
Element: Search Name The search name for the customer. AR301 AR501
Reports can be sequenced using this AR550 BL02.1
field. If left blank when adding the BL802 PW550
customer, the search name defined in TX140
AR09.1 (Customer Group Address)
defaults.
ACM-HOLD-CODE Alpha 4 AR09.1 AR10.1
Element: Hold Code Indicates whether a customer is on AR301 AR501
hold. AR550 AR70.2
BL02.1 BL802
PW550 TX140
ACM-CONTACT Alpha 20 AR09.1 AR10.1
Element: Primary ContacPrimary contact name for this customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-INT-PREFIX Alpha 6 AR09.1 AR10.1
International The international telephone number AR301 AR501
Telephone Prefix prefix. AR550 BL02.1
BL802 PW550
TX140
ACM-PHONE-NMBR Alpha 15 AR09.1 AR10.1
Element: Telephone NumbThe telephone number for this customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-PHONE-EXT Alpha 5 AR09.1 AR10.1
Element: Telephone ExteThe telephone extension number for the AR301 AR501
customer. AR550 BL02.1
BL802 PW550
TX140
ACM-TELEX-NBR Alpha 15 AR09.1 AR10.1
Element: Telex Number The telex number for the customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-EDI-NBR Alpha 15 AR09.1 AR10.1
Element: EDI Number The electronic data interchange (EDI) AR301 AR501
number assigned to the customer. Used by AR550 BL02.1
the Lawson Order Entry system or BL802 PW550
external order processing systems. TX140
ACM-ALT-EDI-NBR Alpha 95 AR09.1 AR10.1
Element: Alternate EDI This is a free-form field to AR301 AR501
accommodate an alternate EDI number or AR550 BL02.1
address. BL802 PW550
TX140
ACM-ALT-EDI-TYPE Alpha 5 AR09.1 AR10.1
Element: Alternate EDI Indicates the type of the alternate EDI AR301 AR501
number. AR550 BL02.1
BL802 PW550
TX140
ACM-FAX-NMBR Alpha 15 AR09.1 AR10.1
Element: Fax Number The customer's fax number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-FAX-EXT Alpha 5 AR09.1 AR10.1
Element: Fax Extension The customer's fax extension. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-START-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Start Date The date the customer first began doing AR301 AR501
business with the company. If left blank AR550 BL02.1
when adding a customer, the system date BL802 PW550
defaults. TX140
ACM-CREDIT-ANLYST Alpha 4 AR09.1 AR10.1
Element: Credit AnalystThe credit analyst code assigned to AR120 AR301
this customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-CURRENCY-CD Alpha 5 AR09.1 AR10.1
Element: Currency Code The default currency in which the AR120 AR301
customer will be invoiced. If the AR501 AR550
company has Yes selected the Currency BL02.1 BL802
Override field in AR01 (Company), this PW550 TX140
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 AR09.1 AR10.1
Element: SalesRep The primary sales representative for AR120 AR301
this customer. This salesrep is used on AR501 AR550
various programs for selection and BL02.1 BL802
sorting. PW550 TX140
ACM-RISK-CD Alpha 1 AR09.1 AR10.1
Element: Risk Code The risk code is used for risk AR120 AR301
analysis. Defaults from the company. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-DEFAULT-CODE Alpha 5 AR09.1 AR10.1
Element: Default Code The customer default code is used to AR301 AR501
default values and options into the AR550 BL02.1
customer record when the customer is BL802 PW550
added into the system. This field is TX140
required and must be a valid default
code defined in AR08 (Customer
Defaults).
ACM-MAJ-CLASS Alpha 4 AR09.1 AR10.1
Element: Major Class The major class assigned to this AR120 AR301
customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-MIN-CLASS Alpha 4 AR09.1 AR10.1
Element: Minor Class The minor class assigned to this AR120 AR301
customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-CURR-BAL Signed 18.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.8
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR505
AR560 AR570
AR575 AR580
AR80.1 AR80.2
AR800 AR82.1
...
ACM-DRAFT-BAL Signed 18.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
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR505 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
...
ACM-OPEN-ORDS Signed 18.2 AR09.1 AR10.1
Element: Open Order TotThe total amount of orders that have AR115 AR129
been entered into an external order AR130 AR131
processing system but have not yet been AR135 AR137
invoiced. AR180 AR190
AR301 AR501
AR502 AR550
AR560 AR800
AR82.1 ARLL.1
BL02.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL802
BL820 BL92.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT520
PW550 TX140
WH20.7
ACM-ORDER-LIM Signed 15.0 AR09.1 AR10.1
Element: Open Order LimThe limit for the total amount of open AR301 AR501
orders allowed for this customer. Zero AR550 BL02.1
means the order amount is not limited. BL802 PW550
This value is maintained in the Lawson TX140
Accounts Receivable system and is used
by external order processing systems.
ACM-CREDIT-LIM Signed 15.0 AR09.1 AR10.1
Element: Credit Limit Total amount of credit extended to a AR301 AR501
customer. Zero means unlimited credit is AR550 BL02.1
extended to this customer. This value is BL802 PW550
maintained in the Lawson Accounts TX140
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) AR09.1 AR10.1
Element: Credit Limit DThe date the credit limit was defined AR301 AR501
or last reviewed. AR550 AR70.2
BL02.1 BL802
PW550 TX140
ACM-CREDIT-REVDAYS Signed 3.0 AR09.1 AR10.1
Element: Credit Review The number of days between the credit AR120 AR301
limit reviews for the customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-LAST-PMT-AMT Signed 18.2 AR09.1 AR10.1
Element: Last Payment AThe amount of the last payment made by AR115 AR124
this customer. AR13.1 AR13.2
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR301 AR32.1
AR34.1 AR501
AR503 AR550
AR570 AR575
AR580 BL02.1
BL802 CB191
DT170 DT180
DT181 PW550
TX140
ACM-LAST-PMT-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Last Payment DThe date of the last payment made by AR115 AR124
the customer. AR13.1 AR13.2
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR30.1
AR301 AR32.1
AR34.1 AR501
AR503 AR550
AR570 AR575
AR580 BL02.1
BL802 CB191
DT170 DT180
DT181 PW550
TX140
ACM-LAST-INV-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Last Invoice DThe date of the last (most recent date) AR115 AR129
invoice for this customer. AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR301
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR550 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 BL02.1
BL802 CB06.2
...
ACM-LAST-INV-AMT Signed 18.2 AR09.1 AR10.1
Element: Intl Amt The amount of the last (most recent AR115 AR129
date) invoice for this customer. AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR301
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR550 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 BL02.1
BL802 CB06.2
...
ACM-LAST-STA-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Last StatementThe date of the last statement for this AR150 AR301
customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-LAST-STA-BAL Signed 18.2 AR09.1 AR10.1
Last Statement The customer's balance on their last AR150 AR301
Balance statement. AR501 AR520
AR550 BL02.1
BL802 PW550
TX140
ACM-REVIEW-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Review Date The last date the customer was defined AR17.1 AR301
for review. AR17 (Comments) and AR70 AR501 AR550
(Analyst Customer Review) are used to AR70.2 BL02.1
define this date. AR170 (Customer Review BL802 PW550
Selection) selects the customer when TX140
this date is reached.
ACM-REVIEW-CODE Alpha 1 AR09.1 AR10.1
Element: Review Code Indicates the status of the customer's AR17.1 AR170
review record. Valid values are: AR301 AR501
AR550 AR70.2
O = Open BL02.1 BL802
R = Reviewed PW550 TX140
ACM-HIGH-BAL Signed 15.0 Occurs 13 Times AR09.1 AR10.1
Element: Highest BalancThe highest balance for the customer AR115 AR129
for the period. AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR301 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR550
AR560 AR80.1
AR80.2 AR800
AR82.1 ARLL.1
BL02.1 BL802
...
ACM-PER-RTMS Signed 3.0 Occurs 13 Times AR09.1 AR10.1
Element: Period RTMs Period Return-to-Maker debit memos. The AR115 AR129
number of payments that have been AR13.1 AR13.2
returned to the customer for the period. AR130 AR131
AR135 AR137
AR180 AR190
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR301 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR550
AR560 AR80.1
AR80.2 AR800
AR82.1 ARLL.1
BL02.1 BL802
...
ACM-PAID-PRMPT Signed 5.0 Occurs 12 Times AR09.1 AR10.1
Element: Paid Prompt The number of invoices that were paid AR190 AR194
in full within the due date of the AR199 AR301
invoice (incorporating grace days). AR501 AR550
Invoices cleared by chargebacks are not BL02.1 BL802
considered. PW550 TX140
ACM-INV-PAID Signed 5.0 Occurs 12 Times AR09.1 AR10.1
Element: Paid Invoices A count of invoices fully paid within AR190 AR194
the period. This will be used in the AR199 AR301
Invoice Payment Average (IPA) and Days AR501 AR550
Beyond Terms (DBT) calculations for each BL02.1 BL802
customer. PW550 TX140
ACM-COLLECT-DAYS Signed 3.0 Occurs 11 Times AR09.1 AR10.1
Element: Collect Days A collection ratio of days to collect AR194 AR301
those invoices that have been fully paid AR501 AR550
in a specific period. It will include BL02.1 BL802
invoices and only debit memos generated PW550 TX140
from chargebacks. This will be a
weighted calculation based on the amount
of invoice.
ACM-CURR-CASH Signed 18.2 AR09.1 AR10.1
Element: Current Cash The cash paid amount from fully paid AR190 AR194
transactions. At the end of a current AR301 AR501
period, it will be used to calculate the AR550 BL02.1
ratio for the Collect Days field. BL802 PW550
TX140
ACM-CURR-CSH-DAYS Signed 18.2 AR09.1 AR10.1
Element: Current Cash DThe Flow of Funds Cash Days calculated AR190 AR194
value (paid amount multiplied by the AR301 AR501
number of days to fully pay) for the AR550 BL02.1
current period. BL802 PW550
TX140
ACM-YTD-CASH Signed 18.2 AR09.1 AR10.1
Element: Year-to-Date CThe year-to-date total of cash for AR190 AR199
fully paid transactions. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-YTD-CSH-DAYS Signed 18.2 AR09.1 AR10.1
Year-to-Date Cash The year to date calculation of cash AR190 AR199
Days paid and applied to an open item times AR301 AR501
the number of days it took to fully pay AR550 BL02.1
the transactions. BL802 PW550
TX140
ACM-YEAR-2-DAYS Signed 3.0 AR09.1 AR10.1
Element: Previous Year The weighted invoice payment average AR199 AR301
for the year previous to the totals AR501 AR550
being tallied in "COLLECT DAYS" period BL02.1 BL802
buckets. PW550 TX140
ACM-STATIC-CUR Signed 18.2 AR09.1 AR10.1
Current Static The static current portion of a AR194 AR301
Balance customer's balance as of the last AR501 AR550
running of AR194 (Audit Summary). BL02.1 BL802
PW550 TX140
ACM-AGING Signed 18.2 Occurs 5 Times AR09.1 AR10.1
Element: Aging These aging buckets carry the static AR194 AR301
past-due amounts in each aging period AR501 AR550
for a given customer. These fields are BL02.1 BL802
updated by AR194 (Audit Summary). PW550 TX140
ACM-LAST-COMMENT Numeric 6 AR115 AR129
Element: Last Comment The last sequence number for comment AR13.1 AR13.2
uniqueness purposes. AR130 AR131
AR135 AR137
AR141 AR161
AR17.1 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR503
AR506 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
...
ACM-DISP-NBR Signed 3.0 AR190 AR29.3
Element: Disputed ItemsThe number of open items currently in AR38.1 AR38.2
dispute. AR38.3 AR45.1
AR506
ACM-DISP-AMT Signed 18.2 AR190 AR29.3
Element: Disputed AmounThe total amount in dispute for this AR38.1 AR38.2
customer. AR38.3 AR45.1
AR506
ACM-PL-EXCL-FL Alpha 1 AR09.1 AR10.1
Process Level Indicates if the invoices being entered AR10.2 AR301
Restrictions on this customer's account should be AR501 AR550
checked for inclusions or exclusions for BL02.1 BL802
the specified process level. Valid PW550 TX140
values are:
Blank = No process level restrictions
I = Process level restriction
ACM-AGE-DISPUTES Alpha 1 AR09.1 AR10.1
Element: Age Disputes Specifies how disputed invoices will be AR120 AR301
aged. Valid values are: AR501 AR550
BL02.1 BL802
N = Not aged - aged in current column PW550 TX140
Y = Aged respective to GL date
ACM-DISPUTES-FIN Alpha 1 AR09.1 AR10.1
Element: Finance DisputSpecifies if disputed invoices are AR120 AR301
exempt from being assessed finance AR501 AR550
charges. Valid values are: BL02.1 BL802
PW550 TX140
N = No; not subject to finance charges
Y = Yes; subject to finance charges
ACM-AUTO-APP-FL Alpha 1 AR09.1 AR10.1
Automatic Automatic cash application indicator. AR120 AR301
Application Valid values are: AR501 AR550
BL02.1 BL802
N = No; no automatic application PW550 TX140
Y = Yes; allows automatic application
ACM-AUTO-DUNN-FL Alpha 1 AR09.1 AR10.1
Automatic Dunning Indicates whether or not automatic AR120 AR301
Letters selection for dunning letters will be AR501 AR550
allowed. Valid values are: BL02.1 BL802
PW550 TX140
N = No; no automatic selection
Y = Yes; allow automatic selection
ACM-DISC-GRACE-PD Numeric 2 AR09.1 AR10.1
Discount Grace Grace days added to discount date to AR120 AR301
Period allow or disallow discount during cash AR501 AR550
application. BL02.1 BL802
PW550 TX140
ACM-CR-VAR-PCT Numeric 3 AR09.1 AR10.1
Credit Variance Contains an optional override percent AR301 AR501
Percent that will be used in customer credit AR550 BL02.1
limit selections. If left blank, BL802 PW550
selection will be based on report TX140
parameter entered percentage. If the
field contains a percent, this will
override the report parameter.
ACM-MEMO-TERM Alpha 5 AR09.1 AR10.1
Element: Memo Terms Memo terms code. Must be a valid terms AR120 AR301
code defined in the Lawson Terms AR501 AR550
system. BL02.1 BL802
PW550 TX140
ACM-CHRGBK-PRT-FL Alpha 1 AR09.1 AR10.1
Element: Print ChargebaSpecifies whether chargebacks will be AR120 AR301
printed. Valid values are: AR501 AR550
BL02.1 BL802
N = No; don't print chargeback debit PW550 TX140
memo
Y = Yes; print chargeback debit memos
ACM-OPEN-BAL-FWD Alpha 1 AR09.1 AR10.1
Open Item/Balance Processing of receivable records by AR120 AR301
Forward either open item or balance forward AR501 AR550
methods. Valid values are: BL02.1 BL802
PW550 TX140
B = Balance forward processing
O = Open Item processing
ACM-STATEMENT-REQ Alpha 1 AR09.1 AR10.1
Element: Statement RequStatement required option. If AR120 AR301
statements are required, the default AR501 AR550
selection criteria will include current, BL02.1 BL802
past due and credit open items. Zero PW550 TX140
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 AR09.1 AR10.1
Element: Statement CyclUsed to group customers with like AR120 AR301
statement cycles for statement AR501 AR550
processing. The statement cycle code BL02.1 BL802
will be assigned for balance forward PW550 TX140
type customers via the first letter of
the company customer level search name.
ACM-LOCK-BOX Alpha 2 AR09.1 AR10.1
Element: Lock Box The remit-to location of a lock box, AR120 AR301
used for payment receipts. If entered, AR501 AR550
it must be a valid lock box code. If BL02.1 BL802
left blank, the company name and address PW550 TX140
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 AR09.1 AR10.1
Element: Zero StatementZero balance statement option. AR301 AR501
Determines whether or not a customer AR550 BL02.1
will receive a statement when there is BL802 PW550
no unapplied transactions and a balance TX140
of zero. Valid values are:
N = No; don't produce zero statements
Y = Yes; produce zero statements
ACM-CRED-STMNT-FL Alpha 1 AR09.1 AR10.1
Element: Credit StatemeCredit balance statement option. AR301 AR501
Determines whether or not a customer AR550 BL02.1
should receive a statement if their BL802 PW550
balance nets to a credit amount. Valid TX140
values are:
N = No; don't produce credit statements
Y = Yes; produce credit statements
ACM-PAST-STMNT-FL Alpha 1 AR09.1 AR10.1
Element: Past Due StatePast due open items only statement AR301 AR501
option. If this option is Yes, only past AR550 BL02.1
due open items will print on the BL802 PW550
customer's statement. Valid values are: TX140
N = Do not produce only past-due
statements
Y = Produce only past-due statements
ACM-OVER-STMNT-FL Alpha 1 AR09.1 AR10.1
Over Credit Limit Over credit limit statement option. AR301 AR501
Statements If Yes is chosen, statements will only AR550 BL02.1
be printed for customers whose balances BL802 PW550
exceed their credit limit. Valid values TX140
are:
N = Do not produce only balance
exceeding credit limit statements
Y = Produce only balance exceeding
credit limit statements
ACM-MAX-AUTO-AMT Signed 18.2 Occurs 3 Times AR09.1 AR10.1
Max Automatic Write The maximum amount a payment may be AR301 AR501
Off Amount short of a particular invoice during AR550 BL02.1
cash application and the system will BL802 PW550
automatically write-off the difference TX140
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 AR09.1 AR10.1
Max Auto Write Off The maximum percentage allowed shortage AR301 AR501
Percent amount during cash application that will AR550 BL02.1
be automatically adjusted. This is one BL802 PW550
of three fields that may be used for TX140
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 AR09.1 AR10.1
Auto Write Off This reason code is required if there AR301 AR501
Reason Code is a short amount or percent allowed for AR550 BL02.1
automatic write-offs for the customer. BL802 PW550
This will allow tracking adjustment TX140
records by their reason codes.
ACM-DISC-REAS-CD Alpha 4 AR09.1 AR10.1
Element: Discount ReasoThe default reason code for earned AR120 AR301
discounts for the customer. This must be AR501 AR550
a valid code in AR15 (Operational Codes BL02.1 BL802
(Reason)). PW550 TX140
ACM-BANK-INST-CODE Alpha 3 AR09.1 AR10.1
Element: Payment Code A transaction code representing a type AR120 AR301
of cash payment (with atributes for AR501 AR550
either receiving AP payments, or BL02.1 BL802
creating EFT payments), bill of PW550 TX140
exchange payment, or bank service
transaction.
ACM-DRAFT-FLAG Alpha 1 AR09.1 AR10.1
Bill of Exchange If the customer has a default payment AR301 AR501
Creation code type of D (Bill of Exchange), this AR550 BL02.1
flag will indicate if the bills of BL802 PW550
exchange should be created in summary or TX140
individually (1 BOE for 1 Invoice).
Valid values are:
Blank = Not paying by BOE, Default
I = Individual
S = Summary
ACM-AR-CODE Alpha 4 AR09.1 AR10.1
Accounts Receivable Default accounts receivable code for AR120 AR301
Code this customer used for record entry. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-TERMS-CD Alpha 5 AR09.1 AR10.1
Element: Terms Code The default terms code to be used AR120 AR301
during invoicing for this customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-TERMS-CASH Signed 18.2 AR09.1 AR10.1
Element: Cash Paid AmouThe cash paid amount from fully paid AR190 AR194
transactions. At the end of a current AR301 AR501
period, it will be used to calculate DBT AR550 BL02.1
(Days Beyond Terms). BL802 PW550
TX140
ACM-TERMS-CSH-DAYS Signed 18.2 AR09.1 AR10.1
Element: Cash Days The flow of funds cash days calculated AR190 AR194
value (paid amount multiplied by the AR301 AR501
number of days from due date to fully AR550 BL02.1
pay) for the current period. BL802 PW550
TX140
ACM-DBT-RATIO Signed 3.0 Occurs 11 Times AR09.1 AR10.1
Element: Days Beyond TeDays Beyond Terms Indicator. Used in AR194 AR301
customer credit analysis. Calculation is AR501 AR550
identical to IPA calculation, however BL02.1 BL802
invoice due date is used instead of PW550 TX140
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 AR09.1 AR10.1
Element: Previous Year This year's Days Beyond Terms indicator AR199 AR301
calculated at the end of the year by AR501 AR550
AR199 (Period Closing). BL02.1 BL802
PW550 TX140
ACM-DBT-YTD-CASH Signed 18.2 AR09.1 AR10.1
DBT YTD Cash Paid The cash paid amount from fully paid AR190 AR199
Amount transactions for the year. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-DBT-YTD-DAYS Signed 18.2 AR09.1 AR10.1
Element: DBT YTD Cash DA running total of the year's Flow of AR190 AR199
Fund Cash Days calculated value (paid AR301 AR501
invoice amount multiplied by the number AR550 BL02.1
of days from Due Date to fully paid). BL802 PW550
TX140
ACM-LATE-PAY-FL Alpha 1 AR09.1 AR10.1
Element: Finance ChargeFinance Charge Type. Indicates what AR301 AR501
type of charges will be assessed. Valid AR550 BL02.1
values are: BL802 PW550
TX140
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 AR09.1 AR10.1
Finance Charge Indicates what type of calculation will AR301 AR501
Calculation be used in calculating finance charges. AR550 BL02.1
Valid values are: BL802 PW550
TX140
D = Detail calculation method
N = Net calculation method
ACM-FIN-CHRG-CD Alpha 2 AR09.1 AR10.1
Element: Finance ChargeFinance charge code. This code must be AR301 AR501
predefined on AR07 (Finance Charge) and AR550 BL02.1
will contain a monthly finance charge BL802 PW550
percentage rate. TX140
ACM-FIN-GRAC-DAYS Numeric 2 AR09.1 AR10.1
Finance Charge The number of grace days added to due AR301 AR501
Grace Days date before finance charges will be AR550 BL02.1
assessed. BL802 PW550
TX140
ACM-FIN-MIN-CHRG Signed 7.2 AR09.1 AR10.1
Minimum Finance The minimum finance charge amount AR301 AR501
Charge assessed if calculated finance charge is AR550 BL02.1
less than minimum. If minimum is zero, BL802 PW550
there will be no override. TX140
ACM-FIN-DOC-PRNT Alpha 1 AR09.1 AR10.1
Print Finance Specifies whether or not finance charge AR301 AR501
Charge Documents documents are required to be printed. AR550 BL02.1
Valid values are: BL802 PW550
TX140
N = No; do not print finance charge
documents
Y = Yes; print finance charge document
ACM-LAST-DUNN Numeric 2 AR09.1 AR10.1
Element: Last Dunning NThe last dunning letter number produced AR161 AR301
for the customer. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Last Dunning DThe date of the last dunning letter AR141 AR161
produced for the customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-LAST-DUN-AMT Signed 18.2 AR09.1 AR10.1
Element: Intl Amt The amount of the last duning letter. AR141 AR161
AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-TAX-EXEMPT-CD Alpha 1 AR09.1 AR10.1
Element: Tax Exempt CodDetermines whether a customer is tax AR301 AR501
exempt or not. Used by the Lawson Order AR550 BL02.1
Entry system. Valid values are: BL802 PW550
TX140
T = Taxable
E = Exempt
ACM-TAX-CODE Alpha 10 AR09.1 AR10.1
Element: Tax Code User-defined code which identifies the AR301 AR501
default taxing authority this customer AR550 BL02.1
pays taxes to. Used by Lawson Order BL802 PW550
Entry system. Must be valid in the TX140
Lawson Tax system.
ACM-TERRITORY Alpha 4 AR09.1 AR10.1
Element: Sales TerritorSales territory. Used by Lawson AR120 AR301
Accounts Receivable, Order Entry and AR501 AR550
Sales Analysis systems. BL02.1 BL802
PW550 TX140
ACM-AGING-CODE Numeric 2 AR09.1 AR10.1
Element: Aging Code Aging code. Indicates if there is a AR120 AR301
customer level aging override present. AR501 AR550
If this field is greater than zero, the BL02.1 BL802
customer's aging code will override the PW550 TX140
company default aging periods and aging
rules in selected programs.
ACM-REVALUE-FL Alpha 1 AR09.1 AR10.1
Element: Revalue Flag Indicates whether to revalue AR120 AR301
transaction currencies against the AR501 AR550
company base currency to account for BL02.1 BL802
exchange rate fluctuations. Valid values PW550 TX140
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 18.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 AR09.1 AR10.1
Minimum Finance Used to determine if minimum finance AR301 AR501
Charge charges are to be used. Valid values AR550 BL02.1
are: BL802 PW550
TX140
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 AR09.1 AR10.1
Finance Charge Finance charge cycle code. Lets you AR301 AR501
Cycle Code control customer selection when you AR550 BL02.1
generate finance charges. BL802 PW550
TX140
ACM-DUN-CYCLE Alpha 2 AR09.1 AR10.1
Element: Dunning Cycle Dunning cycle code. Lets you control AR120 AR301
customer selection when you generate AR501 AR550
dunning notices. BL02.1 BL802
PW550 TX140
ACM-AUTO-METHOD Alpha 1 AR09.1 AR10.1
Auto Cash Indicates the automatic cash AR120 AR301
Application Method application method for this customer. AR501 AR550
Valid values are: BL02.1 BL802
PW550 TX140
A = Algorithm
B = Balance forward
L = Last statement
R = Remittance
" " = None
ACM-AUTO-REMOVE Alpha 1 AR09.1 AR10.1
Element: Auto Remove This field determines whether payments AR120 AR301
and transactions can be removed AR501 AR550
automatically. BL02.1 BL802
N = No PW550 TX140
Y = Yes
ACM-I-FIN-MIN-CHRG Signed 7.2 AR09.1 AR10.1
Element: I Fin Min ChrgMinimum finance charge amount for an AR301 AR501
invoice. AR550 BL02.1
BL802 PW550
TX140
ACM-CB-DTL-DATE Alpha 1 AR09.1 AR10.1
Element: Cb Dtl Date This field will be used to determine AR120 AR301
which dates are used to calculate AR501 AR550
transaction and due dates for detail BL02.1 BL802
chargebacks. PW550 TX140
I = Invoice
P = Payment
ACM-VAT-CUST-TYPE Alpha 2 AR09.1 AR10.1
Element: Vat Cust Type Indicates the type of customer for VAT AR301 AR501
reporting. This field is required for AR550 BL02.1
all customers if the AR company BL802 PW550
indicates that VAT Reporting is TX140
required.
DM = Domestic
ER = EEC-Registered
EU = EEC-Unregistered
XP = Export
ACM-VAT-REG-NBR Alpha 12 AR09.1 AR10.1
Element: Vat Reg Nbr The number component of the VAT AR301 AR501
Registration Number. This field together AR550 BL02.1
with the Registration Country field make BL802 PW550
up the VAT Registration Number. TX140
ACM-VAT-REG-CTRY Alpha 2 AR09.1 AR10.1
Element: Vat Reg Ctry The country component of the VAT AR301 AR501
Registration Number. This field, AR550 BL02.1
together with the Registration Number BL802 PW550
for the company on the tax transaction. TX140
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 AR09.1 AR10.1
Element: Dun Ltr Ind Dunning letters in use for customer. AR301 AR501
Yes or No. This refers to the advanced AR550 BL02.1
dunning letter process. BL802 PW550
TX140
Y = Yes
N = No
ACM-DUN-PROCESS-CD Alpha 6 AR09.1 AR10.1
Element: Dun Process CdDunning letter process code. A unique AR301 AR501
code that represents a combination of AR550 BL02.1
Dunning Letter options. BL802 PW550
TX140
ACM-LANGUAGE-CODE Alpha 10 AR09.1 AR10.1
Element: Language Code The language code (locale) representing AR301 AR501
the customer's preferred language. If AR550 BL02.1
no language code is specified, the BL802 PW550
environment base language is assumed TX140
which is always U.S. English.
ACM-LST-DUNLTR-STM Numeric 2 AR09.1 AR10.1
Element: Lst Dunltr StmDunning level of the last dunning AR145 AR301
letter sent. Refers to a level of AR501 AR550
processing within the dunning process BL02.1 BL802
code. PW550 TX140
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 AR09.1 AR10.1
Element: Lst Ltrtext CdText Code for last Dunning Letter sent AR145 AR301
on this invoice. AR501 AR550
BL02.1 BL802
PW550 TX140
ACM-ASSESS-DUN-FEE Alpha 1 AR09.1 AR10.1
Element: Assess Dun FeeDunning letter fee charged. Yes or No. AR301 AR501
Y = Yes AR550 BL02.1
N = No BL802 PW550
TX140
ACM-CU-NAME Alpha 30 AR09.1 AR10.1
Element: Cu Name Optional credit agency name. Used if AR301 AR501
you are required to send a dunning AR550 BL02.1
letter to a customer's credit agency. BL802 PW550
TX140
ACM-CU-ADDR1 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr1 Credit Union Address Line 1. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr2 Credit Union Address Line 2. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr3 Credit union address line 3. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr4 Credit union address line 4. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-CITY Alpha 18 (Lower Case) AR09.1 AR10.1
Element: Cu City Credit Union City. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-STATE Alpha 2 AR09.1 AR10.1
Element: Cu State Credit Union State. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-POSTAL-CODE Alpha 12 AR09.1 AR10.1
Element: Cu Postal CodeCredit Union Postal Code. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-COUNTRY-CD Alpha 2 AR09.1 AR10.1
Element: Cu Country Cd Credit Union Country Code. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Country Credit Union Country. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-THIRD-PARTY Alpha 1 AR09.1 AR10.1
Element: Third Party Indicates if this customer's payments AR301 AR501
can be applied to open item transactions AR550 BL02.1
regardless of the customer involved. BL802 PW550
N = No third party payment TX140
Y = Third party payment allowed
ACM-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR09.1 AR10.1
Element: Email Address The Email address for this customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-URL-ADDR Alpha 60 (Lower Case) AR09.1 AR10.1
Element: Url Addr The URL address for this customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-CUST-AUDIT Alpha 1 AR09.1 AR10.1
Element: Cust Audit Indicates whether customer changes will AR120 AR301
be tracked. Valid values are: AR501 AR550
BL02.1 BL802
N = No customer audit PW550 TX140
Y = Customer audit
ACM-APPLY-MIXED Alpha 1 AR09.1 AR10.1
Element: Apply Mixed Indicates if transactions with mixed AR120 AR301
signed line items will have credit lines AR501 AR550
applied to debit lines upon transaction BL02.1 BL802
interface and transaction release. PW550 TX140
Valid values are:
N = No
Y = Yes
ACM-OBJ-ID Numeric 12 AR09.1 AR10.1
Element: Obj Id This is the object identifier that is AR301 AR501
used to relate to customer attributes. AR550 BL02.1
Customer attributes are used to help BL802 PW550
formulate customer lists used for TX140
reporting purposes.
ACM-PAY-AUTO-AMT Signed 18.2 AR09.1 AR10.1
Element: Intl Amt AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-PAY-AUTO-PCT Signed 5.5 AR09.1 AR10.1
Element: Max Auto Pct AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ACM-PAY-REAS-CD Alpha 4 AR09.1 AR10.1
Element: Auto Reas Cd AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
ARCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACMSET1 COMPANY AC56.1 AC560
CUSTOMER AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR01.1
AR09.1 AR09.7
AR10.1 AR10.2
AR100 AR105
AR11.1 AR110
AR112 AR115
...
ACMSET2 COMPANY KeyChange AR209 AR210
SEARCH-NAME
CUSTOMER
ACMSET3 CUSTOMER AR09.1 AR12.1
COMPANY AR12.2 AR301
AR58.1
ACMSET4 OBJ-ID Subset AR120 AR129
Where OBJ-ID != Zeroes AR130 AR131
AR135 AR170
AR210 AR211
AR217 AR222
AR223 AR227
AR228 AR229
AR23.3 AR23.4
AR230 AR232
AR233 AR235
AR237 AR238
AR239 AR245
AR250 AR251
AR253 AR258
AR264 AR265
...
ACMSET7 COMPANY KeyChange AR04.1 AR150
STMNT-CYCLE
CUSTOMER
ACMSET8 COMPANY KeyChange AR06.1 AR170
CREDIT-ANLYST AR217 AR271
CUSTOMER AR292
ACMSET9 COMPANY KeyChange, Subset AC56.1 AC560
EDI-NBR Where EDI-NBR != Spaces AR10.1 AR219
AR48.1 AR48.3
AR501 AR550
AR575 BL02.1
BL04.1 BL10.1
BL120 BL121
BL122 BL123
BL125 BL130
BL20.1 BL20.3
BL20.6 BL202
BL204 BL21.2
BL21.5 BL217
BL220 BL231
BL246 BL29.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
|