sales_refund

Tables (3)

CRD_WITHDRAW

  • WITHDRAW_SEQ — NUMBER(10,0) — Primary key — NOT NULL
  • USER_SEQ — NUMBER(10,0)
  • TRADE_NO — VARCHAR2(32)
  • TRADE_DATE — DATE
  • TRADE_AMT — NUMBER(16,2)
  • CHARGE_PAY_AMT — NUMBER(16,2)
  • CHARGE_POINT_AMT — NUMBER(16,2)
  • REFUND_ACCOUNT — VARCHAR2(128)
  • OPERATOR_ID — VARCHAR2(20)
  • TRADE_DESC — VARCHAR2(1024)
  • PAY_CODE — CHAR(2)
  • STATUS — CHAR(1)
  • INVOICE_STATUS — CHAR(3)
  • INVOICE_DATE — DATE

PAY_REFUND_APPLYT

  • APPLY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • SERVICE_TYPE — CHAR(3)
  • USERID — VARCHAR2(20)
  • APPLY_STATUS — CHAR(1)
  • REG_DATE — DATE
  • MOD_DATE — DATE

PAY_REFUND_APPLY_WITHDRAWT

  • APPLY_NO — NUMBER(10,0) — Foreign key → PAY_REFUND_APPLYT.APPLY_NO — NOT NULL
  • WITHDRAW_SEQ — NUMBER(10,0) — Foreign key → CRD_WITHDRAW.WITHDRAW_SEQ — NOT NULL
  • REG_DATE — DATE