Versions Compared

Key

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

...

5

Field Name

Data Type

Field Description

Format/ Possible Field Values

1

RunDate

date

Date of data extraction

YYYY-MM-DD

2

BusinessID

varchar(50)

Customer account identifier from the external provider

3

BusinessName

varchar(50)

Trading name of the business

34

BusinessAccount

varchar(50)

Business account name

45

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

68

CustomerLastName

varchar(40)

Customer's last name

79

DebitsuccessID

varchar(15)

Debitsuccess customer ID

810

CurrentlySuspended

bit

If set to true (value =1), the customer is currently on suspension

0,1

911

ScheduleStartDate

datetime

The date on which the suspension shall start

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

1012

ScheduleEndDate

datetime

The date on which the suspension shall end

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

1113

Instalment

numeric(8, 2)

The amount that will be collected at a frequency provided by the business

1214

PaymentFrequencyCode

char(2)

Payment frequency of an instalment

Refer to description in Payment Frequency

...