PeopleSoft 9.0 Cash Management |
Table Name | HDG_DEAL_MTM |
Table Description |
HDG_DEAL_MTM |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | CHAR(5) | Yes | Yes |
HEDGE_ID | CHAR(12) | Yes | Yes |
HEDGE_DEAL_SEQ | SMALLINT | Yes | Yes |
AS_OF_DATE | PSDATE | Yes | No |
MTM_CURRENCY | CHAR(3) | No | No |
HEDGE_DEAL_PCT | DECIMAL(6,3) | No | No |
MTM_ACCTG_VALUE_PR | DECIMAL(26,3) | No | No |
MTM_ACCTG_VALUE | DECIMAL(26,3) | No | No |
MTM_EXCL_VALUE_PR | DECIMAL(26,3) | No | No |
MTM_EXCL_VALUE | DECIMAL(26,3) | No | No |
MTM_GAINLOSS | DECIMAL(26,3) | No | No |
MTM_ASEF_VALUE_PR | DECIMAL(26,3) | No | No |
MTM_ASEF_VALUE | DECIMAL(26,3) | No | No |
MTM_ASEF_GAINLOSS | DECIMAL(26,3) | No | No |
ACTD_ASEF_GAINLOSS | DECIMAL(26,3) | No | No |
ACTD_EXCL_GAINLOSS | DECIMAL(26,3) | No | No |
ACCOUNTED_FOR | CHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_HDG_DEAL_MTM | PK | Yes |
![]() |
PSAHDG_DEAL_MTM | IE1 | No |
![]() |
Member(s) of "PS_HDG_DEAL_MTM" Index |
BUSINESS_UNIT |
HEDGE_ID |
HEDGE_DEAL_SEQ |
AS_OF_DATE |
Member(s) of "PSAHDG_DEAL_MTM" Index |
BUSINESS_UNIT |
HEDGE_ID |
HEDGE_DEAL_SEQ |
ACCOUNTED_FOR |
AS_OF_DATE |
Published April 30, 2007 |