AM
AMOrderEstimateItemFilter
PX.Objects.AM97 of 97 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AddExistingNonexistent in DB | bit | Add Existing | - | |
Description:No description available | ||||
BaseOrderQty | decimal | 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 | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CurrentEstimateNonexistent in DB | nvarchar(MAX) | 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 | - | |
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 | ||||
EngineerID | int | Engineer | Contact | |
Description:No description available | ||||
EstimateClassID | nvarchar(20) | Estimate Class | - | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
EstimateStatus | int | Status | - | |
Description:No description available | ||||
ExtCost | decimal | Total Cost | - | |
Description:No description available | ||||
ExtCostDisplayNonexistent in DB | decimal | Total Cost | - | |
Description:No description available | ||||
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:No description available | ||||
ImageURL | nvarchar(255) | - | ||
Description:No description available | ||||
InventoryCD | nvarchar(MAX) | 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 | - | |
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 | varchar(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 | 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:No description available | ||||
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 | ||||
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 | Ref. Material Cost | - | |
Description:No description available | ||||
RequestDate | datetime2 | Request Date | - | |
Description:No description available | ||||
RevisionDate | datetime2 | Revision Date | - | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
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 | 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 | ||||
SubItemID | int | Subitem | INSubItem | |
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 | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
UnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
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 | ||||