TRX_EQTY_DVDND

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EQUITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Equity Identification Number - used to identify an equity in the system. the number is system generated and used for technical purposes only. Prompt Table: TRX_EQTY_DEFN
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	DECLARATION_DT	Date(10)	DATE	Date the dividend was declared
5	RECORD_HOLDER_DT	Date(10)	DATE	Date the equity is being held on the record
6	EXDIVIDEND_DT	Date(10)	DATE	Ex dividend date
7	PAYMENT_DT	Date(10)	DATE	Payment Date
8	CASH_DIVIDEND	Character(1)	VARCHAR2(1) NOT NULL	Checkbox to indicate if the dividend is Cash Y/N Table Edit
9	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.
10	TRANSACTION_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The nominal or actual deal transaction amount.
11	TRANSACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"The nominal Prompt Table: CURRENCY_CD_TBL
12	STOCK_DIVIDEND	Character(1)	VARCHAR2(1) NOT NULL	Checkbox to indicate if the dividend is Stock Y/N Table Edit
13	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
14	NBR_OF_CONTRACTS	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	This is the number of future contracts associated with a deal
15	TRANSACTION_PRICE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The preferred business price for a given deal transaction.
16	TRANSACTION_YIELD	Signed Number(15,8)	DECIMAL(13,8) NOT NULL	The applicable yield for an interest rate physical deal transaction.