APPAYCOREL FILE
Pay Group-Company Relationship
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.
REFERENCED BY
AP01.1 AP01.4 AP150 AP151 AP170 AP201
AP230 AP250 AP12.1 AP195 AP520
UPDATED BY
AP00.5 AP00.4 AP101 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYR-PAY-GROUP Alpha 4 AP00.5 AP101
Pay Group A 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.
PYR-COMPANY Numeric 4 AP00.5 AP101
Company An accounts payable company that is
assigned to the pay group. Must be a
valid record in the Accounts Payable
Company file.
PYR-PROC-LEVEL Alpha 5 AP00.5 AP101
Process Level An accounts payable process level that
is assigned to the pay group. Must be a
valid record in the Accounts Payable
Process Level file.
APPAYCOREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYRSET1 PAY-GROUP This index is used by Cash Requirements AP00.4 AP00.5
COMPANY to verify that the given pay group and AP01.1 AP01.4
PROC-LEVEL company have a pay group - company AP101 AP150
relationship record. AP151 AP170
AP201 AP230
AP250
PYRSET2 PAY-GROUP This index is used by Cash Requirements AP150
PROC-LEVEL to verify that a given pay group and
COMPANY process level have a pay group - process
level relationship record.
KeyChange
PYRSET3 COMPANY This index is used to validate that a AP12.1 AP195
PAY-GROUP company has a pay group - company AP305 AP520
PROC-LEVEL relationship record.
APPAYCOREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PYR-COMPANY -> CPY-COMPANY
Approclev APPROCLEV Required
PYR-COMPANY -> APR-COMPANY
PYR-PROC-LEVEL -> APR-PROC-LEVEL
|
