PeopleSoft 9.0 Cash Management |
Table Name | HDG_ITEM_MTM |
Table Description |
HDG_ITEM_MTM |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | CHAR(5) | Yes | Yes |
HEDGE_ID | CHAR(12) | Yes | Yes |
HEDGED_ITEM_SEQ | SMALLINT | Yes | Yes |
AS_OF_DATE | PSDATE | Yes | No |
MTM_CURRENCY | CHAR(3) | No | No |
HEDGED_ITEM_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 |
ACCOUNTED_GAINLOSS | DECIMAL(26,3) | No | No |
ACCOUNTED_FOR | CHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_HDG_ITEM_MTM | PK | Yes |
![]() |
PSAHDG_ITEM_MTM | IE1 | No |
![]() |
Member(s) of "PS_HDG_ITEM_MTM" Index |
BUSINESS_UNIT |
HEDGE_ID |
HEDGED_ITEM_SEQ |
AS_OF_DATE |
Member(s) of "PSAHDG_ITEM_MTM" Index |
BUSINESS_UNIT |
HEDGE_ID |
HEDGED_ITEM_SEQ |
ACCOUNTED_FOR |
AS_OF_DATE |
Published April 30, 2007 |