The Matched Payments table contains details of the Matching Information within Exchequer.
Relational Links
The Matched Payments can be relationally linked to the Transactions (thOurRef) through mpPayRef, mpOurRef, and mpAltRef.
Field Name |
Description |
Type |
Length |
mpIdxRecSub |
TP |
String |
2 |
mpRecType |
T |
String |
1 |
mpSubType |
P |
String |
1 |
mpOurRef |
Matching - Our Ref |
Lstring |
13 |
mpIdxDoc |
Matching - Link To Transaction |
String |
12 |
mpPayRef |
Matching - Receipt Ref |
Lstring |
11 |
mpIdxPayRef |
Matching - Link To Receipt |
String |
11 |
mpSettled |
Matching - Settled Amount |
Float |
|
mpOwnCur |
Matching - Currency Settled Amount |
Float |
2 |
mpCurrency |
Matching - Currency |
Integer |
1 |
mpMatchType |
Matching - Type |
String |
1 |
mpAltRef |
Matching - Alternate Reference |
Lstring |
11 |
mpReceiptCur |
Matching - Receipt Currency |
Integer |
1 |
mpReceiptAmt |
Matching - Receipt Amount |
Float |
8 |
mpSpare |
Future Use |
String |
213 |