CMR_XLA_TRADE_TAXES_V

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: VIEW

Columns

Name

TRADE_EVENT_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 ctet.TRADE_EVENT_TAX_ID,

ctet.TAX TAX_CODE,

ctet.TAX_REGIME_CODE TAX_REGIME_CODE,

ctet.TAX_JURISDICTION_ID TAX_JURISDICTION_ID,

ctet.TAX_RATE_CODE TAX_RATE_CODE,

ctet.TAX_RATE TAX_RATE,

ctet.INCLUSIVE_FLAG TAX_INCLUSIVE_FLAG,

ctet.RECOVERY_TYPE_CODE TAX_RECOVERY_TYPE_CODE,

ctet.RECOVERABLE_FLAG RECOVERABLE_TAX_INDICATOR,

ctet.TAX_POINT_BASIS TAX_POINT_BASIS,

ctet.REC_NREC_CCID TAX_ACCOUNT_CCID,

ctet.RECOVERY_RATE_CODE TAX_RECOVERY_RATE_CODE

from cst_trade_event_taxes ctet