ZX_WHT_SUMMARY_LINES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZX_WHT_SUMMARY_LINES_GT_PK |
SUMMARY_TAX_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUMMARY_TAX_LINE_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| CANCEL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| CHECKRUN_ID | NUMBER | 18 | Oracle internal use only. | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| GL_DATE | DATE | Oracle internal use only. | |||
| INTERNAL_ORGANIZATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| LEDGER_ID | NUMBER | 18 | Oracle internal use only. | ||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| PAYMENT_DATE | DATE | Oracle internal use only. | |||
| PAYMENT_ID | NUMBER | 18 | Oracle internal use only. | ||
| PERIOD_NAME | VARCHAR2 | 10 | Oracle internal use only. | ||
| SUMMARY_TAX_LINE_NUMBER | NUMBER | 18 | Yes | Oracle internal use only. | |
| TAX | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TAX_AMT | NUMBER | Oracle internal use only. | |||
| TAX_AMT_FUNCL_CURR | NUMBER | Oracle internal use only. | |||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_JURISDICTION_ID | NUMBER | 18 | Oracle internal use only. | ||
| TAX_RATE | NUMBER | Oracle internal use only. | |||
| TAX_RATE_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TAX_RATE_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TAX_STATUS_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TRX_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| PAYMENT_NUMBER | NUMBER | 18 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_WHT_SUMMARY_LINES_GT_U1 | Unique | SUMMARY_TAX_LINE_ID |