Active customers who are currently on suspension and/or have suspensions with a start date in the future. One customer may have multiple suspension records within the file.
Field Name | Data Type | Field Description | Format/ Possible Field Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 |
BusinessID
varchar(50)
Customer account identifier from the external provider
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 | CurrentlySuspended | bit | If set to true (value =1), the customer is currently on suspension | 0,1 |
| 11 | ScheduleStartDate | datetime | The date on which the suspension shall start | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 12 | ScheduleEndDate | datetime | The date on which the suspension shall end | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 13 | Instalment | numeric(8, 2) | The amount that will be collected at a frequency provided by the business | |
| 14 | PaymentFrequencyCode | char(2) | Payment frequency of an instalment | Refer to description in Payment Frequency |
| 15 | ScheduleDescription | varchar(50) | Description of the schedule |
|
| 16 | ScheduleNo | int | Unique reference/ identifier for the schedule provided by Debitsuccess | |
| 17 | CurrencyCode | varchar(200) | Currency code |