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

Data Exchange

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