CustomersCancelled

Cancelled customer accounts from yesterday. This file will include only a single record per customer per day. All customers cancelled during the previous day (until 23:59:59 of the previous day) will be present in this file.

	Field Name	Data Type	Field Description	Format/ Possible Field Values

	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	CustomerID	varchar(50)	Customer account identifier from the external provider
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	FinishDate	datetime	Account finish date	YYYY-MM-DD HH:MM:SS [fractional seconds]
11	CancelReason	varchar(30)	Reason for the cancellation of the account. It could have been cancelled by the business or by Debitsuccess.
12	CustomCancelReason	nvarchar(200)	To identify if a custom cancel reason is selected during the process of cancellation of members