--- id: object/table/1230 type: object title: Table 1230 "SEPA Direct Debit Mandate" summary: Table 1230 "SEPA Direct Debit Mandate" in Base Application (Microsoft.Bank.DirectDebit). 13 fields, 5 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "28" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 655e0a73ff45fc39cee0b912042e1ac7ecf982b31f84c06d256ac27cb9529300 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/DirectDebit/SEPADirectDebitMandate.Table.al title: src/Layers/W1/BaseApp/Bank/DirectDebit/SEPADirectDebitMandate.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/finance-collect-payments-with-sepa-direct-debit objects: [] features: [] topics: - topic/business-central/business-functionality/finance/manage-payables - topic/business-central/business-functionality/finance/manage-receivables - topic/business-central/business-functionality/general-business-functionality/exchange-data-electronically/collect-payments-with-sepa-direct-debit - topic/business-central/business-functionality/general-business-functionality/exchange-data-electronically/exchange-data localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 1230 name: SEPA Direct Debit Mandate caption: Direct Debit Mandate namespace: Microsoft.Bank.DirectDebit app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "26" - "28" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 13 procedures: 13 events: 2 subscribers: 0 relations: out: 5 referenced_by: 13 pages: 1 extended_by: 0 event_subscribers: 0 calls: 1 called_by: 0 implements: 0 --- # Table 1230 "SEPA Direct Debit Mandate" > Table 1230 "SEPA Direct Debit Mandate" in Base Application (Microsoft.Bank.DirectDebit). 13 fields, 5 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28. Base Application · Microsoft.Bank.DirectDebit · captioned "Direct Debit Mandate" · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/DirectDebit/SEPADirectDebitMandate.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 1230 "SEPA Direct Debit Mandates"](../page/1230.md) (1 Learn page). ## Properties | Property | Value | |---|---| | Caption | Direct Debit Mandate | | 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 | ID | Code[35] | Specifies the ID of the direct-debit mandate. | | | 2 | Customer No. | Code[20] | Specifies the customer that the direct-debit mandate is activated for. | TableRelation [Table 18 "Customer"](../table/18.md); NotBlank | | 3 | Customer Bank Account Code | Code[20] | Specifies customer bank account that the direct-debit mandate is activated for. | TableRelation [Table 287 "Customer Bank Account"](../table/287.md) ("Customer Bank Account".Code where("Customer No." = field("Customer No."))); NotBlank | | 4 | Valid From | Date | Specifies the date when the direct-debit mandate starts. | | | 5 | Valid To | Date | Specifies the date when the direct-debit mandate ends. | | | 6 | Date of Signature | Date | Specifies when the direct-debit mandate was signed by the customer. | NotBlank | | 7 | Type of Payment | Option | Specifies if the direct-debit transaction is the first or the last according to the expected number of direct-debit transactions that you entered in the Expected Number of Debits field. | OptionCaption: OneOff,Recurrent | | 8 | Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. | | | 9 | Expected Number of Debits | Integer | Specifies how many direct-debit transactions you expect to perform using the direct-debit mandate. This field is used to calculate when to enter First or Last in the Sequence Type field in the Direct Debit Collect. Entries window. | | | 10 | Debit Counter | Integer | Specifies how many direct-debit transactions have been performed using the direct-debit mandate. | not editable | | 11 | No. Series | Code[20] | — | TableRelation [Table 308 "No. Series"](../table/308.md) (No. Series) | | 12 | Closed | Boolean | Specifies that the direct-debit mandate is closed, for example because the date in the Valid To field has been exceeded. | not editable | | 13 | Ignore Exp. Number of Debits | Boolean | Specifies that the direct-debit mandate will not be closed automatically when the debit counter reaches the expected number of debits. | | ## Keys - Key1: ID (clustered) - Key2: Customer No. ## Events published - `OnBeforeInsert(var IsHandled: boolean; var SEPADirectDebitMandate: Record "SEPA Direct Debit Mandate")` (integration): Integration event triggered before inserting a new mandate record. - `OnBeforeModify(var IsHandled: boolean; var SEPADirectDebitMandate: Record "SEPA Direct Debit Mandate")` (integration): Integration event triggered before modifying a mandate record. ## Procedures - `IsMandateActive(TransactionDate: Date): Boolean`: Checks if the mandate is active and valid for the specified transaction date. - `GetDefaultMandate(CustomerNo: Code[20]; DueDate: Date): Code[35]`: Finds the default active mandate for a customer on a specific due date. Prioritizes customer's preferred bank account if specified. - `UpdateCounter()`: Increments the debit counter when the mandate is used and updates the closed status. - `GetSequenceType(): Integer`: Determines the SEPA sequence type based on mandate type and usage history. - `RollBackSequenceType()`: Decrements the debit counter when a collection is rejected or rolled back. Plus 6 local procedures. ## Triggers OnInsert, OnModify ## Relations - drill-down page [Page 1230 "SEPA Direct Debit Mandates"](../page/1230.md) - lookup page [Page 1230 "SEPA Direct Debit Mandates"](../page/1230.md) - Customer No.: TableRelation [Table 18 "Customer"](../table/18.md) - Customer Bank Account Code: TableRelation [Table 287 "Customer Bank Account"](../table/287.md) - No. Series: TableRelation [Table 308 "No. Series"](../table/308.md) ## Referenced by 13 fields in 12 objects relate to this table (TableRelation or CalcFormula). - [Table 1208 "Direct Debit Collection Entry"](../table/1208.md): Mandate Type of Payment, Mandate ID - [Table 112 "Sales Invoice Header"](../table/112.md): Direct Debit Mandate ID - [Table 172 "Standard Customer Sales Code"](../table/172.md): Direct Debit Mandate ID - [Table 181 "Posted Gen. Journal Line"](../table/181.md): Direct Debit Mandate ID - [Table 21 "Cust. Ledger Entry"](../table/21.md): Direct Debit Mandate ID - [Table 36 "Sales Header"](../table/36.md): Direct Debit Mandate ID - [Table 5900 "Service Header"](../table/5900.md): Direct Debit Mandate ID - [Table 5965 "Service Contract Header"](../table/5965.md): Direct Debit Mandate ID - [Table 5970 "Filed Service Contract Header"](../table/5970.md): Direct Debit Mandate ID - [Table 5992 "Service Invoice Header"](../table/5992.md): Direct Debit Mandate ID - [Table 6010 "Service Header Archive"](../table/6010.md): Direct Debit Mandate ID - [Table 81 "Gen. Journal Line"](../table/81.md): Direct Debit Mandate ID ## Pages and codeunits on this table - [Page 1230 "SEPA Direct Debit Mandates"](../page/1230.md) (source table) ## 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. - [Page 456 "No. Series"](../page/456.md) (1 call: `InsertNoSeries → (object)`) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC26, BC28 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: "SEPA Direct Debit Mandate")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.