EEDISTRIB

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEDSET1 COMPANY
VENDOR
EXPENSE-NBR
SEQ-NBR
AP175 AP30.4
AP300 AP305
EE11.1 EE135
EE175 EE20.2
EE20.3 EE20.4
EE20.5 EE220
EE275 EE35.1
EE35.2 EE520
EEI1.1
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
WhereACT-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
WhereGLT-OBJ-ID !=Zeroes


EEDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



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