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)