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 |