CMEMPTRANS – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CET
Primary key
COMPANY, EMPLOYEE, CONTRACT-NBR, TRANS-SEQ-NBR
Fields
25
Updated by
0 programs
Referenced by
0 programs

CMEMPTRANS is a Lawson CW table (prefix CET); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-NBR, TRANS-SEQ-NBR (CETSET1); alternate indexes: CETSET2. The table has 25 fields, 2 indexes and 0 documented relations.

About CMEMPTRANS

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the CET- 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
#CET-COMPANY PK
COMPANY		Numeric 4——
#CET-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#CET-CONTRACT-NBR PK
CONTRACT_NBR		Numeric 6——
#CET-TRANS-SEQ-NBR PK
TRANS_SEQ_NBR		Numeric 12——
#CET-SEGMENT-NBR SET2
SEGMENT_NBR		Numeric 6——
#CET-CHECK-ID
CHECK_ID		Numeric 12——
#CET-PAY-START-DATE
PAY_START_DATE		Numeric 8 (yyyymmdd)——
#CET-PAY-END-DATE SET2
PAY_END_DATE		Numeric 8 (yyyymmdd)——
#CET-PCD-SEQ-NBR
PCD_SEQ_NBR		Numeric 8——
#CET-EARNED-WAGES
EARNED_WAGES		Signed 18.6——
#CET-EARNED-UNITS
EARNED_UNITS		Signed 18.6——
#CET-DOCKED-WAGES
DOCKED_WAGES		Signed 18.6——
#CET-DOCKED-UNITS
DOCKED_UNITS		Signed 18.6——
#CET-PAID-WAGES
PAID_WAGES		Signed 18.6——
#CET-PAID-UNITS
PAID_UNITS		Signed 18.6——
#CET-RESERVE-WAGES
RESERVE_WAGES		Signed 18.6——
#CET-RESERVE-UNITS
RESERVE_UNITS		Signed 18.6——
#CET-CHECK-NBR
CHECK_NBR		Numeric 8——
#CET-CHECK-DATE
CHECK_DATE		Numeric 8 (yyyymmdd)——
#CET-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CET-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CET-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CET-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#CET-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
#CET-USER-ID
USER_ID		Alpha 10 (Lower Case)——

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
CETSET1
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-NBR ↓
  4. TRANS-SEQ-NBR ↓
PrimaryBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
CETSET2
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-NBR
  4. SEGMENT-NBR
  5. PAY-END-DATE
  6. TRANS-SEQ-NBR
—

Programs

No Lawson programs are documented as updating or referencing this table.