AM
AMEstimateItem
PX.Objects.AM95 of 95 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
EstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | - | |
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | Base Order Qty. | - | |
Description:No description available | ||||
Body | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
BranchID | int | Branch | 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(19, 6) | Total Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal(19, 6) | Total Price | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
EngineerID | int | Engineer | Contact | |
Description:No description available | ||||
EstimateClassID | nvarchar(20) | Estimate Class | AMEstimateClass | |
Description:No description available | ||||
EstimateStatus | int | Status | - | |
Description:No description available | ||||
ExtCost | decimal(19, 6) | Total Cost | - | |
Description:No description available | ||||
ExtCostDisplayNonexistent in DB | decimal | Total Cost | - | |
Description:No description available | ||||
ExtPrice | decimal(19, 6) | Total Price | - | |
Description:No description available | ||||
FixedLaborCalcCost | decimal(19, 6) | Fix Labor Calc | - | |
Description:No description available | ||||
FixedLaborCost | decimal(19, 6) | Fixed Labor Cost | - | |
Description:No description available | ||||
FixedLaborOverride | bit | Override Fixed Labor Cost | - | |
Description:No description available | ||||
FixedOverheadCalcCost | decimal(19, 6) | Fix Overhead Calc Cost | - | |
Description:No description available | ||||
FixedOverheadCost | decimal(19, 6) | Fixed Overhead Cost | - | |
Description:No description available | ||||
FixedOverheadOverride | bit | Override Fixed Overhead Cost | - | |
Description:No description available | ||||
HasPriceBreak | bit | Price Breaks | - | |
Description:No description available | ||||
ImageURL | nvarchar(255) | - | ||
Description:No description available | ||||
InventoryCD | nvarchar(30) | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
IsLockedByQuote | bit | Locked by Quote | - | |
Description:No description available | ||||
IsNonInventory | bit | Non-Inventory | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bit | 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(19, 6) | 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 | LineCntrPriceBreak | - | |
Description:No description available | ||||
MachineCalcCost | decimal(19, 6) | Machine Cost Calc | - | |
Description:No description available | ||||
MachineCost | decimal(19, 6) | Machine Cost | - | |
Description:No description available | ||||
MachineMarkupPct | decimal(19, 6) | Machine Markup (%) | - | |
Description:No description available | ||||
MachineOverride | bit | Override Machine Cost | - | |
Description:No description available | ||||
MarkupPct | decimal(19, 6) | Overall Markup (%) | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Override Overall Markup (%) | - | |
Description:No description available | ||||
MaterialCalcCost | decimal(19, 6) | Material Cost Calc | - | |
Description:No description available | ||||
MaterialCost | decimal(19, 6) | Material Cost | - | |
Description:No description available | ||||
MaterialMarkupPct | decimal(19, 6) | Material Markup (%) | - | |
Description:No description available | ||||
MaterialOverride | bit | Override Material Cost | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
Description:No description available | ||||
OverheadMarkupPct | decimal(19, 6) | Overhead Markup (%) | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
PCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
PCreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
PCreatedDateTime | datetime | - | ||
Description:No description available | ||||
PEstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
PLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
PLastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
PLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PriceBreakPrimaryLineNbr | int | PriceBreakPrimaryLineNbr | - | |
Description:No description available | ||||
PriceOverride | bit | Override Unit Price | - | |
Description:No description available | ||||
PrimaryRevisionID | nvarchar(10) | Primary Revision | - | |
Description:No description available | ||||
PromiseDate | datetime2 | Promise Date | - | |
Description:No description available | ||||
QuoteSource | int | Quote Source | - | |
Description:No description available | ||||
ReferenceMaterialCost | decimal(19, 4) | Ref. Material Cost | - | |
Description:No description available | ||||
RequestDate | datetime2 | Request Date | - | |
Description:No description available | ||||
RevisionDate | datetime2 | Revision Date | - | |
Description:No description available | ||||
RoundUpUnitPrice | bit | Round Unit Prices | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubcontractCalcCost | decimal(19, 6) | Subcontract Cost Calc | - | |
Description:No description available | ||||
SubcontractCost | decimal(19, 6) | Subcontract Cost | - | |
Description:No description available | ||||
SubcontractMarkupPct | decimal(19, 6) | Subcontract Markup (%) | - | |
Description:No description available | ||||
SubcontractOverride | bit | Override Subcontract Cost | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
ToolCalcCost | decimal(19, 6) | Tool Cost Calc | - | |
Description:No description available | ||||
ToolCost | decimal(19, 6) | Tool Cost | - | |
Description:No description available | ||||
ToolMarkupPct | decimal(19, 6) | Tool Markup (%) | - | |
Description:No description available | ||||
ToolOverride | bit | Override Tool Cost | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VariableLaborCalcCost | decimal(19, 6) | Var Labor Calc | - | |
Description:No description available | ||||
VariableLaborCost | decimal(19, 6) | Var. Labor Cost | - | |
Description:No description available | ||||
VariableLaborOverride | bit | Override Var. Labor Cost | - | |
Description:No description available | ||||
VariableOverheadCalcCost | decimal(19, 6) | Var Overhead Cost Calc | - | |
Description:No description available | ||||
VariableOverheadCost | decimal(19, 6) | Var. Overhead Cost | - | |
Description:No description available | ||||
VariableOverheadOverride | bit | Override Var. Overhead Cost | - | |
Description:No description available | ||||