Page Comparison

RunDate

date

Date of data extraction

YYYY-MM-DD

DebitsuccessID

varchar(15)

Debitsuccess customer ID

CustomerFirstName

varchar(40)

Customer's first name

CustomerLastName

varchar(40)

Customer's last name

FinishDate

datetime

Customer account’s finish date

Term

varchar(66)

Length of term

PaymentMethodPaymentMethodCode

char(2)

Mode of payment for the payschedule

Direct Debit, Credit Card, Cash, Cheque, Automatic Payment

FrequencyRefer to description in Payment Method

PaymentFrequencyCode

char(2)

Payment frequency of an instalmentWeekly

, Fortnightly, Four Weekly, Monthly, Bi Monthly, Quarterly, One OffRefer to description in Payment Frequency

Instalment

numeric(8, 2)

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

ContractPrefix

char(6)

Contract Prefix associated with the business account

SetToTerm

bit

If set to true (value = 1):

• account is cancelled down after it has reached minimum term, or

• if outside term, the account can be cancelled down with notice providing contract value has been paid

0, 1

StartDate

datetime

The date from which the account will be active

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

LoadDate

datetime

The date from which the account is loaded

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

EstFeeStatus

int

Indicates party paying for the establishment fee

Refer to description in Est Fee Status

EstFeeValue

numeric(7, 2)

Indicates establishment fee value

FirstInstalmentDate

datetime

First payment date

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

ProjectedFinishDate

datetime

Calculated estimated account finish date

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