AM
AMSchdOperDetail
The table that stores the schedule details for an operation on a production order. Parent: AMSchdOper
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Chain | int | Chain | - | |
Description:Groups consecutive schedule details together into a chain. A break in the chain is indicated with a new chain number | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
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 | ||||
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 | ||||
RecordID | bigint | Record ID | - | |
Description:No description available | ||||
RunTime | int | Run Time | - | |
Description:No description available | ||||
RunTimeBase | int | Run Time Without Efficiency | - | |
Description:No description available | ||||
SchdDate | datetime | Schedule Date | - | |
Description:No description available | ||||
SchdKey | uniqueidentifier | Schedule Key | - | |
Description:Links the order detail to a schedule detail record for scheduled blocks. | ||||
SchdQty | decimal | Schedule Qty | - | |
Description:Planned Schedule quantity related to the current detail row | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||