Table 30110 Shpfy Gift Card
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; } }}