Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

Active customers who are currently on suspension and/or have suspensions with a start date in the future. One customer may have multiple suspension records within the file.

Field Name

Data Type

Field Description

Format/ Possible Field Values

RunDate

date

Date of data extraction

YYYY-MM-DD

BusinessName

varchar(50)

Trading name of the business

BusinessAccount

varchar(50)

Business account name

ContractPrefix

char(6)

Contract Prefix associated with the business account

CustomerFirstName

varchar(40)

Customer's first name

CustomerLastName

varchar(40)

Customer's last name

DebitsuccessID

varchar(15)

Debitsuccess customer ID

CurrentlySuspended

bit

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

0,1

ScheduleStartDate

datetime

The date on which the suspension shall start

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

ScheduleEndDate

datetime

The date on which the suspension shall end

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

Instalment

numeric(8, 2)

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

PaymentFrequencyCode

char(2)

Payment frequency of an instalment

Refer to description in Payment Frequency

  • No labels