TRX_POS_TR_TEO1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
4	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	TRANSACTION_LEG	Number(1,0)	SMALLINT NOT NULL	The separate and distinct business positions of a given deal transaction line. 1=Pay Leg 2=Receive Leg
7	PERIOD_START_DT	Date(10)	DATE	Represents the date commencement point for a given time set utilized in cash worksheet processing. Default Value: %date
8	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.
9	PD_INT_START_DT	Date(10)	DATE	Represents the commencement date for calculating accrued interest for a given deal transa
10	ASSET_LIABILITY	Character(1)	VARCHAR2(1) NOT NULL	Whether the deal transaction leg represents an asset or a liability A=Asset L=Liability
11	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
12	PRINCIPAL_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The notional principal balance of a given deal transaction at commencement.
13	PERIOD_INT_ACCRUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the amount of accrued interest attributable to an interest period for a given
14	START_INT_ACCRUAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The initial start amount for a deal transaction's next interest accrual.
15	DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
16	START_DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Internal field utilized to determine the appropriate accrual accounting amount for a giv
17	ANCHOR_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the business unit that generates a given deal transaction.
18	ANCHOR_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Principal amount of a given deal transaction denominated in the anchor currency.
19	SPOT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is stored ei
20	SPOT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange spot rate is stored either
21	FORWARD_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange forward rate is
22	FORWARD_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determing whether a currency exchange forward rate is stor
23	RESET_RATE_SET	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a floating rate for a particular cash flow has been ascertained and e N=Rate Not Set Y=Reset Rate Set
24	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.
25	RATE_RESET_DT	Date(10)	DATE	The date that an interest rate quoted in the market is captured for purposes of calculating interest
26	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code