CS_CLSGRP_SVW(SQL View) |
Index Back |
---|---|
PTSF Clause GroupsClause Groups for PTSF |
SELECT D.SETID , D.CS_OBJECT_ID , D.CS_CLAUSE_GROUP FROM PS_CS_CLS_GRP_DTL D WHERE CS_OBJECT_TYPE = '0001' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | CS_OBJECT_ID | Character(20) | VARCHAR2(20) NOT NULL |
Object id -- clause, section
Prompt Table: CS_OBJECTS_HDR |
3 | CS_CLAUSE_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Supplier contract Clause Group
Prompt Table: CS_CLS_GRP |