Table 5884 Pstd. Phys. Invt. Tracking

Base Application, Microsoft.Inventory.Counting.Tracking

src/Layers/W1/BaseApp/Inventory/Counting/Tracking/PstdPhysInvtTracking.Table.al125 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.Counting.Tracking;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Structure;table 5884 "Pstd. Phys. Invt. Tracking"{    Caption = 'Pstd. Phys. Invt. Tracking';    DrillDownPageID = "Posted Phys. Invt. Tracking";    LookupPageID = "Posted Phys. Invt. Tracking";    DataClassification = CustomerContent;    fields    {        field(1; "Item Tracking No."; Integer)        {            Caption = 'Item Tracking No.';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';        }        field(2; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(3; "Document No."; Code[20])        {            Caption = 'Document No.';            ToolTip = 'Specifies the appropriate field of the physical inventory tracking line.';        }        field(11; "Item No."; Code[20])        {            Caption = 'Item No.';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            Editable = false;            TableRelation = Item;        }        field(12; Description; Text[100])        {            Caption = 'Description';        }        field(13; "Location Code"; Code[10])        {            Caption = 'Location Code';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            Editable = false;            TableRelation = Location;        }        field(14; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            DecimalPlaces = 0 : 5;            InitValue = 1;        }        field(15; "Serial No."; Code[50])        {            Caption = 'Serial No.';            ToolTip = 'Specifies the serial number of the item that is being handled on the document line.';            TableRelation = "Serial No. Information"."Serial No." where("Item No." = field("Item No."),                                                                         "Variant Code" = field("Variant Code"));            ValidateTableRelation = false;        }        field(18; Positive; Boolean)        {            Caption = 'Positive';            Editable = false;        }        field(19; "Warranty Date"; Date)        {            Caption = 'Warranty Date';        }        field(20; "Expiration Date"; Date)        {            Caption = 'Expiration Date';        }        field(5400; "Lot No."; Code[50])        {            Caption = 'Lot No.';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            TableRelation = "Lot No. Information"."Lot No." where("Item No." = field("Item No."),                                                                   "Variant Code" = field("Variant Code"));            ValidateTableRelation = false;        }        field(5401; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            ToolTip = 'Specifies the variant of the item on the line.';            Editable = false;        }        field(5402; "Bin Code"; Code[20])        {            Caption = 'Bin Code';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            Editable = false;            TableRelation = Bin.Code where("Location Code" = field("Location Code"));        }        field(5403; "Entry Type"; Option)        {            Caption = 'Entry Type';            ToolTip = 'Specifies the value from the same field on the physical inventory tracking line.';            OptionCaption = ' ,Positive Adjmt.,Negative Adjmt.';            OptionMembers = " ","Positive Adjmt.","Negative Adjmt.";        }    }    keys    {        key(Key1; "Document No.", "Item Tracking No.", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }}