Approval Setup and Transaction Tables

Basic tables to set up PeopleSoft Supplier Contract Management include:

Table Description

INSTALLATION_CS

Installation settings for Supplier Contracts - Collaboration email template

CS_AW_TYPE

(CS_AW_TYPE_LNG)

Approval type definition.

CS_CLASS

(CS_CLASS_LNG)

Clause class definition.

CS_CLASSDTL

(CS_CLASSDTL_LNG)

Clause detail - map to approval types.

CS_AUTH_USER

User authorization - supplier contracts authorizations for documents, sections, and templates.

CS_AUTH_USER_DTL

User authorization detail - document author and user authorizations

CS_OPR_DEF_TBL_CS

User preferences - main user preference table for Supplier Contract Management.

CS_OPR_COLLAB

Default collaborators - list of default users to include in document collaboration .

These are some of the basic tables the system uses during the processing of approvals and collaboration. You can reference additional tables when setting up approval process definitions to define criteria for approval framework workflow:

Table Description

CS_DOC_HDR

Document Header: Fields in the document header can be commonly accessed for approval process criteria.

CS_AW_DOC_CLSVW

This is a special view that is useful in the approval process definition to control clause approvals within a document.

CS_DOC_PO_KEYS

This table is useful in the approval process definition to determine if document approval is related to a purchase order contract.