Table 30154 Shpfy Suggest Payment

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Transactions/Tables/ShpfySuggestPayment.Table.al104 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.Finance.Currency;using Microsoft.Sales.Customer;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;/// <summary>/// Table Shpfy Suggest Payment (ID 30154)./// </summary>table 30154 "Shpfy Suggest Payment"{    Access = Internal;    Caption = 'Shopify Suggest Payment';    DataClassification = CustomerContent;    TableType = Temporary;    fields    {        field(1; "Entry No."; Integer)        {            DataClassification = SystemMetadata;        }        field(2; "Shop Code"; Code[20])        {            DataClassification = SystemMetadata;            TableRelation = "Shpfy Shop";        }        field(3; "Shpfy Transaction Id"; BigInteger)        {            DataClassification = SystemMetadata;            TableRelation = "Shpfy Order Transaction";        }        field(4; "Customer Ledger Entry No."; Integer)        {            DataClassification = SystemMetadata;            TableRelation = "Cust. Ledger Entry";        }        field(5; "Customer No."; Code[20])        {            DataClassification = SystemMetadata;            TableRelation = Customer;        }        field(6; "Invoice No."; Code[20])        {            DataClassification = SystemMetadata;            TableRelation = "Sales Invoice Header";        }        field(7; "Amount"; Decimal)        {            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = "Currency Code";        }        field(8; "Currency Code"; Code[10])        {            DataClassification = SystemMetadata;            TableRelation = Currency;        }        field(9; "Gateway"; Text[30])        {            DataClassification = CustomerContent;        }        field(10; "Cust. Ledger Entry Dim. Set Id"; Integer)        {            DataClassification = SystemMetadata;        }        field(11; "Shpfy Order No."; Text[50])        {            FieldClass = FlowField;            CalcFormula = lookup("Shpfy Order Header"."Shopify Order No." where("Shopify Order Id" = field("Shpfy Order Id")));        }        field(12; "Shpfy Gift Card Id"; BigInteger)        {            DataClassification = SystemMetadata;        }        field(13; "Payment Method Code"; Code[10])        {            DataClassification = SystemMetadata;        }        field(14; "Shpfy Order Id"; BigInteger)        {            DataClassification = SystemMetadata;        }        field(15; "Credit Memo No."; Code[20])        {            DataClassification = SystemMetadata;            TableRelation = "Sales Cr.Memo Header";        }    }    keys    {        key(PK; "Entry No.")        {            Clustered = true;        }    }}