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