MGCLatticeSetBasedDemandForecastLineEntity
Imports demand forecast lines (item forecasts of the sales forecast) in bulk with set-based processing. A row naming an existing forecast entry updates it; other rows become new lines numbered from the demand forecast number sequence, each with its inventory forecast.
- Primary key:
ForecastEntryNumber
Fields
| Name | Type | Mandatory | Description |
|---|
ForecastEntryNumber | ForecastDemandForecastNumSeq | Yes | |
ForecastModelId | ForecastModelHeadId | Yes | |
ItemNumber | ItemId | Yes | |
ForecastStartDate | StartDate | No | |
ForecastEndDate | EndDate | No | |
ForecastedQuantity | SalesQty | No | |
QuantityUnitSymbol | UnitOfMeasureSymbol | No | |
ForecastedUnitPrice | SalesPrice | No | |
ForecastedRevenue | AmountCur | No | |
PricingCurrencyCode | CurrencyCode | No | |
CustomerAccountNumber | CustAccount | No | |
CustomerGroupId | CustGroupId | No | |
ProductAllocationKeyId | ForecastItemAllocationId | No | |
ForecastAllocationMethod | BudgetAllocateMethod | No | |
PeriodAllocationKeyId | LedgerAllocateKeyId | No | |
AllocationPeriods | Periods | No | |
AllocationPeriodUnit | PeriodUnit | No | |
DeliveringSiteId | InventSiteId | No | |
DeliveringWarehouseId | InventLocationId | No | |
InventoryStatusId | WHSInventStatusId | No | |
ProductConfigurationId | EcoResItemConfigurationName | No | |
ProductColorId | EcoResItemColorName | No | |
ProductSizeId | EcoResItemSizeName | No | |
ProductStyleId | EcoResItemStyleName | No | |
ProductVersionId | EcoResItemVersionName | No | |
Inactive | NoYes | No | |
DefaultDimensionDisplayValue | DimensionDisplayValue | No | |
Mappings
| Entity field | Data source | Field |
|---|
ForecastEntryNumber | ForecastSales | ForecastEntryNumber |
ForecastModelId | ForecastSales | ModelId |
ItemNumber | ForecastSales | ItemId |
ForecastStartDate | ForecastSales | StartDate |
ForecastEndDate | ForecastSales | EndDate |
ForecastedQuantity | ForecastSales | SalesQty |
QuantityUnitSymbol | ForecastSales | SalesUnitId |
ForecastedUnitPrice | ForecastSales | SalesPrice |
ForecastedRevenue | ForecastSales | Amount |
PricingCurrencyCode | ForecastSales | Currency |
CustomerAccountNumber | ForecastSales | CustAccountId |
CustomerGroupId | ForecastSales | CustGroupId |
ProductAllocationKeyId | ForecastSales | ItemAllocateId |
ForecastAllocationMethod | ForecastSales | AllocateMethod |
PeriodAllocationKeyId | ForecastSales | KeyId |
AllocationPeriods | ForecastSales | Freq |
AllocationPeriodUnit | ForecastSales | FreqCode |
DeliveringSiteId | InventDim | InventSiteId |
DeliveringWarehouseId | InventDim | InventLocationId |
InventoryStatusId | InventDim | InventStatusId |
ProductConfigurationId | InventDim | configId |
ProductColorId | InventDim | InventColorId |
ProductSizeId | InventDim | InventSizeId |
ProductStyleId | InventDim | InventStyleId |
ProductVersionId | InventDim | InventVersionId |