AM
AMRPHistory
Overall summary of each process of Regenerate Inventory Planning (AM50500) to capture process information such as start date, end date, was there an error, duration, and some record counts.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CountAMRPDetail | int | Detail Count | - | |
Description:Count a m r p detail | ||||
CountAMRPDetailFP | int | First Pass Detail Count | - | |
Description:First Pass Detail Count | ||||
CountAMRPDetailPlan | int | Detail Plan Count | - | |
Description:Count a m r p detail plan | ||||
CountAMRPExceptions | int | Exceptions Count | - | |
Description:Exceptions Count | ||||
CountAMRPItemSite | int | Inventory Count | - | |
Description:Inventory Count | ||||
CountAMRPPlan | int | Plan Count | - | |
Description:Count a m r p plan | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Duration | int | Duration | - | |
Description:Duration | ||||
EndDateTime | datetime | End Date | - | |
Description:End date time | ||||
HasError | bit | Has Errors | - | |
Description:Has error | ||||
ProcessID | uniqueidentifier | Process ID | - | |
Description:Process i d | ||||
StartDateTime | datetime | Start Date | - | |
Description:Start date time | ||||
Tstamp | timestamp | Tstamp | - | |
Description:No description available | ||||