AM
AMSchdItem
PX.Objects.AM33 of 33 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
SchdID | int | Schedule ID | - | |
Description:No description available | ||||
ConstDate | datetime2 | 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 | datetime2 | End Date | - | |
Description:No description available | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsMRP | bit | Is MRP | - | |
Description:No description available | ||||
IsPlan | bit | Is Plan | - | |
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 | ||||
MRPPlanID | bigint | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigConstDateNonexistent in DB | datetime | Original Constraint Date | - | |
Description:No description available | ||||
OrigSchedulingMethodNonexistent in DB | nvarchar(1) | Original Scheduling Method | - | |
Description:No description available | ||||
ParentOrderType | char(2) | Parent Order Type | - | |
Description:No description available | ||||
ParentOrdID | nvarchar(19) | Parent Production Nbr. | - | |
Description:No description available | ||||
QtyComplete | decimal(25, 6) | Qty Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal | Qty Remaining | - | |
Description:No description available | ||||
QtyScrapped | decimal(25, 6) | Qty Scrapped | - | |
Description:No description available | ||||
QtytoProd | decimal(25, 6) | Qty to Produce | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ScheduleStatus | char(1) | Schedule Status | - | |
Description:No description available | ||||
SchedulingMethod | char(1) | Scheduling Method | - | |
Description:No description available | ||||
SchPriority | smallint | Dispatch Priority | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||