AM
AMProdOper
PX.Objects.AM118 of 118 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ActEndDate | datetime2 | Actual End Date | - | |
Description:No description available | ||||
ActStartDate | datetime2 | Actual Start Date | - | |
Description:No description available | ||||
ActualFixedOverhead | decimal(19, 4) | Fixed Overhead | - | |
Description:No description available | ||||
ActualLabor | decimal(19, 4) | Labor | - | |
Description:No description available | ||||
ActualLaborTime | int | Labor Time | - | |
Description:No description available | ||||
ActualLaborTimeRawNonexistent in DB | int | ActualLaborTimeRaw | - | |
Description:No description available | ||||
ActualMachine | decimal(19, 4) | 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(19, 4) | Material | - | |
Description:No description available | ||||
ActualSubcontract | decimal(19, 4) | Subcontract | - | |
Description:No description available | ||||
ActualTool | decimal(19, 4) | Tool | - | |
Description:No description available | ||||
ActualVariableOverhead | decimal(19, 4) | Variable Overhead | - | |
Description:No description available | ||||
AtVendorQuantityNonexistent in DB | decimal | At Vendor Quantity | - | |
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(25, 6) | Base Total Qty | - | |
Description:No description available | ||||
BaseQtyComplete | decimal(25, 6) | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal(25, 6) | Base Qty Scrapped | - | |
Description:No description available | ||||
BaseQtytoProd | decimal(25, 6) | Base Qty to Produce | - | |
Description:No description available | ||||
BaseShippedQuantity | decimal(25, 6) | Base Shipped Quantity | - | |
Description:No description available | ||||
BaseShipRemainingQtyNonexistent in DB | decimal | Base Ship Remaining Qty | - | |
Description:No description available | ||||
BaseTotalQty | decimal(25, 6) | 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 | 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 | 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 | ||||
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 | ||||
MachineUnits | decimal(19, 6) | Machine Units | - | |
Description:No description available | ||||
MachineUnitTime | int | Machine Time | - | |
Description:No description available | ||||
MachineUnitTimeRawNonexistent in DB | int | MachineUnitTimeRaw | - | |
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 | ||||
OperationID | int | Operation ID | - | |
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(25, 6) | Phantom Prior Level Qty | - | |
Description:No description available | ||||
PlanCostDate | datetime2 | Plan Cost Date | - | |
Description:No description available | ||||
PlanFixedOverhead | decimal(19, 4) | Fixed Overhead | - | |
Description:No description available | ||||
PlanLabor | decimal(19, 4) | Labor | - | |
Description:No description available | ||||
PlanLaborTime | int | Labor Time | - | |
Description:No description available | ||||
PlanLaborTimeRawNonexistent in DB | int | PlanLaborTimeRaw | - | |
Description:No description available | ||||
PlanMachine | decimal(19, 4) | 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(19, 4) | Material | - | |
Description:No description available | ||||
PlanQtyToProduce | decimal(25, 6) | Plan Qty | - | |
Description:No description available | ||||
PlanReferenceMaterial | decimal(19, 4) | Ref. Material | - | |
Description:No description available | ||||
PlanSubcontract | decimal(19, 4) | Subcontract | - | |
Description:No description available | ||||
PlanTool | decimal(19, 4) | Tool | - | |
Description:No description available | ||||
PlanTotalNonexistent in DB | decimal | Planned Total | - | |
Description:No description available | ||||
PlanVariableOverhead | decimal(19, 4) | 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 | ||||
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 | ||||
RunUnits | decimal(19, 6) | 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(19, 4) | 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 | Ship Remaining Qty | - | |
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
TotalQty | decimal(25, 6) | 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 | BAccount | |
Description:No description available | ||||
VendorLocationID | int | Vendor Location | Location | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||
WIPAdjustment | decimal(19, 4) | Adjustments | - | |
Description:No description available | ||||
WIPBalanceNonexistent in DB | decimal | WIP Balance | - | |
Description:No description available | ||||
WIPComp | decimal(19, 4) | MFG to Inventory | - | |
Description:No description available | ||||
WIPTotalNonexistent in DB | decimal | WIP Total | - | |
Description:No description available | ||||