Sales Agreement Prod Schedule DMO

It records the quantity/amount/pricing for the product/product category in a particular time period for eg if the Sales Agreement has a monthly Scheduling Frequency and it’s total duration is 12 months, there will be 12 schedule records per product.

Object API Name: SalesAgreementProdSchedule_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• SalesAgreementProduct has a FOREIGNKEY relationship with the Sales Agreement Product DMO Id field.
• OwnerId has a FOREIGNKEY relationship with the User DMO Id field.

• ActualAmt
• ActualMarginAmt
• ActualMarginPercent
• ActualQuantity
• ActualShipmentQuantity
• cdp_sys_record_currency
• CostPriceAmt
• DataSourceId
• DataSourceObjectId
• EndDate
• ForecastedQuantity
• Id
• InternalOrganizationId
• KQ_Id
• KQ_OwnerId
• KQ_SalesAgreementProduct
• MaximumOrderQuantity
• MinimumPurchaseQuantity
• MinimumPurchaseRevenueAmt
• OwnerId
• PlannedAmt
• PlannedQuantity
• PlannedShipmentQuantity
• SalesAgreementProdScheduleName
• SalesAgreementProduct
• SalesPriceAmt
• StartDate
• UnallocatedOrderQuantity
• UnallocatedOrderRevenueAmt

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

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

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

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

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

• 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: EndDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity ended.

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

• 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_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_SalesAgreementProduct__c
• Data Type: TEXT
• Description: Key Qualifier system field for SalesAgreementProduct

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

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

• Field API Name: MinimumPurchaseRevenueAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the minimum purchase revenue 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: PlannedAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the planned amt. Do not include currency symbols or commas.

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

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

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

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

• 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: StartDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity began.

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

• Field API Name: UnallocatedOrderRevenueAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the unallocated order revenue amt. Do not include currency symbols or commas.