Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Data Type

Field Description

Format/ Possible Field Values

RunDate

date

Date of data extraction

YYYY-MM-DD

BusinessID

varchar(50)

Account level unique identifier from the external provider

BusinessName

varchar(50)

Trading name of the business

BusinessAccount

varchar(50)

Business account name

ContractPrefix

char(6)

Contract Prefix associated to the business account

CustomerFirstName

varchar(40)

Customer's first name

CustomerLastName

varchar(40)

Customer's last name

DebitsuccessID

varchar(15)

Debitsuccess customer ID

DocketNo

numeric(10, 0)

Unique Debitsuccess reference/ identifier for a collection attempt from a customer

TransactionGuid

uniqueidentifier

Unique Debitsuccess reference/ identifier for a transaction that aligns to client payout

Amount

numeric(8, 2)

Transaction amount

TransDate

datetime

Transaction date

YYYY-MM-DD HH:MM:SS [fractional seconds]

TransType

char(1)

Indicator field to differentiate between receipt (+ve amount) and invoice (-ve amount)

Refer to description in TransType

PaymentTransaction

char(2)

Transaction typePayment, Refund, Establishment Fee, Debt Collection Payment, Penalty Fee, Transfer Fee, One Off Payment, Paid At Facility, Suspension Fee, Cancellation Fee

Refer to description in PaymentTransactionCode

PaymentMethod

char(2)

Mode of payment for the transaction

Cash, Credit Card, Direct Credit, Direct DebitRefer to description in PaymentMethodCode

Particulars

char(2)

Reversed payment reasonInsufficient Funds, Authority Stopped, Account Closed, Invalid Account, Declined, No Authority

Refer to description in ReversalReasonCode

IncomeDesc

varchar(500)

Indicator field to differentiate a transaction amount between Debitsuccess or Client Revenue

Debitsuccess Revenue, Facility Revenue

PayoutDate

datetime

Timestamp of payout run

YYYY-MM-DD HH:MM:SS [fractional seconds]

PayoutBatchID

int

Unique reference/identified for a payout run

...