gxhub
Tables (83)
DTS_ACK_TAG
- ACK_TID — NVARCHAR2 — Primary key — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- REF_MSG_TID — NVARCHAR2 — NOT NULL
- ACK_MSG_TID — NVARCHAR2
- ACK_NAME — NVARCHAR2 — NOT NULL
- ACK_TYPE — NVARCHAR2 — NOT NULL
- ACK_DIRECTION — CHAR — NOT NULL
- ACK_ACTIVITY — NVARCHAR2
- ACK_FORMAT — NVARCHAR2
DTS_APP_INFO
- APP_NAME — NVARCHAR2 — NOT NULL
- SERVER_ID — NVARCHAR2 — NOT NULL
- OBJECT_NAME — NVARCHAR2 — NOT NULL
- LOG_LEVEL — NVARCHAR2 — NOT NULL
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_APP_LOG
- LOG_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- APP_NAME — NVARCHAR2 — Primary key — NOT NULL
- OPER — NVARCHAR2 — NOT NULL
- SERVER_NAME — NVARCHAR2 — NOT NULL
- ACTOR_ID — NVARCHAR2 — NOT NULL
- ACTOR_IP — NVARCHAR2 — NOT NULL
DTS_BILL_BASIS
- BILL_BASIS_ID — NVARCHAR2 — Primary key — NOT NULL
- BILL_BASIS_DATE — NVARCHAR2 — NOT NULL
- SERVICE_TYPE — CHAR
- ACPT_CUST_ID — NVARCHAR2
- ACPT_TP_QID — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- DLVR_TP_QID — NVARCHAR2
- ACPT_TIMESTAMP — NVARCHAR2
- ACPT_MSG_FORMAT — NVARCHAR2
- ACPT_MSG_SUB_FORMAT — NVARCHAR2
- DLVR_TIMESTAMP — NVARCHAR2
- DLVR_MSG_FORMAT — NVARCHAR2
- DLVR_MSG_SUB_FORMAT — NVARCHAR2
- ACPT_MSG_SIZE — NUMBER
- DLVR_MSG_SIZE — NUMBER
- ACPT_MSG_CTRL_NUM — NVARCHAR2
- DLVR_MSG_CTRL_NUM — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- DOC_FUNC — NVARCHAR2
- DOC_NUM — NVARCHAR2
- SEND_FLAG — CHAR
- MSG_SUB_TYPE — NVARCHAR2
DTS_BILL_STAT
- STAT_DATE — NVARCHAR2
- SERVICE_TYPE — CHAR
- ACPT_DATE — NVARCHAR2
- ACPT_CUST_ID — NVARCHAR2
- ACPT_TP_QID — NVARCHAR2
- ACPT_MSG_FORMAT — NVARCHAR2
- DLVR_DATE — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- DLVR_TP_QID — NVARCHAR2
- DLVR_MSG_FORMAT — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- SEND_FLAG — CHAR
- MSG_SUB_TYPE — NVARCHAR2
- DOC_CNT — NUMBER
- ACPT_DOC_SIZE — NUMBER
- DLVR_DOC_SIZE — NUMBER
DTS_BIZ_INFO
- BIZ_ID — NVARCHAR2 — Primary key — NOT NULL
- BIZ_NAME — NVARCHAR2
- BIZ_DESC — NVARCHAR2
- USE_FLAG — CHAR
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_BIZ_MAP_INFO
- BIZ_MAP_ID — NVARCHAR2 — Primary key — NOT NULL
- BIZ_ID — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- MSG_FORMAT — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
DTS_COMMON_CODE
- GROUP_CODE_ID — NVARCHAR2 — Primary key — NOT NULL
- CODE_ID — NVARCHAR2 — Primary key — NOT NULL
- CODE_VALUE — NVARCHAR2
- CODE_VALUE_LOC — NVARCHAR2
- REMARK — NVARCHAR2
- USE_FLAG — CHAR
- ORDER_SEQ — NUMBER
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_CONN_LOG
- CONN_LOG_ID — NVARCHAR2 — NOT NULL
- CONN_TIMESTAMP — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2
- CONN_STATUS — CHAR — NOT NULL
- LOCAL_ADDR — NVARCHAR2
- REMOTE_ADDR — NVARCHAR2
- COM_PROTOCOL — NVARCHAR2
- CONN_DIRECTION — CHAR
DTS_CONN_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- CONN_STATUS — CHAR — NOT NULL
- COM_PROTOCOL — NVARCHAR2
- CONN_DIRECTION — CHAR
- CONN_CNT — NUMBER
DTS_COPY_ACTION_INFO
- ACTION_ID — NVARCHAR2 — Primary key — NOT NULL
- COPY_ID — NVARCHAR2 — NOT NULL
- TP_REPLACE_FLAG — CHAR — NOT NULL
- ACPT_TP_ID — NVARCHAR2
- ACPT_TP_QUAL — NVARCHAR2
- DLVR_TP_ID — NVARCHAR2
- DLVR_TP_QUAL — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_COPY_COND_INFO
- COND_ID — NVARCHAR2 — Primary key — NOT NULL
- COPY_ID — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_TP_ID — NVARCHAR2
- ACPT_TP_QUAL — NVARCHAR2
- DLVR_TP_ID — NVARCHAR2
- DLVR_TP_QUAL — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_COPY_INFO
- COPY_ID — NVARCHAR2 — Primary key — NOT NULL
- COPY_TITLE — NVARCHAR2 — NOT NULL
- COPY_TYPE — NVARCHAR2 — NOT NULL
- MSG_FORMAT — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_CUST_CONTACT_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- SEQ — NUMBER — Primary key — NOT NULL
- DEPT — NVARCHAR2
- POSITION — NVARCHAR2
- CHARGE_NAME — NVARCHAR2
- POST_CODE — NVARCHAR2
- ADDR1 — NVARCHAR2
- ADDR2 — NVARCHAR2
- TEL — NVARCHAR2
- MOBILE_TEL — NVARCHAR2
- FAX — NVARCHAR2
- EMAIL — NVARCHAR2
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_CUST_GROUP_INFO
- GROUP_ID — NVARCHAR2 — Primary key — NOT NULL
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
DTS_CUST_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- CUST_NAME — NVARCHAR2 — NOT NULL
- LOGIN_PASSWD — NVARCHAR2
- CUST_STATUS — CHAR — NOT NULL
- MSG_FORMAT — NVARCHAR2 — NOT NULL
- DLVR_TYPE — NVARCHAR2 — NOT NULL
- ACK_TYPES — NVARCHAR2
- ACK_NAME — NVARCHAR2
- BILL_FLAG — CHAR — NOT NULL
- CHAR_SET — NVARCHAR2 — NOT NULL
- ENCODE_FLAG — CHAR — NOT NULL
- SPEC_NO — NVARCHAR2
- CEO_NAME — NVARCHAR2
- COMPANY_NAME — NVARCHAR2
- BIZ_STATUS — NVARCHAR2
- BIZ_TYPE — NVARCHAR2
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_DATA_ACCESS_LOG
- LOG_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- USER_ID — NVARCHAR2 — Primary key — NOT NULL
- DOMAIN — NVARCHAR2 — NOT NULL
- TABLE_NAME — NVARCHAR2 — NOT NULL
- OPER_FLAG — CHAR
- DATA_KEY — NVARCHAR2
DTS_DLVR_MSG
- MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- DLVR_CUST_ID — NVARCHAR2 — NOT NULL
- DLVR_TP_QID — NVARCHAR2 — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- DIRECTION — VARCHAR2 — NOT NULL
- CURR_RETRY_CNT — NUMBER — NOT NULL
- CURR_STATUS — NVARCHAR2 — NOT NULL
- DOMAIN — NVARCHAR2
- CURR_TIMESTAMP — NVARCHAR2 — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- CHECK_DATETIME — NVARCHAR2 — NOT NULL
DTS_DLVR_SCHEDULE_INFO
- DLVR_CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- DLVR_TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- SEQ — NVARCHAR2 — Primary key — NOT NULL
- DAY_OF_WEEK — NUMBER — NOT NULL
- BEGIN_TIME — CHAR — NOT NULL
- END_TIME — CHAR — NOT NULL
- USE_FLAG — CHAR — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_DOC_INFO
- MSG_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- DOC_TYPE — NVARCHAR2 — Primary key — NOT NULL
- DOC_CODE — NVARCHAR2 — Primary key — NOT NULL
- DOC_NAME — NVARCHAR2
- REF_NUM_SEG_NAME — NVARCHAR2
- REF_NUM_SEG_CODE — NVARCHAR2
- REF_NUM_XPATH — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_DOC_LOB
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- DOC_TID — NVARCHAR2 — Primary key — NOT NULL
- DOC_DATA — BLOB
DTS_DOC_LOB_AR
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- DOC_TID — NVARCHAR2 — Primary key — NOT NULL
- DOC_DATA — BLOB
DTS_DOC_MAP_INFO
- DOC_MAP_ID — NVARCHAR2 — Primary key — NOT NULL
- SOURCE_FORMAT — NVARCHAR2 — NOT NULL
- SOURCE_SUB_FORMAT — NVARCHAR2 — NOT NULL
- TARGET_FORMAT — NVARCHAR2 — NOT NULL
- TARGET_SUB_FORMAT — NVARCHAR2 — NOT NULL
- DOC_TYPE — NVARCHAR2 — NOT NULL
- DOC_VER — NVARCHAR2 — NOT NULL
- DOC_CODE — NVARCHAR2 — NOT NULL
- ACPT_CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_TP_QID — NVARCHAR2 — NOT NULL
- DLVR_CUST_ID — NVARCHAR2 — NOT NULL
- DLVR_TP_QID — NVARCHAR2 — NOT NULL
- SOURCE_SCHEMA — NVARCHAR2 — NOT NULL
- TARGET_SCHEMA — NVARCHAR2 — NOT NULL
- MAPPING_SCRIPT — NVARCHAR2 — NOT NULL
- SOURCE_VALIDATION — CHAR — NOT NULL
- TARGET_VALIDATION — CHAR — NOT NULL
- LOGGING_RESULT — CHAR — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_DOC_PRS_INFO
- MSG_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- ACPT_TP_ID_XPATH — NVARCHAR2
- ACPT_TP_QUAL_XPATH — NVARCHAR2
- DLVR_TP_ID_XPATH — NVARCHAR2
- DLVR_TP_QUAL_XPATH — NVARCHAR2
- SCRIPT — BLOB
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_DOC_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- DOC_FORMAT — NVARCHAR2
- DOC_CNT — NUMBER
- DOC_SIZE — NUMBER
DTS_DOC_TAG
- DOC_TID — NVARCHAR2 — Primary key — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- MSG_TID — NVARCHAR2 — NOT NULL
- DOC_SEQ — NUMBER — NOT NULL
- RAW_TID — NVARCHAR2 — NOT NULL
- DOC_FORMAT — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- DOC_NAME — NVARCHAR2
- DOC_NUM — NVARCHAR2
- DOC_SIZE — NUMBER
- DOC_VER — NVARCHAR2
- DOC_FUNC — NVARCHAR2
- REF_NUM — NVARCHAR2
DTS_DOC_TAG_AR
- DOC_TID — NVARCHAR2 — Primary key — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- MSG_TID — NVARCHAR2 — NOT NULL
- DOC_SEQ — NUMBER — NOT NULL
- RAW_TID — NVARCHAR2 — NOT NULL
- DOC_FORMAT — NVARCHAR2
- DOC_TYPE — NVARCHAR2
- DOC_CODE — NVARCHAR2
- DOC_NAME — NVARCHAR2
- DOC_NUM — NVARCHAR2
- DOC_SIZE — NUMBER
- DOC_VER — NVARCHAR2
- DOC_FUNC — NVARCHAR2
- REF_NUM — NVARCHAR2
DTS_EDI_ICR_LOG
- ACPT_TP_QID — NVARCHAR2 — Primary key — NOT NULL
- DLVR_TP_QID — NVARCHAR2 — Primary key — NOT NULL
- CURR_MSG_CTRL_NUM — NUMBER — NOT NULL
DTS_EDI_STD_INFO
- DOC_TYPE — NVARCHAR2 — Primary key — NOT NULL
- DOC_CODE — NVARCHAR2 — Primary key — NOT NULL
- STANDARD — CHAR — Primary key — NOT NULL
- VER — NVARCHAR2 — Primary key — NOT NULL
- SCHEMA_LOCATION — NVARCHAR2
- CNTRL_AGENCY — NVARCHAR2
- FUNC_CODE — NVARCHAR2 — NOT NULL
- AUT_APPLY_FLAG — CHAR
- DOC_CLASS — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_EDI_VALID_INFO
- DOC_TYPE — NVARCHAR2 — Primary key — NOT NULL
- DOC_VER — NVARCHAR2 — Primary key — NOT NULL
- DOC_CODE — NVARCHAR2 — Primary key — NOT NULL
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MAND_ELEM — CHAR — NOT NULL
- ELEM_LENGTH — CHAR — NOT NULL
- VALID_CODE — CHAR — NOT NULL
- VALID_CHAR — CHAR — NOT NULL
- SEG_CNT_IN_TRANS — CHAR — NOT NULL
- SEG_REPEAT_CNT — CHAR — NOT NULL
- MATCHING_CTRL_NUM — CHAR — NOT NULL
- DEFAULT_HEADER_ELEM — CHAR — NOT NULL
- OPTIONAL_HEADER_ELEM — CHAR — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_ERROR_CODE
- ERROR_CODE_ID — NVARCHAR2 — Primary key — NOT NULL
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_FTP_PULL_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- SERVICE_NAME — NVARCHAR2 — NOT NULL
- HOST_NAME — NVARCHAR2 — NOT NULL
- PORT — NUMBER — NOT NULL
- LOGIN_ID — NVARCHAR2 — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- REMOTE_DIR — NVARCHAR2 — NOT NULL
- LOCAL_DIR — NVARCHAR2 — NOT NULL
- INTERVAL — NUMBER — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- USE_FLAG — NVARCHAR2
DTS_GROUP_CODE
- GROUP_CODE_ID — NVARCHAR2 — Primary key — NOT NULL
- GROUP_CODE_NAME — NVARCHAR2
- REMARK — NVARCHAR2
- USE_FLAG — CHAR
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_EBMS_INFO
- CUST_ID — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SERVICE — NVARCHAR2 — NOT NULL
- ACTION — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_EMAIL_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- FROM_ADDRESS — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_FILE_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- SOURCE_DIR — NVARCHAR2 — NOT NULL
- USE_FLAG — CHAR
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_FTP_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- HOME_DIR — NVARCHAR2 — NOT NULL
- SOURCE_DIR — NVARCHAR2 — NOT NULL
- IN_FILE_PREFIX — NVARCHAR2
- MAX_LOGIN_CNT — NUMBER — NOT NULL
- MAX_LOGIN_PER_IP — NUMBER — NOT NULL
- IDLE_TIME — NUMBER — NOT NULL
- DOWNLOAD_RATE — NUMBER — NOT NULL
- UPLOAD_RATE — NUMBER — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_HTTPS_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- HOME_DIR — NVARCHAR2 — NOT NULL
- IN_DIR — NVARCHAR2 — NOT NULL
- OUT_DIR — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- COM_PROTOCOL — NVARCHAR2 — NOT NULL
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_JMS_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- APP_NAME — NVARCHAR2 — NOT NULL
- JMS_QUEUE — NVARCHAR2 — NOT NULL
- QUEUE_NAME — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_SFTP_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- HOME_DIR — NVARCHAR2 — NOT NULL
- IN_DIR — NVARCHAR2 — NOT NULL
- OUT_DIR — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_SOCKET_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- HOME_DIR — NVARCHAR2 — NOT NULL
- IN_DIR — NVARCHAR2 — NOT NULL
- OUT_DIR — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_WS_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- ACTION — NVARCHAR2 — Primary key — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_INDIAL_X400_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- MTA_NAME — NVARCHAR2 — NOT NULL
- STORE_ADDRESS — NVARCHAR2 — NOT NULL
- USER_ADDRESS — NVARCHAR2 — NOT NULL
- USER_PASSWD — NVARCHAR2 — NOT NULL
- SENDER_ADDRESS — NVARCHAR2 — NOT NULL
- TARGET_DIR — NVARCHAR2 — NOT NULL
- RECEIVE_INTERVAL — NUMBER — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_MENU_INFO
- MENU_ID — NVARCHAR2 — Primary key — NOT NULL
- MENU_NAME — NVARCHAR2
- MENU_NAME_LOC — NVARCHAR2
- MENU_DESC — NVARCHAR2
- MENU_URL — NVARCHAR2
- MENU_SEQ — NUMBER
- ROOT_MENU_ID — NVARCHAR2 — NOT NULL
- SUPER_MENU_ID — NVARCHAR2
- MENU_DEPTH — NUMBER — NOT NULL
- LEAF_MENU_FLAG — CHAR
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_MSG_EVENT_LOG
- TAG_ID — NVARCHAR2 — NOT NULL
- EVENT_TIMESTAMP — NVARCHAR2 — NOT NULL
- TAG_TYPE — CHAR — NOT NULL
- ACTIVITY_CODE — NVARCHAR2
- MSG_STATUS — NVARCHAR2
- ACTOR_ID — NVARCHAR2
- ACTOR_TYPE — CHAR
DTS_MSG_EVENT_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- TAG_TYPE — CHAR — NOT NULL
- ACTIVITY_CODE — NVARCHAR2
- MSG_STATUS — NVARCHAR2
- ACTOR_ID — NVARCHAR2
- MSG_EVENT_CNT — NUMBER
DTS_MSG_LOB
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- MSG_DATA — BLOB
DTS_MSG_LOB_AR
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- MSG_DATA — BLOB
DTS_MSG_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- ACPT_CUST_ID — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- MSG_STATUS — NVARCHAR2
- MSG_CNT — NUMBER
- MSG_SIZE — NUMBER
DTS_MSG_TAG
- MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- RAW_TID — NVARCHAR2 — NOT NULL
- MSG_SEQ — NUMBER — NOT NULL
- ROOT_MSG_TID — NVARCHAR2 — NOT NULL
- SUPER_MSG_TID — NVARCHAR2
- MSG_TAG_DEPTH — NUMBER — NOT NULL
- MSG_TYPE — CHAR
- MSG_SUB_TYPE — NVARCHAR2
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_CUST_ID — NVARCHAR2
- ACPT_TP_QID — NVARCHAR2
- ACPT_TP_QUAL — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- DLVR_TP_QID — NVARCHAR2
- DLVR_TP_QUAL — NVARCHAR2
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- ACPT_CHAR_SET — NVARCHAR2
- ACPT_MSG_FORMAT — NVARCHAR2
- ACPT_MSG_SUB_FORMAT — NVARCHAR2
- DLVR_TIMESTAMP — NVARCHAR2
- DLVR_CHAR_SET — NVARCHAR2
- DLVR_MSG_FORMAT — NVARCHAR2
- DLVR_MSG_SUB_FORMAT — NVARCHAR2
- CURR_TIMESTAMP — NVARCHAR2
- CURR_CHAR_SET — NVARCHAR2
- CURR_MSG_FORMAT — NVARCHAR2
- CURR_MSG_SUB_FORMAT — NVARCHAR2
- MSG_STATUS — NVARCHAR2
- MSG_SIZE — NUMBER
- MSG_CTRL_NUM — NVARCHAR2
- DOC_CNT — NUMBER
- TAG_CREATE_TIMESTAMP — NVARCHAR2
- LEAF_TAG_FLAG — CHAR
- ROUT_ID — NVARCHAR2
- ROUT_PATH_SEQ — NUMBER
- CURR_ACTIVITY — NVARCHAR2 — NOT NULL
- CURR_ACTION — NVARCHAR2
- REF_TYPE — NVARCHAR2
DTS_MSG_TAG_AR
- MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- RAW_TID — NVARCHAR2 — NOT NULL
- MSG_SEQ — NUMBER — NOT NULL
- ROOT_MSG_TID — NVARCHAR2 — NOT NULL
- SUPER_MSG_TID — NVARCHAR2
- MSG_TAG_DEPTH — NUMBER — NOT NULL
- MSG_TYPE — CHAR
- MSG_SUB_TYPE — NVARCHAR2
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_CUST_ID — NVARCHAR2
- ACPT_TP_QID — NVARCHAR2
- ACPT_TP_QUAL — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- DLVR_TP_QID — NVARCHAR2
- DLVR_TP_QUAL — NVARCHAR2
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- ACPT_CHAR_SET — NVARCHAR2
- ACPT_MSG_FORMAT — NVARCHAR2
- ACPT_MSG_SUB_FORMAT — NVARCHAR2
- DLVR_TIMESTAMP — NVARCHAR2
- DLVR_CHAR_SET — NVARCHAR2
- DLVR_MSG_FORMAT — NVARCHAR2
- DLVR_MSG_SUB_FORMAT — NVARCHAR2
- CURR_TIMESTAMP — NVARCHAR2
- CURR_CHAR_SET — NVARCHAR2
- CURR_MSG_FORMAT — NVARCHAR2
- CURR_MSG_SUB_FORMAT — NVARCHAR2
- MSG_STATUS — NVARCHAR2
- MSG_SIZE — NUMBER
- MSG_CTRL_NUM — NVARCHAR2
- DOC_CNT — NUMBER
- TAG_CREATE_TIMESTAMP — NVARCHAR2
- LEAF_TAG_FLAG — CHAR
- ROUT_ID — NVARCHAR2
- ROUT_PATH_SEQ — NUMBER
- CURR_ACTIVITY — NVARCHAR2 — NOT NULL
- CURR_ACTION — NVARCHAR2
- ARCHIVE_DATE — NVARCHAR2 — NOT NULL
- RETRIEVAL_FLAG — CHAR
DTS_OUTDIAL_EMAIL_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- FROM_ADDRESS — NVARCHAR2 — NOT NULL
- FROM_NAME — NVARCHAR2
- TO_ADDRESS — NVARCHAR2 — NOT NULL
- TO_NAME — NVARCHAR2
- SUBJECT — NVARCHAR2
- MESSAGE — NVARCHAR2
- ENCRYPT — CHAR
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_FILE_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- TARGET_DIR — NVARCHAR2 — NOT NULL
- TEMP_DIR — NVARCHAR2
- FILENAME_FORMAT — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_FTP_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- REMOTE_HOST — NVARCHAR2 — NOT NULL
- REMOTE_PORT — NUMBER — NOT NULL
- LOGIN_ID — NVARCHAR2 — NOT NULL
- LOGIN_PASSWD — NVARCHAR2 — NOT NULL
- CONN_TIMEOUT — NUMBER — NOT NULL
- DATA_TIMEOUT — NUMBER — NOT NULL
- CONNECTION_MODE — CHAR — NOT NULL
- FILE_TYPE — CHAR — NOT NULL
- TARGET_DIR — NVARCHAR2 — NOT NULL
- TEMP_DIR — NVARCHAR2
- FILENAME_FORMAT — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- COM_PROTOCOL — NVARCHAR2 — NOT NULL
- COM_PROGRAM — NVARCHAR2 — NOT NULL
- DLVR_MODE — NVARCHAR2 — NOT NULL
- MAX_DLVR_MSG_CNT — NUMBER — NOT NULL
- MAX_RETRY_CNT — NUMBER — NOT NULL
- RETRY_INTERVAL — NUMBER — NOT NULL
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_JMS_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- JMS_FACTORY — NVARCHAR2 — NOT NULL
- JMS_QUEUE — NVARCHAR2 — NOT NULL
- QUEUE_NAME — NVARCHAR2 — NOT NULL
- QUEUE_URL — NVARCHAR2 — NOT NULL
- QUEUE_USER_ID — NVARCHAR2
- QUEUE_USER_PASSWD — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_WS_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- ACTION — NVARCHAR2 — NOT NULL
- ENDPOINT — NVARCHAR2 — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_OUTDIAL_X400_INFO
- CUST_ID — NVARCHAR2 — Primary key — NOT NULL
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- STORE_ADDRESS — NVARCHAR2 — NOT NULL
- USER_ADDRESS — NVARCHAR2 — NOT NULL
- USER_PASSWORD — NVARCHAR2 — NOT NULL
- RECIPIENT_ADDRESS — NVARCHAR2 — NOT NULL
- TARGET_DIR — NVARCHAR2 — NOT NULL
- SEND_INTERVAL — NUMBER — NOT NULL
- RECEIVE_INTERVAL — NUMBER — NOT NULL
- RESULT_INTERVAL — NUMBER — NOT NULL
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_POST_CODE
- POST_CODE_SEQ — NUMBER — Primary key — NOT NULL
- POST_CODE — NVARCHAR2
- SIDO — NVARCHAR2
- GUGUN — NVARCHAR2
- DONG — NVARCHAR2
- BUNJI — NVARCHAR2
DTS_RAW_LOB
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- RAW_TID — NVARCHAR2 — Primary key — NOT NULL
- RAW_DATA — BLOB
DTS_RAW_LOB_AR
- ACPT_TIMESTAMP — NVARCHAR2 — Primary key — NOT NULL
- RAW_TID — NVARCHAR2 — Primary key — NOT NULL
- RAW_DATA — BLOB
DTS_RAW_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- MSG_FORMAT — NVARCHAR2
- MSG_TYPE — CHAR
- RAW_CNT — NUMBER
- RAW_SIZE — NUMBER
DTS_RAW_TAG
- RAW_TID — NVARCHAR2 — Primary key — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- RAW_SIZE — NUMBER — NOT NULL
- MSG_FORMAT — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- RAW_STATUS — CHAR — NOT NULL
- STATUS_TIMESTAMP — NVARCHAR2 — NOT NULL
- TAG_CREATE_TIMESTAMP — NVARCHAR2 — NOT NULL
DTS_RAW_TAG_AR
- RAW_TID — NVARCHAR2 — Primary key — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- RAW_SIZE — NUMBER — NOT NULL
- MSG_FORMAT — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- RAW_STATUS — CHAR — NOT NULL
- STATUS_TIMESTAMP — NVARCHAR2 — NOT NULL
- TAG_CREATE_TIMESTAMP — NVARCHAR2 — NOT NULL
DTS_RETRIEVAL_MSG
- OLD_MSG_TID — NVARCHAR2 — Primary key — NOT NULL
- NEW_RAW_TID — NVARCHAR2 — Primary key — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_CUST_ID — NVARCHAR2
- ACPT_TP_QID — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2
- DLVR_TP_QID — NVARCHAR2
- MSG_CTRL_NUM — NVARCHAR2
- ARCHIVE_DATE — NVARCHAR2 — NOT NULL
- ACPT_TIMESTAMP — NVARCHAR2 — NOT NULL
- RETRIEVAL_TIMESTAMP — NVARCHAR2 — NOT NULL
DTS_ROUT_COND_INFO
- ROUT_COND_ID — NVARCHAR2 — Primary key — NOT NULL
- ROUT_ID — NVARCHAR2 — NOT NULL
- ORDER_SEQ — NUMBER
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_ROUT_COND_ITEM_INFO
- ROUT_COND_ITEM_ID — NVARCHAR2 — Primary key — NOT NULL
- ROUT_COND_ID — NVARCHAR2 — NOT NULL
- ROUT_ID — NVARCHAR2 — NOT NULL
- EXPRESSION — NVARCHAR2 — NOT NULL
- DOMAIN — NVARCHAR2 — NOT NULL
- LEFT_COLUMN — NVARCHAR2 — NOT NULL
- OPERATOR — NVARCHAR2 — NOT NULL
- RIGHT_VALUE — NVARCHAR2 — NOT NULL
- RIGHT_TYPE — CHAR — NOT NULL
DTS_ROUT_INFO
- ROUT_ID — NVARCHAR2 — Primary key — NOT NULL
- ROUT_NAME — NVARCHAR2 — NOT NULL
- FROM_ACTIVITY — NVARCHAR2 — NOT NULL
- PRIORITY — NUMBER — NOT NULL
- USE_FLAG — CHAR
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_ROUT_PATH_INFO
- ROUT_ID — NVARCHAR2 — Primary key — NOT NULL
- SEQ — NUMBER — Primary key — NOT NULL
- ACTIVITY — NVARCHAR2 — NOT NULL
- ACTION — NVARCHAR2
- REG_USER_ID — NVARCHAR2
- REG_DATETIME — NVARCHAR2
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_SYS_EVENT_LOG
- SYS_EVENT_LOG_ID — NVARCHAR2 — Primary key — NOT NULL
- LOG_TIMESTAMP — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- EVENT_TIMESTAMP — NVARCHAR2 — NOT NULL
- CODE_ID — NVARCHAR2
- MESSAGE — NVARCHAR2
- SEVERITY — CHAR
- DOMAIN — NVARCHAR2
- PROGRAM_NAME — NVARCHAR2
- CLASS_NAME — NVARCHAR2
- METHOD_NAME — NVARCHAR2
- LINE_NUMBER — NUMBER
- RAW_TID — NVARCHAR2
- MSG_TID — NVARCHAR2
DTS_SYS_EVENT_STAT
- STAT_DATE — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- CODE_ID — NVARCHAR2
- SEVERITY — CHAR
- DOMAIN — NVARCHAR2
- PROGRAM_NAME — NVARCHAR2
- SYS_EVENT_CNT — NUMBER
DTS_TPA_INFO
- TPA_ID — NVARCHAR2 — Primary key — NOT NULL
- ACPT_CUST_ID — NVARCHAR2 — NOT NULL
- ACPT_TP_ID — NVARCHAR2 — NOT NULL
- ACPT_TP_QUAL — NVARCHAR2
- ACPT_DIV_ID — NVARCHAR2
- ACPT_DIV_QUAL — NVARCHAR2
- DLVR_CUST_ID — NVARCHAR2 — NOT NULL
- DLVR_TP_ID — NVARCHAR2 — NOT NULL
- DLVR_TP_QUAL — NVARCHAR2
- DLVR_DIV_ID — NVARCHAR2
- DLVR_DIV_QUAL — NVARCHAR2
- DIV_USE_FLAG — CHAR — NOT NULL
- AUT_USE_FLAG — CHAR — NOT NULL
- ACPT_AUT_KEY — NVARCHAR2
- DLVR_AUT_KEY — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_TP_EDI_INFO
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- ROUTE_ADDRESS — NVARCHAR2
- DATE_FORMAT — NVARCHAR2
- SYNTAX_ID — NVARCHAR2
- SYNTAX_VERSION — CHAR
- RECIPIENT_REF — NVARCHAR2
- RECIPIENT_REF_PW — NVARCHAR2
- PROC_PRIORITY — CHAR
- COM_AGREE_ID — NVARCHAR2
- APP_PW — NVARCHAR2
- CTRL_AGENCY — NVARCHAR2
- AGENCY_CODE — NVARCHAR2
- SUB_DELIMITER — NVARCHAR2
- DELIMITER — NVARCHAR2
- DECIMAL_POINT — NVARCHAR2
- RELEASE — NVARCHAR2
- RESERV — NVARCHAR2
- TERMINATOR — NVARCHAR2
DTS_TP_INFO
- TP_QID — NVARCHAR2 — Primary key — NOT NULL
- TP_NAME — NVARCHAR2
- TP_QUAL — NVARCHAR2
- TP_ID — NVARCHAR2 — NOT NULL
- CUST_ID — NVARCHAR2 — NOT NULL
- MSG_SUB_FORMAT — NVARCHAR2 — NOT NULL
- BILL_FLAG — CHAR — NOT NULL
- DEPT — NVARCHAR2
- POSITION — NVARCHAR2
- CHARGE_NAME — NVARCHAR2
- POST_CODE — NVARCHAR2
- ADDR1 — NVARCHAR2
- ADDR2 — NVARCHAR2
- TEL — NVARCHAR2
- FAX — NVARCHAR2
- EMAIL — NVARCHAR2
- SPEC_NO — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
- TP_STATUS — CHAR
- ACCOUNT_NO — NVARCHAR2
- AGENT_CODE — NVARCHAR2
DTS_USER_GROUP_AUTH
- USER_GROUP_ID — NVARCHAR2 — Primary key — NOT NULL
- MENU_ID — NVARCHAR2 — Primary key — NOT NULL
- SELECT_FLAG — CHAR
- INSERT_FLAG — CHAR
- UPDATE_FLAG — CHAR
- DELETE_FLAG — CHAR
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_USER_GROUP_INFO
- USER_GROUP_ID — NVARCHAR2 — Primary key — NOT NULL
- USER_GROUP_NAME — NVARCHAR2
- REMARK — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_USER_INFO
- USER_ID — NVARCHAR2 — Primary key — NOT NULL
- PSWD — NVARCHAR2
- USER_NAME — NVARCHAR2
- USER_STATUS — CHAR
- REMARK — NVARCHAR2
- USER_GROUP_ID — NVARCHAR2
- GROUP_ADMIN_FLAG — CHAR
- PSWD_DATETIME — NVARCHAR2
- REG_USER_ID — NVARCHAR2 — NOT NULL
- REG_DATETIME — NVARCHAR2 — NOT NULL
- MOD_USER_ID — NVARCHAR2
- MOD_DATETIME — NVARCHAR2
DTS_XMIT_LOG
- XMIT_LOG_ID — NVARCHAR2 — NOT NULL
- XMIT_TIMESTAMP — NVARCHAR2 — NOT NULL
- CONN_LOG_ID — NVARCHAR2
- XMIT_STATUS — CHAR — NOT NULL
- XMIT_DIRECTION — CHAR
- FILE_NAME — NVARCHAR2
DTS_XMIT_MSG_LOG
- XMIT_LOG_ID — NVARCHAR2 — Primary key — NOT NULL
- RAW_TID — NVARCHAR2
- MSG_TID — NVARCHAR2
and 3 more tables