AM
AMEstimateItem
Master table for an Estimate.
View API Entity: Estimate
/entity/MANUFACTURING/25.100.001/Estimate| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseOrderQty | decimal | Base Order Qty. | - | |
Description:No description available | ||||
Body API | nvarchar | Description | - | |
Description:Rich text description of the item/estimate | ||||
BranchID API | int | Branch | - | |
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 | ||||
CuryID | nvarchar(5) | Currency | Currency | |
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 | ||||
DescriptionAsPlainTextNonexistent in DB | string | - | ||
Description:No description available | ||||
EngineerID API | int | Engineer | EPEmployee | |
Description:No description available | ||||
EstimateClassID API | nvarchar(20) | Estimate Class | AMEstimateClass | |
Description:No description available | ||||
EstimateID API | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
EstimateStatus API | int | Status | - | |
Description:Overall estimate status | ||||
ExtCost | decimal | Total Cost | - | |
Description:No description available | ||||
decimal? | Total Cost | - | ||
Description:For use in totals display without a currency view impact (hiding from currency toggle) | ||||
ExtPrice | decimal | Total Price | - | |
Description:No description available | ||||
FixedLaborCalcCost | decimal | Fix Labor Calc | - | |
Description:No description available | ||||
FixedLaborCost API | decimal | Fixed Labor Cost | - | |
Description:No description available | ||||
FixedLaborOverride API | bit | Override Fixed Labor Cost | - | |
Description:No description available | ||||
FixedOverheadCalcCost | decimal | Fix Overhead Calc Cost | - | |
Description:No description available | ||||
FixedOverheadCost API | decimal | Fixed Overhead Cost | - | |
Description:No description available | ||||
FixedOverheadOverride API | bit | Override Fixed Overhead Cost | - | |
Description:No description available | ||||
HasPriceBreak | bit | Price Breaks | - | |
Description:Indicates if AMEstimatePriceBreak data exists for the given estimate revision. | ||||
ImageURL API | nvarchar(255) | - | ||
Description:No description available | ||||
InventoryCD API | nvarchar | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
IsLockedByQuote | bit | Locked by Quote | - | |
Description:When the estimate is linked to specific quote orders, the quote order will drive some fields such as mark as primary which should prevent the user from making changes on the estimate directly | ||||
IsNonInventory API | bit | Non-Inventory | - | |
Description:No description available | ||||
bool? | Primary | - | ||
Description:No description available | ||||
ItemClassID API | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDesc API | nvarchar(256) | Item Description | - | |
Description:No description available | ||||
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 API | int | Lead Time (Days) | - | |
Description:No description available | ||||
LeadTimeOverride API | bit | Override Lead Time | - | |
Description:No description available | ||||
LineCntrHistory | int | History Line Cntr | - | |
Description:No description available | ||||
LineCntrOper | int | - | ||
Description:No description available | ||||
LineCntrPriceBreak | int | - | ||
Description:Line counter for AMEstimatePriceBreak.LineNbr. | ||||
MachineCalcCost | decimal | Machine Cost Calc | - | |
Description:No description available | ||||
MachineCost API | decimal | Machine Cost | - | |
Description:No description available | ||||
MachineMarkupPct | decimal | Machine Markup (%) | - | |
Description:No description available | ||||
MachineOverride API | bit | Override Machine Cost | - | |
Description:No description available | ||||
MarkupPct | decimal | Overall Markup (%) | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Override Overall Markup (%) | - | |
Description:Option to allow overriding MarkupPct. | ||||
MaterialCalcCost | decimal | Material Cost Calc | - | |
Description:No description available | ||||
MaterialCost API | decimal | Material Cost | - | |
Description:No description available | ||||
MaterialMarkupPct | decimal | Material Markup (%) | - | |
Description:No description available | ||||
MaterialOverride API | 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 | ||||
OwnerID API | int | Owner | EPEmployee | |
Description:No description available | ||||
PCreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
PCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
PCreatedDateTime | datetime | - | ||
Description:No description available | ||||
PEstimateID | nvarchar(15) | Estimate ID | - | |
Description:EstimateID for AMEstimatePrimary | ||||
PLastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
PLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
PLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PriceBreakPrimaryLineNbr | int | - | ||
Description:Stores the primary AMEstimatePriceBreak.LineNbr. | ||||
PriceOverride | bit | Override Unit Price | - | |
Description:No description available | ||||
PrimaryRevisionID | nvarchar(10) | Primary Revision | - | |
Description:Primary revision of current estimate | ||||
PromiseDate API | datetime | Promise Date | - | |
Description:No description available | ||||
QuoteSource API | int | Quote Source | - | |
Description:No description available | ||||
ReferenceMaterialCost API | decimal | Ref. Material Cost | - | |
Description:No description available | ||||
RequestDate API | datetime | Request Date | - | |
Description:No description available | ||||
RevisionDate API | datetime | Revision Date | - | |
Description:No description available | ||||
RevisionID API | nvarchar(10) | Revision | - | |
Description:No description available | ||||
RoundUpUnitPrice | bit | Round Unit Prices | - | |
Description:Option to round up CuryUnitPrice. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractCalcCost | decimal | Subcontract Cost Calc | - | |
Description:No description available | ||||
SubcontractCost API | decimal | Subcontract Cost | - | |
Description:No description available | ||||
SubcontractMarkupPct | decimal | Subcontract Markup (%) | - | |
Description:No description available | ||||
SubcontractOverride API | bit | Override Subcontract Cost | - | |
Description:No description available | ||||
ToolCalcCost | decimal | Tool Cost Calc | - | |
Description:No description available | ||||
ToolCost API | decimal | Tool Cost | - | |
Description:No description available | ||||
ToolMarkupPct | decimal | Tool Markup (%) | - | |
Description:No description available | ||||
ToolOverride API | 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 | Var Labor Calc | - | |
Description:No description available | ||||
VariableLaborCost API | decimal | Var. Labor Cost | - | |
Description:No description available | ||||
VariableLaborOverride API | bit | Override Var. Labor Cost | - | |
Description:No description available | ||||
VariableOverheadCalcCost | decimal | Var Overhead Cost Calc | - | |
Description:No description available | ||||
VariableOverheadCost API | decimal | Var. Overhead Cost | - | |
Description:No description available | ||||
VariableOverheadOverride API | bit | Override Var. Overhead Cost | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||