Transactions.

Transactions recorded against a customer’s account from yesterday. One customer may have multiple transactions recorded in single day

	Field Name	Data Type	Field Description	Format/ Possible Field Values

	Field Name	Data Type	Field Description	Format/ Possible Field Values
1	RunDate	date	Date of data extraction	YYYY-MM-DD
2	BusinessName	varchar(50)	Trading name of the business
3	BusinessAccount	varchar(50)	Business account name
4	ContractPrefix	char(6)	Contract Prefix associated to 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	DocketNo	numeric(10, 0)	Unique Debitsuccess reference/ identifier for a collection attempt from a customer
11	TransactionGuid	varchar(40)	Unique Debitsuccess reference/ identifier for a transaction that aligns to client payout
12	Amount	numeric(8, 2)	Transaction amount
13	TransDate	datetime	Transaction date	YYYY-MM-DD HH:MM:SS [fractional seconds]
14	TransType	char(1)	Indicator field to differentiate between receipt (+ve amount) and invoice (-ve amount)	Refer to description in Trans Type
15	PaymentTransactionCode	char(2)	Transaction type	Refer to description in Payment Transaction
16	PaymentMethodCode	char(2)	Mode of payment for the transaction	Refer to description in Payment Method
17	ReversalReasonCode	char(2)	Reversed payment reason	Refer to description in Reversal Reason
18	Commission	numeric(19, 2)	Amount of commission charged by Debitsuccess
19	CurrencyCode	varchar(200)	Currency code