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