AM
AMToolSchdDetail
The table that stores the schedule details for a tool on a production order. Parent: AMToolMst
| 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 | ||||
Description | nvarchar(60) | Description | - | |
Description:No description available | ||||
EndTime | datetime | End Time | - | |
Description:No description available | ||||
EndTimeStringNonexistent in DB | string | End Time | - | |
Description:Work around for GI not being able to display time | ||||
IsBreak | bit | Down Time | - | |
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 | ||||
OrderByDate | datetime | Order By Date Time | - | |
Description:No description available | ||||
PlanQty | int | Plan Qty | - | |
Description:No description available | ||||
ProdToolNoteID | uniqueidentifier | - | ||
Description:Link to AMProdTool via to AMProdTool.noteID | ||||
RecordID | bigint | Record ID | - | |
Description:No description available | ||||
ResourceIDNonexistent in DB | string | Resource ID | - | |
Description:No description available | ||||
RunTime | int | Run Time | - | |
Description:No description available | ||||
RunTimeBase | int | Run Time Without Efficiency | - | |
Description:No description available | ||||
SchdBlocks | int | Scheduled Blocks | - | |
Description:No description available | ||||
SchdDate | datetime | Schedule Date | - | |
Description:No description available | ||||
SchdKey | uniqueidentifier | Schedule Key | - | |
Description:No description available | ||||
SchdQty | int | Schedule Qty | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StartTime | datetime | Start Time | - | |
Description:No description available | ||||
StartTimeStringNonexistent in DB | string | Start Time | - | |
Description:Work around for GI not being able to display time | ||||
ToolID | nvarchar(30) | Tool ID | AMToolMst | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||