PROCESS_INSTANCERUN_CNTL_IDSETIDCNTRCT_IDVERSION_NBR1=All Contracts
2=Contract ID
3=Contract Begin Date Range
CS_CNT_SPND_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 5 | VERSION_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | CNTRCT_EXPIRY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Contract Expiry Flag |
| 8 | CS_CNTRCT_SPND_FLG | Character(1) | VARCHAR2(1) NOT NULL | Notify on Spend Threshold |
| 9 | CNT_AUTO_APPR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Draft Auto-Approval |
| 10 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 11 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 12 | CS_SPEND_SELECT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Spend Threshold Selection
1=All Contracts 2=Contract ID 3=Contract Begin Date Range |
| 13 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 14 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
| 15 | SELECT_PARM | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Clause Sel Parms |