ZX_JURISDICTIONS_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Comments
TAX_JURISDICTION_ID NUMBER 18 Tax jurisdiction identifier
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code
TAX_REGIME_CODE VARCHAR2 30 Tax regime code
TAX VARCHAR2 30 Tax
PRECEDENCE_LEVEL NUMBER Precedence level used for selecting this jurisdiction when multiple jurisdictions are found applicable during tax calculation for a transaction

Indexes

Index Uniqueness Columns
ZX_JURISDICTIONS_GT_U1 Unique TAX_REGIME_CODE, TAX, TAX_JURISDICTION_CODE