|
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
|