Table 263 Intrastat Jnl. Line

Base Application, Microsoft.Inventory.Intrastat

src/Layers/W1/BaseApp/Inventory/Intrastat/IntrastatJnlLine.Table.al244 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEANSCHEMA25// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Inventory.Intrastat;using Microsoft.Foundation.Address;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;table 263 "Intrastat Jnl. Line"{    Caption = 'Intrastat Jnl. Line';    ObsoleteState = Removed;    ObsoleteTag = '25.0';    ObsoleteReason = 'Intrastat related functionalities are moved to Intrastat extensions.';    DataClassification = CustomerContent;    fields    {        field(1; "Journal Template Name"; Code[10])        {            Caption = 'Journal Template Name';        }        field(2; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(4; Type; Option)        {            Caption = 'Type';            OptionCaption = 'Receipt,Shipment';            OptionMembers = Receipt,Shipment;        }        field(5; Date; Date)        {            Caption = 'Date';        }        field(6; "Tariff No."; Code[20])        {            Caption = 'Tariff No.';            NotBlank = true;        }        field(7; "Item Description"; Text[100])        {            Caption = 'Item Description';        }        field(8; "Country/Region Code"; Code[10])        {            Caption = 'Country/Region Code';            TableRelation = "Country/Region";        }        field(9; "Transaction Type"; Code[10])        {            Caption = 'Transaction Type';            TableRelation = "Transaction Type";        }        field(10; "Transport Method"; Code[10])        {            Caption = 'Transport Method';            TableRelation = "Transport Method";        }#if not CLEANSCHEMA29#pragma warning disable AS0105                field(11; "Source Type"; Enum "Intrastat Source Type")        {            BlankZero = true;            Caption = 'Source Type';            ObsoleteState = Removed;            ObsoleteTag = '29.0';            ObsoleteReason = 'Intrastat related functionalities are moved to Intrastat extensions.';        }#pragma warning restore AS0105   #endif        field(12; "Source Entry No."; Integer)        {            Caption = 'Source Entry No.';            Editable = false;        }        field(13; "Net Weight"; Decimal)        {            AutoFormatType = 0;            Caption = 'Net Weight';            DecimalPlaces = 2 : 5;            trigger OnValidate()            begin                if Quantity <> 0 then                    "Total Weight" := Round("Net Weight" * Quantity, 0.00001)                else                    "Total Weight" := 0;            end;        }        field(14; Amount; Decimal)        {            AutoFormatType = 0;            Caption = 'Amount';            DecimalPlaces = 0 : 0;            trigger OnValidate()            begin                if "Cost Regulation %" <> 0 then                    Validate("Cost Regulation %")                else                    "Statistical Value" := Amount + "Indirect Cost";            end;        }        field(15; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DecimalPlaces = 0 : 0;        }        field(16; "Cost Regulation %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Cost Regulation %';            DecimalPlaces = 2 : 2;            MaxValue = 100;            MinValue = -100;            trigger OnValidate()            begin                "Indirect Cost" := Round(Amount * "Cost Regulation %" / 100, 1);                "Statistical Value" := Round(Amount + "Indirect Cost", 1);            end;        }        field(17; "Indirect Cost"; Decimal)        {            AutoFormatType = 0;            Caption = 'Indirect Cost';            DecimalPlaces = 0 : 0;            trigger OnValidate()            begin                "Cost Regulation %" := 0;                "Statistical Value" := Amount + "Indirect Cost";            end;        }        field(18; "Statistical Value"; Decimal)        {            AutoFormatType = 0;            Caption = 'Statistical Value';            DecimalPlaces = 0 : 0;        }        field(19; "Document No."; Code[20])        {            Caption = 'Document No.';        }        field(20; "Item No."; Code[20])        {            Caption = 'Item No.';        }        field(21; Name; Text[100])        {            Caption = 'Name';        }        field(22; "Total Weight"; Decimal)        {            AutoFormatType = 0;            Caption = 'Total Weight';            DecimalPlaces = 0 : 0;            Editable = false;        }        field(23; "Supplementary Units"; Boolean)        {            Caption = 'Supplementary Units';            Editable = false;        }        field(24; "Internal Ref. No."; Text[10])        {            Caption = 'Internal Ref. No.';            Editable = false;        }        field(25; "Country/Region of Origin Code"; Code[10])        {            Caption = 'Country/Region of Origin Code';            TableRelation = "Country/Region";        }        field(26; "Entry/Exit Point"; Code[10])        {            Caption = 'Entry/Exit Point';            TableRelation = "Entry/Exit Point";        }        field(27; "Area"; Code[10])        {            Caption = 'Area';            TableRelation = Area;        }        field(28; "Transaction Specification"; Code[10])        {            Caption = 'Transaction Specification';            TableRelation = "Transaction Specification";        }        field(29; "Shpt. Method Code"; Code[10])        {            Caption = 'Shpt. Method Code';            TableRelation = "Shipment Method";        }        field(30; "Partner VAT ID"; Text[50])        {            Caption = 'Partner VAT ID';        }        field(31; "Location Code"; Code[10])        {            Caption = 'Location Code';            TableRelation = Location;        }        field(32; Counterparty; Boolean)        {            Caption = 'Counterparty';        }    }    keys    {        key(Key1; "Journal Template Name", "Journal Batch Name", "Line No.")        {            Clustered = true;        }        key(Key5; "Document No.")        {        }        key(Key6; "Journal Template Name", "Journal Batch Name", Type, "Internal Ref. No.")        {        }        key(Key7; "Journal Template Name", "Journal Batch Name", Type, "Country/Region Code", "Tariff No.", "Transaction Type", "Transport Method", "Country/Region of Origin Code", "Partner VAT ID")        {        }    }    fieldgroups    {    }}#endif