NEXUS_SCM

테이블 (28)

FAQ (TB_FAQ)

  • faq id (FAQ_ID) — 기본 키 — NOT NULL
  • category code (CATEGORY_CODE) — 회원가입 발주 납품 반품 정산
  • question (QUESTION)
  • answer (ANSWER)
  • view cnt (VIEW_CNT)

감사로그 (TB_AUDIT_LOG)

  • audit id (AUDIT_ID) — 기본 키 — NOT NULL
  • user id (USER_ID)
  • menu id (MENU_ID)
  • action type (ACTION_TYPE)
  • before date (BEFORE_DATA)
  • after data (AFTER_DATA)

공급사 (TB_SUPPLIER)

  • supplier id (SUPPLIER_ID) — 기본 키 — NOT NULL
  • ERP vendor code (ERP_VENDOR_CODE)
  • supplier name (SUPPLIER_NAME)
  • business no (BUSINESS_NO)
  • CEO name (CEO_NAME)
  • email (EMAIL)
  • phone (PHONE)
  • address (ADDRESS)
  • use yn (USE_YN)

공급사사용자관리 (TB_SUPPLIER_USER)

  • supplier user id (SUPPLIER_USER_ID) — 기본 키 — NOT NULL
  • supplier id (SUPPLIER_ID)
  • user id (USER_ID)
  • role code (ROLE_CODE)

공급사승인관리 (TB_SUPPLIER_APPROVAL)

  • approval id (APPROVAL_ID) — 기본 키 — NOT NULL
  • supplier id (SUPPLIER_ID)
  • status (STATUS)
  • approved by (APPROVED_BY)
  • approved date (APPROVED_DT)
  • remark (REMARK)

공지사항 (TB_NOTICE)

  • notice id (NOTICE_ID) — 기본 키 — NOT NULL
  • title (TITLE)
  • content (CONTENT)
  • top yn (TOP_YN)
  • start date (START_DT)
  • end date (END_DT)
  • view cnt (VIEW_CNT)

공통코드 (TB_CODE)

  • group code (GROUP_CODE) — 기본 키 — NOT NULL
  • code (CODE) — 기본 키 — NOT NULL
  • code name (CODE_NAME)
  • sort order (SORT_ORDER)
  • use yn (USE_YN)

공통코드그룹 (TB_CODE_GROUP)

  • group code (GROUP_CODE) — 기본 키 — NOT NULL
  • group name (GROUP_NAME)
  • use yn (USE_YN)

납품마스터 (TB_DELIVERY_HEADER)

  • delivery no (DELIVERY_NO) — 기본 키 — NOT NULL
  • po no (PO_NO)
  • supplier id (SUPPLIER_ID)
  • delivery date (DELIVERY_DATE)
  • status (STATUS)
  • remark (REMARK)

납품상세 (TB_DELIVERY_DETAIL)

  • delivery no (DELIVERY_NO) — 기본 키 — NOT NULL
  • delivery seq (DELIVERY_SEQ) — 기본 키 — NOT NULL
  • item code (ITEM_CODE)
  • delivery qty (DELIVERY_QTY)

로그인이력 (TB_LOGIN_HIS)

  • login history id (LOGIN_HIS_ID) — 기본 키 — NOT NULL
  • user id (USER_ID)
  • login date (LOGIN_DT)
  • ip address (LOGIN_IP)
  • success yn (SUCCESS_YN)
  • fail reason (FAIL_REASON)

메뉴관리 (TB_MENU)

  • menu id (MENU_ID) — 기본 키 — NOT NULL
  • parent menu id (PARENT_MENU_ID)
  • menu name (MENU_NAME)
  • menu url (MENU_URL)
  • menu icon (MENU_ICON)
  • sort order (SORT_ORDER)
  • use yn (USE_YN)

반품마스터 (TB_RETURN_HEADER)

  • return no (RETURN_NO) — 기본 키 — NOT NULL
  • po no (PO_NO)
  • supplier id (SUPPLIER_ID)
  • return date (RETURN_DATE)
  • status (STATUS)
  • return reason (RETURN_REASON)

반품상세 (TB_RETURN_DETAIL)

  • return no (RETURN_NO) — 기본 키 — NOT NULL
  • return seq (RETURN_SEQ) — 기본 키 — NOT NULL
  • item code (ITEM_CODE)
  • return qty (RETURN_QTY)

발주마스터 (TB_PO_HEADER)

  • po no (PO_NO) — 기본 키 — NOT NULL
  • ERP po no (ERP_PO_NO)
  • supplier id (SUPPLIER_ID)
  • po date (PO_DATE)
  • delivery date (DELIVERY_DATE)
  • status (STATUS)
  • total amount (TOTAL_AMT)

발주상세 (TB_PO_DETAIL)

  • po no (PO_NO) — 기본 키 — NOT NULL
  • po seq (PO_SEQ) — 기본 키
  • item code (ITEM_CODE)
  • item name (ITEM_NAME)
  • order qty (ORDER_QTY)
  • unit price (UNIT_PRICE)
  • amount (AMOUNT)

사용자 별 역할 (TB_USER_ROLE)

  • user id (USER_ID) — 기본 키 — NOT NULL
  • role id (ROLE_ID) — 기본 키 — NOT NULL

사용자관리 (TB_USER)

  • user id (USER_ID) — 기본 키 — NOT NULL
  • login id (LOGIN_ID)
  • password (PASSWORD)
  • user name (USER_NAME)
  • email (EMAIL)
  • phone (PHONE)
  • supplier id (SUPPLIER_ID)
  • use yn (USE_YN)
  • last login date (LAST_LOGIN_DT)

알림 (TB_NOTIFICATION)

  • noti id (NOTI_ID) — 기본 키 — NOT NULL
  • user id (USER_ID)
  • noti type (NOTI_TYPE) — 발주서 신규 등록 납품 승인 반품 요청 Q&A 답변 등록 등
  • title (TITLE)
  • message (MESSAGE)
  • read yn (READ_YN)
  • read date (READ_DT)

역할 별 매뉴 (TB_ROLE_MENU)

  • role id (ROLE_ID) — 기본 키 — NOT NULL
  • menu id (MENU_ID) — 기본 키 — NOT NULL
  • select yn (SELECT_YN)
  • insert yn (INSERT_YN)
  • update yn (UPDATE_YN)
  • delete yn (DELETE_YN)
  • export yn (EXPORT_YN)

역할관리 (TB_ROLE)

  • role id (ROLE_ID) — 기본 키
  • role code (ROLE_CODE)
  • role name (ROLE_NAME) — ROLE_ADMIN ROLE_BUYER ROLE_SUPPLIER_ADMIN ROLE_SUPPLIER_USER
  • description (DESCRIPTION)

연동로그 (TB_IF_LOG)

  • interface id (IF_ID) — 기본 키 — NOT NULL
  • interface type (IF_TYPE)
  • request json (REQUEST_JSON)
  • response json (RESPONSE_JSON)
  • status (STATUS)
  • start date (START_DT)
  • end date (END_DT)

입고마스터 (TB_GR_HEADER)

  • gr no (GR_NO) — 기본 키 — NOT NULL
  • delivery no (DELIVERY_NO)
  • ERP gr no (ERP_GR_NO)
  • gr date (GR_DATE)
  • status (STATUS)

입고상세 (TB_GR_DETAIL)

  • gr no (GR_NO) — 기본 키 — NOT NULL
  • gr seq (GR_SEQ) — 기본 키 — NOT NULL
  • item code (ITEM_CODE)
  • gr qty (GR_QTY)

질의답변 (TB_QNA_REPLY)

  • reply id (REPLY_ID) — 기본 키 — NOT NULL
  • qna id (QNA_ID)
  • user id (USER_ID)
  • content (CONTENT)

질의요청 (TB_QNA)

  • qna id (QNA_ID) — 기본 키 — NOT NULL
  • supplier id (SUPPLIER_ID)
  • user id (USER_ID)
  • title (TITLE)
  • content (CONTENT)
  • status (STATUS) — REQUEST ANSWERED CLOSED

파일마스터 (TB_FILE)

  • file id (FILE_ID) — 기본 키 — NOT NULL
  • original file name (ORG_FILE_NAME)
  • save file name (SAVE_FILE_NAME)
  • file path (FILE_PATH)
  • file size (FILE_SIZE)

파일매핑 (TB_FILE_MAPPING)

  • file id (FILE_ID) — 기본 키 — NOT NULL
  • reference table (REF_TABLE) — 예: NOTICE PO DELIVERY QNA
  • reference key (REF_KEY)