Active customers who are currently on suspension and/or have suspensions with a start date in the future
Field Name | Data Type | Field Description | Format/ Possible Field Values |
|---|---|---|---|
RunDate | date | Date of data extraction | YYYY-MM-DD |
BusinessName | varchar(50) | Trading name of the business | |
BusinessAccount | varchar(50) | Business account name | |
ContractPrefix | char(6) | Contract Prefix associated to the business account | |
CustomerFirstName | varchar(40) | Customer's first name | |
CustomerLastName | varchar(40) | Customer's last name | |
DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
CurrentlySuspended | bit | If set to true (value =1), customer is currently on suspension | 0,1 |
ScheduleStartDate | datetime | The date on which the suspension shall start | YYYY-MM-DD HH:MM:SS [fractional seconds] |
ScheduleEndDate | datetime | The date on which the suspension shall end | YYYY-MM-DD HH:MM:SS [fractional seconds] |
Instalment | numeric(8, 2) | Amount that will be collected at a frequency provided by the business | |
Frequency | char(2) | Payment frequency of an installment | BM, DY, FN, FW, MN, OF, QT, WK Refer to description in Frequency |