Table of Contents

Logistics.Inventory.StoreTransactionLines Entity

Namespace: Logistics.Inventory

Details records of Transactions. Each detail contains the movement for one product. Entity: Inv_Transaction_Lines

Default Visualization

Default Display Text Format:
{LineNo}. {TransactionObj.DocumentNo} {TransactionObj.DocumentType.TypeName:T}
Default Search Members:
TransactionObj.DocumentNo
Category: Definitions
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:
Logistics.Inventory.StoreTransactions
Aggregate Root:
Logistics.Inventory.StoreTransactions

Attributes

Name Type Description
AllowOverExecution boolean When true, specifies, that we explicitly allow over-execution. Over-execution is when the quantity in all execution lines exceed the quantity in the parent store order line. Required Default(false)
CurrentBalanceBase Quantity The current balance of the product in the selected store and enterprise company. If lot, serial number or product variant are specified the quantity is calculated accordingly.
DisplayText string Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.
Finished boolean nullable True if this transaction entry completes the operation. false if there might be more entries. Default(false) Filter(eq)
GuaranteePeriodDays int32 nullable Guarantee period in days for the offered product. null for non-serviced products.
Id guid
LineBaseCost Amount (14, 2) The cost of the transaction in the currency of the enterprise company. Currency: TransactionObj.EnterpriseCompany.BaseCurrency Required Default(0)
LineCost Amount (14, 2) Total cost for the line. Currency: TransactionObj.DocumentCurrency Required Default(0)
LineDocumentCost Amount (14, 2) The cost of the transaction in the currency of the document. Currency: TransactionObj.DocumentCurrency Required Default(0) ReadOnly
LineNo int32 Line number, unique within the store transaction. Required
LineProductCost Amount (14, 2) The cost of the transaction in the currency of the product. Currency: Product.CostingCurrency Required Default(0) ReadOnly
LineStoreCost Amount (14, 2) The cost of the transaction in the currency of the warehouse. Currency: TransactionObj.Store.Currency Required Default(0) ReadOnly
Notes string (254) nullable Notes for this StoreTransactionLine.
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.
ParentLineId guid nullable Used, when transaction lines are generated directly from other entities (different from Store Order). Denotes the Id of the parent document line, which generated the transaction line. Filter(multi eq)
ParentLineNo int32 nullable The number of the line within the parent document, which the current line executes. null when the current line does not execute line.
Quantity Quantity (18, 3) The quantity received/issued in the measurement unit, specified in Quantity_Unit_Id. null means that the quantity is specified only in base measurement unit. Unit: QuantityUnit Required Default(0)
QuantityBase Quantity (18, 3) The quantity of the stock received/issued in base measurement unit. Unit: Product.BaseMeasurementCategory.BaseUnit Required Default(0) Filter(ge;le)
StandardQuantityBase Quantity (18, 3) The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. Unit: Product.BaseMeasurementCategory.BaseUnit Required ReadOnly Introduced in version 18.2
TempOrderNo string (50) nullable Obsolete. Not used. Filter(eq)
TransactionTimestamp datetime nullable Exact time when the transaction changes the cost of the product. Filter(ge;le) ORD
UnitCost Amount (14, 5) Cost for 1 of the specified quantity. Currency: TransactionObj.DocumentCurrency Required Default(0)

References

Name Type Description
Document StoreTransactions The transaction to which the transaction line belongs. Required Filter(multi eq)
Lot Lots (nullable) If non-null, contains the specific lot to use for the movement. Filter(multi eq)
OriginalProduct Products (nullable) When specified, contains the original product, which was ordered to be received or issued. The actual product is recorded in the Product field. Deprecated. Use Parent Store Order Line.Product instead. Filter(multi eq)
ParentDocument Documents (nullable) The document, which the current line executes. null when the current line does not execute another line. Filter(multi eq)
ParentStoreOrderLine StoreOrderLines (nullable) The line, containing the ordered quantity, which this execution line executes. Filter(multi eq)
Product Products The item that was received/issued. Required Filter(multi eq)
ProductCode ProductCodes (nullable) Used to set the Product_Id thru the coding systems. Filter(multi eq)
ProductVariant ProductVariants (nullable) If specified determines which product variant of the current product in this line is used. Filter(multi eq)
QuantityUnit MeasurementUnits The measurement unit of Quantity. null means that the quantity is specified only in base measurement unit. Required Filter(multi eq)
SerialNumber SerialNumbers (nullable) Item serial number for serialized items. null for non-serialized items. Filter(multi eq)
StoreBin StoreBins (nullable) Store bin, from/to which the transaction was performed. Filter(multi eq)
TransactionObj StoreTransactions The transaction to which the transaction line belongs. Required Filter(multi eq) Owner

Attribute Details

AllowOverExecution

When true, specifies, that we explicitly allow over-execution. Over-execution is when the quantity in all execution lines exceed the quantity in the parent store order line. Required Default(false)

Type: boolean
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: False
Show in UI: HiddenByDefault

CurrentBalanceBase

The current balance of the product in the selected store and enterprise company. If lot, serial number or product variant are specified the quantity is calculated accordingly.

Type: Quantity
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
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

Finished

True if this transaction entry completes the operation. false if there might be more entries. Default(false) Filter(eq)

Type: boolean nullable
Category: System
Supported Filters: Equals
Supports Order By: False
Default Value: False
Show in UI: HiddenByDefault

GuaranteePeriodDays

Guarantee period in days for the offered product. null for non-serviced products.

Type: int32 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
obj.Product.GuaranteePeriodDays

Id

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

LineBaseCost

The cost of the transaction in the currency of the enterprise company. Currency: TransactionObj.EnterpriseCompany.BaseCurrency Required Default(0)

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: HiddenByDefault

LineCost

Total cost for the line. Currency: TransactionObj.DocumentCurrency Required Default(0)

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

LineDocumentCost

The cost of the transaction in the currency of the document. Currency: TransactionObj.DocumentCurrency Required Default(0) ReadOnly

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: HiddenByDefault

LineNo

Line number, unique within the store transaction. Required

Type: int32
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

Back-End Default Expression:
( obj.TransactionObj.Lines.Select( c => c.LineNo).DefaultIfEmpty( 0).Max( ) + 10)

Front-End Recalc Expressions:
( obj.TransactionObj.Lines.Select( c => c.LineNo).DefaultIfEmpty( 0).Max( ) + 10)

LineProductCost

The cost of the transaction in the currency of the product. Currency: Product.CostingCurrency Required Default(0) ReadOnly

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: HiddenByDefault

LineStoreCost

The cost of the transaction in the currency of the warehouse. Currency: TransactionObj.Store.Currency Required Default(0) ReadOnly

Type: Amount (14, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: HiddenByDefault

Notes

Notes for this StoreTransactionLine.

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

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

ParentLineId

Used, when transaction lines are generated directly from other entities (different from Store Order). Denotes the Id of the parent document line, which generated the transaction line. Filter(multi eq)

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

ParentLineNo

The number of the line within the parent document, which the current line executes. null when the current line does not execute line.

Type: int32 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Quantity

The quantity received/issued in the measurement unit, specified in Quantity_Unit_Id. null means that the quantity is specified only in base measurement unit. Unit: QuantityUnit Required Default(0)

Type: Quantity (18, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

QuantityBase

The quantity of the stock received/issued in base measurement unit. Unit: Product.BaseMeasurementCategory.BaseUnit Required Default(0) Filter(ge;le)

Type: Quantity (18, 3)
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Default Value: Constant
Show in UI: HiddenByDefault

Back-End Default Expression:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.QuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

Front-End Recalc Expressions:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.QuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

StandardQuantityBase

The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. Unit: Product.BaseMeasurementCategory.BaseUnit Required ReadOnly Introduced in version 18.2

Type: Quantity (18, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: HiddenByDefault

Back-End Default Expression:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.StandardQuantityBase, IIF( obj.Product.AllowVariableMeasurementRatios, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product), obj.QuantityBase))

Front-End Recalc Expressions:
IIF( ( ( ( obj.Quantity == null) OrElse ( obj.QuantityUnit == null)) OrElse ( obj.Product == null)), obj.StandardQuantityBase, obj.Quantity.ConvertTo( obj.Product.BaseUnit, obj.Product))

TempOrderNo

Obsolete. Not used. Filter(eq)

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

TransactionTimestamp

Exact time when the transaction changes the cost of the product. Filter(ge;le) ORD

Type: datetime nullable
Indexed: True
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: HiddenByDefault

UnitCost

Cost for 1 of the specified quantity. Currency: TransactionObj.DocumentCurrency Required Default(0)

Type: Amount (14, 5)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Default Value: Constant
Show in UI: ShownByDefault

Reference Details

Document

The transaction to which the transaction line belongs. Required Filter(multi eq)

Type: StoreTransactions
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

Lot

If non-null, contains the specific lot to use for the movement. Filter(multi eq)

Type: Lots (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

OriginalProduct

When specified, contains the original product, which was ordered to be received or issued. The actual product is recorded in the Product field. Deprecated. Use Parent Store Order Line.Product instead. Filter(multi eq)

Type: Products (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Front-End Recalc Expressions:
obj.Product

ParentDocument

The document, which the current line executes. null when the current line does not execute another line. Filter(multi eq)

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

ParentStoreOrderLine

The line, containing the ordered quantity, which this execution line executes. Filter(multi eq)

Type: StoreOrderLines (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

Product

The item that was received/issued. Required Filter(multi eq)

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

Front-End Recalc Expressions:
obj.OriginalProduct

ProductCode

Used to set the Product_Id thru the coding systems. Filter(multi eq)

Type: ProductCodes (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

ProductVariant

If specified determines which product variant of the current product in this line is used. Filter(multi eq)

Type: ProductVariants (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

QuantityUnit

The measurement unit of Quantity. null means that the quantity is specified only in base measurement unit. Required Filter(multi eq)

Type: MeasurementUnits
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

SerialNumber

Item serial number for serialized items. null for non-serialized items. Filter(multi eq)

Type: SerialNumbers (nullable)
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

StoreBin

Store bin, from/to which the transaction was performed. Filter(multi eq)

Type: StoreBins (nullable)
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault

TransactionObj

The transaction to which the transaction line belongs. Required Filter(multi eq) Owner

Type: StoreTransactions
Indexed: True
Category: System
Supported Filters: Equals, EqualsIn
Filterable Reference: True
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

Parameters

  • user
    The user.
    Type: Users

  • notificationClass
    The notification class.
    Type: string

  • subject
    The notification subject.
    Type: string

CreateCopy

Duplicates the object and its child objects belonging to the same aggregate. The duplicated objects are not saved to the data source but remain in the same transaction as the original object.
Return Type: EntityObject
Declaring Type: EntityObject
Domain API Request: POST

Business Rules

Front-End Business Rules

API

Domain API Query: https://demodb.my.erp.net/api/domain/odata/Logistics_Inventory_StoreTransactionLines?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_StoreTransactionLines?$top=10

Suggest improvement to this page