C6EMPINV – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
CEI
Primary key
COMPANY, PAYROLL-YEAR, EMPLOYEE, PRD-START-DATE, INV-GROUP, INV-CODE, SEQ-NBR
Fields
21
Updated by
11 programs
Referenced by
0 programs

C6EMPINV is a Lawson C6 table (prefix CEI); no description in the lawson data dictionary. It is indexed by COMPANY, PAYROLL-YEAR, EMPLOYEE, PRD-START-DATE, INV-GROUP, INV-CODE, SEQ-NBR (CEISET1); alternate indexes: CEISET2. It is related 1:1 to PRSYSTEM, EMPLOYEE and C6INVEST and 1:M to C6PRDDTL. It is updated by BN66.1, PR139, PR140, PR141, PR189, PR195, PR197, PR80.1 and 3 more. The table has 21 fields, 2 indexes and 4 documented relations.

About C6EMPINV

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the CEI- 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
#CEI-COMPANY PK
COMPANY		Numeric 4——
#CEI-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4——
#CEI-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#CEI-PRD-START-DATE PK
PRD_START_DATE		Numeric 8 (yyyymmdd)——
#CEI-INV-GROUP PK
INV_GROUP		Alpha 1—
  • 1 Section 10
  • 2 Section 24
  • 3 Section 16
  • 4 Section 80C
  • 5 Section VI-A
—
#CEI-INV-CODE PK
INV_CODE		Alpha 10——
#CEI-PRD-END-DATE
PRD_END_DATE		Numeric 8 (yyyymmdd)——
#CEI-INV-PROP-AMT
INV_PROP_AMT		Signed 13.2——
#CEI-INV-ACT-AMT
INV_ACT_AMT		Signed 13.2——
#CEI-PROC-STATUS
PROC_STATUS		Alpha 1—
  • P Pending
  • C Closed
BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 +1 more
#CEI-SEQ-NBR PK
SEQ_NBR		Numeric 4——
#CEI-APPROVE-FLG
APPROVE_FLG		Alpha 1—
  • Y Yes
  • N No
—
#CEI-REQUEST-AMT
REQUEST_AMT		Signed 13.2——
#CEI-APPROVED-AMT
APPROVED_AMT		Signed 13.2——
#CEI-USER-FLAG
USER_FLAG		Numeric 1—
  • 0 No
  • 1 Yes
—
#CEI-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CEI-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CEI-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CEI-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#CEI-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#CEI-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——

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
CEISET1
  1. COMPANY
  2. PAYROLL-YEAR
  3. EMPLOYEE
  4. PRD-START-DATE ↓
  5. INV-GROUP
  6. INV-CODE
  7. SEQ-NBR
PrimaryBN66.1, PR140, PR141, PR189, PR195, PR197, PR80.1, PR80.4 +2 more
CEISET2
  1. COMPANY
  2. PAYROLL-YEAR
  3. EMPLOYEE
  4. PRD-START-DATE ↓
  5. INV-GROUP
  6. INV-CODE
  7. SEQ-NBR ↓
BN66.1, PR139, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1 +1 more

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CEI-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
CEI-COMPANY→EMP-COMPANY
CEI-EMPLOYEE→EMP-EMPLOYEE
InvestmentC6INVESTRequired
CEI-COMPANY→C6I-COMPANY
CEI-PAYROLL-YEAR→C6I-PAYROLL-YEAR
CEI-INV-GROUP→C6I-INV-GROUP
CEI-INV-CODE→C6I-INV-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Pay PeriodC6PRDDTL
CEI-COMPANY→C6D-COMPANY
CEI-PAYROLL-YEAR→C6D-PAYROLL-YEAR
—→C6D-PAY-PRD-DEF
—→C6D-START-DATE

Programs

Updated by (11)