VIEW: GMF.SY_SOFT_DTL#

Source

View Text - Preformatted

select SY_SOFT_DTL_ID SY_SOFT_DTL_ID, TABLE_CODE TABLE_CODE, SOFTWARE_CODE SOFTWARE_CODE, CO_CODE CO_CODE, TABLE_NAME TABLE_NAME, TABLE_DESC TABLE_DESC, TABLE_CLASS TABLE_CLASS, MONTHLY MONTHLY, WEEKLY WEEKLY, DAILY DAILY, HOURLY HOURLY, MINUTE MINUTE, DIRECTION_IND DIRECTION_IND, INTERFACE_ID INTERFACE_ID, IMPORTED_DATE IMPORTED_DATE, EXPORTED_DATE EXPORTED_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETE_MARK DELETE_MARK, TRANS_CNT TRANS_CNT, SEQ_NO SEQ_NO, SYNC_METHOD SYNC_METHOD, CO_SPECIFIC_IND CO_SPECIFIC_IND, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "GMF"."SY_SOFT_DTL"

View Text - HTML Formatted

SELECT SY_SOFT_DTL_ID SY_SOFT_DTL_ID
, TABLE_CODE TABLE_CODE
, SOFTWARE_CODE SOFTWARE_CODE
, CO_CODE CO_CODE
, TABLE_NAME TABLE_NAME
, TABLE_DESC TABLE_DESC
, TABLE_CLASS TABLE_CLASS
, MONTHLY MONTHLY
, WEEKLY WEEKLY
, DAILY DAILY
, HOURLY HOURLY
, MINUTE MINUTE
, DIRECTION_IND DIRECTION_IND
, INTERFACE_ID INTERFACE_ID
, IMPORTED_DATE IMPORTED_DATE
, EXPORTED_DATE EXPORTED_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETE_MARK DELETE_MARK
, TRANS_CNT TRANS_CNT
, SEQ_NO SEQ_NO
, SYNC_METHOD SYNC_METHOD
, CO_SPECIFIC_IND CO_SPECIFIC_IND
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "GMF"."SY_SOFT_DTL"