PR941 – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PR9
Primary key
COMPANY, PAYROLL-YEAR, QUARTER, REPORT-ENTITY
Fields
23
Updated by
1 program
Referenced by
2 programs

PR941 is a Lawson Payroll table (prefix PR9); no description in the lawson data dictionary. It is indexed by COMPANY, PAYROLL-YEAR, QUARTER, REPORT-ENTITY (PR9SET1). It is related 1:1 to PRSYSTEM. It is updated by PR87.1 and referenced by PR287 and PR290. The table has 23 fields, 1 index and 2 documented relations.

About PR941

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the PR9- 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
#PR9-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PR87.1
#PR9-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year in which the allocation was taken.PR87.1
#PR9-QUARTER PK
QUARTER		Numeric 1Contains the fiscal quarter for the data stored in this record.PR87.1
#PR9-REPORT-ENTITY PK
REPORT_ENTITY		Alpha 5—PR87.1
#PR9-STATE
STATE		Alpha 2This field contains the two-character state code of the address.PR87.1
#PR9-FUTURE-BOX
FUTURE_BOX		Alpha 1—PR87.1
#PR9-SEASONAL-BOX
SEASONAL_BOX		Alpha 1—PR87.1
#PR9-SOC-SEC-BOX
SOC_SEC_BOX		Alpha 1—PR87.1
#PR9-INC-TAX-ADJ
INC_TAX_ADJ		Signed 11.2——
#PR9-SICK-PAY
SICK_PAY		Signed 11.2—PR87.1
#PR9-FRACTIONS-PAY
FRACTIONS_PAY		Signed 11.2—PR87.1
#PR9-DEP-AMT-941
DEP_AMT_941		Signed 15.2—PR87.1
#PR9-EMPLOYEE-COUNT
EMPLOYEE_COUNT		Numeric 11—PR87.1
#PR9-NEXT-OR-REF-BX
NEXT_OR_REF_BX		Alpha 1—PR87.1
#PR9-SEMI-OR-MNTHLY
SEMI_OR_MNTHLY		Alpha 1—PR87.1
#PR9-TIP-GTL-ADJ
TIP_GTL_ADJ		Signed 11.2—PR87.1
#PR9-INC-TAX-WH
INC_TAX_WH		Signed 11.2——
#PR9-PRIOR-FICA-ADJ
PRIOR_FICA_ADJ		Signed 11.2——
#PR9-FICA-TAX-ADJ
FICA_TAX_ADJ		Signed 11.2——
#PR9-FINAL-DATE
FINAL_DATE		Numeric 8 (yyyymmdd)—PR87.1
#PR9-MONTH-1-LIAB
MONTH_1_LIAB		Signed 14.2—PR87.1
#PR9-MONTH-2-LIAB
MONTH_2_LIAB		Signed 14.2—PR87.1
#PR9-MONTH-3-LIAB
MONTH_3_LIAB		Signed 14.2—PR87.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
PR9SET1
  1. COMPANY
  2. PAYROLL-YEAR
  3. QUARTER
  4. REPORT-ENTITY
PrimaryPR287, PR290, PR87.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPR941

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PR9-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Report EntityPRSYSTEMRequired
PR9-COMPANY→PRS-COMPANY
PR9-REPORT-ENTITY→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (2)