dsf

테이블 (6)

API구분코드 (Untitled)

  • 0001 (조회)
  • 0002 (적립)
  • 0003 (사용)
  • 0004 (취소)

Point_History (포인트 전환 로그)

  • payNo (Field2)
  • txNo (Field4)
  • privilegeNo (Field) — varchar
  • regDate (Field3) — timestamp
  • apiTo (Field6) — varchar
  • apiType (Field10) — varchar
  • apiStatus (Field11) — varchar
  • errorMsg (Field14) — varchar
  • requestBody (Field15) — varchar
  • requestHeader (Field9) — varchar
  • response (Field5)

Point_History_Detail (포인트 전환 내역 상세)

  • txDetailNo (PK) — varchar — 기본 키 — NOT NULL
  • txNo (Field8) — varchar
  • privilegeNo (Field) — varchar
  • fromAmount (Field2) — varchar
  • toAmount (Field3) — varchar
  • apiType (Field4) — varchar
  • apiStatus (Field5) — varchar
  • apiUrl (Field12) — varchar
  • start_date (Field6) — timestamp
  • end_date (Field7) — timestamp
  • errorCode (Field11) — varchar
  • errorMsg (Field10) — varchar
  • descript (Field9) — varchar

TCM_POINT_COOP_PAY_POINT_CONVERSION (포인트 전환 내역)

  • payNo (Key) — varchar — 기본 키 — NOT NULL
  • profileID (Field2) — varchar
  • privilegeNo (Field4) — varchar
  • confirmNo (Field) — varchar
  • coopPayTxNo (Field6) — varchar
  • point (Field10) — 실수형
  • convertPayPoint (Field15) — 실수형
  • transactionType (Field8) — varchar
  • transactionStatus (Field12) — varchar
  • requestDate (Field3)
  • completeDate (Field14)
  • cancelId (Field9)
  • cancelTxNo (Field5)
  • cancelReason (Field7)
  • cancelDate (Field11)
  • coopCd (Field13)

거래구분코드 (title)

  • 0001 (적립)
  • 0002 (사용)
  • 0003 (취소)
  • 0004 (만료)

제휴사코드 (title1)

  • 0001 (CJ)
  • 0002 (Naver)
  • 0003 (Asiana)
  • 0004 (Field4)