BIZ_SALES_CONSULT

Tables (4)

BIZ_CHARGER (계약 담당자 정보)

  • CNTR_ID (계약ID) — VAR_CHAR — Primary key
  • CHRG_TYPE (담당자 타입) — VAR_CHAR
  • USER_ID (담당자 ID) — VAR_CHAR

BIZ_CLIENT (거래처 정보)

  • CLIENT_ID (업체ID) — VAR_CHAR — Primary key
  • CLIENT_NM (업체명) — VAR_CHAR
  • CLIENT_TYPE_CD (거래처 구분) — VAR_CHAR
  • REPT_NM (대표자명) — VAR_CHAR
  • TEL_NO (대표번호) — VAR_CHAR
  • BSSN_NO (사업자등록번호) — VAR_CHAR

BIZ_CONSULT_HISTORY (상담 이력 관리)

  • SEQ (이력ID) — INT — Primary key — MISO, VMS..
  • CLIENT_ID (업체ID) — VAR_CHAR — Primary key
  • CONSULT_DT (상담일자) — VAR_CHAR
  • CONSULT_USER_ID (상담자ID) — VAR_CHAR
  • CONSULT_TYPE_CD (상담구분) — VAR_CHAR
  • CONSULT_DETAIL (상담내용) — VAR_CHAR
  • PARTNER_CD (파트너 구분) — VAR_CHAR
  • PRODUCT_CD (제품) — VAR_CHAR
  • EXPECT_AM (예상금액) — VAR_CHAR

BIZ_PRODUCT (계약 정보)

  • CNTR_ID (계약ID) — VAR_CHAR — Primary key
  • CLIENT_ID (업체ID) — VAR_CHAR — Primary key
  • PRODUCT_CD (제품코드) — VAR_CHAR — MISO, VMS..
  • CNTR_NM (계약명) — VAR_CHAR
  • CNTR_START (계약시작일) — VAR_CHAR
  • CNTR_END (계약종료일) — VAR_CHAR
  • FILE_GROUP_ID (파일그룹ID) — VAR_CHAR
  • AMOUNT (계약금액) — INT
  • CNTR_STATE_CD (진행상태) — VAR_CHAR
  • CNTR_DETAIL (계약내용) — VAR_CHAR