Table Name:country
Table Number:124
Group:Customer Mgr
Description:Country object which defines each country
Flags: 
Baseline/Custom:Baseline
select * from table_country
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
codeLONGint   DIRECT Country code used in telephone numbers for that country Search (24)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
is_defaultLONGint22 0 DIRECT Indicates that this is the default country; i.e., 0=no, 1=yes Search (1)
nameCHARvarchar240  Name of the specific country Search (24)
objidLONGint3  DIRECT Internal record number Search (24)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
country2addressOTMaddressaddress2countryAddresses that belong to the country    
country2currencyMTOcurrencycurrency2countryCurrency used by the country   Search (1)
country2demand_hdrOTMdemand_hdrship_info2countryPart request headers addressed to the country    
country2state_provOTMstate_provstate_prov2countryStates or provices which belong to the country    
country2time_zoneMTMtime_zonetime_zone2countryTime zones which are related to the country  mtm_country1_
time_zone0		 
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
name_indexnameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
name_indexnamenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
55empl_user address, country, employee, site, user
71tr_filter_view address, case, country, site, trans_record
88site_view address, bus_org, country, site
113slv_contct address, country, employee, site
289rol_contct address, bus_org, contact, contact_role, country, site, time_zone
4623fc_acct_site_view address, bus_org, bus_site_role, country, site
5031acct_site_view address, bus_site_role, country, site
5160currency_view country, currency
5186state_view country, state_prov
5193contrconsite address, contact, contact_role, contract, country, site
5340sfaacctsite address, bus_org, bus_site_role, country, site
5374cnt_weblst address, contact, contact_role, country, site, web_user
5375cnt_lst address, contact, contact_role, country, site
5430N_Users address, country, employee, user
5463contact_web address, contact, contact_role, country, site, web_user
5475role_contact address, bus_org, contact, contact_role, country, site
5482acct_sites_view address, bus_org, bus_site_role, country, site
5550site_view_zone address, bus_org, country, site, time_zone
5647site_view2 address, bus_org, country, site
5663address_view address, country, time_zone
5690site_view_more address, bus_org, country, site, time_zone
5707sfa_site_dtl_vw address, bus_org, bus_site_role, country, site, time_zone
5713busorg_site_addr_vw address, bus_org, bus_org_extern, country, site, state_prov
5714blg_argmnt_addr_vw addr_ba_role, address, blg_argmnt, bus_org, bus_org_extern, country, state_prov
5719vw_addr_blg_argmnt addr_ba_role, address, blg_argmnt, blg_argmnt_extern, country, state_prov
5739case_overview address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5740case_more_info address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5747prmry_busorg_site_addr address, bus_org, bus_org_extern, country, site, state_prov
5795site_contact_view address, contact, contact_role, country, site
5796order_shipping_view address, contact, contract, country, order_action, order_shipping, site
5828bar_rel_prim_addr_v address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone
5850fc_rol_contct address, bus_org, contact, contact_role, country, rollup, site
6055order_shipping_vw address, contract, country, order_action, order_shipping, site
6070contact_list address, contact, contact_role, country, site
My Recent Objects
country      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user