CurrentCustomers

A list of all customers active for the Client as of the end of the day yesterday. This file will include only a single record per customer per day.

	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	CustomerID	varchar(50)	Customer account identifier from the external provider
3	AccountGuid	varchar(40)	Unique reference/ identifier for the account provided by Debitsuccess
4	DebitsuccessID	varchar(15)	Debitsuccess customer ID
5	CustomerFirstName	varchar(40)	Customer's first name
6	CustomerLastName	varchar(40)	Customer's last name
7	FinishDate	datetime	Customer account’s finish date
8	Term	varchar(66)	Length of term
9	PaymentMethodCode	char(2)	Mode of payment for the payschedule	Refer to description in Payment Method
10	PaymentFrequencyCode	char(2)	Payment frequency of an instalment	Refer to description in Payment Frequency
11	Instalment	numeric(8, 2)	The amount that will be collected at a frequency provided by the business
12	ContractPrefix	char(6)	Contract Prefix associated with the business account
13	SetToTerm	bit	If set to true (value = 1): account is cancelled down after it has reached minimum term, or if outside term, the account can be cancelled down with notice providing contract value has been paid	0, 1
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 from which the account is loaded	YYYY-MM-DD HH:MM:SS [fractional seconds]
16	FirstInstalmentDate	datetime	First payment date	YYYY-MM-DD HH:MM:SS [fractional seconds]
17	ProjectedFinishDate	datetime	Calculated estimated account finish date	YYYY-MM-DD HH:MM:SS [fractional seconds]
18	EstFeeStatus	int	Indicates party paying for the establishment fee	Refer to description in Est Fee Status
19	EstFeeValue	numeric(7, 2)	Indicates establishment fee value
20	CurrencyCode	varchar(200)	Currency code
21	TermStatus	varchar(50)	Indicates if the respective member is inside term or outside term