C6PRDDTL – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6D
Primary key
COMPANY, PAYROLL-YEAR, PAY-PRD-DEF, START-DATE
Fields
10
Updated by
6 programs
Referenced by
44 programs

C6PRDDTL is a Lawson C6 table (prefix C6D); no description in the lawson data dictionary. It is indexed by COMPANY, PAYROLL-YEAR, PAY-PRD-DEF, START-DATE (C6DSET1); alternate indexes: C6DSET2 and C6DSET3. It is updated by PR140, PR197, PR560, PR80.1, PR80.4 and PR999 and referenced by BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 and 36 more. The table has 10 fields, 3 indexes and 0 documented relations.

About C6PRDDTL

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the C6D- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
C6D-COMPANY PK
COMPANY		Numeric 4——
C6D-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4—PR999
C6D-PAY-PRD-DEF PK
PAY_PRD_DEF		Alpha 4——
C6D-PAY-FREQUENCY
PAY_FREQUENCY		Numeric 1——
C6D-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)—PR999
C6D-END-DATE
END_DATE		Numeric 8 (yyyymmdd)—PR999
C6D-NBR-OF-DAYS
NBR_OF_DAYS		Numeric 2—PR999
C6D-NBR-OF-HOURS
NBR_OF_HOURS		Numeric 5——
C6D-PERIOD-STATUS
PERIOD_STATUS		Alpha 1—
  • 0 Open
  • 9 Closed
PR999
C6D-REMAIN-CYCLES
REMAIN_CYCLES		Numeric 2——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
C6DSET1COMPANY, PAYROLL-YEAR, PAY-PRD-DEF, START-DATEPrimaryBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
C6DSET2COMPANY, PAYROLL-YEAR, PAY-PRD-DEF, START-DATESubsetWhere PERIOD-STATUS = "0"BN66.1, PR139, PR140, PR141, PR189, PR195, PR80.1, PR80.4 +2 more
C6DSET3COMPANY, PAY-PRD-DEF, START-DATE*, PAYROLL-YEARBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

Programs

Updated by (6)

Referenced by (44)