CurrentCustomers

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

PaymentMethod

char(2)

Mode of payment for the payschedule

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

Frequency

char(2)

Payment frequency of an instalment

Weekly, Fortnightly, Four Weekly, Monthly, Bi Monthly, Quarterly, One Off

Instalment

numeric(8, 2)

Amount that will be collected at a frequency provided by the business

ContractPrefix

char(6)

Contract Prefix associated to 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, account can be cancelled down with notice providing contract value has been paid

0, 1

StartDate

datetime

The date from which account will be active

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

LoadDate

datetime

The date from which 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]