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

Id

Unique identification of this inventory across all subscribers and territories.

id Long Read only

Context id

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

contextId Long Context

Time created

The time of creation of this inventory.

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

Last count

The time of the last count of this inventory.

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

Cost price

The cost of the goods included in this inventory.

costPrice BigDecimal Read only

Qty remaining

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

numItemsRemaining Long Read only

Qty. posted

Number of items posted to the item ledger.

numItemsPosted Long Read only

Batch number

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

See also

batchNumber String Length 0 to 250

Expiration date

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

See also

expirationDate Date Format yyyy-MM-dd

Time placed

Time when inventory is set at the current location.

timePlacedAtCurrentLocation Date Format 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 Date Format yyyy-MM-dd'T'HH:mm:ss.SSS'Z' Read only

Status

Specifies inventory status.

lotStatus GlobalTradeItemLotStatus Not Null

Inventory date

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

inventorySortDate Date Not Null Format yyyy-MM-dd

Location

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

locationNumber String Not Null Location

Zone

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

zoneName String Read only

Zone id

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

zoneId Long Read only

GTIN

Barcode for the trade item contained in this lot.

globalTradeItemNumber String Length 0 to 36

SKU

SKU for the item as this is a stock of.

stockKeepingUnit String GlobalTradeItem

Value

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

value BigDecimal Read only

Trade item ID

Unique identification of the trade item contained in this lot.

globalTradeItemId Long GlobalTradeItem

Location id

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

locationId Long Location

Product id

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

productId Long Read only Location

Product number

Number of the product contained in this item lot.

productNumber String Read only

Product name

Name of the product contained in this item lot.

productName String Read only

Qty. contained

The quantity of the product contained within on trade item.

numUnitsContained Long Read only

Product unit

Unit of the product contained in this item lot.

productUnit ProductUnit Read only

Age

Age of this lot in days.

ageInDays Integer Read only

Variant

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

productVariantKey ProductVariantKey Read only

Standard cost price

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

standardCostPrice BigDecimal Read only

Filter

SKU

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

stockKeepingUnitMatch String

Product number

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

productNumberMatch String

Product name

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

productNameMatch String

Location

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

locationNumberMatch String

Storage date before

Only show stocks that have inventory date before this date.

inventorySortDateBefore Date

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

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

Max number left

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

maxNumItemsRemaining Long

Max number posted

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

maxNumItemsPosted Long

Status

Show only inventories with this status.

lotStatus GlobalTradeItemLotStatus

Batch number

Show only inventory where batch number matches this term.

batchNumberMatch String

Expiration date

Only show item lots with this expiration date.

expirationDate Date

Days to expiry

Show only stocks that expire within this number of days.

daysToExpirationDate Integer

Only non-pickable

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

onlyNotPickable Boolean

Varekategori

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

itemCategoryNameMatch String

Only old

Show only old lots.

onlyOld Boolean

Not pending count

Only show those item lots that are not pending count.

onlyNotPendingCount Boolean

Only moved after counted

Show only item lots with transactions after latest stock taking.

onlyMovedSinceLastStockTaking boolean

Delivery number

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

inboundShipmentNumberMatch String

Put-away list

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

putAwayListNumber Long