[Home] [Help] [Dependency Information]
Object Name: | ZX_IMPORT_TAX_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_IMPORT_TAX_LINES_GT |
Subobject Name: | |
Status: | VALID |
ZX.ZX_IMPORT_TAX_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_IMPORT_TAX_LINES_GT_U1 | NORMAL | UNIQUE |
APPLICATION_ID
ENTITY_CODE EVENT_CLASS_CODE TRX_ID SUMMARY_TAX_LINE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_TAX_LINE_NUMBER | NUMBER | Yes | Line number to uniquely identify this imported tax line | |
INTERNAL_ORGANIZATION_ID | NUMBER | Yes | Internal organization identifier of the imported transaction | |
APPLICATION_ID | NUMBER | Yes | Application Identifier of the imported transaction | |
ENTITY_CODE | VARCHAR2 | (30) | Yes | Entity code of the application event class for the imported transaction |
EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | Application event class of the imported transaction |
TRX_ID | NUMBER | Primary transaction identifier for the imported transaction | ||
HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | First component of the user composite key to uniquely identify the imported transaction | |
HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | Second component of the user composite key to uniquely identify the imported transaction | |
HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | Third component of the user composite key to uniquely identify the imported transaction | |
HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | Fourth component of the user composite key to uniquely identify the imported transaction | |
HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | Fifth component of the user composite key to uniquely identify the imported transaction | |
HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | Sixth component of the user composite key to uniquely identify the imported transaction | |
TAX_REGIME_CODE | VARCHAR2 | (30) | Tax regime code for this tax line | |
TAX | VARCHAR2 | (30) | Tax for this tax line | |
TAX_STATUS_CODE | VARCHAR2 | (30) | Tax status code for this tax line | |
TAX_RATE_CODE | VARCHAR2 | (50) | Tax rate code for this tax line | |
TAX_RATE | NUMBER | Tax rate for this tax line | ||
TAX_AMT | NUMBER | Tax amount for this tax line | ||
TAX_JURISDICTION_CODE | VARCHAR2 | (30) | Tax jurisdiction code for this tax line | |
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | Y or N indicates whether this tax line is inclusive | |
TAX_RATE_ID | NUMBER | (15) | Tax rate identifier for this tax line | |
TAX_PROVIDER_ID | NUMBER | (15) | Party tax profile identifier for the third party service provider for the regime of this tax line | |
TAX_EXCEPTION_ID | NUMBER | Tax exception identifier for this tax line | ||
TAX_EXEMPTION_ID | NUMBER | Tax exemption identifier for this tax line | ||
EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exemption reason code | |
EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | Tax exemption certificate number | |
TAX_LINE_ALLOCATION_FLAG | VARCHAR2 | (1) | Y or N indicates whether ZX_TRX_TAX_LINK_GT contains allocations of this imported tax line to multiple transaction lines | |
INTERFACE_ENTITY_CODE | VARCHAR2 | (30) | Column to temporarily store entity code of the tax line interface table | |
INTERFACE_TAX_LINE_ID | NUMBER | Column to temporarily store identifier of the interface line corresponding to this tax line during import of transactions into Receivables | ||
TRX_LINE_ID | NUMBER | Transaction line identifier for the imported transaction line to which this tax line is fully allocated; NULL if this tax line is allocated to more than one transaction line or is not allocated to any transaciton line | ||
TAX_DATE | DATE | |||
SUBSCRIPTION_DATE | DATE | |||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT SUMMARY_TAX_LINE_NUMBER
, INTERNAL_ORGANIZATION_ID
, APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, TRX_ID
, HDR_TRX_USER_KEY1
, HDR_TRX_USER_KEY2
, HDR_TRX_USER_KEY3
, HDR_TRX_USER_KEY4
, HDR_TRX_USER_KEY5
, HDR_TRX_USER_KEY6
, TAX_REGIME_CODE
, TAX
, TAX_STATUS_CODE
, TAX_RATE_CODE
, TAX_RATE
, TAX_AMT
, TAX_JURISDICTION_CODE
, TAX_AMT_INCLUDED_FLAG
, TAX_RATE_ID
, TAX_PROVIDER_ID
, TAX_EXCEPTION_ID
, TAX_EXEMPTION_ID
, EXEMPT_REASON_CODE
, EXEMPT_CERTIFICATE_NUMBER
, TAX_LINE_ALLOCATION_FLAG
, INTERFACE_ENTITY_CODE
, INTERFACE_TAX_LINE_ID
, TRX_LINE_ID
, TAX_DATE
, SUBSCRIPTION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE3
FROM ZX.ZX_IMPORT_TAX_LINES_GT;
ZX.ZX_IMPORT_TAX_LINES_GT does not reference any database object
ZX.ZX_IMPORT_TAX_LINES_GT is referenced by following:
|
|
|