Newly loaded customer accounts from yesterday. This file will include only a single record per customer per day. All customers added (loaded) even before a payschedule is created, for the previous day (until 23:59:59 of the previous day) will be present in this file.
Field Name | Data Type | Field Description | Format/Possible Field Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | 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 | Term | int | Length of term | |
| 11 | Payments | int | Number of payments |
Instalment
| 12 | Instalment | numeric(8, 2) | The amount that will be collected at a frequency provided by the business | |
| 13 | PaymentFrequencyCode | char(2) | Payment frequency of |
'WK' - Weekly
'FN' - Fortnightly
'FW'- Four Weekly 'MN' - Monthly
'BM' - Bi Monthly
'QT' - Quarterly
'OF' - One Off
StartDate
the payschedule (instalment) | Refer to description in Payment Frequency | |||
| 14 | StartDate | datetime | The date from which the account will be active. | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 15 | LoadDate | datetime | The date when the account was loaded | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 16 | CurrencyCode | varchar(200) | Currency code |