AM
AMSchdItem
Master table for a production order schedule. Parent: AMProdItem
View API Entity: RoughCutPlanningDetail
/entity/MANUFACTURING/25.100.001/RoughCutPlanningDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ConstDate API | 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 | ||||
FirmSchedule API | bit | Firm Schedule | - | |
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
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 | ||||
MRPPlanID | bigint | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderType API | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
OrigConstDateNonexistent in DB | DateTime? | Original Constraint Date | - | |
Description:Orig const date - stores the initial constraint date for scheduling validations | ||||
OrigSchedulingMethodNonexistent in DB | string | Original Scheduling Method | - | |
Description:Orig scheduling method - retains the original scheduling method for scheduling validations | ||||
ParentOrdID | nvarchar(19) | Parent Production Nbr. | - | |
Description:No description available | ||||
ParentOrderType | char(2) | Parent Order Type | - | |
Description:No description available | ||||
ProdOrdID API | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
QtyComplete | decimal | Qty Complete | - | |
Description:Order Base Unit Qty Complete | ||||
decimal? | Qty Remaining | - | ||
Description:No description available | ||||
QtyScrapped | decimal | Qty Scrapped | - | |
Description:Order Base Unit Qty Scrapped | ||||
QtytoProd API | decimal | Qty to Produce | - | |
Description:Order Base Unit Qty to Produce | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
SchPriority API | smallint | Dispatch Priority | - | |
Description:No description available | ||||
SchdID API | int | Schedule ID | - | |
Description:No description available | ||||
ScheduleStatus API | char(1) | Schedule Status | - | |
Description:No description available | ||||
SchedulingMethod API | char(1) | Scheduling Method | - | |
Description:No description available | ||||
bool? | Selected | - | ||
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||