inqten

Tables (50)

ATS_3M_CMS

  • REG_ID — NUMBER
  • ATS_ID — NUMBER
  • BANK_ID — VARCHAR2(3 CHAR)
  • BANK_NAME — VARCHAR2(100 CHAR)
  • BANK_ACC — VARCHAR2(60 CHAR)
  • BANK_DEP — VARCHAR2(100 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • CASH_RCPT_YN — VARCHAR2(1 CHAR)
  • CASH_RCPT_TEL — VARCHAR2(20 CHAR)
  • CASH_RCPT_NO — VARCHAR2(20 CHAR)
  • BIRTHDAY — VARCHAR2(8 CHAR)

ATS_3M_DATE

  • ATS_CNT — NUMBER
  • ATS_KIND — VARCHAR2(4 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ATS_MONTH — VARCHAR2(6 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)

ATS_3M_INFO

  • ATS_ID — NUMBER
  • USER_ID — VARCHAR2(20 CHAR)
  • REG_DATE — VARCHAR2(8 CHAR)
  • USE_YN — VARCHAR2(1 CHAR)
  • CAN_DATE — VARCHAR2(14 CHAR)
  • ATS_SDATE — VARCHAR2(8 CHAR)
  • ATS_EDATE — VARCHAR2(8 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ATS_DATE_NEXT — VARCHAR2(8 CHAR)
  • ATS_KIND — VARCHAR2(4 CHAR)
  • CARD_ID — VARCHAR2(2 CHAR)
  • CARD_NUM — VARCHAR2(60 CHAR)
  • CARD_MON — VARCHAR2(2 CHAR)
  • CARD_OWNER — VARCHAR2(100 CHAR)
  • CARD_MONYEAR — VARCHAR2(4 CHAR)
  • CARD_PW — VARCHAR2(60 CHAR)
  • CARD_CHK_YN — VARCHAR2(1 CHAR)
  • CARD_CHK_DATE — VARCHAR2(14 CHAR)
  • CARD_BILL_KEY — VARCHAR2(100 CHAR)
  • ATS_ACC_OLD — NUMBER
  • ATS_ACC_SUCC_OLD — NUMBER
  • ATS_ACC — NUMBER
  • ATS_ACC_SUCC — NUMBER
  • ATS_ACC_FAIL — NUMBER
  • ATS_CON_SUCC — NUMBER
  • ATS_CON_FAIL — NUMBER
  • ATS_SUCC_DATE — VARCHAR2(8 CHAR)
  • ORD_KIND — VARCHAR2(4 CHAR)
  • ORD_PRICE — NUMBER
  • ORD_VAT — NUMBER
  • ORD_AMT — NUMBER
  • ORD_PV1 — NUMBER
  • ORD_PV2 — NUMBER
  • ORD_PV3 — NUMBER
  • DELI_AMT — NUMBER
  • AMT_CARD — NUMBER
  • BUYER_ID — NUMBER
  • DELI_KIND — VARCHAR2(4 CHAR)
  • DELI_NAME — VARCHAR2(100 CHAR)
  • DELI_MOBILE — VARCHAR2(15 CHAR)
  • DELI_TEL — VARCHAR2(15 CHAR)
  • DELI_NT_ID — VARCHAR2(3 CHAR)
  • DELI_POST — VARCHAR2(8 CHAR)
  • DELI_ADDR1 — VARCHAR2(200 CHAR)
  • DELI_ADDR2 — VARCHAR2(200 CHAR)
  • DELI_ADDR3 — VARCHAR2(200 CHAR)
  • DELI_ADDR4 — VARCHAR2(200 CHAR)
  • DELI_E_MAIL — VARCHAR2(100 CHAR)
  • DELI_MEMO — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • PDT_DATE — VARCHAR2(8 BYTE)
  • ATS_DATE_CHANGE — VARCHAR2(8 BYTE)
  • ATS_DATE_BE — VARCHAR2(8 BYTE)
  • AUTO_RENEW — VARCHAR2(1 CHAR)

ATS_3M_ORD

  • REG_ID — NUMBER
  • ATS_ID — NUMBER
  • ATS_ORD_ID — VARCHAR2(50 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ORD_AMT — NUMBER
  • PG_AMT — NUMBER
  • ORD_ID — VARCHAR2(20 CHAR)
  • ORD_AMT_ID — VARCHAR2(20 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • AMT_YN — VARCHAR2(1 CHAR)
  • RESULT_ID — VARCHAR2(20 CHAR)
  • RESULT_MSG — VARCHAR2(100 CHAR)

ATS_3M_ORD_HST

  • REG_ID — NUMBER
  • ATS_ID — VARCHAR2(20 CHAR)
  • ATS_ORD_ID — VARCHAR2(50 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ORD_AMT — NUMBER
  • PG_AMT — NUMBER
  • CARD_NUM — VARCHAR2(60 CHAR)
  • CARD_MONYEAR — VARCHAR2(4 CHAR)
  • CARD_BILL_KEY — VARCHAR2(100 CHAR)
  • AMT_YN — VARCHAR2(1 CHAR)
  • T_ID — VARCHAR2(50 CHAR)
  • STATE_ID — VARCHAR2(20 CHAR)
  • RESULT_ID — VARCHAR2(20 CHAR)
  • RESULT_MSG — VARCHAR2(100 CHAR)
  • CARD_APP — VARCHAR2(20 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

ATS_3M_PDT

  • ATS_ID — NUMBER
  • PDT_ID — VARCHAR2(20 CHAR)
  • QTY — NUMBER
  • PRICE — NUMBER
  • VAT — NUMBER
  • AMT — NUMBER
  • PV1 — NUMBER
  • PV2 — NUMBER
  • PV3 — NUMBER
  • RETAIL_AMT — NUMBER
  • SUPPLY_AMT — NUMBER
  • COST_AMT — NUMBER
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

ATS_CART

  • USER_ID — VARCHAR2(20 CHAR)
  • PDT_ID — VARCHAR2(20 CHAR)
  • QTY — NUMBER
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

ATS_CMS

  • REG_ID — NUMBER
  • ATS_ID — NUMBER
  • BANK_ID — VARCHAR2(3 CHAR)
  • BANK_NAME — VARCHAR2(100 CHAR)
  • BANK_ACC — VARCHAR2(60 CHAR)
  • BANK_DEP — VARCHAR2(100 CHAR)
  • CASH_RCPT_YN — VARCHAR2(1 CHAR)
  • CASH_RCPT_TEL — VARCHAR2(20 CHAR)
  • CASH_RCPT_NO — VARCHAR2(20 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • BIRTHDAY — VARCHAR2(8 CHAR)

ATS_DATE

  • ATS_CNT — NUMBER
  • ATS_KIND — VARCHAR2(4 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ATS_MONTH — VARCHAR2(6 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)

ATS_INFO

  • ATS_ID — NUMBER
  • USER_ID — VARCHAR2(20 CHAR)
  • REG_DATE — VARCHAR2(8 CHAR)
  • USE_YN — VARCHAR2(1 CHAR)
  • CAN_DATE — VARCHAR2(14 CHAR)
  • ATS_SDATE — VARCHAR2(8 CHAR)
  • ATS_EDATE — VARCHAR2(8 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ATS_DATE_NEXT — VARCHAR2(8 CHAR)
  • ATS_KIND — VARCHAR2(4 CHAR)
  • CARD_ID — VARCHAR2(2 CHAR)
  • CARD_NUM — VARCHAR2(60 CHAR)
  • CARD_MON — VARCHAR2(2 CHAR)
  • CARD_OWNER — VARCHAR2(100 CHAR)
  • CARD_MONYEAR — VARCHAR2(4 CHAR)
  • CARD_PW — VARCHAR2(60 CHAR)
  • CARD_CHK_YN — VARCHAR2(1 CHAR)
  • CARD_CHK_DATE — VARCHAR2(14 CHAR)
  • CARD_BILL_KEY — VARCHAR2(100 CHAR)
  • ATS_ACC_OLD — NUMBER
  • ATS_ACC_SUCC_OLD — NUMBER
  • ATS_ACC — NUMBER
  • ATS_ACC_SUCC — NUMBER
  • ATS_ACC_FAIL — NUMBER
  • ATS_CON_SUCC — NUMBER
  • ATS_CON_FAIL — NUMBER
  • ATS_SUCC_DATE — VARCHAR2(8 CHAR)
  • ORD_KIND — VARCHAR2(4 CHAR)
  • ORD_PRICE — NUMBER
  • ORD_VAT — NUMBER
  • ORD_AMT — NUMBER
  • ORD_PV1 — NUMBER
  • ORD_PV2 — NUMBER
  • ORD_PV3 — NUMBER
  • DELI_AMT — NUMBER
  • AMT_CARD — NUMBER
  • BUYER_ID — NUMBER
  • DELI_KIND — VARCHAR2(4 CHAR)
  • DELI_NAME — VARCHAR2(100 CHAR)
  • DELI_MOBILE — VARCHAR2(15 CHAR)
  • DELI_TEL — VARCHAR2(15 CHAR)
  • DELI_NT_ID — VARCHAR2(3 CHAR)
  • DELI_POST — VARCHAR2(8 CHAR)
  • DELI_ADDR1 — VARCHAR2(200 CHAR)
  • DELI_ADDR2 — VARCHAR2(200 CHAR)
  • DELI_ADDR3 — VARCHAR2(200 CHAR)
  • DELI_ADDR4 — VARCHAR2(200 CHAR)
  • DELI_E_MAIL — VARCHAR2(100 CHAR)
  • DELI_MEMO — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • PDT_DATE — VARCHAR2(8 BYTE)
  • ATS_DATE_CHANGE — VARCHAR2(8 BYTE)
  • ATS_DATE_BE — VARCHAR2(8 BYTE)

ATS_ORD

  • REG_ID — NUMBER
  • ATS_ID — NUMBER
  • ATS_ORD_ID — VARCHAR2(50 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ORD_AMT — NUMBER
  • PG_AMT — NUMBER
  • ORD_ID — VARCHAR2(20 CHAR)
  • ORD_AMT_ID — VARCHAR2(20 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • AMT_YN — VARCHAR2(1 CHAR)
  • RESULT_ID — VARCHAR2(20 CHAR)
  • RESULT_MSG — VARCHAR2(100 CHAR)

ATS_ORD_HST

  • REG_ID — NUMBER
  • ATS_ID — VARCHAR2(20 CHAR)
  • ATS_ORD_ID — VARCHAR2(50 CHAR)
  • ATS_DATE — VARCHAR2(8 CHAR)
  • ORD_AMT — NUMBER
  • PG_AMT — NUMBER
  • CARD_NUM — VARCHAR2(60 CHAR)
  • CARD_MONYEAR — VARCHAR2(4 CHAR)
  • CARD_BILL_KEY — VARCHAR2(100 CHAR)
  • AMT_YN — VARCHAR2(1 CHAR)
  • T_ID — VARCHAR2(50 CHAR)
  • STATE_ID — VARCHAR2(20 CHAR)
  • RESULT_ID — VARCHAR2(20 CHAR)
  • RESULT_MSG — VARCHAR2(100 CHAR)
  • CARD_APP — VARCHAR2(20 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

ATS_PDT

  • ATS_ID — NUMBER
  • PDT_ID — VARCHAR2(20 CHAR)
  • QTY — NUMBER
  • PRICE — NUMBER
  • VAT — NUMBER
  • AMT — NUMBER
  • PV1 — NUMBER
  • PV2 — NUMBER
  • PV3 — NUMBER
  • RETAIL_AMT — NUMBER
  • SUPPLY_AMT — NUMBER
  • COST_AMT — NUMBER
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

ATS_PDT_TEMP

  • ATS_ID — NUMBER
  • PDT_ID — VARCHAR2(20 CHAR)
  • QTY — NUMBER
  • PRICE — NUMBER
  • VAT — NUMBER
  • AMT — NUMBER
  • PV1 — NUMBER
  • PV2 — NUMBER
  • PV3 — NUMBER
  • RETAIL_AMT — NUMBER
  • SUPPLY_AMT — NUMBER
  • COST_AMT — NUMBER
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

AUTO_END_DATE

  • USER_ID — VARCHAR2(10 CHAR)
  • END_DATE — VARCHAR2(8 CHAR)
  • PAY_DATE — VARCHAR2(8 CHAR)
  • REMARK — VARCHAR2(150 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)

AUTO_END_DATE_TEMP

  • USER_ID — VARCHAR2(10 CHAR)
  • END_DATE — VARCHAR2(8 CHAR)
  • PAY_DATE — VARCHAR2(8 CHAR)
  • REMARK — VARCHAR2(150 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)

BANK

  • BANK_ID — VARCHAR2(3 CHAR) — 은행코드(000)
  • BANK_NAME — VARCHAR2(100 CHAR) — 은행이름
  • USE_YN — VARCHAR2(1 CHAR) — 사용유무(Y/N)
  • BANK_AMT — NUMBER — 수수료
  • SEND_CODE — VARCHAR2(20 CHAR) — 외부연동
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • SORT_NO — NUMBER — 정렬순서
  • INS_DATE — VARCHAR2(14 CHAR) — 최초등록일시
  • INS_USER — VARCHAR2(20 CHAR) — 최초등록자
  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_USER — VARCHAR2(20 CHAR) — 최종수정자
  • BANK_NAME_EN — VARCHAR2(100 BYTE)

BAT_USER_CNT_ID

  • USER_ID — VARCHAR2(50 CHAR)
  • CNT_ID_OLD — VARCHAR2(50 CHAR)
  • CNT_ID — VARCHAR2(50 CHAR)
  • WORK_DATE — VARCHAR2(50 CHAR)
  • WORK_USER — VARCHAR2(50 CHAR)

BAT_USER_STATE

  • USER_ID — VARCHAR2(50 CHAR)
  • STATE — VARCHAR2(50 CHAR)
  • END_DATE — VARCHAR2(50 CHAR)
  • WORK_DATE — VARCHAR2(50 CHAR)
  • WORK_USER — VARCHAR2(50 CHAR)

BIZ_LOG

  • CMID — VARCHAR2(32 CHAR)
  • UMID — VARCHAR2(32 CHAR)
  • MSG_TYPE — NUMBER(2,0)
  • STATUS — NUMBER(2,0)
  • CALL_STATUS — VARCHAR2(4 CHAR)
  • REQUEST_TIME — DATE
  • SEND_TIME — DATE
  • REPORT_TIME — DATE
  • DEST_PHONE — VARCHAR2(16 CHAR)
  • SEND_PHONE — VARCHAR2(16 CHAR)
  • DEST_NAME — VARCHAR2(32 CHAR)
  • SEND_NAME — VARCHAR2(32 CHAR)
  • SUBJECT — VARCHAR2(64 CHAR)
  • MSG_BODY — VARCHAR2(2000 CHAR)
  • NATION_CODE — VARCHAR2(5 CHAR)
  • SENDER_KEY — VARCHAR2(40 CHAR)
  • TEMPLATE_CODE — VARCHAR2(64 CHAR)
  • RESPONSE_METHOD — VARCHAR2(8 CHAR)
  • TIMEOUT — NUMBER(4,0)
  • RE_TYPE — VARCHAR2(3 CHAR)
  • RE_BODY — VARCHAR2(2000 CHAR)
  • RE_PART — VARCHAR2(1 CHAR)
  • COVER_FLAG — NUMBER(1,0)
  • SMS_FLAG — NUMBER(1,0)
  • REPLY_FLAG — NUMBER(1,0)
  • RETRY_CNT — NUMBER(4,0)
  • ATTACHED_FILE — VARCHAR2(1000 CHAR)
  • VXML_FILE — VARCHAR2(64 CHAR)
  • USE_PAGE — NUMBER(4,0)
  • USE_TIME — NUMBER(4,0)
  • SN_RESULT — NUMBER(1,0)
  • TEL_INFO — VARCHAR2(10 CHAR)
  • CINFO — VARCHAR2(32 CHAR)
  • USER_KEY — VARCHAR2(30 CHAR)
  • AD_FLAG — VARCHAR2(1 CHAR)
  • RCS_REFKEY — VARCHAR2(32 CHAR)
  • WORK_USER — VARCHAR2(20 BYTE)

BIZ_LOG_202309

  • CMID — VARCHAR2(32 CHAR)
  • UMID — VARCHAR2(32 CHAR)
  • MSG_TYPE — NUMBER(2,0)
  • STATUS — NUMBER(2,0)
  • CALL_STATUS — VARCHAR2(4 CHAR)
  • REQUEST_TIME — DATE
  • SEND_TIME — DATE
  • REPORT_TIME — DATE
  • DEST_PHONE — VARCHAR2(16 CHAR)
  • SEND_PHONE — VARCHAR2(16 CHAR)
  • DEST_NAME — VARCHAR2(32 CHAR)
  • SEND_NAME — VARCHAR2(32 CHAR)
  • SUBJECT — VARCHAR2(64 CHAR)
  • MSG_BODY — VARCHAR2(2000 CHAR)
  • NATION_CODE — VARCHAR2(5 CHAR)
  • SENDER_KEY — VARCHAR2(40 CHAR)
  • TEMPLATE_CODE — VARCHAR2(64 CHAR)
  • RESPONSE_METHOD — VARCHAR2(8 CHAR)
  • TIMEOUT — NUMBER(4,0)
  • RE_TYPE — VARCHAR2(3 CHAR)
  • RE_BODY — VARCHAR2(2000 CHAR)
  • RE_PART — VARCHAR2(1 CHAR)
  • COVER_FLAG — NUMBER(1,0)
  • SMS_FLAG — NUMBER(1,0)
  • REPLY_FLAG — NUMBER(1,0)
  • RETRY_CNT — NUMBER(4,0)
  • ATTACHED_FILE — VARCHAR2(1000 CHAR)
  • VXML_FILE — VARCHAR2(64 CHAR)
  • USE_PAGE — NUMBER(4,0)
  • USE_TIME — NUMBER(4,0)
  • SN_RESULT — NUMBER(1,0)
  • TEL_INFO — VARCHAR2(10 CHAR)
  • CINFO — VARCHAR2(32 CHAR)
  • USER_KEY — VARCHAR2(30 CHAR)
  • AD_FLAG — VARCHAR2(1 CHAR)
  • RCS_REFKEY — VARCHAR2(32 CHAR)

BIZ_LOG_MSG

  • MSG_KIND — VARCHAR2(30 CHAR)
  • CALL_STATUS — VARCHAR2(4 CHAR)
  • CALL_MSG — VARCHAR2(300 CHAR)

BIZ_MSG

  • CMID — VARCHAR2(32 CHAR)
  • UMID — VARCHAR2(32 CHAR)
  • MSG_TYPE — NUMBER(2,0)
  • STATUS — NUMBER(2,0)
  • CALL_STATUS — VARCHAR2(4 CHAR)
  • REQUEST_TIME — DATE
  • SEND_TIME — DATE
  • REPORT_TIME — DATE
  • DEST_PHONE — VARCHAR2(16 CHAR)
  • SEND_PHONE — VARCHAR2(16 CHAR)
  • DEST_NAME — VARCHAR2(32 CHAR)
  • SEND_NAME — VARCHAR2(32 CHAR)
  • SUBJECT — VARCHAR2(64 CHAR)
  • MSG_BODY — VARCHAR2(2000 CHAR)
  • NATION_CODE — VARCHAR2(5 CHAR)
  • SENDER_KEY — VARCHAR2(40 CHAR)
  • TEMPLATE_CODE — VARCHAR2(64 CHAR)
  • RESPONSE_METHOD — VARCHAR2(8 CHAR)
  • TIMEOUT — NUMBER(4,0)
  • RE_TYPE — VARCHAR2(3 CHAR)
  • RE_BODY — VARCHAR2(2000 CHAR)
  • RE_PART — VARCHAR2(1 CHAR)
  • COVER_FLAG — NUMBER(1,0)
  • SMS_FLAG — NUMBER(1,0)
  • REPLY_FLAG — NUMBER(1,0)
  • RETRY_CNT — NUMBER(4,0)
  • ATTACHED_FILE — VARCHAR2(1000 CHAR)
  • VXML_FILE — VARCHAR2(64 CHAR)
  • USE_PAGE — NUMBER(4,0)
  • USE_TIME — NUMBER(4,0)
  • SN_RESULT — NUMBER(1,0)
  • TEL_INFO — VARCHAR2(10 CHAR)
  • CINFO — VARCHAR2(32 CHAR)
  • USER_KEY — VARCHAR2(30 CHAR)
  • AD_FLAG — VARCHAR2(1 CHAR)
  • RCS_REFKEY — VARCHAR2(32 CHAR)
  • WORK_USER — VARCHAR2(20 BYTE)

CARD

  • CARD_ID — VARCHAR2(3 CHAR) — 카드사코드
  • CARD_NAME — VARCHAR2(100 CHAR) — 카드사명
  • USE_YN — VARCHAR2(1 CHAR) — 사용유무
  • PG_SETTLEBANK — VARCHAR2(10 CHAR) — PG
  • PG_KSNET — VARCHAR2(10 CHAR) — PG
  • PG_KSNET_AUTH — VARCHAR2(10 CHAR) — PG
  • PG_PAYLETTER — VARCHAR2(10 BYTE)
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • SORT_NO — NUMBER — 정렬순서
  • INS_DATE — VARCHAR2(14 CHAR) — 최초등록일시
  • INS_USER — VARCHAR2(20 CHAR) — 최초등록자
  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_USER — VARCHAR2(20 CHAR) — 최종수정자
  • CARD_NAME_EN — VARCHAR2(100 BYTE)

HST_ATS_INFO_SP

  • WORK_DATE — VARCHAR2(100 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_KIND — VARCHAR2(100 CHAR)
  • ATS_ID — NUMBER
  • USER_ID — VARCHAR2(100 CHAR)
  • REG_DATE — VARCHAR2(10 CHAR)
  • USE_YN — VARCHAR2(100 CHAR)
  • CAN_DATE — VARCHAR2(100 CHAR)
  • ATS_SDATE — VARCHAR2(100 CHAR)
  • ATS_EDATE — VARCHAR2(100 CHAR)
  • ATS_DATE — VARCHAR2(100 CHAR)
  • ATS_DATE_NEXT — VARCHAR2(100 CHAR)
  • ATS_KIND — VARCHAR2(100 CHAR)
  • CARD_ID — VARCHAR2(100 CHAR)
  • CARD_NUM — VARCHAR2(100 CHAR)
  • CARD_MON — VARCHAR2(100 CHAR)
  • CARD_OWNER — VARCHAR2(100 CHAR)
  • CARD_MONYEAR — VARCHAR2(100 CHAR)
  • CARD_PW — VARCHAR2(100 CHAR)
  • CARD_CHK_YN — VARCHAR2(100 CHAR)
  • CARD_CHK_DATE — VARCHAR2(100 CHAR)
  • CARD_BILL_KEY — VARCHAR2(100 CHAR)
  • ATS_ACC — NUMBER
  • ATS_ACC_SUCC — NUMBER
  • ATS_ACC_FAIL — NUMBER
  • ATS_CON_SUCC — NUMBER
  • ATS_CON_FAIL — NUMBER
  • ATS_SUCC_DATE — VARCHAR2(100 CHAR)
  • ORD_KIND — VARCHAR2(100 CHAR)
  • ORD_PRICE — NUMBER
  • ORD_VAT — NUMBER
  • ORD_AMT — NUMBER
  • ORD_PV1 — NUMBER
  • ORD_PV2 — NUMBER
  • ORD_PV3 — NUMBER
  • DELI_AMT — NUMBER
  • AMT_CARD — NUMBER
  • BUYER_ID — NUMBER
  • DELI_KIND — VARCHAR2(100 CHAR)
  • DELI_NAME — VARCHAR2(200 CHAR)
  • DELI_MOBILE — VARCHAR2(100 CHAR)
  • DELI_TEL — VARCHAR2(100 CHAR)
  • DELI_NT_ID — VARCHAR2(100 CHAR)
  • DELI_POST — VARCHAR2(100 CHAR)
  • DELI_ADDR1 — VARCHAR2(300 CHAR)
  • DELI_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_ADDR3 — VARCHAR2(300 CHAR)
  • DELI_ADDR4 — VARCHAR2(300 CHAR)
  • DELI_E_MAIL — VARCHAR2(200 CHAR)
  • DELI_MEMO — VARCHAR2(200 CHAR)
  • REMARK — VARCHAR2(400 CHAR)
  • INS_DATE — VARCHAR2(100 CHAR)
  • INS_USER — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR)

HST_ATS_ORD_SP

  • WORK_DATE — VARCHAR2(100 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_KIND — VARCHAR2(100 CHAR)
  • ATS_ID — VARCHAR2(100 CHAR)
  • ATS_ORD_ID — VARCHAR2(100 CHAR)
  • ATS_DATE — VARCHAR2(100 CHAR)
  • ORD_AMT — VARCHAR2(100 CHAR)
  • PG_AMT — VARCHAR2(100 CHAR)
  • CARD_NUM — VARCHAR2(100 CHAR)
  • CARD_MONYEAR — VARCHAR2(100 CHAR)
  • CARD_BILL_KEY — VARCHAR2(300 CHAR)
  • AMT_YN — VARCHAR2(100 CHAR)
  • T_ID — VARCHAR2(100 CHAR)
  • STATE_ID — VARCHAR2(100 CHAR)
  • RESULT_ID — VARCHAR2(100 CHAR)
  • RESULT_MSG — VARCHAR2(100 CHAR)
  • CARD_APP — VARCHAR2(100 CHAR)
  • INS_DATE — VARCHAR2(100 CHAR)
  • INS_USER — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR)

HST_DELI_INVOICE_SP

  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_NO — NUMBER
  • ORD_DELI_ID — VARCHAR2(50 CHAR)
  • INVOICE_NO — VARCHAR2(200 CHAR)

HST_LINK_INVOICE_SP

  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • DELI_COM_ID — VARCHAR2(100 CHAR)
  • INVOICE_NO — VARCHAR2(200 CHAR)
  • REMARK — VARCHAR2(200 CHAR)

HST_LINK_ORD_SP

  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • BUYER_NAME — VARCHAR2(100 CHAR)
  • BUYER_MOBILE — VARCHAR2(100 CHAR)
  • BUYER_EMAIL — VARCHAR2(100 CHAR)
  • BUYER_POST — VARCHAR2(100 CHAR)
  • BUYER_ADDR1 — VARCHAR2(300 CHAR)
  • BUYER_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_NAME — VARCHAR2(100 CHAR)
  • DELI_MOBILE — VARCHAR2(100 CHAR)
  • DELI_POST — VARCHAR2(100 CHAR)
  • DELI_ADDR1 — VARCHAR2(300 CHAR)
  • DELI_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_MEMO — VARCHAR2(300 CHAR)
  • PDTS_NAME — VARCHAR2(100 CHAR)
  • ORD_AMT — VARCHAR2(100 CHAR)
  • ORD_PV1 — VARCHAR2(100 CHAR)
  • ORD_PV2 — VARCHAR2(100 CHAR)
  • ORD_PV3 — VARCHAR2(100 CHAR)
  • CURRENCY_TYPE — VARCHAR2(100 CHAR)
  • AMT_KIND — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(100 CHAR)

HST_LINK_ORD_SP2

  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • BUYER_NAME — VARCHAR2(100 CHAR)
  • BUYER_MOBILE — VARCHAR2(100 CHAR)
  • BUYER_EMAIL — VARCHAR2(100 CHAR)
  • BUYER_POST — VARCHAR2(100 CHAR)
  • BUYER_ADDR1 — VARCHAR2(300 CHAR)
  • BUYER_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_NAME — VARCHAR2(100 CHAR)
  • DELI_MOBILE — VARCHAR2(100 CHAR)
  • DELI_POST — VARCHAR2(100 CHAR)
  • DELI_ADDR1 — VARCHAR2(300 CHAR)
  • DELI_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_MEMO — VARCHAR2(300 CHAR)
  • PDTS_NAME — VARCHAR2(100 CHAR)
  • ORD_AMT — VARCHAR2(100 CHAR)
  • ORD_PV1 — VARCHAR2(100 CHAR)
  • CURRENCY_TYPE — VARCHAR2(100 CHAR)
  • AMT_KIND — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(100 CHAR)
  • ORD_PV2 — NUMBER
  • ORD_PV3 — NUMBER

HST_MEMBER_SP

  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_KIND — VARCHAR2(100 CHAR) — 등록경로(1601:ERP
  • USER_ID — VARCHAR2(100 CHAR)
  • USER_NAME — VARCHAR2(100 CHAR)
  • FIRST_NAME — VARCHAR2(100 CHAR)
  • LAST_NAME — VARCHAR2(100 CHAR)
  • REG_DATE — VARCHAR2(100 CHAR)
  • STATE — VARCHAR2(100 CHAR)
  • END_DATE — VARCHAR2(100 CHAR)
  • USER_KIND — VARCHAR2(100 CHAR)
  • JUMIN_BIRTH — VARCHAR2(100 CHAR)
  • JUMIN_LAST — VARCHAR2(100 CHAR)
  • BIRTHDAY — VARCHAR2(100 CHAR)
  • BIRTHDAY_KIND — VARCHAR2(100 CHAR)
  • LOGIN_ID — VARCHAR2(100 CHAR)
  • PASS — VARCHAR2(300 CHAR)
  • CNT_ID — VARCHAR2(100 CHAR)
  • P_ID — VARCHAR2(100 CHAR)
  • P_POS — VARCHAR2(100 CHAR)
  • R_ID — VARCHAR2(100 CHAR)
  • GRP_ID — VARCHAR2(100 CHAR)
  • BANK_ID — VARCHAR2(100 CHAR)
  • BANK_ACC — VARCHAR2(100 CHAR)
  • BANK_DEP — VARCHAR2(100 CHAR)
  • MOBILE — VARCHAR2(100 CHAR)
  • TEL — VARCHAR2(100 CHAR)
  • E_MAIL — VARCHAR2(100 CHAR)
  • NT_ID — VARCHAR2(100 CHAR)
  • POST — VARCHAR2(100 CHAR)
  • ADDR1 — VARCHAR2(300 CHAR)
  • ADDR2 — VARCHAR2(300 CHAR)
  • ADDR3 — VARCHAR2(300 CHAR)
  • ADDR4 — VARCHAR2(300 CHAR)
  • HOMEPAGE — VARCHAR2(100 CHAR)
  • SMS_YN — VARCHAR2(100 CHAR)
  • MAIL_YN — VARCHAR2(100 CHAR)
  • EDU_DATE — VARCHAR2(100 CHAR)
  • REGIST_CARD_DATE — VARCHAR2(100 CHAR)
  • MEMBER_BOOK_DATE — VARCHAR2(100 CHAR)
  • VISA — VARCHAR2(100 CHAR)
  • LICENSE_NO — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR) — 최종수정자

HST_ORD_AMT_PG_CANCEL_SP

  • WORK_DATE — VARCHAR2(50 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • CART_YN — VARCHAR2(1 CHAR)
  • PG_MID — VARCHAR2(100 CHAR)
  • ORD_AMT_ID — VARCHAR2(100 CHAR)
  • T_VER — VARCHAR2(100 CHAR)
  • T_METHOD — VARCHAR2(100 CHAR)
  • T_BIZ_TYPE — VARCHAR2(100 CHAR)
  • T_ENC_KIND — VARCHAR2(100 CHAR)
  • T_DATE — VARCHAR2(100 CHAR)
  • T_TIME — VARCHAR2(100 CHAR)
  • T_HASH — VARCHAR2(100 CHAR)
  • PDT_NAME — VARCHAR2(100 CHAR)
  • USER_NAME — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • CARD_NO — VARCHAR2(100 CHAR)
  • JUMIN — VARCHAR2(100 CHAR)
  • CARD_MON — VARCHAR2(100 CHAR)
  • CARD_YEAR — VARCHAR2(100 CHAR)
  • CARD_PW — VARCHAR2(100 CHAR)
  • CARD_PLAN — VARCHAR2(100 CHAR)
  • PG_UNIT — VARCHAR2(100 CHAR)
  • PG_AMT — VARCHAR2(100 CHAR)
  • T_YN — VARCHAR2(100 CHAR)
  • T_ID — VARCHAR2(100 CHAR)
  • T_STATE_ID — VARCHAR2(100 CHAR)
  • T_RESULT_ID — VARCHAR2(100 CHAR)
  • T_RESULT_MSG — VARCHAR2(300 CHAR)
  • T_AMT — VARCHAR2(100 CHAR)
  • T_BILLKEY — VARCHAR2(100 CHAR)
  • T_CARD_ID — VARCHAR2(100 CHAR)
  • T_CARD_NAME — VARCHAR2(100 CHAR)
  • T_CARD_KIND — VARCHAR2(100 CHAR)
  • T_NO_INTEREST — VARCHAR2(100 CHAR)
  • T_CARD_APP — VARCHAR2(100 CHAR)
  • ORGTRDNO — VARCHAR2(100 CHAR)
  • CNCLAMT — VARCHAR2(100 CHAR)
  • CARDCNCLAMT — VARCHAR2(100 CHAR)
  • PNTCNCLAMT — VARCHAR2(100 CHAR)
  • BLCAMT — VARCHAR2(100 CHAR)
  • VACNTNO — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR)
  • MENU_ID — VARCHAR2(100 CHAR)
  • MENU_NAME — VARCHAR2(100 CHAR)

HST_ORD_AMT_PG_SP

  • WORK_DATE — VARCHAR2(50 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • CART_YN — VARCHAR2(1 CHAR)
  • PG_MID — VARCHAR2(100 CHAR)
  • ORD_AMT_ID — VARCHAR2(100 CHAR)
  • T_VER — VARCHAR2(100 CHAR)
  • T_METHOD — VARCHAR2(100 CHAR)
  • T_BIZ_TYPE — VARCHAR2(100 CHAR)
  • T_ENC_KIND — VARCHAR2(100 CHAR)
  • T_DATE — VARCHAR2(100 CHAR)
  • T_TIME — VARCHAR2(100 CHAR)
  • T_HASH — VARCHAR2(100 CHAR)
  • PDT_NAME — VARCHAR2(100 CHAR)
  • USER_NAME — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • CARD_NO — VARCHAR2(100 CHAR)
  • JUMIN — VARCHAR2(100 CHAR)
  • CARD_MON — VARCHAR2(100 CHAR)
  • CARD_YEAR — VARCHAR2(100 CHAR)
  • CARD_PW — VARCHAR2(100 CHAR)
  • CARD_PLAN — VARCHAR2(100 CHAR)
  • PG_UNIT — VARCHAR2(100 CHAR)
  • PG_AMT — VARCHAR2(100 CHAR)
  • T_YN — VARCHAR2(100 CHAR)
  • T_ID — VARCHAR2(100 CHAR)
  • T_STATE_ID — VARCHAR2(100 CHAR)
  • T_RESULT_ID — VARCHAR2(100 CHAR)
  • T_RESULT_MSG — VARCHAR2(300 CHAR)
  • T_AMT — VARCHAR2(100 CHAR)
  • T_BILLKEY — VARCHAR2(100 CHAR)
  • T_CARD_ID — VARCHAR2(100 CHAR)
  • T_CARD_NAME — VARCHAR2(100 CHAR)
  • T_CARD_KIND — VARCHAR2(100 CHAR)
  • T_NO_INTEREST — VARCHAR2(100 CHAR)
  • T_CARD_APP — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR)
  • MENU_ID — VARCHAR2(100 CHAR)
  • MENU_NAME — VARCHAR2(100 CHAR)

HST_ORD_AMT_SP

  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_KIND — VARCHAR2(100 CHAR)
  • ORD_AMT_ID — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • AMT_KIND — VARCHAR2(100 CHAR)
  • AMT_STATE — VARCHAR2(100 CHAR)
  • AMT — NUMBER
  • BANK_BOOK_ID — VARCHAR2(100 CHAR)
  • VIR_BANK_ID — VARCHAR2(100 CHAR)
  • VIR_BANK_ACC — VARCHAR2(30 CHAR)
  • VIR_BANK_DEP — VARCHAR2(100 CHAR)
  • BANK_SENDER — VARCHAR2(100 CHAR)
  • BANK_DATE — VARCHAR2(100 CHAR)
  • RCPT_YN — VARCHAR2(100 CHAR)
  • RCPT_TEL — VARCHAR2(100 CHAR)
  • RCPT_NO — VARCHAR2(100 CHAR)
  • CARD_ID — VARCHAR2(100 CHAR)
  • CARD_NUM — VARCHAR2(100 CHAR)
  • CARD_MON — VARCHAR2(100 CHAR)
  • CARD_OWNER — VARCHAR2(100 CHAR)
  • CARD_MONYEAR — VARCHAR2(100 CHAR)
  • CARD_PW — VARCHAR2(100 CHAR)
  • CARD_APP — VARCHAR2(100 CHAR)
  • CARD_DATE — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • WORK_USER — VARCHAR2(100 CHAR) — 최종수정자

HST_ORD_INFO_SP

  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_KIND — VARCHAR2(100 CHAR) — 등록경로(1601:ERP
  • ORD_ID — VARCHAR2(100 CHAR)
  • ORD_KIND — VARCHAR2(100 CHAR)
  • ORD_DATE — VARCHAR2(100 CHAR)
  • PAY_DATE — VARCHAR2(100 CHAR)
  • AMT_DATE — VARCHAR2(100 CHAR)
  • CAN_DATE — VARCHAR2(100 CHAR)
  • USER_ID — VARCHAR2(100 CHAR)
  • CNT_ID — VARCHAR2(100 CHAR)
  • DELI_KIND — VARCHAR2(100 CHAR)
  • DELI_NAME — VARCHAR2(100 CHAR)
  • DELI_MOBILE — VARCHAR2(100 CHAR)
  • DELI_TEL — VARCHAR2(100 CHAR)
  • DELI_NT_ID — VARCHAR2(100 CHAR)
  • DELI_POST — VARCHAR2(100 CHAR)
  • DELI_ADDR1 — VARCHAR2(300 CHAR)
  • DELI_ADDR2 — VARCHAR2(300 CHAR)
  • DELI_ADDR3 — VARCHAR2(300 CHAR)
  • DELI_ADDR4 — VARCHAR2(300 CHAR)
  • DELI_E_MAIL — VARCHAR2(100 CHAR)
  • DELI_MEMO — VARCHAR2(300 CHAR)
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • WORK_USER — VARCHAR2(100 CHAR) — 최종수정자

HST_ORD_PDT_SELL_SP

  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_KIND — VARCHAR2(100 CHAR)
  • REG_KIND — VARCHAR2(100 CHAR)
  • REG_ID — VARCHAR2(100 CHAR)
  • BUYER_ID — VARCHAR2(100 CHAR)
  • REG_DATE — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • ORD_PDT_ID — VARCHAR2(100 CHAR)
  • PDT_ID — VARCHAR2(100 CHAR)
  • PDT_AMT — VARCHAR2(100 CHAR)
  • PDT_QTY — VARCHAR2(100 CHAR)
  • BOM_ID — VARCHAR2(100 CHAR)
  • BOM_AMT — VARCHAR2(100 CHAR)
  • BOM_QTY — VARCHAR2(100 CHAR)
  • USE_YN — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(100 CHAR)
  • WORK_USER — VARCHAR2(100 CHAR)

HST_ORD_PDT_SP

  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_KIND — VARCHAR2(100 CHAR)
  • ORD_PDT_ID — VARCHAR2(100 CHAR)
  • ORD_ID — VARCHAR2(100 CHAR)
  • PDT_ID — VARCHAR2(20 CHAR)
  • DELI_KIND — VARCHAR2(100 CHAR)
  • QTY — NUMBER
  • RET_ORD_PDT_ID — VARCHAR2(100 CHAR)
  • PDT_VCODE — VARCHAR2(100 CHAR)
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • WORK_USER — VARCHAR2(100 CHAR) — 최종수정자

IQ_REPORT_USER

  • PKID — NUMBER(*,0)
  • ID — VARCHAR2(50 CHAR)
  • PASSWORD — VARCHAR2(50 CHAR)
  • NAME — VARCHAR2(50 CHAR)
  • STATUS — NUMBER(*,0)
  • WDATE — DATE
  • REG_ID — NUMBER(*,0)

JOB_LOG

  • IDX — NUMBER
  • JOB_NAME — VARCHAR2(30 BYTE)
  • JOB_SDATE — DATE
  • JOB_EDATE — DATE
  • REMARK — VARCHAR2(200 BYTE) — 비고사항

JOB_RESULT

  • KIND — VARCHAR2(3 BYTE)
  • KIND_TEXT — VARCHAR2(50 BYTE)
  • JOB_NAME — VARCHAR2(50 BYTE)
  • CALC_DATE — VARCHAR2(8 BYTE)
  • CALC_TIME — VARCHAR2(30 BYTE)
  • CALC_USER — VARCHAR2(8 BYTE)
  • REMARK — VARCHAR2(500 BYTE) — 비고사항

MEMBER

  • REG_ID — NUMBER — 등록순서(SQ_MEMBER)
  • USER_ID — VARCHAR2(10 CHAR) — 회원
  • USER_NAME — VARCHAR2(100 CHAR) — 회원
  • FIRST_NAME — VARCHAR2(100 CHAR) — 영문
  • LAST_NAME — VARCHAR2(100 CHAR) — 영문
  • REG_DATE — VARCHAR2(8 CHAR) — 등록일자
  • STATE — VARCHAR2(4 CHAR) — Foreign key — 상태(2000:탈퇴
  • END_DATE — VARCHAR2(8 CHAR) — 탈퇴일자
  • JUMIN_BIRTH — VARCHAR2(8 CHAR) — 법정생년월일(20200101)
  • GENDER — VARCHAR2(4 CHAR) — Foreign key — 성별(M:남성
  • JUMIN_LAST — VARCHAR2(60 CHAR) — 주민번호뒷7자리(암호화)
  • JUMIN_DATE — VARCHAR2(8 CHAR) — 주민번호
  • BIRTHDAY — VARCHAR2(8 CHAR) — 실제생일
  • BIRTHDAY_KIND — VARCHAR2(1 CHAR) — S:양력
  • LOGIN_ID — VARCHAR2(20 CHAR) — 로그인아이디
  • PASS — VARCHAR2(300 CHAR) — 패스워드(복호불가암호화)
  • SECRET_ID — VARCHAR2(10 CHAR) — 비밀아이디(웹연동에사용)
  • USER_KIND — VARCHAR2(4 CHAR) — Foreign key — 회원구분
  • USER_KIND_NAME — VARCHAR2(100 CHAR) — 회원구분명
  • RANK_ID — VARCHAR2(2 CHAR) — Foreign key — 직급코드
  • RANK_NAME — VARCHAR2(100 CHAR) — 직급명
  • RANK_ID_MAX — VARCHAR2(2 CHAR) — Foreign key — 최고직급코드
  • RANK_NAME_MAX — VARCHAR2(100 CHAR) — 최고직급코드명
  • RANK_PAY_DATE — VARCHAR2(8 CHAR)
  • RANK_WORK_DATE — VARCHAR2(14 CHAR)
  • CNT_ID — VARCHAR2(5 CHAR) — 센터코드
  • CNT_NAME — VARCHAR2(100 CHAR) — 센터명
  • P_ID — VARCHAR2(10 CHAR) — Foreign key → MEMBER.USER_ID — 후원인아이디
  • P_NAME — VARCHAR2(100 CHAR) — 후원인명
  • P_POS — NUMBER — 후원포지션
  • R_ID — VARCHAR2(10 CHAR) — Foreign key → MEMBER.USER_ID — 추천인아이디
  • R_NAME — VARCHAR2(100 CHAR) — 추천인명
  • GRP_ID — VARCHAR2(10 CHAR) — 그룹아이디
  • GRP_NAME — VARCHAR2(100 CHAR) — 그룹명
  • GRP2_ID — VARCHAR2(10 BYTE)
  • GRP2_NAME — VARCHAR2(100 BYTE)
  • GRP3_ID — VARCHAR2(10 BYTE)
  • GRP3_NAME — VARCHAR2(100 BYTE)
  • BANK_ID — VARCHAR2(3 CHAR) — Foreign key → BANK.BANK_ID — 은행코드
  • BANK_NAME — VARCHAR2(100 CHAR) — 은행명
  • BANK_ACC — VARCHAR2(60 CHAR) — 계좌번호(암호화)
  • BANK_DEP — VARCHAR2(100 CHAR) — 예금주
  • MOBILE — VARCHAR2(15 CHAR) — 휴대폰번호
  • TEL — VARCHAR2(15 CHAR) — 전화번호
  • E_MAIL — VARCHAR2(100 CHAR) — 이메일주소
  • NT_ID — VARCHAR2(3 CHAR) — Foreign key — 국가코드
  • NT_NAME — VARCHAR2(100 CHAR) — 국가명
  • POST — VARCHAR2(8 CHAR) — 우편번호
  • ADDR1 — VARCHAR2(200 CHAR) — 주소
  • ADDR2 — VARCHAR2(200 CHAR) — 상세주소
  • ADDR3 — VARCHAR2(200 CHAR) — 주소추가1
  • ADDR4 — VARCHAR2(200 CHAR) — 주소추가2
  • HOMEPAGE — VARCHAR2(100 CHAR) — 홈페이지주소
  • LIC_NO — VARCHAR2(12 CHAR) — 사업자등록번호
  • LIC_NAME — VARCHAR2(100 CHAR) — 사업장명
  • LIC_KIND — VARCHAR2(4 BYTE) — 법인구분(1401:개인
  • LIC_CEO — VARCHAR2(100 CHAR) — 대표이사
  • LIC_CLASS — VARCHAR2(100 CHAR) — 업태
  • LIC_ITEM — VARCHAR2(100 CHAR) — 업종
  • LIC_POST — VARCHAR2(8 CHAR) — 회사우편번호
  • … +31

MEMBER_AMT_ETC

  • REG_NO — NUMBER
  • USER_ID — VARCHAR2(10 CHAR)
  • ETC_KIND — VARCHAR2(4 CHAR)
  • AMT_DATE — VARCHAR2(8 CHAR)
  • AMT — NUMBER
  • USE_YN — VARCHAR2(1 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

MEMBER_CHANGE

  • REG_NO — NUMBER — 일련번호
  • USER_ID — VARCHAR2(10 CHAR) — 회원ID
  • CHANGE_KIND — VARCHAR2(4 CHAR) — Foreign key — 변경항목(2901:이름
  • CHANGE_DATE — VARCHAR2(8 CHAR) — 변경일자
  • CHANGE_BEFORE — VARCHAR2(500 CHAR) — 변경전값
  • CHANGE_AFTER — VARCHAR2(500 CHAR) — 변경후값
  • REG_KIND — VARCHAR2(4 CHAR) — Foreign key — 등록경로(1601:ERP
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • INS_DATE — VARCHAR2(14 CHAR) — 최초등록일시
  • INS_USER — VARCHAR2(20 CHAR) — 최초등록자
  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_USER — VARCHAR2(20 CHAR) — 최종수정자

MEMBER_CRM

  • REG_NO — NUMBER
  • USER_ID — VARCHAR2(10 CHAR)
  • REG_DATE — VARCHAR2(8 CHAR)
  • CRM_KIND — VARCHAR2(4 CHAR)
  • CRM_STATE — VARCHAR2(4 CHAR)
  • CRM_Q — VARCHAR2(1000 CHAR)
  • CRM_A — VARCHAR2(1000 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

MEMBER_DATE

  • REG_NO — NUMBER
  • USER_ID — VARCHAR2(10 CHAR)
  • MEM_DATE_KIND — VARCHAR2(4 CHAR)
  • REG_DATE — VARCHAR2(8 CHAR)
  • FILEPATH — VARCHAR2(300 CHAR)
  • SET1_DATE — VARCHAR2(14 CHAR)
  • SET1_USER — VARCHAR2(20 CHAR)
  • SET2_DATE — VARCHAR2(14 CHAR)
  • SET2_USER — VARCHAR2(20 CHAR)
  • SET3_DATE — VARCHAR2(14 CHAR)
  • SET3_USER — VARCHAR2(20 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

MEMBER_DELI

  • REG_NO — NUMBER — 일련번호
  • USER_ID — VARCHAR2(10 CHAR) — 회원번호
  • DELI_NAME — VARCHAR2(100 CHAR) — 주소록
  • RCPT_NAME — VARCHAR2(100 CHAR) — 받는사람
  • DELI_MOBILE — VARCHAR2(15 CHAR) — 휴대폰번호
  • DELI_TEL — VARCHAR2(15 CHAR) — 전화번호
  • DELI_NT_ID — VARCHAR2(3 CHAR) — Foreign key — 국가
  • DELI_POST — VARCHAR2(8 CHAR) — 우편번호
  • DELI_ADDR1 — VARCHAR2(200 CHAR) — 주소
  • DELI_ADDR2 — VARCHAR2(200 CHAR) — 상세주소
  • DELI_ADDR3 — VARCHAR2(200 CHAR) — 주소추가1
  • DELI_ADDR4 — VARCHAR2(200 CHAR) — 주소추가2
  • DELI_E_MAIL — VARCHAR2(100 CHAR) — 이메일
  • DELI_MEMO — VARCHAR2(100 CHAR) — 배송메모
  • REG_KIND — VARCHAR2(4 CHAR) — 등록경로(1601:ERP
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_USER — VARCHAR2(20 CHAR) — 최종수정자

MEMBER_LINE

  • REG_NO — NUMBER — 일련번호
  • USER_ID — VARCHAR2(10 CHAR) — 회원아이디
  • LINE_DATE — VARCHAR2(8 CHAR) — 변경일자
  • P_ID_BE — VARCHAR2(10 CHAR) — 변경전후원인아이디
  • P_POS_BE — NUMBER — 변경전후원포지션
  • R_ID_BE — VARCHAR2(10 CHAR) — 변경전추천인아이디
  • P_ID — VARCHAR2(10 CHAR) — 변경된후원인아이디
  • P_POS — NUMBER — 변경된후원포지션
  • R_ID — VARCHAR2(10 CHAR) — 변경된추천인아이디
  • REG_KIND — VARCHAR2(4 CHAR) — 등록경로(1601:ERP
  • REMARK — VARCHAR2(300 CHAR) — 비고사항
  • INS_DATE — VARCHAR2(14 CHAR) — 최초등록일시
  • INS_USER — VARCHAR2(20 CHAR) — 최초등록자
  • WORK_DATE — VARCHAR2(14 CHAR) — 최종수정일시
  • WORK_USER — VARCHAR2(20 CHAR) — 최종수정자

MEMBER_ORD_PV

  • REG_NO — NUMBER
  • KIND_ID — VARCHAR2(4 CHAR) — Foreign key
  • USER_ID — VARCHAR2(10 CHAR)
  • ORD_AMT — NUMBER
  • ORD_PV1 — NUMBER
  • ORD_PV2 — NUMBER
  • ORD_PV3 — NUMBER
  • USE_YN — VARCHAR2(1 CHAR)
  • PAY_DATE — VARCHAR2(8 CHAR)
  • ORD_ID — VARCHAR2(20 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

MEMBER_PAY_AB

  • USER_ID — VARCHAR2(10 CHAR)
  • PAY_DATE — VARCHAR2(8 CHAR)
  • A_PV_BE — NUMBER
  • B_PV_BE — NUMBER
  • C_PV_BE — NUMBER
  • USE_YN — VARCHAR2(1 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)

MEMBER_PAY_ADJUST

  • REG_NO — NUMBER
  • USER_ID — VARCHAR2(10 CHAR)
  • PAY_ID — VARCHAR2(5 CHAR)
  • PAY_DATE — VARCHAR2(8 CHAR)
  • AMT — NUMBER
  • USE_YN — VARCHAR2(1 CHAR)
  • REMARK — VARCHAR2(300 CHAR)
  • REG_KIND — VARCHAR2(4 CHAR)
  • INS_DATE — VARCHAR2(14 CHAR)
  • INS_USER — VARCHAR2(20 CHAR)
  • WORK_DATE — VARCHAR2(14 CHAR)
  • WORK_USER — VARCHAR2(20 CHAR)