SupplyChainPlansMeasureBasedExceptions
Lists the measure-based exceptions generated for the supply chain plan.
Columns
| Name | Type | SupportedFinders | Description |
| SupplyChainPlansPlanId [KEY] | Long | Value that uniquely identifies the plan. | |
| Exception | String | Name of an exception. | |
| TimeLevelMember | Date | The date of the time level member in the measure-based exception. | |
| StartDate | Date | Start date of the measure-based exception detail. | |
| EndDate | Date | End date of the measure-based exception detail. | |
| ActionTaken | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that an action is taken to resolve the exception. If 2, then no action is taken. Default value is 2. | |
| Notes | Long | Notes created or updated for the exception detail. | |
| BaseMeasureQuantity | Decimal | Number that represents the measure value or quantity of the measure for comparison with the threshold in the measure-based exception. | |
| BaseMeasureDate | Date | The date used as the measure value for comparison with the threshold in the measure-based exception. | |
| CreatedBy | String | Name of the user who created the exception detail. | |
| CreationDate | Datetime | Date when the exception detail was created. | |
| CustomerLevelMember | Long | Value that uniquely identifies the customer level member in the measure-based exception. | |
| CustomerLevelMemberName | String | Name of the customer level member in the measure-based exception. | |
| ExceptionDetailId [KEY] | Long | Value that uniquely identifies the measure-based exception detail. | |
| ExceptionId | Long | Number that uniquely identifies an exception. | |
| ExceptionLevelMember | Long | Value that uniquely identifies the exception level member in the measure-based exception. | |
| ExceptionLevelMemberName | String | Name of the exception level member in the measure-based exception. | |
| FirstGeneratedDate | Date | Date when the exception details were first generated by the plan. | |
| LastUpdateDate | Datetime | Date when the exception detail was last updated. | |
| LastUpdateLogin | String | The login used when the exception details were last updated. | |
| LastUpdatedBy | String | Name of the user who last updated the exception detail. | |
| OrderTypeLevelMember | Long | Value that uniquely identifies the order type level member in the measure-based exception. | |
| OrderTypeLevelMemberName | String | Name of the order type level member in the measure-based exception. | |
| OrganizationLevelMember | Long | Value that uniquely identifies the organization level member in the measure-based exception. | |
| OrganizationLevelMemberName | String | Name of the organization level member in the measure-based exception. | |
| PlanId [KEY] | Long | PrimaryKey | Value that uniquely identifies the plan in which the exception is generated. |
| PlanLevelMember | Long | Value that uniquely identifies the plan level member in the measure-based exception. | |
| PlanLevelMemberName | String | Name of the plan level member in the measure-based exception. | |
| ProductLevelMember | Long | Value that uniquely identifies the product level member in the measure-based exception. | |
| ProductLevelMemberName | String | Name of the product level member in the measure-based exception. | |
| ResourceLevelMember | Long | Value that uniquely identifies the resource level member in the measure-based exception. | |
| ResourceLevelMemberName | String | Name of the resource level member in the measure-based exception. | |
| SupplierLevelMember | Long | Value that uniquely identifies the supplier level member in the measure-based exception. | |
| SupplierLevelMemberName | String | Name of the supplier level member in the measure-based exception. | |
| ThresholdMeasureQuantity | Decimal | Number that represents the threshold value or quantity of the measure in the measure-based exception. | |
| ThresholdMeasureDate | Date | Date represented as measure value for threshold in the measure-based exception. | |
| PlannerCode | String | Abbreviation that identifies the planner associated with the item in the exception. | |
| PlannerDescription | String | Description of the planner associated with the item in the exception. | |
| PlanCategoryName | String | Name of the category to which the item is assigned in the measure-based exception. | |
| CustomerLevel | Long | Value that uniquely identifies the customer hierarchy level in the measure-based exception. | |
| CustomerLevelName | String | Name of the customer hierarchy level in the measure-based exception. | |
| OrganizationLevel | Long | Value that uniquely identifies the organization hierarchy level in the measure-based exception. | |
| OrganizationLevelName | String | Name of the organization hierarchy level in the measure-based exception. | |
| CustomerHierarchy | Long | Value that uniquely identifies the customer hierarchy in the measure-based exception. | |
| CustomerHierarchyName | String | Name of the customer hierarchy in the measure-based exception. | |
| BasisValue | Long | Value that uniquely identifies the basis in the measure-based exception. | |
| OrganizationHierarchy | Long | Value that uniquely identifies the organization hierarchy in the measure-based exception. | |
| OrganizationHierarchyName | String | Name of the organization hierarchy in the measure-based exception. | |
| ExceptionHierarchy | Long | Value that uniquely identifies the exception hierarchy in the measure-based exception. | |
| ExceptionHierarchyName | String | Name of the exception hierarchy in the measure-based exception. | |
| Basis | Int | Basis of the exception computation. Default is Measure for a measure-based exception. | |
| PlanLevel | Long | Value that uniquely identifies the plan hierarchy level in the measure-based exception. | |
| PlanLevelName | String | Name of the plan hierarchy level in the measure-based exception. | |
| ExceptionLevel | Long | Value that uniquely identifies the exception hierarchy level in the measure-based exception. | |
| ExceptionLevelName | String | Name of the exception hierarchy level in the measure-based exception. | |
| OrderTypeHierarchy | Long | Value that uniquely identifies the order type hierarchy in the measure-based exception. | |
| OrderTypeHierarchyName | String | Name of the order type hierarchy in the measure-based exception. | |
| OrderTypeLevel | Long | Value that uniquely identifies the order type hierarchy level in the measure-based exception. | |
| OrderTypeLevelName | String | Name of the order type hierarchy level in the measure-based exception. | |
| PlanHierarchy | Long | Value that uniquely identifies the plan hierarchy in the measure-based exception. | |
| PlanHierarchyName | String | Name of the plan hierarchy in the measure-based exception. | |
| ProductHierarchy | Long | Value that uniquely identifies the product hierarchy in the measure-based exception. | |
| ProductHierarchyName | String | Name of the product hierarchy in the measure-based exception. | |
| ProductLevel | Long | Value that uniquely identifies the product hierarchy level in the measure-based exception. | |
| ProductLevelName | String | Name of the product hierarchy level in the measure-based exception. | |
| ResourceHierarchy | Long | Value that uniquely identifies the resource hierarchy in the measure-based exception. | |
| ResourceHierarchyName | String | Name of the resource hierarchy in the measure-based exception. | |
| ResourceLevel | Long | Value that uniquely identifies the resource hierarchy level in the measure-based exception. | |
| ResourceLevelName | String | Name of the resource hierarchy level in the measure-based exception. | |
| ScenarioHierarchy | Long | Value that uniquely identifies the scenario hierarchy in the measure-based exception. | |
| ScenarioHierarchyName | String | Name of the scenario hierarchy in the measure-based exception. | |
| ScenarioLevel | Long | Value that uniquely identifies the scenario hierarchy level in the measure-based exception. | |
| ScenarioLevelName | String | Name of the scenario hierarchy level in the measure-based exception. | |
| SupplierHierarchy | Long | Value that uniquely identifies the supplier hierarchy in the measure-based exception. | |
| SupplierHierarchyName | String | Name of the supplier hierarchy in the measure-based exception. | |
| SupplierLevel | Long | Value that uniquely identifies the supplier hierarchy level in the measure-based exception. | |
| SupplierLevelName | String | Name of the supplier hierarchy level in the measure-based exception. | |
| TimeHierarchy | Long | Value that uniquely identifies the time hierarchy in the measure-based exception. | |
| TimeHierarchyName | String | Name of the time hierarchy in the measure-based exception. | |
| TimeLevel | Long | Value that uniquely identifies the time hierarchy level in the measure-based exception. | |
| TimeLevelName | String | Name of the time hierarchy level in the measure-based exception. | |
| ExceptionAge | Int | Number of days representing the age of the exception. | |
| ScenarioLevelMember | Long | Value that uniquely identifies the scenario level member in the measure-based exception. | |
| ScenarioLevelMemberName | String | Name of the scenario level member in the measure-based exception. | |
| PersistentId | String | Value that uniquely identifies the persistent exception detail in the measure-based exception. | |
| DemandClassLevelMember | Long | Value that uniquely identifies the demand class level member in the measure-based exception. | |
| DemandClassLevelMemberName | String | Name of the demand class level member in the measure-based exception. | |
| DemandClassHierarchy | Long | Value that uniquely identifies the demand class hierarchy in the measure-based exception. | |
| DemandClassHierarchyName | String | Name of the demand class hierarchy in the measure-based exception. | |
| DemandClassLevel | Long | Value that uniquely identifies the demand class hierarchy level in the measure-based exception. | |
| DemandClassLevelName | String | Name of the demand class hierarchy level in the measure-based exception. | |
| ClusterHierarchy | Long | Value that uniquely identifies the cluster hierarchy in the measure-based exception. | |
| ClusterHierarchyName | String | Name of the cluster hierarchy in the measure-based exception. | |
| ClusterLevel | Long | Value that uniquely identifies the cluster hierarchy level in the measure-based exception. | |
| ClusterLevelName | String | Name of the cluster hierarchy level in the measure-based exception. | |
| ClusterLevelMember | Long | Value that uniquely identifies the cluster-level member in the measure-based exception. | |
| ClusterLevelMemberName | String | Name of the cluster-level member in the measure-based exception. | |
| ClusterDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the cluster dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| CustomerDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that customer dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| DemandClassDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the demand class dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| ExceptionDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the exception dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| OrderTypeDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the order type dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| OrganizationDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the organization dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| PlanDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the plan dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| ProductDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the product dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| ResourceDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the resource dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| SupplierDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the supplier dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| TimeDimEnabled | Int | Contains one of the following values: 1 or 2. If 1, then it indicates that the time dimension is enabled for the measure-based exception. If 2, then the dimension is not enabled. The default value is 2. | |
| Finder | String | The name of the finder method used to search and filter records. |