AP_PAY_GROUP

This table has been created to allow the user to select multiple values for the pay groups for the Payment Process Request Template or the Payment Process Request. These values will be ORed in the query when multiple values exist during the AutoSelect Program.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
AP_PAY_GROUP_PK	PAY_GROUP_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PAY_GROUP_ID	NUMBER		18	Yes	Pay group unique identifier. A pay group is a method for categorizing suppliers for payment processing.
VENDOR_PAY_GROUP	VARCHAR2	30		Yes	Supplier pay group used in the selection criteria for invoices to be paid.
TEMPLATE_ID	NUMBER		18		Payment template unique identifier.
CHECKRUN_ID	NUMBER		18		Payment process request identifier
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_PAY_GROUP	ap_payment_templates	TEMPLATE_ID
AP_PAY_GROUP	ap_inv_selection_criteria_all	CHECKRUN_ID

Indexes

Index	Uniqueness	Columns
AP_PAY_GROUP_U1	Unique	PAY_GROUP_ID
AP_PAY_GROUP_N1	Non Unique	TEMPLATE_ID
AP_PAY_GROUP_N2	Non Unique	CHECKRUN_ID