AM
AMForecastStaging
PX.Objects.AM26 of 26 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BeginDate | datetime2 | Begin Date | - | |
Description:No description available | ||||
CustomerID | int | CustomerID | Customer | |
Description:No description available | ||||
EndDate | datetime2 | End Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
UserID | uniqueidentifier | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ChangeUnitsNonexistent in DB | decimal | Change in Units | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomerID2Nonexistent in DB | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
Dependent | bit | Dependent | - | |
Description:No description available | ||||
ForecastQty | decimal(25, 6) | Quantity | - | |
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 | ||||
LastYearBaseQty | decimal(25, 6) | Last Year Base | - | |
Description:No description available | ||||
LastYearSalesQty | decimal(25, 6) | Last Year | - | |
Description:No description available | ||||
PercentChangeNonexistent in DB | decimal | Percent Change | - | |
Description:No description available | ||||
Seasonality | nvarchar(10) | Seasonality | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||