AM
AMOrderEstimateItemFilter
Filter for open estimates.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AddExistingNonexistent in DB | bool? | Add Existing | - | |
Description:No description available | ||||
BaseOrderQty | decimal | Base Order Qty. | - | |
Description:No description available | ||||
Body | nvarchar | Description | - | |
Description:Rich text description of the item/estimate | ||||
BranchID | 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 | ||||
CurrentEstimateNonexistent in DB | string | Current Estimate | - | |
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 | int | Engineer | EPEmployee | |
Description:No description available | ||||
EstimateClassID | nvarchar(20) | Estimate Class | AMEstimateClass | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | AMEstimateItem | |
Description:No description available | ||||
EstimateStatus | int | Status | - | |
Description:Overall estimate status | ||||
ExtCost | decimal | Total Cost | - | |
Description:No description available | ||||
ExtCostDisplayNonexistent in DB | 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 | 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 | ||||
HasPriceBreak | bit | Price Breaks | - | |
Description:Indicates if AMEstimatePriceBreak data exists for the given estimate revision. | ||||
ImageURL | nvarchar(255) | - | ||
Description:No description available | ||||
InventoryCD | 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 | bit | Non-Inventory | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bool? | Primary | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDesc | 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 | int | Lead Time (Days) | - | |
Description:No description available | ||||
LeadTimeOverride | 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 | 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:Option to allow overriding MarkupPct. | ||||
MaterialCalcCost | decimal | Material Cost Calc | - | |
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 | ||||
OwnerID | 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 | datetime | Promise Date | - | |
Description:No description available | ||||
QuoteSource | int | Quote Source | - | |
Description:No description available | ||||
ReferenceMaterialCost | decimal | Ref. Material Cost | - | |
Description:No description available | ||||
RequestDate | datetime | Request Date | - | |
Description:No description available | ||||
RevisionDate | datetime | Revision Date | - | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
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 | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractCalcCost | decimal | Subcontract Cost Calc | - | |
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 | Tool Cost Calc | - | |
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 | Var Labor Calc | - | |
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 | Var Overhead Cost Calc | - | |
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 | ||||