Table 30121 Shpfy Orders to Import
src/Apps/W1/Shopify/App/src/Order handling/Tables/ShpfyOrdersToImport.Table.al297 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 System.Reflection;table 30121 "Shpfy Orders to Import"{ Access = Internal; Caption = 'Shopify Orders to Import'; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { AutoIncrement = true; Caption = 'Entry No.'; DataClassification = SystemMetadata; Editable = false; } field(2; "Shop Id"; Integer) { Caption = 'Shop Id'; DataClassification = CustomerContent; Editable = false; } field(3; "Shop Code"; Code[20]) { Caption = 'Shop Code'; DataClassification = CustomerContent; TableRelation = "Shpfy Shop".Code where("Shop Id" = field("Shop Id")); } field(4; Id; BigInteger) { Caption = 'Id'; DataClassification = CustomerContent; Editable = false; } field(5; "Order No."; Text[50]) { Caption = 'Order No.'; DataClassification = CustomerContent; } field(6; "Created At"; DateTime) { Caption = 'Created At (Shopify)'; DataClassification = CustomerContent; Editable = false; } field(7; "Updated At"; DateTime) { Caption = 'Updated At (Shopify)'; DataClassification = CustomerContent; Editable = false; } field(8; Test; Boolean) { Caption = 'Test'; DataClassification = CustomerContent; Editable = false; } field(9; Confirmed; Boolean) { Caption = 'Confirmed'; DataClassification = CustomerContent; Editable = false; } field(10; "Fully Paid"; Boolean) { Caption = 'Fully Paid'; DataClassification = CustomerContent; Editable = false; } field(11; Unpaid; Boolean) { Caption = 'Unpaid'; DataClassification = CustomerContent; Editable = false; }#if not CLEANSCHEMA28 field(12; "Risk Level"; enum "Shpfy Risk Level") { Caption = 'Risk Level'; DataClassification = CustomerContent; Editable = false; ObsoleteReason = 'This field is not imported. Use field '; ObsoleteState = Removed; ObsoleteTag = '28.0'; }#endif field(13; "Financial Status"; enum "Shpfy Financial Status") { Caption = 'Financial Status'; DataClassification = CustomerContent; Editable = false; } field(14; "Fulfillment Status"; enum "Shpfy Order Fulfill. Status") { Caption = 'Fulfillment Status'; DataClassification = CustomerContent; Editable = false; } field(15; "Order Amount"; Decimal) { Caption = 'Order Amount'; DataClassification = CustomerContent; Editable = false; AutoFormatType = 1; AutoFormatExpression = "Currency Code"; } field(16; "Currency Code"; Code[10]) { Caption = 'Currency Code'; DataClassification = CustomerContent; Editable = false; } field(17; "Total Quantity of Items"; Integer) { Caption = 'Total Quantity of Items'; DataClassification = CustomerContent; Editable = false; } field(18; "Number of Order Lines"; Integer) { Caption = 'Number of Order Lines'; DataClassification = CustomerContent; Editable = false; } field(19; Tags; Text[2048]) { Caption = 'Tags'; DataClassification = CustomerContent; Editable = false; } field(20; "Attribute Key Filter"; Text[100]) { Caption = 'Attribute Key Filter'; FieldClass = FlowFilter; } field(21; "Attribute Key Exists"; Boolean) { Caption = 'Attribute Key Exists'; FieldClass = FlowField; CalcFormula = exist("Shpfy Order Attribute" where("Order Id" = field(Id), "Key" = field("Attribute Key Filter"))); } field(22; "Channel Name"; Text[100]) { Caption = 'Channel Name'; DataClassification = SystemMetadata; Editable = false; TableRelation = "Shpfy Sales Channel".Name where("Shop Code" = field("Shop Code")); ValidateTableRelation = false; } field(23; "Purchasing Entity"; Enum "Shpfy Order Purchasing Entity") { Caption = 'Purchasing Entity'; DataClassification = CustomerContent; Editable = false; } field(24; "High Risk"; Boolean) { Caption = 'High Risk'; DataClassification = SystemMetadata; Editable = false; } field(25; "Sell-to Country/Region Code"; Code[20]) { Caption = 'Sell-to Country/Region Code'; DataClassification = CustomerContent; } field(26; "Ship-to Country/Region Code"; Code[20]) { Caption = 'Ship-to Country/Region Code'; DataClassification = CustomerContent; } field(27; "Bill-to Country/Region Code"; Code[20]) { Caption = 'Bill-to Country/Region Code'; DataClassification = CustomerContent; } field(28; "VAT Amount"; Decimal) { Caption = 'VAT Amount'; DataClassification = SystemMetadata; AutoFormatType = 1; AutoFormatExpression = "Currency Code"; } field(29; "Presentment VAT Amount"; Decimal) { Caption = 'Presentment VAT Amount'; DataClassification = SystemMetadata; AutoFormatType = 1; AutoFormatExpression = "Currency Code"; } field(30; "Channel Liable Taxes"; Boolean) { Caption = 'Channel Liable Taxes'; DataClassification = SystemMetadata; Editable = false; } field(100; "Import Action"; Enum "Shpfy Import Action") { Caption = 'Import Action'; DataClassification = CustomerContent; Editable = false; } field(102; "Has Error"; Boolean) { Caption = 'Has Error'; DataClassification = SystemMetadata; Editable = false; } field(103; "Error Message"; Blob) { Caption = 'Error Message'; DataClassification = SystemMetadata; } field(104; "Error Call Stack"; Blob) { Caption = 'Error Call Stack'; DataClassification = SystemMetadata; } } keys { key(PK; "Entry No.") { Clustered = true; } key(Idx1; Id, "Shop Id") { } } /// <summary> /// Description for SetErrorMessage. /// </summary> internal procedure SetErrorInfo() var OutStream: OutStream; begin Clear("Error Message"); "Error Message".CreateOutStream(OutStream, TextEncoding::UTF8); OutStream.WriteText(GetLastErrorText); Clear("Error Call Stack"); "Error Call Stack".CreateOutStream(OutStream, TextEncoding::UTF8); OutStream.WriteText(GetLastErrorCallStack); "Has Error" := true; end; /// <summary> /// Description for GetErrorMessage. /// </summary> /// <returns>Return variable "Text".</returns> internal procedure GetErrorMessage(): Text var TypeHelper: Codeunit "Type Helper"; InStream: InStream; begin CalcFields("Error Message"); "Error Message".CreateInStream(InStream, TextEncoding::UTF8); exit(TypeHelper.ReadAsTextWithSeparator(InStream, TypeHelper.LFSeparator())); end; /// <summary> /// Description for GetErrorCallStack. /// </summary> /// <returns>Return variable "Text".</returns> internal procedure GetErrorCallStack(): Text var TypeHelper: Codeunit "Type Helper"; InStream: InStream; begin CalcFields("Error Call Stack"); "Error Call Stack".CreateInStream(InStream, TextEncoding::UTF8); exit(TypeHelper.ReadAsTextWithSeparator(InStream, TypeHelper.LFSeparator())); end;}