...
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 with the business account | |
CustomerFirstName | varchar(40) | Customer's first name | |
CustomerLastName | varchar(40) | Customer's last name | |
DebitsuccessID | varchar(15) | Debitsuccess customer ID. Unique reference/identifier for customers cancelled. | |
FinishDate | datetime | Account finish date | YYYY-MM-DD HH:MM:SS [fractional seconds] |
CancelReason | varchar(30) | Reason for the cancellation of the account. It could have been cancelled by the business or by Debitsuccess. |
...