Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following is a list of files that can be requested through this service. Data provided is an end of day figure (as of midnight prior day). To learn more about fields provided in each file, please click on the file names below:

...

  • 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.

  • \ (backslash) appearing at the end of the description fields (ScheduleDescription, CancelReason and LastReversalReason) in the files have been cleared to avoid potential errors in the file loading process

  • From 10th December 2021, | (pipe delimiters) appearing in the description field would be converted to a space to avoid ambiguity and potential errors during the files loading process

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>

...