...
Field Name | Data Type | Field Description | Format/Possible Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | AccountGuid | varchar(40) | Unique reference/ identifier for the account provided by Debitsuccess | |
| 3 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
| 4 | ScheduledFeeDate | date | Date when the supplementary fee is due | YYYY-MM-DD |
| 5 | ActualFeeStartDate | date | Date that aligns to the account’s normal recurring debit | YYYY-MM-DD |
| 6 | Amount | numeric(8,2) | Payschedule amount | |
| 7 | ScheduleNo | int | Unique reference/ identifier for the payschedule as provided by Debitsuccess | |
| 8 | CurrencyCode | varchar(200) | Currency code |