Table Name:address
Table Number:47
Group:Customer Mgr
Description:Address object, contains postal addresses
Flags: 
Baseline/Custom:Baseline
select * from table_address
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
addressCHARvarchar 200  Line 1 of address which includes street number, street name, office, building, or suite number, etc Search (29)
address_2CHARvarchar 200  Line 2 of address which typically includes office, building, or suite number, etc Search (22)
cityCHARvarchar 30  The city for the specified address Search (38)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
objidLONGint3  DIRECT Internal record number Search (32)
stateCHARvarchar 40  The state for the specified address Search (34)
update_stampCLK_TIMEdatetime46  ALLOW_NULL Date/time of last update to the address  
zipcodeCHARvarchar 20  The zip or other postal code for the specified address Search (27)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
address2addr_ba_roleOTMaddr_ba_roleaddress_role2addressBilling arrangement for the address    
address2address_extnOTOFaddress_extnaddress_extn2addressAddress book using the address    
address2bus_addr_roleOTMbus_addr_rolebus_addr_role2addressBusiness organizations associated with the address. Reserved    
bus_primary2bus_orgOTMbus_orgbus_primary2addressBusinss organizations having the address as their primary address. Reserved; not used. Get addresses via related sites    
address2caseOTMcasecase2addressAddress used in case<s>    
bill_addr2contr_itmOTMcontr_itmbill_itm2addressOrder items billed to this address    
bill_addr2contr_scheduleOTMcontr_schedulebill_addr2addressContract/quote schedules billed to this address    
ship_addr2contr_scheduleOTMcontr_scheduleship_addr2addressContract/quote schedules shipped to this address    
address2countryMTOcountrycountry2addressCountry for address   Search (32)
address2per_addr_roleOTMper_addr_roleper_addr_role2addressPersons associated with the address    
primary_addr2siteOTMsitecust_primaddr2addressSite primary address    
ship_addr2siteOTMsitecust_shipaddr2addressSite ship to address    
bill_addr2siteOTMsitecust_billaddr2addressSite bill to address    
addr2site_addr_roleOTMsite_addr_rolesite_add_role2addressSites associated with the address    
address2state_provMTOstate_provstate_prov2addressState or province for address   Search (5)
address2time_zoneMTOtime_zonetime_zone2addressTime zone where address is located   Search (6)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_address_citycity, statenonclustered located on PRIMARY
ind_address_statestatenonclustered located on PRIMARY
ind_address2countryaddress2countrynonclustered located on PRIMARY
ind_address2state_provaddress2state_provnonclustered 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
107loc_to_sub address, site
113slv_contct address, country, employee, site
289rol_contct address, bus_org, contact, contact_role, country, site, time_zone
304addrsitepmhpml address, mod_level, part_num, site, site_part
342get_child_site address, site
396appt_empl_user address, employee, site, user
407locatn_view address, inv_locatn, inv_role, site
4623fc_acct_site_view address, bus_org, bus_site_role, country, site
5031acct_site_view address, bus_site_role, country, site
5143sp_role_sp address, mod_level, part_num, prt_prt_role, site, site_part
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
5462wap_case_info address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
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
5734vw_addrsitepmhpml address, mod_level, part_num, site, site_part
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
5745sitepart_address_vw address, site, site_part, site_part_extern
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
6017schdl_tracker_sub_v1 address, appointment, employee, hgsl2hgse, site, user
6018schdl_tracker_sub_v2 address, case, disptchfe, employee, hgsl2hgse, queue, site, user, wipbin
6019schdl_tracker_sub_v3 address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6020schdl_tracker_sub_v4 address, disptchfe, employee, hgsl2hgse, queue, site, user
6021schdl_tracker_sub_v5 address, disptchfe, employee, hgsl2hgse, queue, site, user
6022schdl_tracker_sub_v6 address, appointment, employee, hgsl2hgse, site, user
6055order_shipping_vw address, contract, country, order_action, order_shipping, site
6070contact_list address, contact, contact_role, country, site
My Recent Objects
address      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user