Table 30143 Shpfy FulFillment Order Header
src/Apps/W1/Shopify/App/src/Order Fulfillments/Tables/ShpfyFulFillmentOrderHeader.Table.al96 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;table 30143 "Shpfy FulFillment Order Header"{ Caption = 'Fulfillment Order Header'; DataClassification = CustomerContent; LookupPageId = "Shpfy Fulfillment Orders"; DrillDownPageId = "Shpfy Fulfillment Order Card"; fields { field(1; "Shopify Fulfillment Order Id"; BigInteger) { DataClassification = SystemMetadata; } field(2; "Shopify Order Id"; BigInteger) { DataClassification = SystemMetadata; } field(3; Status; Text[50]) { DataClassification = CustomerContent; } field(4; "Shop Id"; Integer) { Caption = 'Shop Id'; DataClassification = CustomerContent; } field(5; "Shop Code"; Code[20]) { Caption = 'Shop Code'; DataClassification = CustomerContent; TableRelation = "Shpfy Shop".Code; } field(6; "Shopify Location Id"; BigInteger) { Caption = 'Shopify Location Id'; DataClassification = SystemMetadata; } field(7; "Updated At"; DateTime) { Caption = 'Updated At (Shopify)'; DataClassification = SystemMetadata; } field(8; "Shopify Order No."; Text[50]) { Caption = 'Shopify Order No.'; FieldClass = FlowField; CalcFormula = lookup("Shpfy Order Header"."Shopify Order No." where("Shopify Order Id" = field("Shopify Order Id"))); Editable = false; } field(9; "Delivery Method Type"; Enum "Shpfy Delivery Method Type") { Caption = 'Delivery Method Type'; DataClassification = SystemMetadata; Editable = false; } field(10; "Request Status"; Enum "Shpfy FF Request Status") { Caption = 'Request Status'; DataClassification = SystemMetadata; Editable = false; } } keys { key(PK; "Shopify Fulfillment Order Id") { Clustered = true; } key(Key2; "Shopify Order Id") { } } trigger OnDelete() var FulfillmentOrderLine: Record "Shpfy FulFillment Order Line"; DataCapture: Record "Shpfy Data Capture"; begin FulfillmentOrderLine.Reset(); FulfillmentOrderLine.SetRange("Shopify Fulfillment Order Id", Rec."Shopify Fulfillment Order Id"); FulfillmentOrderLine.DeleteAll(true); DataCapture.SetCurrentKey("Linked To Table", "Linked To Id"); DataCapture.SetRange("Linked To Table", Database::"Shpfy FulFillment Order Header"); DataCapture.SetRange("Linked To Id", Rec.SystemId); if not DataCapture.IsEmpty then DataCapture.DeleteAll(false); end;}