Table 263 Intrastat Jnl. Line
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