RSK_DEAL_MTM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
3	AS_OF_DATE	Date(10)	DATE NOT NULL	As of Date
4	MTM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The stated currency for a deal transaction's fair value (mark-to-market)
5	MTM_ACCTG_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair Value
6	MTM_ACCTG_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item
7	MTM_EXCL_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Previous (cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item. Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item.
8	MTM_EXCL_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	(Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item. Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item. NOTE: ONLY Label IDs 3 characters or less can be used as user-chosen labels on the Define Intruments / Analytics page (if added as XLATs to field MTM_EXCL_VAL_TYPE + C/P prefix)
9	ACCOUNTED_GAINLOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gain or Loss accounted for
10	ACCOUNTED_FOR	Character(1)	VARCHAR2(1) NOT NULL	Whether Accounted for Y/N Table Edit Default Value: N
11	BSE_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Base Rate Divisor for Exchange Rates
12	BSE_RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Base Rate Multiplier for Exchange Rates
13	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
14	GAIN_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gain or Loss
15	ACCTG_MC_GAIN_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Stores Accounted Multi Currency Gain or Loss
16	GAIN_LOSS_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gain Loss Prior
17	MTM_EXCL_VAL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page. 1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives) Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels. CAC=Cumulative Amortized Cost CFVA=Cumulative Fair Value PFVA=Per Period Fair Value
18	ACCTG_REVERSAL	Character(3)	VARCHAR2(3) NOT NULL	This Field stores the Accounting Reversal Flag ISR=Is Reversed NOR=No Reversal RAE=Reverse Accounting Entry TBR=To Be Reversed
19	PARTIAL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Partial Amount in MTM
20	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
21	PA_GAIN_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Partial Amount Gain or Loss
22	MTM_GAINLOSS_BC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	MTM Gain/Loss in Base Currency
23	MTM_GAINLOSS_BC_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prior MTM Gain/Loss in Base Currency
24	PARTIAL_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Partial Amount in MTM
25	ACCTG_MTM_GL_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gain or Loss accounted in Base Currency
26	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
27	BOOK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Book Value
28	PRINCIPAL_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The notional principal balance of a given deal transaction at commencement.