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
