itemdemandplan
Holds demand planning data for items, assisting with forecasting and inventory replenishment strategies.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique identifier assigned internally to each demand plan entry. | |
| alternatesourceitem | String | The item that can be used as an alternative source in the demand plan, helping to meet supply needs. | |
| analysisduration | Integer | The number of past periods analyzed to determine historical demand trends for forecasting. | |
| demandplanid | String | System-generated identifier for the demand plan, used to track and reference specific plans. | |
| externalid | String | User-defined external identifier that links this demand plan to external systems or records. | |
| item | String | The specific inventory item for which demand is being forecasted in this plan. | |
| location | String | The physical or logical location associated with this demand plan, such as a warehouse or store. | |
| memo | String | A text field for entering notes or comments related to this demand plan entry. | |
| projectionduration | Integer | The total length of time, measured in periods, over which demand projections are made. | |
| projectioninterval | String | The frequency at which demand projections are calculated, such as daily, weekly, or monthly. | |
| projectionmethod | String | The technique used to forecast demand, such as moving average, linear regression, or seasonal analysis. | |
| projectionstartdate | Date | The start date from which demand projections begin in the forecast. | |
| subsidiary | String | The business subsidiary to which this demand plan applies, relevant for multi-subsidiary organizations. | |
| units | String | The unit of measure used for demand planning, ensuring consistency in quantity calculations. |