Thetis IMS
Datakatalog

Transaction

Transactions in and out of the warehouse.

InventoryTransaction

Fields

Id

Unique identification of this transaction.

id Long Read only

inventoryTransaction.contextId

inventoryTransaction.contextId.description

contextId Long Read only Context

Time made

The time at which this adjustment was made

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

Made by

The initials of the user who made this adjustment.

madeByInitials String Read only

Product group

Name of the product group that this transaction refers to.

productGroupName String Read only

Product no.

The number of the product that this transaction refers to.

productNumber String Read only

Product name

The name of the product that this transaction refers to.

productName String Read only

SKU

SKU for the trade item that this transaction refers to.

stockKeepingUnit String Read only

Type

The type of transaction.

transactionType TransactionType Read only

Quantity

The quantity adjusted.

numItems Long Read only

Value

The value of the lot at the time of this transaction.

value BigDecimal Read only

Quantity posted

The number of items that have been posted from this transaction.

numItemsPosted Long Read only

Reverses

Unique identification of the transaction that this transaction reverses.

reversedTransactionId Long Read only

Reversal

Unique identification of the transaction that reverses this transaction.

reversalTransactionId Long

Time of reversal

Time of the reversal of this transaction.

reversalTransactionTimeMade Date

Tracking no.

Tracking number of the item lot that this transaction refers to.

trackingNumber String

Batch no.

The batch number of the item lot that this transaction refers to.

batchNumber String

Exp. date

Expiration date of the item lot that this transaction refers to.

expirationDate Date Format yyyy-MM-dd

Inventory date

Inventory date for the item lot that this transaction refers to.

inventorySortDate Date Format yyyy-MM-dd

GTIN

The GTIN of the items contained in the item lot that this transaction refers to.

globalTradeItemNumber String

Product id

Unique identification of the product that this transaction refers to.

productId Long Read only Product

Trade item id

Unique identification of the trade item that this transaction refers to.

globalTradeItemId Long Read only GlobalTradeItem

Item lot id

Unique identification of the item lot that this transaction refers to.

globalTradeItemLotId Long Read only GlobalTradeItemLot

Reservation id

Unique identification of the reservation that this transaction refers to.

reservationId Long Read only Reservation

Shipping container id

Unique identification of the shipping container that the items that this transaction refers to are packed to.

shippingContainerId Long Read only ShippingContainer

Repacked to id

Unique identification of the item lot that the items that this transaction refers to were repacked to.

repackedToLotId Long Read only GlobalTradeItemLot

Bundled to id

Unique identification of the item lot that the items that this transaction refers to were bundled to.

bundledToLotId Long Read only GlobalTradeItemLot

Splitted to id

Unique identification of the item lot that the items that this transaction refers to were splitted to.

splittedToLotId Long Read only GlobalTradeItemLot

Stock taking line id

Unique identification of the stock taking line that this transaction refers to.

stockTakingLineId Long Read only StockTakingLine

Packed item id

Unique identification of the packed items related to this transaction.

globalTradeItemInstanceId Long

HS Code

HS code of the product that this transaction refers to.

harmonizedSystemCode String

Shipment id

Unique identification of the shipment that this transaction refers to.

shipmentId Long Read only Shipment

Shipment no.

The number of the shipment that this transaction refers to.

shipmentNumber String

Deliverance id

Unique identification of the deliverance that this transaction refers to.

inboundShipmentId Long Read only InboundShipment

Deliverance no.

The number of the deliverance that this transaction refers to.

inboundShipmentNumber String

Supplier id

Unique identification of the supplier that this transaction refers to.

supplierId Long Read only Supplier

Suppliernumber

The number of the supplier that this transaction refers to.

supplierNumber String

Customer id

Unique identification of the customer that this transaction refers to.

customerId Long Read only Customer

Customer no.

The number of the customer that this transaction refers to.

customerNumber String

Sales channel id

Unique identification of the sales channel related to the shipment that this transaction refers to.

sellerId Long Read only Seller

Sales channel no.

The number of the sales channel related to the shipment that this transaction refers to.

sellerNumber String

Inbound shipment line id

Unique identification of the inbound shipment line this transaction is related to.

inboundShipmentLineId Long Read only InboundShipmentLine

Shipment line id

Unique identification of the shipment line this transaction is related to.

shipmentLineId Long Read only ShipmentLine

Return Shipment line id

Unique identification of the return shipment line this transaction is related to.

returnShipmentLineId Long Read only ReturnShipmentLine

Return Shipment id

Unique identification of the return shipment this transaction is related to.

returnShipmentId Long Read only ReturnShipment

Return Shipment no.

The number of the return shipment that this transaction refers to.

returnShipmentNumber String

Acc. qty

The number of items on stock after this transaction.

accumulatedNumItems Long

Acc. value

Total value after this transaction.

accumulatedValue BigDecimal

Filter

Product group

Show only transaction related to products belonging to a product group with a name that matches this expression.

productGroupNameMatch String

Product number

Show only transactions related to product with numbers matching this expression.

productNumberMatch String

SKU

Show only transactions on trade items with SKU matching this expression.

stockKeepingUnitMatch String

Time made interval

Show only transactions made in this time interval.

timeMadeInterval CommonTimeInterval

Transaction type

Show only transactions of this type.

transactionType TransactionType

Only not reversed

Show only transactions that have not been reversed.

onlyNotReversed Boolean

Inbound shipment

Show only inbound shipments matching this expression.

inboundShipmentNumberMatch String

inventoryTransactionFilter.shipmentNumberMatch

inventoryTransactionFilter.shipmentNumberMatch.description

shipmentNumberMatch String