FreshOn

Tables (17)

ar_month_detail (여신 정보 (주문가능금액 계산))

  • ar_month_detail_no (Key) — Primary key — NOT NULL
  • stock_month (Field)

common_detail (상수값)

  • common_detail_no (Key) — Primary key — NOT NULL

day_order (주문)

  • day_order_no (Key) — Primary key — NOT NULL
  • order_no (Field)
  • item_cd (Field2)
  • est_cd (Field3)
  • stock_date (Field4)
  • log_cd (Field5)
  • inner_price (Field6)
  • order_qty (Field7)

day_order_closing (마감된 주문)

  • day_order_closing_no (Key) — Primary key — NOT NULL

est_info (고객 정보)

  • est_info_no (Key) — Primary key — NOT NULL
  • est_cd (Field)
  • headqt_yn (Field2)
  • large_gbn (Field3)
  • middle_gbn (Field4)
  • small_gbn (Field5)

est_loan_info (사업장여신정보)

  • est_loan_info_no (Key) — Primary key — NOT NULL
  • est_cd (Field)

fc_user_info (매장 담당자 정보)

  • fc_user_info_id (Field)
  • est_cd (Field2)

headquarter_brand_info (중분류 정보)

  • headquarter_brand_info_id (Key) — Primary key — NOT NULL
  • headquarter_info_id (Field)

headquarter_info (본사 정보)

  • headquarter_info_id (Key) — Primary key — NOT NULL
  • headquarter_group_cd (Field)
  • upper_est_cd (Field2)

item_mst (상품 정보)

  • item_mst_no (Key) — Primary key — NOT NULL
  • item_cd (Field)
  • group_cd1 (Field2)
  • group_cd2 (Field3)
  • group_cd3 (Field4)
  • group_cd4 (Field5)

month_stock_in (매입 월마감)

  • month_stock_in_no (Key) — Primary key — NOT NULL
  • stock_in_no (Field)
  • seller_cd (Field2)

month_stock_out (매출 월마감)

  • month_stock_out_no (Key) — Primary key — NOT NULL
  • stock_out_no (Field)
  • item_account (Field2)
  • est_cd (Field3)

price_group_est_item_map (단가 그룹 상품 매핑)

  • price_group_est_item_map_no (Key) — Primary key — NOT NULL
  • item_mst_no (Field)
  • price_group_cd (Field2)
  • sales_price (Field3)
  • delive_price (Field4)
  • sale_unit (Field5)

price_group_est_map (단가 그룹 고객 매핑)

  • price_group_est_map_no (Key) — Primary key — NOT NULL
  • price_group_cd (Field)
  • est_cd (Field2)

price_group_mst (단가 그룹)

  • price_group_mst_no (Key) — Primary key — NOT NULL
  • price_group_cd (Field)

seller_item_mst (협력업체품목정보 (센터별))

  • seller_item_mst_no (Key) — Primary key — NOT NULL
  • item_mst_no (Field)
  • div_cd (Field2)
  • item_cd (Field3)
  • seller_cd (Field4)

user_mst (로그인 정보)

  • user_mst_no (Key) — Primary key — NOT NULL
  • user_id (Field)
  • user_group (Field2)
  • user_type (Field3)
  • customer_code (Field4)
  • admin_yn (Field5)