Versions Compared

Key

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

...

Field Name

Data Type

Field Description

Format/ Possible Field Values

RunDate

date

Date of data extraction

YYYY-MM-DD

BusinessName

varchar(50)

Trading name of the business

BusinessAccount

varchar(50)

Business account name

ContractPrefix

char(6)

Contract Prefix associated with the business account

CustomerFirstName

varchar(40)

Customer's first name

CustomerLastName

varchar(40)

Customer's last name

DebitsuccessID

varchar(15)

Debitsuccess customer ID. Unique reference/identifier for customers added.

OverdueAmount

numeric(8, 2)

Overdue amountĀ 

CatchupAmount

numeric(10, 2)

Amount arranged with the customer to catch up on overdue payments

LastReversalReason

varchar(20)

Reason for last payment failureĀ 

LastReversalDate

date

Date of last payment failure

YYYY-MM-DD

OverdueStatus

int

Indicate overdue stages with increasing severity

Refer to description in Overdue Status

...