PeopleSoft 9.0
Cash Management

Table Name TRX_POSITION_TR

Table Description
TRX_POSITION_TR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_CD char(1) Yes No
TR_SOURCE_ID char(12) Yes No
SEQ_NBR DECIMAL(15) Yes No
TRANSACTION_LEG SMALLINT Yes No
PERIOD_START_DT PSDATE Yes No
PERIOD_END_DT PSDATE No No
PD_INT_START_DT PSDATE No No
ASSET_LIABILITY CHAR(1) No No
POSITION_CURRENCY CHAR(3) No No
PRINCIPAL_BALANCE DECIMAL(26,3) No No
PERIOD_INT_ACCRUAL DECIMAL(26,3) No No
START_INT_ACCRUAL DECIMAL(26,3) No No
DISCOUNT_AMT DECIMAL(26,3) No No
START_DISCOUNT_AMT DECIMAL(26,3) No No
ANCHOR_CURRENCY CHAR(3) No No
ANCHOR_AMOUNT DECIMAL(26,3) 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
RESET_RATE_SET CHAR(1) No No
TRANSACTION_RATE DECIMAL(15,8) No No
RATE_RESET_DT PSDATE No No
Index
Name Type Unique Member
PS_TRX_POSITION_TR PK Yes
Member(s) of "PS_TRX_POSITION_TR" Index
BUSINESS_UNIT
TR_SOURCE_CD
TR_SOURCE_ID
SEQ_NBR
TRANSACTION_LEG
PERIOD_START_DT

Published April 30, 2007