Table 6509 Whse. Item Entry Relation, source in 29
Source29
src/Layers/W1/BaseApp/Warehouse/Ledger/WhseItemEntryRelation.Table.al150 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.Ledger;
using Microsoft.Inventory.Ledger;
using Microsoft.Inventory.Tracking;
table 6509 "Whse. Item Entry Relation"
{
Caption = 'Whse. Item Entry Relation';
DataClassification = CustomerContent;
fields
{
field(1; "Item Entry No."; Integer)
{
Caption = 'Item Entry No.';
TableRelation = "Item Ledger Entry";
}
field(10; "Source Type"; Integer)
{
Caption = 'Source Type';
}
field(11; "Source Subtype"; Option)
{
Caption = 'Source Subtype';
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(12; "Source ID"; Code[20])
{
Caption = 'Source ID';
}
field(13; "Source Batch Name"; Code[10])
{
Caption = 'Source Batch Name';
}
field(14; "Source Prod. Order Line"; Integer)
{
Caption = 'Source Prod. Order Line';
}
field(15; "Source Ref. No."; Integer)
{
Caption = 'Source Ref. No.';
}
field(20; "Serial No."; Code[50])
{
Caption = 'Serial No.';
}
field(21; "Lot No."; Code[50])
{
Caption = 'Lot No.';
}
field(30; "Order No."; Code[20])
{
Caption = 'Order No.';
}
field(31; "Order Line No."; Integer)
{
Caption = 'Order Line No.';
}
field(6515; "Package No."; Code[50])
{
Caption = 'Package No.';
}
}
keys
{
key(Key1; "Item Entry No.")
{
Clustered = true;
}
key(Key2; "Source ID", "Source Type", "Source Subtype", "Source Ref. No.", "Source Prod. Order Line", "Source Batch Name")
{
}
key(Key3; "Order No.", "Order Line No.")
{
}
}
fieldgroups
{
}
procedure InitFromTrackingSpec(TrackingSpecification: Record "Tracking Specification")
begin
Init();
"Item Entry No." := TrackingSpecification."Entry No.";
"Serial No." := TrackingSpecification."Serial No.";
"Lot No." := TrackingSpecification."Lot No.";
OnAfterInitFromTrackingSpec(Rec, TrackingSpecification);
end;
procedure SetSource(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer)
begin
"Source Type" := SourceType;
"Source Subtype" := SourceSubtype;
"Source ID" := SourceID;
"Source Ref. No." := SourceRefNo;
end;
procedure SetSource(SourceBatchName: Code[10]; SourceProdOrderLine: Integer)
begin
"Source Batch Name" := SourceBatchName;
"Source Prod. Order Line" := SourceProdOrderLine;
end;
procedure SetSourceFilter(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceKey: Boolean)
begin
if SourceKey then
SetCurrentKey(
"Source ID", "Source Type", "Source Subtype", "Source Ref. No.", "Source Prod. Order Line", "Source Batch Name");
SetRange("Source Type", SourceType);
if SourceSubtype >= 0 then
SetRange("Source Subtype", SourceSubtype);
SetRange("Source ID", SourceID);
if SourceRefNo >= 0 then
SetRange("Source Ref. No.", SourceRefNo);
OnAfterSetSourceFilter(Rec, SourceType, SourceSubtype, SourceID, SourceRefNo, SourceKey);
end;
procedure SetSourceFilter(SourceBatchName: Code[10]; SourceProdOrderLine: Integer)
begin
SetRange("Source Batch Name", SourceBatchName);
SetRange("Source Prod. Order Line", SourceProdOrderLine);
end;
procedure SetOrderInfo(OrderNo: Code[20]; OrderLineNo: Integer)
begin
"Order No." := OrderNo;
"Order Line No." := OrderLineNo;
end;
[IntegrationEvent(false, false)]
local procedure OnAfterInitFromTrackingSpec(var WhseItemEntryRelation: Record "Whse. Item Entry Relation"; TrackingSpecification: Record "Tracking Specification")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterSetSourceFilter(var WhseItemEntryRelation: Record "Whse. Item Entry Relation"; SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceKey: Boolean)
begin
end;
}