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