Search TipsPayment Details
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Account |
Y |
Numeric |
8,0 |
CMP Account Number |
|
2 |
Unique Transaction ID |
Y |
Alphanumeric |
20 |
Unique, non-sequential ID |
|
3 |
Payment Amount |
|
Numeric |
11,2 |
Amount of payment |
|
4 |
Date Processed |
|
Numeric |
7,0 |
Date payment was processed. YYYY-MM-DD format. |
|
5 |
Time Processed |
|
Numeric |
6,0 |
Time payment was processed. HHMMSS format. |
|
6 |
Payment Status |
|
Alphanumeric |
1 |
Status of the payment |
|
7 |
Payment Status Description |
|
Alphanumeric |
25 |
Description of the Payment Status When a payment is successful the description shows as 'Authorised' and when a payment fails the description displays as 'Rejected'. |
|
8 |
Payment Type |
|
Alphanumeric |
6 |
Payment type associated with the payment |
|
9 |
Reason |
|
Alphanumeric |
4 |
Reason code associated with the payment |
|
10 |
Reason Code Description |
|
Alphanumeric |
30 |
Description of the Reason |
|
11 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD format |
|
12 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
13 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format |
|
14 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
15 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |