APPAYCOREL – Pay Group-Company Relationship

System
Accounts Payable (AP)
Prefix
PYR
Primary key
PAY-GROUP, COMPANY, PROC-LEVEL
Fields
3
Updated by
4 programs
Referenced by
13 programs

APPAYCOREL is the Pay Group-Company Relationship table in Lawson Accounts Payable (prefix PYR). It is indexed by PAY-GROUP, COMPANY, PROC-LEVEL (PYRSET1); alternate indexes: PYRSET2 and PYRSET3. It is related 1:1 to APCOMPANY and APPROCLEV. It is updated by AP00.4, AP00.5, AP101 and AP305 and referenced by AP01.1, AP01.4, AP12.1, AP150, AP151, AP170, AP195, AP201 and 5 more. The table has 3 fields, 3 indexes and 2 documented relations.

About APPAYCOREL

The pay group - company relationship file describes relationships between a pay group and accounts payable companies and process levels. A company and associated process levels do not need to be assigned the same pay group. Each company process level can belong to a different pay group as long as the pay group currency and company base currency are the same. The vendor group assigned to the company and the pay group must be the same.

Fields (3)

Column = COBOL field name without the PYR- 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
#PYR-PAY-GROUP PK
PAY_GROUP		Alpha 4A user-defined pay group. A pay group is made up of a posting company and any number of accounts payable companies and process levels. Must be a valid record in the Pay Group file. A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.AP00.5, AP101
#PYR-COMPANY PK
COMPANY		Numeric 4An accounts payable company that is assigned to the pay group. Must be a valid record in the Accounts Payable Company file.AP00.5, AP101
#PYR-PROC-LEVEL PK
PROC_LEVEL		Alpha 5An accounts payable process level that is assigned to the pay group. Must be a valid record in the Accounts Payable Process Level file.AP00.5, AP101

Indexes (3)

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
PYRSET1
  1. PAY-GROUP
  2. COMPANY
  3. PROC-LEVEL
PrimaryAP00.4, AP00.5, AP01.1, AP01.4, AP101, AP150, AP151, AP170 +5 more
PYRSET2
  1. PAY-GROUP
  2. PROC-LEVEL
  3. COMPANY
KeyChangeAP150
PYRSET3
  1. COMPANY
  2. PAY-GROUP
  3. PROC-LEVEL
AP12.1, AP195, AP305, AP520

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
PYR-COMPANY→CPY-COMPANY
ApproclevAPPROCLEVRequired
PYR-COMPANY→APR-COMPANY
PYR-PROC-LEVEL→APR-PROC-LEVEL

Programs

Updated by (4)

Referenced by (13)