SETIDDefault Value: OPR_DEF_TBL_FS.SETID
CNTRCT_IDDefault Value: NEXT
VERSION_NBRCATEGORY_IDCAT_LINE_NBRCNT_CAT_SRCH(SQL View) |
Index Back |
|---|---|
Contract Line Search View |
| SELECT A.SETID , A.CNTRCT_ID ,A.VERSION_NBR , A.CATEGORY_ID , A.CAT_LINE_NBR FROM PS_CNTRCT_CATEGORY A WHERE A.CATEGORY_ID <> ' ' AND A.LINE_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Default Value: NEXT |
| 3 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 4 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 5 | CAT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |