듀벨업무사이트_판매&상담

테이블 (33)

P_lclass

  • l_code — int — 기본 키 — NOT NULL
  • lclass_name — varchar(200) — NOT NULL
  • wdate — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • turn — tinyint

P_master

  • idx — int — 기본 키 — NOT NULL
  • l_code — int — NOT NULL
  • m_code — int — NOT NULL
  • s_code — int — NOT NULL
  • p_name — varchar(200) — NOT NULL
  • p_price — int
  • p_code — varchar(50) — 현재 미사용
  • p_barcode — char(14) — NOT NULL
  • wdate — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • sch_text — text
  • each_num — int
  • v_chk — char(1) — NOT NULL
  • p_weight1 — float — 현재 사용안함
  • p_weight2 — float — 현재 사용안함
  • refilstandard_chk — char(1) — NOT NULL
  • admin — int
  • re_mat_code — nvarchar(30)
  • re_mat_use_count — float
  • ABAIL — float

P_master_part

  • idx — int — 기본 키 — NOT NULL
  • pmaster_idx — int — NOT NULL
  • pro_idx — int — NOT NULL
  • pro_count — int — NOT NULL
  • tmp_pmaster_idx — int

P_master_refil

  • idx — int — 기본 키 — NOT NULL
  • pmaster_idx — int — NOT NULL
  • refil_count — int — NOT NULL
  • pro_idx — int
  • tmp_pmaster_idx — int

P_mat

  • idx — int — 기본 키 — NOT NULL
  • pro_idx — int — NOT NULL
  • mat_idx — int — mat_master2 : idx (현재 미사용)
  • mat_code — nvarchar(30)
  • mat_unit — nvarchar(20)
  • use_count — float — NOT NULL
  • regdate — datetime — NOT NULL
  • warehousing — varchar(20)
  • customer_code — varchar(20)

P_mclass

  • m_code — int — 기본 키 — NOT NULL
  • l_code — int — 외래 키 → P_lclass.l_code — NOT NULL
  • mclass_name — varchar(200) — NOT NULL
  • wdate — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • turn — tinyint

P_sclass

  • s_code — int — 기본 키 — NOT NULL
  • m_code2 — int — 외래 키 → P_mclass.m_code — NOT NULL
  • l_code2 — int — 외래 키 → P_mclass.l_code — NOT NULL
  • sclass_name — varchar(200) — NOT NULL
  • wdate — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • turn — tinyint

TTB

  • idx — int — 기본 키 — NOT NULL
  • gubun — varchar(20)
  • buyer — varchar(50)
  • receiver — varchar(50)
  • rec_zipcode — varchar(15)
  • rec_addr — varchar(300)
  • rec_phone1 — varchar(40)
  • rec_phone2 — varchar(40)
  • buy_num — int
  • sum_money — float
  • deliver_charge — varchar(20)
  • ori_choice_order — varchar(2000)
  • choice_order — varchar(2000)
  • choice_order1 — varchar(500) — 경우에 따라 choice_order1사용
  • add_order — varchar(500)
  • requirement — varchar(500)
  • buy_phone1 — varchar(40)
  • wdate — datetime
  • status — char(2)
  • status_mat — char(2) — 현재 미사용이나 주문엑셀업로드시 값이 'N'으로 들어가고 있음. 삭제하려면 소스수정 필요
  • cancel_date — datetime
  • memo — text
  • input_bank — tinyint
  • admin — int
  • waybill_num — char(14)
  • send_chk — char(1)
  • delivery_chk — char(1) — 현재 미사용
  • customer — nvarchar(20) — NOT NULL — 주문사이트가 거래처인 경우 추가로 들어감(거래처코드)
  • order_num — varchar(50)
  • d_chk — char(1) — NOT NULL
  • tmp_idx — int
  • sabang_ordernum — varchar(50)
  • repre_phone1 — varchar(40) — 택배 합포장시 사용
  • repre_phone2 — varchar(40) — 택배 합포장시 사용
  • ship_div — char(1) — NOT NULL
  • release_date — datetime
  • pro_gubun — char(1) — 택배자료다운시 같은 상품군끼리 묶을때 사용
  • shoppro_code — varchar(50)
  • release_schedule — datetime
  • v_list — char(1) — NOT NULL

TTB_netgain

  • idx — int — 기본 키 — NOT NULL
  • auction — float
  • gmarket — float
  • st_11 — float
  • interpark — float
  • lotte — float
  • daiso — float
  • uniwater — float
  • storefarm — float
  • lala — float
  • cjoshopping — float
  • hnshop — float
  • nhmarket — float — 현재는 미사용
  • ssg — float
  • emart — float
  • gsshop — float
  • kakao_P — float
  • immall — float
  • wemake — float
  • qoo10 — float
  • amazon — float
  • coupang — float
  • tmon — float
  • moongory — float
  • smartwell — float
  • lotteimall — float
  • todayhome — float
  • wdate — datetime
  • sale_date — date
  • d_chk — char(1) — 1:삭제, 0:정상
  • admin — int
  • eland — float
  • happy — float
  • apmall — float

TTB_release

  • idx — int — 기본 키 — NOT NULL
  • TTB_idx — int
  • pro_idx — int
  • order_num — int
  • cancel_num — int
  • waybill_num — char(15)
  • wdate — datetime — NOT NULL
  • status — char(1) — NOT NULL — code_master : class = 'release_status'
  • pro_name — varchar(300)
  • d_chk — char(1) — NOT NULL
  • tmp_ttb_idx — int
  • release_schedule — datetime
  • P_lcode — int
  • P_mcode — int
  • P_scode — int
  • ttb_gubun — varchar(20)
  • ttb_customer — varchar(20)
  • p_name — varchar(200)
  • ship_div — char(1)
  • tmp — int
  • p_price — float — NOT NULL

TTB_release_mat

  • idx — int — 기본 키 — NOT NULL
  • ttb_idx — int
  • rocket_idx — int
  • waybill_num — nvarchar(20)
  • pro_idx — int
  • pro_order_num — int
  • mat_code — nvarchar(20)
  • mat_order_num — float
  • input_day — datetime
  • admin — varchar(20) — 담당자 ID
  • customer_code — nvarchar(20)
  • receiver — nvarchar(50)
  • mat_unit — nvarchar(10)
  • ship_div — nvarchar(10)
  • release_pro_idx — int
  • use_count — float
  • P_ship_no — nvarchar(30)
  • P_status — nchar(10) — 아무내용도 없으면 정상
  • gubun — nchar(15) — TTB : 판매관리, rocket : 쿠팡로켓, mat_interlock : 직접출하
  • warehousing — varchar(20)
  • reason — varchar(300) — 직접출하시 입력

TTB_release_pro

  • idx — int — 기본 키 — NOT NULL
  • receiver — nchar(50)
  • waybill_num — nchar(14)
  • p_barcode — nchar(13)
  • pro_idx — int — NOT NULL
  • order_num — int — NOT NULL
  • release_num — int
  • c_release_num — int
  • input_day — datetime — NOT NULL
  • admin — int
  • ttb_idx — int
  • d_chk — char(1) — NOT NULL
  • status — char(1) — NOT NULL — 0 : 바코드출고, 1 : 자재출고
  • ship_div — char(1)
  • customer_code — varchar(20)
  • mat_prog_chk — tinyint
  • P_ship_no — nvarchar(30)
  • end_chk — nchar(1)
  • release_schedule — datetime
  • P_lcode — int
  • P_mcode — int
  • P_scode — int
  • ttb_gubun — varchar(20)
  • ttb_customer — varchar(20)
  • p_name — varchar(300)
  • v_list — char(1) — NOT NULL
  • re_mat_code — nvarchar(50)
  • re_mat_use_count — float

account

  • idx — int — 기본 키 — NOT NULL
  • customer_code — varchar(20)
  • gubun — tinyint — code_master : class = 'account_gubun'
  • IO_gubun — tinyint — code_master : class = 'account_IOgubun'
  • shop_chk — char(1)
  • nation — tinyint — code_master : class = 'nation'
  • com_registnum — varchar(50)
  • com_name — nvarchar(150) — NOT NULL
  • com_ceo — nchar(50)
  • com_tel — nchar(30) — NOT NULL
  • com_fax — nchar(30)
  • com_email — varchar(150)
  • com_zipcode — nchar(15)
  • com_address — nvarchar(150)
  • charge_name — nvarchar(100)
  • charge_position — nvarchar(100)
  • charge_tel — nchar(30)
  • memo — text
  • input_idx — int — NOT NULL
  • input_day — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • agent_chk — tinyint — code_master : class = 'account_agent'

code_master

  • code — nchar(10) — 기본 키 — NOT NULL
  • class — nchar(50) — 기본 키 — NOT NULL
  • idx — int — NOT NULL
  • code_name — nchar(50) — NOT NULL
  • class_name — nchar(50)
  • isActive — char(1) — NOT NULL
  • d_chk — char(1) — NOT NULL
  • turn_num — tinyint

consult_data

  • idx — int — 기본 키 — NOT NULL
  • gubun — tinyint — code_master : class = 'o_consult_gubun'
  • admin — int
  • input_admin — int
  • wdate — datetime
  • d_chk — char(1)
  • inquiry — text
  • answer — text

mat_arrival_schedule

  • idx — int — 기본 키 — NOT NULL
  • status — tinyint — NOT NULL — code_master : class = 'matwarehousing_status'
  • fixed_date — date — NOT NULL
  • fixed_date_chk — char(1) — NOT NULL — 1 : 납기일 무시, 지속체크품목
  • customer_idx — int
  • mat_code — varchar(50) — NOT NULL
  • mat_name — varchar(100) — NOT NULL
  • mat_spec — varchar(300)
  • order_num — float — NOT NULL
  • arrival_num — float
  • warehousingwill_num — float
  • mat_unit — tinyint — NOT NULL — code_master : class = 'mat_unit'
  • order_code — nchar(13)
  • input_idx — int — NOT NULL
  • input_date — datetime — NOT NULL
  • modify_idx — int
  • modify_date — datetime
  • order_date — date
  • order_name — varchar(20)
  • memo — varchar(300)
  • d_chk — char(1) — NOT NULL
  • customer_name — nvarchar(150)
  • order_idx — int
  • order_status — tinyint — NOT NULL — code_master : class = 'mat_arrival_schedule_orderstatus'
  • order_maildate — datetime
  • mat_price — float
  • t_mat_price — float
  • test_chk — char(1)

mat_arrival_schedule_order

  • idx — int — 기본 키 — NOT NULL
  • memo — varchar(2000)
  • send_date — datetime
  • admin — int
  • from_email — nvarchar(60)
  • to_email — nvarchar(60)
  • open_chk — char(1)
  • open_day — datetime
  • subject — nvarchar(200)
  • reference_email — nvarchar(60)
  • vendor — nvarchar(200)
  • ordermat_idx — nvarchar(1000) — mat_arrival_schedule의 idx(복수의 경우 쉼표(,)로 구분)
  • customer_name — nvarchar(150)
  • file1 — nvarchar(50)
  • arrival_adminidx — int

mat_orcl_error

  • idx — int — 기본 키 — NOT NULL
  • release_pro_idx — int
  • pro_idx — int
  • mat_code — nvarchar(50)
  • mat_unit — nvarchar(50)
  • use_count — float
  • p_ship_no — nvarchar(50)
  • p_status — nvarchar(50)
  • p_code — nvarchar(50)
  • input_day — datetime

pro_keyword_log

  • idx — int — 기본 키 — NOT NULL
  • ttb_idx — int
  • p_keyword — nvarchar(100)
  • admin — int
  • input_day — date
  • only_chk — char(1) — NOT NULL

ql_class

  • lclass_code — int — 기본 키 — NOT NULL
  • mclass_code — int — 기본 키 — NOT NULL
  • class_name — varchar(50) — NOT NULL
  • d_chk — char(1) — NOT NULL
  • input_date — datetime — NOT NULL
  • idx — int — NOT NULL

ql_master

  • idx — int — 기본 키 — NOT NULL
  • occur_date — date — NOT NULL
  • buy_date — date — NOT NULL
  • lclass_code — int — NOT NULL
  • mclass_code — int — NOT NULL
  • type_idx — int — NOT NULL
  • position_idx — int
  • result_idx — int — NOT NULL
  • comment — text — ext NUL
  • ttb_idx — int — NOT NULL
  • input_idx — int — NOT NULL
  • input_date — datetime — NOT NULL
  • d_chk — char(1) — NOT NULL
  • name — varchar(50) — NOT NULL
  • phone — char(20)
  • p_name — varchar(300)
  • mod_idx — int
  • mod_date — datetime
  • shop_ordernum — varchar(30)
  • TTB_gubun — varchar(20)
  • pro_idx — int
  • pro_cnt — smallint
  • LOT_NO — varchar(50)
  • examine_chk — char(1) — NOT NULL — 1 : 품질검사대상, 0 : 해당없음
  • pickup_chk — char(1) — NOT NULL — 1 : 수거신청, 0 : 해당없음
  • pickup_date — datetime

ql_position

  • idx — int — 기본 키 — NOT NULL
  • lclass_code — int — NOT NULL
  • mclass_code — int — NOT NULL
  • position_name — varchar(50) — NOT NULL
  • d_chk — char(1) — NOT NULL
  • input_date — datetime — NOT NULL

ql_pro

  • idx — int — 기본 키 — NOT NULL
  • lclass_code — int — NOT NULL
  • mclass_code — int — NOT NULL
  • pro_idx — int — NOT NULL — 필드품질분류에 따른 판매갯수 산정을 위함
  • use_num — smallint
  • input_date — datetime — NOT NULL

ql_result

  • idx — int — 기본 키 — NOT NULL
  • result_name — varchar(50) — NOT NULL
  • d_chk — char(1) — NOT NULL

ql_type

  • idx — int — 기본 키 — NOT NULL
  • type_name — varchar(50) — NOT NULL
  • d_chk — char(1) — NOT NULL
  • input_date — datetime — NOT NULL

returnform

  • idx — int — 기본 키 — NOT NULL
  • consult_idx — int
  • ttb_idx — int
  • pro_status — char(1)
  • name — nvarchar(20) — NOT NULL
  • phone — nvarchar(20)
  • p_name — nvarchar(200)
  • account — nvarchar(50)
  • accept_date — datetime — NOT NULL
  • warehousing_date — datetime — NOT NULL
  • admin_name — nvarchar(20)
  • reason — int
  • comment — text — ext NUL
  • admin — int
  • input_day — datetime — NOT NULL
  • status — tinyint — NOT NULL — code_master : class = 'returnform_status'
  • d_chk — char(1) — NOT NULL
  • examine_chk — char(1) — NOT NULL

returnform_detail

  • idx — int — 기본 키 — NOT NULL
  • returnform_idx — int — NOT NULL
  • status — tinyint — NOT NULL — code_master : class = 'returnform_status'
  • input_day — datetime — NOT NULL
  • memo — text
  • admin — int — NOT NULL
  • d_chk — char(1) — NOT NULL

returnform_pro

  • idx — int — 기본 키 — NOT NULL
  • returnform_idx — int — NOT NULL
  • num — smallint
  • pro_idx — int — NOT NULL
  • pro_cnt — smallint — NOT NULL
  • tmp_returnform_idx — int
  • input_day — datetime — NOT NULL
  • d_chk — char(1)

rocket_districenter

  • idx — int — 기본 키 — NOT NULL
  • distri_name — varchar(50) — NOT NULL
  • phone — varchar(30) — NOT NULL
  • zipcode — varchar(15)
  • address — varchar(150) — NOT NULL
  • d_chk — bit

rocket_sale

  • idx — int — 기본 키 — NOT NULL
  • order_num — int — NOT NULL
  • sku_id — int — NOT NULL
  • sku_name — varchar(100) — NOT NULL
  • barcode — varchar(20) — NOT NULL
  • order_amount — int — NOT NULL
  • delivery_amount — int — NOT NULL
  • return_amount — int — NOT NULL
  • distri_center — int
  • order_date — date — NOT NULL
  • ship_date — date — NOT NULL
  • delivery_date — date
  • money — float — NOT NULL
  • delivery_method — tinyint — code_master : class = 'rocket_delivery_method'
  • pro_idx — int
  • wdate — datetime — NOT NULL
  • admin — int — NOT NULL
  • d_chk — char(1) — NOT NULL
  • keyword_chk — char(1)
  • status — tinyint — code_master : class = 'rocket_status'
  • box_no — smallint
  • waybill_num — varchar(20)
  • mat_prog_chk — char(1)
  • P_ship_no — nchar(30)
  • mat_stock — float
  • mes_release_date — datetime
  • turn_num — smallint
  • memo — varchar(100)

rocket_sale_pro

  • idx — int — 기본 키 — NOT NULL
  • distri_center — varchar(50)
  • sku_name — varchar(100) — NOT NULL
  • rocket_order_num — varchar(10) — NOT NULL
  • order_num — int — NOT NULL
  • release_num — int — NOT NULL
  • c_release_num — int — NOT NULL
  • wdate — datetime — NOT NULL
  • waybill_num — nchar(14) — NOT NULL
  • pro_idx — int — NOT NULL
  • p_barcode — nchar(13) — NOT NULL
  • d_chk — char(1) — NOT NULL
  • turn_num — smallint

rocket_shipdown_num

  • chk_data — nvarchar(3000) — 쿠팡로켓 쉽먼트자료다운 - 한번에 20개이상 선택시 엑셀다운 문제가 생겨 임시로 저장하여 처리하는 TABLE

tmp_TTB_gurae_release_calendar

  • release_schedule_date — varchar(10)
  • customer — nvarchar(13)
  • receiver — nvarchar(50)
  • com_name — nvarchar(100)
  • status — nvarchar(20)