EECDISTRIB FILE
Expense Distribution Interface
The Expense Distribution Interface file is used by the Expense Interface
program to interface expense distribution records to the Lawson Employee
Expense and Accounts Payable systems. When you run EE520 (Expense Interface),
the system reads records in this file for interface into the Expense
Distribution file and, for released status expenses, into the Invoice
Distribution file.
When Distribution Interface records are successfully interfaced from the
Expense Distribution Interface file, they are purged from the interface file.
You can use EE52.2 (Distribution) to add records to the interface file or
maintain records already loaded into the file before interfacing the records.
UPDATED BY
EE52.1 EE52.2 EE520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVT-COMPANY Numeric 4 EE52.2
Company Required. The company number. Must be a
valid record in the Accounts Payable
Company file.
CVT-VENDOR Alpha 9 (Right Justified) EE52.2
Employee Required. The employee number. Must be
a valid vendor record in the Accounts
Payable Vendor file.
CVT-EXPENSE-NBR Alpha 10 EE52.2
Expense Number Required. The expense report number.
CVT-SEQ-NBR Numeric 4 EE52.2
Sequence Number Required if you have more than one line
of distribution for an expense. A unique
system-assigned identification value
assigned to the distribution to make the
record unique.
CVT-REC-STATUS Numeric 1 EE52.2
Record Status Required. The record status of the
distribution. Valid values are:
0 = Unreleased.
1 = Open.
CVT-CATEGORY Alpha 9 EE52.2
Category Required. The category code assigned to
the expense distribution. Identifies the
type of expense. Represents a general
ledger account and optional distribution
information. Must be a valid record in
the Category Code file.
CVT-TRAN-EXP-AMT Signed 15.2 EE52.2
Transaction Expense Required. The amount of the
Amount distribution in the currency of the
expense.
CVT-BASE-EXP-AMT Signed 15.2
Total Expense Amount The base currency amount for the
distribution.
CVT-TAX-CODE Alpha 10 EE52.2
Tax Code The tax code assigned to the expense
distribution. Must be a valid record in
the Tax Code file.
CVT-TAX-RATE Percent 7.5 (Percent)
Tax Rate The tax rate defined for the tax code.
CVT-ACCR-CODE Alpha 4 EE52.2
Invoice Accrual Code The invoice accrual code assigned to a
company-paid expense distribution. Used
to default a general ledger accrual
account to the expense. Must be a valid
record in the Invoice Accrual Code file.
CVT-TAXABLE-AMT Signed 15.2 EE52.2
Taxable Amount The amount of the expense distribution
that is taxable.
CVT-EXP-CURRENCY Alpha 5 EE52.2
Expense Currency The currency of the expense
distribution. Must be a valid record in
the Currency Codes file.
CVT-CURR-RATE Signed 13.6 EE52.2
Exchange Rate The exchange rate for the expense
distribution. Used to convert a non-base
currency expense amount to the company
base currency.
CVT-CURR-EFF-DATE Numeric 8 (yyyymmdd) EE52.2
Currency Effective The effective date for the currency
Date exchange rate.
CVT-EXPENSE-DATE Numeric 8 (yyyymmdd) EE52.2
Expense Date The date the expense was incurred.
CVT-DIST-COMPANY Numeric 4 EE52.2
Posting Company The company the distribution will be
posted to. Must be a valid record in the
General Ledger Company file and a valid
intercompany relationship must exist in
the Lawson General Ledger system.
CVT-EXP-ACCT-UNIT Alpha 15 EE52.2
Distribution The general ledger distribution
Accounting Unit accounting unit. Must be a valid record
in the Lawson General Ledger system.
CVT-EXP-ACCOUNT Numeric 6 EE52.2
Distribution The general ledger distribution account
Account Number number. Must be a valid record in the
Lawson General Ledger system.
CVT-EXP-SUB-ACCT Numeric 4 EE52.2
Distribution The general ledger distribution
Subaccount Number subaccount number. Must be a valid
record in the Lawson General Ledger
system.
CVT-ACTIVITY Alpha 15 EE52.2
Activity The activity assigned to the
distribution. Must be a valid record in
the Lawson Activity Management system.
CVT-REFERENCE Alpha 10 (Lower Case) EE52.2
Reference The reference value assigned to the
distribution.
CVT-DESCRIPTION Alpha 30 (Lower Case) EE52.2
Description The description assigned to the
distribution.
CVT-ACCT-CATEGORY Alpha 5 EE52.2
Account Category The account category assigned to the
distribution. Must be a valid record in
the Lawson Activity Management system.
CVT-SEGMENT-BLOCK Alpha 103 EE52.2
User Analysis This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
EECDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVTSET1 COMPANY This index is used to access interface EE52.1 EE52.2
VENDOR records. EE520
EXPENSE-NBR
SEQ-NBR
|
