EB_CONVER

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: CUST_CONVER_HDR.SETID Prompt Table: SP_SETID_NONVW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_OPRVW
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Default Value: CUST_CONVER_HDR.CUST_ID Prompt Table: CUSTOMER
4	CONVER_DTTM_INIT	DateTime(26)	TIMESTAMP NOT NULL	Initial Conversation DateTime Default Value: CUST_CONVER_HDR.CONVER_DTTM_INIT
5	CONVER_DT	Date(10)	DATE NOT NULL	Conversation Date Default Value: CUST_CONVER_HDR.CONVER_DT
6	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number
7	CONVER_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Conversation DateTime Default Value: %datetime
8	DESCRLONG	Long Character	CLOB	Long Description
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN_SRCH
10	CONVER_VISIBILITY	Character(1)	VARCHAR2(1) NOT NULL	Customer Visible Y/N Table Edit
11	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: AR_CONVRSND_SCR
12	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
13	EMAIL_DATETIME	DateTime(26)	TIMESTAMP	Email DateTime
14	ORIGIN_CONV	Character(3)	VARCHAR2(3) NOT NULL	Conversation Origin EBI=eBill INT=Internal Default Value: INT
15	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. Default Value: %datetime
16	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
17	EB_UNREAD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Unread