Thetis IMS
Datakatalog

Transaction

Definition

Transactions in and out of the warehouse.

InventoryTransaction

Fields

Id

Unique identification of this transaction.

id Long Read only

Context id

Unique identification of the context that this transaction belongs to.

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 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 Read only

Time of reversal

Time of the reversal of this transaction.

reversalTransactionTimeMade Date Read only

Batch no.

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

batchNumber String Read only

Exp. date

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

expirationDate Date Format yyyy-MM-dd Read only

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

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

HS Code

HS code of the product that this transaction refers to.

harmonizedSystemCode String Read only

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 Read only

Purchase order id

Unique identification of the purchase order that this transaction refers to.

inboundShipmentId Long Read only InboundShipment

Purchase order no.

The number of the purchase order that this transaction refers to.

inboundShipmentNumber String Read only

Supplier id

Unique identification of the supplier that this transaction refers to.

supplierId Long Read only Supplier

Customer id

Unique identification of the customer that this transaction refers to.

customerId Long Read only Customer

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 Read only

Purchase order line id

Unique identification of the purchase order 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 Read only

Acc. qty

The number of items on stock after this transaction.

accumulatedNumItems Long Read only

Location id

Unique identification of the location of the item lot when the transaction took place.

locationId Long Read only ReturnShipment

Location no.

Location of the item lot at the time of this transaction.

locationNumber String Read only

Discrepancy cause

If this transaction was caused by a count, what was then the cause of the discrepancy?

discrepancyCause DiscrepancyCause Read only

Notes on counting

If this transaction was caused by a count, what notes were made at the time of the count?

notesOnCounting String Read only