PRODUCT

Tables (12)

ZCATEGORY_111 (상품 카테고리)

  • CTGR_ID (카테고리ID) — ZCTGR_ID_111 — Primary key
  • CTGR_NM (카테고리명) — ZCTGR_NM_111

ZGRADE_MEM_111 (회원등급)

  • GRADE_ID (등급ID) — ZGRADE_ID_111 — Primary key
  • GRADE_NAME (등급명) — ZGRADE_NAME_111
  • DISCOUNT (할인율) — ZDISCOUNT_111
  • CRIT_AMT (등급 기준 금액) — ZCRIT_AMT_111
  • WAERS (화폐 단위) — WAERS

ZGR_HD_111 (입고)

  • GR_ID (입고ID) — ZGR_ID_111 — Primary key
  • GR_DT (입고일자) — DATS
  • PO_ID (주문 번호) — ZPO_ID_111 — Foreign key → ZORDER_HD_111.PO_ID
  • VND_ID (거래처ID) — ZVND_ID_111 — Foreign key → ZVENDOR_111.VND_ID

ZGR_IT_111 (입고상세)

  • GR_SEQ (입고 일련번호) — ZD_SNUM_111 — Primary key
  • GR_ID (입고ID) — ZGR_ID_111 — Foreign key → ZGR_HD_111.GR_ID
  • TOT_GR_QTY (총 입고 수량) — ZQUANTITY_111
  • DEF_QTY (불량 수량) — ZQUANTITY_111
  • PRODUCT_ID (상품ID) — ZPRODUCT_ID_111 — Foreign key → ZPRODUCT_111.PRODUCT_ID

ZMEMBER_111 (회원)

  • MBR_ID (회원ID) — ZMEMBER_ID_111 — Primary key
  • MBR_NAME (이름) — ZMEMBER_NAME_111
  • PHONENUM (전화번호) — ZPHONE_111
  • BIRTH (생년월일) — ZBIRTH_DATE_111
  • ACC_AMT (누적 구매 금액) — ZACC_AMT_111
  • WAERS (화폐 단위) — WAERS
  • GRADE_ID (등급ID) — ZGRADE_ID_111 — Foreign key → ZGRADE_MEM_111.GRADE_ID

ZORDER_HD_111 (발주)

  • PO_ID (주문 번호) — ZPO_ID_111 — Primary key
  • PO_DT (발주일자) — ZORDER_DATE_111
  • EXP_DT (예상 입고 일자) — ZORDER_EXP_111
  • TOT_AMT (발주 금액) — ZTOT_AMT_111
  • PO_STAT (발주 상태) — ZPO_STAT_111
  • WAERS (화폐 단위) — WAERS
  • VND_ID (거래처ID) — ZVND_ID_111 — Foreign key → ZVENDOR_111.VND_ID

ZORDER_IT_111 (발주 상세)

  • PO_SEQ (발주 일련번호) — ZPO_SEQ_11 — Primary key — NOT NULL
  • PO_ID (주문 번호) — ZPO_ID_111 — Foreign key → ZORDER_HD_111.PO_ID
  • PO_QTY (발주 수량) — ZTOT_AMT_111
  • PO_PRC (매입 단가) — ZPO_PRC_111
  • ITEM_AMT (발주 금액) — ZITEM_AMT_111
  • WAERS (화폐 단위) — WAERS
  • PRODUCT_ID (상품ID) — ZPRODUCT_ID_111 — Foreign key → ZPRODUCT_111.PRODUCT_ID

ZPRODUCT_111 (상품)

  • PRODUCT_ID (상품ID) — ZPRODUCT_ID_111 — Primary key
  • PRODUCT_NAME (상품명) — ZPRODUCT_NAME_111
  • SALES_PRICES (상품가격) — ZPROD_PRICE_111
  • MIN_STOCK_QTY (최소 재고 수량) — ZSTOCK_MIN_111
  • WAERS (화폐 단위) — WAERS
  • CTGR_ID (카테고리ID) — ZCTGR_ID_111 — Foreign key → ZCATEGORY_111.CTGR_ID

ZSALE_HD_111 (판매)

  • SALE_ID (판매ID) — ZSALE_ID_111 — Primary key
  • SALE_DT (판매일자) — ZSALE_DATE_111
  • TOTAL_AMOUNT (총 판매 금액) — ZTOTAL_AMOUNT_111
  • DISCOUNT_AMOUNT (할인 금액) — ZDC_AMOUNT_111
  • FINAL_AMOUNT (최종 결제 금액) — ZFINAL_AMOUNT_111
  • WAERS (화폐 단위) — WAERS
  • MBR_ID (회원ID) — ZMEMBER_ID_111 — Foreign key → ZMEMBER_111.MBR_ID

ZSALE_IT_111 (판매 상세)

  • SALE_SEQ (판매 일련번호) — ZSALE_SEQ_111 — Primary key — NOT NULL
  • SALE_ID (판매ID) — ZSALE_ID_111 — Foreign key → ZSALE_HD_111.SALE_ID
  • QUANTITY (판매 수량) — ZQUANTITY_111
  • UNIT_PRICE (상품 가격) — ZUNIT_PRICE_111
  • WAERS (화폐 단위) — WAERS
  • PRODUCT_ID (상품ID) — ZPRODUCT_ID_111 — Foreign key → ZPRODUCT_111.PRODUCT_ID

ZSTOCK_111 (재고)

  • PRODUCT_ID (상품ID) — ZPRODUCT_ID_111 — Foreign key → ZPRODUCT_111.PRODUCT_ID
  • CURR_STOCK (현재 재고) — ZQUANTITY_111
  • LAST_STOCK_CHANGE_DATE (마지막 재고 변경일) — ZSTOCK_CHG_DATE_111

ZVENDOR_111 (거래처)

  • VND_ID (거래처ID) — ZVND_ID_111 — Primary key
  • VND_NM (거래처명) — ZVND_NM_111
  • REPR_NM (사업자명) — ZREPR_NM_111
  • TEL_NO (전화번호) — ZTEL_NO_111
  • ADDR (주소) — ZADDR_111
  • BANK_ACC (계좌번호) — ZBANK_ACC_111
  • BANK_NM (은행명) — ZBANK_NM_111