EECDISTRIB – Expense Distribution Interface

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

EECDISTRIB is the Expense Distribution Interface table in Lawson Accounts Payable (prefix CVT). It is indexed by COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR (CVTSET1). It is updated by EE52.1, EE52.2 and EE520. The table has 26 fields, 1 index and 0 documented relations.

About EECDISTRIB

No description in the Lawson data dictionary.

Fields (26)

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

Field / column	Type	Description & values	Updated by
`CVT-COMPANY` PK COMPANY	Numeric 4	Required. The company number. Must be a valid record in the Accounts Payable Company file.	EE52.2
`CVT-VENDOR` PK VENDOR	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` PK EXPENSE_NBR	Alpha 10	Required. The expense report number.	EE52.2
`CVT-SEQ-NBR` PK 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` REC_STATUS	Numeric 1	Required. The record status of the distribution. Valid values are: `0` Unreleased. `1` Open.	EE52.2
`CVT-CATEGORY` 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` TRAN_EXP_AMT	Signed 18.2	Required. The amount of the distribution in the currency of the expense.	EE52.2
`CVT-BASE-EXP-AMT` BASE_EXP_AMT	Signed 18.2	—	—
`CVT-TAX-INDICATOR` TAX_INDICATOR	Numeric 1	—	EE52.2
`CVT-TAX-CODE` 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` TAX_RATE	Percent 7.5 (Percent)	Charge rate by month.	EE52.2
`CVT-ACCR-CODE` ACCR_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` TAXABLE_AMT	Signed 18.2	The amount of the expense distribution that is taxable.	EE52.2
`CVT-EXP-CURRENCY` EXP_CURRENCY	Alpha 5	The currency of the expense distribution. Must be a valid record in the Currency Codes file.	EE52.2
`CVT-CURR-RATE` CURR_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` CURR_EFF_DATE	Numeric 8 (yyyymmdd)	The effective date for the currency exchange rate.	EE52.2
`CVT-EXPENSE-DATE` EXPENSE_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	EE52.2
`CVT-DIST-COMPANY` DIST_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` EXP_ACCT_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` EXP_ACCOUNT	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` EXP_SUB_ACCT	Numeric 4	The general ledger distribution subaccount number. Must be a valid record in the Lawson General Ledger system.	EE52.2
`CVT-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the distribution. Must be a valid record in Project Accounting.	EE52.2
`CVT-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference value assigned to the distribution.	EE52.2
`CVT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description assigned to the distribution.	EE52.2
`CVT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the distribution. Must be a valid record in Project Accounting.	EE52.2
`CVT-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.2

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
`CVTSET1`	`COMPANY`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`	Primary		EE52.1, EE52.2, EE520

Programs

Updated by (3)

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