eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: ZX.ZX_TAXES_B#

Source

View Text - Preformatted


select TAX TAX, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, TAX_REGIME_CODE TAX_REGIME_CODE, TAX_TYPE_CODE TAX_TYPE_CODE, ALLOW_MANUAL_ENTRY_FLAG ALLOW_MANUAL_ENTRY_FLAG, ALLOW_TAX_OVERRIDE_FLAG ALLOW_TAX_OVERRIDE_FLAG, MIN_TXBL_BSIS_THRSHLD MIN_TXBL_BSIS_THRSHLD, MAX_TXBL_BSIS_THRSHLD MAX_TXBL_BSIS_THRSHLD, MIN_TAX_RATE_THRSHLD MIN_TAX_RATE_THRSHLD, MAX_TAX_RATE_THRSHLD MAX_TAX_RATE_THRSHLD, MIN_TAX_AMT_THRSHLD MIN_TAX_AMT_THRSHLD, MAX_TAX_AMT_THRSHLD MAX_TAX_AMT_THRSHLD, COMPOUNDING_PRECEDENCE COMPOUNDING_PRECEDENCE, PERIOD_SET_NAME PERIOD_SET_NAME, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, TAX_PRECISION TAX_PRECISION, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, ROUNDING_RULE_CODE ROUNDING_RULE_CODE, TAX_STATUS_RULE_FLAG TAX_STATUS_RULE_FLAG, TAX_RATE_RULE_FLAG TAX_RATE_RULE_FLAG, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE, PLACE_OF_SUPPLY_RULE_FLAG PLACE_OF_SUPPLY_RULE_FLAG, DIRECT_RATE_RULE_FLAG DIRECT_RATE_RULE_FLAG, APPLICABILITY_RULE_FLAG APPLICABILITY_RULE_FLAG, TAX_CALC_RULE_FLAG TAX_CALC_RULE_FLAG, TXBL_BSIS_THRSHLD_FLAG TXBL_BSIS_THRSHLD_FLAG, TAX_RATE_THRSHLD_FLAG TAX_RATE_THRSHLD_FLAG, TAX_AMT_THRSHLD_FLAG TAX_AMT_THRSHLD_FLAG, TAXABLE_BASIS_RULE_FLAG TAXABLE_BASIS_RULE_FLAG, DEF_INCLUSIVE_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG, THRSHLD_GROUPING_LVL_CODE THRSHLD_GROUPING_LVL_CODE, HAS_OTHER_JURISDICTIONS_FLAG HAS_OTHER_JURISDICTIONS_FLAG, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG, ALLOW_RECOVERABILITY_FLAG ALLOW_RECOVERABILITY_FLAG, DEF_TAX_CALC_FORMULA DEF_TAX_CALC_FORMULA, TAX_INCLUSIVE_OVERRIDE_FLAG TAX_INCLUSIVE_OVERRIDE_FLAG, DEF_TAXABLE_BASIS_FORMULA DEF_TAXABLE_BASIS_FORMULA, DEF_REGISTR_PARTY_TYPE_CODE DEF_REGISTR_PARTY_TYPE_CODE, REGISTRATION_TYPE_RULE_FLAG REGISTRATION_TYPE_RULE_FLAG, REPORTING_ONLY_FLAG REPORTING_ONLY_FLAG, AUTO_PRVN_FLAG AUTO_PRVN_FLAG, LIVE_FOR_PROCESSING_FLAG LIVE_FOR_PROCESSING_FLAG, HAS_DETAIL_TB_THRSHLD_FLAG HAS_DETAIL_TB_THRSHLD_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, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG, USE_LEGAL_MSG_FLAG USE_LEGAL_MSG_FLAG, CALC_ONLY_FLAG CALC_ONLY_FLAG, PRIMARY_RECOVERY_TYPE_CODE PRIMARY_RECOVERY_TYPE_CODE, PRIMARY_REC_TYPE_RULE_FLAG PRIMARY_REC_TYPE_RULE_FLAG, SECONDARY_RECOVERY_TYPE_CODE SECONDARY_RECOVERY_TYPE_CODE, SECONDARY_REC_TYPE_RULE_FLAG SECONDARY_REC_TYPE_RULE_FLAG, PRIMARY_REC_RATE_DET_RULE_FLAG PRIMARY_REC_RATE_DET_RULE_FLAG, SEC_REC_RATE_DET_RULE_FLAG SEC_REC_RATE_DET_RULE_FLAG, OFFSET_TAX_FLAG OFFSET_TAX_FLAG, RECOVERY_RATE_OVERRIDE_FLAG RECOVERY_RATE_OVERRIDE_FLAG, ZONE_GEOGRAPHY_TYPE ZONE_GEOGRAPHY_TYPE, REGN_NUM_SAME_AS_LE_FLAG REGN_NUM_SAME_AS_LE_FLAG, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, PARENT_GEOGRAPHY_TYPE PARENT_GEOGRAPHY_TYPE, PARENT_GEOGRAPHY_ID PARENT_GEOGRAPHY_ID, ALLOW_MASS_CREATE_FLAG ALLOW_MASS_CREATE_FLAG, APPLIED_AMT_HANDLING_FLAG APPLIED_AMT_HANDLING_FLAG, 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, RECORD_TYPE_CODE RECORD_TYPE_CODE, ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG, 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, SOURCE_TAX_FLAG SOURCE_TAX_FLAG, DEF_PRIMARY_REC_RATE_CODE DEF_PRIMARY_REC_RATE_CODE, ALLOW_DUP_REGN_NUM_FLAG ALLOW_DUP_REGN_NUM_FLAG, DEF_SECONDARY_REC_RATE_CODE DEF_SECONDARY_REC_RATE_CODE, SPECIAL_INCLUSIVE_TAX_FLAG SPECIAL_INCLUSIVE_TAX_FLAG, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, TAX_ID TAX_ID, CONTENT_OWNER_ID CONTENT_OWNER_ID, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID, THRSHLD_CHK_TMPLT_CODE THRSHLD_CHK_TMPLT_CODE, TAX_ACCOUNT_SOURCE_TAX TAX_ACCOUNT_SOURCE_TAX, TAX_ACCOUNT_CREATE_METHOD_CODE TAX_ACCOUNT_CREATE_METHOD_CODE, OVERRIDE_GEOGRAPHY_TYPE OVERRIDE_GEOGRAPHY_TYPE, LIVE_FOR_APPLICABILITY_FLAG LIVE_FOR_APPLICABILITY_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TAX_EXMPT_CR_METHOD_CODE TAX_EXMPT_CR_METHOD_CODE, TAX_EXMPT_SOURCE_TAX TAX_EXMPT_SOURCE_TAX, APPLICABLE_BY_DEFAULT_FLAG APPLICABLE_BY_DEFAULT_FLAG, LEGAL_REPORTING_STATUS_DEF_VAL LEGAL_REPORTING_STATUS_DEF_VAL from "ZX"."ZX_TAXES_B"

View Text - HTML Formatted

SELECT TAX TAX
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX_TYPE_CODE TAX_TYPE_CODE
, ALLOW_MANUAL_ENTRY_FLAG ALLOW_MANUAL_ENTRY_FLAG
, ALLOW_TAX_OVERRIDE_FLAG ALLOW_TAX_OVERRIDE_FLAG
, MIN_TXBL_BSIS_THRSHLD MIN_TXBL_BSIS_THRSHLD
, MAX_TXBL_BSIS_THRSHLD MAX_TXBL_BSIS_THRSHLD
, MIN_TAX_RATE_THRSHLD MIN_TAX_RATE_THRSHLD
, MAX_TAX_RATE_THRSHLD MAX_TAX_RATE_THRSHLD
, MIN_TAX_AMT_THRSHLD MIN_TAX_AMT_THRSHLD
, MAX_TAX_AMT_THRSHLD MAX_TAX_AMT_THRSHLD
, COMPOUNDING_PRECEDENCE COMPOUNDING_PRECEDENCE
, PERIOD_SET_NAME PERIOD_SET_NAME
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, TAX_PRECISION TAX_PRECISION
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, ROUNDING_RULE_CODE ROUNDING_RULE_CODE
, TAX_STATUS_RULE_FLAG TAX_STATUS_RULE_FLAG
, TAX_RATE_RULE_FLAG TAX_RATE_RULE_FLAG
, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE
, PLACE_OF_SUPPLY_RULE_FLAG PLACE_OF_SUPPLY_RULE_FLAG
, DIRECT_RATE_RULE_FLAG DIRECT_RATE_RULE_FLAG
, APPLICABILITY_RULE_FLAG APPLICABILITY_RULE_FLAG
, TAX_CALC_RULE_FLAG TAX_CALC_RULE_FLAG
, TXBL_BSIS_THRSHLD_FLAG TXBL_BSIS_THRSHLD_FLAG
, TAX_RATE_THRSHLD_FLAG TAX_RATE_THRSHLD_FLAG
, TAX_AMT_THRSHLD_FLAG TAX_AMT_THRSHLD_FLAG
, TAXABLE_BASIS_RULE_FLAG TAXABLE_BASIS_RULE_FLAG
, DEF_INCLUSIVE_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG
, THRSHLD_GROUPING_LVL_CODE THRSHLD_GROUPING_LVL_CODE
, HAS_OTHER_JURISDICTIONS_FLAG HAS_OTHER_JURISDICTIONS_FLAG
, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG
, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG
, ALLOW_RECOVERABILITY_FLAG ALLOW_RECOVERABILITY_FLAG
, DEF_TAX_CALC_FORMULA DEF_TAX_CALC_FORMULA
, TAX_INCLUSIVE_OVERRIDE_FLAG TAX_INCLUSIVE_OVERRIDE_FLAG
, DEF_TAXABLE_BASIS_FORMULA DEF_TAXABLE_BASIS_FORMULA
, DEF_REGISTR_PARTY_TYPE_CODE DEF_REGISTR_PARTY_TYPE_CODE
, REGISTRATION_TYPE_RULE_FLAG REGISTRATION_TYPE_RULE_FLAG
, REPORTING_ONLY_FLAG REPORTING_ONLY_FLAG
, AUTO_PRVN_FLAG AUTO_PRVN_FLAG
, LIVE_FOR_PROCESSING_FLAG LIVE_FOR_PROCESSING_FLAG
, HAS_DETAIL_TB_THRSHLD_FLAG HAS_DETAIL_TB_THRSHLD_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
, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG
, USE_LEGAL_MSG_FLAG USE_LEGAL_MSG_FLAG
, CALC_ONLY_FLAG CALC_ONLY_FLAG
, PRIMARY_RECOVERY_TYPE_CODE PRIMARY_RECOVERY_TYPE_CODE
, PRIMARY_REC_TYPE_RULE_FLAG PRIMARY_REC_TYPE_RULE_FLAG
, SECONDARY_RECOVERY_TYPE_CODE SECONDARY_RECOVERY_TYPE_CODE
, SECONDARY_REC_TYPE_RULE_FLAG SECONDARY_REC_TYPE_RULE_FLAG
, PRIMARY_REC_RATE_DET_RULE_FLAG PRIMARY_REC_RATE_DET_RULE_FLAG
, SEC_REC_RATE_DET_RULE_FLAG SEC_REC_RATE_DET_RULE_FLAG
, OFFSET_TAX_FLAG OFFSET_TAX_FLAG
, RECOVERY_RATE_OVERRIDE_FLAG RECOVERY_RATE_OVERRIDE_FLAG
, ZONE_GEOGRAPHY_TYPE ZONE_GEOGRAPHY_TYPE
, REGN_NUM_SAME_AS_LE_FLAG REGN_NUM_SAME_AS_LE_FLAG
, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, PARENT_GEOGRAPHY_TYPE PARENT_GEOGRAPHY_TYPE
, PARENT_GEOGRAPHY_ID PARENT_GEOGRAPHY_ID
, ALLOW_MASS_CREATE_FLAG ALLOW_MASS_CREATE_FLAG
, APPLIED_AMT_HANDLING_FLAG APPLIED_AMT_HANDLING_FLAG
, 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
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG
, 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
, SOURCE_TAX_FLAG SOURCE_TAX_FLAG
, DEF_PRIMARY_REC_RATE_CODE DEF_PRIMARY_REC_RATE_CODE
, ALLOW_DUP_REGN_NUM_FLAG ALLOW_DUP_REGN_NUM_FLAG
, DEF_SECONDARY_REC_RATE_CODE DEF_SECONDARY_REC_RATE_CODE
, SPECIAL_INCLUSIVE_TAX_FLAG SPECIAL_INCLUSIVE_TAX_FLAG
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, TAX_ID TAX_ID
, CONTENT_OWNER_ID CONTENT_OWNER_ID
, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID
, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID
, THRSHLD_CHK_TMPLT_CODE THRSHLD_CHK_TMPLT_CODE
, TAX_ACCOUNT_SOURCE_TAX TAX_ACCOUNT_SOURCE_TAX
, TAX_ACCOUNT_CREATE_METHOD_CODE TAX_ACCOUNT_CREATE_METHOD_CODE
, OVERRIDE_GEOGRAPHY_TYPE OVERRIDE_GEOGRAPHY_TYPE
, LIVE_FOR_APPLICABILITY_FLAG LIVE_FOR_APPLICABILITY_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAX_EXMPT_CR_METHOD_CODE TAX_EXMPT_CR_METHOD_CODE
, TAX_EXMPT_SOURCE_TAX TAX_EXMPT_SOURCE_TAX
, APPLICABLE_BY_DEFAULT_FLAG APPLICABLE_BY_DEFAULT_FLAG
, LEGAL_REPORTING_STATUS_DEF_VAL LEGAL_REPORTING_STATUS_DEF_VAL
FROM "ZX"."ZX_TAXES_B"