Lawson Insight Technical Documentation |
|
ARDISTRIB
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 TX101 AR199 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 AR300 AR31.5 AR33.5 AR34.1
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR48.3 AR502 AR507 AR560 AR570 AR575
AR580 AR82.1 ARLL.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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Accounting UniThe 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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 7 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Distribution CThe 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. AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Customer The customer number associated with AR137 AR190
this distribution. This field will have AR196 AR20.1
a value depending on whether the AR21.1 AR21.2
distributions are detail or summary and AR21.3 AR24.1
the originating process. AR28.1 AR29.2
AR29.3 AR30.1
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
ARLL.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-TYPE Alpha 1 AR115 AR124
Element: Transaction TyThe type of transaction associated with AR137 AR190
the distribution. Valid values are: AR196 AR20.1
AR21.1 AR21.2
C = Credit Memo AR21.3 AR24.1
D = Debit Memo AR29.2 AR30.1
I = Invoice AR31.5 AR33.5
N = Non-Accounts Receivable Payment AR34.1 AR42.1
B = Bills of Exchange AR42.2 AR42.6
P = Payment (AR) AR42.7 AR43.1
R = Remittance AR44.3 AR48.3
M = Mixed AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Invoice NumberUsed to identify the invoice. AR137 AR190
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Transaction DaThe 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Distribution TIdentifies 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 AR31.5 AR33.5
RM = Receivable Memo AR34.1 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 ARLL.1
DB CB191 DT150
DC DT155 DT160
DH DT165 DT166
DK DT170 DT180
DR DT181 DT185
EC 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 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 AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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 18.2 AR115 AR124
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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 18.2 AR115 AR124
Element: To Company AmoThe 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 AR31.5
AR33.5 AR34.1
AR42.2 AR44.3
AR48.3 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
Element: 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: 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
Element: 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.
Valid account category types are:
cost
revenue
accrual
pass thru
AMD-STATUS Numeric 1 AR115 AR124
Element: 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 AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Transaction CuThe currency in which the transaction AR137 AR190
was entered. AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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 14.7 AR115 AR124
Element: 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 AR31.5 AR33.5
rate at entry time. AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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 18.2 AR115 AR124
Element: Transaction AmThe amount of the distribution in AR137 AR190
transaction currency. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR31.5
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
ARLL.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
Element: 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
Element: 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
Element: 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 ARLL.1
in the Lawson Tax system. DT150 DT160
DT170 DT180
DT181 DT185
DT45.1 DT60.1
DT60.2 DT70.1
DT70.3 DT80.1
DT92.1
AMD-TRAN-TAXABLE Signed 18.2 AR190 AR21.3
Element: Base Taxable AThe taxable amount of the distribution. AR29.2 AR42.2
AR42.7 AR44.3
AR48.3 AR560
ARLL.1 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
Element: Update SummaryIndicates what summary amount should be AR190 AR196
updated when AR194 (Audit Summary) is AR31.5 AR33.5
run. Valid values are: AR42.1 AR42.2
AR42.6 AR42.7
01 = Invoice AR43.1 AR44.3
02 = Memos AR48.3 AR502
03 = Cash AR560 AR82.1
04 = Credits Applied ARLL.1 DT150
06 = Chargebacks DT155 DT160
07 = Discounts DT165 DT166
08 = Write-Offs DT170 DT180
09 = Gain/Loss on currency exchange DT181 DT185
10 = Cashed Bill of Exchange 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
Element: Number of DeciIndicates 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 AR31.5
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
ARLL.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
Element: 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
Element: Originating CoThis is the company the distribution AR42.2 AR42.6
record originated from. AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR560
ARLL.1 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 18.2 AR190 AR21.3
Element: Intl Amt The taxable amount of the original AR29.2 AR42.2
distribution transaction. AR42.7 AR44.3
AR48.3 AR560
ARLL.1 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
Element: Document NumbeThis 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 AR31.5
value for many documents with an AR33.5 AR34.1
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 ARLL.1
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
15 = Debit Memo Grouping DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-DST-SOURCE Alpha 1 AR115 AR124
Element: Distribution SThe 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 AR31.5
AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Base Account UUsed 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
AR31.5 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR507
AR560 AR570
AR575 AR580
AR82.1 ARLL.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
Element: Journal Book NThis 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 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR507 AR560
AR570 AR575
AR580 AR82.1
ARLL.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
Element: 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
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.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
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR44.3
AR48.3 AR560
AR570 AR575
AR580 ARLL.1
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
Element: Activity ObjecA subsystem interface identification AR190 AR20.1
number. Used for Drill Around purposes. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR48.3
AR560 AR570
AR575 AR580
ARLL.1 CB191
DT180 DT181
DT190
AMD-TAX-POINT Alpha 1 AR21.3 AR29.2
Element: Tax Point Indicates the tax point origin, used AR42.2 AR42.7
for tax calculation. Valid values are: AR48.3 AR560
ARLL.1 DT180
I = Invoice origin DT181
P = Payment origin
Blank = No tax point origin
S = Ship
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 AR34.1
Journal Book Seq Nbr is set to Yes in AR570 AR575
GL10.1 (Company). AR580 CB191
AMD-LINE-TYPE Alpha 1 AR42.2
Element: Line Type This field contains the type of
inventory on this line.
AMD-WEIGHT Signed 9.3 AR42.2
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
AMD-ICN-CODE Alpha 8 AR42.2
Element: Icn Code
AMD-SUPLMNTARY-QTY Signed 13.4 AR42.2
Element: Quantity
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 AR20.1 AR21.1
ACCOUNT sequence number. AR21.2 AR21.3
SUB-ACCT AR24.1 AR287
GL-DATE AR29.2 AR293
CREATE-DATE AR295 AR30.1
CREATE-TIME AR300 AR31.5
PROG-SEQ-NBR AR33.5 AR34.1
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
AR570 AR575
AR580 AR82.1
AR95.1 ARLL.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 AR300
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR560 AR570
AR575 AR580
...
AMDSET3 COMPANY The path is used to read released AR199 DT190
ACCT-UNIT distributions.
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 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.8 AR31.6
DIST-SEQ AR33.1 AR33.3
AR33.6 AR34.1
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
|