BILL

Tables (3)

DC_APLY_CTG_DTL (할인적용카데고리상세)

  • DC_ID (Key) — Primary key — NOT NULL

DC_BAS (할인기본)

  • DC_ID (할인ID) — VARCHAR2(11) — Primary key — NOT NULL
  • DC_NM (할인명) — VARCHAR2(100)
  • DC_MTHD_CD (할인방법코드) — VARCHAR2(15)
  • DC_APLY_TYPE_CD (할인적용유형코드) — VARCHAR2(4)
  • DC_RATE (할인율) — NUMBER(9,6)
  • DC_AMT (할인금액) — NUMBER(18,3)

PROD_BAS (상품기본)

  • PROD_ID (상품ID) — VARCHAR2(15) — Primary key — NOT NULL
  • PROD_NM (상품명) — VARCHAR2(100)
  • PROD_TYPE_CD (상품유형코드) — VARCHAR2(4)