|
|
EEDISTRIB FILE
Expense Distribution
The Employee Expense Distribution file is used to store expense distribution
detail records.
REFERENCED BY
AP285 EE220 EE275 EE90.3
UPDATED BY
AP30.4 AP300 AP305 AP961 AP981 AP984
EE135 EE175 EE20.2 EE20.3 EE20.4 EE35.1
EE35.2 EE520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EED-COMPANY Numeric 4 AP961 EE20.3
Company The company number. Must be a valid EE20.4 EE520
record in the Accounts Payable Company
file.
EED-VENDOR Alpha 9 AP961 EE20.3
Employee The employee number. Must be a valid EE20.4 EE520
record in the Accounts Payable Vendor
file.
EED-EXPENSE-NBR Alpha 10 AP961 EE20.3
Expense Number A unique, user-defined number assigned EE20.4 EE520
to the employee expense.
EED-SEQ-NBR Numeric 4 AP961 EE20.3
Sequence Number A unique system-assigned identification EE20.4 EE520
value assigned to the distribution to
make the record unique.
EED-REC-STATUS Numeric 1 AP30.4 AP961
Record Status The record status of the distribution. EE135 EE175
Valid values are: EE20.3 EE20.4
EE35.1 EE35.2
0 = Unreleased. EE520
1 = Released.
9 = Posted by EE175 (company-paid
expense distributions only).
EED-CATEGORY Alpha 9 AP961 EE20.3
Category The category code assigned to the EE20.4 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 AP961
Transaction Expense The amount of the distribution in the EE20.3 EE20.4
Amount currency of the transaction. EE520
EED-TRAN-ND Numeric 1 AP961 EE20.3
Transaction Number The number of decimal positions defined EE20.4 EE520
of Decimals for the transaction currency.
EED-BASE-EXP-AMT Signed 15.2 AP30.4 AP961
Total Expense Amount The amount of the distribution in the EE20.3 EE20.4
company base currency. EE520
EED-TAX-CODE Alpha 10 AP961 EE20.3
Tax Code The tax code assigned to an employee EE520
expense tax distribution. Must be a
valid record in the Tax Code file.
EED-TAX-RATE Percent 7.5 (Percent) AP961 EE20.3
Tax Rate The tax rate defined for the tax code. EE520
EED-TAX-TYPE Alpha 1 AP961 EE20.3
Tax Type The type of tax represented by the tax EE520
code.
EED-ACCR-CODE Alpha 4 AP961 EE20.2
Invoice Accrual Code The invoice accrual code assigned to a EE20.3 EE20.4
company-paid expense distribution. Used EE520
to default a general ledger accrual
account to the expense.
EED-APA-ACCT-UNIT Alpha 15 AP961 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 AP961 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 AP961 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 AP961
Taxable Amount The amount of the expense distribution EE20.3 EE520
that is taxable.
EED-CATEGORY-TYPE Alpha 1 AP961 EE20.3
Category Type Identifies the type of expense. Valid EE20.4 EE520
values are:
E = Employee Paid Expense.
C = Company Paid Expense.
P = Cash Payment (payback).
U = Units.
EED-EXP-CURRENCY Alpha 5 AP961 EE20.3
Expense Currency The currency of the distribution. Must EE20.4 EE520
be a valid record in the Currency Codes
file.
EED-CURR-RATE Signed 13.6 AP961 EE20.3
Currency Rate The exchange rate for the expense EE20.4 EE520
distribution. Used to convert a non-base
currency expense amount to the company
base currency.
EED-CURR-EFF-DATE Numeric 8 (yyyymmdd) AP961 EE20.3
Currency Effective The effective date for the currency EE20.4 EE520
Date exchange rate.
EED-EXPENSE-DATE Numeric 8 (yyyymmdd) AP961 EE20.3
Expense Date The date the expense was incurred. EE20.4 EE520
EED-DIST-COMPANY Numeric 4 AP961 EE20.3
Posting Company The company the distribution will be EE20.4 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 AP961
Posting Date The general ledger posting date EE20.2 EE20.3
assigned to the distribution. EE20.4 EE520
EED-EXP-ACCT-UNIT Alpha 15 AP961 EE20.3
Distribution The general ledger distribution EE20.4 EE520
Accounting Unit accounting unit. Must be a valid record
in the General Ledger Names file.
EED-EXP-ACCOUNT Numeric 6 AP961 EE20.3
Distribution The general ledger distribution account EE20.4 EE520
Account Number number. Must be a valid record in the
General Ledger Account Master file.
EED-EXP-SUB-ACCT Numeric 4 AP961 EE20.3
Distribution The general ledger distribution EE20.4 EE520
Subaccount Number subaccount number. Must be a valid
record in the General Ledger Account
Master file.
EED-ACTIVITY Alpha 15 AP961 EE20.3
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) AP961 EE20.3
Reference The reference value assigned to the EE20.4 EE520
distribution.
EED-DESCRIPTION Alpha 30 (Lower Case) AP961 EE20.3
Description The description assigned to the EE20.4 EE520
distribution.
EED-GLT-OBJ-ID Numeric 12 AP984 EE175
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
EED-ACT-OBJ-ID Numeric 12 AP961 AP981
Subsystem Activity A subsystem activity interface EE135 EE175
InterfaceID identification number. Used for Drill EE35.1 EE35.2
Around purposes. EE520
EED-ACCT-CATEGORY Alpha 5 AP961 EE20.3
Account Category The 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 AP961 EE20.3
Unit Amount The total unit amount for the EE520
distribution.
EED-ANALYSIS-FLD Alpha 20 AP961 EE20.3
Analysis Field The user-defined analysis field EE20.4
assigned to the distribution.
EEDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEDSET1 COMPANY This index is used to access employee AP285 AP30.4
VENDOR expense records for a specific employee AP300 AP305
EXPENSE-NBR and company. AP981 AP984
SEQ-NBR EE135 EE175
EE20.2 EE20.3
EE20.4 EE220
EE35.1 EE35.2
EE520
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
EEDSET7 DIST-COMPANY This index is used by the General
EXP-ACCT-UNIT Ledger System to drill down to accounts
EXP-ACCOUNT payable transactions.
EXP-SUB-ACCT KeyChange
DISTRIB-DATE
GLT-OBJ-ID
COMPANY
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
EEDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
EED-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|