--- schema_version: "1" id: 662c06ee56aa7b526a05d7753b347036ff34632033042b6445092d050d84a952 title: Sales Agreement Product DMO collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-salesagreementproductdmo-dmo.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesagreementproductdmo-dmo.html source_site: developer.salesforce.com content_type: documentation content_hash: 392dfddf9b8e3072fd5ca693791f9fa29dd12d70217c0383a6bb8cf40864013a products: - Data 360 DMO and Mapping Guide - Data 360 Developer Documentation --- # Sales Agreement Product DMO It records the total quantity/amount and default pricing information for a given product/product category across all time periods of the Sales Agreement. ## Object Properties **Object API Name:** `SalesAgreementProduct_std__dlm` **Category:** Unassigned **Availability:** Available in 260 and later versions **Primary Key Field:** Id ## Relationships - **SalesAgreementId** has a FOREIGNKEY relationship with the [Sales Agreement DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesagreementdmo-dmo.md) `Id` field. - **ProductId** has a FOREIGNKEY relationship with the [Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field. - **PriceBookEntryId** has a FOREIGNKEY relationship with the [Price Book Entry DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookentrydmo-dmo.md) `Id` field. - **SalesAgreementId** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **ProductCategoryId** has a FOREIGNKEY relationship with the [Product Category DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productcategorydmo-dmo.md) `Id` field. - **UnitOfMeasureId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field. ## Fields - [ActualMarginPercent](#actualmarginpercent) - [cdp_sys_record_currency](#cdp_sys_record_currency) - [CostPriceAmt](#costpriceamt) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [DiscountPercent](#discountpercent) - [Id](#id) - [InitialPlannedAmt](#initialplannedamt) - [InitialPlannedQuantity](#initialplannedquantity) - [InternalOrganizationId](#internalorganizationid) - [KQ_Id](#kq_id) - [KQ_PriceBookEntryId](#kq_pricebookentryid) - [KQ_ProductCategoryId](#kq_productcategoryid) - [KQ_ProductId](#kq_productid) - [KQ_SalesAgreementId](#kq_salesagreementid) - [KQ_UnitOfMeasureId](#kq_unitofmeasureid) - [ListPriceAmt](#listpriceamt) - [OwnerId](#ownerid) - [PlannedMarginPercent](#plannedmarginpercent) - [PriceBookEntryId](#pricebookentryid) - [ProductCategoryId](#productcategoryid) - [ProductId](#productid) - [SalesAgreementId](#salesagreementid) - [SalesPriceAmt](#salespriceamt) - [TotalActualAmt](#totalactualamt) - [TotalActualCostAmt](#totalactualcostamt) - [TotalActualMarginAmt](#totalactualmarginamt) - [TotalActualQuantity](#totalactualquantity) - [TotalActualShipmentQuantity](#totalactualshipmentquantity) - [TotalForecastedQuantity](#totalforecastedquantity) - [TotalPlannedCostAmt](#totalplannedcostamt) - [TotalPlannedMarginAmt](#totalplannedmarginamt) - [TotalPlannedQuantity](#totalplannedquantity) - [TotalPlannedShipmentQuantity](#totalplannedshipmentquantity) - [TotalUnallocatedOrderQuantity](#totalunallocatedorderquantity) - [TotalUnallocatedOrderRevenueAmt](#totalunallocatedorderrevenueamt) - [TotalUnallocatedPlannedQuantity](#totalunallocatedplannedquantity) - [UnitOfMeasureId](#unitofmeasureid) ### ActualMarginPercent - **Field API Name:** `ActualMarginPercent__c` - **Data Type:** PERCENT - **Description:** Plain number percentage value representing the actual margin percent. ### cdp_sys_record_currency - **Field API Name:** `cdp_sys_record_currency__c` - **Data Type:** TEXT - **Description:** System-generated metadata field that stores a 3-letter ISO currency code. ### CostPriceAmt - **Field API Name:** `CostPriceAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the cost price amt. Do not include currency symbols or commas. ### DataSourceId - **Field API Name:** `DataSourceId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### DataSourceObjectId - **Field API Name:** `DataSourceObjectId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### DiscountPercent - **Field API Name:** `DiscountPercent__c` - **Data Type:** PERCENT - **Description:** Plain number percentage value representing the discount percent. ### Id - **Field API Name:** `Id__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### InitialPlannedAmt - **Field API Name:** `InitialPlannedAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the initial planned amt. Do not include currency symbols or commas. ### InitialPlannedQuantity - **Field API Name:** `InitialPlannedQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### InternalOrganizationId - **Field API Name:** `InternalOrganizationId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### KQ_PriceBookEntryId - **Field API Name:** `KQ_PriceBookEntryId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for PriceBookEntryId ### KQ_ProductCategoryId - **Field API Name:** `KQ_ProductCategoryId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ProductCategoryId ### KQ_ProductId - **Field API Name:** `KQ_ProductId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ProductId ### KQ_SalesAgreementId - **Field API Name:** `KQ_SalesAgreementId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for SalesAgreementId ### KQ_UnitOfMeasureId - **Field API Name:** `KQ_UnitOfMeasureId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for UnitOfMeasureId ### ListPriceAmt - **Field API Name:** `ListPriceAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the list price amt. Do not include currency symbols or commas. ### OwnerId - **Field API Name:** `OwnerId__c` - **Data Type:** TEXT - **Description:** The unique identifier for the user who owns this record. ### PlannedMarginPercent - **Field API Name:** `PlannedMarginPercent__c` - **Data Type:** PERCENT - **Description:** Plain number percentage value representing the planned margin percent. ### PriceBookEntryId - **Field API Name:** `PriceBookEntryId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### ProductCategoryId - **Field API Name:** `ProductCategoryId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### ProductId - **Field API Name:** `ProductId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### SalesAgreementId - **Field API Name:** `SalesAgreementId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### SalesPriceAmt - **Field API Name:** `SalesPriceAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the sales price amt. Do not include currency symbols or commas. ### TotalActualAmt - **Field API Name:** `TotalActualAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total actual amt. Do not include currency symbols or commas. ### TotalActualCostAmt - **Field API Name:** `TotalActualCostAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total actual cost amt. Do not include currency symbols or commas. ### TotalActualMarginAmt - **Field API Name:** `TotalActualMarginAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total actual margin amt. Do not include currency symbols or commas. ### TotalActualQuantity - **Field API Name:** `TotalActualQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalActualShipmentQuantity - **Field API Name:** `TotalActualShipmentQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalForecastedQuantity - **Field API Name:** `TotalForecastedQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalPlannedCostAmt - **Field API Name:** `TotalPlannedCostAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total planned cost amt. Do not include currency symbols or commas. ### TotalPlannedMarginAmt - **Field API Name:** `TotalPlannedMarginAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total planned margin amt. Do not include currency symbols or commas. ### TotalPlannedQuantity - **Field API Name:** `TotalPlannedQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalPlannedShipmentQuantity - **Field API Name:** `TotalPlannedShipmentQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalUnallocatedOrderQuantity - **Field API Name:** `TotalUnallocatedOrderQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### TotalUnallocatedOrderRevenueAmt - **Field API Name:** `TotalUnallocatedOrderRevenueAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total unallocated order revenue amt. Do not include currency symbols or commas. ### TotalUnallocatedPlannedQuantity - **Field API Name:** `TotalUnallocatedPlannedQuantity__c` - **Data Type:** DOUBLE - **Description:** The count or numerical value of the quantity for this record. ### UnitOfMeasureId - **Field API Name:** `UnitOfMeasureId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record.