A list of all customers active for the Client as of the end of the day yesterday. This file will include only a single record per customer per day.
Field Name | Data Type | Field Description | Format/ Possible Field Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
| 3 | CustomerFirstName | varchar(40) | Customer's first name | |
| 4 | CustomerLastName | varchar(40) | Customer's last name | |
| 5 | FinishDate | datetime | Customer account’s finish date | |
| 6 | Term | varchar(66) | Length of term | |
| 7 | PaymentMethodCode | char(2) | Mode of payment for the payschedule | Refer to description in Payment Method |
| 8 | PaymentFrequencyCode | char(2) | Payment frequency of an instalment | Refer to description in Payment Frequency |
| 9 | Instalment | numeric(8, 2) | The amount that will be collected at a frequency provided by the business | |
| 10 | ContractPrefix | char(6) | Contract Prefix associated with the business account | |
| 11 | SetToTerm | bit | If set to true (value = 1):
| 0, 1 |
| 12 | StartDate | datetime | The date from which the account will be active | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 13 | LoadDate | datetime | The date from which the account is loaded | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 14 | EstFeeStatus | int | Indicates party paying for the establishment fee | Refer to description in Est Fee Status |
| 15 | EstFeeValue | numeric(7, 2) | Indicates establishment fee value | |
| 16 | FirstInstalmentDate | datetime | First payment date | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 17 | ProjectedFinishDate | datetime | Calculated estimated account finish date | YYYY-MM-DD HH:MM:SS [fractional seconds] |