AM
AMProdTotal
Table that contains the planned and actual costs of a production order. These records can be viewed on the Production Order Details (AM209000) form (corresponding to the ProdDetail graph). Parent: AMProdItem
View API Entity: ProductionOrderTotals
/entity/MANUFACTURING/25.100.001/ProductionOrderTotals| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActualFixedOverhead API | decimal | Fixed Overhead | - | |
Description:No description available | ||||
ActualLabor API | decimal | Labor | - | |
Description:No description available | ||||
ActualLaborTime | int | Labor Time | - | |
Description:No description available | ||||
int? | - | |||
Description:No description available | ||||
ActualMachine API | decimal | Machine | - | |
Description:No description available | ||||
ActualMaterial API | decimal | Material | - | |
Description:No description available | ||||
ActualSubcontract API | decimal | Subcontract | - | |
Description:No description available | ||||
ActualTool API | decimal | Tool | - | |
Description:No description available | ||||
ActualVariableOverhead API | decimal | Variable Overhead | - | |
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 | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
PlanCostDate API | datetime | Plan Cost Date | - | |
Description:No description available | ||||
PlanFixedOverhead API | decimal | Fixed Overhead | - | |
Description:No description available | ||||
PlanLabor API | decimal | Labor | - | |
Description:No description available | ||||
PlanLaborTime | int | Labor Time | - | |
Description:No description available | ||||
int? | - | |||
Description:No description available | ||||
PlanMachine API | decimal | Machine | - | |
Description:No description available | ||||
PlanMaterial API | decimal | Material | - | |
Description:No description available | ||||
PlanQtyToProduce | decimal | Qty to Produce | - | |
Description:No description available | ||||
PlanReferenceMaterial API | decimal | Ref. Material | - | |
Description:No description available | ||||
PlanSubcontract API | decimal | Subcontract | - | |
Description:No description available | ||||
PlanTool API | decimal | Tool | - | |
Description:No description available | ||||
decimal? | Plan Total | - | ||
Description:No description available | ||||
decimal? | Unit Cost | - | ||
Description:No description available | ||||
PlanVariableOverhead API | decimal | Variable Overhead | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
QtyCompleteNonexistent in DB | decimal? | Qty Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty Remaining | - | |
Description:No description available | ||||
ScrapAmount API | decimal | Scrap | - | |
Description:No description available | ||||
decimal? | Fixed Overhead | - | ||
Description:No description available | ||||
decimal? | Labor | - | ||
Description:No description available | ||||
VarianceLaborTimeNonexistent in DB | int? | Labor Time | - | |
Description:No description available | ||||
int? | - | |||
Description:No description available | ||||
decimal? | Machine | - | ||
Description:No description available | ||||
decimal? | Material | - | ||
Description:No description available | ||||
decimal? | Subcontract | - | ||
Description:No description available | ||||
decimal? | Tool | - | ||
Description:No description available | ||||
decimal? | Total Variance | - | ||
Description:No description available | ||||
decimal? | Variable Overhead | - | ||
Description:No description available | ||||
WIPAdjustment API | decimal | Adjustments | - | |
Description:No description available | ||||
decimal? | WIP Balance | - | ||
Description:No description available | ||||
decimal? | MFG to Inventory | - | ||
Description:No description available | ||||
decimal? | WIP Total | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||