Table "Entry Summary"
ID 338
Namespace: Microsoft.Inventory.Tracking
Properties
| Name |
Value |
| Caption |
Entry Summary
|
| TableType |
Temporary
|
| DataClassification |
CustomerContent
|
Fields
| Name |
Type |
Description |
| "Entry No." |
Integer
|
|
| "Table ID" |
Integer
|
|
| "Summary Type" |
Text[80]
|
Specifies which type of line or entry is summarized in the entry summary.
|
| "Total Quantity" |
Decimal
|
Specifies the total quantity of the item in inventory.
|
| "Total Reserved Quantity" |
Decimal
|
Specifies the total quantity of the relevant item that is reserved on documents or entries of the type on the line.
|
| "Total Available Quantity" |
Decimal
|
Specifies the quantity available for the user to request, in entries of the type on the line.
|
| "Current Reserved Quantity" |
Decimal
|
Specifies the quantity of items in the entry that are reserved for the line that the Reservation window is opened from.
|
| "Source Subtype" |
Integer
|
|
| "Qty. Alloc. in Warehouse" |
Decimal
|
|
| "Res. Qty. on Picks & Shipmts." |
Decimal
|
|
| "Serial No." |
Code[50]
|
Specifies the serial number for which availability is presented in the Item Tracking Summary window.
|
| "Lot No." |
Code[50]
|
Specifies the lot number for which availability is presented in the Item Tracking Summary window.
|
| "Warranty Date" |
Date
|
Specifies the warranty expiration date, if any, of the item carrying the item tracking number.
|
| "Expiration Date" |
Date
|
Specifies the expiration date, if any, of the item carrying the item tracking number.
|
| "Total Requested Quantity" |
Decimal
|
Specifies the total quantity of the serial, lot or package number that is requested in all documents.
|
| "Selected Quantity" |
Decimal
|
Specifies the quantity of each serial, lot or package number that you want to use to fulfill the demand for the transaction.
|
| "Current Pending Quantity" |
Decimal
|
Specifies the quantity from the item tracking line that is selected on the document but not yet committed to the database.
|
| "Current Requested Quantity" |
Decimal
|
|
| "Bin Content" |
Decimal
|
Specifies the quantity of the item in the bin specified in the document line.
|
| "Bin Active" |
Boolean
|
|
| "Non-specific Reserved Qty." |
Decimal
|
Specifies the quantity of the item that is reserved but does not have specific item tracking numbers in the reservation.
|
| "Double-entry Adjustment" |
Decimal
|
|
| "Non Serial Tracking" |
Boolean
|
|
| "Package No." |
Code[50]
|
Specifies the package number for which availability is presented in the Item Tracking Summary window.
|
| "Qty. Rounding Precision (Base)" |
Decimal
|
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemCreatedByUserName |
Text[50]
|
|
| SystemCreatedByFullName |
Text[80]
|
|
| SystemModifiedByUserName |
Text[50]
|
|
| SystemModifiedByFullName |
Text[80]
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
GetLastEntryNo
procedure GetLastEntryNo(): Integer
Returns
UpdateAvailable
procedure UpdateAvailable()
HasQuantity
procedure HasQuantity(): Boolean
Returns
HasNonSerialTracking
procedure HasNonSerialTracking(): Boolean
Returns
HasSameTracking
procedure HasSameTracking(EntrySummary: Record "Entry Summary"): Boolean
Parameters
Returns
HasSameNonSerialTracking
procedure HasSameNonSerialTracking(EntrySummary: Record "Entry Summary"): Boolean
Parameters
Returns
CopyTrackingFromItemTrackingSetup
procedure CopyTrackingFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
CopyTrackingFromReservEntry
procedure CopyTrackingFromReservEntry(ReservEntry: Record "Reservation Entry")
Parameters
CopyTrackingFromSpec
procedure CopyTrackingFromSpec(TrackingSpecification: Record "Tracking Specification")
Parameters
QtyAvailableToSelectFromBin
procedure QtyAvailableToSelectFromBin(): Decimal
Returns
SetTrackingFilterFromEntrySummary
procedure SetTrackingFilterFromEntrySummary(EntrySummary: Record "Entry Summary")
Parameters
SetNonSerialTrackingFilterFromEntrySummary
procedure SetNonSerialTrackingFilterFromEntrySummary(EntrySummary: Record "Entry Summary")
Parameters
SetNonSerialTrackingFilterFromReservEntry
procedure SetNonSerialTrackingFilterFromReservEntry(ReservEntry: Record "Reservation Entry")
Parameters
SetTrackingFilterFromItemTrackingSetup
procedure SetTrackingFilterFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
SetTrackingFilterFromItemTrackingSetupIfRequired
procedure SetTrackingFilterFromItemTrackingSetupIfRequired(ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
SetTrackingFilterFromReservEntry
procedure SetTrackingFilterFromReservEntry(ReservationEntry: Record "Reservation Entry")
Parameters
SetTrackingFilterFromSpec
procedure SetTrackingFilterFromSpec(TrackingSpecification: Record "Tracking Specification")
Parameters
SetTrackingKey
procedure SetTrackingKey()
Events
OnAfterHasSameTracking
[IntegrationEvent(False,False)]
local procedure OnAfterHasSameTracking(ToEntrySummary: Record "Entry Summary"; FromEntrySummary: Record "Entry Summary"; var SameTracking: Boolean)
Parameters
OnAfterHasSameNonSerialTracking
[IntegrationEvent(False,False)]
local procedure OnAfterHasSameNonSerialTracking(ToEntrySummary: Record "Entry Summary"; FromEntrySummary: Record "Entry Summary"; var SameTracking: Boolean)
Parameters
OnAfterHasNonSerialTracking
[IntegrationEvent(False,False)]
local procedure OnAfterHasNonSerialTracking(EntrySummary: Record "Entry Summary"; var NonSerialTracking: Boolean)
Parameters
OnAfterCopyTrackingFromReservEntry
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromReservEntry(var ToEntrySummary: Record "Entry Summary"; FromReservEntry: Record "Reservation Entry")
Parameters
OnAfterCopyTrackingFromSpec
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromSpec(var ToEntrySummary: Record "Entry Summary"; TrackingSpecification: Record "Tracking Specification")
Parameters
OnAfterCopyTrackingFromItemTrackingSetup
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromItemTrackingSetup(var ToEntrySummary: Record "Entry Summary"; ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterSetTrackingFilterFromEntrySummary
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromEntrySummary(var ToEntrySummary: Record "Entry Summary"; FromEntrySummary: Record "Entry Summary")
Parameters
OnAfterSetNonSerialTrackingFilterFromEntrySummary
[IntegrationEvent(False,False)]
local procedure OnAfterSetNonSerialTrackingFilterFromEntrySummary(var ToEntrySummary: Record "Entry Summary"; FromEntrySummary: Record "Entry Summary")
Parameters
OnAfterSetNonSerialTrackingFilterFromReservEntry
[IntegrationEvent(False,False)]
local procedure OnAfterSetNonSerialTrackingFilterFromReservEntry(var ToEntrySummary: Record "Entry Summary"; FromReservEntry: Record "Reservation Entry")
Parameters
OnAfterSetTrackingFilterFromItemTrackingSetup
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetup(var ToEntrySummary: Record "Entry Summary"; ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var ToEntrySummary: Record "Entry Summary"; ItemTrackingSetup: Record "Item Tracking Setup")
Parameters
OnAfterSetTrackingFilterFromReservEntry
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromReservEntry(var ToEntrySummary: Record "Entry Summary"; FromReservEntry: Record "Reservation Entry")
Parameters
OnAfterSetTrackingFilterFromSpec
[IntegrationEvent(False,False)]
local procedure OnAfterSetTrackingFilterFromSpec(var ToEntrySummary: Record "Entry Summary"; FromTrackingSpecification: Record "Tracking Specification")
Parameters
OnBeforeSetTrackingKey
[IntegrationEvent(False,False)]
local procedure OnBeforeSetTrackingKey(var EntrySummary: Record "Entry Summary"; var IsHandled: Boolean)
Parameters
OnAfterUpdateAvailable
[IntegrationEvent(False,False)]
local procedure OnAfterUpdateAvailable(var EntrySummary: Record "Entry Summary")
Parameters
See also