Search TipsPayment Details Analytics
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
|
Account Number |
Y |
Numeric |
8,0 |
CMP Account Number |
|
Payment Identifier |
Y |
Numeric |
|
ID number of the payment |
|
Payment Amount |
|
Numeric |
11,2 |
Amount of payment, to 2 decimal places |
|
Payment Date Time |
|
Numeric |
25,0 |
Date and time that payment was processed. YYYY-MM-DD HH:MM:SS format |
|
Payment Status |
|
Alphanumeric |
1 |
Status of the payment, for example, S=Success |
|
Payment Status Description |
|
Alphanumeric |
25 |
Description of the Payment Status, for example, Success |
|
Payment Type |
|
Alphanumeric |
6 |
Payment type code associated with the payment, for example, MANUAL |
|
Reason Code |
|
Alphanumeric |
4 |
Reason code associated with the payment, for example, SET |
|
Reason Description |
|
Alphanumeric |
30 |
Text Description of the Reason Code, for example, Settled |
| Payment Source | Alphanumeric | 1 | Code for the payment source, for example, O=Online Payment, B = Prepaid Balance | |
| Payment Source Description | Alphanumeric | 30, 0 | Text description of the payment source, for example, Online Payment, Prepaid Balance | |
| External Reference | Alphanumeric | 15,0 | Reference number for payment used by external third party | |
| SPUniqueIdentifier | Alphanumeric | 10,0 | Unique identifier for the SP | |
| AuditTimestamp | Numeric | 25,0 | Date and time of audit. YYYY-MM-DD HH:MM:SS format | |
| Error Code |
Alphanumeric |
4 |
If applicable, the error code associated with a payment error | |
| Error Description |
Alphanumeric |
30 |
If applicable, the description of the error associated with the payment | |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |