dup

Tables (5)

PG_COMMISSION_CODE

  • CODE — VARCHAR2(10) — Primary key — NOT NULL
  • PG_ID — VARCHAR2(10) — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(10) — NOT NULL
  • DESCRIPTION — VARCHAR2(100) — NOT NULL
  • COMMISSION_RATE — NUMBER(10, 2) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL

SERVICE_COMMISSION_CODE

  • CODE — VARCHAR2(10) — Primary key — NOT NULL
  • SERVICE_NO — BIGINT — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(10) — NOT NULL
  • DESCRIPTION — VARCHAR2(100) — NOT NULL
  • COMMISSION_RATE — NUMBER(10, 2) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL

TB_MERCHANT_SETTLE_INFO

  • ID — BIGINT — NOT NULL
  • MERCHANT_NO — BIGINT — NOT NULL
  • SETTLE_PERIOD_CODE — VARCHAR2(10) — NOT NULL
  • SETTLE_LIMIT — BIGINT — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL

TB_SETTLE_DATE

  • ID — BIGINT — NOT NULL
  • SETTLE_PERIOD_CODE — VARCHAR2(10) — NOT NULL
  • SETTLE_DATE — INT — NOT NULL
  • DESCRIPTION — VARCHAR2(100) — NOT NULL

TB_SETTLE_PERIOD_CODE

  • CODE — VARCHAR2(10) — NOT NULL
  • DESCRIPTION — VARCHAR2(100) — NOT NULL