Table Name:	currency
Table Number:	399
Group:	Policy Mgr
Description:	Defines a currency in which monetary amounts may be denominated
Flags:
Baseline/Custom:	Baseline

select * from table_currency

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	tinyint			1	DIRECT, ALLOW_NULL	Indicates whether the currency is active or not; i.e., 0=no, 1=yes, default=1
base_ind	LONG	smallint			0	DIRECT	Indicates whether the currency is the system base currency; i.e., 0=no, 1=yes, default=0	Search (1)
conv_rate	FLOAT	real			0		The current conversion rate being used for the currency. Reserved; obsolete. See curr_conv object	Search (4)
description	CHAR	varchar		255			Description of the currency	Search (4)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
iso_code	CHAR	varchar		3			ISO 4217 currency code for the currency
name	CHAR	varchar	2	20			Name of the currency	Search (22)
objid	LONG	int	3			DIRECT	Internal record number	Search (30)
sub_scale	LONG	tinyint			0	DIRECT	Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0	Search (20)
symbol	CHAR	varchar		5			Symbol for the currency; e.g., $ for US dollar	Search (10)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment
currency2campaign	OTM	campaign	campaign2currency	Campaigns denominated in the currency
currency2contract	OTM	contract	contract2currency	Contracts denominated in the currency
currency2country	OTM	country	country2currency	Countries using the currency
fm_curr2curr_conv	OTM	curr_conv	fm_curr2currency	Conversion rates for the currency
to_curr2curr_conv	OTM	curr_conv	to_curr2currency	Currency converted TO
is_pegged2currency	OTM	currency	pegged_to2currency	Currencies which are pegged to the currency for conversion purposes
pegged_to2currency	MTO	currency	is_pegged2currency	Currency which the currency is pegged to for conversion purposes
currency2entitlement	OTM	entitlement	curr_type2currency	Entitlements denominated in the currency
curr2frcst_itm	OTM	frcst_itm	frcst_itm2currency	Forecast items denominated in the currency
currency2frcst_target	OTM	frcst_target	frcst_target2currency	Forecast targets denominated in the currency
curr2opportunity	OTM	opportunity	opp2currency	Opportunities denominated in the currency
currency2price_factor	OTM	price_factor	factor2currency	Discounts and surcharges denominated in the currency
currency2price_prog	OTM	price_prog	price_prog2currency	Price programs denominated in the currency

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
name_index	name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
name_index	name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4622	fc_acct_opp_view	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
4627	fc_quote_view	bus_org, contact, contract, currency, gbst_elm, user
5034	ent_cur	currency, entitlement
5062	p_factor_view	currency, price_factor
5069	c_options	currency, mod_level, part_num, price_inst, price_prog, price_qty
5095	con_opp_view	con_opp_role, contact, currency, cycle_stage, opportunity, user
5101	c_price_srvc	currency, mod_level, part_num, price_inst, price_prog, price_qty
5109	ccn_bill_view	bus_org, condition, contr_schedule, contract, currency, site, user
5158	frtrgt_view	currency, frcst_target, territory, user
5159	frcstitem_view	currency, frcst_itm, opportunity, territory, user
5160	currency_view	country, currency
5189	v_frcstitem	currency, frcst_itm, opportunity, territory, user
5341	sfa_opp_v	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5343	sfa_quote_v	bus_org, contact, contract, currency, gbst_elm, user
5344	sfa_frcst_v	bus_org, currency, frcst_itm, opportunity, territory, user
5345	sfa_camp_v	campaign, currency, price_prog, user
5347	sfa_target	bus_org, currency, frcst_target, gbst_elm, territory, user
5357	sfa_opp_mto_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5363	sfa_pipeline	currency, gbst_elm, gbst_lst, opportunity, user
5478	sales_quote_v	bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5485	price_prog_cur_v	currency, price_prog
5597	iclient_opp_view	condition, currency, cycle_stage, opportunity, user
5742	opp_summary_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5788	price_inst_view	currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5792	offr_prod_price_v	currency, mod_level, offr_prod, part_num, price_inst, price_prog, price_qty, price_type
5799	pc_options	currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5812	offr_price_inst_view	currency, offr_price, price_inst, price_prog, price_type
5829	f_offr_price_list_v	currency, fake_base
5842	po_curr_contr_v	contract, currency, pay_means, purchase_ord
6066	contr_itm_lst_vw	contr_itm, contr_schedule, contract, currency, mod_level, part_num, price_inst, purchase_ord, site, site_part

My Recent Objects

currency

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog