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)
                {
                }
            }
        }
    }
}