AM
AMForecastPeriod
The table use to maintain time period records for forecast interval and display in Forecast vs. Sales (AM404100) and Forecast vs. Sales Details (AM404200)
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
ForecastID | nvarchar(15) | Forecast ID | AMForecast | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PeriodEnd | datetime | End Date | - | |
Description:Forecast Period End Date | ||||
PeriodStart | datetime | Start Date | - | |
Description:Forecast Period Start Date | ||||
TimePeriod | nvarchar(21) | Time Period | - | |
Description:Natural key to select a forecast period | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||