inv_level - AWS Supply Chain

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:

  • Unrestricted - Inventory is available.

  • Inspection - Below quality or any other inspection.

  • Returns - Inventory goes to return area.

  • Blocked - Inventory is blocked for a reason.

  • InTransfer - Used during inventory stock transfer.

  • Restricted - Restricted for other reasons but not blocked.

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