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