AM
AMProdItemRelated
AMProdItem for cache updates to related parent and product orders
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
BaseQtyComplete | decimal | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal | - | ||
Description:No description available | ||||
BaseQtytoProd | decimal | Base Qty to Produce | - | |
Description:No description available | ||||
DemandPlanID | bigint | - | ||
Description:No description available | ||||
DueDate | datetime | Due Date | - | |
Description:Date production order is due. Date comes from a linked order. | ||||
DueDateDiff | int | Due Date Diff. | - | |
Description:The difference in days from DueDate and EndDate. | ||||
EndDate | datetime | End Date | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LineCntrEvnt | int | Event Line Cntr | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
ParentOrdID | nvarchar(19) | Parent Order | - | |
Description:No description available | ||||
ParentOrderType | char(2) | Parent Order Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItemRelated | |
Description:No description available | ||||
ProductOrdID | nvarchar(19) | Product Order | - | |
Description:No description available | ||||
ProductOrderType | char(2) | Product Order Type | - | |
Description:No description available | ||||
QtyComplete | decimal | Qty. Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty. Remaining | - | |
Description:Qty. Remaining from the order | ||||
QtyScrapped | decimal | Qty. Scrapped | - | |
Description:No description available | ||||
QtytoProd | decimal | Qty. to Produce | - | |
Description:No description available | ||||
RelationTypeNonexistent in DB | string | Relationship Type | - | |
Description:Relation type of the related order | ||||
Released | bit | - | ||
Description:No description available | ||||
ScheduleStatus | char(1) | Schedule Status | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SupplyType | int | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||