EEDISTRIB – Expense Distribution

System: Accounts Payable (AP)
Prefix: EED
Primary key: COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR
Fields: 38
Updated by: 13 programs
Referenced by: 5 programs

EEDISTRIB is the Expense Distribution table in Lawson Accounts Payable (prefix EED). It is indexed by COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR (EEDSET1); alternate indexes: EEDSET2, EEDSET3, EEDSET4, EEDSET5, EEDSET6 and EEDSET8. It is related 1:1 to EECATEGORY, EEEXPENSE, GLMASTER and GLNAMES. It is updated by AP198, AP30.4, AP300, AP305, EE11.1, EE135, EE175, EE20.2 and 5 more and referenced by AP175, EE220, EE275, EE90.3 and EEI1.1. The table has 38 fields, 7 indexes and 4 documented relations.

About EEDISTRIB

The Employee Expense Distribution file is used to store expense distribution detail records.

Fields (38)

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

Field / column	Type	Description & values	Updated by
`EED-COMPANY` PK COMPANY	Numeric 4	The company number. Must be a valid record in the Accounts Payable Company file.	EE11.1, EE20.3, EE20.4, EE520
`EED-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	The employee number. Must be a valid record in the Accounts Payable Vendor file.	EE11.1, EE20.3, EE20.4, EE520
`EED-EXPENSE-NBR` PK EXPENSE_NBR	Alpha 10	A unique, user-defined number assigned to the employee expense.	EE11.1, EE20.3, EE20.4, EE520
`EED-SEQ-NBR` PK SEQ_NBR	Numeric 4	A unique system-assigned identification value assigned to the distribution to make the record unique.	EE11.1, EE20.3, EE20.4, EE520
`EED-ORIG-SEQ-NBR` ORIG_SEQ_NBR	Numeric 4	—	—
`EED-REC-STATUS` REC_STATUS	Numeric 1	The record status of the distribution. Valid values are: expense distributions only). `0` Unreleased. `1` Released. `9` Posted by EE175 (company-paid	AP30.4, EE11.1, EE135, EE175, EE20.3, EE20.4, EE35.1, EE35.2 +1 more
`EED-CATEGORY` CATEGORY	Alpha 9	The category code assigned to the employee expense distribution. Identifies the type of expense. Used to default a general ledger account and optional distribution information to the expense distribution during entry. Must be a valid record in the Category Code file.	EE11.1, EE20.3, EE20.4, EE520
`EED-TRAN-EXP-AMT` TRAN_EXP_AMT	Signed 18.2	The amount of the distribution in the currency of the transaction.	AP30.4, EE11.1, EE20.3, EE20.4, EE520
`EED-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions defined for the transaction currency.	EE11.1, EE20.3, EE20.4, EE520
`EED-BASE-EXP-AMT` BASE_EXP_AMT	Signed 18.2	The amount of the distribution in the company base currency.	AP30.4, EE11.1, EE20.3, EE20.4, EE520
`EED-TAX-SEQ-NBR` TAX_SEQ_NBR	Numeric 4	—	—
`EED-TAX-INDICATOR` TAX_INDICATOR	Numeric 1	—	EE520
`EED-TAX-CODE` TAX_CODE	Alpha 10	The tax code assigned to an employee expense tax distribution. Must be a valid record in the Tax Code file.	EE11.1, EE20.3, EE520
`EED-TAX-RATE` TAX_RATE	Percent 7.5 (Percent)	Charge rate by month.	EE11.1, EE20.3, EE520
`EED-TAX-TYPE` TAX_TYPE	Alpha 1	The type of tax represented by the tax code.	EE11.1, EE20.3, EE520
`EED-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.	EE11.1, EE20.2, EE20.3, EE20.4, EE520
`EED-APA-ACCT-UNIT` APA_ACCT_UNIT	Alpha 15	The general ledger accrual accounting unit assigned to the distribution. Must be a valid record in the General Ledger Names file.	EE520
`EED-APA-ACCOUNT` APA_ACCOUNT	Numeric 6	The general ledger accrual account number assigned to the distribution. Must be a valid record in the General Ledger Account Master file.	EE520
`EED-APA-SUB-ACCT` APA_SUB_ACCT	Numeric 4	The general ledger accrual subaccount number assigned to the distribution. Must be a valid record in the General Ledger Account Master file.	EE520
`EED-TAXABLE-AMT` TAXABLE_AMT	Signed 18.2	The amount of the expense distribution that is taxable.	AP30.4, EE11.1, EE20.3, EE520
`EED-CATEGORY-TYPE` CATEGORY_TYPE	Alpha 1	Identifies the type of expense. Valid values are: `E` Employee Paid Expense. `C` Company Paid Expense. `P` Cash Payment (payback). `U` Units.	EE11.1, EE20.3, EE20.4, EE520
`EED-EXP-CURRENCY` EXP_CURRENCY	Alpha 5	The currency of the distribution. Must be a valid record in the Currency Codes file.	EE11.1, EE20.3, EE20.4, EE520
`EED-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.	EE11.1, EE20.3, EE20.4, EE520
`EED-CURR-EFF-DATE` CURR_EFF_DATE	Numeric 8 (yyyymmdd)	The effective date for the currency exchange rate.	EE11.1, EE20.3, EE20.4, EE520
`EED-EXPENSE-DATE` EXPENSE_DATE	Numeric 8 (yyyymmdd)	The date the expense was incurred.	EE11.1, EE20.3, EE20.4, EE520
`EED-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. A valid intercompany relationship must exist in the General Ledger Intercompany file. The company that a transaction should be posted to. A valid intercompany relationship must be defined in the Lawson General Ledger system.	EE11.1, EE20.3, EE20.4, EE520
`EED-DISTRIB-DATE` DISTRIB_DATE	Numeric 8 (yyyymmdd)	The general ledger posting date assigned to the distribution.	AP30.4, EE11.1, EE20.2, EE20.3, EE20.4, EE520
`EED-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	The general ledger distribution accounting unit. Must be a valid record in the General Ledger Names file.	EE11.1, EE20.3, EE20.4, EE520
`EED-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	The general ledger distribution account number. Must be a valid record in the General Ledger Account Master file.	EE11.1, EE20.3, EE20.4, EE520
`EED-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	The general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.	EE11.1, EE20.3, EE20.4, EE520
`EED-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the employee expense distribution. Must be a valid record in the Lawson Activity Management system.	EE11.1, EE20.3, EE20.4, EE520
`EED-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference value assigned to the distribution.	EE11.1, EE20.3, EE20.4, EE520
`EED-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description assigned to the distribution.	EE11.1, EE20.3, EE20.4, EE520
`EED-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	EE135, EE175, EE35.1, EE35.2, EE520
`EED-ACT-OBJ-ID` ACT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	EE135, EE175, EE35.1, EE35.2, EE520
`EED-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the employee expense distribution. Must be a valid record in the Lawson Activity Management system.	EE11.1, EE20.3, EE20.4, EE520
`EED-UNT-AMOUNT` UNT_AMOUNT	Signed 18.2	The total unit amount for the distribution.	EE11.1, EE20.3, EE520
`EED-ANALYSIS-FLD` ANALYSIS_FLD	Alpha 32	The user-defined analysis field assigned to the distribution.	EE11.1, EE20.3, EE20.4

Indexes (7)

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
`EEDSET1`	`COMPANY`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`	Primary		AP175, AP198, AP30.4, AP300, AP305, EE11.1, EE135, EE175 +10 more
`EEDSET2`	`COMPANY`, `REC-STATUS`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`	KeyChange		EE175
`EEDSET3`	`DIST-COMPANY`, `EXP-ACCT-UNIT`, `CATEGORY`, `EXP-ACCOUNT`, `EXP-SUB-ACCT`, `EXPENSE-DATE`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`, `COMPANY`	KeyChange		EE275
`EEDSET4`	`DIST-COMPANY`, `CATEGORY`, `DISTRIB-DATE`, `VENDOR`, `EXPENSE-NBR`, `EXP-ACCT-UNIT`, `SEQ-NBR`, `COMPANY`	KeyChange		EE90.3
`EEDSET5`	`ACT-OBJ-ID`, `COMPANY`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`	KeyChange, Subset	Where ACT-OBJ-ID != Zeroes	—
`EEDSET6`	`COMPANY`, `VENDOR`, `EXPENSE-NBR`, `CATEGORY`, `SEQ-NBR`	KeyChange		EE20.3
`EEDSET8`	`GLT-OBJ-ID`, `COMPANY`, `VENDOR`, `EXPENSE-NBR`, `SEQ-NBR`	KeyChange, Subset	Where GLT-OBJ-ID != Zeroes	—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Eecategory	EECATEGORY	Required	`EED-COMPANY` → `CTG-COMPANY (CTGSET1)`, `EED-CATEGORY` → `CTG-CATEGORY`
Eeexpense	EEEXPENSE	Required	`EED-COMPANY` → `EXP-COMPANY`, `EED-VENDOR` → `EXP-VENDOR`, `EED-EXPENSE-NBR` → `EXP-EXPENSE-NBR`
Glmaster	GLMASTER	Required	`EED-COMPANY` → `GLM-COMPANY`, `EED-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `EED-EXP-ACCOUNT` → `GLM-ACCOUNT`, `EED-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glnames	GLNAMES	Required	`EED-COMPANY` → `GLN-COMPANY`, `EED-EXP-ACCT-UNIT` → `GLN-ACCT-UNIT`

Programs

Updated by (13)

AP198 Invoice Data Archival
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
AP305 Accounts Payable Company Purge
EE11.1 Expense Line Detail
EE135 Mass Employee Release
EE175 Company Expense Posting
EE20.2 Employee Expense
EE20.3 Expense Detail
EE20.4 Employee Payback
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface

Referenced by (5)

AP175 Invoice Distribution Closing
EE220 Expense, Advance, or Payback Edit
EE275 Expense Analysis Report
EE90.3 Expense Category Inquiry
EEI1.1 EE Comment Routine