Table 7330 Bin Content Buffer
src/Layers/W1/BaseApp/Warehouse/Structure/BinContentBuffer.Table.al181 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.Structure;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Activity;table 7330 "Bin Content Buffer"{ Caption = 'Bin Content Buffer'; ReplicateData = false; TableType = Temporary; DataClassification = CustomerContent; fields { field(1; "Location Code"; Code[10]) { Caption = 'Location Code'; DataClassification = SystemMetadata; NotBlank = true; TableRelation = Location; } field(2; "Zone Code"; Code[10]) { Caption = 'Zone Code'; DataClassification = SystemMetadata; NotBlank = true; TableRelation = Zone.Code where("Location Code" = field("Location Code")); } field(3; "Bin Code"; Code[20]) { Caption = 'Bin Code'; DataClassification = SystemMetadata; NotBlank = true; TableRelation = if ("Zone Code" = filter('')) Bin.Code where("Location Code" = field("Location Code")) else if ("Zone Code" = filter(<> '')) Bin.Code where("Location Code" = field("Location Code"), "Zone Code" = field("Zone Code")); } field(4; "Item No."; Code[20]) { Caption = 'Item No.'; DataClassification = SystemMetadata; NotBlank = true; TableRelation = Item; } field(5; "Variant Code"; Code[10]) { Caption = 'Variant Code'; DataClassification = SystemMetadata; TableRelation = "Item Variant".Code where("Item No." = field("Item No.")); } field(6; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code'; DataClassification = SystemMetadata; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); } field(10; Cubage; Decimal) { AutoFormatType = 0; Caption = 'Cubage'; DataClassification = SystemMetadata; DecimalPlaces = 0 : 5; } field(11; Weight; Decimal) { AutoFormatType = 0; Caption = 'Weight'; DataClassification = SystemMetadata; DecimalPlaces = 0 : 5; } field(12; "Base Unit of Measure"; Code[10]) { Caption = 'Base Unit of Measure'; DataClassification = SystemMetadata; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); } field(50; "Qty. to Handle (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Qty. to Handle (Base)'; DataClassification = SystemMetadata; DecimalPlaces = 0 : 5; Editable = false; } field(51; "Qty. Outstanding (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Qty. Outstanding (Base)'; DataClassification = SystemMetadata; DecimalPlaces = 0 : 5; } field(6500; "Lot No."; Code[50]) { Caption = 'Lot No.'; DataClassification = SystemMetadata; } field(6501; "Serial No."; Code[50]) { Caption = 'Serial No.'; DataClassification = SystemMetadata; } field(6515; "Package No."; Code[50]) { Caption = 'Package No.'; DataClassification = SystemMetadata; } field(7382; Dedicated; Boolean) { Caption = 'Dedicated'; DataClassification = SystemMetadata; } } keys { key(Key1; "Location Code", "Bin Code", "Item No.", "Variant Code", "Unit of Measure Code", "Lot No.", "Serial No.", "Package No.") { Clustered = true; } } fieldgroups { } procedure UpdateBuffer(LocationCode: Code[10]; BinCode: Code[20]; ItemNo: Code[20]; VariantCode: Code[10]; UnitOfMeasureCode: Code[10]; WhseItemTrackingSetup: Record "Item Tracking Setup"; QtyBase: Decimal) begin if Get( LocationCode, BinCode, ItemNo, VariantCode, UnitOfMeasureCode, WhseItemTrackingSetup."Lot No.", WhseItemTrackingSetup."Serial No.", WhseItemTrackingSetup."Package No.") then begin "Qty. to Handle (Base)" += QtyBase; Modify(); end else begin Init(); "Location Code" := LocationCode; "Bin Code" := BinCode; "Item No." := ItemNo; "Variant Code" := VariantCode; "Unit of Measure Code" := UnitOfMeasureCode; CopyTrackingFromWhseItemTrackingSetup(WhseItemTrackingSetup); "Qty. to Handle (Base)" := QtyBase; Insert(); end; end; procedure CopyTrackingFromWhseActivityLine(WhseActivityLine: Record "Warehouse Activity Line") begin "Serial No." := WhseActivityLine."Serial No."; "Lot No." := WhseActivityLine."Lot No."; OnAfterCopyTrackingFromWhseActivityLine(Rec, WhseActivityLine); end; procedure CopyTrackingFromWhseItemTrackingSetup(WhseItemTrackingSetup: Record "Item Tracking Setup") begin "Serial No." := WhseItemTrackingSetup."Serial No."; "Lot No." := WhseItemTrackingSetup."Lot No."; OnAfterCopyTrackingFromWhseItemTrackingSetup(Rec, WhseItemTrackingSetup); end; [IntegrationEvent(false, false)] local procedure OnAfterCopyTrackingFromWhseActivityLine(var BinContentBuffer: Record "Bin Content Buffer"; WhseActivityLine: Record "Warehouse Activity Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCopyTrackingFromWhseItemTrackingSetup(var BinContentBuffer: Record "Bin Content Buffer"; WhseItemTrackingSetup: Record "Item Tracking Setup") begin end;}