Inventory movements
A change in the quantity and value of an item's inventory at a site, caused by a document.
- API name:
inventorymovements - Domain: Inventory
- Modules: Inventory analytics, Inventory, Manufacturing
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Item | productitemId | Reference | ||
| Movement post date | date | Date | Calendar date for this value. | |
| Quantity | quantity | Quantity | Yes | Units requested on the source document when this movement was created. This is the amount the system will attempt to apply when the movement is processed. |
| Item | customitemId | Reference | ||
| Identifier | inventoryidentifierId | Reference | ||
| Catalog | catalog | Constant | Yes | Fixed option from the allowed set for this field. |
| Unit | catalogunit | Unit | ||
| Record | tableUid | Constant | Yes | Business table this row points to. |
| Record ID | recordId | Reference | Yes | |
| Kind | kind | Constant | Yes | Fixed option from the allowed set for this field. |
| Method | method | Constant | Yes | Indicates whether the movement increases or decreases inventory (add or subtract). |
| Bucket | bucket | Constant | Yes | Bucket this movement changes: on hand, on hold, reserved, or in transit. |
| Unit cost | unitCost | Unit price | Cost of the inventory per unit. | |
| Movement value | movementValue | Currency | Monetary amount in the applicable currency for this record. | |
| Location | sitelocationId | Reference | Yes | |
| Zone | siteareaId | Reference | Yes | |
| User | userId | User | Yes | |
| Created at | createdAt | Date and Time | Yes | |
| Processed at | processedAt | Date and Time | ||
| Canceled by | canceledBy | User | ||
| Canceled at | canceledAt | Date and Time |
Relations
| Field | Points to | Kind |
|---|---|---|
Identifier inventoryidentifierId | Inventory identifiers | reference |
Location sitelocationId | Site locations | reference |
Zone siteareaId | Site areas | reference |