C6EMDDMSTR – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
CED
Primary key
COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR
Fields
13
Updated by
115 programs
Referenced by
6 programs

C6EMDDMSTR is a Lawson C6 table (prefix CED); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR (CEDSET1); alternate indexes: CEDSET2. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 107 more and referenced by BN66.1, PR139, PR140, PR195, PR89.1 and PRAT.1. The table has 13 fields, 2 indexes and 0 documented relations.

About C6EMDDMSTR

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
CED-COMPANY PK
COMPANY		Numeric 4—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-EMPLOYEE PK
EMPLOYEE		Numeric 9—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-DED-CODE PK
DED_CODE		Alpha 4—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-SEQ-NBR PK
SEQ_NBR		Numeric 4—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-PF-CONTRIB
PF_CONTRIB		Numeric 1—
  • 0 Default from Employee
  • 1 Qualifying Amount
  • 2 Actual Amount
—
CED-STUDENT
STUDENT		Numeric 1——
CED-HOSTELITE
HOSTELITE		Numeric 1——
CED-CREATE-USERID
CREATE_USERID		Alpha 10 (Lower Case)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
CED-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CEDSET1COMPANY, EMPLOYEE, DED-CODE, SEQ-NBRPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
CEDSET2COMPANY, EMPLOYEE, PF-CONTRIB, DED-CODE, SEQ-NBRKeyChange—

Programs

Updated by (115)

Referenced by (6)