EEDISTRIB – Expense Distribution

System
Accounts Payable (AP)
Prefix
EED
Primary key
COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR
Fields
38
Updated by
13 programs
Referenced by
5 programs

EEDISTRIB is the Expense Distribution table in Lawson Accounts Payable (prefix EED). It is indexed by COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR (EEDSET1); alternate indexes: EEDSET2, EEDSET3, EEDSET4, EEDSET5, EEDSET6 and EEDSET8. It is related 1:1 to EECATEGORY, EEEXPENSE, GLMASTER and GLNAMES. It is updated by AP198, AP30.4, AP300, AP305, EE11.1, EE135, EE175, EE20.2 and 5 more and referenced by AP175, EE220, EE275, EE90.3 and EEI1.1. The table has 38 fields, 7 indexes and 4 documented relations.

About EEDISTRIB

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

Fields (38)

Column = COBOL field name without the EED- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EED-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.EE11.1, EE20.3, EE20.4, EE520
#EED-VENDOR PK
VENDOR		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 PK
EXPENSE_NBR		Alpha 10A unique, user-defined number assigned to the employee expense.EE11.1, EE20.3, EE20.4, EE520
#EED-SEQ-NBR PK
SEQ_NBR		Numeric 4A 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
ORIG_SEQ_NBR		Numeric 4——
#EED-REC-STATUS SET2
REC_STATUS		Numeric 1The record status of the distribution. Valid values are: expense distributions only).
  • 0 Unreleased.
  • 1 Released.
  • 9 Posted by EE175 (company-paid
AP30.4, EE11.1, EE135, EE175, EE20.3, EE20.4, EE35.1, EE35.2 +1 more
#EED-CATEGORY SET3 SET4 SET6
CATEGORY		Alpha 9The 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
TRAN_EXP_AMT		Signed 18.2The amount of the distribution in the currency of the transaction.AP30.4, EE11.1, EE20.3, EE20.4, EE520
#EED-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the transaction currency.EE11.1, EE20.3, EE20.4, EE520
#EED-BASE-EXP-AMT
BASE_EXP_AMT		Signed 18.2The amount of the distribution in the company base currency.AP30.4, EE11.1, EE20.3, EE20.4, EE520
#EED-TAX-SEQ-NBR
TAX_SEQ_NBR		Numeric 4——
#EED-TAX-INDICATOR
TAX_INDICATOR		Numeric 1—EE520
#EED-TAX-CODE
TAX_CODE		Alpha 10The 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
TAX_RATE		Percent 7.5 (Percent)Charge rate by month.EE11.1, EE20.3, EE520
#EED-TAX-TYPE
TAX_TYPE		Alpha 1The type of tax represented by the tax code.EE11.1, EE20.3, EE520
#EED-ACCR-CODE
ACCR_CODE		Alpha 4The 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
APA_ACCT_UNIT		Alpha 15The general ledger accrual accounting unit assigned to the distribution. Must be a valid record in the General Ledger Names file.EE520
#EED-APA-ACCOUNT
APA_ACCOUNT		Numeric 6The 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
APA_SUB_ACCT		Numeric 4The 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
TAXABLE_AMT		Signed 18.2The amount of the expense distribution that is taxable.AP30.4, EE11.1, EE20.3, EE520
#EED-CATEGORY-TYPE
CATEGORY_TYPE		Alpha 1Identifies 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
EXP_CURRENCY		Alpha 5The currency of the distribution. Must be a valid record in the Currency Codes file.EE11.1, EE20.3, EE20.4, EE520
#EED-CURR-RATE
CURR_RATE		Signed 14.7The 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
CURR_EFF_DATE		Numeric 8 (yyyymmdd)The effective date for the currency exchange rate.EE11.1, EE20.3, EE20.4, EE520
#EED-EXPENSE-DATE SET3
EXPENSE_DATE		Numeric 8 (yyyymmdd)The date the expense was incurred.EE11.1, EE20.3, EE20.4, EE520
#EED-DIST-COMPANY SET3 SET4
DIST_COMPANY		Numeric 4The 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 SET4
DISTRIB_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 SET3 SET4
EXP_ACCT_UNIT		Alpha 15The 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 SET3
EXP_ACCOUNT		Numeric 6The 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 SET3
EXP_SUB_ACCT		Numeric 4The 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
ACTIVITY		Alpha 15The 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
REFERENCE		Alpha 10 (Lower Case)The reference value assigned to the distribution.EE11.1, EE20.3, EE20.4, EE520
#EED-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description assigned to the distribution.EE11.1, EE20.3, EE20.4, EE520
#EED-GLT-OBJ-ID SET8
GLT_OBJ_ID		Numeric 12This 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 SET5
ACT_OBJ_ID		Numeric 12This 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
ACCT_CATEGORY		Alpha 5The 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
UNT_AMOUNT		Signed 18.2The total unit amount for the distribution.EE11.1, EE20.3, EE520
#EED-ANALYSIS-FLD
ANALYSIS_FLD		Alpha 32The user-defined analysis field assigned to the distribution.EE11.1, EE20.3, EE20.4

Indexes (7)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EEDSET1
  1. COMPANY
  2. VENDOR
  3. EXPENSE-NBR
  4. SEQ-NBR
PrimaryAP175, AP198, AP30.4, AP300, AP305, EE11.1, EE135, EE175 +10 more
EEDSET2
  1. COMPANY
  2. REC-STATUS
  3. VENDOR
  4. EXPENSE-NBR
  5. SEQ-NBR
KeyChangeEE175
EEDSET3
  1. DIST-COMPANY
  2. EXP-ACCT-UNIT
  3. CATEGORY
  4. EXP-ACCOUNT
  5. EXP-SUB-ACCT
  6. EXPENSE-DATE
  7. VENDOR
  8. EXPENSE-NBR
  9. SEQ-NBR
  10. COMPANY
KeyChangeEE275
EEDSET4
  1. DIST-COMPANY
  2. CATEGORY
  3. DISTRIB-DATE
  4. VENDOR
  5. EXPENSE-NBR
  6. EXP-ACCT-UNIT
  7. SEQ-NBR
  8. COMPANY
KeyChangeEE90.3
EEDSET5
  1. ACT-OBJ-ID
  2. COMPANY
  3. VENDOR
  4. EXPENSE-NBR
  5. SEQ-NBR
KeyChange, SubsetWhere ACT-OBJ-ID != Zeroes—
EEDSET6
  1. COMPANY
  2. VENDOR
  3. EXPENSE-NBR
  4. CATEGORY
  5. SEQ-NBR
KeyChangeEE20.3
EEDSET8
  1. GLT-OBJ-ID
  2. COMPANY
  3. VENDOR
  4. EXPENSE-NBR
  5. SEQ-NBR
KeyChange, SubsetWhere GLT-OBJ-ID != Zeroes—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EECATEGORYEEEXPENSEGLMASTERGLNAMESEEDISTRIB

One to one (4) — lookups and parents

RelationTableRulesConditionField map
EecategoryEECATEGORYRequired
EED-COMPANY→CTG-COMPANY (CTGSET1)
EED-CATEGORY→CTG-CATEGORY
EeexpenseEEEXPENSERequired
EED-COMPANY→EXP-COMPANY
EED-VENDOR→EXP-VENDOR
EED-EXPENSE-NBR→EXP-EXPENSE-NBR
GlmasterGLMASTERRequired
EED-COMPANY→GLM-COMPANY
EED-EXP-ACCT-UNIT→GLM-ACCT-UNIT
EED-EXP-ACCOUNT→GLM-ACCOUNT
EED-EXP-SUB-ACCT→GLM-SUB-ACCOUNT
GlnamesGLNAMESRequired
EED-COMPANY→GLN-COMPANY
EED-EXP-ACCT-UNIT→GLN-ACCT-UNIT

Programs

Updated by (13)

Referenced by (5)