Table 30133 Shpfy Order Transaction
src/Apps/W1/Shopify/App/src/Transactions/Tables/ShpfyOrderTransaction.Table.al321 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.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;/// <summary>/// Table Shpfy Order Transaction (ID 30133)./// </summary>table 30133 "Shpfy Order Transaction"{ Caption = 'Shopify Order Transaction'; DataClassification = SystemMetadata; LookupPageID = "Shpfy Order Transactions"; fields { field(1; "Shopify Transaction Id"; BigInteger) { Caption = 'Shopify Transaction Id'; DataClassification = SystemMetadata; Editable = false; } field(2; "Shopify Order Id"; BigInteger) { Caption = 'Shopify Order Id'; DataClassification = SystemMetadata; Editable = false; } field(3; Amount; Decimal) { Caption = 'Amount'; DataClassification = SystemMetadata; Editable = false; AutoFormatType = 1; AutoFormatExpression = Currency; } field(4; Type; Enum "Shpfy Transaction Type") { Caption = 'Type'; DataClassification = SystemMetadata; Editable = false; } field(5; Gateway; Text[30]) { Caption = 'Gateway'; DataClassification = SystemMetadata; Editable = false; } field(6; Status; Enum "Shpfy Transaction Status") { Caption = 'Status'; DataClassification = SystemMetadata; Editable = false; } field(7; "Message"; Text[250]) { Caption = 'Message'; DataClassification = SystemMetadata; Editable = false; } field(8; "Created At"; DateTime) { Caption = 'Created At (Shopify)'; DataClassification = SystemMetadata; Editable = false; } field(9; Test; Boolean) { Caption = 'Test'; DataClassification = SystemMetadata; Editable = false; } field(10; Authorization; Code[50]) { Caption = 'Authorization'; DataClassification = SystemMetadata; Editable = false; } field(11; Currency; Code[20]) { Caption = 'Currency'; DataClassification = SystemMetadata; Editable = false; } field(12; "Presentment Currency"; Code[20]) { Caption = 'Presentment Currency'; ToolTip = 'Specifies the currency of the transaction in the presentment currency.'; DataClassification = SystemMetadata; Editable = false; } field(13; "Presentment Amount"; Decimal) { Caption = 'Presentment Amount'; DataClassification = SystemMetadata; Editable = false; ToolTip = 'Specifies the amount of money included in the transaction in the presentment currency.'; AutoFormatType = 1; AutoFormatExpression = "Presentment Currency"; } field(14; "Gift Card Id"; BigInteger) { Caption = 'Gift Card Id'; DataClassification = SystemMetadata; Editable = false; }#if not CLEANSCHEMA28 field(15; "Source Name"; Code[20]) { Caption = 'Source Name'; DataClassification = SystemMetadata; Editable = false; Access = Internal; ObsoleteReason = 'Source name is no longer used.'; ObsoleteState = Removed; ObsoleteTag = '28.0'; }#endif field(16; "Credit Card Bin"; Code[10]) { Caption = 'Credit Card Bin'; DataClassification = SystemMetadata; Editable = false; Access = Internal; } field(17; "AVS Result Code"; Code[1]) { Caption = 'AVS Result Code'; //http://www.emsecommerce.net/avs_cvv2_response_codes.htm DataClassification = SystemMetadata; Editable = false; Access = Internal; } field(18; "CVV Result Code"; Code[1]) { Caption = 'CVV Result Code'; //http://www.emsecommerce.net/avs_cvv2_response_codes.htm DataClassification = SystemMetadata; Editable = false; Access = Internal; } field(19; "Credit Card Number"; Text[30]) { Caption = 'Credit Card Number'; DataClassification = SystemMetadata; Editable = false; Access = Internal; } field(20; "Credit Card Company"; Text[50]) { Caption = 'Credit Card company'; DataClassification = SystemMetadata; Editable = false; } field(21; "Parent Id"; BigInteger) { Caption = 'Parent Id'; DataClassification = SystemMetadata; Editable = false; TableRelation = "Shpfy Order Transaction"; } field(22; "Error Code"; Text[30]) { Caption = 'Error Code'; DataClassification = SystemMetadata; Editable = false; } field(23; "Payment Id"; Text[250]) { Caption = 'Payment Id'; DataClassification = CustomerContent; Editable = false; } field(24; "Rounding Amount"; Decimal) { Caption = 'Rounding Amount'; DataClassification = SystemMetadata; Editable = false; AutoFormatType = 1; AutoFormatExpression = Currency; } field(25; "Rounding Currency"; Code[20]) { Caption = 'Rounding Currency'; DataClassification = SystemMetadata; Editable = false; } field(26; "Refund Id"; BigInteger) { Caption = 'Refund Id'; DataClassification = SystemMetadata; Editable = false; } field(27; "Presentment Rounding Amount"; Decimal) { Caption = 'Presentment Rounding Amount'; DataClassification = SystemMetadata; Editable = false; AutoFormatType = 1; AutoFormatExpression = "Presentment Rounding Currency"; } field(28; "Presentment Rounding Currency"; Code[20]) { Caption = 'Presentment Rounding Currency'; DataClassification = SystemMetadata; Editable = false; } field(101; "Sales Document No."; code[20]) { Caption = 'Sales Document No.'; FieldClass = FlowField; CalcFormula = lookup("Sales Header"."No." where("Shpfy Order Id" = field("Shopify Order Id"))); } field(102; "Posted Invoice No."; Code[20]) { Caption = 'Posted Invoice No.'; FieldClass = FlowField; CalcFormula = lookup("Sales Invoice Header"."No." where("Shpfy Order Id" = field("Shopify Order Id"))); }#if not CLEANSCHEMA31 field(103; "Shop Code"; Code[20]) { Caption = 'Shop Code'; FieldClass = FlowField; CalcFormula = lookup("Shpfy Order Header"."Shop Code" where("Shopify Order Id" = field("Shopify Order Id"))); ObsoleteReason = 'Use field Shop instead.';#if CLEAN28 ObsoleteState = Removed; ObsoleteTag = '31.0';#else ObsoleteState = Pending; ObsoleteTag = '28.0';#endif }#endif field(104; "Payment Method"; Code[10]) { Caption = 'Payment Method'; FieldClass = FlowField; CalcFormula = lookup("Shpfy Payment Method Mapping"."Payment Method Code" where("Shop Code" = field("Shop"), Gateway = field(Gateway), "Credit Card Company" = field("Credit Card Company"))); }#if not CLEANSCHEMA28 field(105; "Payment Priority"; Integer) { Caption = 'Payment Priority'; FieldClass = FlowField; CalcFormula = lookup("Shpfy Payment Method Mapping".Priority where("Shop Code" = field("Shop"), Gateway = field(Gateway), "Credit Card Company" = field("Credit Card Company"))); ObsoleteReason = 'Priority is no longer used.'; ObsoleteState = Removed; ObsoleteTag = '28.0'; }#endif field(106; Used; Boolean) { Caption = 'Used'; FieldClass = FlowField; CalcFormula = exist("Cust. Ledger Entry" where("Shpfy Transaction Id" = field("Shopify Transaction Id"))); } field(107; "Manual Payment Gateway"; Boolean) { Caption = 'Manual Payment Gateway'; Editable = false; } field(108; Shop; Code[20]) { Caption = 'Shop Code'; TableRelation = "Shpfy Shop"; } field(109; "Shpfy 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"))); } } keys { key(Key1; "Shopify Transaction Id") { Clustered = true; } key(Idx001; "Gift Card Id") { SumIndexFields = Amount; } key(Idx002; "Created At") { } key(Idx003; Type) { } key(Key5; "Shopify Order Id", Status) { } key(Key6; "Refund Id", Type, Status) { } } fieldgroups { } trigger OnDelete() var DataCapture: Record "Shpfy Data Capture"; begin DataCapture.SetCurrentKey("Linked To Table", "Linked To Id"); DataCapture.SetRange("Linked To Table", Database::"Shpfy Order Transaction"); DataCapture.SetRange("Linked To Id", Rec.SystemId); if not DataCapture.IsEmpty() then DataCapture.DeleteAll(false); end;}