Expense Distribution
The Employee Expense Distribution file is used to store expense distribution detail records.
REFERENCED BY
AP175 | EE220 | EE275 | EEI1.1 | EE90.3 |
AP30.4 | AP305 | EE11.1 | EE135 | EE175 | EE20.2 |
EE20.3 | EE20.4 | EE35.1 | EE35.2 | EE520 | AP198 |
AP300 |
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. |
|
||||||||||
EED-VENDOR Element: Employee | Alpha 9 (Right Justified) The employee number. Must be a valid record in the Accounts Payable Vendor file. |
|
||||||||||
EED-EXPENSE-NBR Element: Expense Nbr | Alpha 10 A unique, user-defined number assigned to the employee expense. |
|
||||||||||
EED-SEQ-NBR Element: Seq Nbr | Numeric 4 A unique system-assigned identification value assigned to the distribution to make the record unique. |
|
||||||||||
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). |
|
||||||||||
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. |
|
||||||||||
EED-TRAN-EXP-AMT Element: Intl Amt | Signed 18.2 The amount of the distribution in the currency of the transaction. |
|
||||||||||
EED-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the transaction currency. |
|
||||||||||
EED-BASE-EXP-AMT Element: Intl Amt | Signed 18.2 The amount of the distribution in the company base currency. |
|
||||||||||
EED-TAX-SEQ-NBR Element: Tax Seq Nbr | Numeric 4 |
|
||||||||||
EED-TAX-INDICATOR Element: Tax Indicator | Numeric 1 |
|
||||||||||
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. |
|
||||||||||
EED-TAX-RATE Element: Chrg Rate | Percent 7.5 (Percent) Charge rate by month. |
|
||||||||||
EED-TAX-TYPE Element: Tax Type | Alpha 1 The type of tax represented by the tax code. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
EED-TAXABLE-AMT Element: Intl Amt | Signed 18.2 The amount of the expense distribution that is taxable. |
|
||||||||||
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. |
|
||||||||||
EED-EXP-CURRENCY Element: Expense Currency | Alpha 5 The currency of the distribution. Must be a valid record in the Currency Codes file. |
|
||||||||||
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. |
|
||||||||||
EED-CURR-EFF-DATE Element: Date | Numeric 8 (yyyymmdd) The effective date for the currency exchange rate. |
|
||||||||||
EED-EXPENSE-DATE Element: Date | Numeric 8 (yyyymmdd) The date the expense was incurred. |
|
||||||||||
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. |
|
||||||||||
EED-DISTRIB-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The general ledger posting date assigned to the distribution. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
EED-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference value assigned to the distribution. |
|
||||||||||
EED-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The description assigned to the distribution. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
EED-UNT-AMOUNT Element: Unit Amount | Signed 18.2 The total unit amount for the distribution. |
|
||||||||||
EED-ANALYSIS-FLD Element: Analysis Fld | Alpha 32 The user-defined analysis field assigned to the distribution. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EEDSET1 |
COMPANY VENDOR EXPENSE-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||
EEDSET2 |
COMPANY REC-STATUS VENDOR EXPENSE-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||
EEDSET3 |
DIST-COMPANY EXP-ACCT-UNIT CATEGORY EXP-ACCOUNT EXP-SUB-ACCT EXPENSE-DATE VENDOR EXPENSE-NBR SEQ-NBR COMPANY |
|
| ||||||||||||||||||||||||
EEDSET4 |
DIST-COMPANY CATEGORY DISTRIB-DATE VENDOR EXPENSE-NBR EXP-ACCT-UNIT SEQ-NBR COMPANY |
|
| ||||||||||||||||||||||||
EEDSET5 |
ACT-OBJ-ID COMPANY VENDOR EXPENSE-NBR SEQ-NBR |
|
|||||||||||||||||||||||||
EEDSET6 |
COMPANY VENDOR EXPENSE-NBR CATEGORY SEQ-NBR |
|
| ||||||||||||||||||||||||
EEDSET8 |
GLT-OBJ-ID COMPANY VENDOR EXPENSE-NBR SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Eecategory | EECATEGORY |
Required
| ||||||||||||
Eeexpense | EEEXPENSE |
Required
| ||||||||||||
Glmaster | GLMASTER |
Required
| ||||||||||||
Glnames | GLNAMES |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.