Logistics.Inventory.Lots Entity

Namespace: Logistics.Inventory

Warehouse lots. They contain one row for each specific product, status, production batch and other specific warehousing conditions. Lot status can block certain operations. Entity: Inv_Lots

Default Visualization

Default Display Text Format:
{Product.Name:T}
Default Search Members:
Number; Product.Name
Code Data Member:
Number
Name Data Member:
Product.Name
Category: Views
Show in UI: ShownByDefault

Track Changes

Min level: 0 - Do not track changes
Max level: 4 - Track object attribute and blob changes

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Parent:
General.Products.Products
Aggregate Root:
General.Products.Products

Attributes

Name	Type	Description
AlcoholicStrength	decimal (5, 2)	Percentage of pure alcohol used in excise duty reporting. `Required` `Default(0)` `Introduced in version 22.1.6.66`
Description	MultilanguageString (254) nullable	The description of this Lot.
DisplayText	string	Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.
ExpiryDate	datetime nullable	Expiry date for this lot. `Filter(ge;le)`
Id	guid
LicenseNo	string (50) nullable	The license number for this lot. Null when license number is N/A or unknown.
Number	string (30)	The unique number of the Lot. May contain characters, if required. `Required` `Filter(eq;like)` `ORD`
ObjectVersion	int32	The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking.
ProductionBatchId	guid nullable	Non-null if the production batch is known. Production batches are automatically created for internal production, but can also be used for specifying production batches for purchased goods. `Filter(multi eq)`
PurchaseLotNumber	string (30) nullable	Identification of the purchase lost with which the products from this store lot are received. E.g. the document number of the Receiving order. `Filter(like)`
ReceiptDate	date nullable	The date of the first receipt of products in this lot. `Filter(ge;le)` `ReadOnly`
Status	Status	Status of the warehouse lot. Minus statuses describe blocked conditions. -3 blocked for document (sales or service order) -2 blocked for party -1 blocked for inspection 0 free to use. `Required` `Default(0)` `Filter(multi eq)`

References

Name	Type	Description
BlockedForDocument	Documents (nullable)	If non-null, contains the document for which the lot is blocked. `Filter(multi eq)`
BlockedForParty	Parties (nullable)	Non-null when the warehouse lot is blocked specifically for some party. `Filter(multi eq)`
CertificateDocument	Documents (nullable)	Document, containing the certificate for this lot. `Filter(multi eq)`
ExciseMeasuringTransaction	MeasuringTransactions (nullable)	When the lot was created in an excise controlled environment, specifies the measuring transaction which was used to create the lot. `Filter(multi eq)` `Introduced in version 21.1.1.59`
Product	Products	The product to which the lot is bound. `Required` `Filter(multi eq)` `Owner`
ReceiptStoreTransaction	StoreTransactions (nullable)	The store receipt transaction, which created the lot. null if the lot is manually created. `Filter(multi eq)`

Attribute Details

AlcoholicStrength

Percentage of pure alcohol used in excise duty reporting. Required Default(0) Introduced in version 22.1.6.66

Type: decimal (5, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: 0
Show in UI: ShownByDefault

Description

The description of this Lot.

Type: MultilanguageString (254) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

DisplayText

Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.

Type: string
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault

ExpiryDate

Expiry date for this lot. Filter(ge;le)

Type: datetime nullable
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault

Id

Type: guid
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: CannotBeShown

LicenseNo

The license number for this lot. Null when license number is N/A or unknown.

Type: string (50) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 50
Show in UI: ShownByDefault

Number

The unique number of the Lot. May contain characters, if required. Required Filter(eq;like) ORD

Type: string (30)
Indexed: True
Category: System
Supported Filters: Equals, Like
Supports Order By: True
Maximum Length: 30
Show in UI: ShownByDefault

Back-End Default Expression:
obj.GetNextDefaultLotNumber( )

ObjectVersion

The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking.

Type: int32
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault

ProductionBatchId

Non-null if the production batch is known. Production batches are automatically created for internal production, but can also be used for specifying production batches for purchased goods. Filter(multi eq)

Type: guid nullable
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: CannotBeShown

PurchaseLotNumber

Identification of the purchase lost with which the products from this store lot are received. E.g. the document number of the Receiving order. Filter(like)

Type: string (30) nullable
Category: System
Supported Filters: Like
Supports Order By: False
Maximum Length: 30
Show in UI: ShownByDefault

ReceiptDate

The date of the first receipt of products in this lot. Filter(ge;le) ReadOnly

Type: date nullable
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault

Status

Status of the warehouse lot. Minus statuses describe blocked conditions. -3 blocked for document (sales or service order) -2 blocked for party -1 blocked for inspection 0 free to use. Required Default(0) Filter(multi eq)

Type: Status
Category: System
Allowed values for the Status(Logistics.Inventory.Lots.md#status) data attribute
Allowed Values (Logistics.Inventory.LotsRepository.Status Enum Members)

Value	Description
FreeToUse	FreeToUse value. Stored as 0. Database Value: 0 Model Value: 0 Domain API Value: 'FreeToUse'
BlockedForDocument	BlockedForDocument value. Stored as -3. Database Value: -3 Model Value: -3 Domain API Value: 'BlockedForDocument'
BlockedForParty	BlockedForParty value. Stored as -2. Database Value: -2 Model Value: -2 Domain API Value: 'BlockedForParty'
BlockedForInspection	BlockedForInspection value. Stored as -1. Database Value: -1 Model Value: -1 Domain API Value: 'BlockedForInspection'

Supported Filters: Equals, EqualsIn
Supports Order By: False
Default Value: 0
Show in UI: ShownByDefault

Reference Details

BlockedForDocument

If non-null, contains the document for which the lot is blocked. Filter(multi eq)

Type: Documents (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

BlockedForParty

Non-null when the warehouse lot is blocked specifically for some party. Filter(multi eq)

Type: Parties (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

CertificateDocument

Document, containing the certificate for this lot. Filter(multi eq)

Type: Documents (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

ExciseMeasuringTransaction

When the lot was created in an excise controlled environment, specifies the measuring transaction which was used to create the lot. Filter(multi eq) Introduced in version 21.1.1.59

Type: MeasuringTransactions (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

Product

The product to which the lot is bound. Required Filter(multi eq) Owner

Type: Products
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Show in UI: ShownByDefault

ReceiptStoreTransaction

The store receipt transaction, which created the lot. null if the lot is manually created. Filter(multi eq)

Type: StoreTransactions (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

API Methods

Methods that can be invoked in public APIs.

GetAllowedCustomPropertyValues

Gets the allowed values for the specified custom property for this entity object. If supported the result is ordered by property value. Some property value sources do not support ordering - in that case the result is not ordered.
Return Type: Collection Of CustomPropertyValue
Declaring Type: EntityObject
Domain API Request: GET

Parameters

customPropertyCode
The code of the custom property
Type: string
search
The search text - searches by value or description. Can contain wildcard character %.
Type: string
Optional: True
Default Value: null
exactMatch
If true the search text should be equal to the property value
Type: boolean
Optional: True
Default Value: False
orderByDescription
If true the result is ordered by Description instead of Value. Note that ordering is not always possible.
Type: boolean
Optional: True
Default Value: False
top
The top clause - default is 10
Type: int32
Optional: True
Default Value: 10
skip
The skip clause - default is 0
Type: int32
Optional: True
Default Value: 0

CreateNotification

Create a notification immediately in a separate transaction, and send a real-time event to the user.
Return Type: void
Declaring Type: EntityObject
Domain API Request: POST