BUSINESS_UNITHEDGE_IDHEDGED_ITEM_SEQDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT_TRX
HDG_TRD_LINK(SQL Table) |
Index Back |
|---|---|
Treasury Deals Hedge Link TblA link to Treasury Deals when a Deal is the hedged item. Used on HDG_HEDGED_ITEM panel. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | HEDGE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items |
| 3 | HEDGED_ITEM_SEQ |
Number(4,0) | SMALLINT NOT NULL | Sequence number of the hedged item. this allows mulitple items to be designated as hedged items. |
| 4 | BUSINESS_UNIT_TRX | Character(5) | VARCHAR2(5) NOT NULL |
The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW |
| 5 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Prompt Table:
%EDITTABLE
|
| 6 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Instrument type |