Table "Payment Export Data"

ID 1226

Namespace: Microsoft.Bank.Payment

Table 1226 "Payment Export Data" contains data for exporting payments to bank files. This table stores all the necessary information for payment file generation including sender bank details, recipient information, payment amounts, SEPA parameters, and various formatting options.

Properties

Name	Value
Caption	Payment Export Data
DataClassification	CustomerContent

Fields

Name	Type	Description
"Entry No."	Integer	Unique identifier for the payment export data entry.
"Data Exch Entry No."	Integer	Reference to the data exchange entry associated with this payment export.
"Line No."	Integer	Line number within the data exchange for this payment export data.
"Data Exch. Line Def Code"	Code[20]	Code defining the line definition in the data exchange.
"General Journal Template"	Code[10]	General journal template associated with this payment export.
"General Journal Batch Name"	Code[10]	General journal batch name associated with this payment export.
"General Journal Line No."	Integer	General journal line number associated with this payment export.
"Sender Bank Name - Data Conv."	Text[50]	Sender bank name for data conversion purposes (limited to 50 characters).
"Sender Bank Name"	Text[100]	Full name of the sender bank.
"Sender Bank Account Code"	Code[20]	Code of the sender bank account.
"Sender Bank Account No."	Text[50]	Account number of the sender bank.
"Sender Bank Account Currency"	Code[10]	Currency code of the sender bank account.
"Sender Bank Country/Region"	Code[10]	Country/region code of the sender bank.
"Sender Bank BIC"	Code[35]	Bank Identifier Code (BIC) of the sender bank.
"Sender Bank Clearing Std."	Text[50]	Clearing standard used by the sender bank.
"Sender Bank Clearing Code"	Text[50]	Clearing code used by the sender bank.
"Sender Bank Address"	Text[100]	Address of the sender bank.
"Sender Bank City"	Text[50]	City of the sender bank.
"Sender Bank Post Code"	Code[20]	Postal code of the sender bank.
"Recipient Name"	Text[100]	Name of the payment recipient.
"Recipient Address"	Text[100]	Address of the payment recipient.
"Recipient City"	Text[50]	City of the payment recipient.
"Recipient Post Code"	Code[20]	Postal code of the payment recipient.
"Recipient Country/Region Code"	Code[10]
"Recipient Email Address"	Text[80]
"Recipient ID"	Code[20]
"Recipient Bank Clearing Std."	Text[50]
"Recipient Bank Clearing Code"	Text[50]
"Recipient Reg. No."	Code[20]
"Recipient Acc. No."	Code[30]
"Recipient Bank Acc. No."	Text[50]
"Recipient Bank BIC"	Code[35]
"Recipient Bank Name"	Text[100]
"Recipient Bank Address"	Text[100]
"Recipient Bank City"	Text[50]
"Recipient Bank Country/Region"	Code[10]
"Recipient Creditor No."	Code[20]
"Recipient Bank Post Code"	Code[20]
"Message Type"	Code[1]
"Letter to Sender"	Code[1]
"Recipient Acknowledgement"	Code[1]
"Short Advice"	Text[35]
"Message to Recipient 1"	Text[140]
"Message to Recipient 2"	Text[140]
Amount	Decimal
"Currency Code"	Code[10]
"Transfer Date"	Date
"Transfer Type"	Code[1]
"Payment Type"	Text[50]
"Document No."	Code[20]
"Recipient Reference"	Code[35]
"Payment Reference"	Code[50]
"Invoice Amount"	Decimal
"Invoice Date"	Date
"Recipient County"	Text[30]
"Recipient Bank County"	Text[30]
"Sender Bank County"	Text[30]
"Sender Reg. No."	Text[50]
"Payment Information ID"	Text[50]
"End-to-End ID"	Text[50]
"Message ID"	Text[35]
"SEPA Instruction Priority"	Option
"SEPA Instruction Priority Text"	Code[4]
"SEPA Payment Method"	Option
"SEPA Payment Method Text"	Code[3]
"SEPA Batch Booking"	Boolean
"SEPA Charge Bearer"	Option
"SEPA Charge Bearer Text"	Code[4]
"SEPA Direct Debit Mandate ID"	Code[35]
"SEPA Direct Debit Seq. Type"	Option
"SEPA Direct Debit Seq. Text"	Code[4]
"SEPA DD Mandate Signed Date"	Date
"SEPA Partner Type"	Enum Microsoft.Foundation.Enums."Partner Type"
"SEPA Partner Type Text"	Code[4]
"Importing Code"	Code[10]
"Importing Date"	Date
"Importing Description"	Text[250]
"Costs Distribution"	Text[30]
"Message Structure"	Text[30]
"Own Address Info."	Text[30]
"Creditor No."	Code[35]
"Transit No."	Code[35]
"Applies-to Ext. Doc. No."	Code[35]
"Format Command"	Code[4]
"Format Remittance Info Type"	Code[1]
"Format Payment Type"	Code[2]
"Format Expense Code"	Code[1]
"Format Text Code"	Code[3]
"Format Form Type"	Code[2]
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

InitData

procedure InitData(var GenJnlLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GenJnlLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"

AddRemittanceText

procedure AddRemittanceText(NewText: Text[140])

Parameters

Name	Type	Description
NewText	Text[140]

GetRemittanceTexts

procedure GetRemittanceTexts(var PaymentExportRemittanceText: Record "Payment Export Remittance Text")

Parameters

Name	Type	Description
PaymentExportRemittanceText	Table Microsoft.Bank.Payment."Payment Export Remittance Text"

GetOrganizationID

procedure GetOrganizationID(): Text

Returns

Type	Description
Text

GetSenderCreditorNo

procedure GetSenderCreditorNo(): Text

Returns

Type	Description
Text

AddGenJnlLineErrorText

procedure AddGenJnlLineErrorText(GenJnlLine: Record "Gen. Journal Line", NewText: Text)

Parameters

Name	Type	Description
GenJnlLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"
NewText	Text

SetPreserveNonLatinCharacters

procedure SetPreserveNonLatinCharacters(NewPreserveNonLatinCharacters: Boolean)

Parameters

Name	Type	Description
NewPreserveNonLatinCharacters	Boolean

GetPreserveNonLatinCharacters

procedure GetPreserveNonLatinCharacters(): Boolean

Returns

Type	Description
Boolean

CompanyInformationConvertToLatin

procedure CompanyInformationConvertToLatin(var CompanyInformation: Record "Company Information")

Parameters

Name	Type	Description
CompanyInformation	Table Microsoft.Foundation.Company."Company Information"

SetCustomerAsRecipient

procedure SetCustomerAsRecipient(var Customer: Record Customer, var CustomerBankAccount: Record "Customer Bank Account")

Parameters

Name	Type	Description
Customer	Table Microsoft.Sales.Customer.Customer
CustomerBankAccount	Table Microsoft.Sales.Customer."Customer Bank Account"

SetVendorAsRecipient

procedure SetVendorAsRecipient(var Vendor: Record Vendor, var VendorBankAccount: Record "Vendor Bank Account")

Parameters

Name	Type	Description
Vendor	Table Microsoft.Purchases.Vendor.Vendor
VendorBankAccount	Table Microsoft.Purchases.Vendor."Vendor Bank Account"

SetEmployeeAsRecipient

procedure SetEmployeeAsRecipient(var Employee: Record Employee)

Parameters

Name	Type	Description
Employee	Table Microsoft.HumanResources.Employee.Employee

SetBankAsRecipient

procedure SetBankAsRecipient(var BankAccount: Record "Bank Account")

Parameters

Name	Type	Description
BankAccount	Table Microsoft.Bank.BankAccount."Bank Account"

SetBankAsSenderBank

procedure SetBankAsSenderBank(BankAccount: Record "Bank Account")

Parameters

Name	Type	Description
BankAccount	Table Microsoft.Bank.BankAccount."Bank Account"

SetCreditorIdentifier

procedure SetCreditorIdentifier(BankAccount: Record "Bank Account")

Parameters

Name	Type	Description
BankAccount	Table Microsoft.Bank.BankAccount."Bank Account"

SetCreditTransferIDs

procedure SetCreditTransferIDs(MessageID: Code[20])

Parameters

Name	Type	Description
MessageID	Code[20]

IsFieldBlank

procedure IsFieldBlank(FieldID: Integer): Boolean

Parameters

Name	Type	Description
FieldID	Integer

Returns

Type	Description
Boolean

Events

OnAfterGetSenderCreditorNo

Integration event raised after determining the sender creditor number for payment export. Enables custom logic to modify or override the creditor number used in payment files.

[IntegrationEvent(True,False)]
local procedure OnAfterGetSenderCreditorNo(PaymentExportData: Record "Payment Export Data", var CreditorNo: Text)

Parameters

Name	Type	Description
PaymentExportData	Table Microsoft.Bank.Payment."Payment Export Data"	Payment export data record being processed
CreditorNo	Text	Creditor number to be used in payment export

OnAfterSetBankAsSenderBank

Integration event raised after setting the bank account as sender bank for payment export. Enables custom processing after sender bank configuration.

[IntegrationEvent(True,False)]
local procedure OnAfterSetBankAsSenderBank(BankAccount: Record "Bank Account")

Parameters

Name	Type	Description
BankAccount	Table Microsoft.Bank.BankAccount."Bank Account"	Bank account configured as sender

OnAfterSetCustomerAsRecipient

Integration event raised after setting a customer as the payment recipient. Enables custom modifications to customer recipient data for payment export.

[IntegrationEvent(False,False)]
local procedure OnAfterSetCustomerAsRecipient(var PaymentExportData: Record "Payment Export Data", var Customer: Record Customer, var CustomerBankAccount: Record "Customer Bank Account")

Parameters

Name	Type	Description
PaymentExportData	Table Microsoft.Bank.Payment."Payment Export Data"	Payment export data being updated
Customer	Table Microsoft.Sales.Customer.Customer	Customer record configured as recipient
CustomerBankAccount	Table Microsoft.Sales.Customer."Customer Bank Account"	Customer bank account for payment

OnAfterSetEmployeeAsRecipient

Integration event raised after setting an employee as the payment recipient. Enables custom processing after employee recipient configuration.

[IntegrationEvent(True,False)]
local procedure OnAfterSetEmployeeAsRecipient(Employee: Record Employee)

Parameters

Name	Type	Description
Employee	Table Microsoft.HumanResources.Employee.Employee	Employee record configured as recipient

OnAfterSetVendorAsRecipient

Integration event raised after setting a vendor as the payment recipient. Enables custom modifications to vendor recipient data for payment export.

[IntegrationEvent(False,False)]
local procedure OnAfterSetVendorAsRecipient(var PaymentExportData: Record "Payment Export Data", var Vendor: Record Vendor, var VendorBankAccount: Record "Vendor Bank Account")

Parameters

Name	Type	Description
PaymentExportData	Table Microsoft.Bank.Payment."Payment Export Data"	Payment export data being updated
Vendor	Table Microsoft.Purchases.Vendor.Vendor	Vendor record configured as recipient
VendorBankAccount	Table Microsoft.Purchases.Vendor."Vendor Bank Account"	Vendor bank account for payment

OnAfterSetBankAsRecipient

Integration event raised after setting a bank account as the payment recipient. Enables custom modifications to bank recipient data for payment export.

[IntegrationEvent(True,False)]
local procedure OnAfterSetBankAsRecipient(var PaymentExportData: Record "Payment Export Data", var BankAccount: Record "Bank Account")

Parameters

Name	Type	Description
PaymentExportData	Table Microsoft.Bank.Payment."Payment Export Data"	Payment export data being updated
BankAccount	Table Microsoft.Bank.BankAccount."Bank Account"	Bank account configured as recipient

See also

• Table