Table 5767 Warehouse Activity Line

Base Application, Microsoft.Warehouse.Activity

10 keys

KeyVersions
key(Key1; "Activity Type", "No.", "Line No.") { Clustered = true; }17-29
key(Key2; "No.", "Line No.", "Activity Type")17-29
key(Key3; "Source Type", "Source Subtype", "Source No.", "Source Line No.", "Source Subline No.", "Unit of Measure Code", "Action Type", "Breakbulk No.", "Original Breakbulk", "Activity Type", "Assemble to Order") { IncludedFields = "Qty. Outstanding", "Qty. Outstanding (Base)"; }17-29changed in 22
key(Key4; "Activity Type", "No.", "Sorting Sequence No.") { IncludedFields = "Shelf No."; }17-29changed in 25
key(Key14; "Whse. Document No.", "Whse. Document Type", "Activity Type", "Whse. Document Line No.", "Action Type", "Unit of Measure Code", "Original Breakbulk", "Breakbulk No.", "Lot No.", "Serial No.", "Assemble to Order", "Package No.") { IncludedFields = "Qty. Outstanding (Base)", "Qty. Outstanding"; }17-29changed in 18, 22
key(Key15; "Item No.", "Bin Code", "Location Code", "Action Type", "Variant Code", "Unit of Measure Code", "Breakbulk No.", "Activity Type", "Lot No.", "Serial No.", "Original Breakbulk", "Assemble to Order", "ATO Component") { IncludedFields = Quantity, "Qty. (Base)", "Qty. Outstanding", "Qty. Outstanding (Base)", Cubage, Weight; }17-29changed in 22
key(Key16; "Item No.", "Location Code", "Activity Type", "Bin Type Code", "Unit of Measure Code", "Variant Code", "Breakbulk No.", "Action Type", "Lot No.", "Serial No.", "Assemble to Order", "Package No.") { IncludedFields = "Qty. Outstanding (Base)"; }17-29changed in 18, 22
key(Key17; "Bin Code", "Location Code", "Action Type", "Breakbulk No.") { IncludedFields = Cubage, Weight; }17-29changed in 22
key(Key18; "Location Code", "Activity Type")17-29
key(Key19; "Source No.", "Source Line No.", "Source Subline No.") { IncludedFields = "Serial No.", "Lot No.", "Package No."; }17-29changed in 18, 25