Field Mapping When Importing SEPA CAMT Files
The generic version of Microsoft Dynamics NAV supports the regional SEPA standard (Single Euro Payments Area) for importing SEPA bank statements (CAMT format). For more information, see How to: Import Bank Statements.
The SEPA CAMT standard itself has local variations. Therefore, you may have to modify the generic data exchange definition (represented by the SEPA CAMT code in the Data Exchange Definitions window to adapt it to a local variation of the standard. The following tables show the element-to-field mapping for tables 81, 273, and 274 in the SEPA CAMT implementation in Microsoft Dynamics NAV.
For information about creating or adjusting a data exchange definition, see How to: Set Up Data Exchange Definitions.
CAMT data mapping to fields in the General Journal table (81)
| Element Path | Message Element | Data Type | Description | Negative-Sign Identifier | Field No. | Field Name |
|---|---|---|---|---|---|---|
Stmt/Ntry/Amt |
Amount |
Decimal |
The amount of money in the cash entry |
13 |
Amount |
|
Stmt/Ntry/CdtDbtInd |
CreditDebitIndicator |
Text |
Indicates whether the entry is a credit or a debit entry |
DBIT |
13 |
Amount |
Stmt/Ntry/BookgDt/Dt |
Date |
Date |
The date when an entry is posted to an account on the account servicer's books |
5 |
Posting Date |
|
Stmt/Ntry/BookgDt/DtTm |
DateTime |
DateTime |
The date and time when an entry is posted to an account on the account servicer's books |
5 |
Posting Date |
|
Stmt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Nm |
Name |
Text |
The name of the party that owes an amount of money to the (ultimate) creditor |
1221 |
Payer Information |
|
Stmt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd |
Unstructured |
Text |
Information supplied to enable the matching/reconciliation of an entry with the items that the payment is intended to settle, such as commercial invoices in an accounts-receivable system, in an unstructured form |
8 |
Description |
|
Stmt/Ntry/AddtlNtryInf |
AdditionalEntryInformation |
Text |
Additional information about the entry |
1222 |
Transaction Information |
CAMT data mapping to fields in the Bank Acc. Reconciliation table (273)
| Element Path | Message Element | Data Type | Description | Negative-Sign Identifier | Field No. | Field Name |
|---|---|---|---|---|---|---|
Stmt/CreDtTm |
CreationDateTime |
Date |
The date and time when the message was created |
3 |
Statement Date |
|
Stmt/Bal/Amt |
Amount |
Decimal |
The amount resulting from the netted amounts for all debit and credit entries |
4 |
Statement Ending Balance |
CAMT data mapping to fields in the Bank Acc. Reconciliation Line table (274)
| Element Path | Message Element | Data Type | Description | Negative-Sign Identifier | Field No. | Field Name |
|---|---|---|---|---|---|---|
Stmt/Ntry/Amt |
Amount |
Decimal |
The amount of money in the cash entry |
7 |
Statement Amount |
|
Stmt/Ntry/CdtDbtInd |
CreditDebitIndicator |
Text |
Indicates whether the entry is a credit or a debit entry |
DBIT |
7 |
Statement Amount |
Stmt/Ntry/BookgDt/Dt |
Date |
Date |
The date when an entry is posted to an account on the account servicer's books |
5 |
Transaction Date |
|
Stmt/Ntry/BookgDt/DtTm |
DateTime |
DateTime |
The date and time when an entry is posted to an account on the account servicer's books |
5 |
Transaction Date |
|
Stmt/Ntry/ValDt/Dt |
Date |
Date |
The date when assets become available to the account owner in case of a credit entry, or cease to be available to the account owner in case of a debit entry |
12 |
Value Date |
|
Stmt/Ntry/ValDt/DtTm |
DateTime |
DateTime |
The date and time when assets become available to the account owner in case of a credit entry, or cease to be available to the account owner in case of a debit entry |
12 |
Value Date |
|
Stmt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Nm |
Name |
Text |
The name of the party that owes an amount of money to the (ultimate) creditor |
15 |
Payer Information |
|
Stmt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd |
Unstructured |
Text |
Information supplied to enable the matching/reconciliation of an entry with the items that the payment is intended to settle, such as commercial invoices in an accounts-receivable system, in an unstructured form |
6 |
Description |
|
Stmt/Ntry/AddtlNtryInf |
AdditionalEntryInformation |
Text |
Additional information about the entry |
16 |
Transaction Information |
Elements in the Ntry node that are imported into Microsoft Dynamics NAV but not mapped to any fields are stored in the Data Exch. Column Def table. Users can view these elements from the Payment Reconciliation Journal, Payment Application, and Bank Acc. Reconciliation windows by choosing the Bank Statement Line Details action. For more information, see Reconcile Payments Automatically.
See Also
Tasks
How to: Import Bank Statements
How to: Use XML Schemas to Prepare Data Exchange Definitions
Concepts
Other Resources
Data Exchange Definitions
Payment Reconciliation Journal
Payment Application
Bank Acc. Reconciliation
How to: Automatically Apply Payments with Open Documents
How to: Match Bank Statement Lines with Bank Account Ledger Entries