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 |