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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
C6N-COMPANY PKCOMPANY | Numeric 4 | — | — |
C6N-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | — |
C6N-POSITION-CODE PKPOSITION_CODE | Alpha 10 | — | — |
C6N-EFF-START-DATE PKEFF_START_DATE | Numeric 8 (yyyymmdd) | — | — |
C6N-EFF-END-DATEEFF_END_DATE | Numeric 8 (yyyymmdd) | — | — |
C6N-NET-WAGE-AMTNET_WAGE_AMT | Signed 13.2 | — | — |
C6N-PERCENTAGEPERCENTAGE | Percent 5.2 (Percent) | — | — |
C6N-PSG-NWTPSG_NWT | Alpha 3 Occurs 9 Times ×9 | — | — |
C6N-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | — |
C6N-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | — |
C6N-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | — |
C6N-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | — |
C6N-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | — |
C6N-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | — |
Indexes (1)
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 |
|---|---|---|---|---|
C6NSET1 | COMPANY, PROCESS-LEVEL, POSITION-CODE, EFF-START-DATE* | Primary | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |