One-off and recurring payschedules which exist in active customer accounts. One customer may have multiple payschedules within the file.
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 | AccountGuid | varchar(40) | Unique reference/ identifier for the account provided by Debitsuccess | |
| 4 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
| 5 | LoadDate | datetime | The date from which the account is loaded | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 6 | LoadSource | char(30) | Source channel of loaded payschedules/ name of the person who loaded the payschedules | |
| 7 | ScheduleStartDate | datetime | Date when a schedule starts | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 8 | Instalment | numeric(8, 2) | The amount that will be collected at a frequency provided by the business | |
| 9 | PaymentFrequencyCode | char(2) | Payment frequency of the payschedule (instalment) | Refer to description in Payment Frequency |
| 10 | PaymentTransactionCode | char(2) | Transaction type | Refer to description in Payment Transaction |
| 11 | PaymentMethodCode | char(2) | Mode of payment for the payschedule | Refer to description in Payment Method |
| 12 | ScheduleDescription | varchar(50) | Description of the schedule | |
| 13 | ScheduleNo | int | Unique reference/ identifier for the schedule provided by Debitsuccess |