Versions Compared

Key

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

...

5

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

BusinessName

varchar(50)

Trading name of the business

34

BusinessAccount

varchar(50)

Business account name

45

ContractPrefix

char(6)

Contract Prefix associated with the business account

6

AccountGuid

varchar(40)

Unique reference/ identifier for the account provided by Debitsuccess

7

CustomerFirstName

varchar(40)

Customer's first name

68

CustomerLastName

varchar(40)

Customer's last name

79

DebitsuccessID

varchar(15)

Debitsuccess customer ID

810

OverdueAmount

numeric(8, 2)

Overdue amountĀ 

911

CatchupAmount

numeric(10, 2)

Amount arranged with the customer to catch up on overdue payments

1012

LastReversalReason

varchar(20)

Reason for last payment failureĀ 

1113

LastReversalDate

date

Date of last payment failure

YYYY-MM-DD

1214

OverdueStatus

int

Indicate overdue stages with increasing severity

Refer to description in Overdue Status

...