Table "Availability Info. Buffer"

ID 520
Namespace: Microsoft.Inventory.Availability

Properties

Name Value
Caption Availability Information Buffer
TableType Temporary
DataClassification CustomerContent

Fields

Name Type Description
"Item No." Code[20]
"Lot No." Code[50]
"Serial No." Code[50]
"Package No." Code[50]
"Expiration Date" Date
Quality Option
"Certificate Number" Code[20]
Blocked Boolean
Inventory Decimal
"Date Filter" Date
"Variant Code Filter" Code[10]
"Location Code Filter" Code[10]
"Lot No. Filter" Code[50]
"Qty. In Hand" Decimal
"Gross Requirement" Decimal
"Planned Order Receipt" Decimal
"Scheduled Receipt" Decimal
"Available Inventory" Decimal
"Qty. on Sales Order" Decimal
"Qty. on Service Order" Decimal
"Qty. on Job Order" Decimal
"Qty. on Component Lines" Decimal
"Qty. on Trans. Order Shipment" Decimal
"Qty. on Asm. Component" Decimal
"Qty. on Purch. Return" Decimal
"Qty. on Purch. Order" Decimal
"Planned Order Receipt (Qty.)" Decimal
"Purch. Req. Receipt (Qty.)" Decimal
"Qty. on Prod. Receipt" Decimal
"Qty. on Trans. Order Receipt" Decimal
"Qty. on Assembly Order" Decimal
"Qty. on Sales Return" Decimal
"Qty. on Prod. Order" Decimal
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

AddEntriesForLookUp

procedure AddEntriesForLookUp(var TempReservationEntry: Record "Reservation Entry" temporary, SourceType: Integer, SourceSubTypeFilter: Text, ReservationStatusFilter: Text, DateFilterOption: Enum "Reservation Date Filter")

Parameters

Name Type Description
TempReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"
SourceType Integer
SourceSubTypeFilter Text
ReservationStatusFilter Text
DateFilterOption Enum Microsoft.Inventory.Tracking."Reservation Date Filter"

GetRangeFilter

procedure GetRangeFilter(FromVariant: Variant, ToVariant: Variant): Text

Parameters

Name Type Description
FromVariant Variant
ToVariant Variant

Returns

Type Description
Text

GetOptionFilter

procedure GetOptionFilter(Option1Variant: Variant, Option2Variant: Variant, Option3Variant: Variant): Text

Parameters

Name Type Description
Option1Variant Variant
Option2Variant Variant
Option3Variant Variant

Returns

Type Description
Text

Events

OnLookupAvailableInventory

[IntegrationEvent(True,False)]
local procedure OnLookupAvailableInventory(var TempReservationEntry: Record "Reservation Entry" temporary)

Parameters

Name Type Description
TempReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

OnLookupGrossRequirement

[IntegrationEvent(True,False)]
local procedure OnLookupGrossRequirement(var TempReservationEntry: Record "Reservation Entry" temporary)

Parameters

Name Type Description
TempReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

OnLookupScheduledReceipt

[IntegrationEvent(True,False)]
local procedure OnLookupScheduledReceipt(var TempReservationEntry: Record "Reservation Entry" temporary)

Parameters

Name Type Description
TempReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

OnLookupPlannedOrderReceipt

[IntegrationEvent(True,False)]
local procedure OnLookupPlannedOrderReceipt(var TempReservationEntry: Record "Reservation Entry" temporary)

Parameters

Name Type Description
TempReservationEntry Table Microsoft.Inventory.Tracking."Reservation Entry"

OnAddEntriesForLookUpOnBeforeVariantCodeGetFilter

[IntegrationEvent(True,False)]
local procedure OnAddEntriesForLookUpOnBeforeVariantCodeGetFilter(var AvailabilityInfoBuffer: Record "Availability Info. Buffer" temporary, var IsHandled: Boolean)

Parameters

Name Type Description
AvailabilityInfoBuffer Table Microsoft.Inventory.Availability."Availability Info. Buffer"
IsHandled Boolean

See also