sap project
Tables (13)
ZCATEGORY
- MANDT — CHAR(3) — Primary key — NOT NULL
- CTGR_ID — CHAR(4) — Primary key — NOT NULL — 카테고리
- CTGR_NM — CHAR(40) — 카테고리명
ZGR
- GR_ID — CHAR(10) — Primary key — NOT NULL — 입고
- MANDT — CHAR(3) — Foreign key → ZVENDOR.MANDT — NOT NULL
- PO_ID — CHAR(10) — Foreign key → ZORDER.PO_ID — 발주
- VND_ID — CHAR(10) — Foreign key → ZVENDOR.VND_ID — 거래처
- GR_DT — DATE — 입고
ZGRADE
- MANDT — CHAR(3) — Primary key — NOT NULL
- GRADE_ID — CHAR(4) — Primary key — NOT NULL — 회원
- GRADE_NM — CHAR(20) — 등급명
- DC_RATE — DECIMAL(3,1) — 할인율
- CRIT_AMT — DECIMAL(15,2) — 등급
- WAERK — CHAR(5) — 통화
ZGR_IT
- GR_SEQ — NUMERIC(4) — Primary key — NOT NULL — 입고
- MANDT — CHAR(3) — Foreign key → ZPRODUCT.MANDT — NOT NULL
- GR_ID — CHAR(10) — Foreign key → ZGR.GR_ID — NOT NULL — 입고
- PROD_ID — CHAR(10) — Foreign key → ZPRODUCT.PROD_ID — 상품
- TOT_GR_QTY — DECIMAL(13,3) — 총
- DEF_QTY — DECIMAL(13,3) — 불량
- MEINS — CHAR(3) — 수량
ZMEMBER
- MBR_ID — CHAR(10) — Primary key — NOT NULL — 회원
- MANDT — CHAR(3) — Foreign key → ZGRADE.MANDT — NOT NULL
- MBR_NM — CHAR(40) — 회원
- CELL_NO — CHAR(15) — 휴대폰
- BRTH_DT — DATE — 생년월일
- ACC_AMT — DECIMAL(15,2) — 누적
- WAERK — CHAR(5) — 통화
- GRADE_ID — CHAR(4) — Foreign key → ZGRADE.GRADE_ID — 등급
ZORDER
- PO_ID — CHAR(10) — Primary key — NOT NULL — 발주
- MANDT — CHAR(3) — Foreign key → ZVENDOR.MANDT — NOT NULL
- VND_ID — CHAR(10) — Foreign key → ZVENDOR.VND_ID — 거래처
- PO_DT — DATE — 발주
- EXP_DT — DATE — 예상
- TOT_AMT — DECIMAL(15,2) — 총
- PO_STAT — CHAR(2) — 발주
- WAERK — CHAR(5) — 통화
ZORDER_IT
- PO_SEQ — NUMERIC(4) — Primary key — NOT NULL — 발주
- MANDT — CHAR(3) — Foreign key → ZPRODUCT.MANDT — NOT NULL
- PO_ID — CHAR(10) — Foreign key → ZORDER.PO_ID — NOT NULL — 발주
- PROD_ID — CHAR(10) — Foreign key → ZPRODUCT.PROD_ID — 상품
- PO_QTY — DECIMAL(13,3) — 발주
- PO_PRC — DECIMAL(15,2) — 매입
- ITEM_AMT — DECIMAL(15,2) — 상품별
- MEINS — CHAR(3) — 수량
- WAERK — CHAR(5) — 통화
ZPRODUCT
- PROD_ID — CHAR(10) — Primary key — NOT NULL — 상품
- MANDT — CHAR(3) — Foreign key → ZVENDOR.MANDT — NOT NULL
- CTGR_ID — CHAR(4) — Foreign key → ZCATEGORY.CTGR_ID — 카테고리
- VND_ID — CHAR(10) — Foreign key → ZVENDOR.VND_ID — 주거래처
- PROD_NM — CHAR(40) — 상품명
- PRICE — DECIMAL(15,2) — 판매
- MIN_STOCK — DECIMAL(13,3) — 최소
- MEINS — CHAR(3) — 수량
- WAERK — CHAR(5) — 통화
ZSALE_HD
- SALE_ID — CHAR(10) — Primary key — NOT NULL — 판매
- MANDT — CHAR(3) — Foreign key → ZMEMBER.MANDT — NOT NULL
- MBR_ID — CHAR(10) — Foreign key → ZMEMBER.MBR_ID — 회원
- SALE_DT — DATE — 판매
- TOT_AMT — DECIMAL(15,2) — 총
- DC_AMT — DECIMAL(15,2) — 할인
- NET_AMT — DECIMAL(15,2) — 최종
- WAERK — CHAR(5) — 통화
ZSALE_IT
- SALE_SEQ — NUMERIC(4) — Primary key — NOT NULL — 판매
- MANDT — CHAR(3) — Foreign key → ZPRODUCT.MANDT — NOT NULL
- SALE_ID — CHAR(10) — Foreign key → ZSALE_HD.SALE_ID — NOT NULL — 판매
- PROD_ID — CHAR(10) — Foreign key → ZPRODUCT.PROD_ID — 상품
- SALE_QTY — DECIMAL(13,3) — 수량
- SALE_PRC — DECIMAL(15,2) — 판매
- MEINS — CHAR(3) — 판매
- WAERK — CHAR(5) — 금액
ZSTK_HIST
- HIST_ID — CHAR(12) — Primary key — NOT NULL — 재고
- MANDT — CHAR(3) — Foreign key → ZPRODUCT.MANDT — NOT NULL
- PROD_ID — CHAR(10) — Foreign key → ZPRODUCT.PROD_ID — 상품
- CHG_QTY — DECIMAL(13,3) — 변동
- BEF_STOCK — DECIMAL(13,3) — 변경
- AFT_STOCK — DECIMAL(13,3) — 변경
- MEINS — CHAR(3) — 수량
- CHG_DT — TIMESTAMP — 변경
- MOVE_REASON — CHAR(50) — 변경
ZSTOCK
- MANDT — CHAR(3) — Foreign key → ZPRODUCT.MANDT — NOT NULL
- PROD_ID — CHAR(10) — Foreign key → ZPRODUCT.PROD_ID — NOT NULL — 상품
- CURR_STOCK — DECIMAL(13,3) — 현재
- MEINS — CHAR(3) — 단위
- LST_CHG_DT — TIMESTAMP — 마지막
ZVENDOR
- MANDT — CHAR(3) — Primary key — NOT NULL
- VND_ID — CHAR(10) — Primary key — NOT NULL — 거래처
- VND_NM — CHAR(40) — 거래처명
- REPR_NM — CHAR(40) — 대표자명
- TEL_NO — CHAR(15) — 전화번호
- ADDR — CHAR(100) — 주소
- BANK_ACC — CHAR(30) — 계좌번호
- BANK_NM — CHAR(20) — 은행명