Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

35

LoadDate

datetime

The date from which the account is loaded

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

46

LoadSource

char(30)

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

57

ScheduleStartDate

datetime

Date when a schedule starts

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

68

Instalment

numeric(8, 2)

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

79

PaymentFrequencyCode

char(2)

Payment frequency of the payschedule (instalment)

Refer to description in Payment Frequency

810

PaymentTransactionCode

char(2)

Transaction type

Refer to description in Payment Transaction

911

PaymentMethodCode

char(2)

Mode of payment for the payschedule

Refer to description in Payment Method

1012

ScheduleDescription

varchar(50)

Description of the schedule

1113

ScheduleNo

int

Unique reference/ identifier for the schedule provided by Debitsuccess

...