HDG_SRC_ACT_TBL (SQL Table)	Index Back
Hedge Source Acctg Templ Tbl Accounting Templates for various accounting events that afflict hedged items.

HDG_SRC_ACT_TBL

(SQL Table)

Hedge Source Acctg Templ Tbl

Accounting Templates for various accounting events that afflict hedged items.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 HEDGED_ITEM_SRC Character(3) VARCHAR2(3) NOT NULL This identifies which sub-system/product contains the item being hedged.
BDF=Budgets Forecast
POO=Purchase Order
TRD=Treasury Deal
TRE=Other Hedgeable Items

3 HEDGE_TYPE_133 Character(3) VARCHAR2(3) NOT NULL Hedge type when FAS 133 is applied.
CF=Cash Flow Hedge
FV=Fair Value Hedge
XAS=FX FV of Available-for-Sale
XCF=FX Cash Flow Hedge
XFC=FX FV of Firm Commitment
XNI=FX Hedge of Net Investment

4 HDGD_ITM_FINANCIAL Character(1) VARCHAR2(1) NOT NULL Is the hedged item/transaction a Financial Asset or Liability, or a non-financial Firm Commitment with Financial components? (FAS133 paras 21(e-f) & 29(g-h))
N=Nonfinancial Item
Y=Financial Item

5 ACCTG_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting types for deal capture and hedging

6 DO_ACCOUNTING Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that treasury accounting is to be generated for transaction events associated with a deal or hedge
Y/N Table Edit
Default Value: Y

7 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: TRA_HDG_TMPL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	HEDGED_ITEM_SRC	Character(3)	VARCHAR2(3) NOT NULL	This identifies which sub-system/product contains the item being hedged. BDF=Budgets Forecast POO=Purchase Order TRD=Treasury Deal TRE=Other Hedgeable Items
3	HEDGE_TYPE_133	Character(3)	VARCHAR2(3) NOT NULL	Hedge type when FAS 133 is applied. CF=Cash Flow Hedge FV=Fair Value Hedge XAS=FX FV of Available-for-Sale XCF=FX Cash Flow Hedge XFC=FX FV of Firm Commitment XNI=FX Hedge of Net Investment
4	HDGD_ITM_FINANCIAL	Character(1)	VARCHAR2(1) NOT NULL	Is the hedged item/transaction a Financial Asset or Liability, or a non-financial Firm Commitment with Financial components? (FAS133 paras 21(e-f) & 29(g-h)) N=Nonfinancial Item Y=Financial Item
5	ACCTG_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Accounting types for deal capture and hedging
6	DO_ACCOUNTING	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that treasury accounting is to be generated for transaction events associated with a deal or hedge Y/N Table Edit Default Value: Y
7	ACCTG_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits. Prompt Table: TRA_HDG_TMPL_VW