VIEW: JE.JE_IT_LIST_PARTIES_ALL#

Source

View Text - Preformatted

select PERIOD_NAME PERIOD_NAME, ORG_ID ORG_ID, TRANSMISSION_NUM TRANSMISSION_NUM, APPLICATION_ID APPLICATION_ID, PARTY_ID PARTY_ID, TAXABLE_AMT TAXABLE_AMT, VAT_AMT VAT_AMT, NON_TAXABLE_AMT NON_TAXABLE_AMT, EXEMPT_AMT EXEMPT_AMT, TAXABLE_VAT_AMT TAXABLE_VAT_AMT, TAXABLE_VAT_INV_AMT TAXABLE_VAT_INV_AMT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PARTY_SEQUENCE_NUM PARTY_SEQUENCE_NUM, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION YEAR_OF_DECLARATION, CM_TAXABLE_AMT CM_TAXABLE_AMT, CM_VAT_AMT CM_VAT_AMT, CM_NON_TAXABLE_AMT CM_NON_TAXABLE_AMT, CM_EXEMPT_AMT CM_EXEMPT_AMT, CM_TAXABLE_VAT_AMT CM_TAXABLE_VAT_AMT, CM_TAXABLE_VAT_INV_AMT CM_TAXABLE_VAT_INV_AMT, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM, FISCAL_ID_NUM FISCAL_ID_NUM from "JE"."JE_IT_LIST_PARTIES_ALL"

View Text - HTML Formatted

SELECT PERIOD_NAME PERIOD_NAME
, ORG_ID ORG_ID
, TRANSMISSION_NUM TRANSMISSION_NUM
, APPLICATION_ID APPLICATION_ID
, PARTY_ID PARTY_ID
, TAXABLE_AMT TAXABLE_AMT
, VAT_AMT VAT_AMT
, NON_TAXABLE_AMT NON_TAXABLE_AMT
, EXEMPT_AMT EXEMPT_AMT
, TAXABLE_VAT_AMT TAXABLE_VAT_AMT
, TAXABLE_VAT_INV_AMT TAXABLE_VAT_INV_AMT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PARTY_SEQUENCE_NUM PARTY_SEQUENCE_NUM
, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID
, YEAR_OF_DECLARATION YEAR_OF_DECLARATION
, CM_TAXABLE_AMT CM_TAXABLE_AMT
, CM_VAT_AMT CM_VAT_AMT
, CM_NON_TAXABLE_AMT CM_NON_TAXABLE_AMT
, CM_EXEMPT_AMT CM_EXEMPT_AMT
, CM_TAXABLE_VAT_AMT CM_TAXABLE_VAT_AMT
, CM_TAXABLE_VAT_INV_AMT CM_TAXABLE_VAT_INV_AMT
, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, FISCAL_ID_NUM FISCAL_ID_NUM
FROM "JE"."JE_IT_LIST_PARTIES_ALL"