EECEXPENSE – Expense Interface

System: Accounts Payable (AP)
Prefix: CVE
Primary key: COMPANY, VENDOR, EXPENSE-NBR
Fields: 43
Updated by: 3 programs
Referenced by: 0 programs

EECEXPENSE is the Expense Interface table in Lawson Accounts Payable (prefix CVE). It is indexed by COMPANY, VENDOR, EXPENSE-NBR (CVESET1). It is updated by EE52.1, EE52.2 and EE520. The table has 43 fields, 1 index and 0 documented relations.

About EECEXPENSE

No description in the Lawson data dictionary.

Fields (43)

Column = COBOL field name without the CVE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CVE-COMPANY` PK COMPANY	Numeric 4	Required. The company number. Must be a valid record in the Accounts Payable Company file.	EE52.1
`CVE-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	Required. The employee number. Must be a valid record in the Accounts Payable Vendor file.	EE52.1
`CVE-EXPENSE-NBR` PK EXPENSE_NBR	Alpha 10	Required. The expense report number.	EE52.1
`CVE-EXPENSE-TYPE` EXPENSE_TYPE	Alpha 1	Required. Identifies the type of expense. Valid values are: `E` Expense. `P` Cash Payback.	EE52.1
`CVE-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description assigned to the employee expense report.	EE52.1
`CVE-REC-STATUS` REC_STATUS	Numeric 1	Required. The record status of the expense. Valid values are: matching or payment. `0` Unreleased. Not available for `1` Open. Available for payment.	EE52.1
`CVE-POSTING-STATUS` POSTING_STATUS	Numeric 1	Required. The posting status of associated expense report distributions. Valid values are: available for posting. for posting. 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. `0` Unreleased. Distributions not `1` Unposted. Distributions available `9` Posted. Distributions posted to the	EE52.1, EE52.2
`CVE-APPROVAL-CODE` APPROVAL_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` EXPENSE_DATE	Numeric 8 (yyyymmdd)	Required. The date the expense was incurred. Used when updating the employee's purchase balance.	EE52.1
`CVE-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	Required. The due date of the employee expense.	EE52.1
`CVE-DISTRIB-DATE` DISTRIB_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` TRAN_EXP_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` BASE_EXP_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` BASE_TAX_AMT	Signed 18.2	The total tax amount of the expense in the company base currency.	EE52.1
`CVE-BASE-EMP-PAID` BASE_EMP_PAID	Signed 18.2	The total employee-paid amount of the expense in the company base currency.	EE52.1
`CVE-PROC-LEVEL` PROC_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` DEF_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` 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` 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` 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` ACCR_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` HLD_CODE	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` HOLD_TYPE	Alpha 1	Indicates the type of invoice hold code assigned to the employee expense, if assigned. Valid values are: Payable, the expense will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the expense record. 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. `T` Temporary. Upon release to Accounts `P` Permanent. Upon release to Accounts	—
`CVE-REL-FOR-PMT` REL_FOR_PMT	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` REFERENCE	Alpha 10 (Lower Case)	The default reference assigned to the employee expense. Defaults on distributions entered for the expense.	—
`CVE-DIST-DESCRIPT` DIST_DESCRIPT	Alpha 30 (Lower Case)	The default description assigned to the expense. Defaults on distributions entered for the expense.	—
`CVE-DIST-COMPANY` DIST_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` DEF_TRAN_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` 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` CURR_EFF_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` TRANS_NBR	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` BANK_INST_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` CHECK_DATE	Numeric 8 (yyyymmdd)	The date assigned to the manual payment. This field is not used.	EE52.1
`CVE-CHECK-AMT` CHECK_AMT	Signed 18.2	The manual payment amount issued for the employee expense. This field is not used.	EE52.1
`CVE-CROSS-REF` CROSS_REF	Alpha 10	The user-defined cross reference value assigned to the expense.	EE52.1
`CVE-TRANS-IDENT` TRANS_IDENT	Numeric 10	A unique system-generated identification value assigned to the transaction to make this record unique.	—
`CVE-REMIT-TO-CODE` 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` 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` 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` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	EE52.1
`CVE-ADVANCE-NBR` 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` 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` 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

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CVESET1`	`COMPANY`, `VENDOR`, `EXPENSE-NBR`	Primary		EE52.1, EE52.2, EE520

Programs

Updated by (3)

EE52.1 Expense Update
EE52.2 Distribution
EE520 Expense Interface