TrunkStocks
Tracks trunk stock inventory, including quantities and serial numbers for sub-inventories.
Columns
Name | Type | Description |
StockLocationId | Long | A unique identifier for the stocking location in the trunk stock system. It helps to identify and track the specific location where inventory is stored. |
OrganizationId [KEY] | Long | A unique identifier for the organization associated with the trunk stock. This is used to determine which organization the stock belongs to. |
OrganizationCode | String | The code representing the organization that manages or owns the trunk stock. It helps categorize and identify the organization in reports and operations. |
Subinventory [KEY] | String | The name or code of the subinventory within the organization where the trunk stock is stored. This field is used to classify stock at a more granular level within the organization. |
InventoryItemId [KEY] | Long | A unique identifier for the inventory item in the trunk stock system. This identifier links the trunk stock to the corresponding inventory item. |
ItemNumber | String | The item number used to identify the product or material in the trunk stock. This number provides a reference for inventory management. |
Revision | String | The revision number of the item in the trunk stock. It is used to track different versions or updates of the item in the inventory. |
ItemSerialControl | Decimal | Indicates the serial control applied to the item in the trunk stock. It tracks whether the item is managed by serial number. |
UOMCode | String | The unit of measure code that identifies how the trunk stock is measured. This code is used for inventory and transaction processing. |
UnitOfMeasure | String | The unit of measure used for the inventory item in the trunk stock. It is a descriptive term that identifies how the item is quantified, such as 'each' or 'box'. |
TotalQoh | Decimal | The total quantity on hand (QOH) of the item in the trunk stock. It represents the total amount of the item available for use or sale. |
TotalAvailable | Decimal | The total available quantity of the item in the trunk stock. It accounts for items that are not reserved or committed to other transactions. |
RecoveredPartDispCode | String | The recovery disposition code for parts in the trunk stock. It categorizes parts based on their condition, such as 'recovered' or 'scrapped'. |
SerialNumber [KEY] | String | The serial number of the item in the trunk stock. This number uniquely identifies each instance of the item, particularly useful for items tracked by serial number. |
TransactionDate | Datetime | The date and time when the transaction related to the trunk stock occurred. It is used to track the timing of inventory changes. |
ItemDescription | String | A description of the item in the trunk stock. It provides detailed information about the item, such as its function or specifications. |
Finder | String | The name of the finder function used to search and retrieve specific trunk stock records in the database. |