Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPAYCOREL


                            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     AP270     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
Element: 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
Element: 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
Element: 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                                              AP00.4  AP00.5
          COMPANY                                                AP01.1  AP01.4
          PROC-LEVEL                                             AP101   AP150
                                                                 AP151   AP170
                                                                 AP201   AP230
                                                                 AP250   AP270

PYRSET2   PAY-GROUP     KeyChange                                AP150
          PROC-LEVEL
          COMPANY

PYRSET3   COMPANY                                                AP12.1  AP195
          PAY-GROUP                                              AP305   AP520
          PROC-LEVEL

                         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