AM
AMProdItemRelated
PX.Objects.AM29 of 29 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
BaseQtyComplete | decimal(25, 6) | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtytoProd | decimal(25, 6) | Base Qty to Produce | - | |
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
DemandPlanID | bigint | - | ||
Description:No description available | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
DueDateDiff | int | Due Date Diff. | - | |
Description:No description available | ||||
EndDate | datetime2 | End Date | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
LineCntrEvnt | int | Event Line Cntr | - | |
Description:No description available | ||||
ParentOrderType | char(2) | Parent Order Type | - | |
Description:No description available | ||||
ParentOrdID | nvarchar(19) | Parent Order | - | |
Description:No description available | ||||
ProductOrderType | char(2) | Product Order Type | - | |
Description:No description available | ||||
ProductOrdID | nvarchar(19) | Product Order | - | |
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 | ||||
RelationTypeNonexistent in DB | nvarchar(MAX) | Relationship Type | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ScheduleStatus | char(1) | Schedule Status | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SupplyType | int | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||