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    AP12.2    AP195     AP520
AP952     AP960     MA530     MA540     PO31.1    PR199

UPDATED BY

AP00.7    AP00.4    AP101     AP305     AP958

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PYR-PAY-GROUP        Alpha 4                                     AP00.7  AP101
Pay Group            A user-defined pay group. A pay group       AP958
                     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.7  AP101
Company              An accounts payable company that is         AP958
                     assigned to the pay group. Must be a
                     valid record in the Accounts Payable
                     Company file.


PYR-PROC-LEVEL       Alpha 5                                     AP00.7  AP101
Process Level        An accounts payable process level that      AP958
                     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.7
          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
                        process level have a pay group - process
                        level relationship record.

                        KeyChange, Duplicates

PYRSET3   COMPANY       This index is used to validate that a    AP12.1  AP12.2
          PAY-GROUP     company has a pay group - company        AP195   AP305
          PROC-LEVEL    relationship record.                     AP520   AP952
                                                                 AP960   MA530
                                                                 MA540   PO31.1
                                                                 PR199

                         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