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
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
activeLONGtinyint  1 DIRECT, ALLOW_NULL Indicates whether the currency is active or not; i.e., 0=no, 1=yes, default=1  
base_indLONGsmallint  0 DIRECT Indicates whether the currency is the system base currency; i.e., 0=no, 1=yes, default=0 Search (1)
conv_rateFLOATreal  0  The current conversion rate being used for the currency. Reserved; obsolete. See curr_conv object Search (4)
descriptionCHARvarchar 255  Description of the currency Search (4)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
iso_codeCHARvarchar 3  ISO 4217 currency code for the currency  
nameCHARvarchar220  Name of the currency Search (22)
objidLONGint3  DIRECT Internal record number Search (30)
sub_scaleLONGtinyint  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)
symbolCHARvarchar 5  Symbol for the currency; e.g., $ for US dollar Search (10)
Relations:
Relation
Type
Target Object
Inverse Relation
Comment
Flags
MTM Table
Used in Views
currency2campaignOTMcampaigncampaign2currencyCampaigns denominated in the currency    
currency2contractOTMcontractcontract2currencyContracts denominated in the currency    
currency2countryOTMcountrycountry2currencyCountries using the currency    
fm_curr2curr_convOTMcurr_convfm_curr2currencyConversion rates for the currency    
to_curr2curr_convOTMcurr_convto_curr2currencyCurrency converted TO    
is_pegged2currencyOTMcurrencypegged_to2currencyCurrencies which are pegged to the currency for conversion purposes    
pegged_to2currencyMTOcurrencyis_pegged2currencyCurrency which the currency is pegged to for conversion purposes    
currency2entitlementOTMentitlementcurr_type2currencyEntitlements denominated in the currency    
curr2frcst_itmOTMfrcst_itmfrcst_itm2currencyForecast items denominated in the currency    
currency2frcst_targetOTMfrcst_targetfrcst_target2currencyForecast targets denominated in the currency    
curr2opportunityOTMopportunityopp2currencyOpportunities denominated in the currency    
currency2price_factorOTMprice_factorfactor2currencyDiscounts and surcharges denominated in the currency    
currency2price_progOTMprice_progprice_prog2currencyPrice programs denominated in the currency    
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
name_indexnameUNIQUE 
Indexes (Defined in Database):
Index Name
Fields
Additional Information
name_indexnamenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
4622fc_acct_opp_view bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
4627fc_quote_view bus_org, contact, contract, currency, gbst_elm, user
5034ent_cur currency, entitlement
5062p_factor_view currency, price_factor
5069c_options currency, mod_level, part_num, price_inst, price_prog, price_qty
5095con_opp_view con_opp_role, contact, currency, cycle_stage, opportunity, user
5101c_price_srvc currency, mod_level, part_num, price_inst, price_prog, price_qty
5109ccn_bill_view bus_org, condition, contr_schedule, contract, currency, site, user
5158frtrgt_view currency, frcst_target, territory, user
5159frcstitem_view currency, frcst_itm, opportunity, territory, user
5160currency_view country, currency
5189v_frcstitem currency, frcst_itm, opportunity, territory, user
5341sfa_opp_v bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5343sfa_quote_v bus_org, contact, contract, currency, gbst_elm, user
5344sfa_frcst_v bus_org, currency, frcst_itm, opportunity, territory, user
5345sfa_camp_v campaign, currency, price_prog, user
5347sfa_target bus_org, currency, frcst_target, gbst_elm, territory, user
5357sfa_opp_mto_v currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5363sfa_pipeline currency, gbst_elm, gbst_lst, opportunity, user
5478sales_quote_v bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5485price_prog_cur_v currency, price_prog
5597iclient_opp_view condition, currency, cycle_stage, opportunity, user
5742opp_summary_v currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5788price_inst_view currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5792offr_prod_price_v currency, mod_level, offr_prod, part_num, price_inst, price_prog, price_qty, price_type
5799pc_options currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5812offr_price_inst_view currency, offr_price, price_inst, price_prog, price_type
5829f_offr_price_list_v currency, fake_base
5842po_curr_contr_v contract, currency, pay_means, purchase_ord
6066contr_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