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 |