ZUNIONDUES – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PPU
Primary key
COMPANY, DED-CODE, SEQ-NBR
Fields
9
Updated by
0 programs
Referenced by
0 programs

ZUNIONDUES is a Lawson Payroll table (prefix PPU); no description in the lawson data dictionary. It is indexed by COMPANY, DED-CODE, SEQ-NBR (PPUSET1); alternate indexes: PPUSET2. The table has 9 fields, 2 indexes and 0 documented relations.

About ZUNIONDUES

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the PPU- 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
#PPU-COMPANY PK
COMPANY		Numeric 4——
#PPU-DED-CODE PK
DED_CODE		Alpha 4——
#PPU-SEQ-NBR PK
SEQ_NBR		Numeric 4——
#PPU-PAY-CLASS SET2
PAY_CLASS		Alpha 3——
#PPU-PPH-TO-HRS
PPH_TO_HRS		Signed 4.1——
#PPU-PPH-BASE-RATE
PPH_BASE_RATE		Percent 6.4 (Percent)——
#PPU-PPH-PD-REDUC
PPH_PD_REDUC		Signed 6.4——
#PPU-PPH-PD-MAX-AMT
PPH_PD_MAX_AMT		Signed 11.2——
#PPU-PPU-CALC-TYPE
PPU_CALC_TYPE		Alpha 1——

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
PPUSET1
  1. COMPANY
  2. DED-CODE
  3. SEQ-NBR
PrimaryZP139
PPUSET2
  1. COMPANY
  2. DED-CODE
  3. PAY-CLASS
  4. SEQ-NBR
—

Programs

No Lawson programs are documented as updating or referencing this table.