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

BusinessIDCustomerID

varchar(50)

Customer account identifier from the external provider

3

BusinessName

varchar(50)

Trading name of the business

4

BusinessAccount

varchar(50)

Business account name

5

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

8

CustomerLastName

varchar(40)

Customer's last name

9

DebitsuccessID

varchar(15)

Debitsuccess customer ID

10

OverdueAmount

numeric(8, 2)

Overdue amountĀ 

11

CatchupAmount

numeric(10, 2)

Amount arranged with the customer to catch up on overdue payments

12

LastReversalReason

varchar(20)

Reason for last payment failureĀ 

13

LastReversalDate

date

Date of last payment failure

YYYY-MM-DD

14

OverdueStatus

int

Indicate overdue stages with increasing severity

Refer to description in Overdue Status

...