PM
PMQuote
PX.Objects.PM108 of 108 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
QuoteNbr | nvarchar(255) | Quote Nbr. | - | |
Description:No description available | ||||
AllowOverrideContactAddress | bit | Override Contact and Address | - | |
Description:No description available | ||||
AllowOverrideShippingContactAddress | bit | Override | - | |
Description:No description available | ||||
Amount | decimal(19, 4) | - | ||
Description:The total estimated sale of the project quote in the base currency of the tenant. | ||||
Approved | bit | Approved | - | |
Description:Specifies (if set to ) that the document has been approved. | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:Provides the values of attributes associated with the project quote. The field is reserved for internal use. | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BAccountID | int | Business Account | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:No description available | ||||
CarrierID | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
ClassIDNonexistent in DB | nvarchar(20) | - | ||
Description:The class ID for the attributes. The field always returns the current GroupTypes.Project. | ||||
ContactID | int | Contact | - | |
Description:No description available | ||||
CostTotal | decimal(19, 4) | - | ||
Description:The total estimated cost of the project quote in the base currency of the tenant. | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Date Created | - | |
Description:No description available | ||||
CuryAmount | decimal(19, 4) | Detail Total | - | |
Description:No description available | ||||
CuryCostTotal | decimal(19, 4) | Total Cost | - | |
Description:The total estimated cost of the project quote. | ||||
CuryDiscTot | decimal(19, 4) | Discount | - | |
Description:No description available | ||||
CuryExtPriceTotal | decimal(19, 4) | Subtotal | - | |
Description:No description available | ||||
CuryGrossMarginAmountNonexistent in DB | decimal | Gross Margin Amount | - | |
Description:The estimated gross margin of the project quote. Calculated as the difference between Total Sales and Total Cost. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:The identifier of the CurrencyInfo record associated with the project quote. | ||||
CuryLineDiscountTotal | decimal(19, 4) | Line Discounts | - | |
Description:No description available | ||||
CuryLineDocDiscountTotal | decimal(19, 4) | CuryLineDocDiscountTotal | - | |
Description:No description available | ||||
CuryLineTotal | decimal(19, 4) | Total Sales | - | |
Description:The total estimated sale of the project quote in the project quote currency. | ||||
CuryProductsAmount | decimal(19, 4) | Total | - | |
Description:No description available | ||||
CuryQuoteTotalNonexistent in DB | decimal | Quote Total | - | |
Description:The overall total of the project quote. Calculated as the sum of the Total Sales and Tax Total amounts. | ||||
CuryTaxInclTotal | decimal(19, 4) | Inclusive Tax Total | - | |
Description:The total inclusive tax amount. | ||||
CuryTaxTotal | decimal(19, 4) | Tax Total | - | |
Description:The total tax of the project quote in the project quote currency. | ||||
CuryVatExemptTotal | decimal(19, 4) | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal(19, 4) | VAT Taxable Total | - | |
Description:No description available | ||||
CuryWgtAmountNonexistent in DB | decimal | Wgt. Total | - | |
Description:No description available | ||||
DefQuoteID | uniqueidentifier | - | ||
Description:No description available | ||||
DiscTot | decimal(19, 4) | - | ||
Description:No description available | ||||
DocumentDate | datetime2 | Date | - | |
Description:The date of the project quote. Defaults to the current business date. | ||||
ExpirationDate | datetime | Expiration Date | - | |
Description:The expiration date of the project quote. | ||||
ExternalRef | nvarchar(255) | External Ref. | - | |
Description:The external reference number of the project quote. | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
ExtPriceTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
FOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
GrossMarginAmountNonexistent in DB | decimal | Gross Margin Amount | - | |
Description:The estimated gross margin of the project quote in the base currency of the tenant. | ||||
GrossMarginPctNonexistent in DB | decimal | Gross Margin (%) | - | |
Description:The percentage of the estimated gross margin of the project quote. | ||||
HoldNonexistent in DB | bit | Hold | - | |
Description:Specifies (if set to ) that the document was hold. | ||||
Insurance | bit | Insurance | - | |
Description:No description available | ||||
IsDisabledNonexistent in DB | bit | Disabled | - | |
Description:A service field, which is used to configure the availability of the project quote fields. | ||||
IsFirstQuoteNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPrimaryNonexistent in DB | bit | Primary | - | |
Description:Specifies (if set to ) that the project quote is the primary quote of the opportunity associated with the project quote. | ||||
IsSetupApprovalRequiredNonexistent in DB | unspecified | Approvable Setup | - | |
Description:Specifies (if set to ) that the approval workflow is enabled for the project quotes. | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:Specifies (if set to ) that the amount of tax calculated with the external tax engine, such as Avalara, is up to date. If the value of this field is , the document was updated since last synchronization with the tax engine. Taxes might need recalculation. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified Date | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscountTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
LineDocDiscountTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
LineTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
LocationID | int | Location | - | |
Description:No description available | ||||
ManualTotalEntry | bit | Manual Amount | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpportunityAddressID | int | - | ||
Description:No description available | ||||
OpportunityContactID | int | - | ||
Description:No description available | ||||
OpportunityID | nvarchar(15) | Opportunity ID | CROpportunity | |
Description:No description available | ||||
OpportunityIsActive | bit | Opportunity Is Active | - | |
Description:Specifies (if set to ) that the opportunity associated with the project quote is active. | ||||
OwnerID | int | Owner | - | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | - | |
Description:No description available | ||||
ProductCntr | int | - | ||
Description:No description available | ||||
ProductsAmount | decimal(19, 4) | - | ||
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
ProjectManager | int | Project Manager | EPEmployee | |
Description:The identifier of the employee who is responsible for the estimation of the project quote and who will be the project manager. The value of this field corresponds to the value of the EPEmployee.bAccountID field. | ||||
QuoteID | uniqueidentifier | - | ||
Description:No description available | ||||
QuoteProjectCD | nvarchar(30) | New Project ID | - | |
Description:The reference number that will be assigned to a project created based on the project quote. | ||||
QuoteProjectID | int | Project ID | PMProject | |
Description:No description available | ||||
QuoteTotalNonexistent in DB | decimal | Quote Total | - | |
Description:The overall total of the project quote in the base currency of the tenant. | ||||
QuoteType | char(1) | Type | - | |
Description:The type of the quote. The field can have one of the following values: ""D"": Sales Quote, ""P"": Project Quote | ||||
RCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
RCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
RCreatedDateTime | datetime | - | ||
Description:No description available | ||||
RefOpportunityID | nvarchar(15) | - | ||
Description:No description available | ||||
Rejected | bit | Rejected | - | |
Description:Specifies (if set to ) that the document has been rejected. | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
RLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
RLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
RLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
RNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
SaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipAddressID | int | - | ||
Description:No description available | ||||
ShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
ShipContactID | int | - | ||
Description:No description available | ||||
ShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
ShipZoneID | nvarchar(15) | Shipping Zone | ShippingZone | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:The status of the project quote. The field can have one of the following values: ""D"": Draft, ""A"": Prepared, ""S"": Sent, ""P"": Pending Approval, ""R"": Rejected, ""T"": Accepted, ""O"": Converted, ""L"": Declined, ""C"": Closed, ""V"": Approved | ||||
Subject | nvarchar(255) | Description | - | |
Description:The description of the project quote. | ||||
SubmitCancelledNonexistent in DB | bit | - | ||
Description:Specifies (if set to ) that the submission of the document was canceled due to errors. This is a service field. | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxInclTotal | decimal(19, 4) | Inclusive Tax Total in Base Currency | - | |
Description:The total inclusive tax amount in base currency. | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxTotal | decimal(19, 4) | - | ||
Description:The total tax of the project quote in the base currency of the tenant. | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:The tax zone. | ||||
TemplateID | int | Project Template | PMProject | |
Description:No description available | ||||
TermsID | nvarchar(10) | Credit Terms | Terms | |
Description:No description available | ||||
TextForProductsGridNonexistent in DB | nvarchar(MAX) | Availability footer | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VatExemptTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||