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 API Name: SalesAgreement_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• AccountContactId has a FOREIGNKEY relationship with the Account Contact DMO Id field.
• PriceBookId has a FOREIGNKEY relationship with the Price Book DMO Id field.
• RenewedFromAgreementId has a FOREIGNKEY relationship with the Sales Agreement DMO Id field.
• RenewedToAgreementId has a FOREIGNKEY relationship with the Sales Agreement DMO Id field.
• OwnerId has a FOREIGNKEY relationship with the User DMO Id field.
• ApprovedByUserId has a FOREIGNKEY relationship with the User DMO Id field.

• AccountContactId
• AccountId
• ActivatedDateTime
• ActualMarginPercent
• ApprovedByUserId
• ApprovedDateTime
• CancellationDateTime
• CancellationReason
• cdp_sys_record_currency
• CreatedDate
• DataSourceId
• DataSourceObjectId
• EndDate
• Id
• InternalOrganizationId
• KQ_AccountContactId
• KQ_AccountId
• KQ_ApprovedByUserId
• KQ_Id
• KQ_OwnerId
• KQ_PriceBookId
• KQ_RenewedFromAgreementId
• KQ_RenewedToAgreementId
• LastActualsCalculatedDateTime
• OwnerId
• PlannedMarginPercent
• PriceBookId
• RenewedFromAgreementId
• RenewedToAgreementId
• SalesAgreementName
• SalesAgreementProductLevel
• SalesAgreementType
• ScheduleFrequency
• ShouldUserSpecPlnQuantity
• StartDate
• Status
• StatusCategory
• TotalActualAgreementAmt
• TotalActualCostAmt
• TotalActualMarginAmt
• TotalAgreementAmt
• TotalPlannedCostAmt
• TotalPlannedMarginAmt
• TotalProposedAgreementAmt

• Field API Name: AccountContactId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: AccountId__c
• Data Type: TEXT
• Description: The unique identifier for the related Account record.

• Field API Name: ActivatedDateTime__c
• Data Type: DATETIME
• Description: The date and time of the activated date time.

• Field API Name: ActualMarginPercent__c
• Data Type: PERCENT
• Description: Plain number percentage value representing the actual margin percent.

• Field API Name: ApprovedByUserId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ApprovedDateTime__c
• Data Type: DATETIME
• Description: The date and time of the approved date time.

• Field API Name: CancellationDateTime__c
• Data Type: DATETIME
• Description: The date and time of the cellation date time.

• Field API Name: CancellationReason__c
• Data Type: TEXT
• Description: The reason for the cellation.

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: EndDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity ended.

• Field API Name: Id__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: KQ_AccountContactId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountContactId

• Field API Name: KQ_AccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountId

• Field API Name: KQ_ApprovedByUserId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ApprovedByUserId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_OwnerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OwnerId

• Field API Name: KQ_PriceBookId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PriceBookId

• Field API Name: KQ_RenewedFromAgreementId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RenewedFromAgreementId

• Field API Name: KQ_RenewedToAgreementId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RenewedToAgreementId

• Field API Name: LastActualsCalculatedDateTime__c
• Data Type: DATETIME
• Description: The date and time of the last actuals calculated date time.

• Field API Name: OwnerId__c
• Data Type: TEXT
• Description: The unique identifier for the user who owns this record.

• Field API Name: PlannedMarginPercent__c
• Data Type: PERCENT
• Description: Plain number percentage value representing the planned margin percent.

• Field API Name: PriceBookId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: RenewedFromAgreementId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: RenewedToAgreementId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: SalesAgreementName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the sales agreement name.

• Field API Name: SalesAgreementProductLevel__c
• Data Type: TEXT
• Description: Alphanumeric string representing the sales agreement product level.

• Field API Name: SalesAgreementType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the sales agreement type.

• Field API Name: ScheduleFrequency__c
• Data Type: TEXT
• Description: Alphanumeric string representing the schedule frequency.

• Field API Name: ShouldUserSpecPlnQuantity__c
• Data Type: BOOLEAN
• Description: Indicates whether this record should user spec pln quantity (true) or not (false).

• Field API Name: StartDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity began.

• Field API Name: Status__c
• Data Type: TEXT
• Description: The status of this record.

• Field API Name: StatusCategory__c
• Data Type: TEXT
• Description: Alphanumeric string representing the status category.

• Field API Name: TotalActualAgreementAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total actual agreement amt. Do not include currency symbols or commas.

• Field API Name: TotalActualCostAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total actual cost amt. Do not include currency symbols or commas.

• Field API Name: TotalActualMarginAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total actual margin amt. Do not include currency symbols or commas.

• Field API Name: TotalAgreementAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total agreement amt. Do not include currency symbols or commas.

• Field API Name: TotalPlannedCostAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total planned cost amt. Do not include currency symbols or commas.

• Field API Name: TotalPlannedMarginAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total planned margin amt. Do not include currency symbols or commas.

• Field API Name: TotalProposedAgreementAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total proposed agreement amt. Do not include currency symbols or commas.