AM
ProdOperMatl
PX.Objects.AM156 of 156 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
MatlPOOrderNbrNonexistent in DB | nvarchar(20) | Purchase Order | POOrder | |
Description:No description available | ||||
MatlPOOrderTypeNonexistent in DB | nvarchar(MAX) | MatlPOOrderType | - | |
Description:No description available | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
ActEndDate | datetime2 | Actual End Date | - | |
Description:No description available | ||||
ActStartDate | datetime2 | 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 | ActualLaborTimeRaw | - | |
Description:No description available | ||||
ActualMachine | decimal | Machine | - | |
Description:No description available | ||||
ActualMachineTime | int | Actual Machine Time | - | |
Description:No description available | ||||
ActualMachineTimeRawNonexistent in DB | int | ActualMachineTimeRaw | - | |
Description:No description available | ||||
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:No description available | ||||
AutoReportQty | bit | Auto-Report Qty | - | |
Description:No description available | ||||
BaseAtVendorQuantityNonexistent in DB | decimal | Base At Vendor Quantity | - | |
Description:No description available | ||||
BaseMaterialQty | decimal | Base Total Qty | - | |
Description:No description available | ||||
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 | ||||
BaseShippedQuantity | decimal | Base Shipped Quantity | - | |
Description:No description available | ||||
BaseShipRemainingQtyNonexistent in DB | decimal | Base Ship Remaining Qty | - | |
Description:No description available | ||||
BaseTotalQty | decimal | Base Total Qty | - | |
Description:No description available | ||||
BFlush | bit | Backflush Labor | - | |
Description:No description available | ||||
ControlPoint | bit | Control Point | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(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 | datetime2 | End Date | - | |
Description:No description available | ||||
FinishTime | int | Finish Time | - | |
Description:No description available | ||||
FinishTimeRawNonexistent in DB | int | FinishTimeRaw | - | |
Description:No description available | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
HasActualCostNonexistent in DB | bit | Has Actual cost | - | |
Description:No description available | ||||
IsMatlPOLinkedNonexistent in DB | bit | IsMatlPOLinked | - | |
Description:No description available | ||||
IsMatlRegularNSNonexistent in DB | bit | IsMatlRegularNS | - | |
Description:No description available | ||||
IsMatlRegularStockWBomNonexistent in DB | bit | IsMatlRegularStockWBom | - | |
Description:No description available | ||||
IsMatlRegularStockWOBomNonexistent in DB | bit | IsMatlRegularStockWOBom | - | |
Description:No description available | ||||
IsMatlSubCNSNonexistent in DB | bit | IsMatlSubCNS | - | |
Description:No description available | ||||
IsMatlSubCWBomMFGNonexistent in DB | bit | IsMatlSubCWBomMFG | - | |
Description:No description available | ||||
IsMatlSubCWOBomMFGNonexistent in DB | bit | IsMatlSubCWOBomMFG | - | |
Description:No description available | ||||
IssuedDescrNonexistent in DB | nvarchar(MAX) | IssuedDescr | - | |
Description:No description available | ||||
IssuedMaterialQtyNonexistent in DB | decimal | Issued Material Qty. | - | |
Description:No description available | ||||
LackOfMaterialsNonexistent in DB | bit | Lack Of Materials | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(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 | ||||
MachineUnits | decimal | Machine Units | - | |
Description:No description available | ||||
MachineUnitTime | int | Machine Time | - | |
Description:No description available | ||||
MachineUnitTimeRawNonexistent in DB | int | MachineUnitTimeRaw | - | |
Description:No description available | ||||
MaterialCDNonexistent in DB | nvarchar(MAX) | MaterialCD | - | |
Description:No description available | ||||
MaterialIDNonexistent in DB | int | Material ID | InventoryItem | |
Description:No description available | ||||
MaterialLocationIDNonexistent in DB | int | Location | INLocation | |
Description:No description available | ||||
MaterialMarkForNonexistent in DB | int | Mark For | - | |
Description:No description available | ||||
MaterialScheduledEndNonexistent in DB | datetime | Material Scheduled End | - | |
Description:No description available | ||||
MaterialScheduledStartNonexistent in DB | datetime | Material Scheduled Start | - | |
Description:No description available | ||||
MaterialSiteIDNonexistent in DB | int | Warehouse | INSite | |
Description:No description available | ||||
MaterialTypeNonexistent in DB | int | Material Type | - | |
Description:No description available | ||||
MaterialUOMNonexistent in DB | nvarchar(10) | Material UOM | - | |
Description:No description available | ||||
MatlDescrNonexistent in DB | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
MatlPOLineDescrNonexistent in DB | nvarchar(MAX) | Line Desc. | - | |
Description:No description available | ||||
MatlPOOpenQtyNonexistent in DB | decimal | Open Qty. | - | |
Description:No description available | ||||
MatlPOOrderQtyNonexistent in DB | decimal | Order Qty. | - | |
Description:No description available | ||||
MatlPOPromiseDateNonexistent in DB | datetime | Promised On | - | |
Description:No description available | ||||
MatlPOUOMNonexistent in DB | nvarchar(MAX) | UOM | - | |
Description:No description available | ||||
MatlPOVendorIDNonexistent in DB | int | Vendor | BAccount | |
Description:No description available | ||||
MatlSubcontractSourceNonexistent in DB | int | Subcontract Source | - | |
Description:No description available | ||||
MoveTime | int | Move Time | - | |
Description:No description available | ||||
MoveTimeRawNonexistent in DB | int | MoveTimeRaw | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationEventCDNonexistent in DB | nvarchar(MAX) | OperationEventCD | - | |
Description:No description available | ||||
OperationID | int | Operation ID | - | |
Description:No description available | ||||
OperMatlLineIDNonexistent in DB | int | OperMatlLineID | - | |
Description:No description available | ||||
OperUOMNonexistent in DB | nvarchar(MAX) | UOM | - | |
Description:No description available | ||||
OutsideProcess | bit | Outside Process | - | |
Description:No description available | ||||
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 | datetime2 | 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 | PlanLaborTimeRaw | - | |
Description:No description available | ||||
PlanMachine | decimal | Machine | - | |
Description:No description available | ||||
PlanMachineTime | int | Plan Machine Time | - | |
Description:No description available | ||||
PlanMachineTimeRawNonexistent in DB | int | PlanMachineTimeRaw | - | |
Description:No description available | ||||
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 | ||||
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: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 | ||||
QueueTime | int | Queue Time | - | |
Description:No description available | ||||
QueueTimeRawNonexistent in DB | int | QueueTimeRaw | - | |
Description:No description available | ||||
ReceivedDescrNonexistent in DB | nvarchar(MAX) | ReceivedDescr | - | |
Description:No description available | ||||
RemainingMaterialQtyNonexistent in DB | decimal | Remaining Material Qty. | - | |
Description:No description available | ||||
RequiredMaterialQtyNonexistent in DB | decimal | Required Material Qty. | - | |
Description:No description available | ||||
RunUnits | decimal | Run Units | - | |
Description:No description available | ||||
RunUnitTime | int | Run Time | - | |
Description:No description available | ||||
RunUnitTimeRawNonexistent in DB | int | RunUnitTimeRaw | - | |
Description:No description available | ||||
ScrapAction | int | Scrap Action | - | |
Description:No description available | ||||
ScrapAmount | decimal | Scrap | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SetupTime | int | Setup Time | - | |
Description:No description available | ||||
SetupTimeRawNonexistent in DB | int | SetupTimeRaw | - | |
Description:No description available | ||||
ShippedQuantity | decimal(25, 6) | Shipped Quantity | - | |
Description:No description available | ||||
ShipRemainingQtyNonexistent in DB | decimal | Remaining Qty. to Ship | - | |
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SupplyOrderTypeNonexistent in DB | nvarchar(MAX) | SupplyOrderType | - | |
Description:No description available | ||||
SupplyProdOrdIDNonexistent in DB | nvarchar(MAX) | SupplyProdOrdID | - | |
Description:No description available | ||||
TotalQty | decimal | Total Qty | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
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 | VarianceLaborTimeRaw | - | |
Description:No description available | ||||
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 | - | |
Description:No description available | ||||
VendorLocationID | int | Vendor Location | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | - | |
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 | ||||