Locations

The Other > Location custom field is available for the Locations table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
address	VARCHAR2	999					Address
address_one	VARCHAR2	150					Address one
address_three	VARCHAR2	150					Address three
address_two	VARCHAR2	150					Address two
addressee	VARCHAR2	100					Addressee
attention	VARCHAR2	150					Attention
city	VARCHAR2	50					City
country	VARCHAR2	50					Country
date_last_modified	TIMESTAMP						Date last modified
full_name	VARCHAR2	4000					Full name
inventory_available	VARCHAR2	3					Inventory is available
inventory_available_web_store	VARCHAR2	3					Inventory is available in web store
is_include_in_supply_planning	VARCHAR2	3					Whether is included in supply planning
isinactive	VARCHAR2	3					Location is inactive
location_extid	VARCHAR2	255					Location external ID
location_id	NUMBER		39	0			Location ID
name	VARCHAR2	60					Name
parent_id	NUMBER		39	0	location_id	Locations	Sublocation of
phone	VARCHAR2	100					Phone
return_address_one	VARCHAR2	150					Return address one
return_address_two	VARCHAR2	150					Return address two
return_city	VARCHAR2	50					Return city
return_country	VARCHAR2	50					Return country
return_state	VARCHAR2	50					Return state
return_zipcode	VARCHAR2	36					Return zip code
returnaddress	VARCHAR2	999					Return address
state	VARCHAR2	50					State
tran_num_prefix	VARCHAR2	8					Transaction number prefix
use_bins	VARCHAR2	3					Use bins
zipcode	VARCHAR2	36					Zip code

Primary key

PK Column Name
location_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
locations_locations_fk	parent_id	Locations	location_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Accounts_locations_fk	location_id	Accounts	location_id	1
Billing_subscription_lines_locations_fk	location_id	Billing_subscription_lines	location_id	1
Billing_subscriptions_locations_fk	location_id	Billing_subscriptions	location_id	1
Budget_locations_fk	location_id	Budget	location_id	1
Employee_time_locations_fk	location_id	Employee_time	location_id	1
Employees_locations_fk	location_id	Employees	location_id	1
Global_account_map_locations_fk	location_id	Global_account_map	location_id	1
Item_account_map_locations_fk	location_id	Item_account_map	location_id	1
Location_costing_grp_locations_locations_fk	location_id	Location_costing_grp_locations	location_id	1
Locations_locations_fk	location_id	Locations	parent_id	1
Opportunity_lines_locations_fk	location_id	Opportunity_lines	location_id	1
Planned_standard_costs_locations_fk	location_id	Planned_standard_costs	location_id	1
Posting_account_activity_locations_fk	location_id	Posting_account_activity	location_id	1
Posting_account_activity_pe_locations_fk	location_id	Posting_account_activity_pe	location_id	1
Subscription_plans_locations_fk	location_id	Subscription_plans	location_id	1
Subsidiary_location_map_locations_fk	location_id	Subsidiary_location_map	location_id	1

This table is included in the following domains

Domains
Expense_amortization
Invoice_with_amortization
Multibooks

Domain diagrams