Power BI Connector for Vault CRM

Build 25.0.9454

SampleInventoryItems

Provides item-level granularity for entries in the sample inventory, linking specific product instances to their associated inventory records. This is useful for tracing lot numbers, expiry dates, and detailed inventory audits.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique system-generated identifier for the sample inventory item record within Veeva Vault.

Sample Inventory Item Type String True

Specifies the Vault object type of the sample inventory item, used to determine business rules and record behavior.

Global ID String True

System-assigned globally unique identifier that ensures cross-environment uniqueness for the inventory item.

Link String False

System-generated hyperlink to the inventory item record within the Vault interface.

Sample Inventory Item Number String True

Human-readable identifier or code for the sample inventory item, often used for display and reference purposes.

Status String False

Current status of the sample inventory item in the workflow, such as Active, Inactive, or Archived.

Created By String True

Username or user ID of the individual who originally created the sample inventory item record.

Created Date Datetime True

Timestamp indicating when the sample inventory item record was first created in the system.

Last Modified By String True

Username or user ID of the last user who modified the sample inventory item record.

Last Modified Date Datetime True

Timestamp indicating the last time the sample inventory item record was updated.

Count Decimal False

Actual counted quantity of the sample product during a physical inventory process.

Expected Quantity Decimal False

System-expected quantity of the sample item based on historical inventory data or planned distribution.

Expiration Date Date False

The date on which the sample product lot expires and should no longer be used or distributed.

Lot # String False

Primary lot number associated with the sample inventory item, used for tracking and compliance purposes.

Mobile ID String False

Identifier generated by a mobile device during offline inventory actions; used to sync with Vault when reconnected.

Sample String False

Reference to the specific sample product associated with the inventory item, usually tied to a product catalog.

U/M String False

Unit of measure for the inventory item (for example, bottle, pack, blister), used to interpret count and expected quantities.

Unlock Bool False

Indicates whether the inventory item is editable (unlocked) or frozen (locked) from further changes during reconciliation.

Inventory Name String False

Name or label of the inventory event or audit session to which this sample inventory item belongs.

Lot #2 String False

Secondary lot number used for lookup or cross-referencing purposes, possibly derived from external systems.

Difference Decimal True

Numeric difference between the expected and actual count values, used to identify discrepancies during reconciliation.

Legacy CRM Id String False

Identifier referencing the item in a legacy Customer Relationship Management (CRM) system, maintained for backward compatibility or data migration.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454