Expense Interface

The Expense Interface file is used by the Expense Interface program to interface employee expense records from a desktop application or a non-Lawson system to the Lawson Employee Expense system. When you run EE520 (Expense Interface), the system reads records in this file for interface into the Employee Expense file and, for released status expenses, into the Accounts Payable Invoice file. When the Expense Interface file records are successfully interfaced, they are purged from this file. You can use EE52.1 (Expense Update) to add records to this file or maintain records already loaded into this file before interfacing the records. Expense records with an open status must have one or more corresponding records in the Expense Distribution Interface file.
UPDATED BY

EE52.1

EE52.2

EE520

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CVE-COMPANY Element: Company	Numeric 4 Required. The company number. Must be a valid record in the Accounts Payable Company file.	EE52.1
CVE-VENDOR Element: Employee	Alpha 9 (Right Justified) Required. The employee number. Must be a valid record in the Accounts Payable Vendor file.	EE52.1
CVE-EXPENSE-NBR Element: Expense Nbr	Alpha 10 Required. The expense report number.	EE52.1
CVE-EXPENSE-TYPE Element: Expense Type	Alpha 1 Required. Identifies the type of expense. Valid values are: E = Expense. P = Cash Payback.	EE52.1
CVE-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description assigned to the employee expense report.	EE52.1
CVE-REC-STATUS Element: Rec Status	Numeric 1 Required. The record status of the expense. Valid values are: 0 = Unreleased. Not available for matching or payment. 1 = Open. Available for payment.	EE52.1
CVE-POSTING-STATUS Expense Report Posting Status	Numeric 1 Required. The posting status of associated expense report distributions. Valid values are: 0 = Unreleased. Distributions not available for posting. 1 = Unposted. Distributions available for posting. 9 = Posted. Distributions posted to the general ledger. Note: If the expense status is Unreleased, the distribution posting status must be Unreleased. If the expense status is Open, the distribution posting status must be Unposted or Posted.	EE52.1 EE52.2
CVE-APPROVAL-CODE Element: Auth Code	Alpha 3 The approval code assigned to the employee expense. Used for approving expenses to be released to the Accounts Payable system. Must be a valid record in the Approval Code file.	EE52.1
CVE-EXPENSE-DATE Element: Date	Numeric 8 (yyyymmdd) Required. The date the expense was incurred. Used when updating the employee's purchase balance.	EE52.1
CVE-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) Required. The due date of the employee expense.	EE52.1
CVE-DISTRIB-DATE Element: Post Date	Numeric 8 (yyyymmdd) The date used for posting the expense report distributions to the general ledger. If left blank, the expense date defaults.	EE52.1
CVE-TRAN-EXP-AMT Element: Intl Amt	Signed 18.2 Required. The total amount of the employee expense. Includes both company-paid and employee-paid expenses. Must be entered in company currency. This field contains the same value as the Base Currency Expense Amount field.	EE52.1
CVE-BASE-EXP-AMT Element: Intl Amt	Signed 18.2 The amount of the employee expense in the company base currency. Includes both company-paid and employee-paid expenses.	EE52.1
CVE-BASE-TAX-AMT Element: Intl Amt	Signed 18.2 The total tax amount of the expense in the company base currency.	EE52.1
CVE-BASE-EMP-PAID Element: Intl Amt	Signed 18.2 The total employee-paid amount of the expense in the company base currency.	EE52.1
CVE-PROC-LEVEL Element: Process Level	Alpha 5 The process level assigned to the employee expense. Must be a valid record in the Accounts Payable Process Level file. This field is required if the company does not have a default process level assigned.	EE52.1
CVE-DEF-ACCT-UNIT Element: Acct Unit	Alpha 15 Required. The default general ledger accounting unit assigned to the employee expense. Defaults on all expense distributions that do not have an accounting unit assigned.	EE52.1
CVE-ACTIVITY Element: Activity	Alpha 15 The default activity assigned to the expense. Defaults on detail lines entered for the expense. Must be a valid record in Project Accounting.	EE52.1
CVE-ACCT-CATEGORY Element: Acct Category	Alpha 5 The default account category assigned to the expense. Defaults on detail lines entered for the expense. Must be a valid record in Project Accounting.	EE52.1
CVE-CASH-CODE Element: Cash Code	Alpha 4 The cash code assigned to the employee expense. Represents the bank account the expense is to be paid from. Must be a valid record in the Cash Code file.	EE52.1
CVE-ACCR-CODE Element: Invoice Accrual Code	Alpha 4 The invoice accrual code assigned to the employee expense. Used to default a general ledger invoice accrual account to the expense. Must be a valid record in the Invoice Accrual Code file. If left blank, the invoice accrual code assigned to the employee, if assigned, the process level, or the company defaults.	EE52.1
CVE-HLD-CODE Element: Hld Code Ap	Alpha 4 The hold code assigned to the employee expense, if assigned. Used to prevent the expense from being scheduled for payment in the Lawson Accounts Payable system. Must be a valid invoice hold code record in the Hold Code file.	EE52.1
CVE-HOLD-TYPE Element: Hold Type	Alpha 1 Indicates the type of invoice hold code assigned to the employee expense, if assigned. Valid values are: T = Temporary. Upon release to Accounts Payable, the expense will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the expense record. P = Permanent. Upon release to Accounts Payable, the expense will be held until you remove the hold code from the expense record. Blank. A hold code is not assigned to the employee expense.
CVE-REL-FOR-PMT Element: All Flag	Alpha 1 Indicates whether the expense can be released to Accounts Payable. Valid values are: Y = Yes. Default value. N = No.	EE52.1
CVE-REFERENCE Element: Reference	Alpha 10 (Lower Case) The default reference assigned to the employee expense. Defaults on distributions entered for the expense.
CVE-DIST-DESCRIPT Element: Description	Alpha 30 (Lower Case) The default description assigned to the expense. Defaults on distributions entered for the expense.
CVE-DIST-COMPANY Element: Posting Company	Numeric 4 The company the expense will be posted to. Must be a valid general ledger company record and a valid intercompany relationship must be defined in the Lawson General Ledger system.	EE52.1
CVE-DEF-TRAN-CURR Element: To Base Curr	Alpha 5 The default currency assigned to the expense. Defaults on distributions entered for the expense. Must be a valid record in the Lawson Currency system.	EE52.1
CVE-DEF-CNV-RATE Element: Def Cnv Rate	Percent 14.6 (Percent) The default exchange rate for the employee expense. Defaults on distributions entered for the expense. If left blank and a Default Currency is defined, the rate defined for the relationship defaults.	EE52.1
CVE-CURR-EFF-DATE Element: Date	Numeric 8 (yyyymmdd) The effective date of the exchange rate, if entered. If left blank, the expense date defaults.	EE52.1
CVE-TRANS-NBR Element: Payment Number	Alpha 10 (Right Justified) The payment number assigned to the employee expense if paid with a manual payment. This field is not used.	EE52.1
CVE-BANK-INST-CODE Cash Payment Transaction Code	Alpha 3 The payment code assigned to the employee expense. If left blank, the payment code assigned to the employee, vendor class, or pay group defaults.	EE52.1
CVE-CHECK-DATE Element: Check Date	Numeric 8 (yyyymmdd) The date assigned to the manual payment. This field is not used.	EE52.1
CVE-CHECK-AMT Element: Intl Amt	Signed 18.2 The manual payment amount issued for the employee expense. This field is not used.	EE52.1
CVE-CROSS-REF Element: Cross Reference	Alpha 10 The user-defined cross reference value assigned to the expense.	EE52.1
CVE-TRANS-IDENT Element: Transaction ID	Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique.
CVE-REMIT-TO-CODE Element: Remit To Code	Alpha 4 The remit to location assigned to the expense. Represents an alternate remittance address for the employee. Must be a valid record in the Vendor Location file.	EE52.1
CVE-INVOICE-GROUP Element: Invoice Group	Alpha 4 The user-defined invoice group assigned to the expense. Cash Requirements (AP150) has an option to select all transactions assigned the same invoice group. If blank, the invoice group defaults from the employee, if assigned.	EE52.1
CVE-APPROVED-FLAG Element: Approved Flag	Alpha 1 Indicates whether the expense is approved for payment. Valid values are: Y = Yes. Default value. N = No. D = Disapproved.
CVE-JRNL-BOOK-NBR Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.	EE52.1
CVE-ADVANCE-NBR Element: Advance Nbr	Alpha 10 If an employee advance was issued for the expense report, and the company has Matching selected in the Employee Expense Reconciliation field, you can type the advance number in this field to apply the full expense amount to the advance. Entry in this field creates a record in the Advance-Expense Matching file.	EE52.1
CVE-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.1
CVE-JBK-SEQ-NBR Element: Jbk Seq Nbr	Numeric 10 The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).	EE52.1

EECEXPENSE FILE INDEX

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