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