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.	EE52.2
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

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