Table 1900 Cancelled Document

Base Application, Microsoft.Utilities

src/Layers/W1/BaseApp/Utilities/CancelledDocument.Table.al158 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.Utilities;using Microsoft.Purchases.History;using Microsoft.Sales.History;table 1900 "Cancelled Document"{    Caption = 'Cancelled Document';    Permissions = TableData "Cancelled Document" = rimd;    DataClassification = CustomerContent;    fields    {        field(1; "Source ID"; Integer)        {            Caption = 'Source ID';        }        field(2; "Cancelled Doc. No."; Code[20])        {            Caption = 'Cancelled Doc. No.';            TableRelation = if ("Source ID" = const(112)) "Sales Invoice Header"."No."            else            if ("Source ID" = const(122)) "Purch. Inv. Header"."No."            else            if ("Source ID" = const(114)) "Sales Cr.Memo Header"."No."            else            if ("Source ID" = const(124)) "Purch. Cr. Memo Hdr."."No.";        }        field(3; "Cancelled By Doc. No."; Code[20])        {            Caption = 'Cancelled By Doc. No.';            TableRelation = if ("Source ID" = const(114)) "Sales Invoice Header"."No."            else            if ("Source ID" = const(124)) "Purch. Inv. Header"."No."            else            if ("Source ID" = const(112)) "Sales Cr.Memo Header"."No."            else            if ("Source ID" = const(122)) "Purch. Cr. Memo Hdr."."No.";        }    }    keys    {        key(Key1; "Source ID", "Cancelled Doc. No.")        {            Clustered = true;        }        key(Key2; "Cancelled By Doc. No.")        {        }    }    fieldgroups    {    }    procedure InsertSalesInvToCrMemoCancelledDocument(InvNo: Code[20]; CrMemoNo: Code[20])    begin        InsertEntry(DATABASE::"Sales Invoice Header", InvNo, CrMemoNo);    end;    procedure InsertSalesCrMemoToInvCancelledDocument(CrMemoNo: Code[20]; InvNo: Code[20])    begin        InsertEntry(DATABASE::"Sales Cr.Memo Header", CrMemoNo, InvNo);        RemoveSalesInvCancelledDocument();    end;    procedure InsertPurchInvToCrMemoCancelledDocument(InvNo: Code[20]; CrMemoNo: Code[20])    begin        InsertEntry(DATABASE::"Purch. Inv. Header", InvNo, CrMemoNo);    end;    procedure InsertPurchCrMemoToInvCancelledDocument(CrMemoNo: Code[20]; InvNo: Code[20])    begin        InsertEntry(DATABASE::"Purch. Cr. Memo Hdr.", CrMemoNo, InvNo);        RemovePurchInvCancelledDocument();    end;    local procedure InsertEntry(SourceID: Integer; CanceledDocNo: Code[20]; CanceledByDocNo: Code[20])    begin        Init();        Validate("Source ID", SourceID);        Validate("Cancelled Doc. No.", CanceledDocNo);        Validate("Cancelled By Doc. No.", CanceledByDocNo);        Insert(true);    end;    local procedure RemoveSalesInvCancelledDocument()    begin        FindSalesCorrectiveCrMemo("Cancelled Doc. No.");        DeleteAll(true);    end;    local procedure RemovePurchInvCancelledDocument()    begin        FindPurchCorrectiveCrMemo("Cancelled Doc. No.");        DeleteAll(true);    end;    procedure FindSalesCancelledInvoice(CanceledDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledDocNo(DATABASE::"Sales Invoice Header", CanceledDocNo));    end;    procedure FindSalesCorrectiveInvoice(CanceledByDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledByDocNo(DATABASE::"Sales Cr.Memo Header", CanceledByDocNo));    end;    procedure FindPurchCancelledInvoice(CanceledDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledDocNo(DATABASE::"Purch. Inv. Header", CanceledDocNo));    end;    procedure FindPurchCorrectiveInvoice(CanceledByDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledByDocNo(DATABASE::"Purch. Cr. Memo Hdr.", CanceledByDocNo));    end;    procedure FindSalesCorrectiveCrMemo(CanceledByDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledByDocNo(DATABASE::"Sales Invoice Header", CanceledByDocNo));    end;    procedure FindSalesCancelledCrMemo(CanceledDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledDocNo(DATABASE::"Sales Cr.Memo Header", CanceledDocNo));    end;    procedure FindPurchCorrectiveCrMemo(CanceledByDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledByDocNo(DATABASE::"Purch. Inv. Header", CanceledByDocNo));    end;    procedure FindPurchCancelledCrMemo(CanceledDocNo: Code[20]): Boolean    begin        exit(FindWithCancelledDocNo(DATABASE::"Purch. Cr. Memo Hdr.", CanceledDocNo));    end;    local procedure FindWithCancelledDocNo(SourceID: Integer; CanceledDocNo: Code[20]): Boolean    begin        exit(Get(SourceID, CanceledDocNo));    end;    local procedure FindWithCancelledByDocNo(SourceID: Integer; CanceledByDocNo: Code[20]): Boolean    begin        Reset();        SetRange("Source ID", SourceID);        SetRange("Cancelled By Doc. No.", CanceledByDocNo);        exit(FindFirst());    end;}