DemandAndSupplyPlansItemRelationships
Lists the item relationships used in the demand and supply plan.
Columns
| Name | Type | SupportedFinders | Description |
| DemandAndSupplyPlansPlanId [KEY] | Long | Value that uniquely identifies the plan. | |
| CreatedBy | String | User who created the item relationship. | |
| CreationDate | Datetime | Date when the user created the item relationship. | |
| CustomerId | Long | Unique identifier of the customer associated with the item relationship. | |
| Customer | String | Name of the customer associated with the item relationship. | |
| CustomerSiteId | Long | Unique identifier of the customer site associated with the item relationship. | |
| CustomerSite | String | Name of the customer site associated with the item relationship. | |
| DisableDate | Date | Date the item relationship is disabled. | |
| EffectiveDate | Date | Date the item relationship is effective. | |
| HigherItemId | Long | Unique identifier of the higher-level item. | |
| HigherItemName | String | Name of the higher-level item. | |
| HighestItemId | Long | Unique identifier of the highest item. | |
| LastUpdateDate | Datetime | Date when the user most recently updated the item relationship. | |
| LastUpdateLogin | String | Sign-in used for updating the item relationship. | |
| LastUpdatedBy | String | User who most recently updated the item relationship. | |
| LowerItemId | Long | Value that uniquely identifies the lower item. | |
| LowerItemName | String | Name of the lower item. | |
| InferredIndicator | Decimal | Indicates whether the item relationship is inferred. | |
| InferredMeaning | String | Meaning of the inferred item relationship indicator. | |
| OrganizationId [KEY] | Decimal | Value that uniquely identifies the organization. | |
| OrganizationCode | String | The code that identifies the organization. | |
| PlanId [KEY] | Long | PrimaryKey | Value that uniquely identifies the plan. |
| PlanningEnabledIndicator | Decimal | Indicates whether planning is enabled. | |
| PlanningEnabledMeaning | String | Meaning of the planning enabled indicator. | |
| Rank | Decimal | Rank of the item relationship. | |
| ReciprocalIndicator | Decimal | Indicates whether the item relationship is reciprocal. | |
| ReciprocalMeaning | String | Meaning of the reciprocal item relationship indicator. | |
| OrganizationIndicator | Decimal | Indicates whether the item relationship is organization independent. | |
| ControlledAt | String | Indicates whether the item relationship is controlled at the master level or the organization level. | |
| SubstituteId [KEY] | Long | Unique identifier of the substitute. | |
| PartitionKey [KEY] | Long | The partition key for the item relationship. | |
| HigherItemDescription | String | Description of the higher-level item in the item relationship. | |
| LowerItemDescription | String | Description of the lower item involved in the item relationship. | |
| RelationshipTypeMeaning | String | Type of the item relationship. | |
| RelationshipDescription | String | Description of the item relationship. | |
| MasterOrganizationId | Decimal | Value that uniquely identifies the master organization. | |
| MasterOrganizationCode | String | The code that identifies the master organization. | |
| InheritedIndicator | Decimal | Indicates whether the item relationship is inherited. | |
| InheritedMeaning | String | Meaning of the inherited item relationship indicator. | |
| CurrentLevel | Decimal | The current level of the item relationship. | |
| Finder | String | The name of the finder method used to search and filter records. |