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: std__SalesAgreementProductDmo__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
• 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: std__ActualMarginPercent__c
• Data Type: PERCENT
• Description: The total actual margin amount as a percentage of total actual amount.

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

• Field API Name: std__CostPriceAmt__c
• Data Type: CURRENCY
• Description: Default cost price for the Product.

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

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

• Field API Name: std__DiscountPercent__c
• Data Type: PERCENT
• Description: Default Discount associated with the Product/Product Category

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Primary Key

• Field API Name: std__InitialPlannedAmt__c
• Data Type: CURRENCY
• Description: this field captures the total planned Amount for the entire Sales Agreement for this product/product category. This is then used to default the equally divided amount in each of the child Sales Agreement Product Schedule records.

• Field API Name: std__InitialPlannedQuantity__c
• Data Type: DOUBLE
• Description: This field captures the total planned quantity for the entire Sales Agreement Term for this Product. This is then used to default the equally divided quantity in each of the child Sales Agreement Product Schedule records.

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

• Field API Name: std__ListPriceAmt__c
• Data Type: CURRENCY
• Description: Field stores list price (from the price book entry) for the selected product (only for Product level agreements).

• Field API Name: std__OwnerId__c
• Data Type: TEXT
• Description: Owner of record

• Field API Name: std__PlannedMarginPercent__c
• Data Type: PERCENT
• Description: The total planned margin amount as a percentage of total planned amount.

• Field API Name: std__PriceBookEntryId__c
• Data Type: TEXT
• Description: Reference to Pricebook Entry

• Field API Name: std__ProductCategoryId__c
• Data Type: TEXT
• Description: FK to Product Category

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: FK to Products.

• Field API Name: std__SalesAgreementId__c
• Data Type: TEXT
• Description: Foreign Key Reference to the Parent Sales Agreement

• Field API Name: std__SalesPriceAmt__c
• Data Type: CURRENCY
• Description: Default Unit Price if the Agreement Line is of Product type

• Field API Name: std__TotalActualAmt__c
• Data Type: CURRENCY
• Description: This is calculated by adding actual values for all the associated line schedules.

• Field API Name: std__TotalActualCostAmt__c
• Data Type: CURRENCY
• Description: The sum of the actual cost amounts across all schedules in a sales agreement.

• Field API Name: std__TotalActualMarginAmt__c
• Data Type: CURRENCY
• Description: The sum of the actual margin amounts across all schedules in a sales agreement.

• Field API Name: std__TotalActualQuantity__c
• Data Type: DOUBLE
• Description: This is calculated by adding actual volume for all the associated line schedules.

• Field API Name: std__TotalActualShipmentQuantity__c
• Data Type: DOUBLE
• Description: It represents total number of quantities the manufacturer shipped for the given product.(Roll up from SalesAgreementProductSchedule)

• Field API Name: std__TotalForecastedQuantity__c
• Data Type: DOUBLE
• Description: This is calculated by adding forecast volume for all the associated line schedules.

• Field API Name: std__TotalPlannedCostAmt__c
• Data Type: CURRENCY
• Description: The sum of the planned cost amounts across all schedules in a sales agreement.

• Field API Name: std__TotalPlannedMarginAmt__c
• Data Type: CURRENCY
• Description: The sum of the planned margin amounts across all schedules in a sales agreement.

• Field API Name: std__TotalPlannedQuantity__c
• Data Type: DOUBLE
• Description: This is calculated by adding planned volume for all the associated line schedules.

• Field API Name: std__TotalPlannedShipmentQuantity__c
• Data Type: DOUBLE
• Description: It represents total number of quantities the manufacturer should be shipping for the given product.(Roll up from SalesAgreementProductSchedule)

• Field API Name: std__TotalUnallocatedOrderQuantity__c
• Data Type: DOUBLE
• Description: It represents total number of quantities available in the orders which are not associated with this salesagreement for the given product.(Roll up from SalesAgreementProductSchedule)

• Field API Name: std__TotalUnallocatedOrderRevenueAmt__c
• Data Type: CURRENCY
• Description: It represents total revenue or amount in the orders which are not associated with this salesagreement for the given product.(Roll up from SalesAgreementProductSchedule)

• Field API Name: std__TotalUnallocatedPlannedQuantity__c
• Data Type: DOUBLE
• Description: It represents difference between Initial Planned Quantity and Total Planned Quantity when the distribution is Manual

• Field API Name: std__UnitOfMeasureId__c
• Data Type: TEXT
• Description: It reprents unit of measure for quantity field.