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)