One-off and recurring payschedules which exist in active customer accounts
Field Name | Data Type | Field Description | Format/ Possible Field Values |
|---|---|---|---|
RunDate | date | Date of data extraction | YYYY-MM-DD |
DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
LoadDate | datetime | The date from which account is loaded | YYYY-MM-DD HH:MM:SS [fractional seconds] |
LoadSource | char(30) | Source channel of loaded payschedules/ name of person who loaded the payschedules | |
ScheduleStartDate | datetime | Date when a schedule starts | YYYY-MM-DD HH:MM:SS [fractional seconds] |
Instalment | numeric(8, 2) | Amount that will be collected at a frequency provided by the business | |
Frequency | char(2) | Payment frequency of an payschedule (instalment) | BM, DY, FN, FW, MN, OF, QT, WK Refer to description in Frequency |
PaymentTransactionCode | char(2) | Transaction type | Refer to description in Payment Transaction |
PaymentMethodCode | char(2) | Mode of payment for the payschedule | Refer to description in Payment Method |
ScheduleDescription | varchar(50) | Description of the schedule | |
ScheduleNo | int | Unique reference/ identifier for the schedule provided by Debitsuccess |