PRREGDICT – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
RGF
Primary key
COUNTRY-CODE, RECORD-TYPE, TOPIC, FLD-NBR
Fields
13
Updated by
1 program
Referenced by
12 programs

PRREGDICT is a Lawson Payroll table (prefix RGF); no description in the lawson data dictionary. It is indexed by COUNTRY-CODE, RECORD-TYPE, TOPIC, FLD-NBR (RGFSET1); alternate indexes: RGFSET2, RGFSET3 and RGFSET4. It is updated by HR100 and referenced by PR11.1, PR11.4, PR127, PR227, PR240, PR241, PR242, PR243 and 4 more. The table has 13 fields, 4 indexes and 0 documented relations.

About PRREGDICT

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
RGF-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).—
RGF-TOPIC PK
TOPIC		Alpha 2——
RGF-FLD-NBR PK
FLD_NBR		Numeric 4This field contains the PO dictionary field number.—
RGF-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.—
RGF-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
—
RGF-DATA-TYPE
DATA_TYPE		Alpha 1Determines the type of data being entered and how to edit it. Values are Date, Alpha, or Numeric.—
RGF-SIZE
SIZE		Numeric 2——
RGF-DECIMALS
DECIMALS		Numeric 1This field determines the number of decimals for column amounts. For example, if you select 3, the value 100 appears as 100.00. The default is No Decimals.—
RGF-OCCURRENCES
OCCURRENCES		Numeric 2——
RGF-LENGTH
LENGTH		Numeric 2——
RGF-EXCL-FLD-NBR
EXCL_FLD_NBR		Numeric 4——
RGF-DB-FILE
DB_FILE		Alpha 3——
RGF-ACTIVE
ACTIVE		Alpha 1——

Indexes (4)

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

IndexKeysFlagsConditionUsed in
RGFSET1COUNTRY-CODE, RECORD-TYPE, TOPIC, FLD-NBRPrimaryHR100, PR127, PR227, PR240, PR241, PR242, PR243, PR244 +1 more
RGFSET2COUNTRY-CODE, RECORD-TYPE, TOPICSubsetWhere ACTIVE = Spaces And FLD-NBR = ZeroesPR11.1, PR11.4, PR27.1, PR27.2
RGFSET3COUNTRY-CODE, RECORD-TYPE, TOPIC, NAME, FLD-NBRKeyChange, SubsetWhere ACTIVE = Spaces And FLD-NBR != ZeroesPR11.1, PR11.4, PR27.1, PR27.2
RGFSET4COUNTRY-CODE, RECORD-TYPE, TOPIC, FLD-NBRSubsetWhere ACTIVE = Spaces—

Programs

Updated by (1)

Referenced by (12)