CNTRCT_IDPrompt Table: PRCR_ENTITY_TBL
P=Procurement History
S=Spend Analysis
Default Value: P
PRCR_CNTRCT_VW(SQL View) |
Index Back |
|---|---|
Procurement Entity Cntl Table |
| SELECT CNTRCT_ID , ENTITY_TYPE , REPORT_ENTITY FROM PS_PRCR_ENTITY_TBL WHERE ENTITY_TYPE = 'P' AND CNTRCT_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: PRCR_ENTITY_TBL |
| 2 | ENTITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reporting Entity Type
P=Procurement History S=Spend Analysis Default Value: P |
| 3 | REPORT_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |