Table 30110 Shpfy Gift Card

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Gift Cards/Tables/ShpfyGiftCard.Table.al59 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;/// <summary>/// Table Shpfy Gift Card (ID 30110)./// </summary>table 30110 "Shpfy Gift Card"{    Access = Internal;    Caption = 'Shopify Gift Card';    DataClassification = SystemMetadata;    fields    {        field(1; Id; BigInteger)        {            Caption = 'Id';            DataClassification = SystemMetadata;        }        field(2; "Last Characters"; Text[4])        {            Caption = 'Last Characters';            DataClassification = SystemMetadata;        }        field(3; Amount; Decimal)        {            Caption = 'Amount';            DataClassification = SystemMetadata;            AutoFormatType = 1;            AutoFormatExpression = '';        }        field(4; "Order Line Id"; BigInteger)        {            Caption = 'Order Line Id';            DataClassification = SystemMetadata;        }        field(101; "Known Used Amount"; Decimal)        {            CalcFormula = sum("Shpfy Order Transaction".Amount where("Gift Card Id" = field(Id)));            Caption = 'Known Used Amount';            FieldClass = FlowField;            AutoFormatType = 1;            AutoFormatExpression = '';        }    }    keys    {        key(PK; Id)        {            Clustered = true;        }    }}