AM
ProdOperAdjusted
Projection DAC to summarize production operations with adjusted quantity values. Primary DAC AMProdOper Joined to projection AMBatchProdOperSum which is based on AMBatchProdOper."/>
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseQtyComplete | decimal | Completed Base Qty. | - | |
Description:No description available | ||||
BaseQtyCompleteAdjustedNonexistent in DB | decimal? | Completed Base Qty. | - | |
Description:Sum of AMProdOper.BaseQtyComplete and AMBatchProdOper.BaseQtyComplete. | ||||
BaseQtyRemainingNonexistent in DB | decimal? | Remaining Base Qty. | - | |
Description:BaseTotalQty subtract BaseQtyComplete add BaseQtyScrapped. | ||||
BaseQtyRemainingAdjustedNonexistent in DB | decimal? | Remaining Base Qty. | - | |
Description:BaseTotalQtyAdjusted subtract BaseQtyCompleteAdjusted add BaseQtyScrappedAdjusted. | ||||
BaseQtyScrapped | decimal | Scrapped Base Qty. | - | |
Description:No description available | ||||
BaseQtyScrappedAdjustedNonexistent in DB | decimal? | Scrapped Base Qty. | - | |
Description:Sum of AMProdOper.BaseQtyScrapped and AMBatchProdOper.BaseQtyScrapped. | ||||
BaseQtytoProd | decimal | Base Qty. to Produce | - | |
Description:No description available | ||||
BaseQtytoProdAdjustedNonexistent in DB | decimal? | Base Qty. to Produce | - | |
Description:Sum of AMProdOper.BaseQtytoProd and AMBatchProdOper.BaseQtytoProd. | ||||
BaseTotalQty | decimal | Base Total Qty. | - | |
Description:No description available | ||||
BaseTotalQtyAdjustedNonexistent in DB | decimal? | Base Total Qty. | - | |
Description:Sum of AMProdOper.BaseTotalQty and AMBatchProdOper.BaseTotalQty. | ||||
Descr | nvarchar(256) | Operation Description | - | |
Description:No description available | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OperationID | int | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
QtyComplete | decimal | Completed Qty. | - | |
Description:No description available | ||||
QtyCompleteAdjustedNonexistent in DB | decimal? | Completed Qty. | - | |
Description:Sum of AMProdOper.QtyComplete and AMBatchProdOper.QtyComplete. | ||||
QtyRemainingNonexistent in DB | decimal? | Remaining Qty. | - | |
Description:TotalQty subtract QtyComplete add QtyScrapped. | ||||
QtyRemainingAdjustedNonexistent in DB | decimal? | Remaining Qty. | - | |
Description:TotalQtyAdjusted subtract QtyCompleteAdjusted add QtyScrappedAdjusted. | ||||
QtyScrapped | decimal | Scrapped Qty. | - | |
Description:No description available | ||||
QtyScrappedAdjustedNonexistent in DB | decimal? | Scrapped Qty. | - | |
Description:Sum of AMProdOper.QtyScrapped and AMBatchProdOper.QtyScrapped. | ||||
QtytoProd | decimal | Qty. to Produce | - | |
Description:No description available | ||||
QtytoProdAdjustedNonexistent in DB | decimal? | Qty. to Produce | - | |
Description:Sum of AMProdOper.QtytoProd and AMBatchProdOper.QtytoProd. | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
StatusIDAdjustedNonexistent in DB | string | Status | - | |
Description:Unbound formula to calculate operation status based on unreleased quantity. | ||||
TotalQty | decimal | Total Qty. | - | |
Description:No description available | ||||
TotalQtyAdjustedNonexistent in DB | decimal? | Total Qty. | - | |
Description:Sum of AMProdOper.TotalQty and AMBatchProdOper.TotalQty. | ||||
WcID | nvarchar(20) | Work Center | - | |
Description:No description available | ||||