VENDOR_CONVER(SQL Table) |
Index Back |
---|---|
Conversations with a Supplier |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
3 | CONVER_DT | Date(10) | DATE NOT NULL |
Conversation Date
Default Value: %date |
4 | CONVER_SEQ_NUM | 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 |