cl_orderlist

Tables (50)

aa

  • aa — text

access_ticket_info_going_out_chk

  • idx — int
  • nUserIdn — int
  • barcode — varchar(50)
  • out_minute — int
  • regdate — datetime
  • updatetime — datetime

access_ticket_info_going_out_chk_log

  • idx — int
  • out_nEventLogIdn — int
  • in_nEventLogIdn — int
  • nUserIdn — int
  • barcode — varchar(50)
  • status — int
  • orgin_out_time — int
  • origin_in_time — int
  • regdate — datetime
  • updatetime — datetime

access_ticket_info_going_out_chk_log_bk

  • idx — int
  • out_nEventLogIdn — int
  • in_nEventLogIdn — int
  • nUserIdn — int
  • barcode — varchar(50)
  • status — int
  • orgin_out_time — int
  • origin_in_time — int
  • regdate — datetime
  • updatetime — datetime

admin_api_order_detail_list_log

  • idx — int
  • uid — varchar(50)
  • barcode — varchar(40)
  • regdate — datetime

api_order_detail_create

  • idx — int
  • company — varchar(50)
  • order_num — varchar(50)
  • barcode — varchar(50)
  • new_order_num — varchar(50)
  • new_barcode — varchar(50)
  • regdate — varchar(50)
  • updatetime — datetime

api_order_detail_list

  • buy_date1 — date — Primary key — NOT NULL
  • idx — int
  • nType — char(20)
  • pos_open_date — datetime
  • last_pos_open_date — datetime
  • use_uid — varchar(30)
  • use_name — varchar(30)
  • use_date — datetime
  • insert_idx — int
  • order_num — varchar(50)
  • product_option — varchar(200)
  • package_barcode — varchar(50)
  • barcode — varchar(50)
  • master_option_idx — int
  • master_option_detail_setting_idx — int
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • prev_use_uid — varchar(30)
  • prev_use_name — varchar(30)
  • prev_use_date — datetime
  • start_date — datetime
  • end_date — datetime
  • regdate — datetime
  • updatetime — datetime
  • status — char
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

api_order_detail_list_status_log

  • idx — int
  • unique_code — varchar(20)
  • pos_open_date — datetime
  • use_uid — varchar(50)
  • barcode — varchar(50)
  • status — char
  • regdate — datetime

api_order_master_create

  • idx — int
  • company — varchar(50)
  • order_num — varchar(50)
  • new_order_num — varchar(50)
  • regdate — varchar(50)
  • updatetime — datetime

api_order_master_list

  • buy_date1 — date — Primary key — NOT NULL
  • idx — int
  • nType — char(20)
  • company_product_code — varchar(20)
  • channel_name — varchar(50)
  • order_num — varchar(50)
  • company — varchar(20)
  • buy_name — varchar(50)
  • buy_hp — varchar(50)
  • buy_hp1 — char(4)
  • buy_date — datetime
  • pre_registration_group_no — varchar(20)
  • updatetime — datetime
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

app_api_order_detail_list

  • idx — int
  • pos_open_date — datetime
  • company — varchar(50)
  • app_id — varchar(50)
  • order_num — varchar(50)
  • package_barcode — varchar(30)
  • barcode — varchar(50)
  • web_ticket_detail_list_idx — int
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • start_date — datetime
  • end_date — datetime
  • status — char
  • message — varchar(80)
  • regdate — datetime
  • updatetime — datetime

app_api_order_master_list

  • idx — int
  • company — varchar(50)
  • app_id — varchar(50)
  • order_num — varchar(50)
  • web_ticket_master_list_idx — int
  • company_list_idx — int
  • memo — varchar(200)
  • regdate — datetime
  • regdate1 — datetime
  • updatetime — datetime

app_api_ticket_send

  • idx — int
  • pos_order_num — varchar(50)
  • company — varchar(50)
  • barcode — varchar(50)
  • status — char
  • send_chk — char
  • regdate — datetime
  • updatetime — datetime

app_coupon_barcode_use_list

  • idx — int
  • pos_orderdetail_order_num — varchar(50)
  • app_coupon_barcode — varchar(30)
  • status — char
  • regdate — datetime
  • regdate1 — datetime
  • updatetime — datetime

app_coupon_mt_list

  • idx — int
  • order_num — varchar(50)
  • barcode — varchar(50)
  • web_ticket_detail_list_idx — int
  • status — char
  • regdate — datetime
  • updatetime — datetime

app_order_num_list

  • idx — int
  • app_member_company — varchar(40)
  • app_member_id — varchar(40)
  • app_member_name — varchar(50)
  • app_member_point — int
  • pos_open_date — datetime
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • order_num — varchar(50)
  • amount — int
  • status — int
  • regdate — datetime
  • updatetime — datetime

app_order_num_list_ready

  • idx — int
  • app_member_company — varchar(40)
  • app_member_id — varchar(40)
  • app_member_name — varchar(50)
  • app_member_point — int
  • pos_open_date — datetime
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • order_num — varchar(50)
  • amount — int
  • status — int
  • regdate — datetime
  • updatetime — datetime

app_order_num_list_send

  • idx — int
  • send_chk — char
  • app_member_company — varchar(40)
  • app_member_id — varchar(40)
  • app_member_name — varchar(50)
  • app_member_point — int
  • pos_open_date — datetime
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • order_num — varchar(50)
  • amount — int
  • status — int
  • regdate — datetime
  • updatetime — datetime

barcode_memo

  • idx — int
  • uid — varchar(50)
  • order_num — varchar(50)
  • package_barcode — varchar(50)
  • memo — text
  • regdate — datetime

booking_advance_payment_list

  • idx — int
  • order_num — varchar(80)
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • advance_payment — int
  • regdate — datetime
  • status — int

booking_advance_payment_list_ready

  • idx — int
  • order_num — varchar(80)
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • advance_payment — int
  • regdate — datetime
  • status — int

booking_detail_list

  • buy_date1 — date — Primary key — NOT NULL
  • idx — int
  • user_name — varchar(30)
  • user_hp — varchar(20)
  • last_pos_open_date — datetime
  • order_num — varchar(50)
  • package_barcode — varchar(50)
  • barcode — varchar(50)
  • rbuy_price — int
  • rsell_price — int
  • no_show_price — int
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • master_option_idx — int
  • reserve_option_list_idx — int
  • reserve_manage_setting_idx — int
  • reserve_date — varchar(10)
  • use_uid — varchar(50)
  • status — int
  • option_type — varchar(20)
  • memo1 — varchar(150)
  • memo2 — varchar(150)
  • regdate — datetime
  • updatetime — datetime
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

booking_detail_list_ready

  • idx — int
  • user_name — varchar(30)
  • user_hp — varchar(20)
  • server_time — varchar(20)
  • order_num — varchar(50)
  • package_barcode — varchar(50)
  • barcode — varchar(50)
  • master_option_idx — int
  • rbuy_price — int
  • rsell_price — int
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • reserve_option_list_idx — int
  • reserve_manage_setting_idx — int
  • reserve_date — varchar(10)
  • status — int
  • option_type — varchar(20)
  • memo1 — varchar(150)
  • memo2 — varchar(150)
  • buy_date1 — date
  • regdate — datetime
  • updatetime — datetime

booking_detail_list_ready_error

  • idx — int
  • server_time — varchar(20)
  • order_num — varchar(80)
  • regdate — datetime

booking_master_list

  • buy_date1 — date — Primary key — NOT NULL
  • idx — int
  • channel_name — varchar(50)
  • order_num — varchar(50)
  • company — varchar(20)
  • buy_name — varchar(50)
  • buy_hp — varchar(50)
  • buy_hp1 — char(4)
  • buy_date — datetime
  • real_price — int
  • advance_payment — int
  • admin_memo — text
  • status — int
  • deposit_status — int
  • sms_content_list_idx — int
  • updatetime — datetime
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

booking_master_list_ready

  • idx — int
  • channel_name — varchar(50)
  • order_num — varchar(50)
  • company — varchar(20)
  • buy_name — varchar(50)
  • buy_hp — varchar(50)
  • buy_hp1 — char(4)
  • buy_date — datetime
  • buy_date1 — date
  • real_price — int
  • advance_payment — int
  • admin_memo — text
  • status — int
  • deposit_status — int
  • sms_content_list_idx — int
  • updatetime — datetime

calculate_day_detail_list

  • idx — int
  • pos_open_date — datetime
  • nType — varchar(50) — NOT NULL
  • channel_name — varchar(30) — NOT NULL
  • uid — varchar(50) — NOT NULL
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • master_option_idx — int — NOT NULL
  • sell_count — int
  • cancel_count — int
  • regdate — varchar(10)

calculate_day_detail_list_ready

  • idx — int
  • pos_open_date — datetime
  • order_num — varchar(80) — NOT NULL
  • barcode — varchar(80) — NOT NULL
  • nType — varchar(10) — NOT NULL
  • status — int
  • hit — int
  • regdate — datetime — NOT NULL
  • updatetime — datetime

calculate_day_detail_list_ready_bk

  • idx — int
  • pos_open_date — datetime
  • pidx — int
  • order_num — varchar(80)
  • barcode — varchar(80)
  • nType — varchar(10)
  • status — int
  • hit — int
  • regdate — datetime
  • updatetime — datetime

calculate_day_master_list

  • idx — int
  • nType — varchar(50) — NOT NULL
  • channel_name — varchar(30) — NOT NULL
  • uid — varchar(50) — NOT NULL
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int — NOT NULL
  • visit_user_count — int
  • card_discount_price — int
  • card_real_price — int
  • card_cancel_price — int
  • cashy_discount_price — int
  • cashy_real_price — int
  • cashy_cancel_price — int
  • cashn_discount_price — int
  • cashn_real_price — int
  • cashn_cancel_price — int
  • online_use_price — int
  • regdate — varchar(10)

calculate_day_master_list_ready

  • idx — int
  • order_num — varchar(80) — NOT NULL
  • nType — varchar(10) — NOT NULL
  • status — int
  • hit — int
  • regdate — datetime — NOT NULL
  • updatetime — datetime

calculate_day_master_list_ready_bk

  • idx — int
  • pidx — int
  • order_num — varchar(80)
  • nType — varchar(10)
  • status — int
  • hit — int
  • regdate — datetime
  • updatetime — datetime

calculate_day_online_list_ready

  • idx — int
  • pos_open_date — datetime
  • uid — varchar(50)
  • barcode — varchar(80) — NOT NULL
  • nType — varchar(10) — NOT NULL
  • status — int
  • hit — int
  • regdate — datetime — NOT NULL
  • updatetime — datetime

calculate_day_online_list_ready_bk

  • idx — int
  • pidx — int
  • barcode — varchar(80)
  • nType — varchar(10)
  • status — int
  • hit — int
  • regdate — datetime
  • updatetime — datetime

calculate_day_visit_use_count

  • idx — int
  • pos_open_date — datetime
  • channel_name — varchar(20)
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int — NOT NULL
  • visit_user_count — int
  • regdate — varchar(10)

calculate_day_visit_use_count_ready

  • idx — int
  • pos_open_date — datetime
  • nType — varchar(10)
  • channel_name — varchar(20)
  • barcode — varchar(50)
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • status — int
  • regdate — varchar(10)
  • updatetime — datetime

call_list

  • idx — int
  • company_upjang_list_idx — int
  • did_call_num — int
  • start_call — int
  • lastcall — int
  • regdate — varchar(10)
  • updatetime — datetime

call_list_chk

  • idx — int
  • company_upjang_list_idx — int
  • did_num — int
  • did_call_num — int
  • start_call — int
  • lastcall — int
  • regdate — varchar(10)
  • updatetime — datetime

company_calculate_list_log1

  • idx — int
  • in_mode — varchar(10) — NOT NULL
  • barcode — varchar(50) — NOT NULL
  • regdate — datetime — NOT NULL

company_calculate_list_log2

  • idx — int
  • payment_type_a — varchar(20) — NOT NULL
  • in_mode — varchar(10) — NOT NULL
  • barcode — varchar(50) — NOT NULL
  • uid — varchar(50) — NOT NULL
  • use_date — datetime
  • regdate — datetime — NOT NULL

company_calculate_sum_purchase_option_price_list

  • pos_open_date — datetime — Primary key — NOT NULL
  • idx — int
  • company_list_idx — int — NOT NULL
  • company_branch_list_idx — int — NOT NULL
  • company_upjang_list_idx — int — NOT NULL
  • uid — varchar(50) — NOT NULL
  • payment_type_a — varchar(20) — NOT NULL
  • payment_type_b — varchar(35) — NOT NULL
  • option_type_a — varchar(35)
  • option_type_b — varchar(15)
  • common_master_option_idx — int — NOT NULL
  • buy_price — int
  • sell_price — int
  • add_count — int — NOT NULL
  • cancel_count — int — NOT NULL
  • sum_count — int — NOT NULL
  • add_purchase_buy_price — int — NOT NULL
  • add_purchase_sell_price — int — NOT NULL
  • cancel_purchase_buy_price — int — NOT NULL
  • cancel_purchase_sell_price — int — NOT NULL
  • total_purchase_buy_price — int — NOT NULL
  • total_purchase_sell_price — int — NOT NULL
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202208
  • partition — p202209
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

company_calculate_sum_purchase_option_price_list_v2

  • idx — int
  • pos_open_date — datetime — NOT NULL
  • company_list_idx — int — NOT NULL
  • company_branch_list_idx — int — NOT NULL
  • company_upjang_list_idx — int — NOT NULL
  • uid — varchar(50) — NOT NULL
  • payment_type_a — varchar(20) — NOT NULL
  • payment_type_b — varchar(35) — NOT NULL
  • option_type_a — varchar(35)
  • option_type_b — varchar(15)
  • common_master_option_idx — int — NOT NULL
  • buy_price — int
  • sell_price — int
  • add_count — int — NOT NULL
  • cancel_count — int — NOT NULL
  • sum_count — int — NOT NULL
  • add_purchase_buy_price — int — NOT NULL
  • add_purchase_sell_price — int — NOT NULL
  • cancel_purchase_buy_price — int — NOT NULL
  • cancel_purchase_sell_price — int — NOT NULL
  • total_purchase_buy_price — int — NOT NULL
  • total_purchase_sell_price — int — NOT NULL

company_calculate_sum_purchase_price_list

  • pos_open_date — datetime — Primary key — NOT NULL
  • idx — int
  • company_list_idx — int — NOT NULL
  • company_branch_list_idx — int — NOT NULL
  • company_upjang_list_idx — int — NOT NULL
  • uid — varchar(50) — NOT NULL
  • payment_type_a — varchar(20) — NOT NULL
  • payment_type_b — varchar(35) — NOT NULL
  • option_type_a — varchar(35)
  • add_purchase_buy_price — int — NOT NULL
  • add_purchase_sell_price — int — NOT NULL
  • cancel_purchase_buy_price — int — NOT NULL
  • cancel_purchase_sell_price — int — NOT NULL
  • total_purchase_buy_price — int — NOT NULL
  • total_purchase_sell_price — int — NOT NULL
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202208
  • partition — p202209
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

company_calculate_sum_purchase_price_list_v2

  • idx — int
  • pos_open_date — datetime — NOT NULL
  • company_list_idx — int — NOT NULL
  • company_branch_list_idx — int — NOT NULL
  • company_upjang_list_idx — int — NOT NULL
  • uid — varchar(50) — NOT NULL
  • payment_type_a — varchar(20) — NOT NULL
  • payment_type_b — varchar(35) — NOT NULL
  • option_type_a — varchar(35)
  • add_purchase_buy_price — int — NOT NULL
  • add_purchase_sell_price — int — NOT NULL
  • cancel_purchase_buy_price — int — NOT NULL
  • cancel_purchase_sell_price — int — NOT NULL
  • total_purchase_buy_price — int — NOT NULL
  • total_purchase_sell_price — int — NOT NULL

company_calculate_sum_user_count_list

  • pos_open_date — datetime — Primary key — NOT NULL
  • idx — int
  • company_list_idx — int
  • company_branch_list_idx — int
  • company_upjang_list_idx — int
  • add_count — int
  • cancel_count — int
  • total_count — int
  • partition — p202003
  • partition — p202004
  • partition — p202005
  • partition — p202006
  • partition — p202007
  • partition — p202008
  • partition — p202009
  • partition — p202010
  • partition — p202011
  • partition — p202012
  • partition — p202101
  • partition — p202102
  • partition — p202103
  • partition — p202104
  • partition — p202105
  • partition — p202106
  • partition — p202107
  • partition — p202108
  • partition — p202109
  • partition — p202110
  • partition — p202111
  • partition — p202112
  • partition — p202201
  • partition — p202202
  • partition — p202203
  • partition — p202204
  • partition — p202205
  • partition — p202206
  • partition — p202207
  • partition — p202208
  • partition — p202209
  • partition — p202210
  • partition — p202211
  • partition — p202212
  • partition — p202301
  • partition — pmax

daily_issue_number

  • idx — int
  • print_number — int
  • company_upjang_list_idx — int
  • did_call_num — int
  • regdate — varchar(10)

day_sum_price_chk_list

  • idx — int
  • pos_open_date — datetime
  • total_purchase_sell_price — bigint
  • total_purchase_sell_option_price — bigint
  • prev_sell_price — bigint
  • prev_sell_option_price — bigint
  • prev_partial_refund — bigint
  • all_total_purchase_sell_price — bigint
  • all_total_purchase_sell_option_price — bigint
  • all_sell_price — bigint
  • all_sell_option_price — bigint
  • all_partial_refund — bigint
  • regdate — datetime
  • updatetime — datetime
  • status — char

deferred_payment_cancel_log

  • idx — int
  • pay_order_num — varchar(80)
  • uid — varchar(50)
  • regdate — datetime

del_barcode

  • idx — int
  • barcode — varchar(50)
  • status — int
  • updatetime — datetime
  • regdate — datetime

delivery_order_master

  • idx — int
  • uid — varchar(40)
  • pos_open_date — datetime
  • company_list_idx — smallint
  • company_branch_list_idx — smallint
  • company_upjang_list_idx — smallint
  • nType — varchar(20)
  • order_num — varchar(50)
  • status — char
  • regdate — datetime
  • updatetime — datetime
  • memo — varchar(30)