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