Related topics
- About the Imported bank statement functionality
- Setting up the Imported bank statement functionality
This panel displays the rejected transactions for the selected imported bank statement. The transaction is rejected if the transaction’s bank transaction code is inactive or missing in Work with Cash Management schemes/Bank accounts details. From here you can drill down to view the payment details. See the Integrator script section and the Approves/rejects transactions within the imported bank statement section in About the Imported bank statement functionality for more information.
Options
| Payment details | Select this option to access the Work with imported bank statements, Payment details panel where you can view the payment details for the selected payment. |
Function keys
| Business partner seq/Document date seq | Toggle to view rejected transactions in Business partner sequence or Document date sequence. |
Selection fields
- Syst
- Optional field. Enter the user’s language code for System identities (A/R, A/P or G/L), or enter a question mark (?) character to select undefined transactions (bank transaction code is missing in Work with Cash Management schemes/Bank accounts details).
- Imported bank stmt
- Displays the imported bank statement number and Message Identification. If Message Identification is missing, this field displays the imported bank statement number and description.
Message Identification:
For field details for description, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.For the Netstore/Teller Settlement Report, the file name is displayed.
Description:
For field details for description, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Acquirer Information.
- Status
- Displays the status code of the imported bank statement.
Code Description 20 Reloading completed 30 Transfer completed
- Creation date/time
- Displays the date and time that the bank created the file.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Group header or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Group header.
For the Netstore/Teller Settlement Report, the date from the file name and time when the XML was imported to DC1 is displayed.
- Electronic seq no
- Displays the unique electronic sequence number of the bank account statement assigned by the bank.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification.
For Netstore/Teller Settlement Report, the Payments info/Settlement number is displayed.
- Bank account no/curr
- Displays the bank account number and currency.
For field details, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Statement (Account) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Notification (Account).
For the Netstore/Teller Settlement Report, the Card Acceptor Details info/Agreement Card Acceptor Num is displayed. Currency code is not applicable.
- Doc date
- This column displays the document date of the transaction.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Entry (Value Date) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Entry (Value Date).
For Netstore/Teller Settlement Report, (Payments Info/Actual Settlement Date).
- Business partner
- This column displays the payment’s debtor number for the Mandate ID, if it exists. Otherwise for the business partner for the bank account number, if it exists.
- Amount
- This column displays the amount of the transaction in transaction currency.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Amount Details/Transaction Amount) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Amount Details/Transaction Amount).
For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Amount).
- Curr
- This column displays the transaction currency for the transaction.
For ISO 20022, see Transaction amount above. For Netstore/Teller Settlement Report, (Transaction Level/Transaction Settlement Currency).
- Domain
- This column displays the transaction’s bank transaction code for Domain.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Family
- This column displays the transaction’s bank transaction code for Family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Sub fam
- This column displays the transaction’s bank transaction code for Sub family.
For field ISO 20022 details, refer to the standard or local guideline according to the UNIFI Payments message BankToCustomerStatetmentV02 (Msg ID camt.053.001.02), Entry (Bank Transaction Code) or to BankToCustomerDebitCreditNotificationV02 (Msg ID camt.054.001.02), Entry (Bank Transaction Code).
For Netstore/Teller Settlement report, default value.
- Syst
- This column displays the user’s language code for System identities A/R, A/P or G/L. A question mark (?) character denotes undefined transactions (bank transaction code is missing in Work with Cash Management schemes/Bank accounts details).
- Internal name
- Only shown if this column has been activated through the Edit columns feature. This column displays the internal name of the business partner.
- Domain description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction domain code description from Work with ISO 20022 external code lists.
- Family description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction family code description from Work with ISO 20022 external code lists.
- Sub family description
- Only shown if this column has been activated through the Edit columns feature. This column displays the bank transaction sub family code description from Work with ISO 20022 external code lists.
- Bank account number
- Only shown if this column has been activated through the Edit columns feature. This column displays the business partner’s bank account number where the payment was drawn.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Debtor Account) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Debtor Account).
For Netstore/Teller Settlement Report, this field is not applicable.
- Mandate ID
- Only shown if this column has been activated through the Edit columns feature. This column displays the payment’s Mandate ID when the SEPADD function is activated in the Function control file.
For ISO 20022, refer to the standard or local guideline according to the UNIFI ISO 20022 Payments message BankToCustomerStatementV02 (Msg ID camt.053.001.02), Transaction Details (Mandate Identification) or to BankToCustomerDebitCreditNotificationV02( Msg ID camt.054.001.02), Transaction Details (Mandate Identification).
For Netstore/Teller Settlement Report, this field is not applicable.