[Home] [Help]
View: CE_MISC_TAX_CODE_V
View Text
SELECT SCO.TAX_RATE_CODE TAX_CODE
, SCO.TAX
, ABS(DECODE(SCO.RATE_TYPE_CODE
, 'QUANTITY'
, SCO.QUANTITY_RATE
, SCO.PERCENTAGE_RATE )) TAX_RATE
, SCO.TAX_RATE_ID
, SCO.EFFECTIVE_FROM
, SCO.EFFECTIVE_TO
, ACCOUNTS.LEDGER_ID
, SUBSTR(SCO.TAX_CLASS
, 1
, 1)
, ACCOUNTS.INTERNAL_ORGANIZATION_ID ORG_ID
FROM ZX_SCO_RATES SCO
, ZX_ACCOUNTS ACCOUNTS
WHERE SCO.ACTIVE_FLAG='Y'
AND ACCOUNTS.TAX_ACCOUNT_ENTITY_ID = SCO.TAX_RATE_ID
AND ACCOUNTS.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
AND SCO.TAX_JURISDICTION_CODE IS NULL
AND SCO.TAX <> 'LOCATION' ORDER BY SCO.TAX_RATE_CODE
Columns
Name |
TAX_CODE |
MEANING |
TAX_RATE |
VAT_TAX_ID |
START_DATE |
END_DATE |
SET_OF_BOOKS_ID |
TAX_CLASS |
ORG_ID |