cmn_location table

[tiagomacul]

cmn_location table

TypeSort	ReferenceSort	Max lengthSort	Default valueSort	DisplaySort
City	city	String		40		false
Company	company	Reference	Company	32		false
Contact	contact	Reference	User	32		false
Country	country	String		40		false
Fax phone	fax_phone	String		40		false
Full name	full_name	String		255		false
Latitude	latitude	Floating Point Number		40		false
Lat long error	lat_long_error	String		1,000		false
Longitude	longitude	Floating Point Number		40		false
Name	name	String		100		true
Parent	parent	Reference	Location	32		false
Phone	phone	String		40		false
Phone territory	phone_territory	Reference	Sys Phone Territory	32		false
State / Province	state	String		40		false
Stock room	stock_room	True/False		40	false	false
Street	street	Two Line Text Area		255		false
Created by	sys_created_by	String		40		false
Created	sys_created_on	Date/Time		40		false
Sys ID	sys_id	Sys ID (GUID)		32		false
Updates	sys_mod_count	Integer		40		false
Updated by	sys_updated_by	String		40		false
Updated	sys_updated_on	Date/Time		40		false
Time zone	time_zone	String		40		false
Address ID	u_address_id	Reference	Service Address	32		false
For Asset?	u_for_asset	True/False		40	false	false
Location Description	u_location_description	String (Full UTF-8)		4,000		false
State/Province Description	u_state_province_description	String (Full UTF-8)		255		false
Zip / Postal Code	zip	String		40		false

.

referencing in hundreds tables

Referenced tables

Principais tabelas