Table 1206 "Credit Transfer Entry"
Base Application · Microsoft.Bank.Payment
Across versions
- BC23present
- BC243 fields changed
- BC25-26unchanged
- BC271 fields changed
- BC2814 fields changed
- BC29-30unchanged
Neighbourhood 10 connected objects and pages
Base Application · Microsoft.Bank.Payment · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1206 “Credit Transfer Reg. Entries” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Credit Transfer Entry |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Credit Transfer Register No. Δ BC28 | Integer | Specifies the number of the credit-transfer register entry in the Credit Transfer Registers window that the credit transfer entry relates to. | TableRelation Table 1205 “Credit Transfer Register” (Credit Transfer Register) |
| 2 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 3 | Account Type Δ BC28 | Enum “Credit Transfer Account Type” | Specifies the type of account that received payment with the credit transfer. If the type is Debitor, then the credit transfer was a refund. | enum Enum 1207 “Credit Transfer Account Type” |
| 4 | Account No. Δ BC28 | Code[20] | Specifies the number of the vendor, or debitor, who received payment with the credit transfer. If the Account Type field contains Debitor, then the credit transfer was a refund. | TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor) |
| 5 | Applies-to Entry No. Δ BC28 | Integer | Specifies the entry number of the purchase invoice that the vendor ledger entry behind this credit transfer was applied to. | TableRelation Table 21 “Cust. Ledger Entry”, Table 25 “Vendor Ledger Entry” (if (“Account Type” = const(Customer)) “Cust. Ledger Entry” else if (“Account Type” = const(Vendor)) “Vendor Ledger Entry”) |
| 6 | Transfer Date Δ BC28 | Date | Specifies when the SEPA credit transfer is made. The value is copied from the Posting Date field on the payment line for the purchase invoice. | |
| 7 | Currency Code Δ BC28 | Code[10] | Specifies the currency that the SEPA credit transfer was made in. To process payments using SEPA Credit Transfer, the currency on the purchase invoice must be EURO. | TableRelation Table 4 “Currency” |
| 8 | Transfer Amount Δ BC27 Δ BC28 | Decimal | Specifies the amount that is paid with the SEPA credit transfer. | |
| 9 | Transaction ID Δ BC28 | Text[35] | Specifies the ID of the credit transfer. The ID is defined from the value in the Identifier field in the Credit Transfer Register field plus the value in the Entry No. field, divided by a slash. For example, DABA00113/3. | |
| 10 | Canceled Δ BC28 | Boolean | Specifies if the exported payment file for this credit transfer register entry has been canceled. | FlowField: exist(“Credit Transfer Register” where(“No.” = field(“Credit Transfer Register No.”), Status = const(Canceled))) |
| 11 | Recipient Bank Acc. No. | Code[50] | Recipient Bank Account caption | |
| 12 | Message to Recipient Δ BC28 | Text[140] | Specifies the text that was entered in the Message to Recipient field on the payment journal line that this credit transfer file was exported from. | |
| 13 | Recipient IBAN Δ BC24 Δ BC28 | Code[50] | Specifies the IBAN of the creditor bank account that was used on the payment journal line that this credit transfer file was exported from. | |
| 14 | Recipient Bank Account No. Δ BC24 Δ BC28 | Code[30] | Specifies the number of the creditor bank account that was used on the payment journal line that this credit transfer file was exported from. | |
| 15 | Recipient Name Δ BC24 Δ BC28 | Text[100] | Specifies the recipient of the exported credit transfer, typically a vendor. | DataClassification EndUserIdentifiableInformation |
Keys
- Key1: Credit Transfer Register No., Entry No. (clustered)
Events published
OnAfterFillRecipientData(var CreditTransferEntry: Record "Credit Transfer Entry")(integration): Integration event raised after filling recipient data from account information. Enables custom logic for populating additional recipient fields.OnAfterGetAppliesToEntry(var CreditTransferEntry: Record "Credit Transfer Entry"; var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")(integration): Integration event raised after retrieving applies-to entry information. Enables modification of the CV ledger entry buffer before it is used.OnCreateNewOnAfterInitAccountType(var CreditTransferEntry: Record "Credit Transfer Entry"; GenJnlAccountType: Enum "Gen. Journal Account Type")(integration): Integration event raised after initializing account type during CreateNew procedure. Enables custom logic for handling additional account type mappings.
Procedures
CreateNew(RegisterNo: Integer; EntryNo: Integer; GenJnlAccountType: Enum "Gen. Journal Account Type"; AccountNo: Code[20]; LedgerEntryNo: Integer; TransferDate: Date; CurrencyCode: Code[10]; TransferAmount: Decimal; TransActionID: Text[35]; RecipientBankAccount: Code[20]; MessageToRecipient: Text[140]): Creates a new credit transfer entry with the specified parameters.FillRecipientData(): Fills recipient data fields based on the account type and account number. Retrieves recipient name, IBAN, and bank account number from related tables.AppliesToEntryDocumentNo(): Code[20]: Returns the document number from the applied ledger entry.AppliesToEntryDescription(): Text: Returns the description from the applied ledger entry.AppliesToEntryPostingDate(): Date: Returns the posting date from the applied ledger entry.AppliesToEntryCurrencyCode(): Code[10]: Returns the currency code from the applied ledger entry.AppliesToEntryAmount(): Decimal: Returns the original amount from the applied ledger entry.AppliesToEntryRemainingAmount(): Decimal: Returns the remaining amount from the applied ledger entry.
Plus 1 local procedures.
Relations
- drill-down page Page 1206 “Credit Transfer Reg. Entries”
- lookup page Page 1206 “Credit Transfer Reg. Entries”
- Canceled: CalcFormula Table 1205 “Credit Transfer Register”
- Credit Transfer Register No.: TableRelation Table 1205 “Credit Transfer Register”
- Account No.: TableRelation Table 18 “Customer” (conditional)
- Applies-to Entry No.: TableRelation Table 21 “Cust. Ledger Entry” (conditional)
- Account No.: TableRelation Table 23 “Vendor” (conditional)
- Applies-to Entry No.: TableRelation Table 25 “Vendor Ledger Entry” (conditional)
- Currency Code: TableRelation Table 4 “Currency”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 1205 “Credit Transfer Register”: No. of Transfers
Pages and codeunits on this table
- Page 1206 “Credit Transfer Reg. Entries” (source table)
Extended by
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Credit Transfer Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.