Search TipsTransaction Detail 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 |
|---|---|---|---|---|
| Transaction Identifier | Y | Numeric | ID number of the transaction | |
| Transaction Type | Alphanumeric | 8,0 | CMP Code for the transaction type | |
| Transaction Reference | Numeric | Reference number for transaction | ||
|
Transaction Date |
|
Numeric |
25,0 |
Batch Date and Time in CMP. YYYY-MM-DD format |
|
Remark |
|
Alphanumeric |
30 |
Description of payment or comment, for example "DD Payment" |
|
Account Number |
Y |
Numeric |
8,0 |
CMP Account Number |
|
Gross Amount |
|
Numeric |
11,2 |
Gross amount of the transaction, to 2 decimal places, positive or negative |
| Statement Reference | Numeric | Reference number for statement associated with the transaction | ||
| External Reference | Numeric | External reference for the transaction used by third parties | ||
|
Reason |
|
Numeric |
6,0 | Reason code for the transaction |
| General Ledger Reference | Alphanumeric | Reference to transaction that appears in the General Ledger | ||
|
Audit Timestamp |
|
Numeric |
25,0 |
Date and time that the record was produced in CMP. YYYY-MM-DD HH:MM:SS format |
|
Audit User |
|
Alphanumric |
50 |
ID of user who changed the record |
|
Data Extract Date |
|
Numeric |
7,0 |
Date and time that the data above was extracted from CMP. YYYY-MM-DD format |