Query 20401 Qlty. Inspection Values

Quality Management, Microsoft.QualityManagement.API

src/Apps/W1/Quality Management/app/src/API/QltyInspectionValues.Query.al113 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.QualityManagement.API;using Microsoft.QualityManagement.Document;/// <summary>/// Do not use this query outside of web services./// Power Automate friendly web service for quality inspections./// This web service is used to help list inspection values./// </summary>query 20401 "Qlty. Inspection Values"{    QueryType = API;    APIPublisher = 'microsoft';    APIGroup = 'qualityManagement';    APIVersion = 'v1.0';    EntityName = 'qualityInspectionValue';    EntityCaption = 'Quality Inspection Value';    EntitySetName = 'qualityInspectionValues';    EntitySetCaption = 'Quality Inspection Values';    DataAccessIntent = ReadOnly;    OrderBy = ascending(lineSystemModifiedAt);    elements    {        dataitem(QltyInspectionHeader; "Qlty. Inspection Header")        {            column(systemId; SystemId) { }            column(templateCode; "Template Code") { }            column(inspectionNo; "No.") { }            column(reinspectionNo; "Re-inspection No.") { }            column(inspectionStatus; Status)            {                Caption = 'inspectionStatus', Locked = true;            }            column(systemCreatedBy; SystemCreatedBy) { }            column(systemCreatedAt; SystemCreatedAt) { }            column(finishedByUserID; "Finished By User ID") { }            column(finishedAtDate; "Finished Date") { }            column(finishedAtDay; "Finished Date")            {                Method = Day;            }            column(finishedAtMonth; "Finished Date")            {                Method = Month;            }            column(finishedAtYear; "Finished Date")            {                Method = Year;            }            column(resultCode; "Result Code") { }            column(resultDescription; "Result Description") { }            column(sourceItemNo; "Source Item No.") { }            column(sourceVariantCode; "Source Variant Code") { }            column(sourceLotNo; "Source Lot No.") { }            column(sourceSerialNo; "Source Serial No.") { }            column(sourcePackageNo; "Source Package No.") { }            column(sourceDocumentNo; "Source Document No.") { }            column(sourceDocumentLineNo; "Source Document Line No.") { }            column(sourceTaskNo; "Source Task No.") { }            column(sourceQuantityBase; "Source Quantity (Base)") { }            column(sourceRecordTableNo; "Source Record Table No.") { }            column(sourceRecordId; "Source RecordId") { }            column(sourceRecordId2; "Source RecordId 2") { }            column(sourceRecordId3; "Source RecordId 3") { }            column(sourceCustom1; "Source Custom 1") { }            column(sourceCustom2; "Source Custom 2") { }            column(sourceCustom3; "Source Custom 3") { }            column(sourceCustom4; "Source Custom 4") { }            column(sourceCustom5; "Source Custom 5") { }            column(sourceCustom6; "Source Custom 6") { }            column(sourceCustom7; "Source Custom 7") { }            column(sourceCustom8; "Source Custom 8") { }            column(sourceCustom9; "Source Custom 9") { }            column(sourceCustom10; "Source Custom 10") { }            dataitem(QltyInspectionLine; "Qlty. Inspection Line")            {                DataItemLink = "Inspection No." = QltyInspectionHeader."No.", "Re-inspection No." = QltyInspectionHeader."Re-inspection No.";                column(lineSystemId; SystemId) { }                column(lineNo; "Line No.") { }                column(lineTestCode; "Test Code") { }                column(lineTestValueType; "Test Value Type")                {                    Caption = 'lineTestValueType', Locked = true;                }                column(lineResultCode; "Result Code") { }                column(lineDerivedNumericValue; "Derived Numeric Value") { }                column(lineTestValue; "Test Value") { }                column(lineSystemModifiedBy; SystemModifiedBy) { }                column(lineSystemModifiedAt; SystemModifiedAt) { }                column(lineSystemModifiedAtDay; SystemModifiedAt)                {                    Method = Day;                }                column(lineSystemModifiedAtMonth; SystemModifiedAt)                {                    Method = Month;                }                column(lineSystemModifiedAtYear; SystemModifiedAt)                {                    Method = Year;                }            }        }    }}