Expense Distribution

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

REFERENCED BY

AP175

UPDATED BY

AP30.4	AP300	AP305	EE11.1	EE135	EE175
EE20.2	EE20.3	EE20.4	EE35.1	EE35.2	EE520
EE220	EE275	EEI1.1	EE90.3

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
EED-COMPANY Element: 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 Element: Employee	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 Element: Expense Nbr	Alpha 10 A unique, user-defined number assigned to the employee expense.	EE11.1 EE20.3 EE20.4 EE520
EED-SEQ-NBR Element: 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 Element: Orig Seq Nbr	Numeric 4
EED-REC-STATUS Element: Rec Status	Numeric 1 The record status of the distribution. Valid values are: 0 = Unreleased. 1 = Released. 9 = Posted by EE175 (company-paid expense distributions only).	AP30.4 EE11.1 EE135 EE175 EE20.3 EE20.4 EE35.1 EE35.2 EE520
EED-CATEGORY Element: 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 Element: Intl 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 Element: Acct Nd	Numeric 1 The number of decimal positions defined for the transaction currency.	EE11.1 EE20.3 EE20.4 EE520
EED-BASE-EXP-AMT Element: Intl 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 Element: Tax Seq Nbr	Numeric 4
EED-TAX-INDICATOR Element: Tax Indicator	Numeric 1	EE520
EED-TAX-CODE Element: 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 Element: Chrg Rate	Percent 7.5 (Percent) Charge rate by month.	EE11.1 EE20.3 EE520
EED-TAX-TYPE Element: Tax Type	Alpha 1 The type of tax represented by the tax code.	EE11.1 EE20.3 EE520
EED-ACCR-CODE Element: Invoice Accrual 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 Distribution Accrual 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 Distribution Accrual 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 Distribution Accrual Subacct	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 Element: Intl Amt	Signed 18.2 The amount of the expense distribution that is taxable.	AP30.4 EE11.1 EE20.3 EE520
EED-CATEGORY-TYPE Element: 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 Element: Expense 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 Element: 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 Element: Date	Numeric 8 (yyyymmdd) The effective date for the currency exchange rate.	EE11.1 EE20.3 EE20.4 EE520
EED-EXPENSE-DATE Element: Date	Numeric 8 (yyyymmdd) The date the expense was incurred.	EE11.1 EE20.3 EE20.4 EE520
EED-DIST-COMPANY Element: Posting 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 Element: Posting 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 Distribution Accounting 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 Distribution Account Number	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 Distribution Subaccount Number	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 Element: 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 Element: Reference	Alpha 10 (Lower Case) The reference value assigned to the distribution.	EE11.1 EE20.3 EE20.4 EE520
EED-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description assigned to the distribution.	EE11.1 EE20.3 EE20.4 EE520
EED-GLT-OBJ-ID Element: 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 Element: 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 Element: 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 Element: Unit Amount	Signed 18.2 The total unit amount for the distribution.	EE11.1 EE20.3 EE520
EED-ANALYSIS-FLD Element: Analysis Fld	Alpha 32 The user-defined analysis field assigned to the distribution.	EE11.1 EE20.3 EE20.4

EEDISTRIB FILE INDEX

EEDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS

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