[Home] [Help]
View: JG_ZZ_VAT_ALLOC_RULES_V
View Text
SELECT ROWID
, ALLOCATION_RULE_ID
, VAT_REPORTING_ENTITY_ID
, SOURCE
, FINANCIAL_DOCUMENT_TYPE
, VAT_TRANSACTION_TYPE
, TAX_ID
, TAX_CODE
, TAX_STATUS
, TAX_JURISDICTION_CODE
, TAX_RATE_CODE
, TAX_RATE_ID
, TAX_BOX_RECOVERABLE
, TAX_BOX_NON_RECOVERABLE
, TAXABLE_BOX_RECOVERABLE
, TAXABLE_BOX_NON_RECOVERABLE
, TOTAL_BOX
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, PERIOD_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TAX_REC_SIGN_FLAG
, TAX_NON_REC_SIGN_FLAG
, TAXABLE_REC_SIGN_FLAG
, TAXABLE_NON_REC_SIGN_FLAG
FROM JG_ZZ_VAT_ALLOC_RULES
Columns
Name |
ROW_ID |
ALLOCATION_RULE_ID |
VAT_REPORTING_ENTITY_ID |
SOURCE |
FINANCIAL_DOCUMENT_TYPE |
VAT_TRANSACTION_TYPE |
TAX_ID |
TAX_CODE |
TAX_STATUS |
TAX_JURISDICTION_CODE |
TAX_RATE_CODE |
TAX_RATE_ID |
TAX_BOX_RECOVERABLE |
TAX_BOX_NON_RECOVERABLE |
TAXABLE_BOX_RECOVERABLE |
TAXABLE_BOX_NON_RECOVERABLE |
TOTAL_BOX |
EFFECTIVE_FROM_DATE |
EFFECTIVE_TO_DATE |
PERIOD_TYPE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
TAX_REC_SIGN_FLAG |
TAX_NON_REC_SIGN_FLAG |
TAXABLE_REC_SIGN_FLAG |
TAXABLE_NON_REC_SIGN_FLAG |