A

Tables (18)

ATTACHMENT

  • ATTACHMENT_ID — NUMBER(19) — Primary key — NOT NULL
  • DOCUMENT_TYPE — VARCHAR2(30) — NOT NULL
  • DOCUMENT_ID — NUMBER(19) — NOT NULL
  • ORIGINAL_NAME — VARCHAR2(255) — NOT NULL
  • SAVED_NAME — VARCHAR2(255) — NOT NULL
  • FILE_PATH — VARCHAR2(1000) — NOT NULL
  • FILE_SIZE — NUMBER(19) — NOT NULL
  • CONTENT_TYPE — VARCHAR2(150)
  • CREATED_AT — TIMESTAMP — NOT NULL

BUSINESS_PARTNER

  • PARTNER_ID — NUMBER(19) — Primary key — NOT NULL
  • PARTNER_CODE — VARCHAR2(30) — NOT NULL
  • PARTNER_NAME — VARCHAR2(150) — NOT NULL
  • PARTNER_TYPE — VARCHAR2(20) — NOT NULL
  • BUSINESS_NO — VARCHAR2(30)
  • REPRESENTATIVE — VARCHAR2(100)
  • PHONE — VARCHAR2(30)
  • EMAIL — VARCHAR2(200)
  • ADDRESS — VARCHAR2(500)
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • DEFAULT_CURRENCY_CODE — VARCHAR2(10) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

EMPLOYEE

  • EMPLOYEE_ID — NUMBER(19) — Primary key — NOT NULL
  • EMPLOYEE_CODE — VARCHAR2(30) — NOT NULL
  • EMPLOYEE_NAME — VARCHAR2(100) — NOT NULL
  • DEPARTMENT_NAME — VARCHAR2(100)
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

ESTIMATE_HEADER

  • ESTIMATE_ID — NUMBER(19) — Primary key — NOT NULL
  • ESTIMATE_NO — VARCHAR2(40) — NOT NULL
  • ESTIMATE_DATE — DATE — NOT NULL
  • PARTNER_ID — NUMBER(19) — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID
  • CURRENCY_CODE — VARCHAR2(10) — NOT NULL
  • EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
  • TRANSACTION_TYPE — VARCHAR2(30)
  • PROJECT_NAME — VARCHAR2(100)
  • STATUS — VARCHAR2(30) — NOT NULL
  • TOTAL_SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

ESTIMATE_LINE

  • ESTIMATE_LINE_ID — NUMBER(19) — Primary key — NOT NULL
  • ESTIMATE_ID — NUMBER(19) — Foreign key → ESTIMATE_HEADER.ESTIMATE_ID — NOT NULL
  • LINE_NO — NUMBER(10) — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • UNIT_PRICE — NUMBER(18,4) — NOT NULL
  • SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • REMARK — VARCHAR2(500)

ITEM

  • ITEM_ID — NUMBER(19) — Primary key — NOT NULL
  • ITEM_CODE — VARCHAR2(30) — NOT NULL
  • ITEM_NAME — VARCHAR2(150) — NOT NULL
  • SPECIFICATION — VARCHAR2(200)
  • BARCODE — VARCHAR2(100)
  • BASE_UNIT — VARCHAR2(30) — NOT NULL
  • INBOUND_PRICE — NUMBER(18,4) — NOT NULL
  • OUTBOUND_PRICE — NUMBER(18,4) — NOT NULL
  • STOCK_MANAGED_YN — CHAR(1) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

PAYMENT

  • PAYMENT_ID — NUMBER(19) — Primary key — NOT NULL
  • SALE_ID — NUMBER(19) — Foreign key → SALE_HEADER.SALE_ID — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(30) — NOT NULL
  • AMOUNT — NUMBER(18,2) — NOT NULL
  • MERCHANT_NO — VARCHAR2(100)
  • APPROVAL_NO — VARCHAR2(100)
  • PAYMENT_STATUS — VARCHAR2(20) — NOT NULL
  • APPROVED_AT — TIMESTAMP
  • CANCELED_AT — TIMESTAMP
  • CANCEL_REASON — VARCHAR2(500)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SALES_ORDER_HEADER

  • ORDER_ID — NUMBER(19) — Primary key — NOT NULL
  • ORDER_NO — VARCHAR2(40) — NOT NULL
  • ORDER_DATE — DATE — NOT NULL
  • DELIVERY_DATE — DATE
  • PARTNER_ID — NUMBER(19) — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID
  • CURRENCY_CODE — VARCHAR2(10) — NOT NULL
  • EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
  • TRANSACTION_TYPE — VARCHAR2(30)
  • PROJECT_NAME — VARCHAR2(100)
  • STATUS — VARCHAR2(30) — NOT NULL
  • TOTAL_SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SALES_ORDER_LINE

  • ORDER_LINE_ID — NUMBER(19) — Primary key — NOT NULL
  • ORDER_ID — NUMBER(19) — Foreign key → SALES_ORDER_HEADER.ORDER_ID — NOT NULL
  • ESTIMATE_LINE_ID — NUMBER(19) — Foreign key → ESTIMATE_LINE.ESTIMATE_LINE_ID
  • LINE_NO — NUMBER(10) — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • UNIT_PRICE — NUMBER(18,4) — NOT NULL
  • SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • DELIVERY_DATE — DATE
  • REMARK — VARCHAR2(500)

SALE_HEADER

  • SALE_ID — NUMBER(19) — Primary key — NOT NULL
  • SALE_NO — VARCHAR2(40) — NOT NULL
  • SALE_DATE — DATE — NOT NULL
  • PARTNER_ID — NUMBER(19) — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • CURRENCY_CODE — VARCHAR2(10) — NOT NULL
  • EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
  • TRANSACTION_TYPE — VARCHAR2(30)
  • PROJECT_NAME — VARCHAR2(100)
  • STATUS — VARCHAR2(30) — NOT NULL
  • ACCOUNTING_STATUS — VARCHAR2(30) — NOT NULL
  • ADJUSTMENT_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SALE_LINE

  • SALE_LINE_ID — NUMBER(19) — Primary key — NOT NULL
  • SALE_ID — NUMBER(19) — Foreign key → SALE_HEADER.SALE_ID — NOT NULL
  • ORDER_LINE_ID — NUMBER(19) — Foreign key → SALES_ORDER_LINE.ORDER_LINE_ID
  • LINE_NO — NUMBER(10) — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • UNIT_PRICE — NUMBER(18,4) — NOT NULL
  • DISCOUNT_AMOUNT — NUMBER(18,2) — NOT NULL
  • SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
  • TAX_AMOUNT — NUMBER(18,2) — NOT NULL
  • TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
  • SERIAL_LOT — VARCHAR2(100)
  • REMARK — VARCHAR2(500)

SHIPMENT_HEADER

  • SHIPMENT_ID — NUMBER(19) — Primary key — NOT NULL
  • SHIPMENT_NO — VARCHAR2(40) — NOT NULL
  • SHIPMENT_DATE — DATE — NOT NULL
  • PARTNER_ID — NUMBER(19) — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • PROJECT_NAME — VARCHAR2(100)
  • CONTACT — VARCHAR2(100)
  • ZIP_CODE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(500)
  • STATUS — VARCHAR2(30) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SHIPMENT_LINE

  • SHIPMENT_LINE_ID — NUMBER(19) — Primary key — NOT NULL
  • SHIPMENT_ID — NUMBER(19) — Foreign key → SHIPMENT_HEADER.SHIPMENT_ID — NOT NULL
  • INSTRUCTION_LINE_ID — NUMBER(19) — Foreign key → SHIPPING_INSTRUCTION_LINE.INSTRUCTION_LINE_ID
  • LINE_NO — NUMBER(10) — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • REMARK — VARCHAR2(500)

SHIPPING_INSTRUCTION_HEADER

  • INSTRUCTION_ID — NUMBER(19) — Primary key — NOT NULL
  • INSTRUCTION_NO — VARCHAR2(40) — NOT NULL
  • INSTRUCTION_DATE — DATE — NOT NULL
  • PLANNED_DATE — DATE
  • PARTNER_ID — NUMBER(19) — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER(19) — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • PROJECT_NAME — VARCHAR2(100)
  • CONTACT — VARCHAR2(100)
  • ZIP_CODE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(500)
  • STATUS — VARCHAR2(30) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

SHIPPING_INSTRUCTION_LINE

  • INSTRUCTION_LINE_ID — NUMBER(19) — Primary key — NOT NULL
  • INSTRUCTION_ID — NUMBER(19) — Foreign key → SHIPPING_INSTRUCTION_HEADER.INSTRUCTION_ID — NOT NULL
  • SALE_LINE_ID — NUMBER(19) — Foreign key → SALE_LINE.SALE_LINE_ID
  • LINE_NO — NUMBER(10) — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • REMARK — VARCHAR2(500)

STOCK

  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL

STOCK_LEDGER

  • LEDGER_ID — NUMBER(19) — Primary key — NOT NULL
  • ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • WAREHOUSE_ID — NUMBER(19) — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • SALE_LINE_ID — NUMBER(19) — Foreign key → SALE_LINE.SALE_LINE_ID
  • MOVEMENT_TYPE — VARCHAR2(30) — NOT NULL
  • QTY — NUMBER(18,4) — NOT NULL
  • REMARK — VARCHAR2(500)
  • MOVEMENT_AT — TIMESTAMP — NOT NULL

WAREHOUSE

  • WAREHOUSE_ID — NUMBER(19) — Primary key — NOT NULL
  • WAREHOUSE_CODE — VARCHAR2(20) — NOT NULL
  • WAREHOUSE_NAME — VARCHAR2(100) — NOT NULL
  • WAREHOUSE_TYPE — VARCHAR2(30) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • UPDATED_AT — TIMESTAMP — NOT NULL