VIEW: ZX.ZX_REGIMES_B#

Source

View Text - Preformatted

select TAX_REGIME_CODE TAX_REGIME_CODE, PARENT_REGIME_CODE PARENT_REGIME_CODE, HAS_SUB_REGIME_FLAG HAS_SUB_REGIME_FLAG, COUNTRY_OR_GROUP_CODE COUNTRY_OR_GROUP_CODE, COUNTRY_CODE COUNTRY_CODE, GEOGRAPHY_TYPE GEOGRAPHY_TYPE, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, THRSHLD_GROUPING_LVL_CODE THRSHLD_GROUPING_LVL_CODE, ROUNDING_RULE_CODE ROUNDING_RULE_CODE, TAX_PRECISION TAX_PRECISION, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, TAX_STATUS_RULE_FLAG TAX_STATUS_RULE_FLAG, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE, APPLICABILITY_RULE_FLAG APPLICABILITY_RULE_FLAG, PLACE_OF_SUPPLY_RULE_FLAG PLACE_OF_SUPPLY_RULE_FLAG, TAX_CALC_RULE_FLAG TAX_CALC_RULE_FLAG, TAXABLE_BASIS_THRSHLD_FLAG TAXABLE_BASIS_THRSHLD_FLAG, TAX_RATE_THRSHLD_FLAG TAX_RATE_THRSHLD_FLAG, TAX_AMT_THRSHLD_FLAG TAX_AMT_THRSHLD_FLAG, TAX_RATE_RULE_FLAG TAX_RATE_RULE_FLAG, TAXABLE_BASIS_RULE_FLAG TAXABLE_BASIS_RULE_FLAG, DEF_INCLUSIVE_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG, HAS_OTHER_JURISDICTIONS_FLAG HAS_OTHER_JURISDICTIONS_FLAG, ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG, ALLOW_RECOVERABILITY_FLAG ALLOW_RECOVERABILITY_FLAG, AUTO_PRVN_FLAG AUTO_PRVN_FLAG, HAS_TAX_DET_DATE_RULE_FLAG HAS_TAX_DET_DATE_RULE_FLAG, HAS_EXCH_RATE_DATE_RULE_FLAG HAS_EXCH_RATE_DATE_RULE_FLAG, HAS_TAX_POINT_DATE_RULE_FLAG HAS_TAX_POINT_DATE_RULE_FLAG, USE_LEGAL_MSG_FLAG USE_LEGAL_MSG_FLAG, REGN_NUM_SAME_AS_LE_FLAG REGN_NUM_SAME_AS_LE_FLAG, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, RECORD_TYPE_CODE RECORD_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, DEF_REGISTR_PARTY_TYPE_CODE DEF_REGISTR_PARTY_TYPE_CODE, REGISTRATION_TYPE_RULE_FLAG REGISTRATION_TYPE_RULE_FLAG, TAX_INCLUSIVE_OVERRIDE_FLAG TAX_INCLUSIVE_OVERRIDE_FLAG, REGIME_PRECEDENCE REGIME_PRECEDENCE, CROSS_REGIME_COMPOUNDING_FLAG CROSS_REGIME_COMPOUNDING_FLAG, TAX_REGIME_ID TAX_REGIME_ID, GEOGRAPHY_ID GEOGRAPHY_ID, THRSHLD_CHK_TMPLT_CODE THRSHLD_CHK_TMPLT_CODE, PERIOD_SET_NAME PERIOD_SET_NAME, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID, TAX_ACCOUNT_PRECEDENCE_CODE TAX_ACCOUNT_PRECEDENCE_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "ZX"."ZX_REGIMES_B"

View Text - HTML Formatted

SELECT TAX_REGIME_CODE TAX_REGIME_CODE
, PARENT_REGIME_CODE PARENT_REGIME_CODE
, HAS_SUB_REGIME_FLAG HAS_SUB_REGIME_FLAG
, COUNTRY_OR_GROUP_CODE COUNTRY_OR_GROUP_CODE
, COUNTRY_CODE COUNTRY_CODE
, GEOGRAPHY_TYPE GEOGRAPHY_TYPE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, THRSHLD_GROUPING_LVL_CODE THRSHLD_GROUPING_LVL_CODE
, ROUNDING_RULE_CODE ROUNDING_RULE_CODE
, TAX_PRECISION TAX_PRECISION
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, TAX_STATUS_RULE_FLAG TAX_STATUS_RULE_FLAG
, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE
, APPLICABILITY_RULE_FLAG APPLICABILITY_RULE_FLAG
, PLACE_OF_SUPPLY_RULE_FLAG PLACE_OF_SUPPLY_RULE_FLAG
, TAX_CALC_RULE_FLAG TAX_CALC_RULE_FLAG
, TAXABLE_BASIS_THRSHLD_FLAG TAXABLE_BASIS_THRSHLD_FLAG
, TAX_RATE_THRSHLD_FLAG TAX_RATE_THRSHLD_FLAG
, TAX_AMT_THRSHLD_FLAG TAX_AMT_THRSHLD_FLAG
, TAX_RATE_RULE_FLAG TAX_RATE_RULE_FLAG
, TAXABLE_BASIS_RULE_FLAG TAXABLE_BASIS_RULE_FLAG
, DEF_INCLUSIVE_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG
, HAS_OTHER_JURISDICTIONS_FLAG HAS_OTHER_JURISDICTIONS_FLAG
, ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG
, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG
, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG
, ALLOW_RECOVERABILITY_FLAG ALLOW_RECOVERABILITY_FLAG
, AUTO_PRVN_FLAG AUTO_PRVN_FLAG
, HAS_TAX_DET_DATE_RULE_FLAG HAS_TAX_DET_DATE_RULE_FLAG
, HAS_EXCH_RATE_DATE_RULE_FLAG HAS_EXCH_RATE_DATE_RULE_FLAG
, HAS_TAX_POINT_DATE_RULE_FLAG HAS_TAX_POINT_DATE_RULE_FLAG
, USE_LEGAL_MSG_FLAG USE_LEGAL_MSG_FLAG
, REGN_NUM_SAME_AS_LE_FLAG REGN_NUM_SAME_AS_LE_FLAG
, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DEF_REGISTR_PARTY_TYPE_CODE DEF_REGISTR_PARTY_TYPE_CODE
, REGISTRATION_TYPE_RULE_FLAG REGISTRATION_TYPE_RULE_FLAG
, TAX_INCLUSIVE_OVERRIDE_FLAG TAX_INCLUSIVE_OVERRIDE_FLAG
, REGIME_PRECEDENCE REGIME_PRECEDENCE
, CROSS_REGIME_COMPOUNDING_FLAG CROSS_REGIME_COMPOUNDING_FLAG
, TAX_REGIME_ID TAX_REGIME_ID
, GEOGRAPHY_ID GEOGRAPHY_ID
, THRSHLD_CHK_TMPLT_CODE THRSHLD_CHK_TMPLT_CODE
, PERIOD_SET_NAME PERIOD_SET_NAME
, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID
, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID
, TAX_ACCOUNT_PRECEDENCE_CODE TAX_ACCOUNT_PRECEDENCE_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "ZX"."ZX_REGIMES_B"