Table 7344 Registered Invt. Movement Hdr.
src/Layers/W1/BaseApp/Warehouse/InventoryDocument/RegisteredInvtMovementHdr.Table.al194 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.Warehouse.InventoryDocument;using Microsoft.Assembly.Document;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Transfer;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Warehouse.Activity;using Microsoft.Warehouse.Comment;using Microsoft.Warehouse.Request;using Microsoft.Warehouse.Setup;table 7344 "Registered Invt. Movement Hdr."{ Caption = 'Registered Invt. Movement Hdr.'; LookupPageID = "Registered Invt. Movement List"; DataClassification = CustomerContent; fields { field(2; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; } field(3; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the same as the field with the same name in the Registered Whse. Activity Hdr. table.'; NotBlank = true; TableRelation = Location.Code; } field(4; "Assigned User ID"; Code[50]) { Caption = 'Assigned User ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = "Warehouse Employee" where("Location Code" = field("Location Code")); } field(5; "Assignment Date"; Date) { Caption = 'Assignment Date'; } field(6; "Assignment Time"; Time) { Caption = 'Assignment Time'; } field(8; "Registering Date"; Date) { Caption = 'Registering Date'; } field(9; "No. Series"; Code[20]) { Caption = 'No. Series'; Editable = false; TableRelation = "No. Series".Code; } field(10; Comment; Boolean) { CalcFormula = exist("Warehouse Comment Line" where("Table Name" = const("Registered Invt. Movement"), Type = const(" "), "No." = field("No."))); Caption = 'Comment'; Editable = false; FieldClass = FlowField; } field(11; "Invt. Movement No."; Code[20]) { Caption = 'Invt. Movement No.'; ToolTip = 'Specifies the number of the inventory movement from which the activity was registered.'; } field(12; "No. Printed"; Integer) { Caption = 'No. Printed'; Editable = false; } field(20; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the same as the field with the same name in the Registered Whse. Activity Hdr. table.'; } field(7306; "Source No."; Code[20]) { Caption = 'Source No.'; ToolTip = 'Specifies the number of the source document that the entry originates from.'; TableRelation = if ("Source Type" = const(120)) "Purch. Rcpt. Header" where("No." = field("Source No.")) else if ("Source Type" = const(110)) "Sales Shipment Header" where("No." = field("Source No.")) else if ("Source Type" = const(6650)) "Return Shipment Header" where("No." = field("Source No.")) else if ("Source Type" = const(6660)) "Return Receipt Header" where("No." = field("Source No.")) else if ("Source Type" = const(5744)) "Transfer Shipment Header" where("No." = field("Source No.")) else if ("Source Type" = const(5746)) "Transfer Receipt Header" where("No." = field("Source No.")) else if ("Source Type" = const(900)) "Assembly Header"."No." where("Document Type" = const(Order), "No." = field("Source No.")); } field(7307; "Source Document"; Enum "Warehouse Activity Source Document") { BlankZero = true; Caption = 'Source Document'; ToolTip = 'Specifies the type of document that the line relates to.'; } field(7308; "Source Type"; Integer) { Caption = 'Source Type'; } field(7309; "Source Subtype"; Option) { Caption = 'Source Subtype'; Editable = false; OptionCaption = '0,1,2,3,4,5,6,7,8,9,10'; OptionMembers = "0","1","2","3","4","5","6","7","8","9","10"; } field(7310; "Destination Type"; enum "Warehouse Destination Type") { Caption = 'Destination Type'; } field(7311; "Destination No."; Code[20]) { Caption = 'Destination No.'; ToolTip = 'Specifies the same as the field with the same name in the Registered Whse. Activity Hdr. table.'; TableRelation = if ("Destination Type" = const(Vendor)) Vendor else if ("Destination Type" = const(Customer)) Customer else if ("Destination Type" = const(Location)) Location else if ("Destination Type" = const(Item)) Item else if ("Destination Type" = const("Sales Order")) "Sales Header"."No." where("Document Type" = const(Order)); } field(7312; "External Document No."; Code[35]) { Caption = 'External Document No.'; ToolTip = 'Specifies a document number that refers to the customer''s or vendor''s numbering system.'; } field(7314; "Shipment Date"; Date) { Caption = 'Shipment Date'; ToolTip = 'Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time.'; } field(7315; "External Document No.2"; Code[35]) { Caption = 'External Document No.2'; ToolTip = 'Specifies an additional part of the document number that refers to the customer''s or vendor''s numbering system.'; } } keys { key(Key1; "No.") { Clustered = true; } key(Key2; "Invt. Movement No.") { } key(Key3; "Location Code") { } } fieldgroups { } trigger OnDelete() var WarehouseCommentLine: Record "Warehouse Comment Line"; RegisteredInvtMovementLine: Record "Registered Invt. Movement Line"; begin RegisteredInvtMovementLine.SetRange("No.", "No."); RegisteredInvtMovementLine.DeleteAll(false); WarehouseCommentLine.SetRange("Table Name", WarehouseCommentLine."Table Name"::"Registered Invt. Movement"); WarehouseCommentLine.SetRange(Type, WarehouseCommentLine.Type::" "); WarehouseCommentLine.SetRange("No.", "No."); WarehouseCommentLine.DeleteAll(false); end;}