Power BI Connector for Vault CRM

Build 25.0.9454

SampleReceipts

Stores data about the receipt of physical or digital sample products, including received quantities, dates, and recipient information. This is useful for verifying delivery completion and maintaining audit trails.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the sample receipt record in the system.

Sample Receipt Type String True

Specifies the type of sample receipt, as defined by the Vault object type configuration.

Global ID String True

System-generated global identifier used for data integration and cross-system referencing.

Link String False

System-generated hyperlink pointing to the detailed Vault record for this sample receipt.

Receipt Id String True

Human-readable identifier for the receipt, typically used for labeling and tracking purposes.

Status String False

Current lifecycle status of the sample receipt, such as Draft, Submitted, or Completed.

Created By String True

Username of the individual who created the sample receipt record.

Created Date Datetime True

Timestamp indicating when the sample receipt record was initially created.

Last Modified By String True

Username of the individual who most recently modified the sample receipt record.

Last Modified Date Datetime True

Timestamp indicating when the record was last updated in the system.

Cold Chain Status String False

Describes the integrity of the cold chain during shipment, indicating whether required temperature conditions were maintained.

Comments String False

General remarks or notes provided by the user about the sample receipt.

Confirmed Quantity Decimal False

The quantity of samples confirmed as received, typically verified against shipment documentation.

Custom Text String False

Optional custom text field for capturing additional context or internal references.

Lot # Name String False

Descriptive name or label associated with the sample lot involved in this receipt.

Quantity Decimal False

Total number of sample units expected or recorded in the receipt.

Receipt Comments String False

Additional comments specifically related to the receipt transaction, such as handling notes or discrepancies.

Received Bool False

Indicates whether the sample has been physically received (true) or not (false).

Sample String False

Reference to the specific sample item being received, typically linking to a product or compound.

Shipment Id String False

Identifier for the related shipment, allowing traceability between receipt and shipment records.

Tag Alert Number String False

Unique alert number associated with the shipment's temperature tag or monitoring device, if applicable.

Transferred Date Date False

Date on which the sample was transferred from the previous location or owner.

Transferred From Name String False

Name of the source location or individual from whom the sample was transferred.

U/M String False

Unit of measure for the quantity received, such as mL, tablet, or vial.

Lot # String False

Identifier for the lot associated with the received sample, used for tracking and quality control.

Ref Order Transaction Id String False

Reference to the original order transaction that triggered or is related to this receipt.

Transferred From String False

Vault reference to the entity (such as a user or location) from which the sample was transferred.

Legacy CRM Id String False

Identifier used in legacy Customer Relationship Management (CRM) systems for backward compatibility and historical referencing.

Ref Transaction Id String False

Reference to another transaction, such as a prior receipt or distribution event, linked to this record.

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