ZX_CONTENT_SOURCES
This table stores Tax Content Providers
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_CONTENT_SOURCES_PK |
PROVIDER_REGIME_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROVIDER_ID | NUMBER | 18 | Yes | Party tax profile identifier for tax content provider | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROVIDER_REGIME_CODE | VARCHAR2 | 30 | Yes | Code of the regime defined by the provider corresponding to a standard regime code published by Oracle | |
| STANDARD_REGIME_CODE | VARCHAR2 | 30 | Yes | Regime code that identifies the standard regime defined by Oracle. This regime is standardized for a specific geographical area and type of tax. | |
| COUNTRY_CODE | VARCHAR2 | 30 | Yes | Country code for which this regime is applicable | |
| LOADED_FOR_GCO_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether content is loaded for global configuration owner | |
| REGIME_PURPOSE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the provider gives content or services for this regime. Possible values are CONTENT and SERVICE. This information will be used to load data for supporting a service subscription. | ||
| ENTITY_GROUP_CODE | VARCHAR2 | 30 | Lookup code to indicates the group of tax configuration entities for which this provider gives content. The data upload process uses this information to invoke loader programs for appropriate entities. | ||
| VERSION_LOADED | VARCHAR2 | 30 | Column to store the latest version of the tax content loaded at the isntallation. NULL indicates that the content for this regime has never been loaded at this installation. | ||
| POINT_RELEASE_VERSION_LOADED | VARCHAR2 | 30 | Yes | Column to store the version of the content loaded at the installation through the latest Oracle point release applied at this installation | |
| CONTENT_FILE_TYPE | VARCHAR2 | 30 | Yes | Type of the content file. Possible values are EXTERNAL_XML, INTERNAL_XML, EXCEL, LOADER | |
| CONTENT_FILE_LOCATION | VARCHAR2 | 240 | Yes | Location of the content file | |
| CONTENT_FILE_NAME | VARCHAR2 | 240 | Yes | Name of the content file | |
| PROGRAM_UPDATE_DATE | DATE | Identifies the date when the program has loaded the latest version of the content | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program name of last concurrent program to update this record | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application name of last concurrent program to update this record |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_CONTENT_SOURCES | zx_party_tax_profile | PROVIDER_ID |
| ZX_CONTENT_SOURCES | zx_regimes_b | PROVIDER_REGIME_CODE |
| ZX_CONTENT_SOURCES | zx_regimes_b | STANDARD_REGIME_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_CONTENT_SOURCES_U1 | Unique | Default | PROVIDER_REGIME_CODE |
| ZX_CONTENT_SOURCES_U2 | Unique | Default | PROVIDER_ID, STANDARD_REGIME_CODE |