Lawson Insight Technical Documentation |
|
ARCUSTOMER
ARCUSTOMER FILE
AR Company Customer
The AR Company Customer file will contain customer information that is
relevant to a specific company level customer. The customer processing rules
for the company key, are defined and maintained in this record. Statistical
fields and order processing fields are also contained on this record.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 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 AR245 AR25.1 AR25.2
AR250 AR251 AR253 AR255 AR258 AR260
AR261 AR271 AR274 AR275 AR286 AR290
AR291 AR292 AR293 AR294 AR50.1 AR504
AR515 AR53.1 AR58.1 AR72.1 AR74.1 AR75.1
AR90.1 BL04.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
BL802 BL81.1 BL82.1 BL85.1 BL85.2 BL90.1
BR00.1 BR00.2 BR02.3 BR10.1 BR11.1 BR120
BR121 BR122 BR140 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.2 BR210 BR211 BR216 BR217 BR220
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR521 BRIP.1 CB06.2 DT161 DT190
DT270 DT280 DT42.1 DT95.1 IC02.1 IC28.1
IC531 MA180 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 OE112 OE116
OE130 OE16.1 OE230 OE254 OE260 OE270
OE271 OE272 OE280 OE284 OE285 OE286
OE290 OE291 OE292 OE293 OE294 OE330
OE53.1 OE54.1 OE60.1 OE80.1 OE80.2 OE81.1
OE81.2 OE85.1 OE85.3 OE86.1 OE90.1 OE90.2
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 PR197 RQ10.1
RQ10.2 SA03.1 SA100 SA252 SA254 SA256
SA261 SA271 SA281 SA291 SA300 SA80.2
SA90.2 SACU.1 IN120 IN20.1 TX125 TX40.1
WH110 WH120 WH130 WH132 WH190 WH21.2
WH224 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WO30.1 AR04.1
AR06.1
UPDATED BY
AR09.1 AR10.1 AR10.2 AR112 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.8
AR301 AR31.6 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 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 AR82.1 ARI1.1 ARLL.1 BL02.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CB191
DT150 DT155 DT160 DT165 DT166 DT170
DT180 DT181 DT30.1 DT30.2 DT40.1 DT45.1
DT520 DT60.1 DT60.2 DT70.1 DT70.3 DT80.1
DT85.1 DT85.2 DT90.1 DT92.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE114 OE129 OE13.2 OE13.3 OE13.5
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE810
OE830 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
DT150
ACM-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer The unique identifier assigned to the AR301 AR501
customer. AR550 BL02.1
DT150
ACM-ACTIVE-STATUS Alpha 1 AR09.1 AR10.1
Element: Active Status Indicates the status of the customer. AR301 AR501
Valid values are: AR550 BL02.1
A = Active
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
another national account. Valid values
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
customer, the search name defined in
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
ACM-CONTACT Alpha 20 AR09.1 AR10.1
Element: Primary ContacPrimary contact name for this customer. AR301 AR501
AR550 BL02.1
ACM-INT-PREFIX Alpha 6 AR09.1 AR10.1
International The international telephone number AR301 AR501
Telephone Prefix prefix. AR550 BL02.1
ACM-PHONE-NMBR Alpha 15 AR09.1 AR10.1
Element: Telephone NumbThe telephone number for this customer. AR301 AR501
AR550 BL02.1
ACM-PHONE-EXT Alpha 5 AR09.1 AR10.1
Element: Telephone ExteThe telephone extension number for the AR301 AR501
customer. AR550 BL02.1
ACM-TELEX-NBR Alpha 15 AR09.1 AR10.1
Element: Telex Number The telex number for the customer. AR301 AR501
AR550 BL02.1
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
external order processing systems.
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.
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
ACM-FAX-NMBR Alpha 15 AR09.1 AR10.1
Element: Fax Number The customer's fax number. AR301 AR501
AR550 BL02.1
ACM-FAX-EXT Alpha 5 AR09.1 AR10.1
Element: Fax Extension The customer's fax extension. AR301 AR501
AR550 BL02.1
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
defaults.
ACM-CREDIT-ANLYST Alpha 4 AR09.1 AR10.1
Element: Credit AnalystThe credit analyst code assigned to AR301 AR501
this customer. AR550 BL02.1
ACM-CURRENCY-CD Alpha 5 AR09.1 AR10.1
Element: Currency Code The default currency in which the AR301 AR501
customer will be invoiced. If the AR550 BL02.1
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 AR09.1 AR10.1
Element: SalesRep The primary sales representative for AR301 AR501
this customer. This salesrep is used on AR550 BL02.1
various programs for selection and
sorting.
ACM-RISK-CD Alpha 1 AR09.1 AR10.1
Element: Risk Code The risk code is used for risk AR301 AR501
analysis. Defaults from the company. AR550 BL02.1
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
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 AR09.1 AR10.1
Element: Major Class The major class assigned to this AR301 AR501
customer. AR550 BL02.1
ACM-MIN-CLASS Alpha 4 AR09.1 AR10.1
Element: Minor Class The minor class assigned to this AR301 AR501
customer. AR550 BL02.1
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
AR31.6 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
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR505 AR560
AR570 AR575
AR580 AR80.1
AR80.2 AR82.1
ARLL.1 CB191
DT150 DT155
DT160 DT165
...
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
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR31.6
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 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR505
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
...
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 AR82.1
ARLL.1 BL02.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT520
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
...
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.
This value is maintained in the Lawson
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
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) AR09.1 AR10.1
Element: Credit Limit DThe date the credit limit was defined AR301 AR501
or last reviewed. AR550 AR70.2
BL02.1
ACM-CREDIT-REVDAYS Signed 3.0 AR09.1 AR10.1
Element: Credit Review The number of days between the credit AR301 AR501
limit reviews for the customer. AR550 BL02.1
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 AR34.1
AR501 AR503
AR550 AR570
AR575 AR580
BL02.1 CB191
DT170 DT180
DT181
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 AR34.1
AR501 AR503
AR550 AR570
AR575 AR580
BL02.1 CB191
DT170 DT180
DT181
ACM-LAST-INV-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Last Invoice DThe date of the last invoice for this AR115 AR129
customer. AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR301
AR31.6 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
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR550
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 BL02.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
...
ACM-LAST-INV-AMT Signed 18.2 AR09.1 AR10.1
Element: Intl Amt AR115 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR301
AR31.6 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
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR550
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 BL02.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
...
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
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
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
Selection) selects the customer when
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
R = Reviewed
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 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR301 AR31.6
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 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR550 AR560
AR80.1 AR80.2
AR82.1 ARLL.1
BL02.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
...
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 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR301 AR31.6
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 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR550 AR560
AR80.1 AR80.2
AR82.1 ARLL.1
BL02.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
...
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
considered.
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
customer.
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
invoices and only debit memos generated
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.
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.
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
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.
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
buckets.
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
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
updated by AR194 (Audit Summary).
ACM-LAST-COMMENT Numeric 6 AR115 AR129
Element: Last Comment AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR141 AR161
AR17.1 AR180
AR190 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR31.6 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
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR503 AR506
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
...
ACM-DISP-NBR Signed 3.0 AR190 AR45.1
Element: Disputed ItemsThe number of open items currently in AR506
dispute.
ACM-DISP-AMT Signed 18.2 AR190 AR45.1
Element: Disputed AmounThe total amount in dispute for this AR506
customer.
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
the specified process level. Valid
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 AR301 AR501
aged. Valid values are: AR550 BL02.1
N = Not aged - aged in current column
Y = Aged respective to GL date
ACM-DISPUTES-FIN Alpha 1 AR09.1 AR10.1
Element: Finance DisputSpecifies if disputed invoices are AR301 AR501
exempt from being assessed finance AR550 BL02.1
charges. Valid values are:
N = No; not subject to finance charges
Y = Yes; subject to finance charges
ACM-AUTO-APP-FL Alpha 1 AR09.1 AR10.1
Automatic Automatic cash application indicator. AR301 AR501
Application Valid values are: AR550 BL02.1
N = No; no automatic application
Y = Yes; allows automatic application
ACM-AUTO-DUNN-FL Alpha 1 AR09.1 AR10.1
Automatic Dunning Indicates whether or not automatic AR301 AR501
Letters selection for dunning letters will be AR550 BL02.1
allowed. Valid values are:
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 AR301 AR501
Period allow or disallow discount during cash AR550 BL02.1
application.
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,
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 AR09.1 AR10.1
Element: Memo Terms Memo terms code. Must be a valid net or AR301 AR501
prepayment type terms code defined in AR550 BL02.1
the Lawson Terms system.
ACM-CHRGBK-PRT-FL Alpha 1 AR09.1 AR10.1
Element: Print ChargebaSpecifies whether chargebacks will be AR301 AR501
printed. Valid values are: AR550 BL02.1
N = No; don't print chargeback debit
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 AR301 AR501
Forward either open item or balance forward AR550 BL02.1
methods. Valid values are:
B = Balance forward processing
O = Open Item processing
ACM-STATEMENT-REQ Alpha 1 AR09.1 AR10.1
Element: Statement RequStatement required option. If AR301 AR501
statements are required, the default AR550 BL02.1
selection criteria will include current,
past due and credit open items. Zero
balance statements will not be produced.
Individual statement options may
override this set of default criteria.
Valid values are:
N = No statements required
Y = Statements required
ACM-STMNT-CYCLE Alpha 2 AR09.1 AR10.1
Element: Statement CyclUsed to group customers with like AR301 AR501
statement cycles for statement AR550 BL02.1
processing. The statement cycle code
will be assigned for balance forward
type customers via the first letter of
the company customer level search name.
ACM-LOCK-BOX Alpha 2 AR09.1 AR10.1
Element: Lock Box The remit-to location of a lock box, AR301 AR501
used for payment receipts. If entered, AR550 BL02.1
it must be a valid lock box code. If
left blank, the company name and address
will be used for the remit-to address on
Accounts Receivable external forms. For
the Lawson Order Entry system, the
process level name and address for the
process level of the invoice will be
used if left blank.
ACM-ZERO-STMNT-FL Alpha 1 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
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 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
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 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
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 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
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 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
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 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
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 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.
This will allow tracking adjustment
records by their reason codes.
ACM-DISC-REAS-CD Alpha 4 AR09.1 AR10.1
Element: Discount ReasoThe default reason code for earned AR301 AR501
discounts for the customer. This must be AR550 BL02.1
a valid code in AR15 (Operational Codes
(Reason)).
ACM-BANK-INST-CODE Alpha 3 AR09.1 AR10.1
Element: Payment Code This will be the users normal method of AR301 AR501
payment. It will edit to the AR550 BL02.1
user-defined Cash Ledger payment code
file. It must be a payment type of cash
payment, or bills of exchange to be a
valid default payment.
ACM-DRAFT-FLAG Alpha 1 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
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 AR09.1 AR10.1
Accounts Receivable Default accounts receivable code for AR301 AR501
Code this customer used for record entry. AR550 BL02.1
ACM-TERMS-CD Alpha 5 AR09.1 AR10.1
Element: Terms Code The default terms code to be used AR301 AR501
during invoicing for this customer. AR550 BL02.1
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).
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.
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
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 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
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
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).
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:
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:
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
percentage rate.
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.
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,
there will be no override.
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:
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
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
ACM-LAST-DUN-AMT Signed 18.2 AR09.1 AR10.1
Element: Intl Amt AR141 AR161
AR301 AR501
AR550 BL02.1
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:
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 TX140
Entry system. Must be valid in the
Lawson Tax system.
ACM-TERRITORY Alpha 4 AR09.1 AR10.1
Element: Sales TerritorSales territory. Used by Lawson AR301 AR501
Accounts Receivable, Order Entry and AR550 BL02.1
Sales Analysis systems.
ACM-AGING-CODE Numeric 2 AR09.1 AR10.1
Element: Aging Code Aging code. Indicates if there is a AR301 AR501
customer level aging override present. AR550 BL02.1
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 AR09.1 AR10.1
Element: Revalue Flag Indicates whether to revalue AR301 AR501
transaction currencies against the AR550 BL02.1
company base currency to account for
exchange rate fluctuations. Valid values
are:
N = No
Y = Yes
ACM-CURR-DRAFT-BAL Derived
Bill of Exchange A derived field containing the total
Balance amount of a customer's balance and bill
of exchange balance.
ACM-DISHONORED Signed 5.0 DT90.1
Element: Dishonored BOEThe total number of customer bills of
exchange that have been dishonored.
ACM-DISHONORED-AMT Signed 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:
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.
ACM-DUN-CYCLE Alpha 2 AR09.1 AR10.1
Element: Dunning Cycle Dunning cycle code. Lets you control AR301 AR501
customer selection when you generate AR550 BL02.1
dunning notices.
ACM-AUTO-METHOD Alpha 1 AR09.1 AR10.1
Auto Cash Indicates the automatic cash AR301 AR501
Application Method application method for this customer. AR550 BL02.1
Valid values are:
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 AR301 AR501
and transactions can be removed AR550 BL02.1
automatically.
N = No
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
ACM-CB-DTL-DATE Alpha 1 AR09.1 AR10.1
Element: Cb Dtl Date This field will be used to determine AR301 AR501
which dates are used to calculate AR550 BL02.1
transaction and due dates for detail
chargebacks.
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
indicates that VAT Reporting is
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
up the VAT Registration Number.
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
for the company on the tax transaction.
ACM-VAT-NBR Derived
Element: Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
ACM-DUN-LTR-IND Alpha 1 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.
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.
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
environment base language is assumed
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
code.
ACM-LAST-LTR-DATE Numeric 8 (yyyymmdd) AR145
Element: Last Ltr Date Date last dunning letter was sent for
the invoice.
ACM-LST-LTRTEXT-CD Alpha 6 AR09.1 AR10.1
Element: Lst Ltrtext CdText Code for last Dunning Letter sent AR145 AR301
on this invoice. AR501 AR550
BL02.1
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
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.
ACM-CU-ADDR1 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr1 Credit Union Address Line 1. AR301 AR501
AR550 BL02.1
ACM-CU-ADDR2 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr2 Credit Union Address Line 2. AR301 AR501
AR550 BL02.1
ACM-CU-ADDR3 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr3 Credit union address line 3. AR301 AR501
AR550 BL02.1
ACM-CU-ADDR4 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Addr4 Credit union address line 4. AR301 AR501
AR550 BL02.1
ACM-CU-CITY Alpha 18 (Lower Case) AR09.1 AR10.1
Element: Cu City Credit Union City. AR301 AR501
AR550 BL02.1
ACM-CU-STATE Alpha 2 AR09.1 AR10.1
Element: Cu State Credit Union State. AR301 AR501
AR550 BL02.1
ACM-CU-POSTAL-CODE Alpha 12 AR09.1 AR10.1
Element: Cu Postal CodeCredit Union Postal Code. AR301 AR501
AR550 BL02.1
ACM-CU-COUNTRY-CD Alpha 2 AR09.1 AR10.1
Element: Cu Country Cd Credit Union Country Code. AR301 AR501
AR550 BL02.1
ACM-CU-COUNTRY Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Cu Country Credit Union Country. AR301 AR501
AR550 BL02.1
ACM-THIRD-PARTY Alpha 1 AR09.1 AR10.1
Element: Third Party N = No third party payment AR301 AR501
Y = Third party payment allowed AR550 BL02.1
ACM-E-MAIL-ADDRESS Alpha 60 (Lower Case) AR09.1 AR10.1
Element: Email Address AR301 AR501
AR550 BL02.1
ACM-URL-ADDR Alpha 60 (Lower Case) AR09.1 AR10.1
Element: Url Addr AR301 AR501
AR550 BL02.1
ACM-CUST-AUDIT Alpha 1 AR09.1 AR10.1
Element: Cust Audit AR301 AR501
AR550 BL02.1
ACM-APPLY-MIXED Alpha 1 AR09.1 AR10.1
Element: Apply Mixed AR301 AR501
AR550 BL02.1
ACM-OBJ-ID Numeric 12 AR09.1 AR10.1
Object This is the object identifier. It is AR301 AR501
Identification used to relate commitments or posted AR550 BL02.1
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
ARCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACMSET1 COMPANY This is the primary path used to access AP125 AP126
CUSTOMER customer records. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR01.1 AR09.1
AR09.7 AR10.1
AR10.2 AR100
AR105 AR11.1
AR110 AR112
AR115 AR12.1
AR12.2 AR124
AR129 AR13.1
AR13.2 AR130
AR131 AR132
AR135 AR136
...
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 AR301
COMPANY with the same customer number in AR58.1
different companies.
ACMSET4 OBJ-ID Subset AR135 AR170
Where OBJ-ID != Zeroes AR210 AR211
AR222 AR23.3
AR23.4 AR232
AR235 AR250
AR251 AR253
AR271 AR275
AR290 AR293
AR294 BL232
OE280 OE285
OE290
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 AR10.1 AR219
EDI-NBR records by EDI number. AR48.1 AR48.3
KeyChange, Subset AR501 AR550
Where EDI-NBR != Spaces AR575 BL02.1
BL04.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 BL29.2
BL290 BL291
...
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
|