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     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     AP23.1
AP230     AP25.1    AP25.2    AP250     AP251     AP255
AP26.1    AP260     AP265     AP266     AP27.1    AP270
AP28.1    AP28.2    AP30.1    AP30.2    AP30.3    AP30.4
AP32.2    AP35.1    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    CB500     EE135     EE20.1
EE20.2    EE20.3    EE20.4    EE35.1    EE35.2    EE520
MA41.2    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
To Company Base        The base currency assigned to the
Currency               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
Account Currency       The number of decimals defined for the
Code                   posting company base currency.

PAY-CASH-CODE          Alpha 4                                   AP01.1
Accounts Receivable    The cash code assigned to the pay
Code                   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: Status        The pay group status. Valid values are:

                       A = Active. Default value.
                       I = Inactive.

PAY-USED-FL            Alpha 1
Element: Used          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
Payment Run Serial     This field is a system-generated number
Number                 used to group tape payment transactions
                       together.

PAY-DRAFT-NBR-OPT      Alpha 1                                   AP01.1
Bill of Exchange       A = Auto BOE Numbering
Numbering Opt          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     This index is used to verify or access   AP00.4  AP00.5
                        a pay group record.                      AP01.1  AP01.3
                                                                 AP01.4  AP101
                                                                 AP115   AP12.1
                                                                 AP125   AP126
                                                                 AP141   AP150
                                                                 AP151   AP155
                                                                 AP156   AP160
                                                                 AP161   AP166
                                                                 AP167   AP170
                                                                 AP180   AP181
                                                                 AP185   AP190
                                                                 AP191   AP193
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...

PAYSET2   POST-COMPANY  When processing period closing for a     AP195
          PAY-GROUP     general ledger company that is not also
                        defined as an Accounts Payable company,
                        this index is used to access the pay
                        group record associated with the posting
                        company.
                        KeyChange

                         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