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