Table 1207 "Direct Debit Collection"
Base Application · Microsoft.Bank.DirectDebit
Across versions
- BC23present
- BC241 fields changed
- BC25-27unchanged
- BC287 fields changed
- BC29-30unchanged
Neighbourhood 6 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 1207 “Direct Debit Collections” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Direct Debit Collection |
| 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 | No. Δ BC28 | Integer | Specifies the number of the involved entry or record, according to the specified number series. | |
| 2 | Identifier Δ BC28 | Code[20] | Specifies, together with the number series, which direct debit collection a direct-debit collection entry is related to. | |
| 3 | Created Date-Time | DateTime | — | |
| 4 | Created by User Δ BC28 | Code[50] | Specifies which user created the direct debit collection. | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 5 | Status Δ BC28 | Option | Specifies the status of the direct debit collection. The following options exist. | OptionCaption: New,Canceled,File Created,Posted,Closed |
| 6 | No. of Transfers Δ BC28 | Integer | Specifies how many direct debit transactions have been performed for the direct debit collection. | FlowField: count(“Direct Debit Collection Entry” where(“Direct Debit Collection No.” = field(“No.”))) |
| 7 | To Bank Account No. Δ BC28 | Code[20] | Specifies the number of the bank account that the direct debit collection will be transferred to. | TableRelation Table 270 “Bank Account” (Bank Account) |
| 8 | To Bank Account Name Δ BC24 Δ BC28 | Text[100] | Specifies the name of the bank account that the direct debit collection will be transferred to. | FlowField: lookup(“Bank Account”.Name where(“No.” = field(“To Bank Account No.”))) |
| 9 | Message ID | Code[35] | — | |
| 10 | Partner Type | Enum “Partner Type” | — | enum Enum 134 “Partner Type”; not editable |
Keys
- Key1: No. (clustered)
Events published
OnBeforeHasPaymentFileErrors(DirectDebitCollection: Record "Direct Debit Collection"; var DirectDebit: Record "Gen. Journal Line"; var Result: Boolean; var IsHandled: Boolean)(integration): Integration event that allows customization of payment file error checking logic.
Procedures
CreateRecord(NewIdentifier: Code[20]; NewBankAccountNo: Code[20]; PartnerType: Enum "Partner Type"): Creates a new direct debit collection record with the specified parameters.CloseCollection(): Closes the collection and sets status of pending entries to rejected. Prompts user for confirmation as this action prevents payment registration.Export(): Initiates SEPA export process for all entries in this collection.HasPaymentFileErrors(): Boolean: Checks if any payment file errors exist for entries in this collection.SetStatus(NewStatus: Option): Updates the collection status with proper locking.DeletePaymentFileErrors(): Removes all payment file errors associated with entries in this collection.
Relations
- drill-down page Page 1207 “Direct Debit Collections”
- lookup page Page 1207 “Direct Debit Collections”
- No. of Transfers: CalcFormula Table 1208 “Direct Debit Collection Entry”
- To Bank Account Name: CalcFormula Table 270 “Bank Account”
- To Bank Account No.: TableRelation Table 270 “Bank Account”
Referenced by
3 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 1208 “Direct Debit Collection Entry”: Direct Debit Collection Status, Direct Debit Collection No.
- Table 1255 “Direct Debit Collection Buffer”: Direct Debit Collection No.
Pages and codeunits on this table
- Page 1207 “Direct Debit Collections” (source table)
Recent changes
- 2026-09-07 #11036 Ruleset hardening: promote four compatibility rules to Error (main, BC30, other)
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). 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"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.