Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPAYGROUP


                            APPAYGROUP FILE

                               Pay Group

The Pay Group file contains pay group records which are defined and
maintained in AP01.1 (Payment Group). A pay group lets you create a single
payment for a vendor to pay invoices received by multiple Accounts Payable
companies and process levels. A pay group is made up of one posting company
and any number of invoice companies and process levels.

All companies associated with the pay group must belong to the same vendor
group and have the same base currency. You can assign a company and all of its
process levels to the same pay group, assign each process level to a different
pay group, or group process levels under pay groups however you need to
process payments.

REFERENCED BY

AP00.4    AP00.5    AP101     AP115     AP12.1    AP125
AP126     AP136     AP141     AP150     AP155     AP156
AP166     AP170     AP180     AP181     AP185     AP190
AP191     AP193     AP195     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.6    AP20.7    AP20.8    AP201
AP21.1    AP23.1    AP230     AP25.1    AP25.2    AP250
AP251     AP255     AP26.1    AP265     AP266     AP27.1
AP270     AP28.1    AP28.2    AP30.1    AP30.2    AP30.3
AP30.4    AP35.1    AP36.2    AP40.1    AP41.1    AP520
AP55.1    AP55.2    AP80.1    AP81.1    AP90.5    AP91.2
AP91.4    AP92.2    AP92.3    AP92.4    AP93.2    AP93.3
AP93.4    API1.1    API2.1    CB06.2    CB50.1    CB500
CB54.1    CB55.1    CB554     EE135     EE20.1    EE20.2
EE20.3    EE20.4    EE35.1    EE35.2    EE520     ET09.2
MA41.1    MA41.2    MA41.4    MA41.7    MA43.2    MA540
MA61.1    MA65.1    MA70.1    MA75.1    MAI1.1

UPDATED BY

AP01.1    AP151     AP160     AP161     AP167     AP56.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAY-PAY-GROUP          Alpha 4                                   AP01.1  AP191
Element: Pay Group     A pay group is used for processing        AP193   AP35.1
                       accounts payable payments. A pay group    AP80.1
                       lets you create a single payment for a
                       vendor to pay invoices received by all
                       company process levels assigned to the
                       pay group.

PAY-NAME               Alpha 30  (Lower Case)                    AP01.1
Element: Name          The name or description of the pay
                       group.


PAY-POST-COMPANY       Numeric 4                                 AP01.1
Element: Posting CompanThe company used for posting cash
                       transactions to the general ledger. Must
                       be a valid general ledger company. The
                       posting company must have the same base
                       currency as all companies assigned to
                       the pay group. This field cannot be
                       changed once an invoice has been entered
                       for the pay group.


PAY-VENDOR-GROUP       Alpha 4                                   AP01.1
Element: Vendor Group  The vendor group associated with the
                       pay group. A vendor group represents a
                       group of vendors that can be shared by
                       more than one accounts payable company.
                       All companies associated with the pay
                       group must belong to the same vendor
                       group. Must be defined in the Vendor
                       Group file.

PAY-BASE-CURRENCY      Alpha 5                                   AP01.1
Element: Base Currency The base currency assigned to the
                       posting company. The posting company and
                       all accounts payable companies
                       associated with the pay group must have
                       the same base currency.

PAY-CURR-ND            Numeric 1                                 AP01.1
Element: Acct Nd       The number of decimals defined for the
                       posting company base currency.

PAY-CASH-CODE          Alpha 4                                   AP01.1
Element: Cash Code     The cash code assigned to the pay
                       group. A cash code represents a specific
                       bank account. Must be defined in the
                       Cash Code file. A valid relationship
                       must be defined between the cash code
                       and all companies associated with the
                       pay group, including the posting
                       company.

PAY-BANK-INST-CODE     Alpha 3                                   AP01.1
Element: Payment Code  The payment code associated with the
                       pay group. Represents a type of cash
                       payment, such as a check or payment
                       tape, or bill of exchange payment. Must
                       be defined as a cash or bill of exchange
                       payment transaction code in the
                       Transaction Code file.

PAY-LAST-DRAFT-NBR     Numeric 10                                AP01.1  AP151
Last Bill of           If the pay group processes bill of        AP56.1
Exchange               exchange payments, this field contains
                       the last bill of exchange number printed
                       for the pay group.

PAY-ACCEPT-ACCTING     Alpha 1                                   AP01.1
BOE Acceptance         If the pay group processes bill of
Accounting             exchange payments, this field indicates
                       whether the bill of exchange amount
                       should post to the BOE Acceptance
                       Account upon acceptance. Valid values
                       are:

                       N = No. Default value.
                       Y = Yes.

PAY-DRAFT-CODE         Alpha 4                                   AP01.1
Element: BOE Accrual CoIf the pay group has Yes selected in
                       the Acceptance Accounting field, this
                       field contains the bill of exchange
                       accrual code assigned to the pay group.
                       A bill of exchange accrual code
                       represents a default acceptance account.
                       Must be defined in the Bill of Exchange
                       Accrual Code file.

PAY-ACTIVE-STATUS      Alpha 1                                   AP01.1
Element: Active Status The pay group status. Valid values are:

                       A = Active. Default value.
                       I = Inactive.

PAY-USED-FL            Alpha 1
Element: Used Fl       Indicates whether any invoices have
                       been entered for the pay group. The
                       posting company assigned to the pay
                       group cannot be changed once the pay
                       group has been used.

PAY-USER-CLASS         Alpha 12                                  AP01.1
Element: User Class    The user class assigned to the pay
                       group. Represents a group of Accounts
                       Payable system users. If assigned, only
                       users assigned to the user group can
                       access or update pay  group information
                       in programs that update pay group
                       information. Must be a valid record in
                       the Pay Group User Class file.

PAY-SERIAL-NUM         Numeric 8                                 AP160   AP161
Element: Serial Num    This field is a system-generated number
                       used to group tape payment transactions
                       together.

PAY-DRAFT-NBR-OPT      Alpha 1                                   AP01.1
Element: Draft Nbr Opt A = Auto BOE Numbering
                       M = Manual BOE Numbering

PAY-BOE-STMT-NBR       Numeric 8                                 AP167
Element: Statement Nbr

PAY-USE-DFT-STMTS      Alpha 1                                   AP01.1
Element: Use Dft Stmts Y = Yes
                       N = No

                         APPAYGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAYSET1   PAY-GROUP                                              AP00.4  AP00.5
                                                                 AP01.1  AP01.3
                                                                 AP01.4  AP101
                                                                 AP115   AP12.1
                                                                 AP125   AP126
                                                                 AP136   AP141
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP160   AP161
                                                                 AP166   AP167
                                                                 AP170   AP180
                                                                 AP181   AP185
                                                                 AP190   AP191
                                                                 AP193   AP195
                                                                 AP20.1  AP20.2
                                                                 ...

PAYSET2   POST-COMPANY  KeyChange                                AP195
          PAY-GROUP

                         APPAYGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apmonitor      APMONITOR    Delete Restricted

                            PAY-PAY-GROUP    -> MON-PAY-GROUP
                                                MON-RUN-PROG
                                                MON-PROC-GRP
                                                MON-PROC-LEVEL
                                                MON-ADA-ACCT-STRCT
                                                MON-BATCH-NUM
                                                MON-AUTH-CODE
                                                MON-COMPANY

Appaycorel     APPAYCOREL   Required

                            PAY-PAY-GROUP    -> PYR-PAY-GROUP
                                                PYR-COMPANY
                                                PYR-PROC-LEVEL