PeopleSoft 9.0
Cash Management

Table Name HDG_HEDGED_ITEM

Table Description
HDG_HEDGED_ITEM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
HEDGE_ID CHAR(12) Yes Yes
HEDGED_ITEM_SEQ SMALLINT Yes No
HEDGED_ITEM_SRC CHAR(3) No No
HDGD_ITM_FINANCIAL CHAR(1) No No
HEDGED_ITEM_PRTION CHAR(3) No No
HEDGED_ITEM_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_CURRENCY CHAR(3) No No
AMORT_CARRYAMT_ADJ CHAR(1) No No
AMORT_BEGIN_DT PSDATE No No
AMORT_END_DT PSDATE No No
HDGD_ITEM_BEGIN_DT PSDATE No No
HDGD_ITEM_END_DT PSDATE No No
HDGD_ITEM_AMT DECIMAL(26,3) No No
HDGD_ITEM_AMT_CCY CHAR(3) No No
HDGD_ITEM_QUANTITY DECIMAL(15,4) No No
HDGD_ITEM_UOM CHAR(3) No No
HDGD_ITEM_QTY_CCY CHAR(3) No No
HDGD_ITEM_DETAILS CHAR(254) 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_HEDGED_ITEM PK Yes
Member(s) of "PS_HDG_HEDGED_ITEM" Index
BUSINESS_UNIT
HEDGE_ID
HEDGED_ITEM_SEQ

Published April 30, 2007