Forecasting Item Historical Trend DMO

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

• cdp_sys_record_currency
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• ForecastingItemId
• HistoricalForecastAmount
• HistoricalForecastAmt
• HistoricalForecastQuantity
• HistoricalOwnerOnlyAmount
• HistoricalOwnerOnlyAmt
• HistoricalOwnerOnlyQuantity
• HistoricalWithoutAdjustmentsAmount
• HistoricalWithoutAdjustmentsAmt
• HistoricalWithoutAdjustmentsQuantity
• HistoricalWithoutManagerAdjAmount
• HistoricalWithoutManagerAdjAmt
• HistoricalWithoutManagerAdjQuantity
• Id
• InternalOrganizationId
• IsDeleted
• KQ_Id
• Name
• PriorForecastAmount
• PriorForecastAmt
• PriorForecastQuantity
• PriorOwnerOnlyAmount
• PriorOwnerOnlyAmt
• PriorOwnerOnlyQuantity
• PriorWithoutAdjustmentsAmount
• PriorWithoutAdjustmentsAmt
• PriorWithoutAdjustmentsQuantity
• PriorWithoutManagerAdjustmentAmount
• PriorWithoutManagerAdjustmentAmt
• PriorWithoutManagerAdjustmentQuantity
• SystemModstamp
• ValidFromDateTime
• ValidToDateTime

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

• Field API Name: ssot__CreatedById__c
• Data Type: TEXT
• Description: Required. The user who created the record. Maximum size is 255 characters.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: Created Date.

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

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

• Field API Name: ssot__ForecastingItemId__c
• Data Type: TEXT
• Description: Required. This is a One to One (1:1) relationship field. ForecastingItemHistoricalTrends is the relationship name and Forecasting Item is the referenced object. Maximum size is 15 characters.

• Field API Name: ssot__HistoricalForecastAmount__c
• Data Type: DOUBLE
• Description: The historical forecast amount for the forecasting item historical trend.

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

• Field API Name: ssot__HistoricalForecastQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the forecasting item historical trend quantity.

• Field API Name: ssot__HistoricalOwnerOnlyAmount__c
• Data Type: DOUBLE
• Description: Owner Only Amount (Historical).

• Field API Name: ssot__HistoricalOwnerOnlyAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the historical owner only amt. Do not include currency symbols or commas.

• Field API Name: ssot__HistoricalOwnerOnlyQuantity__c
• Data Type: DOUBLE
• Description: Owner Only Quantity (Historical).

• Field API Name: ssot__HistoricalWithoutAdjustmentsAmount__c
• Data Type: DOUBLE
• Description: Amount WO Adj (Historical).

• Field API Name: ssot__HistoricalWithoutAdjustmentsAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the historical without adjustments amt. Do not include currency symbols or commas.

• Field API Name: ssot__HistoricalWithoutAdjustmentsQuantity__c
• Data Type: DOUBLE
• Description: Quantity WO Adj (Historical).

• Field API Name: ssot__HistoricalWithoutManagerAdjAmount__c
• Data Type: DOUBLE
• Description: Amount WO Manager Adj (Historical).

• Field API Name: ssot__HistoricalWithoutManagerAdjAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the historical without manager adj amt. Do not include currency symbols or commas.

• Field API Name: ssot__HistoricalWithoutManagerAdjQuantity__c
• Data Type: DOUBLE
• Description: Quantity WO Manager Adj (Historical).

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Historical Data Table Id.

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

• Field API Name: ssot__IsDeleted__c
• Data Type: BOOLEAN
• Description: Whether the forecasting item historical trend is deleted (true) or not (false).

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

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of Forecasting Item Historical Trend.

• Field API Name: ssot__PriorForecastAmount__c
• Data Type: DOUBLE
• Description: The prior forecast amount for the forecasting item historical trend.

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

• Field API Name: ssot__PriorForecastQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the forecasting item historical trend quantity.

• Field API Name: ssot__PriorOwnerOnlyAmount__c
• Data Type: DOUBLE
• Description: Owner Only Amount (Prior).

• Field API Name: ssot__PriorOwnerOnlyAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the prior owner only amt. Do not include currency symbols or commas.

• Field API Name: ssot__PriorOwnerOnlyQuantity__c
• Data Type: DOUBLE
• Description: Owner Only Quantity (Prior).

• Field API Name: ssot__PriorWithoutAdjustmentsAmount__c
• Data Type: DOUBLE
• Description: Amount WO Adj (Prior).

• Field API Name: ssot__PriorWithoutAdjustmentsAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the prior without adjustments amt. Do not include currency symbols or commas.

• Field API Name: ssot__PriorWithoutAdjustmentsQuantity__c
• Data Type: DOUBLE
• Description: Quantity WO Adj (Prior).

• Field API Name: ssot__PriorWithoutManagerAdjustmentAmount__c
• Data Type: DOUBLE
• Description: Amount WO Manager Adj (Prior).

• Field API Name: ssot__PriorWithoutManagerAdjustmentAmt__c
• Data Type: CURRENCY
• Description: Monetary amount representing the prior without manager adjustment amt. Do not include currency symbols or commas.

• Field API Name: ssot__PriorWithoutManagerAdjustmentQuantity__c
• Data Type: DOUBLE
• Description: Quantity WO Manager Adj (Prior).

• Field API Name: ssot__SystemModstamp__c
• Data Type: DATETIME
• Description: Required. The date and time of the last system modification.

• Field API Name: ssot__ValidFromDateTime__c
• Data Type: DATETIME
• Description: Valid From.

• Field API Name: ssot__ValidToDateTime__c
• Data Type: DATETIME
• Description: Valid To.