ZX_DATA_UPLOAD_DISCARD
This is an intermediate table used by the data upload program to temporarily hold the content from third party content providers not used by Fusion Tax.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GEOGRAPHY_ID | NUMBER | 18 | Oracle internal use only. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Oracle internal use only. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Oracle internal use only. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Oracle internal use only. | ||
| ZONE_GEOGRAPHY_ID | NUMBER | 18 | Oracle internal use only. Automatically populated. | ||
| RECORD_TYPE | NUMBER | 2 | Type of rate. Valid values: 09, 10, 11, 12. 09 means sales tax. 10 means use tax. 11 means rental rate. 12 means lease rate. | ||
| COUNTRY_CODE | VARCHAR2 | 3 | Code of the country to which the geography belongs. Must use two-letter ISO code. Example: United States is US. Use the Manage Tax Geographies task to identify valid values. | ||
| STATE_JURISDICTION_CODE | VARCHAR2 | 2 | State jurisdiction code for creating concatenated jurisdiction code. Free text field. Not validated. | ||
| COUNTY_JURISDICTION_CODE | VARCHAR2 | 3 | County jurisdiction code for creating concatenated jurisdiction code. Free text field. Not validated. | ||
| CITY_JURISDICTION_CODE | VARCHAR2 | 23 | City jurisdiction code for creating concatenated jurisdiction code. Free text field. Not validated. | ||
| COUNTRY_STATE_ABBREVIATION | VARCHAR2 | 2 | Abbreviation for country or state. Free text field. Not validated. | ||
| GEOGRAPHY_NAME | VARCHAR2 | 30 | Primary name of the geography. Free text field. Not validated. | ||
| EFFECTIVE_FROM | DATE | Effective from date. Date format: YYYY/MM/DD. | |||
| EFFECTIVE_TO | DATE | Effective to date. Date format: YYYY/MM/DD. | |||
| ZIP_BEGIN | VARCHAR2 | 5 | Lowest value in the zip code range. Must be a valid zip code. Free text field. Not validated. Applies only to US tax jurisdictions. | ||
| ZIP_END | VARCHAR2 | 5 | Highest value in the zip code range. Must be a valid zip code. Free text field. Not validated. Applies only to US tax jurisdictions. | ||
| JURISDICTION_SERIAL_NUMBER | NUMBER | 1 | Indicates whether geography is inside or outside city limits. Valid values: 0, 1. 0 means outside city limits. 1 means inside city limits. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | ||
| CREATION_VERSION | NUMBER | 5 | File version of the third party content provider in which this record was first introduced. Free text field. Not validated. | ||
| LAST_UPDATION_VERSION | NUMBER | 5 | File version of the third party content provider in which this record was last updated. Free text field. Not validated. | ||
| STATUS | VARCHAR2 | 60 | Oracle internal use only. Valid values: CREATE, UPDATE, ERROR, NOCHANGE. | ||
| ERROR_MESSAGE | VARCHAR2 | 240 | Oracle internal use only. Error message. | ||
| CHANGE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| REQUEST_ID | NUMBER | 18 | Oracle Enterprise Scheduler: process identifier that created or last updated the row. For Oracle Cloud implementations: Import Tax Configuration Content. For On-Premise implementations: Upload Tax Configuration Content | ||
| GEO_DATA_PROVIDER | VARCHAR2 | 60 | Always use: Vertex. Format (upper versus lower case) determined by configuration. | ||
| RENTAL_TAX_RATE | NUMBER | Tax rate for rental tax from the content provider. Use the Manage Tax Rates task to view loaded rates. | |||
| RENTAL_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether rental tax rate is active. Valid values: Y, N. | ||
| RENTAL_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level that identifies rental tax rate. Valid values: STATE, COUNTY, CITY. | ||
| USE_TAX_RATE | NUMBER | Tax rate for use tax from the content provider. | |||
| USE_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether use tax rate is active. Valid values: Y, N. | ||
| USE_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level. Valid values: STATE, COUNTY, CITY. | ||
| LEASE_TAX_RATE | NUMBER | Tax rate for lease tax. | |||
| LEASE_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether lease tax rate is active. Valid values: Y, N. | ||
| LEASE_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level. Valid values: STATE, COUNTY, CITY. | ||
| SALES_TAX_RATE | NUMBER | Tax rate for sales tax. | |||
| SALES_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether sales tax rate is active. Valid values: Y, N. | ||
| SALES_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level. Valid values: STATE, COUNTY, CITY. | ||
| MULTIPLE_PARENT_FLAG | VARCHAR2 | 1 | Indicates whether geography has more than one parent. Valid values: Y, N. | ||
| PRIMARY_FLAG | VARCHAR2 | 1 | Check box that identifies primary geographies. Valid values: Y, N. Y is used to create geographies and jurisdictions. N is used to create geographies without jurisdictions. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Oracle internal use only. |