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 |