...
Field Name | Data Type | Field Description | Format/ Possible Field Values | |
|---|---|---|---|---|
| 1 | RunDate | date | Date of data extraction | YYYY-MM-DD |
| 2 | BusinessID | varchar(50) | Account level unique 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 to the business account | |
| 6 | CustomerFirstName | varchar(40) | Customer's first name | |
| 7 | CustomerLastName | varchar(40) | Customer's last name | |
| 8 | DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
| 9 | DocketNo | numeric(10, 0) | Unique Debitsuccess reference/ identifier for a collection attempt from a customer | |
| 10 | TransactionGuid | uniqueidentifier | Unique Debitsuccess reference/ identifier for a transaction that aligns to client payout | |
| 11 | Amount | numeric(8, 2) | Transaction amount | |
| 12 | TransDate | datetime | Transaction date | YYYY-MM-DD HH:MM:SS [fractional seconds] |
| 13 | TransType | char(1) | Indicator field to differentiate between receipt (+ve amount) and invoice (-ve amount) | Refer to description in TransType |
| 14 | PaymentTransactionPaymentTransactionCode | char(2) | Transaction typePayment, Refund, Establishment Fee, Debt Collection Payment, Penalty Fee, Transfer Fee, One Off Payment, Paid At Facility, Suspension Fee, Cancellation Fee | Refer to description in PaymentTransactionCode |
| 15 | PaymentMethodPaymentMethodCode | char(2) | Mode of payment for the transaction | Cash, Credit Card, Direct Credit, Direct DebitRefer to description in PaymentMethodCode |
| 16 | ParticularsReversalReasonCode | char(2) | Reversed payment reasonInsufficient Funds, Authority Stopped, Account Closed, Invalid Account, Declined, No Authority | Refer to description in ReversalReasonCode |