AM
WorkCenterCapacityInq.WorkCenterCapacityDetail
Details of work center capacities. These records are generated by the WorkCenterCapacityInq graph.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AvailableBlocks | int | Available Blocks | - | |
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 | ||||
EndTime | datetime | End Time | - | |
Description:No description available | ||||
ExceptionDate | bit | Exception Date | - | |
Description:No description available | ||||
FromDateNonexistent in DB | DateTime? | From Date | - | |
Description:Starting date range | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PlanBlocks | int | Plan Blocks | - | |
Description:No description available | ||||
PlanUtilizationPctNonexistent in DB | decimal? | Plan Utilization Pct | - | |
Description:No description available | ||||
ResourceIDNonexistent in DB | string | Resource ID | - | |
Description:No description available | ||||
SchdBlocks | int | Scheduled Blocks | - | |
Description:No description available | ||||
SchdDate | datetime | Schedule Date | - | |
Description:No description available | ||||
SchdTime | int | Schedule Time | - | |
Description:Indicates total schedule time | ||||
SchdUtilizationPctNonexistent in DB | decimal? | Schd Utilization Pct | - | |
Description:No description available | ||||
ShiftCD | nvarchar(4) | Shift | AMShift | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StartTime | datetime | Start Time | - | |
Description:No description available | ||||
ToDateNonexistent in DB | DateTime? | To Date | - | |
Description:Ending date range | ||||
TotalBlocks | int | Total Blocks | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||
WorkTime | int | Work Time | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||