ELS-NEW
Tables (20)
C_KAP_SOURCING_PRODUCT_MAPPING
- KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
- UsingTable_1 — varchar(256)
- UsingTable_2 — varchar(256)
- UsingTable_3 — varchar(256)
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_BIDDING_COMPANY
- IssuerCompanyID — varchar(6) — Primary key — NOT NULL — 발행사ID
- SourcingProductID — varchar(15) — Foreign key → M_SOURCING_PRODUCT_TENDER_REG.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID (SourcingCompanyID2) — varchar(6) — Foreign key → M_SOURCING_PRODUCT_TENDER_REG.SourcingCompanyID — NOT NULL — 조달사ID
- TenderPossibleYN — varchar(1) — 참여가능여부
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_BIDDING_INFO
- IssuerCompanyID — varchar(6) — Foreign key → M_BIDDING_COMPANY.IssuerCompanyID — NOT NULL — 발행사ID
- SourcingProductID — varchar(15) — Foreign key → M_BIDDING_COMPANY.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_BIDDING_COMPANY.SourcingCompanyID — NOT NULL — 조달사ID
- ProposePrice — decimal(6, 3) — 제안가격
- SetLimitAmout — decimal(18, 0) — NOT NULL — 설정한도금액
- SubmitStdCode — varchar(256) — NOT NULL — 제출기준코드
- SubmitStdOfferCondition — varchar(128) — NOT NULL — 제출기준제시조건
- BiddingCancelYN — varchar(1) — 응찰취소여부
- BiddingCancelDateTime — varchar(16) — 응찰취소일시
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_BIDDING_SUCCBID
- IssuerCompanyID (IssuerCompanyID2) — varchar(6) — Foreign key → M_BIDDING_INFO.IssuerCompanyID — NOT NULL — 발행사ID
- SourcingProductID (SourcingProductID2) — varchar(15) — Foreign key → M_BIDDING_INFO.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID (SourcingCompanyID2) — varchar(6) — Foreign key → M_BIDDING_INFO.SourcingCompanyID — NOT NULL — 조달사ID
- SuccessDate — varchar(8) — NOT NULL — 낙찰일
- SourcingPossibleAmout — decimal(18, 0) — NOT NULL — 조달확정금액
- SuccessReason — varchar(512) — 낙찰사유
- SuccessFixYN — varchar(1) — 낙찰확정
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
M_ISSUE_PRODUCT_INFO
- IssueProductID — varchar(12) — Primary key — NOT NULL — 발행상품ID
- IssuerCompanyID — varchar(6) — Foreign key → M_BIDDING_SUCCBID.IssuerCompanyID — NOT NULL — 발행사ID
- SourcingProductID — varchar(15) — Foreign key → M_BIDDING_SUCCBID.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_BIDDING_SUCCBID.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
- IssueProductName — varchar(256) — 발행상품명
- IssueXth — varchar(6) — 발행회차
- SubscriptNoticeDate — varchar(8) — 청약공고일
- SubscriptStartDate — varchar(8) — 청약시작일
- SubscriptEndDate — varchar(8) — 청약종료일
- SubscriptEndTime — varchar(4) — 청약종료시각
- TradeDate — varchar(8) — 거래일
- IssueDate — varchar(8) — 발행일
- IssueCurrencyID — varchar(3)
- DueDate — varchar(8) — 만기일
- DueMonthCount — int — 만기개월수
- DueStepmonth — varchar(2) — 상환주기
- UnderlyingBasisDate — varchar(8) — 기초자산기준가결정일
- UnderlyingID_1 — varchar(20) — 기초자산ID1
- UnderlyingID_2 — varchar(20) — 기초자산ID2
- UnderlyingID_3 — varchar(20) — 기초자산ID3
- UnderlyingID_4 — varchar(20) — 기초자산ID4
- UnderlyingID_5 — varchar(20) — 기초자산ID5
- ExerciseStructure — varchar(80) — 행사구조
- MonthCouponBarrier — decimal(4, 0) — 월쿠폰베리어
- KnockType — varchar(2) — 낙유형
- KnockBarrier — decimal(4, 0) — 낙베리어
- CouponRate — decimal(7, 4) — 연지급금리
- ShortCutProductId — varchar(15) — 쇼컷ProductID
- ProposePrice — decimal(6, 3) — 제안가격
- MaxIssueAmount — decimal(18, 0) — 최대발행금액
- LastlIssueAmount — decimal(18, 0) — 최종발행금액
- ParticipationRate — decimal(7, 4) — 참여율
- AddRedemtionConditionNo — varchar(256) — 추가상환조건행사회차
- AddRedemtionCondition — varchar(256) — 추가상환조건
- AddANNPayInterest — decimal(7, 4) — 추가연지급금리
- DummyCouponRate — decimal(7, 4) — 더미쿠폰
- MoniteringMethodCode — varchar(1)
- KRCODE — varchar(12) — 표준코드
- DeleteYN — varchar(1) — 삭제여부
- Memo — varchar(512) — 메모
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_ISSUE_PRODUCT_PAYMENT
- ExerMonth — int — Primary key — NOT NULL — 행사월
- IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
- IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
- ExerXth — int — 행사순서
- ExerDate — varchar(8) — 관찰일
- PayDate — varchar(8) — 지급일
- TrustPayDate — varchar(8) — 신탁지급일
- AddPayInterest — decimal(7, 4) — 지급금리
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_ISSUE_PRODUCT_REDEMTION
- ExerMonth — int — Primary key — NOT NULL — 행사월
- IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
- IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
- ExerXth — int — NOT NULL — 행사회차
- ExerciseBarrier — decimal(7, 4) — NOT NULL — 행사베리어
- ExerDate — varchar(8) — 행사일
- PayDate — varchar(8) — 지급일
- TrustPayDate — varchar(8) — 신탁지급일
- PayInterest — decimal(7, 4) — 지급금리
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_ISSUE_PRODUCT_REDEMTION_ADD
- ExerMonth — int — Primary key — NOT NULL — 행사월
- IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
- IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
- ExerDate — varchar(8) — 행사일
- PayDate — varchar(8) — 지급일
- TrustPayDate — varchar(8) — 신탁지급일
- AddExerXth — int — 추가상환조건회차
- MoniteringMethodCode — varchar(1) — 관찰방법코드
- AddExecBarrier — decimal(7, 4) — 추가행사베리어
- AddPayInterest — decimal(7, 4) — 추가지급금리
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_ISSUE_PRODUCT_UNDERLYING_PRICE
- UnderlyingID — varchar(20) — Primary key — NOT NULL — 기초자산ID
- IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
- IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
- UnderlyingBasisPrice — decimal(20, 8) — 기준가격
- Seq — varchar(4) — Seq
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_KAPPRODUCT_LIST
- KAPProductDefineID — varchar(12) — Primary key — NOT NULL — KAP상품정의ID
- KAPProductName — varchar(40) — NOT NULL — KAP상품명
- LargeCategoryCode — varchar(3) — NOT NULL — 대분류코드
- MiddleCategoryCode — varchar(3) — NOT NULL — 중분류코드
- SmallCategoryCode — varchar(4) — NOT NULL — 소분류코드
- KnockType — varchar(2) — NOT NULL — 낙유형
- UseYN — varchar(1) — 사용여부
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — 입력사용자ID
- InputDateTime — varchar(16) — 입력일시
- InputIP — varchar(15) — 입력IP
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
M_KAPPRODUCT_OPTIONS
- Seq — int — Primary key — NOT NULL — 순번
- KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
- KAPOptionID — varchar(12) — NOT NULL — KapOptionID
- UseYN — varchar(1) — 사용여부
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — 입력사용자ID
- InputDateTime — varchar(16) — 입력일시
- InputIP — varchar(15) — 입력IP
M_KAP_PRODUCT_DEFAULTVALUE
- TargetColumnName — varchar(256) — Primary key — NOT NULL — 대상컬럼명
- KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
- Seq — varchar(4) — 순번
- ColumnDisplayName — varchar(256) — 컬럼표시명
- PreProcessEquation — varchar(512) — 사전처리수식
- DefaultSetValue — varchar(256) — 기본설정값
- AfterProcessEquation — varchar(512) — 사후처리수식
- UseYN — varchar(1) — 사용여부
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_PROPOSE_PRODUCT_INFO
- ProposeProductID — varchar(15) — Primary key — NOT NULL — 제안상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
- IssuerCompanyID — varchar(6) — NOT NULL — 제안발행사ID
- ProposeProductName — varchar(256) — 제안상품명
- ExerciseStructure — varchar(80) — 행사구조
- CouponRate — decimal(7, 4) — 연지급금리
- OfferPrice — decimal(6, 3) — 제안가격
- MaxIssueAmount — decimal(18, 0) — 최대발행금액
- ParticipationRate — decimal(7, 4) — 참여율
- AddANNPayInterest — decimal(7, 4) — 추가연지급금리
- OfferRegDate — varchar(8) — 제안등록일
- OfferEndDate — varchar(8) — 제안마감일
- Memo — varchar(512) — 제안요청사항
- DeleteYN — varchar(1)
- ProposeNo — varchar(40) — 제안상품No
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_SOURCING_PRODUCT_DEFAULTVALUE
- TargetColumnName — varchar(256) — Primary key — NOT NULL — 대상컬럼명
- Seq — Primary key — NOT NULL — 순번
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
- ColumnDisplayName — varchar(256) — 컬럼표시명
- PreProcessEquation — varchar(512)
- DefaultSetValue — varchar(256) — 기본설정값
- AfterProcessEquation — varchar(512)
- UseYN — varchar(1)
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
- ColumnUsage — NOT NULL — 컬럼사용용도
M_SOURCING_PRODUCT_DEFINE_SUBMIT_STD
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
- SubmitStdCode — varchar(2) — NOT NULL — 제출기준코드
- UseYN — varchar(1) — 사용여부
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_SOURCING_PRODUCT_INFO
- SourcingProductID — varchar(15) — Primary key — NOT NULL — 조달상품ID
- ProposeProductID — varchar(15) — Foreign key → M_PROPOSE_PRODUCT_INFO.ProposeProductID — NOT NULL — 제안상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_PROPOSE_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
- SourcingProductName — varchar(256) — 조달상품명
- ExerciseStructure — varchar(80) — 행사구조
- CouponRate — decimal(7, 4) — 연지급금리
- ProposePrice — decimal(6, 3) — 제안가격
- MaxIssueAmount — decimal(18, 0) — 최대발행금액
- ParticipationRate — decimal(7, 4) — 참여율
- AddANNPayInterest — decimal(7, 4) — 추가연지급금리
- SourcingRegDate — varchar(8) — 조달등록일
- ProposeCompanyID — varchar(6) — NOT NULL — 제안발행사ID
- ProposeUserID — varchar(24) — NOT NULL — 제안사용자ID
- DeleteYN — varchar(1) — 삭제여부
- Memo — varchar(256)
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_SOURCING_PRODUCT_INFO_DETAIL
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_DEFAULTVALUE.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_DEFAULTVALUE.SourcingProductDefineID — NOT NULL — 조달상품정의ID
- ProposeProductID — varchar(15) — Foreign key → M_PROPOSE_PRODUCT_INFO.ProposeProductID — NOT NULL — 제안상품ID
- SourcingProductID — varchar(15) — Foreign key → M_SOURCING_PRODUCT_INFO.SourcingProductID — NOT NULL — 조달상품ID
- IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
- TargetColumnName — varchar(256) — Foreign key → M_SOURCING_PRODUCT_DEFAULTVALUE.TargetColumnName — NOT NULL — 대상컬럼명
- SaveValue — 저장데이터
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_SOURCING_PRODUCT_LIST
- SourcingCompanyID — varchar(6) — Primary key — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — Primary key — NOT NULL — 조달상품정의ID
- Seq — varchar(4) — 순번
- SourcingProductName — varchar(256) — NOT NULL — 조달사상품명
- UseYN — varchar(1) — 사용여부
- Memo — varchar(256) — 비고
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_SOURCING_PRODUCT_TENDER_REG
- SourcingProductID — varchar(15) — Foreign key → M_TENDER_PRODUCT_INFO.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_TENDER_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
- TenderStartDate — varchar(8) — 입찰시작일시
- TenderEndDate — varchar(16) — 입찰마감일시
- TenderType — varchar(1) — 입찰방식
- TenderTarget — varchar(1) — 입찰대상
- CollectMaxLimitAmount — decimal(18, 0) — 모집한도금액
- TenderCancelYN — varchar(1) — 입찰취소여부
- TenderCancelDateTime — varchar(16) — 입찰취소일시
- TenderStatus — varchar(1) — 입찰상태
- TenderConfirmDateTime — varchar(16) — 낙찰확정일시
- SuccableReason — varchar(512) — 낙찰될만한조건
- SubscriptStartDate — varchar(8) — 청약시작일
- SubscriptEndDate — varchar(8) — 청약종료일
- TenderCouponRate — decimal(7, 4) — 입찰쿠폰금리
- TenderProposePrice — decimal(6, 3) — 입찰제안가
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP
M_TENDER_PRODUCT_INFO
- SourcingProductID — varchar(15) — Foreign key → M_SOURCING_PRODUCT_INFO.SourcingProductID — NOT NULL — 조달상품ID
- SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
- SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
- TenderProductName — varchar(256) — 입찰상품명
- ExerciseStructure — varchar(80) — 행사구조
- CouponRate — decimal(7, 4) — 연지급금리
- ProposePrice — decimal(6, 3) — 제안가격
- MaxIssueAmount — decimal(18, 0) — 최대발행금액
- ParticipationRate — decimal(7, 4) — 참여율
- AddANNPayInterest — decimal(7, 4) — 추가연지급금리
- SourcingRegDate — varchar(8) — 조달등록일
- ProposeCompanyID — varchar(6) — NOT NULL — 제안발행사ID
- ProposeUserID — varchar(24) — NOT NULL — 제안사용자ID
- ProposeProductID — varchar(15) — NOT NULL — 제안상품ID
- DeleteYN — varchar(1) — 삭제여부
- Memo — varchar(256) — 메모
- InputUserID — varchar(24) — NOT NULL — 입력사용자ID
- InputDateTime — varchar(16) — NOT NULL — 입력일시
- InputIP — varchar(15) — 입력IP