...
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 | ||
| 3 | BusinessName | varchar(50) | Trading name of the business | ||
| 34 | BusinessAccount | varchar(50) | Business account name | ||
| 45 | ContractPrefix | char(6) | Contract Prefix associated with the business account | 5||
| 6 | AccountGuid | varchar(40) | Unique reference/ identifier for the account provided by Debitsuccess | ||
| 7 | CustomerFirstName | varchar(40) | Customer's first name | ||
| 68 | CustomerLastName | varchar(40) | Customer's last name | ||
| 79 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | ||
| 810 | FinishDate | datetime | Account finish date | YYYY-MM-DD HH:MM:SS [fractional seconds] | |
| 911 | CancelReason | varchar(30) | Reason for the cancellation of the account. It could have been cancelled by the business or by Debitsuccess. |
...