VIEW: CLN.M4U_DMD_DOCUMENTS#

Source

View Text - Preformatted

select MSG_ID MSG_ID, DOC_ID DOC_ID, REF_DOC_ID REF_DOC_ID, ORIG_DOC_ID ORIG_DOC_ID, TYPE TYPE, ACTION ACTION, DOC_TIMESTAMP DOC_TIMESTAMP, DOC_STATUS DOC_STATUS, FUNCTIONAL_STATUS FUNCTIONAL_STATUS, PROCESSING_MESSAGE PROCESSING_MESSAGE, TOP_GTIN TOP_GTIN, INFO_PROVIDER_GLN INFO_PROVIDER_GLN, DATA_RECEPIENT_GLN DATA_RECEPIENT_GLN, TARGET_MARKET_COUNTRY TARGET_MARKET_COUNTRY, TARGET_MARKET_SUB_DIV TARGET_MARKET_SUB_DIV, PARAMETER1 PARAMETER1, PARAMETER2 PARAMETER2, PARAMETER3 PARAMETER3, PARAMETER4 PARAMETER4, PARAMETER5 PARAMETER5, LPARAMETER1 LPARAMETER1, LPARAMETER2 LPARAMETER2, LPARAMETER3 LPARAMETER3, LPARAMETER4 LPARAMETER4, LPARAMETER5 LPARAMETER5, RETRY_COUNT RETRY_COUNT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "CLN"."M4U_DMD_DOCUMENTS"

View Text - HTML Formatted

SELECT MSG_ID MSG_ID
, DOC_ID DOC_ID
, REF_DOC_ID REF_DOC_ID
, ORIG_DOC_ID ORIG_DOC_ID
, TYPE TYPE
, ACTION ACTION
, DOC_TIMESTAMP DOC_TIMESTAMP
, DOC_STATUS DOC_STATUS
, FUNCTIONAL_STATUS FUNCTIONAL_STATUS
, PROCESSING_MESSAGE PROCESSING_MESSAGE
, TOP_GTIN TOP_GTIN
, INFO_PROVIDER_GLN INFO_PROVIDER_GLN
, DATA_RECEPIENT_GLN DATA_RECEPIENT_GLN
, TARGET_MARKET_COUNTRY TARGET_MARKET_COUNTRY
, TARGET_MARKET_SUB_DIV TARGET_MARKET_SUB_DIV
, PARAMETER1 PARAMETER1
, PARAMETER2 PARAMETER2
, PARAMETER3 PARAMETER3
, PARAMETER4 PARAMETER4
, PARAMETER5 PARAMETER5
, LPARAMETER1 LPARAMETER1
, LPARAMETER2 LPARAMETER2
, LPARAMETER3 LPARAMETER3
, LPARAMETER4 LPARAMETER4
, LPARAMETER5 LPARAMETER5
, RETRY_COUNT RETRY_COUNT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "CLN"."M4U_DMD_DOCUMENTS"