VIEW: ZX.ZX_REPORTING_TYPES_B#

Source

View Text - Preformatted

select REPORTING_TYPE_ID REPORTING_TYPE_ID, REPORTING_TYPE_CODE REPORTING_TYPE_CODE, REPORTING_TYPE_DATATYPE_CODE REPORTING_TYPE_DATATYPE_CODE, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, FORMAT_MASK FORMAT_MASK, MIN_LENGTH MIN_LENGTH, MAX_LENGTH MAX_LENGTH, LEGAL_MESSAGE_FLAG LEGAL_MESSAGE_FLAG, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, HAS_REPORTING_CODES_FLAG HAS_REPORTING_CODES_FLAG, RECORD_TYPE_CODE RECORD_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZD_EDITION_NAME ZD_EDITION_NAME from "ZX"."ZX_REPORTING_TYPES_B"

View Text - HTML Formatted

SELECT REPORTING_TYPE_ID REPORTING_TYPE_ID
, REPORTING_TYPE_CODE REPORTING_TYPE_CODE
, REPORTING_TYPE_DATATYPE_CODE REPORTING_TYPE_DATATYPE_CODE
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, FORMAT_MASK FORMAT_MASK
, MIN_LENGTH MIN_LENGTH
, MAX_LENGTH MAX_LENGTH
, LEGAL_MESSAGE_FLAG LEGAL_MESSAGE_FLAG
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, HAS_REPORTING_CODES_FLAG HAS_REPORTING_CODES_FLAG
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ZX"."ZX_REPORTING_TYPES_B"