SETIDCNTRCT_IDVERSION_NBRCNTRCT_ID_CHILDPrompt Table: CNTRCT_CHI_SRCH
A=Active
I=Inactive
C=Contract Child
S=Supplier Location
CS_CNT_CHILD_VW(SQL View) |
Index Back |
|---|---|
Contract Relationship TableContract Relationship Table |
| SELECT R.Setid , R.Cntrct_Id , R.Version_Nbr , r.Cntrct_Id_Child , R.Reltn_Status , R.Reltn_Type , ch.cntrct_style_name , ch.vendor_id , ch.name1 , ch.vendor_name_short , ch.cntrct_begin_dt , ch.cntrct_expire_dt , ch.amt_cntrct_max FROM Ps_Cntrct_Reltn R , Ps_Cntrct_Hdr H , PS_CS_CNT_CHIRELVW Ch WHERE R.Setid = H.Setid AND R.Cntrct_Id = H.Cntrct_Id AND R.Version_Nbr = H.Version_Nbr AND R.Setid = Ch.Setid AND R.Cntrct_Id_Child = Ch.Cntrct_Id_Child |
| # | 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 |
| 5 | RELTN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Relationship Status
A=Active I=Inactive |
| 6 | RELTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Contract Relationship Type
C=Contract Child S=Supplier Location |
| 7 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Style Description |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 11 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 12 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 13 | AMT_CNTRCT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount of Contract. |