BUSINESS_UNITHEDGE_IDHEDGED_ITEM_SEQDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT_PO
HDG_POO_LINK(SQL Table) |
Index Back |
|---|---|
Purchase Orders Hedge Link TblA link to Purchase Orders when they are 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_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 5 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
%EDITTABLE
|