AM
AMEstimateItem
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
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 | ||||
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 | Contact | |
Description:No description available | ||||
EstimateClassID | nvarchar(20) | Estimate Class | AMEstimateClass | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
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 | Fixed 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 Break | - | |
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 | - | ||
Description:No description available | ||||
IsNonInventory | bit | Non-Inventory | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDesc | nvarchar(255) | 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 | ||||
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 | Contact | |
Description:No description available | ||||
PriceBreakPrimaryLineNbr | int | - | ||
Description:Stores the primary AMEstimatePriceBreak.LineNbr. | ||||
PriceOverride | bit | Override Unit Price | - | |
Description:No description available | ||||
PromiseDate | datetime | Promise Date | - | |
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 | - | |
Description:No description available | ||||
RoundUpUnitPrice | bit | Roundup Unit Prices | - | |
Description:Option to round up CuryUnitPrice. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
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 | ||||