|
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 AP201 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 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
CB500 EE135 EE20.1 EE20.2 EE20.3 EE20.4
EE35.1 EE35.2 EE520 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
Account Currency The number of decimals defined for the
Code 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: 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 Next BOE Statment Number
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 AP201
AP230 AP25.1
...
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
|