PRATXGROUP – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
AGF
Primary key
COMPANY, GROUP-CODE, TAX-STATUS
Fields
5
Updated by
1 program
Referenced by
0 programs

PRATXGROUP is a Lawson Payroll table (prefix AGF); no description in the lawson data dictionary. It is indexed by COMPANY, GROUP-CODE, TAX-STATUS (AGFSET1). It is updated by PR56.1. The table has 5 fields, 1 index and 0 documented relations.

About PRATXGROUP

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the AGF- 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
#AGF-COMPANY PK
COMPANY		Numeric 4—PR56.1
#AGF-GROUP-CODE PK
GROUP_CODE		Alpha 10—PR56.1
#AGF-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—PR56.1
#AGF-TAX-STATUS PK
TAX_STATUS		Alpha 2—PR56.1
#AGF-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1—PR56.1

Indexes (1)

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
AGFSET1
  1. COMPANY
  2. GROUP-CODE
  3. TAX-STATUS
PrimaryPR56.1

Programs

Updated by (1)