TRA_FISCPRD_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	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
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction. Default Value: 1
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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
8	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
9	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
10	AS_OF_DATE	Date(10)	DATE	As of Date
11	RUN_DT	Date(10)	DATE	Run Date
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	ORIG_DISCPR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the original discount/premium amount deducted from the par price of a given deal transaction such as a bond.
14	DISCPR_END_DT	Date(10)	DATE	The end date up through which accounting accruals will be calculated for a given deal transaction.
15	DISCPR_ACCR_TO_DT	Date(10)	DATE	The date up through which accounting accruals have been calculated for a given deal transaction.
16	DISCPR_ACCR_TO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amortized discount/premium amount.
17	PER_ACCR_DISCPR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the discount/premiun amount accrued during this fiscal period.
18	INT_ACCR_END_DT	Date(10)	DATE	The end date up through which accounting accruals will be calculated for a given deal transaction.
19	INT_ACCR_TO_DT	Date(10)	DATE	The date up through which accounting accruals have been calculated for a given deal transaction.
20	INT_ACCR_TO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amortized interest amount.
21	PER_ACCR_INTEREST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the interest amount accrued during this fiscal period.
22	PRINCIPAL_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The notional principal balance of a given deal transaction at commencement.
23	PRINCIPAL_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the principal.
24	INTEREST_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the interest.
25	FEE_START	Date(10)	DATE	The beginning accrual date for fee transactions.
26	FEE_END	Date(10)	DATE	End of the fees accrual period
27	FEE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The transaction fee amount.
28	FEE_ACCR_TO_DT	Date(10)	DATE	The date up through which accounting accruals have been calculated for a given fee transaction.
29	FEE_ACCR_TO_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amortized fee amount.
30	UNAMORT_FEE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents Unamortized Fee Balance on Deal Fees
31	PER_ACCR_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the fee amount accrued during this fiscal period.