|
|
ACDBTRANS FILE
UPDATED BY
AC54.2 AC54.3 AC541 AC542
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DBT-RUN-GROUP Alpha 15
Element: 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
Element: Activity Activities are the processes or AC542
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 AC542
Element: Account CategoAccount 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)
Element: Date
DBT-TRANS-DATE Numeric 8 (yyyymmdd) AC54.2
Element: Date
DBT-DIST-COMPANY Numeric 4
Element: Company
DBT-DS-ACCT-UNIT Alpha 15
Element: Ds Acct Unit
DBT-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
DBT-TRAN-CURRENCY Alpha 5
To Company Base
Currency
DBT-TRAN-AMOUNT Signed 15.2
Element: Adj Amt
DBT-TRAN-ND Numeric 1
Account Currency
Code
DBT-PAYMENT-AMT Signed 15.2
Element: Adj Amt
DBT-PAYMENT-CURR Alpha 5
Element: Payment Curr
DBT-PAYMENT-ND Numeric 1
Element: Payment Nd
DBT-PAYMENT-RATE Signed 12.6
Element: Payment Rate
DBT-INVOICE Alpha 22
Element: Invoice NumberUsed to identify the invoice.
DBT-EXPENSE-CODE Alpha 20 AC54.2
Element: Expense Code
DBT-AP-COMPANY Numeric 4 AC54.2
Element: Ap Company
DBT-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The vendor's identification code.
DBT-SOURCE-CODE Alpha 2
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
DBT-UNITS-AMOUNT Signed 15.2
Element: Adj Amt This is the units amount included in
the file.
DBT-PAYMENT-TYPE Alpha 2
Element: Payment Type
DBT-HR-COMPANY Numeric 4
Element: Company
DBT-EMPLOYEE Numeric 9
Element: 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
Element: 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
Element: Location
DBT-JOB-CODE Alpha 9
Element: Job Code Contains a user-defined code that
represents a type of job.
DBT-SHIFT Numeric 1
Element: Shift Contains the shift number associated
with the pay.
DBT-MATRIX-CAT-1 Alpha 12
Element: Attribute
DBT-MATRIX-CAT-2 Alpha 12
Element: Attribute
DBT-MATRIX-CAT-3 Alpha 12
Element: Attribute
DBT-MX-VALUE-1 Alpha 32
Element: Attribute Value
DBT-MX-VALUE-2 Alpha 32
Element: Attribute Value
DBT-MX-VALUE-3 Alpha 32
Element: Attribute Value
DBT-TRANS-TYPE Alpha 1 AC54.2 AC542
Element: Transaction TyDetermines if amounts or units are
processed in each transaction.
DBT-PREV-RUN-GROUP Alpha 15
Element: Prev Run Group
DBT-FLAG1 Alpha 1
Tax Distrib. Flag - D = Daily
Tax Code 1 F = Final
A = Adjustment
M = Manual
DBT-ORIG-OBJ-ID Numeric 12
Element: Orig Obj Id
DBT-ATN-OBJ-ID Numeric 12 AC541
Object
Identification
DBT-PAY-PER-END-DT Numeric 8 (yyyymmdd)
Element: Pay Per End Dt
DBT-PAY-VENDOR Alpha 9 (Right Justified) AC54.2
Element: Vendor ID
DBT-RECORD-TYPE Alpha 1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
1 = Offset Entry
2 = Adjusted Entry
DBT-ADJ-ORIG-OBJID Numeric 12
Element: Adj Orig Objid
ACDBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DBTSET1 RUN-GROUP AC54.2 AC54.3
SEQ-NUMBER AC541 AC542
DBTSET2 RUN-GROUP KeyChange
SEQ-NUMBER
SOURCE-CODE
FLAG1
|
