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