VENDOR_CONVER(SQL Table) | 
Index Back | 
|---|---|
Conversations with a Supplier | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
| 3 | Date(10) | DATE NOT NULL | 
Conversation Date
 Default Value: %date  | 
|
| 4 | Number(6,0) | INTEGER NOT NULL | Conversation Sequence Number | |
| 5 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | 
Contact Sequence Number
 Prompt Table: VNDR_CNTCT_VW  | 
| 6 | CONVER_TOPIC | Character(30) | VARCHAR2(30) NOT NULL | Conversation Topic | 
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | 
| 8 | REVIEW_DAYS | Number(3,0) | SMALLINT NOT NULL | Review Days | 
| 9 | REVIEW_DATE | Date(10) | DATE | Review Date | 
| 10 | REVIEW_NEXT_DATE | Date(10) | DATE | Next Review Date | 
| 11 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL | 
Keyword
 Prompt Table: KEYWORD_AP  | 
| 12 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL | 
Keyword
 Prompt Table: KEYWORD_AP  | 
| 13 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL | 
Keyword
 Prompt Table: KEYWORD_AP  | 
| 14 | SES_LAST_DTTM | DateTime(26) | TIMESTAMP | 
PTSF Last Modified DateTimestamp
 Default Value: %DATETIME  | 
| 15 | DESCRLONG | Long Character | CLOB | Long Description |