Client Data Files

Client Data Files is a suite of CSV files containing data pertaining to customers, payschedules, contract prefixes, transactions, payout, etc. It is a service offered to our Clients by Debitsuccess.

This service is available by request only through our Account Management team.

Debitsuccess will deliver these files once per day to the client’s choice of cloud-based storage, either AWS S3 bucket, Azure Data Lake or Azure Blob Storage that is managed by them.

The following is a list of files that can be requested through this service. To learn more about fields provided in each file, please click on the file names below:

File naming: DS_<FacilityGroup>_<FileName>_<YYYYMMDD><Timestamp>

Note: Timestamp → HHMMSS

Other Information:

The fields in the CSV files are separated using the pipe delimiter. Empty or Null fields will be an empty string.
File sending : Clients will receive each of the files they are subscribed for daily, regardless of whether data exist in the file or not.
i.e. If there is no data from the preceding day, the file will only contain the header row. In the event of an issue during file generation, Debitsuccess will hold off sending the entire set of files until the issue is resolved to prevent partial data sending.

	File Name	File Description

	File Name	File Description
1	CustomersAdded	Newly loaded customer accounts from yesterday
2	CustomersAddedPayschedules	One-off and recurring payschedules which have been added to active customer accounts from yesterday
3	CustomersAllPayschedules	One-off and recurring payschedules which exist in active customer accounts
4	CustomersCancelled	Cancelled customer accounts from yesterday
5	CustomersOverdue	Active customer accounts with an amount owing, as at the end of the day yesterday
6	CustomersCurrentAndFutureSuspensions	Active customers who are currently on suspension and/or have suspensions with a start date in the future
7	ContractPrefix	Client's contract prefix for each business account
8	CurrentCustomers	A list of all customers active for the Client as of the end of the day yesterday
9	PayoutSummary	Summary of client’s payout run from yesterday
10	PayoutTransactions	Transaction level detail file for customer payments, from all payout runs in the PayoutSummary file.
11	Transactions	Transactions recorded against a customer’s account from yesterday
12	QuarterlyFeeAdded	One-off supplemental fees payschedules added from the prior day <Client specific process only>