Table 30100 Shpfy Cue
src/Apps/W1/Shopify/App/src/Base/Tables/ShpfyCue.Table.al109 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.Integration.Shopify;using Microsoft.Sales.History;using System.Threading;/// <summary>/// Table Shpfy Cue (ID 30100)./// </summary>table 30100 "Shpfy Cue"{ Access = Internal; Caption = 'Shopify Cue'; DataClassification = SystemMetadata; fields { field(1; "Primary Key"; Code[10]) { Caption = 'Primary Key'; DataClassification = SystemMetadata; } field(2; "Unmapped Customers"; Integer) { CalcFormula = count("Shpfy Customer" where("Customer SystemId" = const('00000000-0000-0000-0000-000000000000'))); Caption = 'Unmapped Customers'; FieldClass = FlowField; } field(3; "Unmapped Products"; Integer) { CalcFormula = count("Shpfy Product" where("Item SystemId" = const('00000000-0000-0000-0000-000000000000'))); Caption = 'Unmapped Products'; FieldClass = FlowField; } field(4; "Unprocessed Orders"; Integer) { CalcFormula = count("Shpfy Order Header" where(Processed = const(false))); Caption = 'Unprocessed Orders'; FieldClass = FlowField; } field(5; "Unprocessed Shipments"; Integer) { CalcFormula = count("Sales Shipment Header" where("Shpfy Order Id" = filter(<> 0), "Shpfy Fulfillment Id" = filter(= 0))); Caption = 'Unprocessed Shipments'; FieldClass = FlowField; } field(6; "Synchronization Errors"; Integer) { CalcFormula = count("Job Queue Log Entry" where(Status = const(Error), "Object Type to Run" = const(Report), "Object ID to Run" = filter(Report::"Shpfy Sync Orders from Shopify" | Report::"Shpfy Sync Shipm. to Shopify" | Report::"Shpfy Sync Products" | Report::"Shpfy Sync Stock to Shopify" | Report::"Shpfy Sync Images" | Report::"Shpfy Sync Customers" | Report::"Shpfy Sync Payments" | Report::"Shpfy Sync Companies" | Report::"Shpfy Sync Catalogs" | Report::"Shpfy Sync Catalog Prices" | Report::"Shpfy Sync Invoices to Shpfy" | Report::"Shpfy Sync Disputes"))); Caption = 'Synchronization Errors'; FieldClass = FlowField; } field(7; "Shipment Errors"; Integer) { CalcFormula = count("Sales Shipment Header" where("Shpfy Order Id" = filter(<> 0), "Shpfy Fulfillment Id" = filter(= -1))); Caption = 'Shipments Errors'; FieldClass = FlowField; } field(8; "Unprocessed Order Updates"; Integer) { CalcFormula = count("Shpfy Order Header" where("Has Order State Error" = const(true))); Caption = 'Unprocessed Order Updates'; FieldClass = FlowField; } field(9; "Unmapped Companies"; Integer) { CalcFormula = count("Shpfy Company" where("Customer SystemId" = const('00000000-0000-0000-0000-000000000000'))); Caption = 'Unmapped Companies'; FieldClass = FlowField; } field(10; "Skipped Records"; Integer) { CalcFormula = count("Shpfy Skipped Record"); Caption = 'Skipped Records'; FieldClass = FlowField; } field(11; "API Errors"; Integer) { CalcFormula = count("Shpfy Log Entry" where("Has Error" = const(true))); Caption = 'API Errors'; FieldClass = FlowField; } } keys { key(PK; "Primary Key") { Clustered = true; } }}