inventoryAssignment
Tracks inventory assignments across different locations or transactions to ensure accurate stock tracking.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for this inventory assignment entry. This value is automatically generated by the system and is used for referencing specific records. | |
| bin | String | The designated storage location within a warehouse or distribution center where the inventory item is stored. Bin numbers help track and manage stock efficiently. | |
| inventorynumber | String | The unique serial or lot number assigned to a specific inventory item is used for tracking purposes and ensures the traceability of stock movements. | |
| inventorystatus | String | The current status of the inventory item, indicating its availability or restriction. Possible statuses may include 'Available,' 'On Hold,' or 'Reserved.' | |
| quantity | Decimal | The total number of units for the specified inventory item allocated to a transaction, reflecting the exact amount taken from stock. | |
| transaction | String | The transaction record associated with this inventory assignment, such as a sales order, transfer order, or work order, helps track inventory movement. |