...
Field Name | Data Type | Field Description | Format/ Possible Field Values | |||||
---|---|---|---|---|---|---|---|---|
1 | RunDate | date | Date of data extraction | YYYY-MM-DD | ||||
2 | CustomerID | varchar(50) | Customer account identifier from the external provider | 3 | BusinessName | varchar(50) | Trading name of the business | |
43 | BusinessAccount | varchar(50) | Business account name | |||||
54 | ContractPrefix | char(6) | Contract Prefix associated with the business account | |||||
5 | CustomerID | varchar(50) | Customer account identifier from the external provider | |||||
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 |
...