eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ZX.ZX_EXEMPTIONS_INT

Object Details

Object Name:	ZX_EXEMPTIONS_INT
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_EXEMPTIONS_INT
Subobject Name:
Status:	VALID

Interface Table to store the Exemption Records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_EXEMPTIONS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTF_PTP_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(22)		Identifier to identify a set of records to be processed as a batch.
REQUEST_ID	NUMBER	(22)		Request identifier of last concurrent program to update this record
INTF_PTP_REFERENCE	VARCHAR2	(40)	Yes	User Identifier to associate to the corresponding Party Tax Profile
DML_TYPE	VARCHAR2	(10)	Yes	Indicates whether the record is for insert or for update.
RECORD_STATUS	NUMBER	(2)		Interface record status
ERROR_NUMBER	NUMBER	(22)		For program internal use only This column is used to store the error number whenever an error is flashed
PARTY_TAX_PROFILE_ID	NUMBER	(22)		Party tax profile identifier of the party for which this exemption applies.
PROG_INT_RECORD_REF	NUMBER	(22)		Unique identifier populated for the record in context of batch being processed by program internally for errored records.
PROG_INT_CHAR1	VARCHAR2	(2000)		For program internal use only
PROG_INT_NUM1	NUMBER	(22)		For program internal use only
TAX_EXEMPTION_ID	NUMBER	(22)		Unique identifier
EXEMPTION_TYPE_CODE	VARCHAR2	(30)		Lookup code that indicates the type of this exemption. Possible values are DISCOUNT and SPECIAL_RATE.This is the method of calculating the exemption percentage.
EXEMPTION_TYPE_NAME	VARCHAR2	(80)		Lookup Name that indicates the type of this exemption. Possible values are Discount/Surcharge and Special Rate.This is the method of calculating the exemption percentage.
EXEMPTION_STATUS_CODE	VARCHAR2	(30)		Lookup code that indicates approval status for this exemption.
EXEMPTION_STATUS_NAME	VARCHAR2	(80)		Lookup Name that indicates approval status for this exemption.
TAX_REGIME_CODE	VARCHAR2	(30)		Column to store tax regime code for this exemption.
TAX_REGIME_NAME	VARCHAR2	(80)		Column to store tax regime name for this exemption.
TAX_STATUS_CODE	VARCHAR2	(30)		Column to store tax status code for this exemption.
TAX_STATUS_NAME	VARCHAR2	(80)		Column to store tax status name for this exemption.
TAX_CODE	VARCHAR2	(30)		Column to store tax for this exemption.
TAX_NAME	VARCHAR2	(80)		Column to store tax for this exemption.
TAX_RATE_CODE	VARCHAR2	(30)		Column to store tax rate code for this exemption.
TAX_RATE_NAME	VARCHAR2	(240)		Column to store tax rate name for this exemption.
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)		Exemption certificate number. This is the certificate number that applies to this exemption and considered during tax calculation, if entered on the transaction line.
EXEMPT_REASON_CODE	VARCHAR2	(30)		Lookup code that indicates the reason for this exemption. This is the exempt reason that applies to this exemption and considered during tax calculation, if entered on the transaction line.
EXEMPT_REASON_NAME	VARCHAR2	(80)		Lookup Name that indicates the reason for this exemption. This is the exempt reason that applies to this exemption and considered during tax calculation, if entered on the transaction line.
ISSUING_TAX_AUTHORITY_ID	NUMBER	(22)		Party tax profile identifier for the tax authority that has issued the exemption certificate for this exemption
ISSUING_TAX_AUTHORITY_NAME	VARCHAR2	(360)		Party tax profile identifier for the tax authority that has issued the exemption certificate for this exemption
EFFECTIVE_FROM	DATE		Yes	Effective from date. This date should be within the date range of the entities related to this tax exemption: tax regime, tax, tax status, tax rate, and tax jurisdiction.
EFFECTIVE_TO	DATE			Effective to date. This date should be within the date range of the entities related to this tax exemption: tax regime, tax, tax status, tax rate, and tax jurisdiction.
CONTENT_OWNER_ID	NUMBER	(22)		Party tax profile identifier for configuration owner of this tax.
CONTENT_OWNER_NAME	VARCHAR2	(240)		Party tax profile identifier for configuration owner of this tax.
INVENTORY_ITEM_ID	NUMBER	(22)		Inventory Item for this exemption. This is applicable for product-specific exemption.
ITEM_NUMBER	VARCHAR2	(240)		Item number to identify the Item
INVENTORY_ORG_ID	NUMBER	(22)		Inventory organization identifier for the item. This is applicable for product-specific exemption.
INVENTORY_ORG_NAME	VARCHAR2	(240)		Inventory organization identifier for the item. This is applicable for product-specific exemption.
RATE_MODIFIER	NUMBER	(22)		Percentage of the original tax rate that is exempt if exemption type is discount. Percentage of tax rate if exemption type is special / surcharge.
TAX_JURISDICTION_ID	NUMBER	(22)		Column to store tax jurisdiction for this exemption.
TAX_JURISDICTION_NAME	VARCHAR2	(240)		Column to store tax jurisdiction for this exemption.
APPLY_TO_LOWER_LEVELS_FLAG	VARCHAR2	(1)		Y or N Indicates if this exemption is applicable to taxes at lower levels. This indicates that this exemption applies to all taxes that use this tax as the tax exemptions source.
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      INTF_PTP_REFERENCE
,      DML_TYPE
,      RECORD_STATUS
,      ERROR_NUMBER
,      PARTY_TAX_PROFILE_ID
,      PROG_INT_RECORD_REF
,      PROG_INT_CHAR1
,      PROG_INT_NUM1
,      TAX_EXEMPTION_ID
,      EXEMPTION_TYPE_CODE
,      EXEMPTION_TYPE_NAME
,      EXEMPTION_STATUS_CODE
,      EXEMPTION_STATUS_NAME
,      TAX_REGIME_CODE
,      TAX_REGIME_NAME
,      TAX_STATUS_CODE
,      TAX_STATUS_NAME
,      TAX_CODE
,      TAX_NAME
,      TAX_RATE_CODE
,      TAX_RATE_NAME
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      EXEMPT_REASON_NAME
,      ISSUING_TAX_AUTHORITY_ID
,      ISSUING_TAX_AUTHORITY_NAME
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CONTENT_OWNER_ID
,      CONTENT_OWNER_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      INVENTORY_ORG_ID
,      INVENTORY_ORG_NAME
,      RATE_MODIFIER
,      TAX_JURISDICTION_ID
,      TAX_JURISDICTION_NAME
,      APPLY_TO_LOWER_LEVELS_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM ZX.ZX_EXEMPTIONS_INT;

Dependencies

[top of page]

ZX.ZX_EXEMPTIONS_INT does not reference any database object

ZX.ZX_EXEMPTIONS_INT is referenced by following:

ZX: ZX_EXEMPTIONS_INT#