CustomersAdded

Newly loaded customer accounts from yesterday. This file will include only a single record per customer per day. All customers added (loaded) even before a payschedule is created, for 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	Term	int	Length of term
11	Payments	int	Number of payments
12	Instalment	numeric(8, 2)	The amount that will be collected at a frequency provided by the business
13	PaymentFrequencyCode	char(2)	Payment frequency of the payschedule (instalment)	Refer to description in Payment Frequency
14	StartDate	datetime	The date from which the account will be active.	YYYY-MM-DD HH:MM:SS [fractional seconds]
15	LoadDate	datetime	The date when the account was loaded	YYYY-MM-DD HH:MM:SS [fractional seconds]
16	CurrencyCode	varchar(200)	Currency code