Table 5818 Detailed Matched Order Line
src/Layers/W1/BaseApp/Inventory/Tracking/DetailedMatchedOrderLine.Table.al211 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.Purchases.Document;table 5818 "Detailed Matched Order Line"{ Caption = 'Detailed Matched Order Line'; DataClassification = CustomerContent; ReplicateData = false; TableType = Temporary; fields { field(1; "Line No."; Integer) { Editable = false; ToolTip = 'Specifies the line number of the invoice/credit memo line.'; } field(2; Type; Enum "Purchase Line Type") { Editable = false; ToolTip = 'Specifies the invoice/credit memo line type.'; } field(3; "No."; Code[20]) { Editable = false; ToolTip = 'Specifies the number of the involved entry or record.'; } field(4; Description; Text[100]) { Editable = false; ToolTip = 'Specifies a description of the entry of the product.'; } field(5; "Description 2"; Text[50]) { Editable = false; ToolTip = 'Specifies information in addition to the description.'; } field(6; Quantity; Decimal) { AutoFormatType = 0; BlankZero = true; DecimalPlaces = 0 : 5; Editable = false; ToolTip = 'Specifies the quantity from the matched order or receipt/shipment line.'; } field(7; "Qty. Rcd. Not Invoiced"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Quantity Received Not Invoiced'; DecimalPlaces = 0 : 5; Editable = false; ToolTip = 'Specifies the quantity received but not yet invoiced from the matched order or receipt/shipment line.'; } field(8; "Qty. to Invoice"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Quantity to Invoice'; DecimalPlaces = 0 : 5; ToolTip = 'Specifies the quantity to invoice from the matched order or receipt/shipment line.'; } field(9; "Qty. to Invoice (Base)"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Quantity to Invoice (Base)'; DecimalPlaces = 0 : 5; Editable = false; ToolTip = 'Specifies the base quantity to invoice from the matched order or receipt/shipment line.'; } field(10; "Qty. Invoiced"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Quantity Invoiced'; DecimalPlaces = 0 : 5; Editable = false; ToolTip = 'Specifies the quantity invoiced from the matched purchase order or receipt/shipment line.'; } field(11; "Qty. Invoiced (Base)"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Quantity Invoiced (Base)'; DecimalPlaces = 0 : 5; Editable = false; ToolTip = 'Specifies the base quantity invoiced from the matched purchase order or receipt/shipment line.'; } field(50; "Receipt on Invoice"; Boolean) { Caption = 'Receipt on Invoice'; Editable = false; ToolTip = 'Specifies whether the receipt is posted automatically with the invoice.'; } field(100; "Order No."; Code[20]) { Caption = 'Order No.'; Editable = false; ToolTip = 'Specifies the number of the order.'; } field(101; "Order Line No."; Integer) { BlankZero = true; Caption = 'Order Line No.'; Editable = false; ToolTip = 'Specifies the line number of the order.'; } field(200; "Receipt/Shipment No."; Code[20]) { Caption = 'Receipt/Shipment No.'; Editable = false; ToolTip = 'Specifies the number of the receipt or shipment.'; } field(201; "Receipt/Shipment Line No."; Integer) { BlankZero = true; Caption = 'Receipt/Shipment Line No.'; Editable = false; ToolTip = 'Specifies the line number of the receipt or shipment.'; } field(220; "Your Reference"; Text[35]) { Caption = 'Your Reference'; Editable = false; ToolTip = 'Specifies the vendor''s reference.'; } field(221; "Vendor Order No."; Code[35]) { Caption = 'Vendor Order No.'; ToolTip = 'Specifies the vendor''s order number.'; Editable = false; } field(222; "Vendor Shipment No."; Code[35]) { Caption = 'Vendor Shipment No.'; Editable = false; ToolTip = 'Specifies the vendor''s shipment number.'; } field(223; "Vendor Invoice No."; Code[35]) { Caption = 'Vendor Invoice No.'; Editable = false; ToolTip = 'Specifies the vendor''s invoice number.'; } field(224; "Vendor Cr. Memo No."; Code[35]) { Caption = 'Vendor Cr. Memo No.'; Editable = false; ToolTip = 'Specifies the vendor''s credit memo number.'; } field(1000; Indentation; Integer) { DataClassification = SystemMetadata; Editable = false; } field(1001; HasSubLines; Boolean) { DataClassification = SystemMetadata; Editable = false; } field(1002; "Line"; Text[250]) { Editable = false; } field(1003; "Document Line SystemId"; Guid) { DataClassification = SystemMetadata; Editable = false; } field(1004; "Matched Order Line SystemId"; Guid) { DataClassification = SystemMetadata; Editable = false; } field(1005; "Matched Rcpt./Shpt. Line SysId"; Guid) { DataClassification = SystemMetadata; Editable = false; } } keys { key(Key1; "Line No.", "Order No.", "Order Line No.", "Receipt/Shipment No.", "Receipt/Shipment Line No.") { Clustered = true; } } trigger OnDelete() var MatchedOrderLine: Record "Matched Order Line"; MatchedOrderLineMgmt: Codeunit "Matched Order Line Mgmt."; begin MatchedOrderLine.SetRange("Document Line SystemId", Rec."Document Line SystemId"); if not IsNullGuid(Rec."Matched Order Line SystemId") then MatchedOrderLine.SetRange("Matched Order Line SystemId", Rec."Matched Order Line SystemId"); if not IsNullGuid(Rec."Matched Rcpt./Shpt. Line SysId") then MatchedOrderLine.SetRange("Matched Rcpt./Shpt. Line SysId", Rec."Matched Rcpt./Shpt. Line SysId"); MatchedOrderLine.DeleteAll(true); MatchedOrderLineMgmt.UpdateQtyOnParentLines(Rec, false, -"Qty. to Invoice", -"Qty. to Invoice (Base)"); MatchedOrderLineMgmt.UpdateQtyOnParentLines(Rec, true, -"Qty. to Invoice", -"Qty. to Invoice (Base)"); end;}