Table 5936 Service Document Register
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;}