Table 30143 Shpfy FulFillment Order Header

Shopify Connector, Microsoft.Integration.Shopify

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;}