# DW_NS_subsidiary_D

This table contains information about subsidiaries like the subsidiary name, the calendar it uses, the currency it uses etc.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True | Internal ID |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Primary Key |  |
name | VARCHAR2 | 256 |  |  | Name |  |
fullname | VARCHAR2 | 999 |  |  | Full Name |  |
legalname | VARCHAR2 | 256 |  |  | Legal Name |  |
parent | NUMBER | 38 | 0 |  | SubSubsidiary of | DW_NS_subsidiary_D | id
country | VARCHAR2 | 16 |  |  | Country | DW_NS_Country_D | id
state | VARCHAR2 | 64 |  |  | State | DW_NS_state_D | shortname
currency | NUMBER | 38 | 0 |  | Currency | DW_NS_currency_D | id
fiscalcalendar | NUMBER | 38 | 0 |  | Fiscal Calendar | DW_NS_fiscalCalendar_D | id
federalidnumber | VARCHAR2 | 128 |  |  | Employer Identification Number (EIN) |  |
glimpactlocking | VARCHAR2 | 16 |  |  | GL Impact Locking |  |
iselimination | VARCHAR2 | 16 |  |  | Elimination |  |
isinactive | VARCHAR2 | 16 |  |  | Subsidiary is Inactive |  |
languagelocale | VARCHAR2 | 64 |  |  | Language | DW_NS_Language_D | deflocale
mainaddress | NUMBER | 38 | 0 |  | Address |  |
lastmodifieddate | TIMESTAMP |  |  |  | Last Modified Date |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.