Subsidiaries

The Other > Subsidiary custom field is available for the Subsidiaries table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
address	VARCHAR2	999					Subsidiary address
address1	VARCHAR2	150					Address line 1
address2	VARCHAR2	150					Address line 2
base_currency_id	NUMBER		22	0			Base currency ID
city	VARCHAR2	50					City
country	VARCHAR2	2					Country
date_last_modified	TIMESTAMP						Date last modified (GMT)
edition	VARCHAR2	20					NetSuite edition
federal_number	VARCHAR2	40					Federal tax ID
fiscal_calendar_id	NUMBER		22	0			Fiscal calendar ID
full_name	VARCHAR2	1791					Full name
is_elimination	VARCHAR2	3					Whether elimination subsidiary
is_moss	VARCHAR2	3					Whether the subsidiary uses the MOSS taxation scheme
isinactive	VARCHAR2	3					Subsidiary is inactive
legal_name	VARCHAR2	83					Legal name
moss_nexus_id	NUMBER		22	0			ID of the nexus that uses the MOSS taxation scheme
name	VARCHAR2	83					Name
parent_id	NUMBER		22	0			Parent subsidiary ID
purchaseorderamount	NUMBER		20	2			Purchase order amount
purchaseorderquantity	NUMBER		18	8			Purchase order quantity
purchaseorderquantitydiff	NUMBER		18	8			Purchase order quantity difference
receiptamount	NUMBER		20	2			Receipt amount
receiptquantity	NUMBER		18	8			Receipt quantity
receiptquantitydiff	NUMBER		18	8			Receipt quantity difference
return_address	VARCHAR2	999					Return address
return_address1	VARCHAR2	150					Return address line 1
return_address2	VARCHAR2	150					Return address line 2
return_city	VARCHAR2	50					Return address city
return_country	VARCHAR2	50					Return address country
return_state	VARCHAR2	50					Return address state
return_zipcode	VARCHAR2	36					Return address postal code
shipping_address	VARCHAR2	999					Shipping address
shipping_address1	VARCHAR2	150					Shipping address line 1
shipping_address2	VARCHAR2	150					Shipping address line 2
shipping_city	VARCHAR2	50					Shipping address city
shipping_country	VARCHAR2	50					Shipping address country
shipping_state	VARCHAR2	50					Shipping address state
shipping_zipcode	VARCHAR2	36					Shipping address postal code
state	VARCHAR2	20					Subsidiary state
state_tax_number	VARCHAR2	40					State tax ID
subsidiary_extid	VARCHAR2	255					Subsidiary external ID
subsidiary_id	NUMBER		22	0			Subsidiary ID
tran_num_prefix	VARCHAR2	8					Transaction number prefix
url	VARCHAR2	64					URL
zipcode	VARCHAR2	36					Subsidiary postal code

Primary key

PK Column Name
subsidiary_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Account_activity_subsidiaries_fk	subsidiary_id	Account_activity	subsidiary_id	1
Account_period_activity_subsidiaries_fk	subsidiary_id	Account_period_activity	subsidiary_id	1
Companies_subsidiaries_fk	subsidiary_id	Companies	subsidiary	1
Consolidated_exchange_rates_from_subsidiaries_fk	subsidiary_id	Consolidated_exchange_rates	from_subsidiary_id	1
Consolidated_exchange_rates_to_subsidiaries_fk	subsidiary_id	Consolidated_exchange_rates	to_subsidiary_id	1
Customers_subsidiaries_fk	subsidiary_id	Customers	subsidiary_id	1
Customers_subsidiaries_fk_2	subsidiary_id	Customers	represents_subsidiary_id	1
Employees_subsidiaries_fk	subsidiary_id	Employees	subsidiary_id	1
Global_account_map_subsidiaries_fk	subsidiary_id	Global_account_map	subsidiary_id	1
Item_account_map_subsidiaries_fk	subsidiary_id	Item_account_map	subsidiary_id	1
Item_subsidiary_map_subsidiaries_fk	subsidiary_id	Item_subsidiary_map	subsidiary_id	1
Opportunity_lines_subsidiaries_fk	subsidiary_id	Opportunity_lines	subsidiary_id	1
Partners_subsidiaries_fk	subsidiary_id	Partners	subsidiary	1
Posting_account_activity_subsidiaries_fk	subsidiary_id	Posting_account_activity	subsidiary_id	1
Role_subsidiary_map_subsidiaries_fk	subsidiary_id	Role_subsidiary_map	subsidiary_id	1
Subsidiary_class_map_subsidiaries_fk	subsidiary_id	Subsidiary_class_map	subsidiary_id	1
Subsidiary_department_map_subsidiaries_fk	subsidiary_id	Subsidiary_department_map	subsidiary_id	1
Subsidiary_location_map_subsidiaries_fk	subsidiary_id	Subsidiary_location_map	subsidiary_id	1
Support_incidents_subsidiaries_fk	subsidiary_id	Support_incidents	subsidiary_id	1
Vendor_subsidiary_map_subsidiaries_fk	subsidiary_id	Vendor_subsidiary_map	subsidiary_id	1
Vendors_subsidiaries_fk	subsidiary_id	Vendors	subsidiary	1
Vendors_subsidiaries_fk_2	subsidiary_id	Vendors	represents_subsidiary_id	1

This table is included in the following domains

Domains
Multibooks

Domain diagrams