EasyPOS TRS
테이블 (10)
TRS 주문내역 (trs_slip)
- sale_date — TEXT — 기본 키 — NOT NULL
- pos_no — TEXT — 기본 키 — NOT NULL
- bill_no — TEXT — 기본 키 — NOT NULL
- PRIMARY KEY ((sale_date, pos_no, bill_no)) — 외래 키 → 매출 헤더.PRIMARY KEY — NOT NULL
- trs_slip_no — TEXT — NOT NULL
- tax_type — TEXT
- tran_type — TEXT
- appr_datetime — TEXT
- serial_no — TEXT
- appr_no — TEXT
- appr_amt — INTEGER — NOT NULL
- refund_amt — INTEGER — NOT NULL
- vat_amt — INTEGER — NOT NULL
- ind_amt — INTEGER — NOT NULL
- edu_amt — INTEGER — NOT NULL
- message — TEXT
- passport_no — TEXT
- user_name — TEXT
- nationality — TEXT
- org_appr_datetime — TEXT
- org_appr_no — TEXT
- sale_flag — TEXT
- terminal_cd — TEXT
- refund_fg — TEXT
- refund_cancel_status — TEXT
매출 상세 (sale_detail)
- sale_date — TEXT — 기본 키 — NOT NULL
- head_office_no — TEXT — 기본 키 — NOT NULL
- shop_no — TEXT — 기본 키 — NOT NULL
- pos_no — TEXT — 기본 키 — NOT NULL
- bill_no — TEXT — 기본 키 — NOT NULL
- PRIMARY KEY ((sale_date, pos_no, bill_no)) — 외래 키 → 매출 헤더.PRIMARY KEY — NOT NULL
- detail_no — TEXT — NOT NULL
- refund_product_name — TEXT
- tax_flag — TEXT
- qty — INTEGER — NOT NULL
- total_amt — INTEGER — NOT NULL
- sale_amt — INTEGER — NOT NULL
- net_amt — INTEGER — NOT NULL
- total_dc_amt — INTEGER — NOT NULL
- vat_amt — INTEGER — NOT NULL
- point_amt — INTEGER — NOT NULL
- corp_dc_amt — INTEGER — NOT NULL
- normal_dc_amt — INTEGER — NOT NULL
- service_dc_amt — INTEGER — NOT NULL
- coupon_dc_amt — INTEGER — NOT NULL
- cust_dc_amt — INTEGER — NOT NULL
- cust_accum_point — INTEGER — NOT NULL
- cust_use_point — INTEGER — NOT NULL
- sale_flag — TEXT
- employ_code — TEXT
- order_datetime — TEXT
- serve_datetime — TEXT
- item_cost — INTEGER — NOT NULL
- item_price — INTEGER — NOT NULL
- item_type — TEXT
- sub_menu_type — TEXT
- sub_menu_flag — TEXT
- parent_detail_no — TEXT
- sub_menu_count — INTEGER — NOT NULL
- take_out_flag — TEXT
- item_list_color — TEXT
- cash_amt — INTEGER — NOT NULL
- card_amt — INTEGER — NOT NULL
- ocb_amt — INTEGER — NOT NULL
매출 헤더 (sale_header)
- PRIMARY KEY ((sale_date, pos_no, bill_no)) — 기본 키 — NOT NULL
- sale_date — TEXT — NOT NULL
- head_office_no — TEXT — NOT NULL
- shop_no — TEXT — NOT NULL
- pos_no — TEXT — NOT NULL
- bill_no — TEXT — NOT NULL
- total_amt — INTEGER — NOT NULL
- sale_amt — INTEGER — NOT NULL
- net_amt — INTEGER — NOT NULL
- total_dc_amt — INTEGER — NOT NULL
- vat_amt — INTEGER — NOT NULL
- service_amt — INTEGER — NOT NULL
- cash_amt — INTEGER — NOT NULL
- card_amt — INTEGER — NOT NULL
- tick_amt — INTEGER — NOT NULL
- point_amt — INTEGER — NOT NULL
- gift_amt — INTEGER — NOT NULL
- prepaid_amt — INTEGER — NOT NULL
- ocb_amt — INTEGER — NOT NULL
- corp_dc_amt — INTEGER — NOT NULL
- normal_dc_amt — INTEGER — NOT NULL
- service_dc_amt — INTEGER — NOT NULL
- coupon_dc_amt — INTEGER — NOT NULL
- cust_dc_amt — INTEGER — NOT NULL
- cust_no — TEXT
- cust_card_no — TEXT
- cust_accum_point — INTEGER — NOT NULL
- cust_use_point — INTEGER — NOT NULL
- sale_flag — TEXT
- cancel_flag — TEXT
- org_sale_no — TEXT
- employ_code — TEXT
- system_datetime — TEXT
- table_group_code — TEXT
- table_code — TEXT
- cust_cnt — INTEGER — NOT NULL
- detail_cnt — INTEGER — NOT NULL
- slip_cnt — INTEGER — NOT NULL
- receipt_amt — INTEGER — NOT NULL
- change_amt — INTEGER — NOT NULL
- send_flag — TEXT
- process_stage — TEXT
- Field
- Field2
- Field3
바코드 (barcode)
- item_code — TEXT — 외래 키 → 터치키.item_code
- touch_class_code (touch_class_code2) — TEXT — 외래 키 → 터치키.touch_class_code
- head_office_no — TEXT
- shop_no — TEXT
- barcode — TEXT
- large_scale — TEXT
- medium_scale — TEXT
- small_scale — TEXT
- id — INTEGER — NOT NULL
상품 (product)
- item_code — TEXT — 기본 키 — NOT NULL
- small_scale — TEXT — 외래 키 → 상품 소분류.item_small_scale — NOT NULL
- head_office_no — TEXT — NOT NULL
- shop_no — TEXT — NOT NULL
- item_name — TEXT
- short_name — TEXT
- english_name — TEXT
- large_scale — TEXT
- medium_scale — TEXT
- item_cost — TEXT
- item_price — TEXT
- vat_rate — TEXT
- use_flag — TEXT
- tax_flag — TEXT
- label_type — TEXT
- price_flag — TEXT
- sub_menu_type — TEXT
- service_flag — TEXT
- item_type — TEXT
- delivery_yn — TEXT
- pickup_yn — TEXT
- sale_days — TEXT
- sold_out — TEXT
- id — INTEGER — NOT NULL
상품 소분류 (item_small_scale)
- item_small_scale — TEXT — 기본 키 — NOT NULL
- head_office_no — TEXT — NOT NULL
- shop_no — TEXT — NOT NULL
- item_large_scale — TEXT — NOT NULL
- item_medium_scale — TEXT — NOT NULL
- item_small_scale_name — TEXT
- seq — TEXT
- updated_at — INTEGER
- id — INTEGER — NOT NULL
신용카드 주문내역 (card_slip)
- sale_date — TEXT — 기본 키 — NOT NULL
- pos_no — TEXT — 기본 키 — NOT NULL
- bill_no — TEXT — 기본 키 — NOT NULL
- PRIMARY KEY ((sale_date, pos_no, bill_no)) — 외래 키 → 매출 헤더.PRIMARY KEY — NOT NULL
- card_slip_no — TEXT
- card_no — TEXT
- appr_amt — INTEGER — NOT NULL
- installment — TEXT
- vaild_term — TEXT
- appr_no — TEXT
- appr_datetime — TEXT
- appr_flag — TEXT
- org_appr_date — TEXT
- org_appr_no — TEXT
- issuer_code — TEXT
- acquirer_code — TEXT
- vat_amt — INTEGER — NOT NULL
- service_amt — INTEGER — NOT NULL
- sale_flag — TEXT
- corp_dc_amt — INTEGER — NOT NULL
- msg — TEXT
- sign_flag — TEXT
- pay_kind — TEXT
- wcc — TEXT
- tran_serial_no — TEXT
터치키 (touch_key)
- item_code — TEXT — 기본 키
- touch_class_code — TEXT — 외래 키 → 터치키 분류.touch_class_code
- head_office_no — TEXT
- shop_no — TEXT
- seq — TEXT
- touch_color — TEXT
- id — INTEGER — NOT NULL
터치키 분류 (touch_class)
- touch_class_code — TEXT — 기본 키
- head_office_no — TEXT
- shop_no — TEXT
- touch_class_name — TEXT
- seq — TEXT
- touch_color — TEXT
- id — INTEGER — NOT NULL
현금영수증 주문내역 (cash_slip)
- sale_date — TEXT — 기본 키 — NOT NULL
- pos_no — TEXT — 기본 키 — NOT NULL
- bill_no — TEXT — 기본 키 — NOT NULL
- PRIMARY KEY ((sale_date, pos_no, bill_no)) — 외래 키 → 매출 헤더.PRIMARY KEY — NOT NULL
- cash_slip_no — TEXT
- identity_no — TEXT
- identity_type — TEXT
- trade_flag — TEXT
- appr_amt — INTEGER — NOT NULL
- vat_amt — INTEGER — NOT NULL
- service_amt — INTEGER — NOT NULL
- appr_flag — TEXT
- appr_no — TEXT
- appr_datetime — TEXT
- sale_flag — TEXT
- org_appr_no — TEXT
- org_appr_date — TEXT