--- schema_version: "1" id: 53aef30a6fedc424c2c7b31baab06a97801b0f69b6661d21273374778b85b394 title: Sales Agreement 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-salesagreementdmo-dmo.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesagreementdmo-dmo.html source_site: developer.salesforce.com content_type: documentation content_hash: c38369ca280b86c1312d652e816e8afac0434f7cc063f9863917e827e214a0ee products: - Data 360 DMO and Mapping Guide - Data 360 Developer Documentation --- # Sales Agreement DMO Sales Agreement is a long term volume and price agreement between two parties (seller and buyer). It is a planning tool for users to budget/plan/forecast volume and pricing for a set of products or product families, and does not contain any legal terms. ## Object Properties **Object API Name:** `SalesAgreement_std__dlm` **Category:** Unassigned **Availability:** Available in 260 and later versions **Primary Key Field:** Id ## Relationships - **AccountId** has a FOREIGNKEY relationship with the [Account DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field. - **AccountContactId** has a FOREIGNKEY relationship with the [Account Contact DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountcontactdmo-dmo.md) `Id` field. - **PriceBookId** has a FOREIGNKEY relationship with the [Price Book DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookdmo-dmo.md) `Id` field. - **RenewedFromAgreementId** 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. - **RenewedToAgreementId** 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. - **OwnerId** 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. - **ApprovedByUserId** 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. ## Fields - [AccountContactId](#accountcontactid) - [AccountId](#accountid) - [ActivatedDateTime](#activateddatetime) - [ActualMarginPercent](#actualmarginpercent) - [ApprovedByUserId](#approvedbyuserid) - [ApprovedDateTime](#approveddatetime) - [CancellationDateTime](#cancellationdatetime) - [CancellationReason](#cancellationreason) - [cdp_sys_record_currency](#cdp_sys_record_currency) - [CreatedDate](#createddate) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [EndDate](#enddate) - [Id](#id) - [InternalOrganizationId](#internalorganizationid) - [KQ_AccountContactId](#kq_accountcontactid) - [KQ_AccountId](#kq_accountid) - [KQ_ApprovedByUserId](#kq_approvedbyuserid) - [KQ_Id](#kq_id) - [KQ_OwnerId](#kq_ownerid) - [KQ_PriceBookId](#kq_pricebookid) - [KQ_RenewedFromAgreementId](#kq_renewedfromagreementid) - [KQ_RenewedToAgreementId](#kq_renewedtoagreementid) - [LastActualsCalculatedDateTime](#lastactualscalculateddatetime) - [OwnerId](#ownerid) - [PlannedMarginPercent](#plannedmarginpercent) - [PriceBookId](#pricebookid) - [RenewedFromAgreementId](#renewedfromagreementid) - [RenewedToAgreementId](#renewedtoagreementid) - [SalesAgreementName](#salesagreementname) - [SalesAgreementProductLevel](#salesagreementproductlevel) - [SalesAgreementType](#salesagreementtype) - [ScheduleFrequency](#schedulefrequency) - [ShouldUserSpecPlnQuantity](#shoulduserspecplnquantity) - [StartDate](#startdate) - [Status](#status) - [StatusCategory](#statuscategory) - [TotalActualAgreementAmt](#totalactualagreementamt) - [TotalActualCostAmt](#totalactualcostamt) - [TotalActualMarginAmt](#totalactualmarginamt) - [TotalAgreementAmt](#totalagreementamt) - [TotalPlannedCostAmt](#totalplannedcostamt) - [TotalPlannedMarginAmt](#totalplannedmarginamt) - [TotalProposedAgreementAmt](#totalproposedagreementamt) ### AccountContactId - **Field API Name:** `AccountContactId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### AccountId - **Field API Name:** `AccountId__c` - **Data Type:** TEXT - **Description:** The unique identifier for the related Account record. ### ActivatedDateTime - **Field API Name:** `ActivatedDateTime__c` - **Data Type:** DATETIME - **Description:** The date and time of the activated date time. ### ActualMarginPercent - **Field API Name:** `ActualMarginPercent__c` - **Data Type:** PERCENT - **Description:** Plain number percentage value representing the actual margin percent. ### ApprovedByUserId - **Field API Name:** `ApprovedByUserId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### ApprovedDateTime - **Field API Name:** `ApprovedDateTime__c` - **Data Type:** DATETIME - **Description:** The date and time of the approved date time. ### CancellationDateTime - **Field API Name:** `CancellationDateTime__c` - **Data Type:** DATETIME - **Description:** The date and time of the cellation date time. ### CancellationReason - **Field API Name:** `CancellationReason__c` - **Data Type:** TEXT - **Description:** The reason for the cellation. ### 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. ### CreatedDate - **Field API Name:** `CreatedDate__c` - **Data Type:** DATETIME - **Description:** The date and time the record was originally created. ### 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. ### EndDate - **Field API Name:** `EndDate__c` - **Data Type:** DATEONLY - **Description:** Date and time when the record or activity ended. ### Id - **Field API Name:** `Id__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### InternalOrganizationId - **Field API Name:** `InternalOrganizationId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### KQ_AccountContactId - **Field API Name:** `KQ_AccountContactId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AccountContactId ### KQ_AccountId - **Field API Name:** `KQ_AccountId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AccountId ### KQ_ApprovedByUserId - **Field API Name:** `KQ_ApprovedByUserId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ApprovedByUserId ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### KQ_OwnerId - **Field API Name:** `KQ_OwnerId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for OwnerId ### KQ_PriceBookId - **Field API Name:** `KQ_PriceBookId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for PriceBookId ### KQ_RenewedFromAgreementId - **Field API Name:** `KQ_RenewedFromAgreementId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for RenewedFromAgreementId ### KQ_RenewedToAgreementId - **Field API Name:** `KQ_RenewedToAgreementId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for RenewedToAgreementId ### LastActualsCalculatedDateTime - **Field API Name:** `LastActualsCalculatedDateTime__c` - **Data Type:** DATETIME - **Description:** The date and time of the last actuals calculated date time. ### 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. ### PriceBookId - **Field API Name:** `PriceBookId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### RenewedFromAgreementId - **Field API Name:** `RenewedFromAgreementId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### RenewedToAgreementId - **Field API Name:** `RenewedToAgreementId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### SalesAgreementName - **Field API Name:** `SalesAgreementName__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the sales agreement name. ### SalesAgreementProductLevel - **Field API Name:** `SalesAgreementProductLevel__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the sales agreement product level. ### SalesAgreementType - **Field API Name:** `SalesAgreementType__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the sales agreement type. ### ScheduleFrequency - **Field API Name:** `ScheduleFrequency__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the schedule frequency. ### ShouldUserSpecPlnQuantity - **Field API Name:** `ShouldUserSpecPlnQuantity__c` - **Data Type:** BOOLEAN - **Description:** Indicates whether this record should user spec pln quantity (true) or not (false). ### StartDate - **Field API Name:** `StartDate__c` - **Data Type:** DATEONLY - **Description:** Date and time when the record or activity began. ### Status - **Field API Name:** `Status__c` - **Data Type:** TEXT - **Description:** The status of this record. ### StatusCategory - **Field API Name:** `StatusCategory__c` - **Data Type:** TEXT - **Description:** Alphanumeric string representing the status category. ### TotalActualAgreementAmt - **Field API Name:** `TotalActualAgreementAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total actual agreement 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. ### TotalAgreementAmt - **Field API Name:** `TotalAgreementAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total agreement amt. Do not include currency symbols or commas. ### 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. ### TotalProposedAgreementAmt - **Field API Name:** `TotalProposedAgreementAmt__c` - **Data Type:** CURRENCY - **Description:** Monetary amount representing the total proposed agreement amt. Do not include currency symbols or commas.