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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PYRSET1PAY-GROUP, COMPANY, PROC-LEVELPrimaryAP00.4, AP00.5, AP01.1, AP01.4, AP101, AP150, AP151, AP170 +5 more
PYRSET2PAY-GROUP, PROC-LEVEL, COMPANYKeyChangeAP150
PYRSET3COMPANY, PAY-GROUP, PROC-LEVELAP12.1, AP195, AP305, AP520

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredPYR-COMPANY → CPY-COMPANY
ApproclevAPPROCLEVRequiredPYR-COMPANY → APR-COMPANY, PYR-PROC-LEVEL → APR-PROC-LEVEL

Programs

Updated by (4)

Referenced by (13)