sap

Tables (13)

CATEGORY

  • CATEGORY_ID — VARCHAR(20) — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR(50)

GOODS_RECEIPT

  • RECEIPT_ID — VARCHAR(20) — Primary key — NOT NULL
  • SUPPLIER_ID — VARCHAR(20)
  • ORDER_ID — VARCHAR(20)
  • RECEIPT_DATE — DATETIME

GOODS_RECEIPT_DETAIL

  • RECEIPT_ID — VARCHAR(20) — Primary key — NOT NULL
  • PRODUCT_ID — VARCHAR(20) — Primary key — NOT NULL
  • TOTAL_RECEIPT_QTY — INT
  • DEFECT_QTY — INT

INVENTORY

  • PRODUCT_ID — VARCHAR(20) — Primary key — NOT NULL
  • CURRENT_STOCK_QTY — INT
  • LAST_CHANGED_AT — DATETIME

INVENTORY_HISTORY

  • STOCK_HISTORY_ID — VARCHAR(20) — Primary key — NOT NULL
  • PRODUCT_ID — VARCHAR(20)
  • CHANGE_QTY — INT
  • BEFORE_STOCK_QTY — INT
  • AFTER_STOCK_QTY — INT
  • CHANGED_AT — DATETIME
  • CHANGE_REASON — VARCHAR(50)

MEMBER

  • MEMBER_ID — VARCHAR(20) — Primary key — NOT NULL
  • MEMBER_NAME — VARCHAR(50)
  • PHONE — VARCHAR(20)
  • BIRTH_DATE — DATE
  • TOTAL_PURCHASE_AMOUNT — DECIMAL(15,2)
  • GRADE_ID — VARCHAR(10)
  • CURRENCY_CODE — VARCHAR(5)

MEMBER_GRADE

  • GRADE_ID — VARCHAR(10) — Primary key — NOT NULL
  • GRADE_NAME — VARCHAR(20)
  • DISCOUNT_RATE — DECIMAL(5,2)
  • GRADE_AMOUNT — DECIMAL(15,2)
  • CURRENCY_CODE — VARCHAR(5)

PRODUCT

  • PRODUCT_ID — VARCHAR(20) — Primary key — NOT NULL
  • CATEGORY_ID — VARCHAR(20)
  • SUPPLIER_ID — VARCHAR(20)
  • PRODUCT_NAME — VARCHAR(100)
  • SALE_PRICE — DECIMAL(15,2)
  • MIN_STOCK_QTY — INT
  • CURRENCY_CODE — VARCHAR(5)

PURCHASE_ORDER

  • ORDER_ID — VARCHAR(20) — Primary key — NOT NULL
  • SUPPLIER_ID — VARCHAR(20)
  • ORDER_DATE — DATETIME
  • EXPECTED_RECEIPT_DATE — DATETIME
  • ORDER_AMOUNT — DECIMAL(15,2)
  • ORDER_STATUS — VARCHAR(20)

PURCHASE_ORDER_DETAIL

  • ORDER_ID — VARCHAR(20) — Primary key — NOT NULL
  • PRODUCT_ID — VARCHAR(20) — Primary key — NOT NULL
  • ORDER_QTY — INT
  • PURCHASE_UNIT_PRICE — DECIMAL(15,2)
  • PRODUCT_ORDER_AMOUNT — DECIMAL(15,2)
  • CURRENCY_CODE — VARCHAR(5)

SALES

  • SALES_ID — VARCHAR(20) — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR(20)
  • SALES_DATE — DATETIME
  • TOTAL_SALES_AMOUNT — DECIMAL(15,2)
  • DISCOUNT_AMOUNT — DECIMAL(15,2)
  • FINAL_PAYMENT_AMOUNT — DECIMAL(15,2)
  • CURRENCY_CODE — VARCHAR(5)

SALES_DETAIL

  • SALES_ID — VARCHAR(20) — Primary key — NOT NULL
  • PRODUCT_ID — VARCHAR(20) — Primary key — NOT NULL
  • QUANTITY — INT
  • SALE_UNIT_PRICE — DECIMAL(15,2)
  • CURRENCY_CODE — VARCHAR(5)

SUPPLIER

  • SUPPLIER_ID — VARCHAR(20) — Primary key — NOT NULL
  • SUPPLIER_NAME — VARCHAR(100)
  • CEO_NAME — VARCHAR(50)
  • PHONE — VARCHAR(20)
  • ADDRESS — VARCHAR(200)
  • ACCOUNT_NO — VARCHAR(50)
  • BANK_NAME — VARCHAR(50)