[Home] [Help] [Dependency Information]
Object Name: | ZX_TEST_API_GT |
---|---|
Object Type: | TABLE |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
ZX.ZX_TEST_API_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$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUITE_NUMBER | VARCHAR2 | (30) | ||
CASE_NUMBER | VARCHAR2 | (30) | ||
TRX_ID | NUMBER | |||
TRX_NUMBER | VARCHAR2 | (150) | ||
TRX_LINE_NUMBER | NUMBER | |||
TRX_DATE | DATE | |||
TRX_CURRENCY_CODE | VARCHAR2 | (50) | ||
SUMMARY_TAX_LINE_ID | NUMBER | |||
TAX_LINE_ID | NUMBER | |||
TAX_REGIME_CODE | VARCHAR2 | (50) | ||
TAX_JURISDICTION_ID | NUMBER | |||
TAX | VARCHAR2 | (30) | ||
TAX_STATUS_CODE | VARCHAR2 | (100) | ||
TAX_RATE_ID | NUMBER | |||
TAX_RATE_CODE | VARCHAR2 | (100) | ||
TAX_RATE | NUMBER | |||
TAX_AMT | NUMBER | |||
TAXABLE_AMT | NUMBER | |||
REC_TAX_AMT | NUMBER | |||
NREC_TAX_AMT | NUMBER | |||
TAX_AMT_FUNCL_CURR | NUMBER | |||
TOTAL_REC_TAX_AMT | NUMBER | |||
TOTAL_NREC_TAX_AMT | NUMBER | |||
TOTAL_REC_TAX_AMT_FUNCL_CURR | NUMBER | |||
TOTAL_NREC_TAX_AMT_FUNCL_CURR | NUMBER | |||
SELF_ASSESSED_FLAG | VARCHAR2 | (1) | ||
MANUALLY_ENTERED_FLAG | VARCHAR2 | (1) | ||
LINE_AMT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | ||
TAXABLE_AMT_FUNCL_CURR | NUMBER | |||
REC_TAX_AMT_FUNCL_CURR | NUMBER | |||
NREC_TAX_AMT_FUNCL_CURR | NUMBER | |||
TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
TAX_EXEMPTION_ID | NUMBER | |||
EXEMPTION_RATE | NUMBER | |||
EXEMPT_REASON_CODE | VARCHAR2 | (100) | ||
TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | |||
TAX_REGISTRATION_NUMBER | VARCHAR2 | (50) | ||
TAX_HOLD_CODE | VARCHAR2 | (100) | ||
TAX_HOLD_RELEASED_CODE | VARCHAR2 | (100) | ||
LINE_AMT | NUMBER | |||
TAX_JURISDICTION_CODE | VARCHAR2 | (100) | ||
TAX_RATE_NAME | VARCHAR2 | (100) | ||
TAX_RATE_TYPE | VARCHAR2 | (100) | ||
TAX_DETERMINE_DATE | DATE | |||
CANCEL_FLAG | VARCHAR2 | (1) | ||
EVENT_CLASS_CODE | VARCHAR2 | (100) | ||
EVENT_TYPE_CODE | VARCHAR2 | (100) | ||
ETAX_API | VARCHAR2 | (100) | ||
ERROR_FLAG | VARCHAR2 | (1) | ||
ERROR_MESSAGE | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT SUITE_NUMBER
, CASE_NUMBER
, TRX_ID
, TRX_NUMBER
, TRX_LINE_NUMBER
, TRX_DATE
, TRX_CURRENCY_CODE
, SUMMARY_TAX_LINE_ID
, TAX_LINE_ID
, TAX_REGIME_CODE
, TAX_JURISDICTION_ID
, TAX
, TAX_STATUS_CODE
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE
, TAX_AMT
, TAXABLE_AMT
, REC_TAX_AMT
, NREC_TAX_AMT
, TAX_AMT_FUNCL_CURR
, TOTAL_REC_TAX_AMT
, TOTAL_NREC_TAX_AMT
, TOTAL_REC_TAX_AMT_FUNCL_CURR
, TOTAL_NREC_TAX_AMT_FUNCL_CURR
, SELF_ASSESSED_FLAG
, MANUALLY_ENTERED_FLAG
, LINE_AMT_INCLUDES_TAX_FLAG
, TAXABLE_AMT_FUNCL_CURR
, REC_TAX_AMT_FUNCL_CURR
, NREC_TAX_AMT_FUNCL_CURR
, TAX_AMT_INCLUDED_FLAG
, TAX_EXEMPTION_ID
, EXEMPTION_RATE
, EXEMPT_REASON_CODE
, TAX_APPORTIONMENT_LINE_NUMBER
, TAX_REGISTRATION_NUMBER
, TAX_HOLD_CODE
, TAX_HOLD_RELEASED_CODE
, LINE_AMT
, TAX_JURISDICTION_CODE
, TAX_RATE_NAME
, TAX_RATE_TYPE
, TAX_DETERMINE_DATE
, CANCEL_FLAG
, EVENT_CLASS_CODE
, EVENT_TYPE_CODE
, ETAX_API
, ERROR_FLAG
, ERROR_MESSAGE
FROM ZX.ZX_TEST_API_GT;
ZX.ZX_TEST_API_GT does not reference any database object
ZX.ZX_TEST_API_GT is referenced by following:
|
|
|