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.

Field / column	Type	Description & values	Updated 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` 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CETSET1`	`COMPANY`, `EMPLOYEE`, `CONTRACT-NBR`, `TRANS-SEQ-NBR`	Primary		BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
`CETSET2`	`COMPANY`, `EMPLOYEE`, `CONTRACT-NBR`, `SEGMENT-NBR`, `PAY-END-DATE`, `TRANS-SEQ-NBR`			—

Programs

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