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