You are here:
Distributor Purchase Order Management Data Model
The Distributor Purchase Order Management data model includes objects and fields that you can use to track purchase orders with distributors, document the physical receipt of goods, and verify specific product attributes for batch-tracked and serialized items during the receiving process.
Required Editions
Available in: Lightning Experience Available in: Enterprise, Unlimited, and Developer Editions |
Purchase Order
An operational document issued by a buyer to a seller that specifies the types, quantities, and negotiated prices for products. It serves as the parent record for tracking fulfillment status and total order amount.
Purchase Order Item
A specific product and quantity requested as part of a purchase order. It tracks the ordered quantity versus the physically received quantity to determine fulfillment status.
Goods Received Note
A record that documents the arrival of products at a specific location, such as a warehouse. It acts as the source of truth for physical inventory updates and is typically linked to a Purchase Order.
Goods Received Note Item
A product line item within a Goods Received Note. It captures the physically received quantity, excess quantity, shortage quantity, and unusable quantity. Used in the inventory sync logic to update the associated Product Item.
Goods Received Note Item Production Batch
Links a Goods Received Note Item to a specific Production Batch. It stores production batch level details for a Goods Received Note (GRN) item, including received quantity and unusable quantity.
Goods Received Note Item Serialized Product
Links a Goods Received Note Item to individual Serialized Product records. It represents an individual serialized unit received against a Goods Received Note item. Includes Is Unusable (checkbox) and Unusable Type (picklist) fields to track unusable serialized units.
Goods Received Note Item Unusable Quantity Detail
Breaks down a Goods Received Note Item's unusable quantity by type (for example, part damaged, part expired). Each record represents one unusable type for a GRN item. Includes Last Synced Quantity for incremental sync tracking.
Goods Received Note Item Product Batch Unusable Quantity Detail
Breaks down a Goods Received Note Item Production Batch's unusable quantity by type (for example, part damaged, part expired). Each record represents one unusable type for a batch-tracked GRN item. Includes Last Synced Quantity for incremental sync tracking.
Production Batch
Represents the batch of homogeneous products manufactured in the same production line. In the DMS data model, this is used to verify that the batch being received matches the product defined on the Purchase Order.
Serialized Product
Stores the serial numbers for each individual product in an inventory. DMS uses this to track the specific units added to the quantity-on-hand during a GRN sync.
Product Item
The stock for a product at a specific inventory location. DMS automatically updates quantity-on-hand and quantity-unusable in this object when a user clicks Update Inventory on a Goods Received Note. Quantity Available is calculated as Quantity On Hand − Quantity Allocated − Quantity Unusable.
Product Item Transaction
A record created automatically during the inventory sync process to provide an audit trail of changes (adjustments or replenishments) to the stock levels based on GRN data.
Product Item Quantity Detail
Tracks a breakdown of a product item's unusable quantity by type (for example, part of the quantity is damaged and part is expired). Each record represents one Product Item State and Type combination for a product item.
Product Batch Item Quantity Detail
Tracks the same quantity breakdown by type for a product batch item.
Product Item Additional Transaction
Records transactions affecting a product item's or product batch item's quantity state (such as Unusable). Includes Transaction Type, Transaction Status, Transaction Date, and Quantity, along with Product Item State and Unusable Quantity Type.
