...
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 | ||
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 | CurrentlySuspended | bit | If set to true (value =1), the customer is currently on suspension | 0,1 | |
911 | ScheduleStartDate | datetime | The date on which the suspension shall start | YYYY-MM-DD HH:MM:SS [fractional seconds] | |
1012 | ScheduleEndDate | datetime | The date on which the suspension shall end | YYYY-MM-DD HH:MM:SS [fractional seconds] | |
1113 | Instalment | numeric(8, 2) | The amount that will be collected at a frequency provided by the business | ||
1214 | PaymentFrequencyCode | char(2) | Payment frequency of an instalment | Refer to description in Payment Frequency |
...