ACDBTRANS FILE
UPDATED BY
AC54.2 AC54.3 AC541 AC542
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DBT-RUN-GROUP Alpha 15
Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
DBT-SEQ-NUMBER Numeric 6
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
DBT-ACTIVITY Alpha 15 AC54.2 AC54.3
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
DBT-ACCT-CATEGORY Alpha 5 AC54.3
Account Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
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.
DBT-POSTING-DATE Numeric 8 (yyyymmdd)
Posting Date The date assigned to the journal entry
for posting.
DBT-TRANS-DATE Numeric 8 (yyyymmdd) AC54.2
Transaction Date The date of the transaction.
DBT-DIST-COMPANY Numeric 4
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
DBT-DS-ACCT-UNIT Alpha 15
Ds Acct Unit
DBT-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
DBT-TRAN-CURRENCY Alpha 5
Tax Transaction
Currency
DBT-TRAN-AMOUNT Signed 15.2
Invoice Amount This is the amount in transaction
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
DBT-TRAN-ND Numeric 1
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
DBT-PAYMENT-AMT Signed 15.2
Payment Amt
DBT-PAYMENT-CURR Alpha 5
Payment Curr
DBT-PAYMENT-ND Numeric 1
Payment Nd
DBT-PAYMENT-RATE Signed 12.6
Payment Rate
DBT-INVOICE Alpha 22
Invoice Number Used to identify the invoice.
DBT-EXPENSE-CODE Alpha 20 AC54.2
Expense Code
DBT-AP-COMPANY Numeric 4 AC54.2
Ap Company
DBT-VENDOR Alpha 9 (Right Justified)
Vendor ID The vendor's identification code.
DBT-SOURCE-CODE Alpha 2
Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
DBT-UNITS-AMOUNT Signed 15.2
Units Amount This is the units amount included in
the file.
DBT-PAYMENT-TYPE Alpha 2
Payment Type
DBT-HR-COMPANY Numeric 4
HR Company
DBT-EMPLOYEE Numeric 9
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
DBT-PAY-CODE Alpha 4
Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
DBT-LOCAT-CODE Alpha 10
Location
DBT-JOB-CODE Alpha 9
Job Code Contains a user-defined code that
represents a type of job.
DBT-SHIFT Numeric 1
Shift Contains the shift number associated
with the pay.
DBT-MATRIX-CAT-1 Alpha 12
Attribute 1
DBT-MATRIX-CAT-2 Alpha 12
Attribute 2
DBT-MATRIX-CAT-3 Alpha 12
Attribute 3
DBT-MX-VALUE-1 Alpha 32
Attribute Value
DBT-MX-VALUE-2 Alpha 32
Attribute Value
DBT-MX-VALUE-3 Alpha 32
Attribute Value
DBT-TRANS-TYPE Alpha 1 AC54.2
Transaction Type Determines if amounts or units are
processed in each transaction.
DBT-PREV-RUN-GROUP Alpha 12
Prev Run Group
DBT-FLAG1 Alpha 1
Tax Distrib. Flag -
Tax Code 1
DBT-ORIG-OBJ-ID Numeric 12
Orig Obj Id
DBT-ATN-OBJ-ID Numeric 12 AC541
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
DBT-PAY-PER-END-DT Numeric 8 (yyyymmdd)
Pay Per End Dt
DBT-PAY-VENDOR Alpha 9 (Right Justified) AC54.2
Paid Vendor
ACDBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DBTSET1 RUN-GROUP AC54.2 AC54.3
SEQ-NUMBER AC541 AC542
|
