DW_NS_Nexus_D
This table contains information about tax jurisdiction where the subsidiary have a business or taxable presence.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| country | VARCHAR2 | 16 | Country | DW_NS_Country_D | id | ||
| description | VARCHAR2 | 256 | Description | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| parentnexus | NUMBER | 38 | 0 | Parent Nexus | |||
| state | VARCHAR2 | 64 | State/Province | DW_NS_state_D | shortname | ||
| taxagency | NUMBER | 38 | 0 | Tax Agency | DW_NS_vendor_D | id | |
| taxdatefromfulfillment | VARCHAR2 | 16 | Use Fulfillment to Modify Tax Point Date |