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)