AP_ARC_VND_CV_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	CONVER_DT	Date(10)	DATE NOT NULL	Conversation Date Default Value: %date
6	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number
7	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT
8	CONVER_TOPIC	Character(30)	VARCHAR2(30) NOT NULL	Conversation Topic
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	REVIEW_DAYS	Number(3,0)	SMALLINT NOT NULL	Review Days
11	REVIEW_DATE	Date(10)	DATE	Review Date
12	REVIEW_NEXT_DATE	Date(10)	DATE	Next Review Date
13	KEYWORD1	Character(10)	VARCHAR2(10) NOT NULL	Keyword Prompt Table: KEYWORD_AP
14	KEYWORD2	Character(10)	VARCHAR2(10) NOT NULL	Keyword Prompt Table: KEYWORD_AP
15	KEYWORD3	Character(10)	VARCHAR2(10) NOT NULL	Keyword Prompt Table: KEYWORD_AP
16	SES_LAST_DTTM	DateTime(26)	TIMESTAMP	PTSF Last Modified DateTimestamp
17	DESCRLONG	Long Character	CLOB	Long Description