Table "Direct Debit Collection"

ID 1207

Namespace: Microsoft.Bank.DirectDebit

Represents a collection of direct debit transactions that are grouped together for processing and export. This table serves as the header for organizing multiple direct debit entries into a single collection for efficient processing and SEPA file generation.

Properties

Name	Value
Caption	Direct Debit Collection
DataCaptionFields	2,3
DrillDownPageID	Page Microsoft.Bank.DirectDebit."Direct Debit Collections"
LookupPageID	Page Microsoft.Bank.DirectDebit."Direct Debit Collections"
DataClassification	CustomerContent

Fields

Name	Type	Description
"No."	Integer	Sequential number that uniquely identifies the direct debit collection within the system.
Identifier	Code[20]	Business identifier for the collection, used in external file formats and customer communication.
"Created Date-Time"	DateTime	Timestamp when the direct debit collection was initially created.
"Created by User"	Code[50]	User name of the person who created this direct debit collection.
Status	Option	Current processing status of the collection, tracking its lifecycle from creation to completion.
"No. of Transfers"	Integer	Calculated count of direct debit collection entries associated with this collection.
"To Bank Account No."	Code[20]	Bank account that will receive the direct debit collections when processed.
"To Bank Account Name"	Text[100]	Name of the destination bank account, retrieved from the bank account master data.
"Message ID"	Code[35]	Unique message identifier used in SEPA XML files for tracking and reconciliation purposes.
"Partner Type"	Enum Microsoft.Foundation.Enums."Partner Type"	Specifies the partner type for the collection, determining processing rules and file formats.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

CreateRecord

Creates a new direct debit collection record with the specified parameters.

procedure CreateRecord(NewIdentifier: Code[20], NewBankAccountNo: Code[20], PartnerType: Enum "Partner Type")

Parameters

Name	Type	Description
NewIdentifier	Code[20]	Business identifier for the collection
NewBankAccountNo	Code[20]	Bank account that will receive the collections
PartnerType	Enum Microsoft.Foundation.Enums."Partner Type"	Partner type determining processing rules

CloseCollection

Closes the collection and sets status of pending entries to rejected. Prompts user for confirmation as this action prevents payment registration.

procedure CloseCollection()

Export

Initiates SEPA export process for all entries in this collection.

procedure Export()

HasPaymentFileErrors

Checks if any payment file errors exist for entries in this collection.

procedure HasPaymentFileErrors(): Boolean

Returns

Type	Description
Boolean	True if payment file errors are found

SetStatus

Updates the collection status with proper locking.

procedure SetStatus(NewStatus: Option)

Parameters

Name	Type	Description
NewStatus	Option	The new status to set

DeletePaymentFileErrors

Removes all payment file errors associated with entries in this collection.

procedure DeletePaymentFileErrors()

Events

OnBeforeHasPaymentFileErrors

Integration event that allows customization of payment file error checking logic.

[IntegrationEvent(False,False)]
local procedure OnBeforeHasPaymentFileErrors(DirectDebitCollection: Record "Direct Debit Collection", var DirectDebit: Record "Gen. Journal Line", var Result: Boolean, var IsHandled: Boolean)

Parameters

Name	Type	Description
DirectDebitCollection	Table Microsoft.Bank.DirectDebit."Direct Debit Collection"	The direct debit collection being checked
DirectDebit	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"	General journal line for error checking
Result	Boolean	Result of the error check
IsHandled	Boolean	Whether the event has been handled by subscribers

See also

• Table