# inv\_level
<a name="inventory_mgmnt-inv-level-entity"></a>

**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| inv\_level | snapshot\_date, site\_id, product\_id, inv\_condition, lot\_number | 

The table below lists the column names supported by the data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
| snapshot\_date | timestamp | Yes1 | Date and time when the inventory snapshot was taken. | 
| site\_id2 | string | Yes1 | Site ID of the inventory. | 
| product\_id2 | string | Yes1 | Product ID of the inventory displayed. | 
| company\_id2 | string | No | Company ID. | 
| on\_hand\_inventory | double | Yes | Physical inventory available at the site. | 
| allocated\_inventory | double | No | Inventory allocated for some process. | 
| bound\_inventory | double | No | Inventory bound to some process. | 
| quantity\_uom | string | No | Quantity unit of measure for inventory. | 
| inv\_condition | string | Yes 1 | Condition of the inventory. Inventory in different conditions are displayed in different rows. You can also enter your own value.<br />Reserved inventory condition values in AWS Supply Chain are as follows:[See the AWS documentation website for more details](http://docs.aws.amazon.com/connect-decisions/legacy/userguide/inventory_mgmnt-inv-level-entity.html) | 
| lot\_number | string | Yes1 | Lot number of the inventory. | 
| expiry\_date | timestamp | No | Expiry date of the inventory. | 
| source\_update\_dttm | timestamp | No | Date time stamp of the update made in the source system. | 
| source\_event\_id | string | No | ID of the event created in the source system. | 
| tpartner\_id | string | No | Unique identifier for a trading partner. | 

1You must enter a value. When you ingest data from SAP or EDI, the default value for *string* date type value is SCN\_RESERVED\_NO\_VALUE\_PROVIDED.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| product\_id | Product | product | id | 
| company\_id | Organization | company | id | 
| site\_id | Network | site | id | 
| tpartner\_id | Organization | trading\_partner | id |