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 |