테스트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