C6PREVEMP – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6E
Primary key
COMPANY, EMPLOYEE, PAYROLL-YEAR, PREV-TYPE, PREV-CODE
Fields
21
Updated by
9 programs
Referenced by
2 programs

C6PREVEMP is a Lawson C6 table (prefix C6E); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, PREV-TYPE, PREV-CODE (C6ESET1). It is related 1:1 to PRSYSTEM, INEMPLOYEE and C6INVEST. It is updated by BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 and 1 more and referenced by PR139 and PR141. The table has 21 fields, 1 index and 3 documented relations.

About C6PREVEMP

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the C6E- 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
#C6E-COMPANY PK
COMPANY		Numeric 4——
#C6E-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#C6E-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4——
#C6E-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)——
#C6E-END-DATE
END_DATE		Numeric 8 (yyyymmdd)——
#C6E-PREV-EMPLOYER
PREV_EMPLOYER		Alpha 30 (Lower Case)——
#C6E-PREV-TYPE PK
PREV_TYPE		Alpha 1—
  • G Gross Perquisites
  • T Tax Deducted at Source
  • 1 Section 10
  • 2 Section 24
  • 3 Section 16
  • 4 Section 80C
  • 5 Section VI-A
—
#C6E-PREV-CODE PK
PREV_CODE		Alpha 10——
#C6E-ACTUAL-AMOUNT
ACTUAL_AMOUNT		Signed 13.2——
#C6E-AMOUNT-OLD
AMOUNT_OLD		Signed 13.2——
#C6E-APPROVE-FLG
APPROVE_FLG		Alpha 1—
  • Y Yes
  • N No
  • R Rejected
—
#C6E-APPROVED-AMT
APPROVED_AMT		Signed 13.2——
#C6E-REQUEST-AMT
REQUEST_AMT		Signed 13.2——
#C6E-PROC-STATUS
PROC_STATUS		Alpha 1—
  • 0 Unprocessed
  • P Pending
  • C Closed
BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 +1 more
#C6E-USER-FLAG
USER_FLAG		Numeric 1—
  • 0 No
  • 1 Yes
—
#C6E-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#C6E-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#C6E-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#C6E-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#C6E-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#C6E-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——

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
C6ESET1
  1. COMPANY
  2. EMPLOYEE
  3. PAYROLL-YEAR
  4. PREV-TYPE
  5. PREV-CODE
PrimaryBN66.1, PR139, PR140, PR141, PR189, PR195, PR197, PR80.1 +3 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMINEMPLOYEEC6INVESTC6PREVEMP

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMNot Required
C6E-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeINEMPLOYEERequired
C6E-COMPANY→CEM-COMPANY
C6E-EMPLOYEE→CEM-EMPLOYEE
InvestmentC6INVESTNot Required
C6E-COMPANY→C6I-COMPANY
C6E-PAYROLL-YEAR→C6I-PAYROLL-YEAR
C6E-PREV-TYPE→C6I-INV-GROUP
C6E-PREV-CODE→C6I-INV-CODE

Programs

Updated by (9)

Referenced by (2)