ChargeLink
Tables (11)
CHARGERMAN_KEPCO_RM_NEW (......)
- SPID — Primary key — NOT NULL
- CSID — Primary key — NOT NULL
- CPID — Primary key — NOT NULL
- CPNM
- USE_TIME
- OPEN_YN
- SHOW_YN
- SPCSID
- SPCPID
- CHARGE_UCOST1
- CHARGE_UCOST2
- CHARGE_UCOST3
- USE_YN
- OPER_ST_YMD
- OPER_END_YMD
- OUTLET_CNT
- PNC_YN
- CPKW
- CHARGE_DIV
- CP_TP
- POSTCD
- CS_DIV
- OUTLET_DIV
- CONN_DIV
- CHARGE_KW
- SERVICE_DIV
- NET_DIV
- AUTH_DIV
- COMPTY_DIV
- AMI_CERT
- REGDAT
- UPDDAT
CHASTATINFO_KEPCO_RM_NEW (.......)
- SPID — Primary key — NOT NULL
- CSID — Primary key — NOT NULL
- CPID — Primary key — NOT NULL
- OUTLET_ID
- STSTUS_CD
- STATCODE_DTL_CD
- UPDATE_TIME
- SHOW_YN
- OPEN_YN
- SPCSID
- SPCPID
- CHARGE_ST_DATE
- CHARGE_SOC
- CHARGE_TYPE
- STOP_YN
- STOP_ST_DATE
- STOP_END_DATE
- REGDAT
- UPDDAT
KEPCO_BIDMAP_RM_NEW (.)
- CD_OLD — Primary key — NOT NULL
- CD_NEW — Primary key — NOT NULL
- BID_NM
- USE_YN
- UPDATE_DT
KEPCO_COMCODMAN (..)
- CD_TP — Primary key — NOT NULL
- CD — Primary key — NOT NULL
- CD_TP_NM
- CD_ITEM
- CD_TP_UP
- CD_UP
- USE_YN
- UPDATE_DT
KEPCO_CONTRACT_INFO (..........)
- SPID — Primary key — NOT NULL
- TRADE_SPID — Primary key — NOT NULL
- PLATFORM_SPID
- CNTR_REG_DATE
- CNTR_CFM_DATE
- CNTR_STATUS_CD
- CNTR_ST_DATE
- CNTR_END_DATE
- SP_CALC_UCOST
- SP_CHARGE_UCOST
- TSP_CALC_UCOST
- TSP_CHARGE_UCOST
- INSERT_DATE
- UPDATE_DATE
MAPPING_KEPCO_RM_NEW (........)
- SPID — Primary key — NOT NULL
- CSID — Primary key — NOT NULL
- CPID — Primary key — NOT NULL
- SPCSID
- SPCPID
- POSTCD
- CS_DIV
- OUTLET_DIV
- CONN_DIV
- CHARGE_KW
- SERVICE_DIV
- NET_DIV
- AUTH_DIV
- COMPTY_DIV
- REGDAT
- UPDDAT
MEMCARDMAN_KEPCO_RM_NEW (...)
- SPID — Primary key — NOT NULL
- CARDNO — Primary key — NOT NULL
- EMAID
- USE_YN
- LOST_YN
- STOP_YN
- STOP_ST_DATE
- STOP_END_DATE
- SP_REG_DATE
- SP_UPD_DATE
- ROAMING_REG_DATE
- ROAMING_UPD_DATE
- CERT_PASS
- ISSUE_SP_CD
- REGDAT
- UPDDAT
RESERV_KEPCO_RM_NEW (.........)
- RESERVKEPCORMNEWSEQ (Key) — Primary key — NOT NULL
- TRADE_SPID — NOT NULL
- CHARGE_ID — NOT NULL
- SPID
- CSID
- CPID
- SPCSID
- SPCPID
- OUTLET_ID
- CHARGE_ST_DATE
- CHARGE_END_DATE
- CHARGE_KWH
- CHARGE_KWH1
- CHARGE_KWH2
- CHARGE_KWH3
- CARDNO
- EMAID
- CHARGE_TP
- OUTLET_TP
- SP_UCOST1
- SP_UCOST2
- SP_UCOST3
- CHARGE_AMT
- CHARGE_AMT1
- CHARGE_AMT2
- CHARGE_AMT3
- ROAMING_FEE
- CHARGE_REG_DATE
- CHARGE_UPD_DATE
- SP_CHARGE_ID
- AUTH_ID
- CHARGE_SEND_DATE
- CHARGE_RECV_DATE
- PLATFORM_SPID
- REGDAT
- UPDDAT
- ROAMING_REG_DATE (Field)
- ROAMING_UPD_DATE (Field2)
- CALC_SEND_DATE (Field3)
- CALC_RECV_DATE (Field4)
- CALC_YN (Field5)
- CALC_END_YN (Field6)
- CALC_CFM_DATE (Field7)
- CALC_YM (Field8)
- CALC_DESC (Field9)
RESERV_KEPCO_RM_NEW_PAY (Untitled)
- SPID (Key) — Primary key — NOT NULL
- TRADE_SPID (Key2) — Primary key — NOT NULL
- Field
SPOTMAN_KEPCO_RM_NEW (.....)
- SPID — Primary key — NOT NULL
- CSID — Primary key — NOT NULL
- CSNM
- DADDR
- ADDR
- ADDR_DTL
- LAT
- LONGI
- USE_TIME
- SHOW_YN
- SPCSID
- PARK_FEE_YN
- PARK_FEE
- SPCALL
- MEMBER_YN
- OPEN_YN
- USE_YN
- POSTCD
- CS_DIV
- SIDO
- SIGUNGU
- OPER_ST_YMD
- OPER_END_YMD
- REGDAT
- UPDDAT
USERAUTH_HIS_KEPCO_RM_NEW (....)
- SPID — Primary key — NOT NULL
- AUTH_ID — Primary key — NOT NULL
- PROVIDER_ID
- CARDNO
- CERT_PASS
- EMAID
- AUTH_TYPE
- CSID
- CPID
- OUTLET_ID
- AUTH_RESULT
- AUTH_RESULT_DATE
- AUTH_DATE
- CHARGE_UCOST
- CHARGE_KWH
- REGDATETIME
- REQ_DIV