Objects/Tables/Table 5767 Warehouse Activity Line

Table 5767 Warehouse Activity Line in 20

Jonas Paprotka, Base Application 20.5.45456.61928, checked 2026-09-20

App: Base Application

Fields, 61 Keys, 19 Procedures, 64 Events, 104

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 61

Id	Name	Type	Obsolete
1	Activity Type	Enum Warehouse Activity Type	-
2	No.	Code[20]	-
3	Line No.	Integer	-
4	Source Type	Integer	-
5	Source Subtype	Option	-
6	Source No.	Code[20]	-
7	Source Line No.	Integer	-
8	Source Subline No.	Integer	-
9	Source Document	Enum Warehouse Activity Source Document	-
11	Location Code	Code[10]	-
12	Shelf No.	Code[10]	-
13	Sorting Sequence No.	Integer	-
14	Item No.	Code[20]	-
15	Variant Code	Code[10]	-
16	Unit of Measure Code	Code[10]	-
17	Qty. per Unit of Measure	Decimal	-
18	Description	Text[100]	-
19	Description 2	Text[50]	-
20	Quantity	Decimal	-
21	Qty. (Base)	Decimal	-
24	Qty. Outstanding	Decimal	-
25	Qty. Outstanding (Base)	Decimal	-
26	Qty. to Handle	Decimal	-
27	Qty. to Handle (Base)	Decimal	-
28	Qty. Handled	Decimal	-
29	Qty. Handled (Base)	Decimal	-
31	Shipping Advice	Enum Sales Header Shipping Advice	-
34	Due Date	Date	-
39	Destination Type	Enum Warehouse Destination Type	-
40	Destination No.	Code[20]	-
42	Shipping Agent Code	Code[10]	-
43	Shipping Agent Service Code	Code[10]	-
44	Shipment Method Code	Code[10]	-
47	Starting Date	Date	-
50	Qty. Rounding Precision	Decimal	-
51	Qty. Rounding Precision (Base)	Decimal	-
900	Assemble to Order	Boolean	-
901	ATO Component	Boolean	-
6500	Serial No.	Code[50]	-
6501	Lot No.	Code[50]	-
6502	Warranty Date	Date	-
6503	Expiration Date	Date	-
6504	Serial No. Blocked	Boolean	-
6505	Lot No. Blocked	Boolean	-
6515	Package No.	Code[50]	-
7300	Bin Code	Code[20]	-
7301	Zone Code	Code[10]	-
7305	Action Type	Enum Warehouse Action Type	-
7306	Whse. Document Type	Enum Warehouse Activity Document Type	-
7307	Whse. Document No.	Code[20]	-
7308	Whse. Document Line No.	Integer	-
7309	Bin Ranking	Integer	-
7310	Cubage	Decimal	-
7311	Weight	Decimal	-
7312	Special Equipment Code	Code[10]	-
7313	Bin Type Code	Code[10]	-
7314	Breakbulk No.	Integer	-
7315	Original Breakbulk	Boolean	-
7316	Breakbulk	Boolean	-
7317	Cross-Dock Information	Option	-
7318	Dedicated	Boolean	-

Keys, 19

Name	Fields	Obsolete
Key1, clustered	Activity Type, No., Line No.	-
Key2	No., Line No., Activity Type	-
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	-
Key4	Activity Type, No., Sorting Sequence No.	-
Key5	Activity Type, No., Shelf No.	-
Key6	Activity Type, No., Location Code, Source Document, Source No., Action Type, Zone Code	-
Key7	Activity Type, No., Due Date, Action Type, Bin Code	-
Key8	Activity Type, No., Bin Code, Breakbulk No., Action Type	-
Key9	Activity Type, No., Bin Ranking, Breakbulk No., Action Type	-
Key10	Activity Type, No., Destination Type, Destination No., Action Type, Bin Code	-
Key11	Activity Type, No., Whse. Document Type, Whse. Document No., Whse. Document Line No.	-
Key12	Activity Type, No., Action Type, Bin Code	-
Key13	Activity Type, No., Item No., Variant Code, Action Type, Bin Code	-
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.	-
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	-
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.	-
Key17	Bin Code, Location Code, Action Type, Breakbulk No.	-
Key18	Location Code, Activity Type	-
Key19	Source No., Source Line No., Source Subline No., Serial No., Lot No., Package No.	-

Procedures, 64

Name	Parameters	Returns	Access	Obsolete
CalcQty	(Decimal)	Decimal	public	-
AutofillQtyToHandle	(var Record Warehouse Activity Line)		public	-
DeleteQtyToHandle	(var Record Warehouse Activity Line)		public	-
DeleteRelatedWhseActivLines	(Record Warehouse Activity Line, Boolean)		public	-
CheckWhseDocLine	()		public	-
CheckBinInSourceDoc	()		public	-
GetBin	(Code[10], Code[20])	Boolean	public	-
CheckIncreaseCapacity	(Boolean)		public	-
SplitLine	(var Record Warehouse Activity Line)		public	-
UpdateBreakbulkQtytoHandle	()		public	-
ShowWhseDoc	()		public	-
ShowActivityDoc	()		public	-
ChangeUOMCode	(var Record Warehouse Activity Line, var Record Warehouse Activity Line)		public	-
UpdateRelatedItemTrkg	(Record Warehouse Activity Line)		public	-
LookUpTrackingSummary	(var Record Warehouse Activity Line, Boolean, Integer, Enum Item Tracking Type)		public	-
CheckReservedItemTrkg	(Enum Item Tracking Type, Code[50])		public	-
DeleteBinContent	(Option)		public	-
TransferFromPickWkshLine	(Record Whse. Worksheet Line)		public	-
TransferFromShptLine	(Record Warehouse Shipment Line)		public	-
TransferFromATOShptLine	(Record Warehouse Shipment Line, Record Assembly Line)		public	-
TransferFromIntPickLine	(Record Whse. Internal Pick Line)		public	-
TransferFromCompLine	(Record Prod. Order Component)		public	-
TransferFromAssemblyLine	(Record Assembly Line)		public	-
TransferFromMovWkshLine	(Record Whse. Worksheet Line)		public	-
ShowItemAvailabilityByPeriod	()		public	-
ShowItemAvailabilityByVariant	()		public	-
ShowItemAvailabilityByLocation	()		public	-
ShowItemAvailabilityByEvent	()		public	-
ActivityExists	(Integer, Option, Code[20], Integer, Integer, Option)	Boolean	public	-
TrackingExists	()	Boolean	public	-
SetSource	(Integer, Option, Code[20], Integer, Integer)		public	-
SetSourceFilter	(Integer, Option, Code[20], Integer, Integer, Boolean)		public	-
SetSumLinesFilters	(Record Warehouse Activity Line)		public	-
ClearSourceFilter	()		public	-
ClearTracking	()		public	-
ClearTrackingFilter	()		public	-
CopyTrackingFromSpec	(Record Tracking Specification)		public	-
CopyTrackingFromItemTrackingSetup	(Record Item Tracking Setup)		public	-
CopyTrackingFromPostedWhseRcptLine	(Record Posted Whse. Receipt Line)		public	-
CopyTrackingFromWhseItemTrackingLine	(Record Whse. Item Tracking Line)		public	-
SetTrackingFilterIfNotEmpty	()		public	-
SetTrackingFilter	(Code[50], Code[50])		public	Pending 17.0
Replaced by SetTrackingFilterFrom procedures.
SetTrackingFilterFromBinContent	(var Record Bin Content)		public	-
SetTrackingFilterFromBinContentBuffer	(Record Bin Content Buffer)		public	-
SetTrackingFilterFromItemTrackingSetup	(Record Item Tracking Setup)		public	-
SetTrackingFilterFromReservEntry	(Record Reservation Entry)		public	-
SetTrackingFilterFromReservEntryIfRequired	(Record Reservation Entry)		public	-
SetTrackingFilterFromWhseItemTrackingLineIfNotBlank	(Record Whse. Item Tracking Line)		public	-
SetTrackingFilterFromWhseActivityLine	(Record Warehouse Activity Line)		public	-
SetTrackingFilterFromWhseItemTrackingSetup	(Record Item Tracking Setup)		public	-
SetTrackingFilterFromWhseItemTrackingSetupifNotBlank	(Record Item Tracking Setup)		public	-
SetTrackingFilterToItemIfRequired	(var Record Item, Record Item Tracking Setup)		public	-
SetTrackingFilterToItemLedgEntryIfRequired	(var Record Item Ledger Entry, Record Item Tracking Setup)		public	-
SetTrackingFilterToWhseEntryIfRequired	(var Record Warehouse Entry, Record Item Tracking Setup)		public	-
TestTrackingIfRequired	(Record Item Tracking Setup)		public	-
TrackingFilterExists	()	Boolean	public	-
HasRequiredTracking	(Record Item Tracking Setup)	Boolean	public	-
Lock	()		public	-
ResetQtyToHandleOnReservation	()		public	-
ValidateQtyWhenSNDefined	()		public	-
TestNonSpecificItemTracking	()		public	-
FindBinCode	()	Code[20]	public	-
FindBinContent	()		public	-
TransferFromJobPlanningLine	(Record Job Planning Line)		public	-

Events, 104

Kind	Name	Parameters	Obsolete
Integration event	OnAfterAutofillQtyToHandle	(var Record Warehouse Activity Line)	-
Integration event	OnAfterAutofillQtyToHandleLine	(var Record Warehouse Activity Line)	-
Integration event	OnAfterClearTracking	(var Record Warehouse Activity Line)	-
Integration event	OnAfterClearTrackingFilter	(var Record Warehouse Activity Line)	-
Integration event	OnAfterCopyTrackingFromSpec	(var Record Warehouse Activity Line, Record Tracking Specification)	-
Integration event	OnAfterCopyTrackingFromItemTrackingSetup	(var Record Warehouse Activity Line, Record Item Tracking Setup)	-
Integration event	OnAfterCopyTrackingFromPostedWhseRcptLine	(var Record Warehouse Activity Line, Record Posted Whse. Receipt Line)	-
Integration event	OnAfterCopyTrackingFromWhseItemTrackingLine	(var Record Warehouse Activity Line, Record Whse. Item Tracking Line)	-
Integration event	OnAfterDeleteQtyToHandle	(var Record Warehouse Activity Line)	-
Integration event	OnAfterInitTrackingSpecFromWhseActivLine	(var Record Tracking Specification, Record Warehouse Activity Line)	-
Integration event	OnAfterLookupTrackingSummary	(var Record Warehouse Activity Line, var Record Tracking Specification, Enum Item Tracking Type)	-
Integration event	OnAfterSetTrackingFilter	(var Record Warehouse Activity Line)	Pending 20.0
Replaced by events OnAfterSetTrackingFilterFrom
Integration event	OnAfterSetTrackingFilterIfNotEmpty	(var Record Warehouse Activity Line)	-
Integration event	OnAfterSetTrackingFilterFromItemTrackingSetup	(var Record Warehouse Activity Line, Record Item Tracking Setup)	-
Integration event	OnAfterSetTrackingFilterFromBinContent	(var Record Warehouse Activity Line, var Record Bin Content)	-
Integration event	OnAfterSetTrackingFilterFromBinContentBuffer	(var Record Warehouse Activity Line, var Record Bin Content Buffer)	-
Integration event	OnAfterSetTrackingFilterFromReservEntry	(var Record Warehouse Activity Line, Record Reservation Entry)	-
Integration event	OnAfterSetTrackingFilterFromReservEntryIfRequired	(var Record Warehouse Activity Line, Record Reservation Entry)	-
Integration event	OnAfterSetTrackingFilterFromWhseActivityLine	(var Record Warehouse Activity Line, Record Warehouse Activity Line)	-
Integration event	OnAfterSetTrackingFilterFromWhseItemTrackingLineIfNotBlank	(var Record Warehouse Activity Line, Record Whse. Item Tracking Line)	-
Integration event	OnAfterSetTrackingFilterFromWhseItemTrackingSetupifNotBlank	(var Record Warehouse Activity Line, Record Item Tracking Setup)	-
Integration event	OnAfterSetTrackingFilterFromWhseItemTrackingSetup	(var Record Warehouse Activity Line, Record Item Tracking Setup)	-
Integration event	OnAfterSetTrackingFilterToItemIfRequired	(var Record Warehouse Activity Line, var Record Item, Record Item Tracking Setup)	-
Integration event	OnAfterSetTrackingFilterToItemLedgEntryIfRequired	(var Record Warehouse Activity Line, var Record Item Ledger Entry, Record Item Tracking Setup)	-
Integration event	OnAfterSetTrackingFilterToWhseEntryIfRequired	(var Record Warehouse Activity Line, var Record Warehouse Entry, Record Item Tracking Setup)	-
Integration event	OnAfterShowDeletedMessage	(var Record Warehouse Activity Line)	-
Integration event	OnAfterSplitLines	(var Record Warehouse Activity Line, Record Warehouse Activity Line)	-
Integration event	OnAfterTrackingFilterExists	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnAfterTransferFromShptLine	(var Record Warehouse Activity Line, Record Warehouse Shipment Line)	-
Integration event	OnAfterTransferFromIntPickLine	(var Record Warehouse Activity Line, Record Whse. Internal Pick Line)	-
Integration event	OnAfterTransferFromCompLine	(var Record Warehouse Activity Line, Record Prod. Order Component)	-
Integration event	OnAfterTransferFromAssemblyLine	(var Record Warehouse Activity Line, Record Assembly Line)	-
Integration event	OnAfterTransferFromMovWkshLine	(var Record Warehouse Activity Line, Record Whse. Worksheet Line)	-
Integration event	OnAfterTransferFromPickWkshLine	(var Record Warehouse Activity Line, Record Whse. Worksheet Line)	-
Integration event	OnAfterTestTrackingIfRequired	(var Record Warehouse Activity Line, Record Item Tracking Setup)	-
Integration event	OnAfterTrackingExists	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnAfterUpdateQtyToHandleWhseActivLine	(var Record Warehouse Activity Line)	-
Integration event	OnBeforeAutofillQtyToHandle	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeCheckBinInSourceDoc	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeCheckReservedItemTrkg	(var Record Warehouse Activity Line, Enum Item Tracking Type, Code[50], var Boolean)	-
Integration event	OnBeforeCheckExceedQtyAvailBase	(var Record Warehouse Activity Line, Decimal, Code[20], var Boolean)	-
Integration event	OnBeforeCheckBinCodeFromProdOrderCompLine	(var Record Warehouse Activity Line, Record Prod. Order Component, var Boolean)	-
Integration event	OnBeforeCheckBinCodeFromWhseShptLine	(var Record Warehouse Activity Line, Record Warehouse Shipment Line, var Boolean)	-
Integration event	OnBeforeCheckInvalidBinCode	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeCheckLine	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeCheckWhseDocLine	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeCheckSNSpecificationExists	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeConfirmWhseActivLinesDeletionRecreate	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeConfirmWhseActivLinesDeletionOutOfBalance	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeSplitLines	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeDeleteRelatedWhseActivLines	(var Record Warehouse Activity Line, Boolean)	-
Integration event	OnBeforeDeleteQtyToHandle	(var Record Warehouse Activity Line)	-
Integration event	OnBeforeFindBinCode	(var Record Warehouse Activity Line, var Record Item, var Code[20], var Boolean)	-
Integration event	OnBeforeFindBinContent	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeFindLotNoBySerialNo	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeInsertNewWhseActivLine	(var Record Warehouse Activity Line, var Record Warehouse Activity Line)	-
Integration event	OnBeforeLookUpTrackingSummary	(Record Warehouse Activity Line, Enum Item Tracking Type, var Boolean)	-
Integration event	OnBeforeModifyOldWhseActivLine	(var Record Warehouse Activity Line)	-
Integration event	OnBeforeSetWhseItemTrkgLineFiltersWhseShipment	(var Record Warehouse Activity Line, var Record Whse. Item Tracking Line, Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeShowDeletedMessage	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeShowWhseDoc	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeValidateQtyToHandle	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeValidateVariantCode	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnCreateNewUOMLineOnBeforeNewWhseActivLineInsert	(var Record Warehouse Activity Line, Record Warehouse Activity Line)	-
Integration event	OnLookUpTrackingSummaryOnAfterAssistEditTrackingNo	(var Record Warehouse Activity Line, var Record Tracking Specification, Enum Item Tracking Type)	-
Integration event	OnLookUpTrackingSummaryOnAfterCheckDataSet	(Record Warehouse Activity Line, Record Item, var Record Tracking Specification)	-
Integration event	OnValidateBinCodeOnAfterGetBin	(var Record Warehouse Activity Line, Record Bin)	-
Integration event	OnValidateBinCodeOnAfterCalcQtyAvailBase	(var Record Warehouse Activity Line, Decimal, Code[20])	-
Integration event	OnValidateItemNoOnAfterValidateUoMCode	(var Record Warehouse Activity Line, Record Item, Integer)	-
Integration event	OnValidateQtyToHandleOnAfterCalcQtyToHandleBase	(var Record Warehouse Activity Line, Decimal, var Decimal)	-
Integration event	OnValidateQtyToHandleOnBeforeCalcQtyToHandleBase	(var Record Warehouse Activity Line, var Record Warehouse Activity Line, Record Location, Integer)	-
Integration event	OnValidateVariantCodeOnAfterGetItemVariant	(var Record Warehouse Activity Line, Record Item Variant, var Boolean)	-
Integration event	OnBeforeCheckBin	(var Record Bin, var Boolean)	-
Integration event	OnBeforeChangeUOMCode	(var Record Warehouse Activity Line, var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeReNumberWhseActivityLines	(var Record Warehouse Activity Line, var Record Warehouse Activity Line, var Integer, var Integer, var Boolean)	-
Integration event	OnCheckReservedItemTrkgOnCkeckTypeElseCase	(var Record Warehouse Activity Line, Enum Item Tracking Type, Code[50])	Pending 18.0
Replaced by OnCheckReservedItemTrkgOnCheckTypeElseCase().
Integration event	OnDeleteRelatedWhseActivLinesOnBeforeWhseActivLine2Find	(var Record Warehouse Activity Line, var Record Warehouse Activity Line)	-
Integration event	OnDeleteRelatedWhseActivLinesOnBeforeConfirmWhseActivLinesDeletionOutOfBalance	(Record Warehouse Activity Line, Boolean, var Boolean)	-
Integration event	OnCheckIncreaseCapacityOnBeforeCheckIncreaseBinContent	(var Record Warehouse Activity Line, var Record Bin, Decimal, Decimal, var Boolean)	-
Integration event	OnValidateBinCodeOnAfterCheckInvalidBinCode	(var Record Warehouse Activity Line, Record Warehouse Activity Line, Integer, var Boolean)	-
Integration event	OnBeforeRunWhsePickCard	(var Record Warehouse Activity Header, var Boolean)	-
Integration event	OnConfirmWhseActivLinesDeletionOutOfBalanceOnAfterWhseActivLine3SetFilters	(var Record Warehouse Activity Line, var Record Warehouse Activity Line, var Record Warehouse Activity Line)	-
Integration event	OnAfterCheckReservedItemTrkg	(var Record Warehouse Activity Line, Record Warehouse Activity Line, Integer, Integer, Decimal)	-
Integration event	OnAfterHasRequiredTracking	(var Record Warehouse Activity Line, Record Item Tracking Setup, var Boolean)	-
Integration event	OnBeforeCalcQty	(var Record Warehouse Activity Line, Decimal)	-
Integration event	OnBeforeGetUOMCode	(var Record Warehouse Activity Line, var Code[10], var Boolean, Record Location)	-
Integration event	OnBeforeValidateSerialNo	(var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeValidateLotNo	(var Record Warehouse Activity Line)	-
Integration event	OnBeforeValidateQtyOutstanding	(var Record Warehouse Activity Line, Record Warehouse Activity Line, Integer, var Boolean)	-
Integration event	OnLookUpTrackingSummaryOnAfterAssignSerialNoTracking	(var Record Warehouse Activity Line, Record Tracking Specification)	-
Integration event	OnLookUpTrackingSummaryOnAfterAssignLotNoTracking	(var Record Warehouse Activity Line, Record Tracking Specification)	-
Integration event	OnCheckReservedItemTrkgOnCheckTypeElseCase	(var Record Warehouse Activity Line, Enum Item Tracking Type, Code[50])	-
Integration event	OnDeleteRelatedWhseActivLinesOnBeforeDeleteWhseActivLine2	(var Record Warehouse Activity Line, var Record Warehouse Activity Line, var Boolean)	-
Integration event	OnSplitLineOnBeforeRenumberAllLines	(var Record Warehouse Activity Line, var Integer)	-
Integration event	OnSplitLineOnAfterInitNewWhseActivLine	(var Record Warehouse Activity Line)	-
Integration event	OnUpdateQtyToHandleOnBeforeWhseActivLineModify	(var Record Warehouse Activity Line)	-
Integration event	OnAfterTransferAllButWhseDocDetailsFromAssemblyLine	(var Record Warehouse Activity Line, Record Assembly Line)	-
Integration event	OnBeforeDeleteWhseActivLine2	(var Record Warehouse Activity Line, Boolean, var Boolean)	-
Integration event	OnBeforeValidateQtyBase	(var Record Warehouse Activity Line, Record Warehouse Activity Line, Integer, var Boolean)	-
Integration event	OnChangeUOMCodeOnBeforeRecModify	(var Record Warehouse Activity Line, Record Location)	-
Integration event	OnCreateNewUOMLineOnBeforeNewWhseActivLineModify	(var Record Warehouse Activity Line, var Record Warehouse Activity Line)	-
Integration event	OnBeforeValidateQuantityIsBalanced	(var Record Warehouse Activity Line, Record Warehouse Activity Line, var Boolean)	-
Integration event	OnBeforeValidateQtyWhenSNDefined	(Record Warehouse Activity Line, var Boolean)	-
Integration event	OnUpdateReservationOnBeforeTempTrackingSpecificationInsert	(var Record Tracking Specification, var Record Warehouse Activity Line)	-