NameDescriptionTypeAdditional information
id

Primary Key

globally unique identifier
article_stock_location_id

Foreign key of the article_stock_location

globally unique identifier
article_id

Foreign key of article

globally unique identifier
quantity

Quantity in stock for this article, for this stock. Decimal since PORTAL-11899 / FSA-6229 (decimal(18,2) in the database), so it can hold values such as 2.5; whole quantities are returned as before.

decimal number
sys_computed_eco_stock

Readonly: last computed economic stock quantity (accounting for reservations/thresholds) for this article at this location.

decimal number
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date