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

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

• 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

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

• 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: CostPriceAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the cost price amt. Do not include currency symbols or commas.

• 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: DiscountPercent__c
• Data Type: PERCENT
• Description: Plain number percentage value representing the discount percent.

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

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

• Field API Name: InitialPlannedQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

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

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

• Field API Name: KQ_PriceBookEntryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PriceBookEntryId

• Field API Name: KQ_ProductCategoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductCategoryId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_SalesAgreementId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SalesAgreementId

• Field API Name: KQ_UnitOfMeasureId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UnitOfMeasureId

• Field API Name: ListPriceAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the list price amt. Do not include currency symbols or commas.

• 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: PriceBookEntryId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

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

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

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

• Field API Name: SalesPriceAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the sales price amt. Do not include currency symbols or commas.

• Field API Name: TotalActualAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the total actual 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: TotalActualQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• Field API Name: TotalActualShipmentQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• Field API Name: TotalForecastedQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• 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: TotalPlannedQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• Field API Name: TotalPlannedShipmentQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• Field API Name: TotalUnallocatedOrderQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

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

• Field API Name: TotalUnallocatedPlannedQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

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