EMPEXPENSE – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
ETC
Primary key
COMPANY, EE-CATEGORY, SEA-CATEGORY, CATEGORY-TYPE, CAT-STATUS
Fields
6
Updated by
1 program
Referenced by
0 programs

EMPEXPENSE is a Lawson Accounts Payable table (prefix ETC); no description in the lawson data dictionary. It is indexed by COMPANY, EE-CATEGORY, SEA-CATEGORY, CATEGORY-TYPE, CAT-STATUS (ETCSET1); alternate indexes: ETCSET2. It is updated by ET01.1. The table has 6 fields, 2 indexes and 0 documented relations.

About EMPEXPENSE

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the ETC- 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
#ETC-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.ET01.1
#ETC-EE-CATEGORY PK
EE_CATEGORY		Alpha 9—ET01.1
#ETC-SEA-CATEGORY PK
SEA_CATEGORY		Alpha 40—ET01.1
#ETC-CATEGORY-TYPE PK
CATEGORY_TYPE		Alpha 1This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)ET01.1
#ETC-CAT-STATUS PK
CAT_STATUS		Alpha 1—ET01.1
#ETC-CATEGORY-NAME
CATEGORY_NAME		Alpha 40—ET01.1

Indexes (2)

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
ETCSET1
  1. COMPANY
  2. EE-CATEGORY
  3. SEA-CATEGORY
  4. CATEGORY-TYPE
  5. CAT-STATUS
PrimaryET01.1
ETCSET2
  1. COMPANY
  2. SEA-CATEGORY
  3. EE-CATEGORY
  4. CATEGORY-TYPE
  5. CAT-STATUS
ET01.1

Programs

Updated by (1)