CustomersOverdue

Active customer accounts with an amount owing, as at 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	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	OverdueAmount	numeric(8, 2)	Overdue amount
11	CatchupAmount	numeric(10, 2)	Amount arranged with the customer to catch up on overdue payments
12	LastReversalReason	varchar(20)	Reason for last payment failure
13	LastReversalDate	date	Date of last payment failure	YYYY-MM-DD
14	OverdueStatus	int	Indicate overdue stages with increasing severity	Refer to description in Overdue Status
15	CurrencyCode	varchar(200)	Currency code