ARDISTRIB FILE
AR Distributions
AR Distributions
REFERENCED BY
AR287 AR295 AR95.1 AR220 AR242 AR286
AR199 GL235 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
AR502 AR507 AR560 AR570 AR575 AR580
AR82.1 AR951 AR975 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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
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
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 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-NBR Alpha 10 (Right Justified) AR115 AR124
Transaction Number The transaction number associated with AR190 AR196
the distribution. 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
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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-PAYMENT-SEQ Numeric 6 AR190 AR196
Payment Sequence Payment Sequence. This is the generated AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-UNITS Signed 15.2 AR115 AR124
Units The quantity of units for the AR190 AR20.1
distribution if units are being used for AR21.1 AR21.2
a transaction. AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.2 AR42.7
AR44.3 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT40.1 DT45.1
DT520 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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR115 AR124
Activity Activities are the processes or AR190 AR20.1
procedures that produce work. Cost AR21.1 AR21.2
objects (products, services, customers, AR21.3 AR24.1
and so on) are the reasons for AR29.2 AR30.1
performing the activity. Activities and AR30.2 AR30.4
cost object activities are used AR42.2 AR42.7
synonymously in the Activity Management AR44.3 AR507
system. Direct costs are posted to AR560 AR570
activities, and indirect costs are AR575 AR580
allocated to activities based on AR82.1 AR951
activity drivers. CB191 DT150
DT160 DT170
Activities are grouped or organized by DT180 DT181
activity levels. There are two kinds of DT185 DT40.1
activities: "posting allowed" and DT45.1 DT520
"summary only." Use posting level DT60.1 DT60.2
activities to budget and maintain all DT70.1 DT70.3
posted transactions. Summary activities DT80.1 DT92.1
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
AMD-ACCT-CATEGORY Alpha 5 AR115 AR124
Category Account categories are groupings of AR190 AR20.1
costs, revenues, or a combination of AR21.1 AR21.2
both used for reporting and inquiries AR21.3 AR24.1
for activities in the Activity AR29.2 AR30.1
Management system. All transactions are AR30.2 AR30.4
posted to an account category within an AR42.2 AR42.7
activity. You can assign a specific AR44.3 AR507
General Ledger account or range of AR560 AR570
accounts (company, accounting unit, AR575 AR580
account, and subaccount) that make up AR82.1 CB191
the transactions posted to an account DT150 DT160
category using AC07.1 (Account DT170 DT180
Assignment). DT181 DT185
DT40.1 DT45.1
Period-to-date, year-to-date, and DT520 DT60.1
life-to-date balances are maintained by DT60.2 DT70.1
account category for activities. Account DT70.3 DT80.1
categories must be assigned to DT92.1
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR115 AR124
Distribution Indicates the type of distribution AR190 AR20.1
Category category. Valid values are: AR21.1 AR21.2
AR21.3 AR24.1
C = Category AR30.1 AR30.2
T = Tax AR30.4 AR44.3
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-AR-CATEGORY Alpha 5 AR115 AR124
AR Category The category code assigned to the AR190 AR20.1
distribution. Used to default AR21.1 AR21.2
distribution information. AR21.3 AR24.1
AR30.1 AR30.2
AR30.4 AR42.2
AR42.7 AR44.3
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-TAX-CODE Alpha 10 AR115 AR124
Tax Code The tax code assigned to the AR190 AR20.1
distribution. Identifies a tax AR21.1 AR21.2
percentage to be assessed to the taxable AR21.3 AR24.1
amount of a transaction. Must be defined AR29.2 AR30.1
in the Lawson Tax system. AR30.2 AR30.4
AR42.2 AR42.7
AR44.3 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-ORIG-TAXABLE Signed 15.2 AR115 AR124
Transaction Taxable The taxable amount of the original AR190 AR20.1
Amount distribution transaction. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.2 AR42.7
AR44.3 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-TRAN-TAXABLE Signed 15.2 AR115 AR124
Base Taxable Amount The taxable amount of the distribution. AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.2 AR42.7
AR44.3 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
CB191 DT150
DT160 DT170
DT180 DT181
DT185 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-UPDATE-SUM Alpha 2 AR115 AR124
Update Summary Indicates what summary amount should be AR137 AR190
updated when AR194 (Audit Summary) is AR196 AR20.1
run. Valid values are: AR21.1 AR21.2
AR21.3 AR24.1
01 = Invoice AR30.1 AR30.2
02 = Memos AR30.4 AR31.5
03 = Cash AR42.1 AR42.2
04 = Credits Applied AR42.6 AR42.7
06 = Chargebacks AR43.1 AR44.3
07 = Discounts AR502 AR560
08 = Write-Offs AR570 AR575
09 = Gain/Loss on currency exchange AR580 AR82.1
10 = Cashed Bill of Exchange AR951 AR975
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-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
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 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 AR115 AR124
Auto Reversal When the Auto Reversal field is set to AR190 AR196
"Y", program AR196 (Unrealized Gain Loss AR20.1 AR21.1
Report) creates an opposite entry for AR21.2 AR21.3
this transaction. Valid values are: AR24.1 AR30.1
AR30.2 AR30.4
N = No reversing records needed AR44.3 AR570
Y = Reversing records needed AR575 AR580
AR82.1 AR951
AR975 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-ORIG-COMPANY Numeric 4 AR115 AR124
Originating Company This is the company the distribution AR190 AR20.1
record originated from. AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
AR82.1 AR951
AR975 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-DOCUMENT-NBR Alpha 24 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 AR502 AR560
2 = Debit Memo detail AR570 AR575
3 = Credit Memo detail AR580 AR82.1
5 = Payment Batch summary AR951 AR975
6 = Payment detail CB191 DT150
7 = Application detail/summary DT155 DT160
8 = RTM detail DT165 DT166
9 = Finance Charge summary DT170 DT180
10 = Finance Charge detail DT181 DT185
11 = Invoice Unreal Gain Loss detail DT30.1 DT30.2
12 = Db Memo Unreal Gain Loss detail DT40.1 DT45.1
13 = Cr Memo Unreal Gain Loss detail DT520 DT60.1
14 = Transfer to Non-AR detail DT60.2 DT70.1
DT70.3 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
AR502 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
AR951 AR975
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 20 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 AR560
AR570 AR575
AR580 AR82.1
AR975 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT40.1 DT45.1
DT520 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
AR30.1 AR30.2
AR30.4 AR44.3
AR570 AR575
AR580 AR82.1
AR951 CB191
DT150 DT160
DT170 DT180
DT181 DT185
DT190 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT92.1
AMD-DRAFT-SOURCE Alpha 1 AR115 AR124
Bill of Exchange This defines origination of the bill of AR190 AR20.1
Source exchange. AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR30.2
AR30.4 AR570
AR575 AR580
AR82.1 AR975
CB191 DT180
DT181
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
AR560 AR570
AR575 AR580
AR82.1 AR975
CB191 DT180
DT181 DT190
AMD-TAX-POINT Alpha 1 AR115 AR124
Tax Point Indicates the tax point origin, used AR20.1 AR21.1
for tax calculation. Valid values are: AR21.2 AR21.3
AR24.1 AR29.2
I = Invoice origin AR30.1 AR30.2
P = Payment origin AR30.4 AR42.2
Blank = No tax point origin AR42.7 AR560
AR570 AR575
AR580 AR82.1
AR951 CB191
DT180 DT181
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 AR507
GL10.1 (Company). AR570 AR575
AR580 AR951
CB191
AMD-LINE-TYPE Alpha 1 AR42.2 AR560
Line Type This field contains the type of
inventory on this line.
G = Goods
S = Services
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 AR295 AR30.1
CREATE-TIME AR30.2 AR30.4
PROG-SEQ-NBR AR300 AR31.5
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 AR82.1
AR95.1 CB191
...
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
TRANS-NBR 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
AR560 AR570
AR575 AR580
...
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
TRANS-NBR Where DST-TYPE = "RU"
PAYMENT-SEQ
DIST-SEQ
AMDSET5 GL-COMPANY This path allows drill down into the GL235
ACCT-UNIT distribution file from the General
ACCOUNT Ledger system.
SUB-ACCT KeyChange, Duplicates
GL-DATE
GLT-OBJ-ID
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET6 COMPANY This path is used to find tax AR130 AR131
CUSTOMER distributions that are a prepay type. AR135 AR190
TRANS-TYPE Subset AR30.1 AR30.2
TRANS-NBR Where TAX-POINT = "P" AR30.3 AR30.4
DIST-SEQ AR30.8 AR31.6
AR82.1 DT180
DT181
AMDSET7 ATN-OBJ-ID This path is used for drill around
GL-COMPANY access from Activity Management.
KeyChange, Duplicates, Subset
Where ATN-OBJ-ID != Zeroes
ARDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcategory ARCATEGORY Required
When AMD-CAT-TYPE = "C"
AMD-COMPANY -> ACA-COMPANY
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-TRANS-NBR -> ARH-TRANS-NBR
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-TRANS-NBR -> 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-TRANS-NBR -> DGM-TRANS-NBR
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
When AMD-CAT-TYPE = "T"
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
|