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)