EENONDETL – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
END
Primary key
COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER, SEQ
Fields
10
Updated by
2 programs
Referenced by
0 programs

EENONDETL is a Lawson Accounts Payable table (prefix END); no description in the lawson data dictionary. It is indexed by COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER, SEQ (ENDSET1). It is updated by ET02.1 and ET02.2. The table has 10 fields, 1 index and 0 documented relations.

About EENONDETL

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the END- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
END-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.ET02.2
END-EXPENSE-NBR PK
EXPENSE_NBR		Alpha 10The expense report number.ET02.2
END-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.ET02.2
END-BEFORE-AFTER PK
BEFORE_AFTER		Alpha 1—ET02.2
END-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.ET02.2
END-CAT-DESC
CAT_DESC		Alpha 50—ET02.2
END-TRAN-EXP-AMT
TRAN_EXP_AMT		Signed 18.2—ET02.2
END-APP-EXP-AMT
APP_EXP_AMT		Signed 18.2—ET02.2
END-EXPENSE-DATE
EXPENSE_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.ET02.2
END-CATEGORY
CATEGORY		Alpha 9A category code is user-defined and represents a general ledger account for a specific type of expense type during expense entry.ET02.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ENDSET1COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER, SEQPrimaryET02.1, ET02.2

Programs

Updated by (2)