YEOUN

Tables (50)

ACCESS_LOG

  • ACCESS_DATE — DATE
  • OUT_TIME — TIMESTAMP
  • RETURN_TIME — TIMESTAMP
  • EMP_ID — VARCHAR2(7 CHAR)
  • ACCESS_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • ACCESS_TYPE — VARCHAR2(255 CHAR)
  • REASON — VARCHAR2(255 CHAR)

ALARM

  • ALARM_ID — NUMBER(19,0)
  • ALARM_LINK — VARCHAR2(255 CHAR)
  • ALARM_MESSAGE — VARCHAR2(255 CHAR)
  • ALARM_STATUS — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • EMP_ID — VARCHAR2(255 CHAR)

ANNUAL_LEAVE

  • PERIOD_END — DATE
  • PERIOD_START — DATE
  • REMAIN_DAYS — FLOAT(53)
  • TOTAL_DAYS — FLOAT(53)
  • USE_YEAR — NUMBER(10,0)
  • USED_DAYS — FLOAT(53)
  • EMP_ID — VARCHAR2(7 CHAR)
  • LEAVE_ID — NUMBER(19,0)
  • UPDATED_DATE — TIMESTAMP
  • REASON — VARCHAR2(255 CHAR)
  • UPDATED_USER — VARCHAR2(255 CHAR)

ANNUAL_LEAVE_HISTORY

  • END_DATE — DATE
  • START_DATE — DATE
  • USED_DAYS — NUMBER(10,0)
  • EMP_ID — VARCHAR2(7 CHAR)
  • APPROVAL_ID — NUMBER(19,0)
  • LEAVE_HIST_ID — NUMBER(19,0)
  • LEAVE_ID — NUMBER(19,0)
  • DEPT_ID — VARCHAR2(10 CHAR)
  • LEAVE_TYPE — VARCHAR2(255 CHAR)
  • REASON — VARCHAR2(255 CHAR)

APPROVAL_DOC

  • CREATED_DATE — DATE
  • END_DATE — DATE
  • FINISH_DATE — DATE
  • START_DATE — DATE
  • APPROVAL_ID — NUMBER(19,0)
  • APPROVAL_TITLE — VARCHAR2(255 CHAR)
  • APPROVER — VARCHAR2(255 CHAR)
  • DOC_STATUS — VARCHAR2(255 CHAR)
  • EMP_ID — VARCHAR2(255 CHAR)
  • EXPND_TYPE — VARCHAR2(255 CHAR)
  • FORM_TYPE — VARCHAR2(255 CHAR)
  • LEAVE_TYPE — VARCHAR2(255 CHAR)
  • TO_DEPT_ID — VARCHAR2(255 CHAR)
  • TO_POS_CODE — VARCHAR2(255 CHAR)
  • REASON — VARCHAR2(255 CHAR)

APPROVAL_FORM

  • APPROVER_1 — VARCHAR2(255 CHAR)
  • APPROVER_2 — VARCHAR2(255 CHAR)
  • APPROVER_3 — VARCHAR2(255 CHAR)
  • DEPT_ID — VARCHAR2(255 CHAR)
  • FORM_CODE — VARCHAR2(255 CHAR)
  • FORM_NAME — VARCHAR2(255 CHAR)

APPROVER

  • APPROVAL_STATUS — NUMBER(1,0)
  • APPROVAL_ID — NUMBER(19,0)
  • DELEGATE_STATUS — VARCHAR2(255 CHAR)
  • EMP_ID — VARCHAR2(255 CHAR)
  • ORDER_APPROVERS — VARCHAR2(255 CHAR)
  • VIEWING — VARCHAR2(255 CHAR)

ATTENDANCE

  • WORK_DATE — DATE
  • WORK_DURATION — NUMBER(10,0)
  • WORK_IN — TIMESTAMP
  • WORK_OUT — TIMESTAMP
  • CREATED_USER — VARCHAR2(7 CHAR)
  • EMP_ID — VARCHAR2(7 CHAR)
  • UPDATED_USER — VARCHAR2(7 CHAR)
  • ATTENDANCE_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • UPDATED_DATE — TIMESTAMP
  • REMARK — VARCHAR2(255 CHAR)
  • STATUS_CODE — VARCHAR2(255 CHAR)

BOM_HDR

  • BOM_HDR_ID — VARCHAR2(50 CHAR) — BOM
  • BOM_ID — VARCHAR2(50 CHAR) — BOM
  • BOM_HDR_NAME — VARCHAR2(100 CHAR) — BOM
  • BOM_HDR_TYPE — VARCHAR2(50 CHAR) — BOM
  • USE_YN — VARCHAR2(1 CHAR) — BOM
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • BOM_HDR_DATE — TIMESTAMP
  • CREATED_ID — VARCHAR2(7 BYTE)
  • UPDATED_ID — VARCHAR2(7 BYTE)

CLIENT

  • CLIENT_ID — VARCHAR2(20 CHAR) — 시스템에서
  • ACCOUNT_NAME — VARCHAR2(20 CHAR) — 거래처
  • ACCOUNT_NUMBER — VARCHAR2(30 CHAR) — 거래처
  • ADDR — VARCHAR2(100 CHAR) — 거래처
  • ADDR_DETAIL — VARCHAR2(100 CHAR) — 거래처
  • BANK_NAME — VARCHAR2(20 CHAR) — 거래처
  • BUSINESS_NO — VARCHAR2(20 CHAR) — 사업자
  • CEO_NAME — VARCHAR2(50 CHAR) — 거래처
  • CLIENT_NAME — VARCHAR2(30 CHAR) — 거래처(회사)
  • CLIENT_TYPE — VARCHAR2(20 CHAR) — 거래처의
  • CREATED_BY — VARCHAR2(20 CHAR) — 거래처
  • CREATED_DATE — TIMESTAMP — 거래처
  • FAX_NUMBER — VARCHAR2(30 CHAR) — 거래처
  • MANAGER_DEPT — VARCHAR2(50 CHAR) — 담당자(구매자)의
  • MANAGER_EMAIL — VARCHAR2(100 CHAR) — 담당자
  • MANAGER_NAME — VARCHAR2(50 CHAR) — 우리
  • POST_CODE — VARCHAR2(10 CHAR) — 거래처
  • STATUS_CODE — VARCHAR2(10 CHAR) — 거래처
  • UPDATED_BY — VARCHAR2(20 CHAR) — 마지막으로
  • UPDATED_DATE — TIMESTAMP — 거래처
  • CREATED_AT — TIMESTAMP
  • MANAGER_TEL — VARCHAR2(20 CHAR)
  • UPDATED_AT — TIMESTAMP
  • BIZ_ITEM — VARCHAR2(255 CHAR) — 업종
  • BIZ_TYPE — VARCHAR2(255 CHAR)

CLIENT_ITEM

  • ITEM_ID — NUMBER(19,0) — 공급품목
  • CLIENT_ID — VARCHAR2(20 CHAR) — 해당
  • CREATED_AT — TIMESTAMP — 공급품목
  • CREATED_BY — VARCHAR2(20 CHAR) — 공급품목
  • LEAD_DAYS — NUMBER(10,0) — 발주
  • MATERIAL_ID — VARCHAR2(30 CHAR) — 공급
  • MIN_ORDER_QTY — NUMBER(18,4) — 최소
  • ORDER_UNIT — NUMBER(18,4) — 발주단위
  • SUPPLY_AVAILABLE — VARCHAR2(1 CHAR) — 공급
  • UNIT — VARCHAR2(20 CHAR) — 해당
  • UNIT_PRICE — NUMBER(18,2) — 거래처로부터
  • UPDATED_AT — TIMESTAMP — 공급품목
  • UPDATED_BY — VARCHAR2(20 CHAR) — 공급품목
  • CONV_TO_BASE — NUMBER(18,6)
  • PACK_QTY — NUMBER(18,4)

COMMON_CODE

  • CODE_SEQ — NUMBER(10,0)
  • LEVEL_NO — NUMBER(10,0)
  • USE_YN — VARCHAR2(1 CHAR)
  • CREATED_USER — VARCHAR2(7 CHAR)
  • UPDATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • UPDATED_DATE — TIMESTAMP
  • SYS_TYPE — VARCHAR2(30 CHAR)
  • CODE_ID — VARCHAR2(50 CHAR)
  • PARENT_CODE_ID — VARCHAR2(50 CHAR)
  • CODE_DESC — VARCHAR2(100 CHAR)
  • CODE_NAME — VARCHAR2(100 CHAR)

DEPT

  • USE_YN — VARCHAR2(1 CHAR)
  • HEAD_EMP_ID — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • DEPT_ID — VARCHAR2(10 CHAR)
  • PARENT_ID — VARCHAR2(10 CHAR)
  • DEPT_ABBR — VARCHAR2(20 CHAR)
  • DEPT_NAME — VARCHAR2(50 CHAR)

DISPOSE

  • DISPOSE_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • DISPOSE_AMOUNT — NUMBER(19,0)
  • DISPOSE_REASON — VARCHAR2(255 CHAR)
  • EMP_ID — VARCHAR2(255 CHAR)
  • ITEM_ID — VARCHAR2(255 CHAR)
  • LOT_NO — VARCHAR2(255 CHAR)
  • WORK_TYPE — VARCHAR2(255 CHAR)

EMP

  • GENDER — VARCHAR2(1 CHAR)
  • HIRE_DATE — DATE
  • RETIRE_DATE — DATE
  • EMP_ID — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • LAST_LOGIN — TIMESTAMP
  • PHOTO_FILE_ID — NUMBER(19,0)
  • DEPT_ID — VARCHAR2(10 CHAR)
  • POS_CODE — VARCHAR2(10 CHAR)
  • POST_CODE — VARCHAR2(10 CHAR)
  • STATUS — VARCHAR2(10 CHAR)
  • RRN — VARCHAR2(14 CHAR)
  • MOBILE — VARCHAR2(20 CHAR)
  • EMP_NAME — VARCHAR2(50 CHAR)
  • EMAIL — VARCHAR2(100 CHAR)
  • ADDRESS1 — VARCHAR2(200 CHAR)
  • ADDRESS2 — VARCHAR2(200 CHAR)
  • EMP_PWD — VARCHAR2(200 CHAR)
  • PWD_CHANGE_REQ — VARCHAR2(1 CHAR)

EMP_BANK

  • EMP_ID — VARCHAR2(7 CHAR)
  • BANK_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • FILE_ID — NUMBER(19,0)
  • ACCOUNT_NO — VARCHAR2(30 CHAR)
  • BANK_CODE — VARCHAR2(30 CHAR)
  • HOLDER — VARCHAR2(30 CHAR)

EMP_PAY_ITEM

  • AMOUNT — NUMBER(15,2)
  • SORT_NO — NUMBER(10,0)
  • EMP_PAY_ID — NUMBER(19,0)
  • ITEM_ID — NUMBER(19,0)
  • ITEM_TYPE — VARCHAR2(20 CHAR)
  • ITEM_CODE — VARCHAR2(30 CHAR)
  • ITEM_NAME — VARCHAR2(60 CHAR)

EMP_ROLE

  • EMP_ID — VARCHAR2(7 CHAR)
  • ID — NUMBER(19,0)
  • ROLE_CODE — VARCHAR2(20 CHAR)

EQUIPMENT

  • EQUIP_ID — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • EQUIP_NAME — VARCHAR2(255 CHAR)
  • UPDATED_DATE — TIMESTAMP
  • KO_NAME — VARCHAR2(255 CHAR)
  • REMARK — VARCHAR2(500 CHAR)
  • USE_YN — CHAR(1 BYTE)
  • PROCESS_ID — VARCHAR2(20 CHAR)

EQUIP_DOWNTIME

  • DOWN_ID — NUMBER(19,0)
  • DOWN_REASON — VARCHAR2(255 CHAR)
  • END_TIME — TIMESTAMP
  • REMARK — VARCHAR2(255 CHAR)
  • START_TIME — TIMESTAMP
  • EQUIP_ID — NUMBER(10,0)

FILE_ATTACH

  • CREATED_DATE — DATE
  • FILE_ID — NUMBER(19,0)
  • FILE_SIZE — NUMBER(19,0)
  • REF_ID — NUMBER(19,0)
  • REF_TABLE — VARCHAR2(30 CHAR)
  • FILE_PATH — VARCHAR2(400 CHAR)
  • CATEGORY — VARCHAR2(255 CHAR)
  • FILE_NAME — VARCHAR2(255 CHAR)
  • ORIGIN_FILE_NAME — VARCHAR2(255 CHAR)

HR_ACTION

  • APPLIED_DATE — DATE
  • EFFECTIVE_DATE — DATE
  • LEAVE_END_DATE — DATE
  • CREATED_USER — VARCHAR2(7 CHAR)
  • EMP_ID — VARCHAR2(7 CHAR)
  • ACTION_ID — NUMBER(19,0)
  • APPROVAL_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • FROM_DEPT_ID — VARCHAR2(10 CHAR)
  • FROM_POS_CODE — VARCHAR2(10 CHAR)
  • STATUS — VARCHAR2(10 CHAR)
  • TO_DEPT_ID — VARCHAR2(10 CHAR)
  • TO_POS_CODE — VARCHAR2(10 CHAR)
  • ACTION_TYPE — VARCHAR2(20 CHAR)
  • REASON — VARCHAR2(200 CHAR)
  • APPLIED_YN — VARCHAR2(255 CHAR)

HTE_EMP_ROLE

  • RN_ — NUMBER(10,0)
  • EMP_ID — VARCHAR2(7 CHAR)
  • ID — NUMBER(19,0)
  • ROLE_CODE — VARCHAR2(20 CHAR)

HTE_NOTICE

  • DELETEYN — VARCHAR2(1 CHAR)
  • NOTICEYN — VARCHAR2(1 CHAR)
  • RN_ — NUMBER(10,0)
  • CREATED_USER — VARCHAR2(7 CHAR)
  • UPDATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • NOTICE_ID — NUMBER(19,0)
  • UPDATED_DATE — TIMESTAMP
  • NOTICE_CONTENT — VARCHAR2(255 CHAR)
  • NOTICE_TITLE — VARCHAR2(255 CHAR)

INBOUND

  • INBOUND_ID — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • EMP_ID — VARCHAR2(255 CHAR)
  • EXPECT_ARRIVAL_DATE — TIMESTAMP
  • INBOUND_STATUS — VARCHAR2(255 CHAR)
  • MATERIAL_ID — VARCHAR2(255 CHAR)
  • PROD_ID — VARCHAR2(255 CHAR)
  • INBOUND_TYPE — VARCHAR2(255 CHAR)

INBOUND_ITEM

  • INBOUND_ITEM_ID — NUMBER(19,0)
  • DISPOSE_AMOUNT — NUMBER(19,0)
  • EXPIRATION_DATE — TIMESTAMP
  • INBOUND_AMOUNT — NUMBER(19,0)
  • INBOUND_ID — VARCHAR2(255 CHAR)
  • ITEM_ID — VARCHAR2(255 CHAR)
  • ITEM_TYPE — VARCHAR2(255 CHAR)
  • LOCATION_ID — VARCHAR2(255 CHAR)
  • LOT_NO — VARCHAR2(255 CHAR)
  • MANUFACTURE_DATE — TIMESTAMP
  • REQUEST_AMOUNT — NUMBER(19,0)

INVENTORY

  • IV_ID — NUMBER(19,0)
  • EXPIRATION_DATE — TIMESTAMP
  • IB_DATE — TIMESTAMP
  • ITEM_ID — VARCHAR2(255 CHAR)
  • IV_AMOUNT — NUMBER(19,0)
  • LOCATION_ID — VARCHAR2(255 CHAR)
  • LOT_NO — VARCHAR2(255 CHAR)
  • MANUFACTURE_DATE — TIMESTAMP
  • EXPECT_OB_AMOUNT — NUMBER(19,0)
  • IV_STATUS — VARCHAR2(255 CHAR)
  • ITEM_TYPE — VARCHAR2(255 BYTE)

INVENTORY_HISTORY

  • IV_HISTORY_ID — NUMBER(19,0)
  • CREATED_DATE — TIMESTAMP
  • CURRENT_LOCATION_ID — VARCHAR2(255 CHAR)
  • EMP_ID — VARCHAR2(255 CHAR)
  • LOT_NO — VARCHAR2(255 CHAR)
  • PREV_LOCATION_ID — VARCHAR2(255 CHAR)
  • REASON — VARCHAR2(255 CHAR)
  • WORK_TYPE — VARCHAR2(255 CHAR)
  • ITEM_NAME — VARCHAR2(255 CHAR)
  • CURRENT_AMOUNT — NUMBER(19,0)
  • PREV_AMOUNT — NUMBER(19,0)
  • MOVE_AMOUNT — NUMBER(19,0)

LOT_HISTORY

  • HIST_ID — NUMBER(19,0)
  • CREATED_DATE — DATE
  • DEFECT_QTY — NUMBER(10,0)
  • END_TIME — TIMESTAMP
  • EVENT_TYPE — VARCHAR2(20 CHAR)
  • GOOD_QTY — NUMBER(10,0)
  • LOCATION_ID — VARCHAR2(255 CHAR)
  • LOCATION_TYPE — VARCHAR2(50 CHAR)
  • ORDER_ID — VARCHAR2(16 CHAR)
  • QUANTITY — NUMBER(10,0)
  • START_TIME — TIMESTAMP
  • STATUS — VARCHAR2(50 CHAR)
  • LOT_NO — VARCHAR2(50 CHAR)
  • PROCESS_ID — VARCHAR2(20 CHAR)
  • WORKER_ID — VARCHAR2(7 CHAR)

LOT_MASTER

  • LOT_NO — VARCHAR2(50 CHAR)
  • LOT_TYPE — VARCHAR2(10 CHAR)
  • ORDER_ID — VARCHAR2(16 CHAR)
  • PRD_ID — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • CURRENT_LOC_ID — VARCHAR2(255 CHAR)
  • CURRENT_LOC_TYPE — VARCHAR2(50 CHAR)
  • CURRENT_STATUS — VARCHAR2(50 CHAR)
  • QUANTITY — NUMBER(10,0)
  • STATUS_CHANGE_DATE — TIMESTAMP

LOT_RELATIONSHIP

  • REL_ID — NUMBER(19,0)
  • CREATED_DATE — DATE
  • USED_QTY — NUMBER(10,0)
  • INPUT_LOT_NO — VARCHAR2(50 CHAR)
  • OUTPUT_LOT_NO — VARCHAR2(50 CHAR)

MATERIAL_MST

  • MAT_ID — VARCHAR2(50 CHAR)
  • MAT_NAME — VARCHAR2(100 CHAR)
  • MAT_TYPE — VARCHAR2(50 CHAR)
  • MAT_UNIT — VARCHAR2(20 CHAR)
  • MAT_DESC — VARCHAR2(255 BYTE)
  • CREATED_ID — VARCHAR2(7 BYTE)
  • CREATED_DATE — DATE
  • UPDATED_ID — VARCHAR2(7 BYTE)
  • UPDATED_DATE — DATE
  • USE_YN — VARCHAR2(1 CHAR)
  • EFFECTIVE_DATE — NUMBER

MATERIAL_ORDER

  • ORDER_ID — VARCHAR2(255 CHAR)
  • CLIENT_ID — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • DUE_DATE — VARCHAR2(255 CHAR)
  • EMP_ID — VARCHAR2(255 CHAR)
  • STATUS — VARCHAR2(255 CHAR)
  • TOTAL_AMOUNT — VARCHAR2(255 CHAR)
  • PLAN_ID — VARCHAR2(255 CHAR)

MATERIAL_ORDER_ITEM

  • ORDER_ITEM_ID — NUMBER(19,0)
  • VAT — NUMBER(19,0)
  • ITEM_ID — NUMBER(19,0)
  • ORDER_AMOUNT — NUMBER(19,0)
  • SUPPLY_AMOUNT — NUMBER(19,0)
  • TOTAL_PRICE — NUMBER(19,0)
  • UNIT_PRICE — NUMBER(19,0)
  • ORDER_ID — VARCHAR2(255 CHAR)

MSG_FAVORITE

  • CREATED_DATE — TIMESTAMP
  • EMP_ID — VARCHAR2(255 CHAR)
  • FV_USER — VARCHAR2(255 CHAR)

MSG_MESSAGE

  • SENDER_ID — VARCHAR2(7 CHAR)
  • MSG_ID — NUMBER(19,0)
  • ROOM_ID — NUMBER(19,0)
  • SENT_DATE — TIMESTAMP
  • MSG_TYPE — VARCHAR2(20 CHAR)
  • FILE_ID — VARCHAR2(255 CHAR)
  • REMARK — VARCHAR2(255 CHAR)
  • MSG_CONTENT — CLOB

MSG_RELATION

  • EMP_ID — VARCHAR2(7 CHAR)
  • ACTIVE_DATE — TIMESTAMP
  • JOIN_DATE — TIMESTAMP
  • LAST_READ_ID — NUMBER(19,0)
  • PINNED_DATE — TIMESTAMP
  • RELATION_ID — NUMBER(19,0)
  • ROOM_ID — NUMBER(19,0)
  • PARTICIPANT_YN — CHAR(1 BYTE)
  • PINNED_YN — CHAR(1 BYTE)
  • REMARK — VARCHAR2(255 CHAR)

MSG_ROOM

  • UPDATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • ROOM_ID — NUMBER(19,0)
  • UPDATED_DATE — TIMESTAMP
  • GROUP_NAME — VARCHAR2(50 CHAR)
  • GROUP_YN — CHAR(1 BYTE)

MSG_STATUS

  • MSG_PROFILE — NUMBER(10,0)
  • ONLINE_YN — VARCHAR2(1 CHAR)
  • EMP_ID — VARCHAR2(7 CHAR)
  • AVLB_UPDATED — TIMESTAMP
  • LAST_LOGIN — TIMESTAMP
  • WORK_STAT_UPDATED — TIMESTAMP
  • MANUAL_WORK_STAT — VARCHAR2(20 CHAR)
  • WORK_STAT_SOURCE — VARCHAR2(20 CHAR)
  • AUTO_WORK_STAT — VARCHAR2(20 BYTE)
  • AVLB_STAT — VARCHAR2(20 BYTE)
  • REMARK — VARCHAR2(255 CHAR)

NOTICE

  • DELETEYN — VARCHAR2(1 CHAR)
  • NOTICEYN — VARCHAR2(1 CHAR)
  • CREATED_USER — VARCHAR2(7 CHAR)
  • UPDATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • NOTICE_ID — NUMBER(19,0)
  • UPDATED_DATE — TIMESTAMP
  • NOTICE_CONTENT — VARCHAR2(255 CHAR)
  • NOTICE_TITLE — VARCHAR2(255 CHAR)

ORDERS

  • ORDER_ID — VARCHAR2(30 CHAR) — 수주(주문)
  • CLIENT_ID — VARCHAR2(20 CHAR) — 주문을
  • CREATED_AT — TIMESTAMP — 데이터
  • CREATED_BY — VARCHAR2(30 CHAR) — 최초
  • DELIVERY_DATE — DATE — 고객이
  • ORDER_DATE — DATE — 수주가
  • ORDER_MEMO — VARCHAR2(2000 CHAR) — 주문에
  • ORDER_NUM — VARCHAR2(30 CHAR) — 외부에서
  • ORDER_STATUS — VARCHAR2(20 CHAR) — 수주
  • EMP_ID — VARCHAR2(30 CHAR)
  • MANAGER_EMAIL — VARCHAR2(100 CHAR)
  • MANAGER_NAME — VARCHAR2(100 CHAR)
  • MANAGER_TEL — VARCHAR2(50 CHAR)
  • ADDR — VARCHAR2(255 CHAR)
  • ADDR_DETAIL — VARCHAR2(2000 CHAR)
  • POSTCODE — VARCHAR2(20 CHAR)

ORDER_ITEM

  • ORDER_ITEM_ID — NUMBER(19,0) — 수주
  • CREATED_AT — TIMESTAMP — 데이터
  • ITEM_MEMO — VARCHAR2(2000 CHAR) — 품목
  • ITEM_STATUS — VARCHAR2(50 CHAR) — 품목
  • ORDER_ID — VARCHAR2(30 CHAR) — 수주
  • ORDER_QTY — NUMBER(18,2) — 주문한
  • PRD_ID — VARCHAR2(30 CHAR) — 주문한
  • TOTAL_PRICE — NUMBER(18,2) — 수주
  • UNIT_PRICE — NUMBER(18,2) — 제품
  • UPDATED_AT — TIMESTAMP — 데이터

OUTBOUND

  • OUTBOUND_ID — VARCHAR2(255 CHAR)
  • CREATED_DATE — TIMESTAMP
  • EXPECT_OUTBOUND_DATE — TIMESTAMP
  • OUTBOUND_DATE — TIMESTAMP
  • PROCESS_BY — VARCHAR2(255 CHAR)
  • REQUEST_BY — VARCHAR2(255 CHAR)
  • SHIPMENT_ID — VARCHAR2(255 CHAR)
  • STATUS — VARCHAR2(255 CHAR)
  • WORK_ORDER_ID — VARCHAR2(255 CHAR)

OUTBOUND_ITEM

  • OUTBOUND_ITEM_ID — NUMBER(19,0)
  • ITEM_ID — VARCHAR2(255 CHAR)
  • ITEM_TYPE — VARCHAR2(255 CHAR)
  • LOCATION_ID — VARCHAR2(255 CHAR)
  • LOT_NO — VARCHAR2(255 CHAR)
  • OUTBOUND_AMOUNT — NUMBER(19,0)
  • OUTBOUND_ID — VARCHAR2(255 CHAR)
  • IV_ID — NUMBER(19,0)

PAYROLL_PAYSLIP

  • ALW_AMT — NUMBER(15,2) — 총
  • BASE_AMT — NUMBER(15,2) — 기본금
  • DED_AMT — NUMBER(15,2) — 총
  • INC_AMT — NUMBER(15,2) — 인센티브
  • IS_PARTIAL — VARCHAR2(1 CHAR) — 부분
  • NET_AMT — NUMBER(15,2) — 실
  • TOT_AMT — NUMBER(15,2) — 총
  • PAY_YYMM — VARCHAR2(6 CHAR) — 급여
  • CALC_DATE — TIMESTAMP — 계산일시
  • CONFIRM_DATE — TIMESTAMP — 확정일시
  • JOB_ID — NUMBER(19,0)
  • PAYSLIP_ID — NUMBER(19,0)
  • CALC_STATUS — VARCHAR2(20 CHAR) — 계산
  • CALC_TYPE — VARCHAR2(20 CHAR) — 계산유형
  • CONFIRM_USER — VARCHAR2(20 CHAR) — 확정자
  • DEPT_ID — VARCHAR2(20 CHAR)
  • EMP_ID — VARCHAR2(20 CHAR)
  • PDF_HASH_ID — VARCHAR2(40 CHAR)
  • PDF_PATH — VARCHAR2(255 CHAR)
  • REMARK — CLOB

PAY_CALC_RULE

  • END_DATE — DATE — 적용
  • PRIORITY — NUMBER(10,0) — 낮을수록
  • START_DATE — DATE — 적용
  • VALUE_NUM — NUMBER(21,6) — 정의/비율/금액
  • RULE_ID — NUMBER(19,0) — 규칙ID
  • RULE_TYPE — VARCHAR2(10 CHAR) — 계산
  • TARGET_TYPE — VARCHAR2(10 CHAR) — 대상
  • STATUS — VARCHAR2(12 CHAR) — 사용
  • ITEM_CODE — VARCHAR2(20 CHAR) — 적용될
  • TARGET_CODE — VARCHAR2(30 CHAR) — 대상
  • REMARK — VARCHAR2(255 CHAR)
  • CALC_FORMULA — CLOB — 계산

PAY_ITEM_MST

  • SORT_NO — NUMBER(10,0)
  • CALC_METHOD — VARCHAR2(20 CHAR) — 급여
  • ITEM_CODE — VARCHAR2(20 CHAR) — 급여
  • ITEM_GROUP — VARCHAR2(20 CHAR) — 기본급/인센티브/공제액
  • ITEM_TYPE — VARCHAR2(20 CHAR) — 수입/공제
  • ITEM_NAME — VARCHAR2(60 CHAR) — 화면/보고서
  • REMARK — VARCHAR2(200 CHAR)
  • TAXABLE — CHAR(1 BYTE) — 과세
  • USE_YN — CHAR(1 BYTE)

PAY_RULE

  • BASE_AMT — NUMBER(15,2) — 기본금:
  • EMP_RATE — NUMBER(7,4) — 고용보험
  • END_DATE — DATE — 적용
  • HLTH_RATE — NUMBER(7,4) — 건강보험
  • MEAL_AMT — NUMBER(15,2) — 식대:
  • PAY_DAY — NUMBER(10,0) — 지급일자(매월
  • PEN_RATE — NUMBER(7,4) — 국민연금
  • START_DATE — DATE — 적용
  • TAX_RATE — NUMBER(7,4) — 소득세율(예:
  • TRANS_AMT — NUMBER(15,2) — 교통비:
  • CREATED_DATE — TIMESTAMP — 생성일시
  • RULE_ID — NUMBER(19,0) — 기준
  • UPDATED_DATE — TIMESTAMP — 수정일시
  • STATUS — VARCHAR2(10 CHAR) — 상태:
  • REMARK — CLOB — 비고(관리자

POSITION

  • IS_EXECUTIVE — VARCHAR2(1 CHAR)
  • RANK_ORDER — NUMBER(10,0)
  • USE_YN — VARCHAR2(1 CHAR)
  • CREATED_DATE — TIMESTAMP
  • POS_CODE — VARCHAR2(10 CHAR)
  • POS_NAME — VARCHAR2(30 CHAR)

PROCESS_MST

  • PROCESS_ID — VARCHAR2(20 BYTE)
  • PROCESS_NAME — VARCHAR2(100 BYTE)
  • PROCESS_TYPE — VARCHAR2(20 BYTE)
  • DESCRIPTION — VARCHAR2(400 BYTE)
  • USE_YN — VARCHAR2(1 CHAR)
  • CREATED_ID — VARCHAR2(7 BYTE)
  • CREATED_DATE — TIMESTAMP
  • UPDATED_ID — VARCHAR2(7 BYTE)
  • UPDATED_DATE — TIMESTAMP