Thetis IMS
Datakatalog

Item lot

Definition

An item lot covers a number of items received collectively and located in the same location with the same status.

GlobalTradeItemLot

Constraints

You must provide either an id or a SKU for a trade item.

Fields

Age

Age of this lot in days.

ageInDays
Read only

Batch number

Identification of the batch that these goods are produced as part of.

See also

batchNumber
Size max: 250 min: 0

Context id

Unique identification of the context in which this item lot is created.

contextId

Cost price

The cost of the goods included in this inventory.

costPrice
Read only

Expiration date

Date of expiry of the product and therefore no longer applicable.

See also

expirationDate
Format pattern: yyyy-MM-dd

Trade item ID

Unique identification of the trade item contained in this lot.

globalTradeItemId

GTIN

Barcode for the trade item contained in this lot.

globalTradeItemNumber
Size max: 36 min: 0

Id

Unique identification of this inventory across all subscribers and territories.

id
Read only

Inventory date

Date used to sort inventory - for example, in the case of product withdrawals.

inventorySortDate
NotNull
Format pattern: yyyy-MM-dd

Location id

Unique identification of the location on which this inventory is located.

locationId

Location

The number of the location at which the inventory is located right now.

locationNumber
NotNull

Status

Specifies inventory status.

lotStatus
NotNull

Qty. posted

Number of items posted to the item ledger.

numItemsPosted
Read only

Qty remaining

Number of items not yet sold or moved to another inventory.

numItemsRemaining
Read only

Qty. contained

The quantity of the product contained within on trade item.

numUnitsContained
Read only

Product id

Unique identification of the product contained in the trade items in this lot.

productId
Read only

Product name

Name of the product contained in this item lot.

productName
Read only

Product number

Number of the product contained in this item lot.

productNumber
Read only

Product unit

Unit of the product contained in this item lot.

productUnit
Read only

Variant

Properties that identifies the trade item of this lot as a variant of the product.

productVariantKey
Read only

Standard cost price

Standard cost price for the trade item contained in this lot.

standardCostPrice
Read only

SKU

SKU for the item as this is a stock of.

stockKeepingUnit

Time created

The time of creation of this inventory.

timeCreated
Format pattern: yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
Read only

Last movement

Time of last movement of goods in or out of this inventory.

timeLastMovement
Format pattern: yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
Read only

Last count

The time of the last count of this inventory.

timeLastStockTaking
Format pattern: yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
Read only

Time placed

Time when inventory is set at the current location.

timePlacedAtCurrentLocation
Format pattern: yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
Read only

Value

The value of the goods remaining in stock from this inventory.

value
Read only

Zone id

Unique identification of the zone where this item lot is currently placed.

zoneId
Read only

Zone

Name of the zone where this item lot is currently placed.

zoneName
Read only

Fields in filter

Batch number

Show only inventory where batch number matches this term.

batchNumberMatch String

Days to expiry

Show only stocks that expire within this number of days.

daysToExpirationDate Integer

Expiration date

Only show item lots with this expiration date.

expirationDate Date

Delivery number

Show only inventory received on purchase orders whose numbers match this term.

inboundShipmentNumberMatch String

Storage date before

Only show stocks that have inventory date before this date.

inventorySortDateBefore Date

Varekategori

Vis kun beholdninger af varer fra varekategorier hvis navn matcher dette udtryk.

itemCategoryNameMatch String

Location

Search terms as numbered at the location where the inventory is located must match to appear.

locationNumberMatch String

Status

Show only inventories with this status.

lotStatus GlobalTradeItemLotStatus

Max number posted

Show only lots where there is less than this amount posted.

maxNumItemsPosted Long

Max number left

Show only inventories where there is less than this amount left.

maxNumItemsRemaining Long

Days since last count

Show only trade item that is not counted within this number of days.

minDaysSinceLastStockTaking Integer

Only count required

Show only the trade items that need to be taken stock of.

onlyDueForStockTaking Boolean

Only moved after counted

Show only item lots with transactions after latest stock taking.

onlyMovedSinceLastStockTaking boolean

Not pending count

Only show those item lots that are not pending count.

onlyNotPendingCount Boolean

Only non-pickable

Show only inventories that are not in the pick-up location of the item.

onlyNotPickable Boolean

Only old

Show only old lots.

onlyOld Boolean

Only current

Show only inventories that have not yet been split or sold in full.

onlyRemaining Boolean

Only value

Show only item lots with a value.

onlyValue Boolean

Product name

Show only lots of items containing products with a name matching this expression.

productNameMatch String

Product number

Expressions that the product number must match to display the inventory.

productNumberMatch String

Put-away list

Only show item lots that are on the put-away list with this number.

putAwayListNumber Long

SKU

Show only inventory of items with a SKU that matches this term.

stockKeepingUnitMatch String