AM
AMEstimateReference
PX.Objects.AM29 of 29 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
EstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
Description:No description available | ||||
BAccountID | int | Customer | BAccount | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
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 | ||||
CuryExtPrice | decimal(19, 6) | Total Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
ExternalRefNbr | nvarchar(15) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
ExtPrice | decimal(19, 6) | Total Price | - | |
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 | ||||
OpportunityID | nvarchar(10) | Opportunity ID | CROpportunity | |
Description:No description available | ||||
OpportunityQuoteID | uniqueidentifier | Opportunity Quote ID | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr | SOOrder | |
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
QuoteNbr | nvarchar(15) | Quote Nbr | - | |
Description:No description available | ||||
QuoteNbrLinkNonexistent in DB | nvarchar(15) | Quote Nbr | - | |
Description:No description available | ||||
QuoteType | char(2) | Quote Type | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxLineNbr | int | Tax Line Nbr. | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||