CustomersCurrentAndFutureSuspensions

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

	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	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
15	ScheduleDescription	varchar(50)	Description of the schedule
16	ScheduleNo	int	Unique reference/ identifier for the schedule provided by Debitsuccess
17	CurrencyCode	varchar(200)	Currency code