DEDGROUP – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
DDG
Primary key
COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODE
Fields
5
Updated by
1 program
Referenced by
10 programs

DEDGROUP is a Lawson Payroll table (prefix DDG); no description in the lawson data dictionary. It is indexed by COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODE (DDGSET1); alternate indexes: DDGSET2. It is related 1:1 to PRSYSTEM, INSTCTRYCD and DEDCODE. It is updated by PR02.2 and referenced by PDDG.1, PR227, PR243, PR244, PR245, PR252, PR27.1, PR276 and 2 more. The table has 5 fields, 2 indexes and 3 documented relations.

About DEDGROUP

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
DDG-COMPANY PK
COMPANY		Numeric 4—PR02.2
DDG-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2—PR02.2
DDG-DED-GROUP PK
DED_GROUP		Alpha 10The name of the Deduction GroupPR02.2, PR276
DDG-DESC
DESC		Alpha 30 (Lower Case)The description of the Deduction GroupPR02.2
DDG-DED-CODE PK
DED_CODE		Alpha 4Deduction codes connected to the deduction groupPR02.2, PR276

Indexes (2)

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

IndexKeysFlagsConditionUsed in
DDGSET1COMPANY, COUNTRY-CODE, DED-GROUP, DED-CODEPrimaryPDDG.1, PR02.2, PR227, PR243, PR244, PR245, PR252, PR27.1 +3 more
DDGSET2COMPANY, COUNTRY-CODE, DED-CODE, DED-GROUP—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredDDG-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL
Country CodeINSTCTRYCDRequiredDDG-COUNTRY-CODE → INT-COUNTRY-CODE
Ded CodeDEDCODERequiredDDG-COMPANY → DDC-COMPANY, DDG-DED-CODE → DDC-DED-CODE

Programs

Updated by (1)

Referenced by (10)