테스트1
테이블 (34)
TB_BUSINESS_PARTNER
- BUSINESS_PARTNER_ID — NUMBER — 기본 키 — NOT NULL
- PARTNER_CODE — VARCHAR2(100) — NOT NULL
- PARTNER_NAME — VARCHAR2(100) — NOT NULL
- CODE_TYPE — VARCHAR2(20) — NOT NULL
- REPRESENTATIVE_NAME — VARCHAR2(100)
- BUSINESS_TYPE — VARCHAR2(100)
- BUSINESS_ITEM — VARCHAR2(100)
- PHONE_NUMBER — VARCHAR2(30)
- FAX_NUMBER — VARCHAR2(30)
- MOBILE_NUMBER — VARCHAR2(30)
- EMAIL — VARCHAR2(254)
- SEARCH_KEYWORD — VARCHAR2(200)
- POSTAL_CODE1 — VARCHAR2(10)
- ADDRESS1 — VARCHAR2(300)
- ADDRESS_DETAIL1 — VARCHAR2(300)
- POSTAL_CODE2 — VARCHAR2(10)
- ADDRESS2 — VARCHAR2(300)
- ADDRESS_DETAIL2 — VARCHAR2(300)
- HOMEPAGE_URL — VARCHAR2(500)
- TAX_PARTNER_MODE — VARCHAR2(10) — NOT NULL
- TAX_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID
- TAX_PARTNER_CODE — VARCHAR2(100)
- BRANCH_NUMBER — VARCHAR2(20)
- INDUSTRY_CLASS — VARCHAR2(20)
- CURRENCY_ID — NUMBER — 외래 키 → TB_CURRENCY.CURRENCY_ID
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- NOTE — VARCHAR2(1000)
- SHIPMENT_TARGET_YN — CHAR(1) — NOT NULL
- SALES_TRANS_TYPE — VARCHAR2(20)
- PURCHASE_TRANS_TYPE — VARCHAR2(20)
- COLLECTION_RULE — VARCHAR2(20) — NOT NULL
- OFFSET_DAYS — NUMBER(5)
- OFFSET_MONTHS — NUMBER(3)
- DAY_OF_MONTH — NUMBER(2)
- OFFSET_WEEKS — NUMBER(3)
- DAY_OF_WEEK — NUMBER(1)
- RECEIVABLE_NO_MODE — VARCHAR2(20) — NOT NULL
- PAYABLE_NO_MODE — VARCHAR2(20) — NOT NULL
- CREDIT_LIMIT — NUMBER(18,2) — NOT NULL
- OUTBOUND_ADJUST_RATE — NUMBER(9,4) — NOT NULL
- INBOUND_ADJUST_RATE — NUMBER(9,4) — NOT NULL
- SALES_PRICE_GROUP_ID — NUMBER — 외래 키 → TB_PRICE_GROUP.PRICE_GROUP_ID
- PUR_PRICE_GROUP_ID — NUMBER — 외래 키 → TB_PRICE_GROUP.PRICE_GROUP_ID
- CREDIT_PERIOD_DAYS — NUMBER(5)
- GROUP1_ID — NUMBER — 외래 키 → TB_PARTNER_GROUP.PARTNER_GROUP_ID
- GROUP2_ID — NUMBER — 외래 키 → TB_PARTNER_GROUP.PARTNER_GROUP_ID
- HIERARCHY_GROUP_ID — NUMBER — 외래 키 → TB_PARTNER_GROUP.PARTNER_GROUP_ID
- CUSTOM_TEXT1 — VARCHAR2(500)
- CUSTOM_TEXT2 — VARCHAR2(500)
- CUSTOM_TEXT3 — VARCHAR2(500)
- CUSTOM_TEXT4 — VARCHAR2(500)
- CUSTOM_TEXT5 — VARCHAR2(500)
- CUSTOM_TEXT6 — VARCHAR2(500)
- CUSTOM_NUMBER1 — NUMBER(18,4)
- CUSTOM_NUMBER2 — NUMBER(18,4)
- CUSTOM_NUMBER3 — NUMBER(18,4)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- … +1
TB_CURRENCY
- CURRENCY_ID — NUMBER — 기본 키 — NOT NULL
- CURRENCY_CODE — VARCHAR2(10) — NOT NULL
- CURRENCY_NAME — VARCHAR2(50) — NOT NULL
- EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
- DECIMAL_PLACES — NUMBER(1) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_INVENTORY
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- QUANTITY — NUMBER(18,4) — NOT NULL
- SAFE_STOCK_QTY — NUMBER(18,4)
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_ITEM
- ITEM_ID — NUMBER — 기본 키 — NOT NULL
- ITEM_CODE — VARCHAR2(50) — NOT NULL
- ITEM_NAME — VARCHAR2(100) — NOT NULL
- SPEC_MODE — VARCHAR2(20) — NOT NULL
- SPECIFICATION — VARCHAR2(100)
- UNIT_NAME — VARCHAR2(20)
- ITEM_TYPE — VARCHAR2(20) — NOT NULL
- SET_YN — CHAR(1) — NOT NULL
- INVENTORY_CONTROL_YN — CHAR(1) — NOT NULL
- SALES_VAT_RATE — NUMBER(5,2) — NOT NULL
- PURCHASE_VAT_RATE — NUMBER(5,2) — NOT NULL
- BARCODE — VARCHAR2(100)
- SEARCH_KEYWORD — VARCHAR2(200)
- CPORTAL_SHARE_YN — CHAR(1) — NOT NULL
- IMAGE_PATH — VARCHAR2(500)
- FILE_PATH — VARCHAR2(500)
- NOTE — VARCHAR2(1000)
- PROD_PROCESS_ID — NUMBER — 외래 키 → TB_PROD_PROCESS.PROD_PROCESS_ID
- GROUP1_ID — NUMBER — 외래 키 → TB_ITEM_GROUP.ITEM_GROUP_ID
- GROUP2_ID — NUMBER — 외래 키 → TB_ITEM_GROUP.ITEM_GROUP_ID
- GROUP3_ID — NUMBER — 외래 키 → TB_ITEM_GROUP.ITEM_GROUP_ID
- HIERARCHY_GROUP_ID — NUMBER — 외래 키 → TB_ITEM_GROUP.ITEM_GROUP_ID
- QUALITY_INSP_TYPE_ID — NUMBER — 외래 키 → TB_QUALITY_INSP_TYPE.QUALITY_INSP_TYPE_ID
- QUALITY_INSP_METHOD — VARCHAR2(20)
- CONVERSION_NUMERATOR — NUMBER(18,6) — NOT NULL
- CONVERSION_DENOMINATOR — NUMBER(18,6) — NOT NULL
- SAFE_ORDER_YN — CHAR(1) — NOT NULL
- SAFE_SALE_YN — CHAR(1) — NOT NULL
- SAFE_PROD_ISSUE_YN — CHAR(1) — NOT NULL
- SAFE_PROD_RECEIPT_YN — CHAR(1) — NOT NULL
- SAFE_TRANSFER_YN — CHAR(1) — NOT NULL
- SAFE_SELF_USE_YN — CHAR(1) — NOT NULL
- SAFE_DEFECT_YN — CHAR(1) — NOT NULL
- DEFAULT_SAFE_STOCK_QTY — NUMBER(18,4) — NOT NULL
- CPORTAL_MIN_CHECK_YN — CHAR(1) — NOT NULL
- CPORTAL_MIN_ORDER_QTY — NUMBER(18,4)
- CPORTAL_ORDER_UNIT — VARCHAR2(20)
- PROCUREMENT_DAYS — NUMBER(5)
- MIN_PURCHASE_UNIT — NUMBER(18,4)
- PREFERRED_SUPPLIER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID
- STD_LABOR_TIME — NUMBER(18,4)
- EXPENSE_WEIGHT — NUMBER(18,4)
- STD_COST_MATERIAL — NUMBER(18,2)
- STD_COST_EXPENSE — NUMBER(18,2)
- STD_COST_LABOR — NUMBER(18,2)
- STD_COST_OUTSOURCING — NUMBER(18,2)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_ITEM_GROUP
- ITEM_GROUP_ID — NUMBER — 기본 키 — NOT NULL
- GROUP_TYPE — VARCHAR2(10) — NOT NULL
- GROUP_CODE — VARCHAR2(20) — NOT NULL
- GROUP_NAME — VARCHAR2(100) — NOT NULL
- PARENT_GROUP_ID — NUMBER — 외래 키 → TB_ITEM_GROUP.ITEM_GROUP_ID
- USE_YN — CHAR(1) — NOT NULL
TB_ITEM_PRICE
- ITEM_PRICE_ID — NUMBER — 기본 키 — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- PRICE_TYPE — VARCHAR2(20) — NOT NULL
- PRICE_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_INCLUDED_YN — CHAR(1) — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_MANAGER
- MANAGER_ID — NUMBER — 기본 키 — NOT NULL
- EMPLOYEE_CODE — VARCHAR2(20) — NOT NULL
- EMPLOYEE_NAME — VARCHAR2(50) — NOT NULL
- SEARCH_KEYWORD — VARCHAR2(200)
- POSITION_NAME — VARCHAR2(50)
- CONTACT_NUMBER — VARCHAR2(30)
- EMAIL — VARCHAR2(254)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_ORDER_SALE_LINK
- ORDER_ITEM_ID — NUMBER — 외래 키 → TB_SALES_ORDER_ITEM.ORDER_ITEM_ID — NOT NULL
- SALE_ITEM_ID — NUMBER — 외래 키 → TB_SALE_ITEM.SALE_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_PARTNER_GROUP
- PARTNER_GROUP_ID — NUMBER — 기본 키 — NOT NULL
- GROUP_TYPE — VARCHAR2(10) — NOT NULL
- GROUP_CODE — VARCHAR2(20) — NOT NULL
- GROUP_NAME — VARCHAR2(100) — NOT NULL
- PARENT_GROUP_ID — NUMBER — 외래 키 → TB_PARTNER_GROUP.PARTNER_GROUP_ID
- USE_YN — CHAR(1) — NOT NULL
TB_PAYMENT
- PAYMENT_ID — NUMBER — 기본 키 — NOT NULL
- SALE_ID — NUMBER — 외래 키 → TB_SALE.SALE_ID — NOT NULL
- REQUESTED_AT — TIMESTAMP — NOT NULL
- REQUESTER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID
- COMPANY_CODE — VARCHAR2(50)
- VAN_CODE — VARCHAR2(50)
- PAYMENT_METHOD — VARCHAR2(20) — NOT NULL
- INSTALLMENT_MONTHS — NUMBER(2)
- RECEIPT_TYPE — VARCHAR2(20)
- EASY_PAYMENT_NO — VARCHAR2(100)
- RECEIPT_PRINT_YN — CHAR(1) — NOT NULL
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- PAYMENT_AMOUNT — NUMBER(18,2) — NOT NULL
- PAYMENT_STATUS — VARCHAR2(20) — NOT NULL
- APPROVAL_NUMBER — VARCHAR2(100)
- FAILURE_REASON — VARCHAR2(500)
- INVENTORY_VOUCHER_NO — VARCHAR2(30)
- ACCOUNTING_VOUCHER_NO — VARCHAR2(30)
- FORCED_YN — CHAR(1) — NOT NULL
- CANCELLED_AT — TIMESTAMP
TB_PRICE_GROUP
- PRICE_GROUP_ID — NUMBER — 기본 키 — NOT NULL
- GROUP_TYPE — VARCHAR2(10) — NOT NULL
- GROUP_CODE — VARCHAR2(20) — NOT NULL
- GROUP_NAME — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_PROD_PROCESS
- PROD_PROCESS_ID — NUMBER — 기본 키 — NOT NULL
- PROCESS_CODE — VARCHAR2(20) — NOT NULL
- PROCESS_NAME — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_PROJECT
- PROJECT_ID — NUMBER — 기본 키 — NOT NULL
- PROJECT_CODE — VARCHAR2(20) — NOT NULL
- PROJECT_NAME — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_QUALITY_INSP_TYPE
- QUALITY_INSP_TYPE_ID — NUMBER — 기본 키 — NOT NULL
- INSPECTION_CODE — VARCHAR2(20) — NOT NULL
- INSPECTION_NAME — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_QUOTATION
- QUOTE_ID — NUMBER — 기본 키 — NOT NULL
- VOUCHER_NO — VARCHAR2(30) — NOT NULL
- QUOTE_DATE — DATE — NOT NULL
- VALID_UNTIL — DATE
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID
- TRANSACTION_TYPE — VARCHAR2(20)
- CURRENCY_ID — NUMBER — 외래 키 → TB_CURRENCY.CURRENCY_ID
- EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → TB_PROJECT.PROJECT_ID
- ATTACHMENT_PATH — VARCHAR2(500)
- CUSTOM_DATA — CLOB
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- VOUCHER_STATUS — VARCHAR2(20) — NOT NULL
- PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_QUOTATION_ITEM
- QUOTE_ITEM_ID — NUMBER — 기본 키 — NOT NULL
- QUOTE_ID — NUMBER — 외래 키 → TB_QUOTATION.QUOTE_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- ITEM_CODE_SNAP — VARCHAR2(50) — NOT NULL
- ITEM_NAME_SNAP — VARCHAR2(100) — NOT NULL
- SPEC_SNAP — VARCHAR2(100)
- UNIT_SNAP — VARCHAR2(20)
- QUANTITY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,2) — NOT NULL
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CUSTOM_DATA — CLOB
TB_QUOTE_ORDER_LINK
- QUOTE_ITEM_ID — NUMBER — 외래 키 → TB_QUOTATION_ITEM.QUOTE_ITEM_ID — NOT NULL
- ORDER_ITEM_ID — NUMBER — 외래 키 → TB_SALES_ORDER_ITEM.ORDER_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_QUOTE_SALE_LINK
- QUOTE_ITEM_ID — NUMBER — 외래 키 → TB_QUOTATION_ITEM.QUOTE_ITEM_ID — NOT NULL
- SALE_ITEM_ID — NUMBER — 외래 키 → TB_SALE_ITEM.SALE_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_SALE
- SALE_ID — NUMBER — 기본 키 — NOT NULL
- VOUCHER_NO — VARCHAR2(30) — NOT NULL
- SALE_DATE — DATE — NOT NULL
- SALE_INPUT_TYPE — VARCHAR2(10) — NOT NULL
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID — NOT NULL
- TRANSACTION_TYPE — VARCHAR2(20)
- CURRENCY_ID — NUMBER — 외래 키 → TB_CURRENCY.CURRENCY_ID
- EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → TB_PROJECT.PROJECT_ID
- ATTACHMENT_PATH — VARCHAR2(500)
- CUSTOM_DATA — CLOB
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- ADJUSTMENT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- VOUCHER_STATUS — VARCHAR2(20) — NOT NULL
- PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
- PAYMENT_STATUS — VARCHAR2(20) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_SALES_ORDER
- ORDER_ID — NUMBER — 기본 키 — NOT NULL
- VOUCHER_NO — VARCHAR2(30) — NOT NULL
- ORDER_DATE — DATE — NOT NULL
- DUE_DATE — DATE
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID
- TRANSACTION_TYPE — VARCHAR2(20)
- CURRENCY_ID — NUMBER — 외래 키 → TB_CURRENCY.CURRENCY_ID
- EXCHANGE_RATE — NUMBER(18,6) — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → TB_PROJECT.PROJECT_ID
- ATTACHMENT_PATH — VARCHAR2(500)
- CUSTOM_DATA — CLOB
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- DELETED_YN — CHAR(1) — NOT NULL
- PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_SALES_ORDER_ITEM
- ORDER_ITEM_ID — NUMBER — 기본 키 — NOT NULL
- ORDER_ID — NUMBER — 외래 키 → TB_SALES_ORDER.ORDER_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- ITEM_CODE_SNAP — VARCHAR2(50) — NOT NULL
- ITEM_NAME_SNAP — VARCHAR2(100) — NOT NULL
- SPEC_SNAP — VARCHAR2(100)
- UNIT_SNAP — VARCHAR2(20)
- QUANTITY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,2) — NOT NULL
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- DUE_DATE — DATE
- REMARKS — VARCHAR2(1000)
- CUSTOM_DATA — CLOB
TB_SALE_ADJUSTMENT
- ADJUSTMENT_ID — NUMBER — 기본 키 — NOT NULL
- SALE_ID — NUMBER — 외래 키 → TB_SALE.SALE_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ADJUSTMENT_NAME — VARCHAR2(100) — NOT NULL
- INCREASE_DECREASE — VARCHAR2(10) — NOT NULL
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_RATE — NUMBER(5,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
TB_SALE_ITEM
- SALE_ITEM_ID — NUMBER — 기본 키 — NOT NULL
- SALE_ID — NUMBER — 외래 키 → TB_SALE.SALE_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- ITEM_CODE_SNAP — VARCHAR2(50) — NOT NULL
- ITEM_NAME_SNAP — VARCHAR2(100) — NOT NULL
- SPEC_SNAP — VARCHAR2(100)
- UNIT_SNAP — VARCHAR2(20)
- SERIAL_LOT_NO — VARCHAR2(100)
- QUANTITY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,2) — NOT NULL
- SUPPLY_AMOUNT — NUMBER(18,2) — NOT NULL
- VAT_AMOUNT — NUMBER(18,2) — NOT NULL
- TOTAL_AMOUNT — NUMBER(18,2) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CUSTOM_DATA — CLOB
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_SALE_ORIGIN_LINK
- SRC_SALE_ITEM_ID — NUMBER — 외래 키 → TB_SALE_ITEM.SALE_ITEM_ID — NOT NULL
- SALE_ITEM_ID — NUMBER — 외래 키 → TB_SALE_ITEM.SALE_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_SALE_SHIPPING_LINK
- SALE_ITEM_ID — NUMBER — 외래 키 → TB_SALE_ITEM.SALE_ITEM_ID — NOT NULL
- SHIPPING_ORDER_ITEM_ID — NUMBER — 외래 키 → TB_SHIPPING_ORDER_ITEM.SHIPPING_ORDER_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_SHIPMENT
- SHIPMENT_ID — NUMBER — 기본 키 — NOT NULL
- VOUCHER_NO — VARCHAR2(30) — NOT NULL
- SHIPMENT_DATE — DATE — NOT NULL
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → TB_PROJECT.PROJECT_ID
- CONTACT_NUMBER — VARCHAR2(50)
- POSTAL_CODE — VARCHAR2(10)
- ADDRESS — VARCHAR2(500)
- CUSTOM_DATA — CLOB
- VOUCHER_STATUS — VARCHAR2(20) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_SHIPMENT_ITEM
- SHIPMENT_ITEM_ID — NUMBER — 기본 키 — NOT NULL
- SHIPMENT_ID — NUMBER — 외래 키 → TB_SHIPMENT.SHIPMENT_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- ITEM_CODE_SNAP — VARCHAR2(50) — NOT NULL
- ITEM_NAME_SNAP — VARCHAR2(100) — NOT NULL
- SPEC_SNAP — VARCHAR2(100)
- UNIT_SNAP — VARCHAR2(20)
- QUANTITY — NUMBER(18,4) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CUSTOM_DATA — CLOB
TB_SHIPPING_ORDER
- SHIPPING_ORDER_ID — NUMBER — 기본 키 — NOT NULL
- VOUCHER_NO — VARCHAR2(30) — NOT NULL
- SHIPPING_ORDER_DATE — DATE — NOT NULL
- BUSINESS_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID — NOT NULL
- MANAGER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID — NOT NULL
- PROJECT_ID — NUMBER — 외래 키 → TB_PROJECT.PROJECT_ID
- CONTACT_NUMBER — VARCHAR2(50)
- PLANNED_SHIP_DATE — DATE
- POSTAL_CODE — VARCHAR2(10)
- ADDRESS — VARCHAR2(500)
- CUSTOM_DATA — CLOB
- PROGRESS_STATUS — VARCHAR2(20) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_SHIPPING_ORDER_ITEM
- SHIPPING_ORDER_ITEM_ID — NUMBER — 기본 키 — NOT NULL
- SHIPPING_ORDER_ID — NUMBER — 외래 키 → TB_SHIPPING_ORDER.SHIPPING_ORDER_ID — NOT NULL
- LINE_NO — NUMBER(5) — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- ITEM_CODE_SNAP — VARCHAR2(50) — NOT NULL
- ITEM_NAME_SNAP — VARCHAR2(100) — NOT NULL
- SPEC_SNAP — VARCHAR2(100)
- UNIT_SNAP — VARCHAR2(20)
- QUANTITY — NUMBER(18,4) — NOT NULL
- REMARKS — VARCHAR2(1000)
- CUSTOM_DATA — CLOB
TB_SHIP_RESULT_LINK
- SHIPPING_ORDER_ITEM_ID — NUMBER — 외래 키 → TB_SHIPPING_ORDER_ITEM.SHIPPING_ORDER_ITEM_ID — NOT NULL
- SHIPMENT_ITEM_ID — NUMBER — 외래 키 → TB_SHIPMENT_ITEM.SHIPMENT_ITEM_ID — NOT NULL
- APPLIED_QTY — NUMBER(18,4) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
TB_STOCK_MOVEMENT
- MOVEMENT_ID — NUMBER — 기본 키 — NOT NULL
- WAREHOUSE_ID — NUMBER — 외래 키 → TB_WAREHOUSE.WAREHOUSE_ID — NOT NULL
- ITEM_ID — NUMBER — 외래 키 → TB_ITEM.ITEM_ID — NOT NULL
- MOVEMENT_TYPE — VARCHAR2(20) — NOT NULL
- QUANTITY_CHANGE — NUMBER(18,4) — NOT NULL
- REFERENCE_TYPE — VARCHAR2(30)
- REFERENCE_ID — NUMBER
- MOVED_AT — TIMESTAMP — NOT NULL
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
TB_VOUCHER_HISTORY
- HISTORY_ID — NUMBER — 기본 키 — NOT NULL
- DOCUMENT_TYPE — VARCHAR2(30) — NOT NULL
- DOCUMENT_ID — NUMBER — NOT NULL
- ACTION_TYPE — VARCHAR2(20) — NOT NULL
- BEFORE_STATUS — VARCHAR2(20)
- AFTER_STATUS — VARCHAR2(20)
- WORKER_ID — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- WORKED_AT — TIMESTAMP — NOT NULL
- DESCRIPTION — VARCHAR2(1000)
TB_WAREHOUSE
- WAREHOUSE_ID — NUMBER — 기본 키 — NOT NULL
- WAREHOUSE_CODE — VARCHAR2(20) — NOT NULL
- WAREHOUSE_NAME — VARCHAR2(100) — NOT NULL
- WAREHOUSE_TYPE — VARCHAR2(20) — NOT NULL
- PROD_PROCESS_ID — NUMBER — 외래 키 → TB_PROD_PROCESS.PROD_PROCESS_ID
- OUTSOURCE_PARTNER_ID — NUMBER — 외래 키 → TB_BUSINESS_PARTNER.BUSINESS_PARTNER_ID
- SALES_VAT_MODE — VARCHAR2(10) — NOT NULL
- SALES_VAT_RATE — NUMBER(5,2)
- PURCHASE_VAT_MODE — VARCHAR2(10) — NOT NULL
- PURCHASE_VAT_RATE — NUMBER(5,2)
- SALES_PRICE_GROUP_ID — NUMBER — 외래 키 → TB_PRICE_GROUP.PRICE_GROUP_ID
- PUR_PRICE_GROUP_ID — NUMBER — 외래 키 → TB_PRICE_GROUP.PRICE_GROUP_ID
- WAREHOUSE_GROUP_ID — NUMBER — 외래 키 → TB_WAREHOUSE_GROUP.WAREHOUSE_GROUP_ID
- USE_YN — CHAR(1) — NOT NULL
- CREATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_BY — NUMBER — 외래 키 → TB_MANAGER.MANAGER_ID
- UPDATED_AT — TIMESTAMP — NOT NULL
TB_WAREHOUSE_GROUP
- WAREHOUSE_GROUP_ID — NUMBER — 기본 키 — NOT NULL
- GROUP_CODE — VARCHAR2(20) — NOT NULL
- GROUP_NAME — VARCHAR2(100) — NOT NULL
- PARENT_GROUP_ID — NUMBER — 외래 키 → TB_WAREHOUSE_GROUP.WAREHOUSE_GROUP_ID
- USE_YN — CHAR(1) — NOT NULL