Table 30122 Shpfy Order Tax Line

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Order handling/Tables/ShpfyOrderTaxLine.Table.al168 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 Order Tax Line (ID 30122)./// </summary>table 30122 "Shpfy Order Tax Line"{    Access = Internal;    Caption = 'Shopify Order Tax Line';    DataClassification = CustomerContent;    fields    {        field(1; "Parent Id"; BigInteger)        {            Caption = 'Parent Id';            DataClassification = SystemMetadata;            Editable = false;        }        field(2; "Line No."; Integer)        {            Caption = 'Line No.';            DataClassification = SystemMetadata;            Editable = false;        }#pragma warning disable AS0086 // false positive on extending the field length on internal table        field(3; Title; Code[100])#pragma warning restore AS0086        {            Caption = 'Title';            DataClassification = SystemMetadata;            Editable = false;        }        field(4; Rate; Decimal)        {            Caption = 'Rate';            DataClassification = SystemMetadata;            Editable = false;            AutoFormatType = 0;        }        field(5; Amount; Decimal)        {            Caption = 'Amount';            DataClassification = SystemMetadata;            Editable = false;            AutoFormatType = 1;            AutoFormatExpression = OrderCurrencyCode();        }#if not CLEANSCHEMA25        field(6; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            DataClassification = SystemMetadata;            Editable = false;            ObsoleteState = Removed;            ObsoleteTag = '25.0';            ObsoleteReason = 'This information is available in Shopify Order Header table.';        }#endif        field(7; "Presentment Amount"; Decimal)        {            Caption = 'Presentment Amount';            DataClassification = SystemMetadata;            Editable = false;            AutoFormatType = 1;            AutoFormatExpression = OrderPresentmentCurrencyCode();        }        field(8; "Rate %"; Decimal)        {            Caption = 'Rate %';            DataClassification = SystemMetadata;            Editable = false;            AutoFormatType = 0;        }        field(9; "Channel Liable"; Boolean)        {            Caption = 'Channel Liable';            DataClassification = SystemMetadata;            Editable = false;        }    }    keys    {        key(PK; "Parent Id", "Line No.")        {            Clustered = true;        }    }    trigger OnInsert()    var        OrderTaxLine: Record "Shpfy Order Tax Line";    begin        if "Line No." = 0 then begin            OrderTaxLine.SetRange("Parent Id", "Parent Id");            if OrderTaxLine.FindLast() then                "Line No." := OrderTaxLine."Line No." + 1            else                "Line No." := 1;        end;    end;    internal procedure ImportFromJson(ParentId: BigInteger; JTaxLines: JsonArray)    var        OrderTaxLine: Record "Shpfy Order Tax Line";        JsonHelper: Codeunit "Shpfy Json Helper";        RecordRef: RecordRef;        JToken: JsonToken;    begin        OrderTaxLine.SetRange("Parent Id", ParentId);        if not OrderTaxLine.IsEmpty() then            OrderTaxLine.DeleteAll(false);        foreach JToken in JTaxLines do begin            RecordRef.Open(Database::"Shpfy Order Tax Line");            RecordRef.Init();            RecordRef.Field(OrderTaxLine.FieldNo("Parent Id")).Value := ParentId;            JsonHelper.GetValueIntoField(JToken, 'title', RecordRef, OrderTaxLine.FieldNo(Title));            JsonHelper.GetValueIntoField(JToken, 'rate', RecordRef, OrderTaxLine.FieldNo(Rate));            JsonHelper.GetValueIntoField(JToken, 'ratePercentage', RecordRef, OrderTaxLine.FieldNo("Rate %"));            JsonHelper.GetValueIntoField(JToken, 'priceSet.shopMoney.amount', RecordRef, OrderTaxLine.FieldNo(Amount));            JsonHelper.GetValueIntoField(JToken, 'priceSet.presentmentMoney.amount', RecordRef, OrderTaxLine.FieldNo("Presentment Amount"));            JsonHelper.GetValueIntoField(JToken, 'channelLiable', RecordRef, OrderTaxLine.FieldNo("Channel Liable"));            RecordRef.Insert(true);            RecordRef.Close();        end;    end;    local procedure OrderCurrencyCode(): Code[10]    var        OrderHeader: Record "Shpfy Order Header";        OrderLine: Record "Shpfy Order Line";        OrderShippingCharges: Record "Shpfy Order Shipping Charges";    begin        if OrderLine.Get("Parent Id") then begin            if OrderHeader.Get(OrderLine."Shopify Order Id") then                exit(OrderHeader."Currency Code");        end else            if OrderShippingCharges.Get("Parent Id") then begin                if OrderHeader.Get(OrderShippingCharges."Shopify Order Id") then                    exit(OrderHeader."Currency Code");            end else                if OrderHeader.Get("Parent Id") then                    exit(OrderHeader."Currency Code");    end;    local procedure OrderPresentmentCurrencyCode(): Code[10]    var        OrderHeader: Record "Shpfy Order Header";        OrderLine: Record "Shpfy Order Line";        OrderShippingCharges: Record "Shpfy Order Shipping Charges";    begin        if OrderLine.Get("Parent Id") then begin            if OrderHeader.Get(OrderLine."Shopify Order Id") then                exit(OrderHeader."Presentment Currency Code");        end else            if OrderShippingCharges.Get("Parent Id") then begin                if OrderHeader.Get(OrderShippingCharges."Shopify Order Id") then                    exit(OrderHeader."Presentment Currency Code");            end else                if OrderHeader.Get("Parent Id") then                    exit(OrderHeader."Presentment Currency Code");    end;}