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 Properties

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

Relationships

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

Fields

• 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

ActualAmt

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

ActualMarginAmt

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

ActualMarginPercent

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

ActualQuantity

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

ActualShipmentQuantity

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

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.

EndDate

• Field API Name: EndDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity ended.

ForecastedQuantity

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

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_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_SalesAgreementProduct

• Field API Name: KQ_SalesAgreementProduct__c
• Data Type: TEXT
• Description: Key Qualifier system field for SalesAgreementProduct

MaximumOrderQuantity

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

MinimumPurchaseQuantity

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

MinimumPurchaseRevenueAmt

• Field API Name: MinimumPurchaseRevenueAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the minimum purchase revenue 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.

PlannedAmt

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

PlannedQuantity

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

PlannedShipmentQuantity

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

SalesAgreementProdScheduleName

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

SalesAgreementProduct

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

SalesPriceAmt

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

StartDate

• Field API Name: StartDate__c
• Data Type: DATEONLY
• Description: Date and time when the record or activity began.

UnallocatedOrderQuantity

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

UnallocatedOrderRevenueAmt

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