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