APPAYGROUP – Pay Group

System
Accounts Payable (AP)
Prefix
PAY
Primary key
PAY-GROUP
Fields
18
Updated by
7 programs
Referenced by
108 programs

APPAYGROUP is the Pay Group table in Lawson Accounts Payable (prefix PAY). It is indexed by PAY-GROUP (PAYSET1); alternate indexes: PAYSET2. It is related 1:M to APMONITOR and APPAYCOREL. It is updated by AP01.1, AP151, AP160, AP161, AP167, AP56.1 and ZA161 and referenced by AP00.4, AP00.5, AP101, AP115, AP12.1, AP125, AP126, AP136 and 100 more. The table has 18 fields, 2 indexes and 2 documented relations.

About APPAYGROUP

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.

Fields (18)

Column = COBOL field name without the PAY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PAY-PAY-GROUP PK
PAY_GROUP		Alpha 4A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.AP01.1, AP191, AP193, AP35.1, AP80.1
PAY-NAME
NAME		Alpha 30 (Lower Case)The name or description of the pay group.AP01.1
PAY-POST-COMPANY
POST_COMPANY		Numeric 4The 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.AP01.1
PAY-VENDOR-GROUP
VENDOR_GROUP		Alpha 4The 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.AP01.1
PAY-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The 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.AP01.1
PAY-CURR-ND
CURR_ND		Numeric 1The number of decimals defined for the posting company base currency.AP01.1
PAY-CASH-CODE
CASH_CODE		Alpha 4The 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.AP01.1
PAY-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The 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.AP01.1
PAY-LAST-DRAFT-NBR
LAST_DRAFT_NBR		Numeric 10If the pay group processes bill of exchange payments, this field contains the last bill of exchange number printed for the pay group.AP01.1, AP151, AP56.1
PAY-ACCEPT-ACCTING
ACCEPT_ACCTING		Alpha 1If the pay group processes bill of 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.
AP01.1
PAY-DRAFT-CODE
DRAFT_CODE		Alpha 4If 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.AP01.1
PAY-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The pay group status. Valid values are:
  • A Active. Default value.
  • I Inactive.
AP01.1
PAY-USED-FL
USED_FL		Alpha 1Indicates 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
USER_CLASS		Alpha 12The 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.AP01.1
PAY-SERIAL-NUM
SERIAL_NUM		Numeric 8This field is a system-generated number used to group tape payment transactions together.AP160, AP161, ZA161
PAY-DRAFT-NBR-OPT
DRAFT_NBR_OPT		Alpha 1—
  • A Auto BOE Numbering
  • M Manual BOE Numbering
AP01.1
PAY-BOE-STMT-NBR
BOE_STMT_NBR		Numeric 8—AP167
PAY-USE-DFT-STMTS
USE_DFT_STMTS		Alpha 1—
  • Y Yes
  • N No
AP01.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAYSET1PAY-GROUPPrimaryAP00.4, AP00.5, AP01.1, AP01.3, AP01.4, AP101, AP115, AP12.1 +22 more (list truncated in source)
PAYSET2POST-COMPANY, PAY-GROUPKeyChangeAP195

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
ApmonitorAPMONITORDelete RestrictedPAY-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
AppaycorelAPPAYCORELRequiredPAY-PAY-GROUP → PYR-PAY-GROUP, → PYR-COMPANY, → PYR-PROC-LEVEL

Programs

Updated by (7)

Referenced by (108)