inv_level
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. Reserved inventory condition values in AWS Supply Chain are as follows:
|
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 |