EECEXPENSE

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVESET1 COMPANY
VENDOR
EXPENSE-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.