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