SETIDCS_AGREE_CDEFFDTDefault Value: %date
CS_VERIFY_SEQAT=Attaching Supporting Document
CM=Comments
DT=Date/Time Stamp
NO=Notify Only
SY=System
YN=On Line Verification with Y/N
Prompt Table: CS_OPRDESC_VW
CS_AGREE_VERIFY(SQL Table) |
Index Back |
|---|---|
SLA Agree Code VerificationsSCC 01/01/07 F-AHAYT-S60K7 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | CS_VERIFY_SEQ |
Number(5,0) | INTEGER NOT NULL | Contract Agreement Verification Step |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | CS_COMMENTS254 | Character(254) | VARCHAR2(254) NOT NULL | Comments for Supplier Contract Managment |
| 7 | CS_VERIFY_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Verification Method for Supplier Contract Managment
AT=Attaching Supporting Document CM=Comments DT=Date/Time Stamp NO=Notify Only SY=System YN=On Line Verification with Y/N |
| 8 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |
| 9 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL |
Description field for a user
Prompt Table: CS_OPRDESC_VW |
| 10 | 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. |