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)