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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RGF-COUNTRY-CODE PKCOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | — |
#RGF-TOPIC PKTOPIC | Alpha 2 | — | — |
#RGF-FLD-NBR PKFLD_NBR | Numeric 4 | This field contains the PO dictionary field number. | — |
#RGF-NAME SET3NAME | Alpha 30 (Lower Case) | Displays the company description. | — |
#RGF-RECORD-TYPE PKRECORD_TYPE | Alpha 1 | This field identifies the type of record defined. Valid values are:
| — |
#RGF-DATA-TYPEDATA_TYPE | Alpha 1 | Determines the type of data being entered and how to edit it. Values are Date, Alpha, or Numeric. | — |
#RGF-SIZESIZE | Numeric 2 | — | — |
#RGF-DECIMALSDECIMALS | Numeric 1 | This 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-OCCURRENCESOCCURRENCES | Numeric 2 | — | — |
#RGF-LENGTHLENGTH | Numeric 2 | — | — |
#RGF-EXCL-FLD-NBREXCL_FLD_NBR | Numeric 4 | — | — |
#RGF-DB-FILEDB_FILE | Alpha 3 | — | — |
#RGF-ACTIVEACTIVE | Alpha 1 | — | — |
Indexes (4)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RGFSET1 |
| Primary | HR100, PR127, PR227, PR240, PR241, PR242, PR243, PR244 +1 more | |
RGFSET2 |
| Subset | Where ACTIVE = Spaces And FLD-NBR = Zeroes | PR11.1, PR11.4, PR27.1, PR27.2 |
RGFSET3 |
| KeyChange, Subset | Where ACTIVE = Spaces And FLD-NBR != Zeroes | PR11.1, PR11.4, PR27.1, PR27.2 |
RGFSET4 |
| Subset | Where ACTIVE = Spaces | — |
Programs
Updated by (1)
- HR100 Lawson Delivered Files Purge
Referenced by (12)
- PR11.1 Employee Year-End Parameters
- PR11.4 Canadian Employee Year-End Parameters
- PR127 Year-End Parameters Copy/Delete
- PR227 Year-End Parameter Report
- PR240 T4-T4A Slips
- PR241 T4-T4A XML
- PR242 T4-T4A Reports
- PR243 Releve Slips
- PR244 Releve Magnetic Media
- PR245 Releve Reports
- PR27.1 Year-End Parameters
- PR27.2 Tax Authority Year-End Parameters