Search TipsTransaction Detail
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Account |
Y |
Numeric |
8,0 |
CMP Account Number |
|
2 |
Invoice |
Y |
Numeric |
8,0 |
Invoice number |
|
3 |
Invoice Date |
|
Numeric |
7,0 |
Date invoice produced in CMP. YYYY-MM-DD format. |
|
4 |
Transaction Type |
|
Alphanumeric |
2 |
Code for Transaction Type |
|
5 |
Transaction Type Description |
|
Alphanumeric |
30 |
Description for Transaction Type |
|
6 |
Amount |
Y |
Numeric |
11,2 |
Amount in pounds and pence, to 2 decimal places, positive or negative |
|
7 |
Transaction Date |
|
Numeric |
7,0 |
Batch Date in CMP. YYYY-MM-DD format. |
|
8 |
Payment/Item number |
Y |
Numeric |
8,0 |
Payment Item Reference |
|
9 |
Payment/Item Pay Item |
Y |
Alphanumeric |
3 |
Document Pay Item - Matching(Pmt/Item) |
|
10 |
Remark |
|
Alphanumeric |
30 |
Description of payment, for example "DD Payment" |
|
11 |
Open Amount |
|
Numeric |
11,2 |
The amount in pounds and pence that has not been matched against an invoice or payment |
|
12 |
Payment/Item Doc Type |
|
Alphanumeric |
2 |
Code for Transaction Type that this transaction was matched to |
|
13 |
Payment/Item Doc Typ Description |
|
Alphanumeric |
30 |
Description for Transaction Type that his transaction was matched to |
|
14 |
User ID |
|
Alphanumeric |
10 |
User ID of user who created / changed the record. |
|
15 |
Date Updated |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
16 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |