Table 1208 "Direct Debit Collection Entry"
Base Application · Microsoft.Bank.DirectDebit
Across versions
- BC23present
- BC249 fields changed
- BC25-26unchanged
- BC271 fields changed
- BC2819 fields changed
- BC29-30unchanged
Neighbourhood 14 connected objects and pages
Base Application · Microsoft.Bank.DirectDebit · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1208 “Direct Debit Collect. Entries” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Direct Debit Collection 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 | Direct Debit Collection No. | Integer | — | TableRelation Table 1207 “Direct Debit Collection” (Direct Debit Collection) |
| 2 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 3 | Customer No. Δ BC28 | Code[20] | Specifies the number of the customer that the direct-debit payment is collected from. | TableRelation Table 18 “Customer” |
| 4 | Applies-to Entry No. Δ BC28 | Integer | Specifies the number of the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | TableRelation Table 21 “Cust. Ledger Entry” (“Cust. Ledger Entry” where(“Customer No.” = field(“Customer No.”), “Document Type” = filter(Invoice | “Finance Charge Memo” | Reminder), Open = const(true))) |
| 5 | Transfer Date Δ BC28 | Date | Specifies the date when the payment will be collected from the customer’s bank account. | |
| 6 | Currency Code Δ BC28 | Code[10] | Specifies the currency of the payment amount that is being collected as a direct debit. | TableRelation Table 4 “Currency”; not editable |
| 7 | Transfer Amount Δ BC27 Δ BC28 | Decimal | Specifies the amount that will be collected from the customer’s bank account. | |
| 8 | Transaction ID Δ BC28 | Text[35] | Specifies the ID of the direct debit collection. It consist of a number in the SEPA direct-debit message number series and the value in the Applies-to Entry No. field. | not editable |
| 9 | Sequence Type Δ BC28 | Option | Specifies if the direct-debit collection entry is the first or the last of a sequence of recurring entries. | OptionCaption: One Off,First,Recurring,Last; not editable |
| 10 | Status Δ BC28 | Option | Specifies the status of the direct-debit collection entry. | OptionCaption: New,File Created,Rejected,Posted; not editable |
| 11 | Mandate ID Δ BC28 | Code[35] | Specifies the ID of the direct-debit mandate that exists for the direct debit collection in question. | TableRelation Table 1230 “SEPA Direct Debit Mandate” (“SEPA Direct Debit Mandate”.ID where(“Customer No.” = field(“Customer No.”))) |
| 12 | Mandate Type of Payment Δ BC24 Δ BC28 | Option | Specifies if the related direct-debit mandate is created for one or multiple direct debit collections. | FlowField: lookup(“SEPA Direct Debit Mandate”.“Type of Payment” where(ID = field(“Mandate ID”))); OptionCaption: One Off,Recurrent; not editable |
| 13 | Customer Name Δ BC24 Δ BC28 | Text[100] | Specifies the name of the customer that the direct-debit payment is collected from. | FlowField: lookup(Customer.Name where(“No.” = field(“Customer No.”))); not editable |
| 14 | Applies-to Entry Document No. Δ BC24 Δ BC28 | Code[20] | Specifies the document number on the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | FlowField: lookup(“Cust. Ledger Entry”.“Document No.” where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 15 | Applies-to Entry Description Δ BC24 Δ BC28 | Text[100] | Specifies the description of the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | FlowField: lookup(“Cust. Ledger Entry”.Description where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 16 | Applies-to Entry Posting Date Δ BC24 Δ BC28 | Date | Specifies when the sales invoice that the customer leger entry behind this direct-debit collection entry applies to was posted. | FlowField: lookup(“Cust. Ledger Entry”.“Posting Date” where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 17 | Applies-to Entry Currency Code Δ BC24 Δ BC28 | Code[10] | Specifies the currency of the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | TableRelation Table 4 “Currency”; FlowField: lookup(“Cust. Ledger Entry”.“Currency Code” where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 18 | Applies-to Entry Amount Δ BC28 | Decimal | Specifies the payment amount on the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | FlowField: sum(“Detailed Cust. Ledg. Entry”.Amount where(“Cust. Ledger Entry No.” = field(“Applies-to Entry No.”), “Entry Type” = filter(“Initial Entry” | “Unrealized Loss” | “Unrealized Gain” | “Realized Loss” | “Realized Gain” | “Payment Discount” | “Payment Discount (VAT Excl.)” | “Payment Discount (VAT Adj…; not editable |
| 19 | Applies-to Entry Rem. Amount Δ BC28 | Decimal | Specifies the amount that remains to be paid on the sales invoice that the customer leger entry behind this direct-debit collection entry applies to. | FlowField: sum(“Detailed Cust. Ledg. Entry”.Amount where(“Cust. Ledger Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 20 | Applies-to Entry Open Δ BC24 Δ BC28 | Boolean | Specifies if the sales invoice that the customer leger entry behind this direct-debit collection entry applies to is open. | FlowField: lookup(“Cust. Ledger Entry”.Open where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 21 | Direct Debit Collection Status Δ BC24 | Option | — | FlowField: lookup(“Direct Debit Collection”.Status where(“No.” = field(“Direct Debit Collection No.”))); OptionCaption: New,Canceled,File Created,Posted,Closed |
| 22 | Payment Reference Δ BC24 | Code[50] | — | FlowField: lookup(“Cust. Ledger Entry”.“Payment Reference” where(“Entry No.” = field(“Applies-to Entry No.”))); not editable |
| 23 | Message to Recipient | Text[140] | — |
Keys
- Key1: Direct Debit Collection No., Entry No. (clustered)
- Key2: Applies-to Entry No., Status
Events published
OnBeforeCheckSEPA(var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; var IsHandled: Boolean)(integration): Integration event that allows customization of SEPA validation checks.OnBeforeCheckCustLedgerEntryAmountPositive(var CustLedgerEntry: Record "Cust. Ledger Entry"; var IsHandled: Boolean)(integration): Integration event that allows customization of customer ledger entry amount validation.OnBeforeDocTypeErr(CustLedgerEntry: Record "Cust. Ledger Entry"; var AlllowedDocumentType: Boolean)(integration): Integration event that allows customization of document type validation logic.OnBeforeExportSEPA(var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; var IsHandled: Boolean)(integration): Integration event that allows customization of SEPA export processing.OnBeforeTransferPKToGenJnlLine(var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; var GenJnlLine: Record "Gen. Journal Line"; var IsHandled: Boolean)(integration): Integration event for customizing primary key transfer to general journal line.OnBeforeValidateTransferAmount(var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; var IsHandled: Boolean)(integration): Integration event that allows customization of transfer amount validation.OnCreateNewOnBeforeInsert(CustLedgerEntry: Record "Cust. Ledger Entry"; var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry")(integration): Integration event triggered before inserting a new collection entry.OnCreateNewOnAfterInsert(CustLedgerEntry: Record "Cust. Ledger Entry"; var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry")(integration): Integration event triggered after inserting a new collection entry.OnValidateAppliesToEntryNoOnAfterTransferCustLedgerEntryFields(var DirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; xDirectDebitCollectionEntry: Record "Direct Debit Collection Entry"; CustLedgerEntry: Record "Cust. Ledger Entry")(integration): Integration event triggered after transferring fields from customer ledger entry during validation.
Procedures
CreateNew(DirectDebitCollectionNo: Integer; CustLedgerEntry: Record "Cust. Ledger Entry"): Creates a new direct debit collection entry based on a customer ledger entry.DeletePaymentFileErrors(): Removes payment file errors associated with this collection entry.HasPaymentFileErrors(): Boolean: Checks if any payment file errors exist for this collection entry.ExportSEPA(): Initiates SEPA direct debit export process for this collection entry.InsertPaymentFileError(Text: Text): Creates a payment file error entry with specified text.InsertPaymentFileErrorWithDetails(ErrorText: Text; AddnlInfo: Text): Creates a payment file error entry with additional details.Reject(): Rejects the collection entry and rolls back the mandate sequence type if applicable.GetAmountInActiveCollections(): Decimal: Calculates the total amount already allocated to other active collections for the same customer ledger entry.SetTodayAsTransferDateForOverdueEnries(): Updates transfer dates to today for all overdue entries in the same collection.
Plus 2 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- drill-down page Page 1208 “Direct Debit Collect. Entries”
- lookup page Page 1208 “Direct Debit Collect. Entries”
- Direct Debit Collection Status: CalcFormula Table 1207 “Direct Debit Collection”
- Direct Debit Collection No.: TableRelation Table 1207 “Direct Debit Collection”
- Mandate Type of Payment: CalcFormula Table 1230 “SEPA Direct Debit Mandate”
- Mandate ID: TableRelation Table 1230 “SEPA Direct Debit Mandate”
- Customer Name: CalcFormula Table 18 “Customer”
- Customer No.: TableRelation Table 18 “Customer”
- Applies-to Entry Currency Code: CalcFormula Table 21 “Cust. Ledger Entry”
- Applies-to Entry Description: CalcFormula Table 21 “Cust. Ledger Entry”
- Applies-to Entry Document No.: CalcFormula Table 21 “Cust. Ledger Entry”
- Applies-to Entry Open: CalcFormula Table 21 “Cust. Ledger Entry”
- Applies-to Entry Posting Date: CalcFormula Table 21 “Cust. Ledger Entry”
- Payment Reference: CalcFormula Table 21 “Cust. Ledger Entry”
- Applies-to Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
- Applies-to Entry Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
- Applies-to Entry Rem. Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
- Applies-to Entry Currency Code: TableRelation Table 4 “Currency”
- Currency Code: TableRelation Table 4 “Currency”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 1207 “Direct Debit Collection”: No. of Transfers
Pages and codeunits on this table
- Page 1208 “Direct Debit Collect. Entries” (source table)
- Codeunit 1230 “SEPA DD-Export File” (codeunit runs on it)
- Codeunit 1232 “SEPA DD-Prepare Source” (codeunit runs on it)
- Codeunit 1233 “SEPA DD-Check Line” (codeunit runs on it)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 1233 “SEPA DD-Check Line” (2 calls:
CreateNew → (object),SetTodayAsTransferDateForOverdueEnries → (object)) - Codeunit 1230 “SEPA DD-Export File” (1 call:
ExportSEPA → (object))
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Direct Debit Collection Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.