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

BusinessName

varchar(50)

Trading name of the business

3

BusinessAccount

varchar(50)

Business account name

4

ContractPrefix

char(6)

Contract Prefix associated with the business account

5

CustomerFirstName

varchar(40)

Customer's first name

6

CustomerLastName

varchar(40)

Customer's last name

7

DebitsuccessID

varchar(15)

Debitsuccess customer ID

8

CurrentlySuspended

bit

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

0,1

9

ScheduleStartDate

datetime

The date on which the suspension shall start

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

10

ScheduleEndDate

datetime

The date on which the suspension shall end

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

11

Instalment

numeric(8, 2)

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

12

PaymentFrequencyCode

char(2)

Payment frequency of an instalment

Refer to description in Payment Frequency

...