EECDISTRIB

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
Element: Company
Numeric 4
Required. The company number. Must be a valid record in the Accounts Payable Company file.
EE52.2
CVT-VENDOR
Element: Employee
Alpha 9 (Right Justified)
Required. The employee number. Must be a valid vendor record in the Accounts Payable Vendor file.
EE52.2
CVT-EXPENSE-NBR
Element: Expense Nbr
Alpha 10
Required. The expense report number.
EE52.2
CVT-SEQ-NBR
Element: Seq Nbr
Numeric 4
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.
EE52.2
CVT-REC-STATUS
Element: Rec Status
Numeric 1
Required. The record status of the distribution. Valid values are: 0 = Unreleased. 1 = Open.
EE52.2
CVT-CATEGORY
Element: Category
Alpha 9
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.
EE52.2
CVT-TRAN-EXP-AMT
Element: Intl Amt
Signed 18.2
Required. The amount of the distribution in the currency of the expense.
EE52.2
CVT-BASE-EXP-AMT
Element: Intl Amt
Signed 18.2
CVT-TAX-INDICATOR
Element: Tax Indicator
Numeric 1
EE52.2
CVT-TAX-CODE
Element: Tax Code
Alpha 10
The tax code assigned to the expense distribution. Must be a valid record in the Tax Code file.
EE52.2
CVT-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
Charge rate by month.
CVT-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
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.
EE52.2 EE520
CVT-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
The amount of the expense distribution that is taxable.
EE52.2
CVT-EXP-CURRENCY
Element: Expense Currency
Alpha 5
The currency of the expense distribution. Must be a valid record in the Currency Codes file.
EE52.2
CVT-CURR-RATE
Element: Exchange Rate
Signed 14.7
The exchange rate for the expense distribution. Used to convert a non-base currency expense amount to the company base currency.
EE52.2
CVT-CURR-EFF-DATE
Element: Date
Numeric 8 (yyyymmdd)
The effective date for the currency exchange rate.
EE52.2
CVT-EXPENSE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
EE52.2
CVT-DIST-COMPANY
Element: Posting Company
Numeric 4
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.
EE52.2
CVT-EXP-ACCT-UNIT
Distribution
Accounting Unit
Alpha 15
The general ledger distribution accounting unit. Must be a valid record in the Lawson General Ledger system.
EE52.2
CVT-EXP-ACCOUNT
Distribution
Account Number
Numeric 6
The general ledger distribution account number. Must be a valid record in the Lawson General Ledger system.
EE52.2
CVT-EXP-SUB-ACCT
Distribution
Subaccount Number
Numeric 4
The general ledger distribution subaccount number. Must be a valid record in the Lawson General Ledger system.
EE52.2
CVT-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the distribution. Must be a valid record in Project Accounting.
EE52.2
CVT-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference value assigned to the distribution.
EE52.2
CVT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description assigned to the distribution.
EE52.2
CVT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category assigned to the distribution. Must be a valid record in Project Accounting.
EE52.2
CVT-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
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.
EE52.2


EECDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVTSET1 COMPANY
VENDOR
EXPENSE-NBR
SEQ-NBR
EE52.1 EE52.2
EE520


File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.