Inventory Ledger¶

Table name (referenced in Insights SQL queries): marts_mdc__inventory_ledger

Columns¶

Column	Type	Description
`inventory_transaction_id`	`number`	Unique numerical id of inventory transaction in the inventory ledger
`warehouse_name`	`varchar`	Name of the warehouse where inventory transaction occurred
`warehouse_id`	`number`	Unique identifier of warehouse where inventory transaction occurred
`account_name`	`varchar`	Name of the account owning the inventory
`account_id`	`number`	Unique identifier of the account owning the inventory
`transaction_recorded_at_utc`	`timestamp_ntz`	UTC timestamp when the inventory transaction occurred in the warehouse (i.e. not including backdating due to Inventory Audit)
`transaction_created_at_utc`	`timestamp_ntz`	UTC timestamp when the inventory ledger transaction was formally created (possibly backdated for the purpose of Inventory Audit)
`transaction_entity`	`varchar`	Type of the associated entity to the given inventory transaction, if applicable one of: order, receiving, return, inventory_audit
`transaction_entity_id`	`varchar`	Unique identifier of the associated entity to the given inventory transaction, if applicable one of: Order id, Receiving id, Return id, Inventory Audit uuid
`entity_number`	`varchar`	Natural identifier of the associated entity to the given inventory transaction, if applicable one of: Order number, Receiving ASN, Return RMA, Inventory Audit name
`received_at_utc`	`timestamp_ntz`	UTC timestamp indicating when the inventory has been received (applicable only to receiving related transactions)
`detail`	`varchar`	URL link to the page with details about the associated entity to the given inventory transaction
`category`	`varchar`	Main category of the inventory transaction, one of: received, shipped, in_research, adjustments
`category_detail`	`varchar`	Subcategory of the inventory transaction
`sku`	`varchar`	SKU of the product
`product_id`	`number`	Unique identifier of the product
`product_name`	`varchar`	Name of the product
`product_type`	`varchar`	Type of the product, one of pick_and_pack, insert, packaging
`lot_number`	`varchar`	Lot number of the inventory
`lot_expiration_date`	`varchar`	Expiration date of the inventory
`quantity`	`number`	Inventory quantity change caused by the transaction
`location_timezone`	`varchar`	Local timezone in the facility, where the inventory transaction occurred