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 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.

Fields

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.