TRXAF_LN_FLD_VW (SQL View)	Index Back
Deal Approval Line View Treasury Deals - Fluid Approval - Deal Line information view.

TRXAF_LN_FLD_VW

(SQL View)

Deal Approval Line View

Treasury Deals - Fluid Approval - Deal Line information view.

SELECT L.BUSINESS_UNIT , L.TREAS_HEADER_ID , L.TRANSACTION_LINE , L.INSTRMNT_BASE_TYPE , L.SETTLEMENT_DT , L.MATURITY_DT , L.RATE_RESET_TYPE , L.TRANSACTION_RATE , L.FLOATING_MKT_CD , L.TRANSACTION_AMT , L.TRANSACT_PROCEEDS , L.TRANSACT_CURRENCY , L.INT_CALCULATION , L.AMORT_METHOD , L.REPEAT_INTERVAL , L.RATE_RESET_TYPE_2 , L.TRANSACTION_RATE_2 , L.TRANS_CURRENCY_2 , L.TRANSACTION_AMT_2 , L.FLOATING_MKT_CD_2 , L.REPEAT_INTERVAL_2 , L.OPT_PURCHASE_WRITE , L.EXCHG_CD , L.EQUITY_SYMBOL , L.NBR_OF_CONTRACTS , L.DELIVERY_YEAR , L.MONTHCD , L.QUANTITY , L.MARGIN_INITIAL_AMT , L.MARGIN_MIN_AMT , L.SETTLEMENT_CCY , L.UNIT_OF_MEASURE , L.COMMODITY_CD , L.TRANSACTION_PRICE , L.ASSET_LIABILITY , H.INSTRUMENT_TYPE , L.TRANSACT_CURRENCY , L.SETTLEMENT_CCY FROM PS_TRX_DETAIL_TR L , PS_TRX_HEADER_TR H WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.TREAS_HEADER_ID = H.TREAS_HEADER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
Prompt Table: TRX_HEADER_TR

3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

4 INSTRMNT_BASE_TYPE Character(2) VARCHAR2(2) NOT NULL Instrument base type used as a building block for Treasury deals
01=Interest Rate Physical
02=Interest Rate Swap
03=FX Deal Physical
04=Option
05=Option - Binary Payoff
06=Futures Contract
07=Commodity
08=Generic Instrument
09=Equity

5 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.

6 MATURITY_DT Date(10) DATE The maturity date for a deal transaction.

7 RATE_RESET_TYPE Character(2) VARCHAR2(2) NOT NULL Describes whether a given deal transaction is subject to a fixed or floating interest rate.
FL=Floating
FX=Fixed

8 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.

9 FLOATING_MKT_CD Character(10) VARCHAR2(10) NOT NULL The code used as a key for obtaining market rates for interest rates and futures prices.

10 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.

11 TRANSACT_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL The amount of funds that changes hands when a deal is complete.

12 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal

13 INT_CALCULATION Character(2) VARCHAR2(2) NOT NULL Interest calculation method for financial instruments.
AR=Interest Bearing
CD=Canadian Discount
DS=Straight Discount
DY=Discount to Yield

14 AMORT_METHOD Character(3) VARCHAR2(3) NOT NULL Method of Amortization
C=Constant Term
CP=Constant Payment
F=Factored
I=Index Amortizing
N=Non Amortizing
P=Fixed Paydown
S=Per Schedule

15 REPEAT_INTERVAL Character(3) VARCHAR2(3) NOT NULL Represents the form of repeating interval (days or months between each Interest payment date)
D01=Daily
D07=Weekly
D28=Every 28 Days
D35=Every 35 Days
D49=Every 49 Days
M01=Monthly
M03=Quarterly
M06=Semi-Annual
M12=Annual
M99=At Maturity

16 RATE_RESET_TYPE_2 Character(2) VARCHAR2(2) NOT NULL Describes whether a given deal transaction is subject to a fixed or floating interest rate for the sec
FL=Floating
FX=Fixed

17 TRANSACTION_RATE_2 Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for the second leg of a given deal transaction.

18 TRANS_CURRENCY_2 Character(3) VARCHAR2(3) NOT NULL "The nominal

19 TRANSACTION_AMT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal transaction amount for the second leg of a deal transacation.

20 FLOATING_MKT_CD_2 Character(10) VARCHAR2(10) NOT NULL A unique key identifier that describes a floating rate index basis associated with the second leg of a

21 REPEAT_INTERVAL_2 Character(3) VARCHAR2(3) NOT NULL Represents the form of repeating interval (days or months between each Interest payment date)
D01=Daily
D07=Weekly
D28=Every 28 Days
D35=Every 35 Days
D49=Every 49 days
M01=Monthly
M03=Quarterly
M06=Semi-Annual
M12=Annual
M99=At Maturity

22 OPT_PURCHASE_WRITE Character(1) VARCHAR2(1) NOT NULL Describes whether the dealer is purchasing or writing a given option transaction.
P=Purchase
W=Write

23 EXCHG_CD Character(6) VARCHAR2(6) NOT NULL Trading exchange code

24 EQUITY_SYMBOL Character(15) VARCHAR2(15) NOT NULL Ticker symbol to identify an equity on the exchange that it is traded on

25 NBR_OF_CONTRACTS Signed Number(18,4) DECIMAL(16,4) NOT NULL This is the number of future contracts associated with a deal

26 DELIVERY_YEAR Number(4,0) SMALLINT NOT NULL Delivery Year

27 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

28 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

29 MARGIN_INITIAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Initial margin amount for an exchange traded futures contract.

30 MARGIN_MIN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimummargin amount for an exchange traded futures contract.

31 SETTLEMENT_CCY Character(3) VARCHAR2(3) NOT NULL Settlement Currency

32 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

33 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

34 TRANSACTION_PRICE Signed Number(28,3) DECIMAL(26,3) NOT NULL The preferred business price for a given deal transaction.

35 ASSET_LIABILITY Character(1) VARCHAR2(1) NOT NULL Whether the deal transaction leg represents an asset or a liability
A=Asset
L=Liability

36 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type

37 TRANS_CURRENCY Character(3) VARCHAR2(3) NOT NULL Transaction Currency

38 UNDERLYING_CCY Character(3) VARCHAR2(3) NOT NULL Underlying Currency

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction. Prompt Table: TRX_HEADER_TR
3	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	INSTRMNT_BASE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Instrument base type used as a building block for Treasury deals 01=Interest Rate Physical 02=Interest Rate Swap 03=FX Deal Physical 04=Option 05=Option - Binary Payoff 06=Futures Contract 07=Commodity 08=Generic Instrument 09=Equity
5	SETTLEMENT_DT	Date(10)	DATE	The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
6	MATURITY_DT	Date(10)	DATE	The maturity date for a deal transaction.
7	RATE_RESET_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Describes whether a given deal transaction is subject to a fixed or floating interest rate. FL=Floating FX=Fixed
8	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.
9	FLOATING_MKT_CD	Character(10)	VARCHAR2(10) NOT NULL	The code used as a key for obtaining market rates for interest rates and futures prices.
10	TRANSACTION_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The nominal or actual deal transaction amount.
11	TRANSACT_PROCEEDS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The amount of funds that changes hands when a deal is complete.
12	TRANSACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"The nominal
13	INT_CALCULATION	Character(2)	VARCHAR2(2) NOT NULL	Interest calculation method for financial instruments. AR=Interest Bearing CD=Canadian Discount DS=Straight Discount DY=Discount to Yield
14	AMORT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Method of Amortization C=Constant Term CP=Constant Payment F=Factored I=Index Amortizing N=Non Amortizing P=Fixed Paydown S=Per Schedule
15	REPEAT_INTERVAL	Character(3)	VARCHAR2(3) NOT NULL	Represents the form of repeating interval (days or months between each Interest payment date) D01=Daily D07=Weekly D28=Every 28 Days D35=Every 35 Days D49=Every 49 Days M01=Monthly M03=Quarterly M06=Semi-Annual M12=Annual M99=At Maturity
16	RATE_RESET_TYPE_2	Character(2)	VARCHAR2(2) NOT NULL	Describes whether a given deal transaction is subject to a fixed or floating interest rate for the sec FL=Floating FX=Fixed
17	TRANSACTION_RATE_2	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for the second leg of a given deal transaction.
18	TRANS_CURRENCY_2	Character(3)	VARCHAR2(3) NOT NULL	"The nominal
19	TRANSACTION_AMT_2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The nominal transaction amount for the second leg of a deal transacation.
20	FLOATING_MKT_CD_2	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that describes a floating rate index basis associated with the second leg of a
21	REPEAT_INTERVAL_2	Character(3)	VARCHAR2(3) NOT NULL	Represents the form of repeating interval (days or months between each Interest payment date) D01=Daily D07=Weekly D28=Every 28 Days D35=Every 35 Days D49=Every 49 days M01=Monthly M03=Quarterly M06=Semi-Annual M12=Annual M99=At Maturity
22	OPT_PURCHASE_WRITE	Character(1)	VARCHAR2(1) NOT NULL	Describes whether the dealer is purchasing or writing a given option transaction. P=Purchase W=Write
23	EXCHG_CD	Character(6)	VARCHAR2(6) NOT NULL	Trading exchange code
24	EQUITY_SYMBOL	Character(15)	VARCHAR2(15) NOT NULL	Ticker symbol to identify an equity on the exchange that it is traded on
25	NBR_OF_CONTRACTS	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	This is the number of future contracts associated with a deal
26	DELIVERY_YEAR	Number(4,0)	SMALLINT NOT NULL	Delivery Year
27	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
28	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
29	MARGIN_INITIAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Initial margin amount for an exchange traded futures contract.
30	MARGIN_MIN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Minimummargin amount for an exchange traded futures contract.
31	SETTLEMENT_CCY	Character(3)	VARCHAR2(3) NOT NULL	Settlement Currency
32	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
33	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
34	TRANSACTION_PRICE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The preferred business price for a given deal transaction.
35	ASSET_LIABILITY	Character(1)	VARCHAR2(1) NOT NULL	Whether the deal transaction leg represents an asset or a liability A=Asset L=Liability
36	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type
37	TRANS_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
38	UNDERLYING_CCY	Character(3)	VARCHAR2(3) NOT NULL	Underlying Currency