Versions Compared

Key

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

...

Field Name

Data Type

Field Description

Format/ Possible Field Values

1

RunDate

date

Date of data extraction

YYYY-MM-DD

2

BusinessIDCustomerID

varchar(50)

Customer account identifier from the external provider

3

BusinessName

varchar(50)

Trading name of the business

4

BusinessAccount

varchar(50)

Business account name

5

ContractPrefix

char(6)

Contract Prefix associated with the business account

6

AccountGuid

varchar(40)

Unique reference/ identifier for the account provided by Debitsuccess

7

CustomerFirstName

varchar(40)

Customer's first name

78

CustomerLastName

varchar(40)

Customer's last name

89

DebitsuccessID

varchar(15)

Debitsuccess customer ID

910

DocketNo

numeric(10, 0)

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

1011

TransactionGuid

varchar(40)

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

1112

Amount

numeric(8, 2)

Transaction amount

1213

TransDate

datetime

Transaction date

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

1314

TransType

char(1)

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

Refer to description in Trans Type

1415

PaymentTransactionCode

char(2)

Transaction type

Refer to description in Payment Transaction

1516

PaymentMethodCode

char(2)

Mode of payment for the transaction

Refer to description in Payment Method

1617

ReversalReasonCode

char(2)

Reversed payment reason

Refer to description in Reversal Reason

1718

IncomeDesc

varchar(500)

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

Debitsuccess Revenue, Facility Revenue

1819

PayoutDate

datetime

Timestamp of payout run

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

1920

PayoutBatchID

int

Unique reference/identified for a payout run

...