PeopleSoft 9.0
Cash Management

Table Name TRX_DETAIL_TR

Table Description
TRX_DETAIL_TR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TREAS_HEADER_ID CHAR(12) Yes Yes
TRANSACTION_LINE SMALLINT Yes No
INSTRMNT_BASE_TYPE CHAR(2) No No
VERSION INT No No
OPT_EXERCISE_TYPE CHAR(1) No No
OPT_EXERCISE_INTO CHAR(1) No No
OPT_LOOKBACK_TYPE CHAR(2) No No
OPT_NBR_BARRIERS CHAR(1) No No
OPT_NBR_PREMIUMS CHAR(1) No No
OPT_INT_RATE_CAP CHAR(1) No No
OPT_PURCHASE_WRITE CHAR(1) No No
OPT_PUT_CALL CHAR(1) No No
OPT_PUTCALL_DESCR CHAR(40) No No
OPT_OPTION_STATUS CHAR(1) No No
OPT_EXERCISE_DT PSDATE No No
OPT_INTO_CASH_DT PSDATE No No
OPT_STRIKE_VARIES CHAR(1) No No
OPT_DELTA DECIMAL(9,8) No No
OPT_LOOKBACK_START PSDATE No No
OPT_LOOKBACK_FREQ CHAR(1) No No
OPT_LOOKBACK_AVG CHAR(1) No No
OPT_TRANSACT_LINE SMALLINT No No
CONTINGENT_UPON CHAR(2) No No
NBR_OF_CONTRACTS DECIMAL(16,4) No No
TICK_AMT DECIMAL(26,3) No No
UNDERLYING_CCY CHAR(3) No No
SETTLEMENT_CCY CHAR(3) No No
RT_TYPE CHAR(5) No No
TICK_MIN_INTERVAL DECIMAL(10,8) No No
MARGIN_MIN_AMT DECIMAL(26,3) No No
MARGIN_INITIAL_AMT DECIMAL(26,3) No No
DELIVERY_YEAR SMALLINT No No
MONTHCD CHAR(2) No No
LAST_TRADE_DT PSDATE No No
FIRST_DELIVERY_DT PSDATE No No
FIRST_TRADE_DT PSDATE No No
LAST_DELIVERY_DT PSDATE No No
TRANSACTION_AMT DECIMAL(26,3) No No
TRANSACTION_AMT_2 DECIMAL(26,3) No No
TRANSACTION_PRICE DECIMAL(26,3) No No
TRANSACT_PROCEEDS DECIMAL(26,3) No No
PURCHASED_INTEREST DECIMAL(26,3) No No
PURCH_INT_SOURCE CHAR(1) No No
PURCH_INT_FACTOR DECIMAL(11,10) No No
PRICE_PERCENT_PAR DECIMAL(13,8) No No
PRINCIPAL_ROLL_IN DECIMAL(26,3) No No
INTEREST_ROLL_IN DECIMAL(26,3) No No
XTRA_ROLL_IN DECIMAL(26,3) No No
PRINCIPAL_ROLL_OUT DECIMAL(26,3) No No
INTEREST_ROLL_OUT DECIMAL(26,3) No No
XTRA_ROLL_OUT DECIMAL(26,3) No No
INT_ROLL_OUT_COMPD DECIMAL(26,3) No No
COMMODITY_CD CHAR(10) No No
EXCHG_CD CHAR(6) No No
UNIT_OF_MEASURE CHAR(3) No No
QUANTITY DECIMAL(15,4) No No
RT_RATE_INDEX CHAR(10) No No
COMMODITY_RT_INDEX CHAR(10) No No
EQUITY_ID CHAR(10) No No
EQUITY_SYMBOL CHAR(15) No No
TRANSACT_CURRENCY CHAR(3) No No
TRANS_CURRENCY_2 CHAR(3) No No
SWAP_PRINCIPALS CHAR(1) No No
SETTLEMENT_DT PSDATE No No
MATURITY_DT PSDATE No No
EST_MATURITY_DT PSDATE No No
ISSUE_DT PSDATE No No
INTEREST_START_DT PSDATE No No
EX_COUPON_SW CHAR(1) No No
TRANSACTION_RATE DECIMAL(15,8) No No
TRANSACTION_RATE_2 DECIMAL(15,8) No No
SPOT_RATE_MULT DECIMAL(15,8) No No
SPOT_RATE_DIV DECIMAL(15,8) No No
FORWARD_RATE_MULT DECIMAL(15,8) No No
FORWARD_RATE_DIV DECIMAL(15,8) No No
SPOT_RT_LEG1_MULT DECIMAL(15,8) No No
SPOT_RT_LEG1_DIV DECIMAL(15,8) No No
FWD_RT_LEG1_MULT DECIMAL(15,8) No No
FWD_RT_LEG1_DIV DECIMAL(15,8) No No
SPOT_RT_LEG2_MULT DECIMAL(15,8) No No
SPOT_RT_LEG2_DIV DECIMAL(15,8) No No
FWD_RT_LEG2_MULT DECIMAL(15,8) No No
FWD_RT_LEG2_DIV DECIMAL(15,8) No No
PARTIAL_AMT DECIMAL(26,3) No No
PARTIAL_AMT_2 DECIMAL(26,3) No No
TRANSACTION_YIELD DECIMAL(13,8) No No
AMORT_BEGIN_PRIN DECIMAL(26,3) No No
AMORT_END_PRIN DECIMAL(26,3) No No
AMORT_METHOD CHAR(3) No No
AMORT_BEGIN_PRIN_2 DECIMAL(26,3) No No
AMORT_END_PRIN_2 DECIMAL(26,3) No No
PERCENT_OR_AMOUNT CHAR(1) No No
PERCENT_OR_AMNT_2 CHAR(1) No No
REPEAT_INT_PERIODS CHAR(1) No No
REPEAT_INTERVAL CHAR(3) No No
REPEAT_INTERVAL_2 CHAR(3) No No
RESET_INTERVAL CHAR(3) No No
RESET_INTERVAL_2 CHAR(3) No No
RESET_INDEX_TENOR CHAR(3) No No
RESET_INDEX_TENOR2 CHAR(3) No No
COMPOUND_RESET CHAR(1) No No
COMPOUND_RESET_2 CHAR(1) No No
RATE_RESET_TYPE CHAR(2) No No
RATE_RESET_TYPE_2 CHAR(2) No No
RESET_DT_BASE CHAR(1) No No
RESET_DT_BASE_2 CHAR(1) No No
RESET_DT_OFFSET SMALLINT No No
RESET_DT_OFFSET_2 SMALLINT No No
PYMNT_DT_BASE CHAR(1) No No
PYMNT_DT_BASE_2 CHAR(1) No No
PYMNT_DT_OFFSET SMALLINT No No
PYMNT_DT_OFFSET_2 SMALLINT No No
USE_NOMINAL_DATES CHAR(1) No No
BUSINESS_DT_RULE CHAR(1) No No
INTEREST_DT_RULE CHAR(1) No No
COUPON_DAY SMALLINT No No
COUPON_WEEK SMALLINT No No
COUPON_MONTH SMALLINT No No
USE_NOMINAL_DATES2 CHAR(1) No No
BUSINESS_DT_RULE_2 CHAR(1) No No
INTEREST_DT_RULE_2 CHAR(1) No No
COUPON_DAY_2 SMALLINT No No
COUPON_WEEK_2 SMALLINT No No
COUPON_MONTH_2 SMALLINT No No
INT_BASIS CHAR(2) No No
INT_BASIS_2 CHAR(2) No No
INT_CALCULATION CHAR(2) No No
INT_CALCULATION_2 CHAR(2) No No
DAY_COUNTED_INT CHAR(1) No No
DAY_COUNTED_INT_2 CHAR(1) No No
FIRST_INT_PERIOD CHAR(1) No No
FIRST_INT_PERIOD_2 CHAR(1) No No
LAST_INT_PERIOD CHAR(1) No No
LAST_INT_PERIOD_2 CHAR(1) No No
ACCRUAL_DATE PSDATE No No
STRAIGHTLINE_DISC CHAR(1) No No
AMORTIZE_SW CHAR(1) No No
SECURITY_ID CHAR(10) No No
FLOATING_MKT_CD CHAR(10) No Yes
FLOATING_MKT_CD_2 CHAR(10) No No
YC_CODE_FUTR_CF CHAR(10) No No
YC_CODE_FUTR_CF_2 CHAR(10) No No
FLT_MARGIN_OP CHAR(1) No No
FLOATING_MARGIN DECIMAL(11,8) No No
FLT_MARGIN_OP_2 CHAR(1) No No
FLOATING_MARGIN_2 DECIMAL(11,8) No No
FLT2_MARGIN_OP CHAR(1) No No
FLOATING2_MARGIN DECIMAL(11,8) No No
FLT2_MARGIN_OP_2 CHAR(1) No No
FLOATING2_MARGIN_2 DECIMAL(11,8) No No
ASSET_LIABILITY CHAR(1) No No
ASSET_LIABILITY_2 CHAR(1) No No
ANCHOR_CURRENCY CHAR(3) No No
ANCHOR_AMOUNT DECIMAL(26,3) No No
PAY_BANK_SETID CHAR(5) No No
PAY_BANK_CD_CUST CHAR(5) No No
PAY_BANK_CD CHAR(5) No No
PAY_BANK_ACCT_KEY CHAR(4) No No
PAY_BNK_ID_NBR CHAR(20) No No
PAY_BANK_ACCT_NUM CHAR(17) No No
PAY_SETTLEMENT_ID CHAR(5) No No
PYMNT_METHOD CHAR(3) No No
FORMAT_ID CHAR(10) No No
REC_BANK_SETID CHAR(5) No No
REC_BANK_CD_CUST CHAR(5) No No
REC_BANK_CD CHAR(5) No No
REC_BANK_ACCT_KEY CHAR(4) No No
REC_BNK_ID_NBR CHAR(20) No No
REC_BANK_ACCT_NUM CHAR(17) No No
REC_SETTLEMENT_ID CHAR(5) No No
LAST_MAINT_OPRID CHAR(30) No No
LAST_MAINT_DTTM PSDATETIME No No
TR_FRA_OPTIONS CHAR(1) No No
Index
Name Type Unique Member
PS_TRX_DETAIL_TR PK Yes
Member(s) of "PS_TRX_DETAIL_TR" Index
BUSINESS_UNIT
TREAS_HEADER_ID
TRANSACTION_LINE

Published April 30, 2007