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 Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• PriceBookEntryId has a FOREIGNKEY relationship with the Price Book Entry DMO Id field.
• SalesAgreementId has a FOREIGNKEY relationship with the User DMO Id field.
• ProductCategoryId has a FOREIGNKEY relationship with the Product Category DMO Id field.
• UnitOfMeasureId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.

Fields

• ActualMarginPercent
• cdp_sys_record_currency
• CostPriceAmt
• DataSourceId
• DataSourceObjectId
• DiscountPercent
• Id
• InitialPlannedAmt
• InitialPlannedQuantity
• InternalOrganizationId
• KQ_Id
• KQ_PriceBookEntryId
• KQ_ProductCategoryId
• KQ_ProductId
• KQ_SalesAgreementId
• KQ_UnitOfMeasureId
• ListPriceAmt
• OwnerId
• PlannedMarginPercent
• PriceBookEntryId
• ProductCategoryId
• ProductId
• SalesAgreementId
• SalesPriceAmt
• TotalActualAmt
• TotalActualCostAmt
• TotalActualMarginAmt
• TotalActualQuantity
• TotalActualShipmentQuantity
• TotalForecastedQuantity
• TotalPlannedCostAmt
• TotalPlannedMarginAmt
• TotalPlannedQuantity
• TotalPlannedShipmentQuantity
• TotalUnallocatedOrderQuantity
• TotalUnallocatedOrderRevenueAmt
• TotalUnallocatedPlannedQuantity
• 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.