CS_CNT_AG_HVW(SQL View) |
Index Back |
|---|---|
Contract Header AgreementContract Header Agreement |
| SELECT SETID , CNTRCT_ID , VERSION_NBR , CAT_LINE_NBR , CNTRCT_LINE_NBR , CS_AGREE_SEQ5 , CS_SETID , CS_AGREE_CD , DESCR60 , CS_INCL_IN_CNTRCT , CS_RESULT_TYPE , CURRENCY_CD , UNIT_OF_MEASURE , CS_COMPLIANCE_STAT , CS_TARGET_DATE , CS_RESULT_DATE , CS_RESULT_NUMERIC , CS_RESULT_YN , CS_ACT_RESULT_DATE , CS_ACT_RESULT_NUM , CS_ACT_RESULT_YN , CS_COMMENTS254 , OPRID_LAST_UPDT , LAST_UPDATE_DTTM , CS_COMMENTS FROM PS_CS_CNT_AG WHERE CNTRCT_LINE_NBR = 0 AND CAT_LINE_NBR = 0 |
| # | 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 | CAT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 5 | CNTRCT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Buying Agreement Line Nbr
Default Value: 0 |
| 6 | CS_AGREE_SEQ5 |
Number(5,0) | INTEGER NOT NULL | Agreement Sequence for Supplier Contract Managment |
| 7 | CS_SETID | Character(5) | VARCHAR2(5) NOT NULL | setid for the document objects |
| 8 | CS_AGREE_CD | Character(18) | VARCHAR2(18) NOT NULL |
Agreement Code for Supplier Contract Managment
Prompt Table: CS_AGREE |
| 9 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 10 | CS_INCL_IN_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL |
Include In Contract for Supplier Contract Managment
Y/N Table Edit Default Value: Y |
| 11 | CS_RESULT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Result Type for Supplier Contract Managment
C=Monetary D=Date M=Metric N=Numeric T=Text X=None Y=Yes/No |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 14 | CS_COMPLIANCE_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Compliance Status for Supplier Contract Managment
1=Compliant 2=Not Compliant 3=Not Set 4=Cancelled Default Value: 3 |
| 15 | CS_TARGET_DATE | Date(10) | DATE | Contract Target Date for Supplier Contract Management |
| 16 | CS_RESULT_DATE | Date(10) | DATE | Negotiated Result for Supplier Contract Managment |
| 17 | CS_RESULT_NUMERIC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Negotitated Result for Supplier Contract Managment |
| 18 | CS_RESULT_YN | Character(1) | VARCHAR2(1) NOT NULL |
Negotiated Result for Supplier Contract Managment
N=No Y=Yes Y/N Table Edit |
| 19 | CS_ACT_RESULT_DATE | Date(10) | DATE | Actual Result Date for Supplier Contract Managment |
| 20 | CS_ACT_RESULT_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Actual Result for Supplier Contract Managment |
| 21 | CS_ACT_RESULT_YN | Character(1) | VARCHAR2(1) NOT NULL |
Actual Result for Supplier Contract Managment
N=No Y=Yes Y/N Table Edit |
| 22 | CS_COMMENTS254 | Character(254) | VARCHAR2(254) NOT NULL | Comments for Supplier Contract Managment |
| 23 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 24 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 25 | CS_COMMENTS | Long Character | CLOB | Comment Field for Supplier Contract Managment |