One-off supplemental fees payschedules added from the prior day. One customer may have multiple payschedules within the file.
Field Name | Data Type | Field Description | Format/Possible Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | AccountGuid | uniqueidentifier | 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 |