Bank Statement Lines (tfcmg5511m000)
Use this session to view bank statement lines.
Field Information
- Electronic Bank Statement
-
electronic bank statement
-
- IBAN/Bank Account
- Bank Statement ID
-
The bank statement identifier from the bank.
- Bank Statement ID Sequence
-
The bank statement sequence number from the bank.
- Bank Statement Currency
-
The currency of the bank statement.
-
- Opening Balance
-
The amount of the opening balance.
- Closing Balance
-
The amount of the closing balance.
- Status
-
The status type.
Allowed values
- Converted
- Importing in Process
- Imported
-
The initial status of a bank statement that was received via a BOD.
- Validation in Process
- Not Applicable
- Validation Warnings
- Validated
- Matching in Process
- Partially Matched
- Conversion in Process
- Fully Matched
- Posting in Process
- Posting Errors
- Posted
- Exception
-
If this check box is selected, one or more errors or warnings exist.
-
- Total
-
The total debit amount.
-
The total credit amount.
- Matched
-
The matched debit amount.
-
The matched credit amount.
- Perc. Amount
-
The percentage of matched debit amounts.
- %
-
The percentage of matched credit amounts.
- Line
-
The sequence number of the bank statement line, always starting with value “1”.
-
- Business Partner's Name
-
The business partner name retrieved from the bank statement line.
- Bank Account
-
The bank account number from which or to which an amount is transferred.
- Bank Identifier
- Pay-to/Pay by Business Partner
-
The pay-to business partner or the pay-by business partner.
- Name
-
The business partner's title.
- Booking Date (UTC)
-
The date the transaction was booked at the bank.
- Value Date (UTC)
-
The date the transaction was posted by the bank.
- Detail Line(s)
-
If this check box is selected, one or more detail lines exist.
- Matching Status
-
The matching status of the bank statement line.
The status can be one of the following:
- Not Matched
- Partially Matched
- Fully Matched
- Posted
- Exception
-
If this check box is selected, one or more errors or warnings exist.
-
- Amount in Bank Currency
-
The amount on the electronic bank statement.
-
The currency on the electronic bank statement.
- Incoming/Outgoing
-
The type of bank transaction. In case of a remaining amount, this indicator determines whether an unallocated payment or an unallocated receipt will be created.
- Matched Amount
-
The amount that was already assigned.
- Unmatched Amount
-
The amount that remains to be assigned.
- Bank Charges in Bank Currency
-
bank charges
- Original Amount
-
The invoice amount.
- Original Transaction Currency
-
The invoice currency.
- Original Rate
- Rate Date
-
The exchange rate used was valid at this date and time.
-
- Description
-
The description on the bank statement, for example, the invoices paid. This value can be defaulted from the External Invoice value.
- Check Number
-
The check number used for the payment.
- Document Reference
-
The transaction type and document number, or the trade note number. This value can be defaulted from the External Invoice value.
- Bank Reference
- Mandate Reference
-
The number of a direct debit mandate.
- Return Reason Code
-
The return reason code.
- Return Reason Description
-
The return reason description.
-
-
The entire description.