C6NETWAGE – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6N
Primary key
COMPANY, PROCESS-LEVEL, POSITION-CODE, EFF-START-DATE
Fields
14
Updated by
8 programs
Referenced by
0 programs

C6NETWAGE is a Lawson C6 table (prefix C6N); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, POSITION-CODE, EFF-START-DATE (C6NSET1). It is updated by BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1 and PRAT.1. The table has 14 fields, 1 index and 0 documented relations.

About C6NETWAGE

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the C6N- 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
#C6N-COMPANY PK
COMPANY		Numeric 4——
#C6N-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5——
#C6N-POSITION-CODE PK
POSITION_CODE		Alpha 10——
#C6N-EFF-START-DATE PK
EFF_START_DATE		Numeric 8 (yyyymmdd)——
#C6N-EFF-END-DATE
EFF_END_DATE		Numeric 8 (yyyymmdd)——
#C6N-NET-WAGE-AMT
NET_WAGE_AMT		Signed 13.2——
#C6N-PERCENTAGE
PERCENTAGE		Percent 5.2 (Percent)——
#C6N-PSG-NWT
PSG_NWT		Alpha 3 Occurs 9 Times ×9——
#C6N-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#C6N-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#C6N-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#C6N-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#C6N-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
#C6N-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (1)

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
C6NSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. POSITION-CODE
  4. EFF-START-DATE ↓
PrimaryBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1

Programs

Updated by (8)