Table 5936 Service Document Register

Base Application, Microsoft.Service.Document

src/Layers/W1/BaseApp/Service/Document/ServiceDocumentRegister.Table.al176 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.Service.Document;using Microsoft.Service.Contract;table 5936 "Service Document Register"{    Caption = 'Service Document Register';    DrillDownPageID = "Service Document Registers";    LookupPageID = "Service Document Registers";    DataClassification = CustomerContent;    fields    {        field(1; "Source Document Type"; Enum "Service Source Document Type")        {            Caption = 'Source Document Type';        }        field(2; "Source Document No."; Code[20])        {            Caption = 'Source Document No.';            ToolTip = 'Specifies the number of the service order or service contract.';        }        field(3; "Destination Document Type"; Enum "Service Destination Document Type")        {            Caption = 'Destination Document Type';            ToolTip = 'Specifies the type of document created from the service order or contract specified in the Source Document No.';        }        field(4; "Destination Document No."; Code[20])        {            Caption = 'Destination Document No.';            ToolTip = 'Specifies the number of the invoice or credit memo, based on the contents of the Destination Document Type field.';        }        field(32; "Invoice Period"; Enum "Service Contract Header Invoice Period")        {            Caption = 'Invoice Period';        }        field(33; "Last Invoice Date"; Date)        {            Caption = 'Last Invoice Date';        }        field(34; "Next Invoice Date"; Date)        {            Caption = 'Next Invoice Date';        }        field(98; "Next Invoice Period Start"; Date)        {            Caption = 'Next Invoice Period Start';        }        field(99; "Next Invoice Period End"; Date)        {            Caption = 'Next Invoice Period End';        }    }    keys    {        key(Key1; "Source Document Type", "Source Document No.", "Destination Document Type", "Destination Document No.")        {            Clustered = true;        }        key(Key2; "Destination Document Type", "Destination Document No.")        {        }    }    fieldgroups    {    }    procedure InsertServiceSalesDocument(ServDocType: Enum "Service Source Document Type"; ServDocNo: Code[20]; SalesDocType: Enum "Service Destination Document Type"; SalesDocNo: Code[20])    var        ServiceContractHeader: Record "Service Contract Header";        ServDocReg: Record "Service Document Register";    begin        if not Get(ServDocType, ServDocNo, SalesDocType, SalesDocNo) then begin            ServDocReg.Init();            ServDocReg."Source Document Type" := ServDocType;            ServDocReg."Source Document No." := ServDocNo;            ServDocReg."Destination Document Type" := SalesDocType;            ServDocReg."Destination Document No." := SalesDocNo;            if (ServDocType = ServDocType::Contract) and (SalesDocType = SalesDocType::Invoice) then begin                ServiceContractHeader.SetLoadFields("Invoice Period", "Last Invoice Date", "Next Invoice Date", "Next Invoice Period Start", "Next Invoice Period End");                if ServiceContractHeader.Get(ServiceContractHeader."Contract Type"::Contract, ServDocNo) then begin                    ServDocReg."Invoice Period" := ServiceContractHeader."Invoice Period";                    ServDocReg."Last Invoice Date" := ServiceContractHeader."Last Invoice Date";                    ServDocReg."Next Invoice Date" := ServiceContractHeader."Next Invoice Date";                    ServDocReg."Next Invoice Period Start" := ServiceContractHeader."Next Invoice Period Start";                    ServDocReg."Next Invoice Period End" := ServiceContractHeader."Next Invoice Period End";                end;            end;            if ServDocReg.Insert() then;        end;    end;    procedure PostServiceSalesDocument(SalesDocType: Enum "Service Destination Document Type"; SalesDocNo: Code[20]; InvoiceNo: Code[20])    var        ServDocReg: Record "Service Document Register";        PostedServDocReg: Record "Service Document Register";    begin        ServDocReg.Reset();        ServDocReg.SetCurrentKey("Destination Document Type", "Destination Document No.");        ServDocReg.SetRange("Destination Document Type", SalesDocType);        ServDocReg.SetRange("Destination Document No.", SalesDocNo);        if ServDocReg.Find('-') then            repeat                PostedServDocReg := ServDocReg;                case PostedServDocReg."Destination Document Type" of                    PostedServDocReg."Destination Document Type"::Invoice:                        PostedServDocReg."Destination Document Type" := PostedServDocReg."Destination Document Type"::"Posted Invoice";                    PostedServDocReg."Destination Document Type"::"Credit Memo":                        PostedServDocReg."Destination Document Type" := PostedServDocReg."Destination Document Type"::"Posted Credit Memo";                end;                PostedServDocReg."Destination Document No." := InvoiceNo;                PostedServDocReg.Insert();                ServDocReg.Delete();            until ServDocReg.Next() = 0;    end;    procedure ServiceDocument(SalesDocType: Option Quote,"Order",Invoice,"Credit Memo","Blanket Order"; SalesDocNo: Code[20]; var ServTable: Integer; var ServDocNo: Code[20]): Boolean    var        ServDocReg: Record "Service Document Register";    begin        ServTable := 0;        case SalesDocType of            SalesDocType::Invoice:                begin                    Clear(ServDocReg);                    ServDocReg.SetCurrentKey("Destination Document Type", "Destination Document No.");                    ServDocReg.SetRange("Destination Document Type", ServDocReg."Destination Document Type"::Invoice);                    ServDocReg.SetRange("Destination Document No.", SalesDocNo);                    if ServDocReg.FindFirst() then                        case ServDocReg."Source Document Type" of                            ServDocReg."Source Document Type"::Order:                                begin                                    ServTable := Database::"Service Header";                                    ServDocNo := ServDocReg."Source Document No.";                                end;                            ServDocReg."Source Document Type"::Contract:                                begin                                    ServTable := Database::"Service Contract Header";                                    ServDocNo := ServDocReg."Source Document No.";                                end;                        end;                end;            SalesDocType::"Credit Memo":                begin                    Clear(ServDocReg);                    ServDocReg.SetCurrentKey("Destination Document Type", "Destination Document No.");                    ServDocReg.SetRange("Destination Document Type", ServDocReg."Destination Document Type"::"Credit Memo");                    ServDocReg.SetRange("Destination Document No.", SalesDocNo);                    if ServDocReg.FindFirst() then                        case ServDocReg."Source Document Type" of                            ServDocReg."Source Document Type"::Order:                                begin                                    ServTable := Database::"Service Header";                                    ServDocNo := ServDocReg."Source Document No.";                                end;                            ServDocReg."Source Document Type"::Contract:                                begin                                    ServTable := Database::"Service Contract Header";                                    ServDocNo := ServDocReg."Source Document No.";                                end;                        end;                end;        end;        exit(ServTable <> 0)    end;}