| # |
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
Prompt Table:
SP_SETID_NONVW
|
| 2 |
CS_AGREE_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Agreement Code for Supplier Contract Managment
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 6 |
CS_INCL_IN_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include In Contract for Supplier Contract Managment
Y/N Table Edit
Default Value: Y
|
| 7 |
TARGET_DATE_PARM |
Character(2) |
VARCHAR2(2) NOT NULL |
Target Date Parameters for Supplier Contract Managment
E=Contract End Date
EM=Contract End Date - N days
EP=Contract End Date + N days
S=Contract Start Date
SM=Contract Start Date - N days
SP=Contract Start Date + N days
|
| 8 |
TARGET_DATE_OFFSET |
Number(3,0) |
SMALLINT NOT NULL |
Target Date Offset for Supplier Contract Management
|
| 9 |
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
|
| 10 |
CS_METRIC_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Supplier Contract Metric ID for Service Level Agreements
01=None
02=On-time Receipt Performance
03=On-time Quantity Performance
04=Quantity Performance
05=PO/Receipt Qty Performance
06=Quality Performance
Default Value: 01
|
| 11 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 12 |
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.
|
| 13 |
CS_COMMENTS254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments for Supplier Contract Managment
|
| 14 |
CS_COMMENTS |
Long Character |
CLOB |
Comment Field for Supplier Contract Managment
|