AM
ProdOperMatl
Prod opers matls
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActEndDate | datetime | Actual End Date | - | |
Description:No description available | ||||
ActStartDate | datetime | Actual Start Date | - | |
Description:No description available | ||||
ActualFixedOverhead | decimal | Fixed Overhead | - | |
Description:No description available | ||||
ActualLabor | decimal | Labor | - | |
Description:No description available | ||||
ActualLaborTime | int | Labor Time | - | |
Description:No description available | ||||
ActualLaborTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from ActualLaborTime. Value is in total minutes. | ||||
ActualMachine | decimal | Machine | - | |
Description:No description available | ||||
ActualMachineTime | int | Actual Machine Time | - | |
Description:No description available | ||||
ActualMachineTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from ActualMachineTime. Value is in total minutes. | ||||
ActualMaterial | decimal | Material | - | |
Description:No description available | ||||
ActualSubcontract | decimal | Subcontract | - | |
Description:No description available | ||||
ActualTool | decimal | Tool | - | |
Description:No description available | ||||
ActualVariableOverhead | decimal | Variable Overhead | - | |
Description:No description available | ||||
AtVendorQuantityNonexistent in DB | decimal? | At Vendor Qty. | - | |
Description:At Vendor Qty. | ||||
AutoReportQty | bit | Auto-Report Qty | - | |
Description:Auto report qty decides if the operation allows non sequential quantities when a move occurs for a later operation. | ||||
BFlush | bit | Backflush Labor | - | |
Description:Determine whether user need to release labor manually or not | ||||
BaseAtVendorQuantityNonexistent in DB | decimal? | Base At Vendor Quantity | - | |
Description:No description available | ||||
BaseMaterialQty | decimal | Base Total Qty | - | |
Description:Tracks material qty to indicate open material issued to operations for controlling status. | ||||
BaseQtyComplete | decimal | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal? | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal | Base Qty Scrapped | - | |
Description:No description available | ||||
BaseQtytoProd | decimal | Base Qty to Produce | - | |
Description:No description available | ||||
BaseShipRemainingQtyNonexistent in DB | decimal? | Base Ship Remaining Qty | - | |
Description:No description available | ||||
BaseShippedQuantity | decimal | Base Shipped Quantity | - | |
Description:No description available | ||||
BaseTotalQty | decimal | Base Total Qty | - | |
Description:No description available | ||||
ControlPoint | bit | Control Point | - | |
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 | ||||
Descr | nvarchar(256) | Operation Description | - | |
Description:No description available | ||||
DropShippedToVendor | bit | Drop Shipped to Vendor | - | |
Description:No description available | ||||
EndDate | datetime | End Date | - | |
Description:No description available | ||||
FinishTime | int | Finish Time | - | |
Description:No description available | ||||
FinishTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from FinishTime. Value is in total minutes. | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
HasActualCostNonexistent in DB | bool? | Has Actual cost | - | |
Description:No description available | ||||
IsMatlPOLinkedNonexistent in DB | bool? | - | ||
Description:Material Linked to PO? | ||||
IsMatlRegularNSNonexistent in DB | bool? | - | ||
Description:Material Regular Non Stock | ||||
IsMatlRegularStockWBomNonexistent in DB | bool? | - | ||
Description:Material Regular Stock Item With BOM | ||||
IsMatlRegularStockWOBomNonexistent in DB | bool? | - | ||
Description:Material Regular Stock Item Without BOM | ||||
IsMatlSubCNSNonexistent in DB | bool? | - | ||
Description:Material Subcontract Non Stock | ||||
IsMatlSubCWBomMFGNonexistent in DB | bool? | - | ||
Description:Material Subcontract Stock Item With BOM | ||||
IsMatlSubCWOBomMFGNonexistent in DB | bool? | - | ||
Description:Material Subcontract Stock Item Without BOM | ||||
IssuedDescrNonexistent in DB | string | - | ||
Description:Issued % to display on material cell | ||||
IssuedMaterialQtyNonexistent in DB | decimal? | Issued Material Qty. | - | |
Description:No description available | ||||
LackOfMaterialsNonexistent in DB | bool? | Lack Of Materials | - | |
Description:Indicates whether any materials of any operations hasn't completely received materials | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineCntrMatl | int | - | ||
Description:No description available | ||||
LineCntrOvhd | int | - | ||
Description:No description available | ||||
LineCntrStep | int | - | ||
Description:No description available | ||||
LineCntrTool | int | - | ||
Description:No description available | ||||
MachineUnitTime | int | Machine Time | - | |
Description:No description available | ||||
MachineUnitTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from MachineUnitTime. Value is in total minutes. | ||||
MachineUnits | decimal | Machine Units | - | |
Description:No description available | ||||
MaterialCDNonexistent in DB | string | - | ||
Description:Material InventoryCD | ||||
MaterialIDNonexistent in DB | int? | Material ID | InventoryItem | |
Description:Material Inventory ID | ||||
MaterialLocationIDNonexistent in DB | int? | Location | INLocation | |
Description:Material location | ||||
MaterialMarkForNonexistent in DB | int? | Mark For | - | |
Description:Material mark for | ||||
MaterialScheduledEndNonexistent in DB | DateTime? | Material Scheduled End | - | |
Description:Material End Date | ||||
MaterialScheduledStartNonexistent in DB | DateTime? | Material Scheduled Start | - | |
Description:Material Start Date | ||||
MaterialSiteIDNonexistent in DB | int? | Warehouse | INSite | |
Description:Material Warehouse ID | ||||
MaterialTypeNonexistent in DB | int? | Material Type | - | |
Description:No description available | ||||
MaterialUOMNonexistent in DB | string | Material UOM | - | |
Description:No description available | ||||
MatlDescrNonexistent in DB | string | Description | - | |
Description:Material Description | ||||
MatlPOLineDescrNonexistent in DB | string | Line Desc. | - | |
Description:Material PO Line Descr | ||||
MatlPOOpenQtyNonexistent in DB | decimal? | Open Qty. | - | |
Description:Material PO Open Qty | ||||
MatlPOOrderNbrNonexistent in DB | string | Purchase Order | POOrder | |
Description:Linked PO Order Nbr for Material | ||||
MatlPOOrderQtyNonexistent in DB | decimal? | Order Qty. | - | |
Description:Material PO Qty | ||||
MatlPOOrderTypeNonexistent in DB | string | - | ||
Description:Materil Purchase Order Type - Default - RO | ||||
MatlPOPromiseDateNonexistent in DB | DateTime? | Promised On | - | |
Description:Material PO Promise Date | ||||
MatlPOUOMNonexistent in DB | string | UOM | - | |
Description:Material PO UOM | ||||
MatlPOVendorIDNonexistent in DB | int? | Vendor | BAccountR | |
Description:Material PO Vendor ID | ||||
MatlSubcontractSourceNonexistent in DB | int? | Subcontract Source | - | |
Description:No description available | ||||
MoveTime | int | Move Time | - | |
Description:No description available | ||||
MoveTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from MoveTime. Value is in total minutes. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperMatlLineIDNonexistent in DB | int? | - | ||
Description:Line ID to keep track of the grid row | ||||
OperUOMNonexistent in DB | string | UOM | - | |
Description:Operation UOM | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OperationEventCDNonexistent in DB | string | - | ||
Description:Operation Description on the event cell | ||||
OperationID | int | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
OutsideProcess | bit | Outside Process | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | PO Order Nbr. | - | |
Description:No description available | ||||
POPromiseDateNonexistent in DB | DateTime? | Promised On | - | |
Description:PO Promise Date | ||||
PhtmBOMID | nvarchar(15) | Phantom BOM ID | - | |
Description:No description available | ||||
PhtmBOMLineRef | int | Phantom BOM Ref Line Nbr | - | |
Description:No description available | ||||
PhtmBOMOperationID | int | Phantom Operation ID | - | |
Description:No description available | ||||
PhtmBOMRevisionID | nvarchar(10) | Phantom BOM Revision | - | |
Description:No description available | ||||
PhtmLevel | int | Phantom Level | - | |
Description:No description available | ||||
PhtmMatlBOMID | nvarchar(15) | Phantom Matl BOM ID | - | |
Description:No description available | ||||
PhtmMatlLineRef | int | Phantom Matl Line Nbr | - | |
Description:No description available | ||||
PhtmMatlOperationID | int | Phantom Matl Operation ID | - | |
Description:No description available | ||||
PhtmMatlRevisionID | nvarchar(10) | Phantom Matl Revision | - | |
Description:No description available | ||||
PhtmPriorLevelQty | decimal | Phantom Prior Level Qty | - | |
Description:No description available | ||||
PlanCostDate | datetime | Plan Cost Date | - | |
Description:No description available | ||||
PlanFixedOverhead | decimal | Fixed Overhead | - | |
Description:No description available | ||||
PlanLabor | decimal | Labor | - | |
Description:No description available | ||||
PlanLaborTime | int | Labor Time | - | |
Description:No description available | ||||
PlanLaborTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from PlanLaborTime. Value is in total minutes. | ||||
PlanMachine | decimal | Machine | - | |
Description:No description available | ||||
PlanMachineTime | int | Plan Machine Time | - | |
Description:No description available | ||||
PlanMachineTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from PlanMachineTime. Value is in total minutes. | ||||
PlanMaterial | decimal | Material | - | |
Description:No description available | ||||
PlanQtyToProduce | decimal | Plan Qty | - | |
Description:No description available | ||||
PlanReferenceMaterial | decimal | Ref. Material | - | |
Description:No description available | ||||
PlanSubcontract | decimal | Subcontract | - | |
Description:No description available | ||||
PlanTool | decimal | Tool | - | |
Description:No description available | ||||
PlanTotalNonexistent in DB | decimal? | Planned Total | - | |
Description:No description available | ||||
PlanVariableOverhead | decimal | Variable Overhead | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
QtyComplete | decimal | Qty Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty Remaining | - | |
Description:No description available | ||||
QtyScrapped | decimal | Qty Scrapped | - | |
Description:No description available | ||||
QtytoProd | decimal | Qty to Produce | - | |
Description:No description available | ||||
QueueTime | int | Queue Time | - | |
Description:No description available | ||||
QueueTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from QueueTime. Value is in total minutes. | ||||
ReceivedDescrNonexistent in DB | string | - | ||
Description:Received % to display on Material cell | ||||
RemainingMaterialQtyNonexistent in DB | decimal? | Remaining Material Qty. | - | |
Description:No description available | ||||
RequiredMaterialQtyNonexistent in DB | decimal? | Required Material Qty. | - | |
Description:No description available | ||||
RunUnitTime | int | Run Time | - | |
Description:No description available | ||||
RunUnitTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from RunUnitTime. Value is in total minutes. | ||||
RunUnits | decimal | Run Units | - | |
Description:No description available | ||||
ScrapAction | int | Scrap Action | - | |
Description:No description available | ||||
ScrapAmount | decimal | Scrap | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SetupTime | int | Setup Time | - | |
Description:No description available | ||||
SetupTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from SetupTime. Value is in total minutes. | ||||
ShipRemainingQtyNonexistent in DB | decimal? | Remaining Qty. to Ship | - | |
Description:Remaining Qty. to Ship | ||||
ShippedQuantity | decimal | Shipped Quantity | - | |
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SupplyOrderTypeNonexistent in DB | string | - | ||
Description:Linked Prod Order - Order Type | ||||
SupplyProdOrdIDNonexistent in DB | string | - | ||
Description:Linked Prod Order - Prod Ord ID | ||||
TotalQty | decimal | Total Qty | - | |
Description:No description available | ||||
VarianceFixedOverheadNonexistent in DB | decimal? | Fixed Overhead | - | |
Description:No description available | ||||
VarianceLaborNonexistent in DB | decimal? | Labor | - | |
Description:No description available | ||||
VarianceLaborTimeNonexistent in DB | int? | Labor Time | - | |
Description:No description available | ||||
VarianceLaborTimeRawNonexistent in DB | int? | - | ||
Description:The raw unformatted value from VarianceLaborTime. Value is in total minutes. | ||||
VarianceMachineNonexistent in DB | decimal? | Machine | - | |
Description:No description available | ||||
VarianceMaterialNonexistent in DB | decimal? | Material | - | |
Description:No description available | ||||
VarianceSubcontractNonexistent in DB | decimal? | Subcontract | - | |
Description:No description available | ||||
VarianceToolNonexistent in DB | decimal? | Tool | - | |
Description:No description available | ||||
VarianceTotalNonexistent in DB | decimal? | Total Variance | - | |
Description:No description available | ||||
VarianceVariableOverheadNonexistent in DB | decimal? | Variable Overhead | - | |
Description:No description available | ||||
VendorID | int | Vendor | BAccountR | |
Description:No description available | ||||
VendorLocationID | int | Vendor Location | Location | |
Description:No description available | ||||
WIPAdjustment | decimal | Adjustments | - | |
Description:No description available | ||||
WIPBalanceNonexistent in DB | decimal? | WIP Balance | - | |
Description:No description available | ||||
WIPComp | decimal | MFG to Inventory | - | |
Description:No description available | ||||
WIPTotalNonexistent in DB | decimal? | WIP Total | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||