CMR_XLA_TAXES_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
TRANSACTION_TAX_ID TAX_CODE TAX_REGIME_CODE TAX_JURISDICTION_ID TAX_RATE_CODE TAX_RATE TAX_INCLUSIVE_FLAG TAX_RECOVERY_TYPE_CODE RECOVERABLE_TAX_INDICATOR TAX_POINT_BASIS TAX_ACCOUNT_CCID TAX_RECOVERY_RATE_CODE

Query

SQL_Statement

select ctt.transaction_tax_id transaction_tax_id , ctt.tax tax_code , ctt.tax_regime_code tax_regime_code , ctt.tax_jurisdiction_id tax_jurisdiction_id , ctt.tax_rate_code tax_rate_code , ctt.tax_rate tax_rate , ctt.inclusive_flag tax_inclusive_flag , ctt.recovery_type_code tax_recovery_type_code , ctt.RECOVERABLE_FLAG recoverable_tax_indicator , ctt.TAX_POINT_BASIS TAX_POINT_BASIS , ctt.ACCOUNT_CCID tax_account_ccid , ctt.RECOVERY_RATE_CODE tax_recovery_rate_code from cmr_transaction_taxes ctt