CustomersAllPayschedules

One-off and recurring payschedules which exist in active customer accounts. One customer may have multiple payschedules 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	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	LoadDate	datetime	The date from which the account is loaded	YYYY-MM-DD HH:MM:SS [fractional seconds]
6	LoadSource	char(30)	Source channel of loaded payschedules/ name of the person who loaded the payschedules
7	ScheduleStartDate	datetime	Date when a schedule starts	YYYY-MM-DD HH:MM:SS [fractional seconds]
8	Instalment	numeric(8, 2)	The amount that will be collected at a frequency provided by the business
9	PaymentFrequencyCode	char(2)	Payment frequency of the payschedule (instalment)	Refer to description in Payment Frequency
10	PaymentTransactionCode	char(2)	Transaction type	Refer to description in Payment Transaction
11	PaymentMethodCode	char(2)	Mode of payment for the payschedule	Refer to description in Payment Method
12	ScheduleDescription	varchar(50)	Description of the schedule
13	ScheduleNo	int	Unique reference/ identifier for the schedule provided by Debitsuccess
14	CurrencyCode	varchar(200)	Currency code