Table 6515 Package No. Information

Base Application, Microsoft.Inventory.Tracking

src/Layers/W1/BaseApp/Inventory/Tracking/PackageNoInformation.Table.al206 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.Inventory.Tracking;using Microsoft.Foundation.Address;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Structure;using Microsoft.Warehouse.Tracking;table 6515 "Package No. Information"{    Caption = 'Package No. Information';    DataCaptionFields = "Item No.", "Variant Code", "Package No.", Description;    DrillDownPageID = "Package No. Information List";    LookupPageID = "Package No. Information List";    DataClassification = CustomerContent;    fields    {        field(1; "Item No."; Code[20])        {            Caption = 'Item No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';            NotBlank = true;            TableRelation = Item;        }        field(2; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            ToolTip = 'Specifies the variant of the item on the line.';            TableRelation = "Item Variant".Code where("Item No." = field("Item No."));        }        field(3; "Package No."; Code[50])        {            Caption = 'Package No.';            ToolTip = 'Specifies the customs declaration number.';            CaptionClass = '6,1';            ExtendedDatatype = Barcode;            NotBlank = true;        }        field(5; "Country/Region Code"; Code[10])        {            Caption = 'Country/Region Code';            ToolTip = 'Specifies the country/region of the address.';            TableRelation = "Country/Region";        }        field(10; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description associated with this line.';        }        field(12; "Certificate Number"; Code[20])        {            Caption = 'Certificate Number';        }        field(13; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.';        }        field(14; Comment; Boolean)        {            CalcFormula = exist("Item Tracking Comment" where("Item No." = field("Item No."),                                                               "Variant Code" = field("Variant Code"),                                                               "Serial/Lot No." = field("Package No.")));            Caption = 'Comment';            ToolTip = 'Specifies the comment associated with this line.';            Editable = false;            FieldClass = FlowField;        }        field(20; Inventory; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Item Ledger Entry".Quantity where("Item No." = field("Item No."),                                                                  "Variant Code" = field("Variant Code"),                                                                  "Package No." = field("Package No."),                                                                  "Location Code" = field("Location Filter")));            Caption = 'Inventory';            ToolTip = 'Specifies the quantity on inventory with this line.';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;        }        field(21; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(22; "Location Filter"; Code[10])        {            Caption = 'Location Filter';            FieldClass = FlowFilter;            TableRelation = Location;        }        field(23; "Bin Filter"; Code[20])        {            Caption = 'Bin Filter';            FieldClass = FlowFilter;            TableRelation = Bin.Code where("Location Code" = field("Location Filter"));        }        field(24; "Expired Inventory"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Item Ledger Entry"."Remaining Quantity" where("Item No." = field("Item No."),                                                                              "Variant Code" = field("Variant Code"),                                                                              "Package No." = field("Package No."),                                                                              "Location Code" = field("Location Filter"),                                                                              "Expiration Date" = field("Date Filter"),                                                                              Open = const(true),                                                                              Positive = const(true)));            Caption = 'Expired Inventory';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "Item No.", "Variant Code", "Package No.")        {            Clustered = true;        }        key(Key2; "Package No.")        {            Enabled = false;        }    }    fieldgroups    {        fieldgroup(DropDown; "Item No.", "Variant Code", "Package No.")        {        }    }    trigger OnDelete()    begin        ItemTrackingComment.SetRange(Type, ItemTrackingComment.Type::"Package No.");        ItemTrackingComment.SetRange("Item No.", "Item No.");        ItemTrackingComment.SetRange("Variant Code", "Variant Code");        ItemTrackingComment.SetRange("Serial/Lot No.", "Package No.");        ItemTrackingComment.DeleteAll();    end;    var        ItemTrackingComment: Record "Item Tracking Comment";    procedure GetCountryName(): Text[50]    var        Country: Record "Country/Region";    begin        if not Country.Get("Country/Region Code") then            exit('');        exit(Country.Name);    end;    procedure GetCountryLocalCode(): Code[10]    var        Country: Record "Country/Region";    begin        if not Country.Get("Country/Region Code") then            exit('');        exit('');    end;    procedure ShowCard(PackageNo: Code[50]; TrackingSpecification: Record "Tracking Specification")    var        PackageNoInfoNew: Record "Package No. Information";        PackageNoInfoCard: Page "Package No. Information Card";    begin        Clear(PackageNoInfoCard);        PackageNoInfoCard.Init(TrackingSpecification);        PackageNoInfoNew.SetRange("Item No.", TrackingSpecification."Item No.");        PackageNoInfoNew.SetRange("Variant Code", TrackingSpecification."Variant Code");        PackageNoInfoNew.SetRange("Package No.", PackageNo);        PackageNoInfoCard.SetTableView(PackageNoInfoNew);        PackageNoInfoCard.Run();    end;    procedure ShowCard(PackageNo: Code[50]; WhseItemTrackingLine: Record "Whse. Item Tracking Line")    var        PackageNoInfoNew: Record "Package No. Information";        PackageNoInfoCard: Page "Package No. Information Card";    begin        Clear(PackageNoInfoCard);        PackageNoInfoCard.InitWhse(WhseItemTrackingLine);        PackageNoInfoNew.SetRange("Item No.", WhseItemTrackingLine."Item No.");        PackageNoInfoNew.SetRange("Variant Code", WhseItemTrackingLine."Variant Code");        PackageNoInfoNew.SetRange("Package No.", PackageNo);        PackageNoInfoCard.SetTableView(PackageNoInfoNew);        PackageNoInfoCard.Run();    end;}