Import Transactions

2023/06/07 • 7 min. to read

Import Transactions

Appendix, Payments Import - Data Structure

Fields
External Account Holder	Shows the name of the account holder of the imported transaction (file info: *RltdPties Dbtr Nm/RltdPties Cdtr Nm*).
External Account Holder Address	Shows the address of the account holder of the imported transaction (file info: *RltdPties Dbtr PstlAdr AdrLine/RltdPties Cdtr PstlAdr AdrLine*).
External IBAN (Bank Account No.)	Shows the IBAN or account number of the imported transaction (file info: *RltdPties DbtrAcct Id IBAN/RltdPties CdtrAcct Id IBAN (RltdPties DbtrAcct Id Othr Id/RltdPties CdtrAcct Id Othr Id)*).
External SWIFT-Code (Bank Branch No.)	Shows the SWIFT code or bank branch no. of the imported transaction (file info: *RltdAgts DbtrAgt FinInstnId BIC/RltdAgts CdtrAgt FinInstnId BIC (RltdAgts DbtrAgt FinInstnId Othr Id/RltdAgts CdtrAgt FinInstnId Othr Id)*).
Order Amount	Shows the order amount of the imported transaction (file info: *AmtDtls InstdAmt Amt*).
Order ISO Currency Code	Shows the ISO currency code of the order amount of the imported transaction (file info: *AmtDtls InstdAmt Ccy*).
Currency Factor	Shows the currency factor of the imported transaction. When the transaction entry is transferred to an journal, the amount of the order is converted with the currency factor in case of foreign currency (file Info: *Ccy/AmtDtls TxAmt CcyXchg XchgRate*).
Positive	Shows if the imported transaction is positive or negative (file info: *CdtDbtInd*).
Reversal Posting	Specifies if the imported transaction is a chargeback (return-credit/direct debit and reversal) (file info: *RvslInd*).
Posting Status	Shows the posting status of the transaction (file info: *Sts*).
Posting Date	Shows the posting date of the imported transaction (file info: *BookgDt Dt). Note Depending on the settings used in the NCPI Payments Import Setup, under Transfer*, this field is filled with the appropriate values For more information, see Import Setup - Fields, Transfer..
Value Date	Shows the value date of the imported transaction (file info: *ValDt Dt). Note Depending on the settings used in the NCPI Payments Import Setup, under Transfer*, this field is filled with the appropriate values For more information, see Import Setup - Fields, Transfer..
Open Journal Line Exists	Shows if the data has been transferred to an journal and if there is an open journal line.
Journal Line Posted	Shows if the data has been transferred to an journal and the journal line row has been posted.
Open Recon. Line Exists	Shows if the data has been transferred to an reconciliation and if there is an open reconciliation line.
Posted Statement Lines Exists	Specifies if the data has been transferred to a bank account reconciliation and a posted statement line exists.
No. of Charges	Shows the number of charges. For more information, see History, Import Charges.
Open Charge Journal Line Exists	Shows if the charges have been transferred to an journal and if there is an open journal line.
Open Charge Reconciliation Line Exists	Shows if the charges have been transferred to an reconciliation and if there is an open reconciliation line.
Posted Charge Journal Line Exists	Shows if the charges have been transferred to an journal and if the journal line has been posted.
Posted Charge Reconciliation Line Exists	Shows if the charges have been transferred to an reconciliation and if the reconciliation line has been posted.
No. of Remittance Info. Lines	Specifies the number of remittance information lines.
Remittance Info.	Shows a part of the remittance info (file info: *RmtInf Ustrd*). For more information, see History, Import Remittance Info.
Payment Reference	Shows the payment reference of the imported transaction (file info: *RmtInf Strd CdtrRefInf Ref*).
Transaction Reference (Sender Reference)	Shows the Transaction Reference (Client Reference) of the imported transaction (file info: *Refs EndToEndId >>> [TransactionReference]*).
Order Reference (Batch Control No.)	Specifies the order reference (payment info id) of the imported transaction (file info: *Refs PmtInfId >>> [OrderReference]*).
File Reference (Message Reference)	Displays the file reference (message reference) of the imported transaction. (file info: *Refs MsgId >>> [FileReference]*).
Transaction Code	Displays the transaction code (file info: *BkTxCd Prtry Cd*). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.
Transaction Code Description	Shows the transaction code Description of the corresponding import code. For more information, see Import Setup, Import Codes.
SWIFT Transaktion Code	Shows the SWIFT transaction code (file info: *BkTxCd Prtry Cd*). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.
SWIFT Transaction Code Description	Shows the SWIFT transaction code description of the corresponding import code. For more information, see Import Setup, Import Codes.
Primanota No.	Shows the primanota number of the imported transaction.
Additional Info.	Shows additional information about the imported transaction. For more information, see History, Additional Info..
Return Reason Code	Shows the return reason code of the imported transaction (file info: *RtrInf Rsn Cd*). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes
Return Reason Description	Shows the Return Reason Description of the imported transaction. These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.
Mandate ID	Displays the Mandate ID of the imported transaction (file info: *Refs MndtId*). For more information, see Export Setup, SEPA Mandates.
Check No.	Shows the check number of the imported transaction (file info: *Refs ChqNb*).
Entry No.	Shows the entry number assigned to the record. The application assigns a unique number to each record.
Data Entry No.	This field contains the entry number of the data record.
Import Entry No.	This field contains the entry number of the import.

Fields

External Account Holder

Shows the name of the account holder of the imported transaction (file info: RltdPties Dbtr Nm/RltdPties Cdtr Nm).

External Account Holder Address

Shows the address of the account holder of the imported transaction (file info: RltdPties Dbtr PstlAdr AdrLine/RltdPties Cdtr PstlAdr AdrLine).

External IBAN (Bank Account No.)

Shows the IBAN or account number of the imported transaction (file info: RltdPties DbtrAcct Id IBAN/RltdPties CdtrAcct Id IBAN (RltdPties DbtrAcct Id Othr Id/RltdPties CdtrAcct Id Othr Id)).

External SWIFT-Code (Bank Branch No.)

Shows the SWIFT code or bank branch no. of the imported transaction (file info: RltdAgts DbtrAgt FinInstnId BIC/RltdAgts CdtrAgt FinInstnId BIC (RltdAgts DbtrAgt FinInstnId Othr Id/RltdAgts CdtrAgt FinInstnId Othr Id)).

Order Amount

Shows the order amount of the imported transaction (file info: AmtDtls InstdAmt Amt).

Order ISO Currency Code

Shows the ISO currency code of the order amount of the imported transaction (file info: AmtDtls InstdAmt Ccy).

Currency Factor

Shows the currency factor of the imported transaction. When the transaction entry is transferred to an journal, the amount of the order is converted with the currency factor in case of foreign currency (file Info: Ccy/AmtDtls TxAmt CcyXchg XchgRate).

Positive

Shows if the imported transaction is positive or negative (file info: CdtDbtInd).

Reversal Posting

Specifies if the imported transaction is a chargeback (return-credit/direct debit and reversal) (file info: RvslInd).

Posting Status

Shows the posting status of the transaction (file info: Sts).

Posting Date

Shows the posting date of the imported transaction (file info: BookgDt Dt).

Note

Depending on the settings used in the NCPI Payments Import Setup, under Transfer, this field is filled with the appropriate values For more information, see Import Setup - Fields, Transfer..

Value Date

Shows the value date of the imported transaction (file info: ValDt Dt).

Note

Depending on the settings used in the NCPI Payments Import Setup, under Transfer, this field is filled with the appropriate values For more information, see Import Setup - Fields, Transfer..

Open Journal Line Exists

Shows if the data has been transferred to an journal and if there is an open journal line.

Journal Line Posted

Shows if the data has been transferred to an journal and the journal line row has been posted.

Open Recon. Line Exists

Shows if the data has been transferred to an reconciliation and if there is an open reconciliation line.

Posted Statement Lines Exists

Specifies if the data has been transferred to a bank account reconciliation and a posted statement line exists.

No. of Charges

Shows the number of charges. For more information, see History, Import Charges.

Open Charge Journal Line Exists

Shows if the charges have been transferred to an journal and if there is an open journal line.

Open Charge Reconciliation Line Exists

Shows if the charges have been transferred to an reconciliation and if there is an open reconciliation line.

Posted Charge Journal Line Exists

Shows if the charges have been transferred to an journal and if the journal line has been posted.

Posted Charge Reconciliation Line Exists

Shows if the charges have been transferred to an reconciliation and if the reconciliation line has been posted.

No. of Remittance Info. Lines

Specifies the number of remittance information lines.

Remittance Info.

Shows a part of the remittance info (file info: RmtInf Ustrd). For more information, see History, Import Remittance Info.

Payment Reference

Shows the payment reference of the imported transaction (file info: RmtInf Strd CdtrRefInf Ref).

Transaction Reference (Sender Reference)

Shows the Transaction Reference (Client Reference) of the imported transaction (file info: Refs EndToEndId >>> [TransactionReference]).

Order Reference (Batch Control No.)

Specifies the order reference (payment info id) of the imported transaction (file info: Refs PmtInfId >>> [OrderReference]).

File Reference (Message Reference)

Displays the file reference (message reference) of the imported transaction. (file info: Refs MsgId >>> [FileReference]).

Transaction Code

Displays the transaction code (file info: BkTxCd Prtry Cd). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.

Transaction Code Description

Shows the transaction code Description of the corresponding import code. For more information, see Import Setup, Import Codes.

SWIFT Transaktion Code

Shows the SWIFT transaction code (file info: BkTxCd Prtry Cd). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.

SWIFT Transaction Code Description

Shows the SWIFT transaction code description of the corresponding import code. For more information, see Import Setup, Import Codes.

Primanota No.

Shows the primanota number of the imported transaction.

Additional Info.

Shows additional information about the imported transaction. For more information, see History, Additional Info..

Return Reason Code

Shows the return reason code of the imported transaction (file info: RtrInf Rsn Cd). These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes

Return Reason Description

Shows the Return Reason Description of the imported transaction. These are import codes for transaction types that may appear in the import files. These should be set up before you start with importing. For more information, see Import Setup, Import Codes.

Mandate ID

Displays the Mandate ID of the imported transaction (file info: Refs MndtId). For more information, see Export Setup, SEPA Mandates.

Check No.

Shows the check number of the imported transaction (file info: Refs ChqNb).

Entry No.

Shows the entry number assigned to the record. The application assigns a unique number to each record.

Data Entry No.

This field contains the entry number of the data record.

Import Entry No.

This field contains the entry number of the import.

Actions

Transfer

Allows lines from the payments import to be transferred to an journal. During the transfer, for each payment transaction import, a corresponding line is created in the journal or in the reconciliation. If the option Transfer Charges in the NCPI Payments Import Setup is set to Yes, an entry is also created in the journal or in the reconciliation for the total charges by each transaction. You can either transfer the entire imported file, or individual NCPI Payments Import Data, or just individual NCPI Payments Import Transactions. For more information, see Import Tasks, Working with Payments Import Import - Transfer.

Remittance Info.

Opens the overview of the Remittance Info lines for this Transaction. Each row in the Payments Import window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges. For more information, see History, Import Remittance Info..

Charges

Opens the overview of charges for this Transaction. Each row in the Payments Import window can contain several data entries, which in turn can contain several transactions. The transactions in turn can contain several remittance info. lines and charges. For more information, see History, Import Charges.

Additional Info.

Opens the overview with the Additional Information for the selected transaction. (Stm/Rpt/Ntfctn) For more information, see History, Import Additional Info..

Import Transactions

In this Topic

Fields

Actions

Transfer

Remittance Info.

Charges

Additional Info.

See also

Feedback

Next Topic

In this Topic

★ Featured App