 |
Lawson Insight Technical Documentation |
|
ARDISTRIB FILE
AR Distributions
The AR Distributions file contains distribution records for every transaction
that will be posted to the General Ledger system through the Lawson Accounts
Receivable system.
REFERENCED BY
AR287 AR293 AR295 AR95.1 AR220 AR242
AR286 AR199 DA290 GL235 AR129 AR130
AR131 AR135
UPDATED BY
AR115 AR124 AR137 AR190 AR196 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR28.1 AR29.2
AR29.3 AR30.1 AR30.2 AR30.4 AR300 AR31.5
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR48.3 AR502 AR507 AR560 AR570 AR575
AR580 AR82.1 CB191 DT150 DT155 DT160
DT165 DT166 DT170 DT180 DT181 DT185
DT190 DT30.1 DT30.2 DT40.1 DT45.1 DT520
DT60.1 DT60.2 DT70.1 DT70.3 DT80.1 DT85.1
DT85.2 DT92.1 CB06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMD-GL-COMPANY Numeric 4 AR115 AR124
General Ledger The general ledger company associated AR137 AR190
Company with this distribution. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ACCT-UNIT Alpha 15 AR115 AR124
Accounting Unit The general ledger accounting unit to AR137 AR190
which this distribution will be posted. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ACCOUNT Numeric 6 AR115 AR124
Account The general ledger account number to AR137 AR190
which this distribution will be posted. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-SUB-ACCT Numeric 4 AR115 AR124
Subaccount The general ledger subaccount number AR137 AR190
used for posting the distribution. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-GL-DATE Numeric 8 (yyyymmdd) AR115 AR124
Posting Date The date this distribution will be AR137 AR190
posted to the general ledger. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-CREATE-DATE Numeric 8 (yyyymmdd) AR115 AR124
Creation Date The system date indicating when this AR137 AR190
distribution was created. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-CREATE-TIME Numeric 6 (hhmmss) AR115 AR124
Creation Time The system time indicating when this AR137 AR190
distribution was created. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-PROG-SEQ-NBR Numeric 5 AR115 AR124
Program Sequence Program sequence number. If multiple AR137 AR190
Number records with the same keys exist, this AR196 AR20.1
sequence number is incremented to make AR21.1 AR21.2
records unique. AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-COMPANY Numeric 4 AR115 AR124
Distribution Company The company assigned to the AR137 AR190
distribution. This may be different from AR196 AR20.1
the company assigned to the transaction AR21.1 AR21.2
if an intercompany relationship is AR21.3 AR24.1
defined in the Lawson General Ledger AR29.2 AR30.1
system. AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-BATCH-NBR Numeric 6 AR115 AR124
Batch Number The batch number associated with the AR137 AR190
transaction distribution. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-CUSTOMER Alpha 9 (Right Justified) AR115 AR124
Customer The customer number associated with AR190 AR196
this distribution. This field will have AR20.1 AR21.1
a value depending on whether the AR21.2 AR21.3
distributions are detail or summary and AR24.1 AR28.1
the originating process. AR29.2 AR29.3
AR30.1 AR30.2
AR30.4 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-PROCESS-LEVEL Alpha 5 AR115 AR124
Process Level The process level associated with the AR137 AR190
transaction distribution. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-TRANS-TYPE Alpha 1 AR115 AR124
Transaction Type The type of transaction associated with AR190 AR196
the distribution. Valid values are: AR20.1 AR21.1
AR21.2 AR21.3
C = Credit Memo AR24.1 AR29.2
D = Debit Memo AR30.1 AR30.2
I = Invoice AR30.4 AR31.5
N = Non-Accounts Receivable Payment AR42.1 AR42.2
B = Bills of Exchange AR42.6 AR42.7
P = Payment (AR) AR43.1 AR44.3
R = Remittance AR48.3 AR502
M = Mixed AR507 AR560
AR570 AR575
AR580 AR82.1
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-INVOICE Alpha 22 AR115 AR124
Invoice Number Used to identify the invoice. AR190 AR196
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR124
Transaction Date The date of the transaction associated AR137 AR190
with the distribution. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-DIST-SEQ Numeric 4 AR115 AR124
Distribution Distribution sequence number. If AR137 AR190
Sequence Number multiple distributions are posted for a AR196 AR20.1
transaction, this sequence number helps AR21.1 AR21.2
identify and keep distributions unique. AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-DST-TYPE Alpha 2 AR115 AR124
Distribution Type Identifies where the transaction AR137 AR190
originated in the Lawson Accounts AR196 AR20.1
Receivable system. Valid values are: AR21.1 AR21.2
AR21.3 AR24.1
RI = Receivable Invoicing AR29.2 AR30.1
RL = Receivable Application AR30.2 AR30.4
RM = Receivable Memo AR31.5 AR42.1
RN = Receivable Notice AR42.2 AR42.6
RP = Receivable Payment AR42.7 AR43.1
RV = Receivable Reversal AR44.3 AR48.3
RU = Unrealized Gain Loss AR502 AR507
BE AR560 AR570
BG AR575 AR580
DA AR82.1 CB191
DB DT150 DT155
DC DT160 DT165
DH DT166 DT170
DK DT180 DT181
DR DT185 DT30.1
EC DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-PAYMENT-SEQ Numeric 6 AR190 AR196
Payment Sequence Payment Sequence. This is the generated AR48.3
Number sequence number to separate individual
invoice payment requirements.
AMD-ACCUM-TYPE Alpha 1 AR115 AR124
Distribution Indicates whether the type of the AR137 AR190
Summary/Detail distribution is detail or summary. Valid AR196 AR20.1
values are: AR21.1 AR21.2
AR21.3 AR24.1
D = Detail AR29.2 AR30.1
S = Summary AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-TRAN-AMT Signed 15.2 AR115 AR124
Base Amount The amount of the distribution in the AR137 AR190
company base currency. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-TO-COMP-AMT Signed 15.2 AR115 AR124
To Company Amount The amount of the distribution that AR137 AR190
will be posted to another company in a AR20.1 AR21.1
intercompany transaction. AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR31.5
AR42.2 AR44.3
AR48.3 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-UNITS Signed 15.2 AR190 AR21.3
Units The quantity of units for the AR29.2 AR42.2
distribution if units are being used for AR42.7 AR44.3
a transaction. AR48.3 AR507
AR560 DT150
DT160 DT170
DT180 DT181
DT185 DT45.1
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-DESC Alpha 30 (Lower Case) AR115 AR124
Description The description of the distribution. AR137 AR190
The value in this field varies depending AR196 AR20.1
on the type of transaction and the AR21.1 AR21.2
program the distribution was created in. AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ACTIVITY Alpha 15 AR190 AR21.3
Activity Activities are the processes or AR29.2 AR42.2
procedures that produce work. Cost AR42.7 AR44.3
objects (products, services, customers, AR48.3 AR507
and so on) are the reasons for AR560 DT150
performing the activity. DT160 DT170
DT180 DT181
DT185 DT45.1
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-ACCT-CATEGORY Alpha 5 AR190 AR21.3
Category Account categories are groupings of AR29.2 AR42.2
costs, revenues, or a combination of AR42.7 AR44.3
both used for reporting and inquiries AR48.3 AR507
for activities in the Activity AR560 DT150
Management system. All transactions are DT160 DT170
posted to an account category within an DT180 DT181
activity. You can assign a specific DT185 DT45.1
General Ledger account or range of DT60.1 DT60.2
accounts (company, accounting unit, DT70.1 DT70.3
account, and subaccount) that make up DT80.1 DT92.1
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
AMD-STATUS Numeric 1 AR115 AR124
Status Status of the distribution record. AR137 AR190
Valid values are: AR196 AR20.1
AR21.1 AR21.2
0 = Unreleased AR21.3 AR24.1
2 = Released AR29.2 AR30.1
9 = Posted AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT190
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-ORIG-CURRENCY Alpha 5 AR115 AR124
Transaction Currency The currency in which the transaction AR137 AR190
was entered. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ORIG-RATE Signed 12.6 AR115 AR124
Exchange Rate The currency exchange rate used to AR137 AR190
convert a non-base currency transaction AR196 AR20.1
amount to the company base currency. The AR21.1 AR21.2
rate is maintained in the Currency AR21.3 AR24.1
Relationship file and there is an option AR29.2 AR30.1
at the company level to override the AR30.2 AR30.4
rate at entry time. AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ORIG-AMT Signed 15.2 AR115 AR124
Transaction Amount The amount of the distribution in AR137 AR190
transaction currency. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-CAT-TYPE Alpha 1 AR44.3 DT150
Cat Type Indicates the type of distribution DT160 DT170
category. Valid values are: DT180 DT181
DT185 DT45.1
C = Category DT60.1 DT60.2
T = Tax DT70.1 DT70.3
DT80.1 DT92.1
AMD-AR-CATEGORY Alpha 5 AR190 AR42.2
AR Category The category code assigned to the AR42.7 AR44.3
distribution. Used to default AR48.3 DT150
distribution information. DT160 DT170
DT180 DT181
DT185 DT45.1
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-TAX-CODE Alpha 10 AR190 AR21.3
Tax Code The tax code assigned to the AR29.2 AR42.2
distribution. Identifies a tax AR42.7 AR44.3
percentage to be assessed to the taxable AR48.3 AR507
amount of a transaction. Must be defined AR560 DT150
in the Lawson Tax system. DT160 DT170
DT180 DT181
DT185 DT45.1
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-TRAN-TAXABLE Signed 15.2 AR190 AR21.3
Base Taxable Amount The taxable amount of the distribution. AR29.2 AR42.2
AR42.7 AR44.3
AR48.3 AR560
DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-UPDATE-SUM Alpha 2 AR115 AR137
Update Summary Indicates what summary amount should be AR190 AR196
updated when AR194 (Audit Summary) is AR31.5 AR42.1
run. Valid values are: AR42.2 AR42.6
AR42.7 AR43.1
01 = Invoice AR44.3 AR48.3
02 = Memos AR502 AR560
03 = Cash AR82.1 DT150
04 = Credits Applied DT155 DT160
06 = Chargebacks DT165 DT166
07 = Discounts DT170 DT180
08 = Write-Offs DT181 DT185
09 = Gain/Loss on currency exchange DT30.1 DT30.2
10 = Cashed Bill of Exchange DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-ORIG-ND Numeric 1 AR115 AR124
Number of Decimals Indicates the number of decimals AR190 AR196
defined for the transaction currency. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-AUTO-REV Alpha 1 AR190 AR196
Auto Reversal When the Auto Reversal field is set to AR44.3 AR48.3
"Y", program AR196 (Unrealized Gain Loss DT150 DT160
Report) creates an opposite entry for DT170 DT180
this transaction. Valid values are: DT181 DT185
DT45.1 DT60.1
N = No reversing records needed DT60.2 DT70.1
Y = Reversing records needed DT70.3 DT80.1
DT92.1
AMD-ORIG-COMPANY Numeric 4 AR190 AR42.1
Originating Company This is the company the distribution AR42.2 AR42.6
record originated from. AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-ORIG-TAXABLE Signed 15.2 AR190 AR21.3
Orig Taxable The taxable amount of the original AR29.2 AR42.2
distribution transaction. AR42.7 AR44.3
AR48.3 AR560
DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-DOCUMENT-NBR Alpha 27 AR115 AR124
Document Number This field is used for document AR190 AR196
journalizing in the Lawson General AR20.1 AR21.1
Ledger system. Document numbers are AR21.2 AR21.3
assessed during record creation and AR24.1 AR29.2
represent a source document or a summary AR30.1 AR30.2
value for many documents with an AR30.4 AR31.5
identifying source prefix. Valid values AR42.1 AR42.2
are: AR42.6 AR42.7
AR43.1 AR44.3
1 = Invoicing detail AR48.3 AR502
2 = Debit Memo detail AR560 AR570
3 = Credit Memo detail AR575 AR580
5 = Payment Batch summary AR82.1 CB191
6 = Payment detail DT150 DT155
7 = Application detail/summary DT160 DT165
8 = RTM detail DT166 DT170
9 = Finance Charge summary DT180 DT181
10 = Finance Charge detail DT185 DT30.1
11 = Invoice Unreal Gain Loss detail DT30.2 DT40.1
12 = Db Memo Unreal Gain Loss detail DT45.1 DT520
13 = Cr Memo Unreal Gain Loss detail DT60.1 DT60.2
14 = Transfer to Non-AR detail DT70.1 DT70.3
15 = Debit Memo Grouping DT80.1 DT85.1
DT85.2 DT92.1
AMD-DST-SOURCE Alpha 1 AR115 AR124
Distribution Source The source of the distribution. Valid AR137 AR190
values are: AR20.1 AR21.1
AR21.2 AR21.3
A = Accounts Receivable AR24.1 AR29.2
B = Bill of Exchange AR30.1 AR30.2
AR30.4 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-BASE-ACCTUNIT Alpha 15 AR115 AR124
Base Account Unit Used for inter-zone balancing in the AR137 AR190
Lawson General Ledger system. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-JRNL-BOOK-NBR Alpha 12 AR115 AR124
Journal Book Number This field will contain the journal AR137 AR190
book number for the distribution record. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT185 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT92.1
AMD-MX-VALUE Alpha 32 Occurs 3 Times AR115 AR124
Matrix Value An optional transaction attribute value AR137 AR190
as defined in the Lawson General Ledger AR196 AR20.1
system's Source Code program. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR44.3 AR48.3
AR560 AR570
AR575 AR580
AR82.1 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-GLT-OBJ-ID Numeric 12 AR115 AR124
General Ledger A subsystem interface identification AR190 AR20.1
Object ID number. Used for Drill Around purposes. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR44.3 AR48.3
AR560 AR570
AR575 AR580
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT190
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-DRAFT-SOURCE Alpha 1 AR190 AR48.3
Bill of Exchange This defines origination of the bill of DT180 DT181
Source exchange.
AMD-ATN-OBJ-ID Numeric 12 AR115 AR124
Activity Object ID A subsystem interface identification AR190 AR20.1
number. Used for Drill Around purposes. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR48.3 AR560
AR570 AR575
AR580 CB191
DT180 DT181
DT190
AMD-TAX-POINT Alpha 1 AR21.3 AR29.2
Tax Point Indicates the tax point origin, used AR42.2 AR42.7
for tax calculation. Valid values are: AR48.3 AR560
DT180 DT181
I = Invoice origin
P = Payment origin
Blank = No tax point origin
AMD-JBK-SEQ-NBR Numeric 10 AR115 AR124
Journal Book The journal book sequence number AR190 AR20.1
Sequence Number assigned to a journal book transaction AR21.1 AR21.2
when it is added or interfaced to the AR21.3 AR24.1
Lawson system. Used only when Auto AR30.1 AR30.2
Journal Book Seq Nbr is set to Yes in AR30.4 AR570
GL10.1 (Company). AR575 AR580
CB191
AMD-LINE-TYPE Alpha 1
Line Type This field contains the type of
inventory on this line.
ARDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMDSET1 GL-COMPANY The path is used to keep records unique AR115 AR124
ACCT-UNIT and to find the last used program AR190 AR20.1
ACCOUNT sequence number. AR21.1 AR21.2
SUB-ACCT AR21.3 AR24.1
GL-DATE AR287 AR29.2
CREATE-DATE AR293 AR295
CREATE-TIME AR30.1 AR30.2
PROG-SEQ-NBR AR30.4 AR300
AR31.5 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
AR82.1 AR95.1
...
AMDSET2 COMPANY The path is used to find certain AR115 AR124
BATCH-NBR distribution types (RI, RP and RM). AR190 AR20.1
TRANS-TYPE Subset AR21.1 AR21.2
INVOICE Where DST-TYPE = "RI" AR21.3 AR220
CUSTOMER Or DST-TYPE = "RP" AR24.1 AR242
DIST-SEQ Or DST-TYPE = "RM" AR28.1 AR28.6
AR286 AR29.2
AR29.3 AR295
AR30.1 AR30.2
AR30.4 AR300
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR560
AR570 AR575
...
AMDSET3 COMPANY The path is used to read released AR190 AR199
ACCT-UNIT distributions. DT190
ACCOUNT Subset
SUB-ACCT Where STATUS = 2
GL-COMPANY
GL-DATE
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET4 COMPANY This path will be used to produce the AR196 AR29.3
CUSTOMER Tax report.
TRANS-TYPE Subset
INVOICE Where DST-TYPE = "RU"
PAYMENT-SEQ
DIST-SEQ
AMDSET5 GL-COMPANY This path allows drill down into the DA290 GL235
ACCT-UNIT distribution file from the General
ACCOUNT Ledger system.
SUB-ACCT KeyChange
GL-DATE
GLT-OBJ-ID
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET6 COMPANY This path is used to find tax AR129 AR130
CUSTOMER distributions that are a prepay type. AR131 AR135
TRANS-TYPE Subset AR190 AR30.1
INVOICE Where TAX-POINT = "P" AR30.2 AR30.3
DIST-SEQ AR30.4 AR30.8
AR31.6 AR48.3
DT180 DT181
AMDSET7 ATN-OBJ-ID This path is used for drill around
GL-COMPANY access from Activity Management.
ACCT-UNIT Subset
ACCOUNT Where ATN-OBJ-ID != Zeroes
SUB-ACCT
GL-DATE
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
ARDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcategory ARCATEGORY Required
AMD-COMPANY -> ACA-COMPANY (ACASET1)
AMD-AR-CATEGORY -> ACA-AR-CATEGORY
Aroihdr AROIHDR Required
AMD-COMPANY -> ARH-COMPANY
AMD-BATCH-NBR -> ARH-BATCH-NBR
AMD-CUSTOMER -> ARH-CUSTOMER
AMD-TRANS-TYPE -> ARH-TRANS-TYPE
AMD-INVOICE -> ARH-INVOICE
Arpayment ARPAYMENT Required
When AMD-TRANS-TYPE = "N"
AMD-COMPANY -> APM-COMPANY
AMD-BATCH-NBR -> APM-BATCH-NBR
AMD-TRANS-TYPE -> APM-TRANS-TYPE
AMD-INVOICE -> APM-TRANS-NBR
AMD-CUSTOMER -> APM-CUSTOMER
Arudistrib ARUDISTRIB Not Required
AMD-COMPANY -> DGM-COMPANY
AMD-BATCH-NBR -> DGM-BATCH-NBR
AMD-TRANS-TYPE -> DGM-TRANS-TYPE
AMD-INVOICE -> DGM-INVOICE
AMD-CUSTOMER -> DGM-CUSTOMER
AMD-DIST-SEQ -> DGM-DIST-SEQ
Company ARCOMP Required
AMD-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
When AMD-CUSTOMER != Spaces
Or AMD-CUSTOMER != "000000000"
ACO-CUST-GROUP -> CUD-CUST-GROUP
AMD-CUSTOMER -> CUD-CUSTOMER
Customer ARCUSTOMER Required
AMD-COMPANY -> ACM-COMPANY
AMD-CUSTOMER -> ACM-CUSTOMER
Gl Comp ARCOMP Required
AMD-GL-COMPANY -> ACO-COMPANY
Txtaxcode TXTAXCODE Required
AMD-COMPANY -> TAC-COMPANY
AMD-TAX-CODE -> TAC-TAX-CODE
ARDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
AMD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|