AM
AMSchdOper
The table that stores the schedule for an operation on a production order. Parent: AMProdOper
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ConstDate | datetime | Constraint | - | |
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 | ||||
EndDate | datetime | End Date | - | |
Description:No description available | ||||
FinishTime | int | Finish Time | - | |
Description:No description available | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
IsMRP | bit | Is MRP | - | |
Description:When MRP Reruns it will reset the IsPlan records for this field back to false. Then rerun and if the same order is picked back up to reschedule it will contain a true value | ||||
IsPlan | bit | Is Plan | - | |
Description:Indicates if the record is plan order (most likely out of MRP planning) Plan orders should not have an Actual order in AMProdItem as of 6.0 release | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr | - | |
Description:No description available | ||||
MachID | nvarchar(30) | Machine ID | - | |
Description:No description available | ||||
MoveEndDate | datetime | Move End Date | - | |
Description:No description available | ||||
MoveTime | int | Move Time | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
QtyComplete | decimal | QtyComplete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty Remaining | - | |
Description:No description available | ||||
QtyScrapped | decimal | QtyScrapped | - | |
Description:No description available | ||||
QtytoProd | decimal | Qty to Produce | - | |
Description:No description available | ||||
QueueStartDate | datetime | Queue Start Date | - | |
Description:No description available | ||||
QueueTime | int | Queue Time | - | |
Description:No description available | ||||
RunTime | int | Run Time | - | |
Description:No description available | ||||
RunTimeBase | int | Run Time Without Efficiency | - | |
Description:No description available | ||||
SchdID | int | Schd ID | AMSchdItem | |
Description:No description available | ||||
SchedulingMethod | char(1) | Scheduling Method | - | |
Description:No description available | ||||
SetupTime | int | Setup Time | - | |
Description:No description available | ||||
SiteID | int | SiteID | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
TotalPlanTime | int | Total Plan Time | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||