Query 135 OCR Vendor Bank Accounts
- App
- Base Application
- Namespace
- Microsoft.EServices.EDocument
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/eServices/EDocument/OCRVendorBankAccounts.Query.al50 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.EServices.EDocument;
using Microsoft.Purchases.Vendor;
query 135 "OCR Vendor Bank Accounts"
{
Caption = 'OCR Vendor Bank Accounts';
elements
{
dataitem(Vendor_Bank_Account; "Vendor Bank Account")
{
column(Name; Name)
{
}
column(Bank_Branch_No; "Bank Branch No.")
{
}
column(Bank_Account_No; "Bank Account No.")
{
}
column(SWIFT_Code; "SWIFT Code")
{
}
column(IBAN; IBAN)
{
}
dataitem(Vendor; Vendor)
{
DataItemLink = "No." = Vendor_Bank_Account."Vendor No.";
SqlJoinType = InnerJoin;
column(Id; SystemId)
{
}
column(No; "No.")
{
}
column(ModifiedAt; SystemModifiedAt)
{
}
}
}
}
}