VIEW: JE.JE_IT_ABOVE_THR_HDR_ALL#

Source

View Text - Preformatted

select VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION YEAR_OF_DECLARATION, ORG_ID ORG_ID, REPORT_MODE REPORT_MODE, TYPE_OF_UPLOAD TYPE_OF_UPLOAD, REQUEST_ID#1 REQUEST_ID, TRANSMISSION_CODE TRANSMISSION_CODE, PROVINCE_CODE PROVINCE_CODE, DECLR_OF_INCORP_COMP DECLR_OF_INCORP_COMP, TRX_ACCOUNTING_STATUS TRX_ACCOUNTING_STATUS, END_DATE_TO_EXTR_CM_DM END_DATE_TO_EXTR_CM_DM, B2C_INVOICE_THRESHOLD B2C_INVOICE_THRESHOLD, B2B_INVOICE_THRESHOLD B2B_INVOICE_THRESHOLD, START_DATE_TO_EXTR_B2C_TRX START_DATE_TO_EXTR_B2C_TRX, NO_OF_DETAILED_RECORDS NO_OF_DETAILED_RECORDS, 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, PROTOCOL_NUM PROTOCOL_NUM from "JE"."JE_IT_ABOVE_THR_HDR_ALL"

View Text - HTML Formatted

SELECT VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID
, YEAR_OF_DECLARATION YEAR_OF_DECLARATION
, ORG_ID ORG_ID
, REPORT_MODE REPORT_MODE
, TYPE_OF_UPLOAD TYPE_OF_UPLOAD
, REQUEST_ID#1 REQUEST_ID
, TRANSMISSION_CODE TRANSMISSION_CODE
, PROVINCE_CODE PROVINCE_CODE
, DECLR_OF_INCORP_COMP DECLR_OF_INCORP_COMP
, TRX_ACCOUNTING_STATUS TRX_ACCOUNTING_STATUS
, END_DATE_TO_EXTR_CM_DM END_DATE_TO_EXTR_CM_DM
, B2C_INVOICE_THRESHOLD B2C_INVOICE_THRESHOLD
, B2B_INVOICE_THRESHOLD B2B_INVOICE_THRESHOLD
, START_DATE_TO_EXTR_B2C_TRX START_DATE_TO_EXTR_B2C_TRX
, NO_OF_DETAILED_RECORDS NO_OF_DETAILED_RECORDS
, 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
, PROTOCOL_NUM PROTOCOL_NUM
FROM "JE"."JE_IT_ABOVE_THR_HDR_ALL"