|
|
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
Element: Company Required. The company number. Must be a
valid record in the Accounts Payable
Company file.
CVT-VENDOR Alpha 9 (Right Justified) EE52.2
Element: Employee Required. The employee number. Must be
a valid vendor record in the Accounts
Payable Vendor file.
CVT-EXPENSE-NBR Alpha 10 EE52.2
Element: Expense Nbr Required. The expense report number.
CVT-SEQ-NBR Numeric 4 EE52.2
Element: Seq Nbr 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
Element: Rec Status Required. The record status of the
distribution. Valid values are:
0 = Unreleased.
1 = Open.
CVT-CATEGORY Alpha 9 EE52.2
Element: 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 18.2 EE52.2
Element: Intl Amt Required. The amount of the
distribution in the currency of the
expense.
CVT-BASE-EXP-AMT Signed 18.2
Element: Intl Amt
CVT-TAX-INDICATOR Numeric 1 EE52.2
Element: Tax Indicator
CVT-TAX-CODE Alpha 10 EE52.2
Element: 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)
Element: Chrg Rate Charge rate by month.
CVT-ACCR-CODE Alpha 4 EE52.2 EE520
Element: Invoice AccruaThe 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 18.2 EE52.2
Element: Intl Amt The amount of the expense distribution
that is taxable.
CVT-EXP-CURRENCY Alpha 5 EE52.2
Element: Expense CurrenThe currency of the expense
distribution. Must be a valid record in
the Currency Codes file.
CVT-CURR-RATE Signed 14.7 EE52.2
Element: 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
Element: Date The effective date for the currency
exchange rate.
CVT-EXPENSE-DATE Numeric 8 (yyyymmdd) EE52.2
Element: Date This field displays the system date
when this was created.
CVT-DIST-COMPANY Numeric 4 EE52.2
Element: Posting CompanThe 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
Element: Activity The activity assigned to the
distribution. Must be a valid record in
Project Accounting.
CVT-REFERENCE Alpha 10 (Lower Case) EE52.2
Element: Reference The reference value assigned to the
distribution.
CVT-DESCRIPTION Alpha 30 (Lower Case) EE52.2
Element: Description The description assigned to the
distribution.
CVT-ACCT-CATEGORY Alpha 5 EE52.2
Element: Acct Category The account category assigned to the
distribution. Must be a valid record in
Project Accounting.
CVT-SEGMENT-BLOCK Alpha 103 EE52.2
Element: Segment Block 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 EE52.1 EE52.2
VENDOR EE520
EXPENSE-NBR
SEQ-NBR
|
