DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_DATA_UPLOAD_INTERFACE

Object Details
Object Name: ZX_DATA_UPLOAD_INTERFACE
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_DATA_UPLOAD_INTERFACE
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_DATA_UPLOAD_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECORD_TYPE
ColumnSTATE_JURISDICTION_CODE
ColumnCOUNTY_JURISDICTION_CODE
ColumnCITY_JURISDICTION_CODE
Columns
Name Datatype Length Mandatory Comments
GEOGRAPHY_ID NUMBER (15)
Unique geography identifier for master geography
ZONE_GEOGRAPHY_ID NUMBER (15)
Unique geography identifier for tax geography
RECORD_TYPE NUMBER (2)
For internal use only
COUNTRY_CODE VARCHAR2 (3)
Code of the Country to which the Geography belongs
STATE_JURISDICTION_CODE VARCHAR2 (2)
State jurisdiction code
COUNTY_JURISDICTION_CODE VARCHAR2 (3)
County jurisdiction code
CITY_JURISDICTION_CODE VARCHAR2 (23)
City jurisdiction code
COUNTRY_STATE_ABBREVIATION VARCHAR2 (2)
Abbreviation for country or state based onw hether this record is for a country or state
GEOGRAPHY_NAME VARCHAR2 (30)
Primary Name of the geography
EFFECTIVE_FROM DATE

Effective from date
EFFECTIVE_TO DATE

Effective to date
ZIP_BEGIN VARCHAR2 (5)
Column for recording the lowest value in the zip code range
ZIP_END VARCHAR2 (5)
Column for recording the highest value in the zip code range
JURISDICTION_SERIAL_NUMBER NUMBER (1)
0 or 1 to indicate outside and inside city limits for this geography if it represents a city
MULTIPLE_PARENT_FLAG VARCHAR2 (1)
Y or N indicates whether this geography has more than one parent
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_VERSION NUMBER (5)
Column to record the file version of the third party content provider in which this record was first introduced
LAST_UPDATION_VERSION NUMBER (5)
Column to record the file version of the third party content provider in which this record was last updated
STATUS VARCHAR2 (60)
Column to indicate whether this record is to be inserted or updated
ERROR_MESSAGE VARCHAR2 (240)
Error message
CHANGE_FLAG VARCHAR2 (1)
Not currently used
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
GEO_DATA_PROVIDER VARCHAR2 (60)
Name of the data source provider
RENTAL_TAX_RATE NUMBER

Tax rate for rental tax
RENTAL_TAX_RATE_ACTIVE_FLAG VARCHAR2 (1)
Y or N indicates whether rental tax rate is active
RENTAL_TAX_AUTHORITY_LEVEL VARCHAR2 (6)
Column to store the tax authority level that identifies whether the given rental tax rate is for STATE, COUNTY or CITY
USE_TAX_RATE NUMBER

Tax rate for use tax
USE_TAX_RATE_ACTIVE_FLAG VARCHAR2 (1)
Y or N indicates whether use tax rate is active
USE_TAX_AUTHORITY_LEVEL VARCHAR2 (6)
Column to store the tax authority level that identifies whether the given use tax rate is for STATE, COUNTY or CITY
LEASE_TAX_RATE NUMBER

Tax rate for lease tax
LEASE_TAX_RATE_ACTIVE_FLAG VARCHAR2 (1)
Y or N indicates whether lease tax rate is active
LEASE_TAX_AUTHORITY_LEVEL VARCHAR2 (6)
Column to store the tax authority level that identifies whether the given lease tax rate is for STATE, COUNTY or CITY
SALES_TAX_RATE NUMBER

Tax rate for sales tax
SALES_TAX_RATE_ACTIVE_FLAG VARCHAR2 (1)
Y or N indicates whether sales tax rate is active
SALES_TAX_AUTHORITY_LEVEL VARCHAR2 (6)
Column to store the tax authority level that identifies whether the given sales tax rate is for STATE, COUNTY or CITY
PRIMARY_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GEOGRAPHY_ID
,      ZONE_GEOGRAPHY_ID
,      RECORD_TYPE
,      COUNTRY_CODE
,      STATE_JURISDICTION_CODE
,      COUNTY_JURISDICTION_CODE
,      CITY_JURISDICTION_CODE
,      COUNTRY_STATE_ABBREVIATION
,      GEOGRAPHY_NAME
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ZIP_BEGIN
,      ZIP_END
,      JURISDICTION_SERIAL_NUMBER
,      MULTIPLE_PARENT_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_VERSION
,      LAST_UPDATION_VERSION
,      STATUS
,      ERROR_MESSAGE
,      CHANGE_FLAG
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      GEO_DATA_PROVIDER
,      RENTAL_TAX_RATE
,      RENTAL_TAX_RATE_ACTIVE_FLAG
,      RENTAL_TAX_AUTHORITY_LEVEL
,      USE_TAX_RATE
,      USE_TAX_RATE_ACTIVE_FLAG
,      USE_TAX_AUTHORITY_LEVEL
,      LEASE_TAX_RATE
,      LEASE_TAX_RATE_ACTIVE_FLAG
,      LEASE_TAX_AUTHORITY_LEVEL
,      SALES_TAX_RATE
,      SALES_TAX_RATE_ACTIVE_FLAG
,      SALES_TAX_AUTHORITY_LEVEL
,      PRIMARY_FLAG
FROM ZX.ZX_DATA_UPLOAD_INTERFACE;

Dependencies

[top of page]

ZX.ZX_DATA_UPLOAD_INTERFACE does not reference any database object

ZX.ZX_DATA_UPLOAD_INTERFACE is referenced by following:

SchemaAPPS
SynonymZX_DATA_UPLOAD_INTERFACE