|
|
EEDISTRIB FILE
Expense Distribution
The Employee Expense Distribution file is used to store expense distribution
detail records.
REFERENCED BY
AP198 EE220 EE275 EEI1.1 EE90.3
UPDATED BY
AP30.4 AP300 AP305 EE135 EE175 EE20.2
EE20.3 EE20.4 EE35.1 EE35.2 EE520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EED-COMPANY Numeric 4 EE20.3 EE20.4
Element: Company The company number. Must be a valid EE520
record in the Accounts Payable Company
file.
EED-VENDOR Alpha 9 (Right Justified) EE20.3 EE20.4
Element: Employee The employee number. Must be a valid EE520
record in the Accounts Payable Vendor
file.
EED-EXPENSE-NBR Alpha 10 EE20.3 EE20.4
Element: Expense NumberA unique, user-defined number assigned EE520
to the employee expense.
EED-SEQ-NBR Numeric 4 EE20.3 EE20.4
Element: Sequence NumbeA unique system-assigned identification EE520
value assigned to the distribution to
make the record unique.
EED-REC-STATUS Numeric 1 AP30.4 EE135
Element: Record Status The record status of the distribution. EE175 EE20.3
Valid values are: EE20.4 EE35.1
EE35.2 EE520
0 = Unreleased.
1 = Released.
9 = Posted by EE175 (company-paid
expense distributions only).
EED-CATEGORY Alpha 9 EE20.3 EE20.4
Element: Category The category code assigned to the EE520
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 Signed 15.2 AP30.4 EE20.3
Element: Adj Amt The amount of the distribution in the EE20.4 EE520
currency of the transaction.
EED-TRAN-ND Numeric 1 EE20.3 EE20.4
Account Currency The number of decimal positions defined EE520
Code for the transaction currency.
EED-BASE-EXP-AMT Signed 15.2 AP30.4 EE20.3
Element: Adj Amt The amount of the distribution in the EE20.4 EE520
company base currency.
EED-TAX-CODE Alpha 10 EE20.3 EE520
Element: Tax Code The tax code assigned to an employee
expense tax distribution. Must be a
valid record in the Tax Code file.
EED-TAX-RATE Percent 7.5 (Percent) EE20.3 EE520
Element: Chrg Rate The tax rate defined for the tax code.
EED-TAX-TYPE Alpha 1 EE20.3 EE520
Element: Tax Type The type of tax represented by the tax
code.
EED-ACCR-CODE Alpha 4 EE20.2 EE20.3
Element: Invoice AccruaThe invoice accrual code assigned to a EE20.4 EE520
company-paid expense distribution. Used
to default a general ledger accrual
account to the expense.
EED-APA-ACCT-UNIT Alpha 15 EE520
Distribution The general ledger accrual accounting
Accrual Acct Unit unit assigned to the distribution. Must
be a valid record in the General Ledger
Names file.
EED-APA-ACCOUNT Numeric 6 EE520
Distribution The general ledger accrual account
Accrual Account number assigned to the distribution.
Must be a valid record in the General
Ledger Account Master file.
EED-APA-SUB-ACCT Numeric 4 EE520
Distribution The general ledger accrual subaccount
Accrual Subacct number assigned to the distribution.
Must be a valid record in the General
Ledger Account Master file.
EED-TAXABLE-AMT Signed 15.2 AP30.4 EE20.3
Element: Adj Amt The amount of the expense distribution EE520
that is taxable.
EED-CATEGORY-TYPE Alpha 1 EE20.3 EE20.4
Element: Category Type Identifies the type of expense. Valid EE520
values are:
E = Employee Paid Expense.
C = Company Paid Expense.
P = Cash Payment (payback).
U = Units.
EED-EXP-CURRENCY Alpha 5 EE20.3 EE20.4
Element: Expense CurrenThe currency of the distribution. Must EE520
be a valid record in the Currency Codes
file.
EED-CURR-RATE Signed 13.6 EE20.3 EE20.4
Element: Currency Rate The exchange rate for the expense EE520
distribution. Used to convert a non-base
currency expense amount to the company
base currency.
EED-CURR-EFF-DATE Numeric 8 (yyyymmdd) EE20.3 EE20.4
Element: Date The effective date for the currency EE520
exchange rate.
EED-EXPENSE-DATE Numeric 8 (yyyymmdd) EE20.3 EE20.4
Element: Date The date the expense was incurred. EE520
EED-DIST-COMPANY Numeric 4 EE20.3 EE20.4
Element: Posting CompanThe company the distribution will be EE520
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 Numeric 8 (yyyymmdd) AP30.4 EE20.2
Element: Posting Date The general ledger posting date EE20.3 EE20.4
assigned to the distribution. EE520
EED-EXP-ACCT-UNIT Alpha 15 EE20.3 EE20.4
Distribution The general ledger distribution EE520
Accounting Unit accounting unit. Must be a valid record
in the General Ledger Names file.
EED-EXP-ACCOUNT Numeric 6 EE20.3 EE20.4
Distribution The general ledger distribution account EE520
Account Number number. Must be a valid record in the
General Ledger Account Master file.
EED-EXP-SUB-ACCT Numeric 4 EE20.3 EE20.4
Distribution The general ledger distribution EE520
Subaccount Number subaccount number. Must be a valid
record in the General Ledger Account
Master file.
EED-ACTIVITY Alpha 15 EE20.3 EE20.4
Element: Activity The activity assigned to the employee EE520
expense distribution. Must be a valid
record in the Lawson Activity Management
system.
EED-REFERENCE Alpha 10 (Lower Case) EE20.3 EE20.4
Element: Requester The reference value assigned to the EE520
distribution.
EED-DESCRIPTION Alpha 30 (Lower Case) EE20.3 EE20.4
Element: Description The description assigned to the EE520
distribution.
EED-GLT-OBJ-ID Numeric 12 EE135 EE175
Object EE35.1 EE35.2
Identification EE520
EED-ACT-OBJ-ID Numeric 12 EE135 EE175
Object EE35.1 EE35.2
Identification EE520
EED-ACCT-CATEGORY Alpha 5 EE20.3 EE20.4
Element: Account CategoThe account category assigned to the EE520
employee expense distribution. Must be a
valid record in the Lawson Activity
Management system.
EED-UNT-AMOUNT Signed 15.2 EE20.3 EE520
Element: Unit Amount The total unit amount for the
distribution.
EED-ANALYSIS-FLD Alpha 32 EE20.3 EE20.4
Element: Analysis FieldThe user-defined analysis field
assigned to the distribution.
EEDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEDSET1 COMPANY This index is used to access employee AP198 AP30.4
VENDOR expense records for a specific employee AP300 AP305
EXPENSE-NBR and company. EE135 EE175
SEQ-NBR EE20.2 EE20.3
EE20.4 EE220
EE275 EE35.1
EE35.2 EE520
EEI1.1
EEDSET2 COMPANY This index is used to access unreleased EE175
REC-STATUS expense records for an employee.
VENDOR KeyChange
EXPENSE-NBR
SEQ-NBR
EEDSET3 DIST-COMPANY This index is used to access expense EE275
EXP-ACCT-UNIT distributions for a specific category
CATEGORY and distribution company.
EXP-ACCOUNT KeyChange
EXP-SUB-ACCT
EXPENSE-DATE
VENDOR
EXPENSE-NBR
SEQ-NBR
COMPANY
EEDSET4 DIST-COMPANY This index is used to access expense EE90.3
CATEGORY distribution records for a specific
DISTRIB-DATE category and company.
VENDOR KeyChange
EXPENSE-NBR
EXP-ACCT-UNIT
SEQ-NBR
COMPANY
EEDSET5 ACT-OBJ-ID This index is used by the Activity
COMPANY Management System to drill back to the
VENDOR Accounts Payable System detail records.
EXPENSE-NBR KeyChange, Subset
SEQ-NBR Where ACT-OBJ-ID != Zeroes
EEDSET6 COMPANY This index is used to access expenses EE20.3
VENDOR for a specific employee.
EXPENSE-NBR KeyChange
CATEGORY
SEQ-NBR
EEDSET8 GLT-OBJ-ID KeyChange, Subset
COMPANY Where GLT-OBJ-ID != Zeroes
VENDOR
EXPENSE-NBR
SEQ-NBR
EEDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
