SETIDCNTRCT_IDVERSION_NBRCNTRCT_ID_CHILDPrompt Table: CNTRCT_CHI_SRCH
CS_CNTRELCH_TMP(SQL Table) |
Index Back |
|---|---|
Source table for bind11/30/2015 PUM#18 Master Contracts feature Temp table used to get key structre of Child Relationships for contracts Nothing is ever stored in this table .. just used in Contract Management source transaction mapping. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 4 | CNTRCT_ID_CHILD |
Character(25) | VARCHAR2(25) NOT NULL |
Contract ID To
Prompt Table: CNTRCT_CHI_SRCH |