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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 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
CEDSET1
  1. COMPANY
  2. EMPLOYEE
  3. DED-CODE
  4. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
CEDSET2
  1. COMPANY
  2. EMPLOYEE
  3. PF-CONTRIB
  4. DED-CODE
  5. SEQ-NBR
KeyChange—

Programs

Updated by (115)

Referenced by (6)