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 setup (represented by the SEPA CAMT code in the Post Exch Def List 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 setup, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

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 Posting 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.

CAMT data mapping to fields in the General Journal table (81)

CAMT data mapping to fields in the Bank Acc. Reconciliation table (273)

CAMT data mapping to fields in the Bank Acc. Reconciliation Line table (274)

See Also

Tasks

Concepts