PeopleSoft 9.0 Cash Management |
Table Name | HDG_HEDGE_DEAL |
Table Description |
HDG_HEDGE_DEAL |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | CHAR(5) | Yes | Yes |
HEDGE_ID | CHAR(12) | Yes | Yes |
HEDGE_DEAL_SEQ | SMALLINT | Yes | No |
HEDGE_DEAL_SRC | CHAR(3) | No | No |
BUSINESS_UNIT_TRX | CHAR(5) | No | No |
TREAS_HEADER_ID | CHAR(12) | No | No |
HEDGE_DEAL_PCT | DECIMAL(6,3) | No | No |
MTM_MODEL | CHAR(10) | No | No |
MTM_ACCTG_VALUE_0 | DECIMAL(26,3) | No | No |
MTM_EXCL_VALUE_0 | DECIMAL(26,3) | No | No |
MTM_ASEF_VALUE_0 | DECIMAL(26,3) | No | No |
MTM_CURRENCY | CHAR(3) | No | No |
HDG_ADDED_DT | PSDATE | No | No |
HDG_ADDED_OPRID | CHAR(30) | No | No |
HDG_REMOVED_DT | PSDATE | No | No |
HDG_REMOVED_OPRID | CHAR(30) | No | No |
Index |
Name | Type | Unique | Member |
PS_HDG_HEDGE_DEAL | PK | Yes |
![]() |
Member(s) of "PS_HDG_HEDGE_DEAL" Index |
BUSINESS_UNIT |
HEDGE_ID |
HEDGE_DEAL_SEQ |
Published April 30, 2007 |