PeopleSoft 9.0 Cash Management |
Table Name | TRX_INTEREST_TR |
Table Description |
TRX_INTEREST_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 | Yes |
NOMINAL_DT | PSDATE | Yes | No |
TRX_PAYMENT_TYPE | CHAR(1) | Yes | No |
TRANSACTION_LEG | SMALLINT | Yes | No |
INTEREST_DT | PSDATE | No | No |
PAYMENT_DT | PSDATE | No | No |
QUASI_COUPON_DT_SW | CHAR(1) | No | No |
RESET_RATE_SET | CHAR(1) | No | No |
TRANSACTION_RATE | DECIMAL(15,8) | No | No |
RATE_RESET_DT | PSDATE | No | No |
PRINCIPAL_BALANCE | DECIMAL(26,3) | No | No |
OVERRIDE_AMT_SW | CHAR(1) | No | No |
PAYMENT_AMT | DECIMAL(26,3) | No | No |
PRINCIPAL_PAYMENT | DECIMAL(26,3) | No | No |
INTEREST_PAYMENT | DECIMAL(26,3) | No | No |
AMORT_MTHD_FACTOR | DECIMAL(22,20) | No | No |
CURRENCY_CD | CHAR(3) | No | No |
Index |
Name | Type | Unique | Member |
PS_TRX_INTEREST_TR | PK | Yes |
![]() |
Member(s) of "PS_TRX_INTEREST_TR" Index |
BUSINESS_UNIT |
TREAS_HEADER_ID |
TRANSACTION_LINE |
NOMINAL_DT |
TRX_PAYMENT_TYPE |
TRANSACTION_LEG |
Published April 30, 2007 |