1

Tables (28)

AMOUNT_ADJUSTMENT_TYPE

  • ADJUSTMENT_TYPE_ID — NUMBER — Primary key — NOT NULL
  • ADJUSTMENT_CODE — VARCHAR2(20) — NOT NULL
  • ADJUSTMENT_NAME — VARCHAR2(100) — NOT NULL
  • ADJUSTMENT_DIRECTION — VARCHAR2(20) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL

BUSINESS_PARTNER

  • PARTNER_ID — NUMBER — Primary key — NOT NULL
  • PARTNER_CODE — VARCHAR2(20) — NOT NULL
  • PARTNER_NAME — VARCHAR2(100) — NOT NULL
  • PARTNER_TYPE — VARCHAR2(20) — NOT NULL
  • BUSINESS_NO — VARCHAR2(20)
  • REPRESENTATIVE — VARCHAR2(50)
  • BUSINESS_TYPE — VARCHAR2(100)
  • BUSINESS_ITEM — VARCHAR2(100)
  • ADDRESS — VARCHAR2(300)
  • PHONE — VARCHAR2(30)
  • FAX — VARCHAR2(30)
  • EMAIL — VARCHAR2(100)
  • CURRENCY_ID — NUMBER — Foreign key → CURRENCY.CURRENCY_ID
  • SALES_PRICE_GROUP_ID — NUMBER — Foreign key → PRICE_GROUP.PRICE_GROUP_ID
  • PURCHASE_PRICE_GROUP_ID — NUMBER — Foreign key → PRICE_GROUP.PRICE_GROUP_ID
  • CREDIT_LIMIT — NUMBER(18,2)
  • PAYMENT_TERM — VARCHAR2(100)
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

CURRENCY

  • CURRENCY_ID — NUMBER — Primary key — NOT NULL
  • CURRENCY_CODE — VARCHAR2(10) — NOT NULL
  • CURRENCY_NAME — VARCHAR2(50) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL

DOCUMENT_HISTORY

  • HISTORY_ID — NUMBER — Primary key — NOT NULL
  • DOCUMENT_TYPE — VARCHAR2(30) — NOT NULL
  • DOCUMENT_ID — NUMBER — NOT NULL
  • ACTION_TYPE — VARCHAR2(30) — NOT NULL
  • BEFORE_JSON — CLOB
  • AFTER_JSON — CLOB
  • ACTOR_EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • REASON — VARCHAR2(500)
  • OCCURRED_AT — DATE — NOT NULL

DOCUMENT_LINE_LINK

  • LINK_ID — NUMBER — Primary key — NOT NULL
  • SOURCE_TYPE — VARCHAR2(30) — NOT NULL
  • SOURCE_LINE_ID — NUMBER — NOT NULL
  • TARGET_TYPE — VARCHAR2(30) — NOT NULL
  • TARGET_LINE_ID — NUMBER — NOT NULL
  • LINKED_QTY — NUMBER(18,4) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL

EMPLOYEE

  • EMPLOYEE_ID — NUMBER — Primary key — NOT NULL
  • EMPLOYEE_CODE — VARCHAR2(20) — NOT NULL
  • EMPLOYEE_NAME — VARCHAR2(50) — NOT NULL
  • DEPARTMENT_NAME — VARCHAR2(100)
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

ESTIMATE_HEADER

  • ESTIMATE_ID — NUMBER — Primary key — NOT NULL
  • ESTIMATE_NO — VARCHAR2(30) — NOT NULL
  • ESTIMATE_DATE — DATE — NOT NULL
  • VALID_UNTIL — DATE
  • PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER — Foreign key → WAREHOUSE.WAREHOUSE_ID
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.PROJECT_ID
  • CURRENCY_ID — NUMBER — Foreign key → CURRENCY.CURRENCY_ID
  • EXCHANGE_RATE — NUMBER(18,6)
  • PROGRESS_STATUS — VARCHAR2(20) — 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 — DATE — NOT NULL
  • UPDATED_AT — DATE

ESTIMATE_LINE

  • ESTIMATE_LINE_ID — NUMBER — Primary key — NOT NULL
  • ESTIMATE_ID — NUMBER — Foreign key → ESTIMATE_HEADER.ESTIMATE_ID — NOT NULL
  • LINE_NO — NUMBER — NOT NULL
  • ITEM_ID — NUMBER — 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

ITEM

  • ITEM_ID — NUMBER — Primary key — NOT NULL
  • ITEM_CODE — VARCHAR2(20) — NOT NULL
  • ITEM_NAME — VARCHAR2(100) — NOT NULL
  • SPECIFICATION — VARCHAR2(100)
  • ITEM_GROUP_ID — NUMBER — Foreign key → ITEM_GROUP.ITEM_GROUP_ID
  • ITEM_TYPE — VARCHAR2(30)
  • BARCODE — VARCHAR2(50)
  • BASE_UNIT — VARCHAR2(20)
  • STOCK_MANAGED_YN — CHAR(1) — NOT NULL
  • INBOUND_PRICE — NUMBER(18,4) — NOT NULL
  • OUTBOUND_PRICE — NUMBER(18,4) — NOT NULL
  • SAFETY_STOCK — NUMBER(18,4) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

ITEM_GROUP

  • ITEM_GROUP_ID — NUMBER — Primary key — NOT NULL
  • GROUP_CODE — VARCHAR2(20) — NOT NULL
  • GROUP_NAME — VARCHAR2(100) — NOT NULL
  • PARENT_GROUP_ID — NUMBER — Foreign key → ITEM_GROUP.ITEM_GROUP_ID
  • ACTIVE_YN — CHAR(1) — NOT NULL

PAYMENT

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

PAYMENT_COMPARISON

  • COMPARISON_ID — NUMBER — Primary key — NOT NULL
  • IMPORT_ID — NUMBER — Foreign key → PAYMENT_IMPORT.IMPORT_ID — NOT NULL
  • PAYMENT_ID — NUMBER — Foreign key → PAYMENT.PAYMENT_ID
  • EXTERNAL_APPROVED_AT — DATE
  • EXTERNAL_METHOD — VARCHAR2(30)
  • EXTERNAL_MERCHANT_NO — VARCHAR2(50)
  • EXTERNAL_APPROVAL_NO — VARCHAR2(50)
  • EXTERNAL_AMOUNT — NUMBER(18,2)
  • EXTERNAL_STATUS — VARCHAR2(30)
  • ERP_AMOUNT — NUMBER(18,2)
  • DIFFERENCE_AMOUNT — NUMBER(18,2)
  • COMPARISON_STATUS — VARCHAR2(30) — NOT NULL
  • REASON — VARCHAR2(500)
  • CREATED_AT — DATE — NOT NULL

PAYMENT_IMPORT

  • IMPORT_ID — NUMBER — Primary key — NOT NULL
  • FILE_NAME — VARCHAR2(255) — NOT NULL
  • FILE_CHECKSUM — VARCHAR2(100) — NOT NULL
  • UPLOADED_BY — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • UPLOADED_AT — DATE — NOT NULL
  • TOTAL_ROWS — NUMBER — NOT NULL
  • IMPORT_STATUS — VARCHAR2(20) — NOT NULL

PRICE_GROUP

  • PRICE_GROUP_ID — NUMBER — Primary key — NOT NULL
  • GROUP_CODE — VARCHAR2(20) — NOT NULL
  • GROUP_NAME — VARCHAR2(100) — NOT NULL
  • GROUP_TYPE — VARCHAR2(20) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

PROJECT

  • PROJECT_ID — NUMBER — Primary key — NOT NULL
  • PROJECT_CODE — VARCHAR2(20) — NOT NULL
  • PROJECT_NAME — VARCHAR2(100) — NOT NULL
  • START_DATE — DATE
  • END_DATE — DATE
  • STATUS — VARCHAR2(20)
  • ACTIVE_YN — CHAR(1) — NOT NULL

SALES_ORDER_HEADER

  • ORDER_ID — NUMBER — Primary key — NOT NULL
  • ORDER_NO — VARCHAR2(30) — NOT NULL
  • ORDER_DATE — DATE — NOT NULL
  • DUE_DATE — DATE
  • PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER — Foreign key → WAREHOUSE.WAREHOUSE_ID
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.PROJECT_ID
  • CURRENCY_ID — NUMBER — Foreign key → CURRENCY.CURRENCY_ID
  • EXCHANGE_RATE — NUMBER(18,6)
  • PROGRESS_STATUS — VARCHAR2(20) — 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 — DATE — NOT NULL
  • UPDATED_AT — DATE

SALES_ORDER_LINE

  • ORDER_LINE_ID — NUMBER — Primary key — NOT NULL
  • ORDER_ID — NUMBER — Foreign key → SALES_ORDER_HEADER.ORDER_ID — NOT NULL
  • LINE_NO — NUMBER — NOT NULL
  • ITEM_ID — NUMBER — 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

SALE_AMOUNT_ADJUSTMENT

  • SALE_ADJUSTMENT_ID — NUMBER — Primary key — NOT NULL
  • SALE_ID — NUMBER — Foreign key → SALE_HEADER.SALE_ID — NOT NULL
  • ADJUSTMENT_TYPE_ID — NUMBER — Foreign key → AMOUNT_ADJUSTMENT_TYPE.ADJUSTMENT_TYPE_ID — 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)

SALE_HEADER

  • SALE_ID — NUMBER — Primary key — NOT NULL
  • SALE_NO — VARCHAR2(30) — NOT NULL
  • SALE_DATE — DATE — NOT NULL
  • PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.PROJECT_ID
  • CURRENCY_ID — NUMBER — Foreign key → CURRENCY.CURRENCY_ID
  • TRANSACTION_TYPE_ID — NUMBER — Foreign key → TRANSACTION_TYPE.TRANSACTION_TYPE_ID
  • EXCHANGE_RATE — NUMBER(18,6)
  • SALE_TYPE — VARCHAR2(20)
  • PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
  • ACCOUNTING_STATUS — VARCHAR2(20)
  • 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 — DATE — NOT NULL
  • UPDATED_AT — DATE

SALE_LINE

  • SALE_LINE_ID — NUMBER — Primary key — NOT NULL
  • SALE_ID — NUMBER — Foreign key → SALE_HEADER.SALE_ID — NOT NULL
  • LINE_NO — NUMBER — NOT NULL
  • ITEM_ID — NUMBER — 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
  • SERIAL_LOT — VARCHAR2(100)
  • REMARK — VARCHAR2(500)

SHIPMENT_HEADER

  • SHIPMENT_ID — NUMBER — Primary key — NOT NULL
  • SHIPMENT_NO — VARCHAR2(30) — NOT NULL
  • SHIPMENT_DATE — DATE — NOT NULL
  • PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.PROJECT_ID
  • CONTACT — VARCHAR2(100)
  • ZIP_CODE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(300)
  • PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

SHIPMENT_LINE

  • SHIPMENT_LINE_ID — NUMBER — Primary key — NOT NULL
  • SHIPMENT_ID — NUMBER — Foreign key → SHIPMENT_HEADER.SHIPMENT_ID — NOT NULL
  • LINE_NO — NUMBER — NOT NULL
  • ITEM_ID — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL
  • SHIPMENT_QTY — NUMBER(18,4) — NOT NULL

SHIPPING_INSTRUCTION_HEADER

  • INSTRUCTION_ID — NUMBER — Primary key — NOT NULL
  • INSTRUCTION_NO — VARCHAR2(30) — NOT NULL
  • INSTRUCTION_DATE — DATE — NOT NULL
  • PLANNED_DATE — DATE
  • PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEE.EMPLOYEE_ID
  • WAREHOUSE_ID — NUMBER — Foreign key → WAREHOUSE.WAREHOUSE_ID — NOT NULL
  • PROJECT_ID — NUMBER — Foreign key → PROJECT.PROJECT_ID
  • CONTACT — VARCHAR2(100)
  • ZIP_CODE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(300)
  • PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

SHIPPING_INSTRUCTION_LINE

  • INSTRUCTION_LINE_ID — NUMBER — Primary key — NOT NULL
  • INSTRUCTION_ID — NUMBER — Foreign key → SHIPPING_INSTRUCTION_HEADER.INSTRUCTION_ID — NOT NULL
  • LINE_NO — NUMBER — NOT NULL
  • ITEM_ID — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL
  • INSTRUCTION_QTY — NUMBER(18,4) — NOT NULL

SPECIAL_PRICE

  • SPECIAL_PRICE_ID — NUMBER — Primary key — NOT NULL
  • PRICE_GROUP_ID — NUMBER — Foreign key → PRICE_GROUP.PRICE_GROUP_ID — NOT NULL
  • ITEM_ID — NUMBER — Foreign key → ITEM.ITEM_ID — NOT NULL
  • UNIT_PRICE — NUMBER(18,4) — NOT NULL
  • START_DATE — DATE
  • END_DATE — DATE
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE

STOCK

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

TRANSACTION_TYPE

  • TRANSACTION_TYPE_ID — NUMBER — Primary key — NOT NULL
  • TYPE_CODE — VARCHAR2(20) — NOT NULL
  • TYPE_NAME — VARCHAR2(100) — NOT NULL
  • TAX_TYPE — VARCHAR2(20)
  • TAX_RATE — NUMBER(5,2) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL

WAREHOUSE

  • WAREHOUSE_ID — NUMBER — Primary key — NOT NULL
  • WAREHOUSE_CODE — VARCHAR2(20) — NOT NULL
  • WAREHOUSE_NAME — VARCHAR2(100) — NOT NULL
  • WAREHOUSE_TYPE — VARCHAR2(30) — NOT NULL
  • OUTSOURCING_PARTNER_ID — NUMBER — Foreign key → BUSINESS_PARTNER.PARTNER_ID
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE