| # |
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
Default Value: 1
|
| 4 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 5 |
CAT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Category Line Number
|
| 6 |
CS_AGREE_SEQ5 |
Number(5,0) |
INTEGER NOT NULL |
Agreement Sequence for Supplier Contract Managment
|
| 7 |
CS_VERIFY_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Contract Agreement Verification Step
Prompt Table:
CS_CNT_AG_VFY
|
| 8 |
CS_WORKFLOW_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Workflow Sequence for Supplier Contract Managment
|
| 9 |
CS_WORKFLOW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Type flag
0=Agreement
1=Verification Step
2=Agreement and Steps
|
| 10 |
CS_REMIND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow reminder sent flag
Y/N Table Edit
Default Value: N
|
| 11 |
CS_REMINDFINAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow final reminder flag
Y/N Table Edit
Default Value: N
|
| 12 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
%EDITTABLE
|
| 13 |
OPRDEFNDESC |
Character(30) |
VARCHAR2(30) NOT NULL |
Description field for a user
Prompt Table:
CS_OPRDESC_VW
|
| 14 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 15 |
USER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
User Type for Supplier Contract Managment
E=External
I=Internal
|
| 16 |
DAYS_PRIOR_REMIND |
Number(4,0) |
SMALLINT NOT NULL |
Reminder Days Prior to Contract Target Date for Supplier Contract Managment
|
| 17 |
DAYS_FINAL_REMIND |
Number(4,0) |
SMALLINT NOT NULL |
Nag Days for Supplier Contract Managment
|
| 18 |
PASSED_DUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify User when Contract Target Date is Passed Due for Supplier Contract Managment
Y/N Table Edit
Default Value: N
|
| 19 |
NOTIFY_ON_STAT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify On Status Change
Y/N Table Edit
Default Value: N
|
| 20 |
NOTIFIED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Notified Flag
Y/N Table Edit
Default Value: N
|
| 21 |
CS_WARN_PERF |
Character(1) |
VARCHAR2(1) NOT NULL |
Warning for SLA Metric Result Type
Y/N Table Edit
Default Value: N
|
| 22 |
CS_UNACCEPT_PERF |
Character(1) |
VARCHAR2(1) NOT NULL |
Uncacceptable Performance for SLA Metric Result
Y/N Table Edit
Default Value: N
|
| 23 |
ALLOW_UPDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Updates
Y/N Table Edit
Default Value: N
|
| 24 |
OVERRIDE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Specify Email
Y/N Table Edit
Default Value: N
|