Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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.7    AP101     AP12.1    AP12.2    AP125
AP126     AP150     AP155     AP156     AP157     AP166
AP170     AP180     AP181     AP185     AP190     AP191
AP193     AP195     AP20.1    AP20.2    AP20.5    AP20.6
AP20.7    AP20.8    AP201     AP225     AP226     AP23.1
AP230     AP25.1    AP25.2    AP250     AP255     AP26.1
AP260     AP265     AP266     AP270     AP28.1    AP28.2
AP30.1    AP30.2    AP30.3    AP30.4    AP32.2    AP35.1
AP40.1    AP520     AP55.1    AP55.2    AP80.1    AP81.1
AP90.5    AP91.2    AP91.4    AP92.2    AP92.3    AP92.4
CB06.2    CB500     EE135     EE20.1    EE20.2    EE20.3
EE20.4    EE35.1    EE35.2    EE520     MA40.1    MA40.2
MA41.1    MA41.2    MA41.3    MA41.4    MA41.5    MA41.6
MA43.1    MA43.2    MA43.3    MA43.4    MA52.1    MA530
MA540     PO31.1

UPDATED BY

AP01.1    AP151     AP160     AP161     AP167     AP56.1
AP957

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PAY-PAY-GROUP        Alpha 4                                     AP01.1  AP191
Pay Group            A pay group is used for processing          AP193   AP35.1
                     accounts payable payments. A pay group      AP80.1  AP957
                     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  AP957
Name                 The name or description of the pay
                     group.

PAY-POST-COMPANY     Numeric 4                                   AP01.1  AP957
Posting Company      The 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  AP957
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  AP957
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  AP957
Currency Number of   The number of decimals defined for the
Decimals             posting company base currency.

PAY-CASH-CODE        Alpha 4                                     AP01.1  AP957
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  AP957
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  AP957
Exchange             exchange payments, this field contains
                     the last bill of exchange number printed
                     for the pay group.

PAY-ACCEPT-ACCTING   Alpha 1                                     AP01.1  AP957
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  AP957
BOE Accrual Code     If 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  AP957
Status               The pay group status. Valid values are:

                     A = Active. Default value.
                     I = Inactive.

PAY-USED-FL          Alpha 1                                     AP957
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  AP957
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     AP957
Number               used to group tape payment transactions
                     together.


PAY-BOE-STMT-NBR     Numeric 8                                   AP167   AP957
BOE Statement Number The statement number assigned to a set
                     of bills of exchange cashed by a bank on
                     a single day.

PAY-USE-DFT-STMTS    Alpha 1                                     AP01.1
Pay Group Uses BOE   The Pay Group Use Draft Statements flag
Draft Stmts          specifies whether bills of exchange are
                     to be processed in sets of BOEs with the
                     same cashing date (Yes) or individually
                     (No).

PAY-DRAFT-NBR-OPT    Alpha 1                                     AP01.1
Bill of Exchange     Indicates the type of bill of exchange
Numbering Opt        numbering that will be used for the
                     company. Valid values are:

                     A = Automatic BOE numbering
                     M = Manual BOE numbering
                     " " = Manual Draft Numbering

                         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.7
                        a pay group record.                      AP01.1  AP01.3
                                                                 AP01.4  AP101
                                                                 AP12.1  AP12.2
                                                                 AP125   AP126
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP157   AP160
                                                                 AP161   AP166
                                                                 AP167   AP170
                                                                 AP180   AP181
                                                                 AP185   AP190
                                                                 AP191   AP193
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.5
                                                                 ...

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-BATCH-NUM
                                                MON-AUTH-CODE
                                                MON-COMPANY

Appaycorel     APPAYCOREL   Required

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