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

8

CustomerLastName

varchar(40)

Customer's last name

9

DebitsuccessID

varchar(15)

Debitsuccess customer ID

10

CurrentlySuspended

bit

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

0,1

11

ScheduleStartDate

datetime

The date on which the suspension shall start

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

12

ScheduleEndDate

datetime

The date on which the suspension shall end

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

13

Instalment

numeric(8, 2)

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

14

PaymentFrequencyCode

char(2)

Payment frequency of an instalment

Refer to description in Payment Frequency

...