AM
AMEstimatePriceBreak
Estimate price break data entered on the Estimate Maintenance (AM303000) form (corresponding to the EstimateMaint graph)
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseOrderQty | decimal | - | ||
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 | ||||
CuryExtCost | decimal | Total Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Total Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | AMEstimateItem | |
Description:No description available | ||||
ExtCost | decimal | Total Cost | - | |
Description:No description available | ||||
ExtPrice | decimal | Total Price | - | |
Description:No description available | ||||
FixedLaborCalcCost | decimal | - | ||
Description:No description available | ||||
FixedLaborCost | decimal | Fixed Labor Cost | - | |
Description:No description available | ||||
FixedLaborOverride | bit | Override Fixed Labor Cost | - | |
Description:No description available | ||||
FixedOverheadCalcCost | decimal | Fix Overhead Calc Cost | - | |
Description:No description available | ||||
FixedOverheadCost | decimal | Fixed Overhead Cost | - | |
Description:No description available | ||||
FixedOverheadOverride | bit | Override Fixed Overhead Cost | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bool? | Primary | - | |
Description:Is the AMEstimatePriceBreak the primary record which maintains its values with AMEstimateItem. | ||||
LaborMarkupPct | decimal | Labor Markup (%) | - | |
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 | ||||
LeadTime | int | Lead Time (Days) | - | |
Description:No description available | ||||
LeadTimeOverride | bit | Override Lead Time | - | |
Description:No description available | ||||
LineNbr | int | - | ||
Description:The line number of the document. | ||||
MachineCalcCost | decimal | - | ||
Description:No description available | ||||
MachineCost | decimal | Machine Cost | - | |
Description:No description available | ||||
MachineMarkupPct | decimal | Machine Markup (%) | - | |
Description:No description available | ||||
MachineOverride | bit | Override Machine Cost | - | |
Description:No description available | ||||
MarkupPct | decimal | Overall Markup (%) | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Override Overall Markup (%) | - | |
Description:No description available | ||||
MaterialCalcCost | decimal | - | ||
Description:No description available | ||||
MaterialCost | decimal | Material Cost | - | |
Description:No description available | ||||
MaterialMarkupPct | decimal | Material Markup (%) | - | |
Description:No description available | ||||
MaterialOverride | bit | Override Material Cost | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQty | decimal | Order Qty. | - | |
Description:No description available | ||||
OverheadMarkupPct | decimal | Overhead Markup (%) | - | |
Description:No description available | ||||
PriceOverride | bit | Override Unit Price | - | |
Description:No description available | ||||
Print | bit | - | ||
Description:Option to control including AMEstimatePriceBreak data in reporting. | ||||
ReferenceMaterialCost | decimal | Ref. Material Cost | - | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
Description:No description available | ||||
SubcontractCalcCost | decimal | - | ||
Description:No description available | ||||
SubcontractCost | decimal | Subcontract Cost | - | |
Description:No description available | ||||
SubcontractMarkupPct | decimal | Subcontract Markup (%) | - | |
Description:No description available | ||||
SubcontractOverride | bit | Override Subcontract Cost | - | |
Description:No description available | ||||
ToolCalcCost | decimal | - | ||
Description:No description available | ||||
ToolCost | decimal | Tool Cost | - | |
Description:No description available | ||||
ToolMarkupPct | decimal | Tool Markup (%) | - | |
Description:No description available | ||||
ToolOverride | bit | Override Tool Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
VariableLaborCalcCost | decimal | - | ||
Description:No description available | ||||
VariableLaborCost | decimal | Var. Labor Cost | - | |
Description:No description available | ||||
VariableLaborOverride | bit | Override Var. Labor Cost | - | |
Description:No description available | ||||
VariableOverheadCalcCost | decimal | - | ||
Description:No description available | ||||
VariableOverheadCost | decimal | Var. Overhead Cost | - | |
Description:No description available | ||||
VariableOverheadOverride | bit | Override Var. Overhead Cost | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||