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 AR296 AR95.1 AR99.6
AR220 AR242 AR286 TX101 AR199 GL235
AR129 AR130 AR131 AR135 AR39.1 AR39.2
UPDATED BY
AR115 AR124 AR137 AR190 AR195 AR196
AR197 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR28.1 AR29.2 AR29.3 AR30.1 AR300 AR32.1
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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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. AR32.1 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
AR32.1 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
AR32.1 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
AR32.1 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 AR32.1 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 Used to identify the invoice. AR137 AR190
AR196 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 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
AR32.1 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
AR32.1 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 AR32.1 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 = BOE Cashing Expense AR560 AR570
BG = BOE Bank Presentation Cashing AR575 AR580
DA = BOE Accepted AR82.1 ARLL.1
DB = BOE Cancellation CB191 DT150
DC = BOE Cashing DT155 DT160
DH = BOE Dishonored DT165 DT166
DK = BOE Discounted Remittance DT170 DT180
DR = BOE Cashing with Remittance DT181 DT185
EC = BOE Gain Loss DT30.1 DT30.2
RY = Application Reversal DT40.1 DT45.1
RQ = Application Adjustment DT520 DT60.1
RX = Adjustment Reversal DT60.2 DT70.1
DT70.3 DT80.1
DT85.1 DT85.2
DT92.1
AMD-PAYMENT-SEQ Numeric 6 AR190 AR196
Payment Sequence A unique number assigned to each AR48.3
Number transaction to be interfaced into the
Lawson system.
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 AR32.1 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
AR32.1 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 AR32.1
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
AR32.1 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: AR195 AR196
AR20.1 AR21.1
0 = Unreleased AR21.2 AR21.3
2 = Released AR24.1 AR29.2
9 = Posted AR30.1 AR32.1
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
AR32.1 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 AR32.1 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 AR32.1
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 AR33.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 ARLL.1
04 = Credits Applied DT150 DT155
06 = Chargebacks DT160 DT165
07 = Discounts DT166 DT170
08 = Write-Offs DT180 DT181
09 = Gain/Loss on currency exchange DT185 DT30.1
10 = Cashed Bill of Exchange 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 AR32.1
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 AR195
Element: Auto Reversal When the Auto Reversal field is set to AR196 AR44.3
"Y", program AR196 (Unrealized Gain Loss AR48.3 DT150
Report) creates an opposite entry for DT160 DT170
this transaction. Valid values are: DT180 DT181
DT185 DT45.1
N = No reversing records needed DT60.1 DT60.2
Y = Reversing records needed DT70.1 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 AR32.1
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 AR32.1
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
AR32.1 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 AR32.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
AR32.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 AR195
Object ID number. Used for Drill Around purposes. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.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 AR195
number. Used for Drill Around purposes. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.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 = Shipping Date
G = GL Date
AMD-JBK-SEQ-NBR Numeric 10 AR115 AR124
Element: Jbk Seq Nbr The journal book sequence number AR190 AR20.1
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 AR32.1
Journal Book Seq Nbr is set to Yes in AR34.1 AR570
GL10.1 (Company). AR575 AR580
CB191
AMD-LINE-TYPE Alpha 1 AR42.2 AR560
Element: Line Type This field contains the line type used
for intrastat purpose. Valid values
are:
Blank
G = Goods
S = Services
AMD-WEIGHT Signed 9.3 AR42.2 AR560
Element: Weight This field contains a weight
measurement used in the intrastat
process.
AMD-ICN-CODE Alpha 8 AR42.2 AR560
Element: Icn Code The ICN code used in the intrastat
process.
AMD-SUPLMNTARY-QTY Signed 13.4 AR42.2 AR560
Element: Quantity The supplementary quantity used in the
intrastat process.
AMD-BAL-DATE Numeric 8 (yyyymmdd) AR197
Element: Date This field displays the system date
when this was created.
ARDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMDSET1 GL-COMPANY AR115 AR124
ACCT-UNIT AR195 AR197
ACCOUNT AR20.1 AR21.1
SUB-ACCT AR21.2 AR21.3
GL-DATE AR24.1 AR287
CREATE-DATE AR29.2 AR293
CREATE-TIME AR295 AR296
PROG-SEQ-NBR AR30.1 AR300
AR32.1 AR33.5
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR560 AR570
AR575 AR580
...
AMDSET2 COMPANY Subset AR115 AR124
BATCH-NBR Where DST-TYPE = "RI" AR190 AR195
TRANS-TYPE Or DST-TYPE = "RP" AR20.1 AR21.1
INVOICE Or DST-TYPE = "RM" AR21.2 AR21.3
CUSTOMER AR220 AR24.1
DIST-SEQ AR242 AR28.1
AR28.6 AR286
AR29.2 AR29.3
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR560 AR570
...
AMDSET3 COMPANY Subset AR195 AR199
ACCT-UNIT Where STATUS = 2 DT190
ACCOUNT
SUB-ACCT
GL-COMPANY
GL-DATE
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET4 COMPANY Subset AR196 AR29.3
CUSTOMER Where DST-TYPE = "RU"
TRANS-TYPE
INVOICE
PAYMENT-SEQ
DIST-SEQ
AMDSET5 GL-COMPANY KeyChange GL235
ACCT-UNIT
ACCOUNT
SUB-ACCT
GL-DATE
GLT-OBJ-ID
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET6 COMPANY Subset AR129 AR130
CUSTOMER Where TAX-POINT = "P" AR131 AR135
TRANS-TYPE AR190 AR30.1
INVOICE AR30.8 AR32.1
DIST-SEQ AR33.1 AR33.3
AR33.6 AR34.1
AR39.1 AR39.2
AR48.3 DT180
DT181
AMDSET7 ATN-OBJ-ID Subset
GL-COMPANY Where ATN-OBJ-ID != Zeroes
ACCT-UNIT
ACCOUNT
SUB-ACCT
GL-DATE
CREATE-DATE
CREATE-TIME
PROG-SEQ-NBR
AMDSET8 GL-COMPANY Subset AR197
ACCT-UNIT Where BAL-DATE = Zeroes
ACCOUNT And STATUS = 9
SUB-ACCT
DST-TYPE
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
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
|