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