Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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 the account is loaded

YYYY-MM-DD HH:MM:SS [fractional seconds]

LoadSource

char(30)

Source channel of loaded payschedules/ name of the person who loaded the payschedules

ScheduleStartDate

datetime

Date when a schedule starts

YYYY-MM-DD HH:MM:SS [fractional seconds]

Instalment

numeric(8, 2)

The amount that will be collected at a frequency provided by the business

Frequency

char(2)

Payment frequency of the 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

  • No labels