CR
CRQuote
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMCuryEstimateTotal | decimal | Est. Amount | - | |
Description:Pointer to CROpportunityRevisionExt.AMCuryEstimateTotal | ||||
AMEstimateQty | decimal | Estimate Qty. | - | |
Description:Pointer to CROpportunityRevisionExt.AMEstimateQty | ||||
AMEstimateTotal | decimal | Estimate Total | - | |
Description:Pointer to CROpportunityRevisionExt.AMEstimateTotal | ||||
AllowOverrideBillingContactAddressNonexistent in DB | bool? | - | ||
Description:Virtual field used to set CRBillingContact.IsDefaultContact and CRBillingAddress.IsDefaultAddress by the workflow. The behavior is controlled by CROpportunityContactAddress.CROpportunityContactAddressExt{TGraph}. | ||||
AllowOverrideContactAddress | bit | Override | - | |
Description:No description available | ||||
AllowOverrideShippingContactAddress | bit | Override Shipping Info | - | |
Description:No description available | ||||
Amount | decimal | - | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
BillAddressID | int | CRAddress | ||
Description:No description available | ||||
BillContactID | int | CRContact | ||
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 | ||||
ContactID | int | Contact | Contact | |
Description:No description available | ||||
CostTotal | decimal | - | ||
Description:A pointer to CROpportunityRevision.CostTotal. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Date Created | - | |
Description:No description available | ||||
CuryAmount | decimal | Detail Total | - | |
Description:No description available | ||||
CuryCostTotal | decimal | Cost | - | |
Description:A pointer to CROpportunityRevision.CuryCostTotal. | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document of the opportunity(line discounts are not included). | ||||
CuryExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryGrossMarginAmountNonexistent in DB | decimal? | Gross Margin Amount | - | |
Description:The gross margin amount in the base currency. The amount is calculated from CRQuote.CuryLineTotal and CuryCostTotal. | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineDiscountTotal | decimal | Line Discounts | - | |
Description:No description available | ||||
CuryLineDocDiscountTotal | decimal | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryMarginAmt | decimal | Est. Margin Amount | - | |
Description:The quote's estimated margin amount (in the currency of the document). | ||||
CuryNetSalesTotal | decimal | - | ||
Description:The sum of the line amounts without the taxes and with the applied group and document discounts (in the currency of the document). | ||||
CuryOrderDiscTotalNonexistent in DB | decimal? | Discount Total | - | |
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document and line discounts of the opportunity. | ||||
CuryProductsAmount | decimal | Total | - | |
Description:No description available | ||||
CurySalesCostTotal | decimal | - | ||
Description:The sum of the extended costs of the detail lines for which the margin is not empty (in the currency of the document). The line's extended cost is used with the negative sign for the receipt lines. | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryVatExemptTotal | decimal | VAT Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | 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 | - | ||
Description:No description available | ||||
DocumentDate | datetime | Date | - | |
Description:No description available | ||||
ExpirationDate | datetime | Expiration Date | - | |
Description:No description available | ||||
ExtPriceTotal | decimal | - | ||
Description:No description available | ||||
ExternalRef | char(255) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
FOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
GrossMarginAmountNonexistent in DB | decimal? | Gross Margin | - | |
Description:The gross margin amount, which is calculated from CRQuote.LineTotal and CostTotal. | ||||
GrossMarginPctNonexistent in DB | decimal? | Gross Margin (%) | - | |
Description:The percentage of the gross margin. | ||||
HoldNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Insurance | bit | Insurance | - | |
Description:No description available | ||||
IsDisabledNonexistent in DB | bool? | Disabled | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bool? | Primary | - | |
Description:No description available | ||||
IsSetupApprovalRequiredNonexistent in DB | bool? | Approvable Setup | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
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 | - | ||
Description:No description available | ||||
LineDocDiscountTotal | decimal | - | ||
Description:No description available | ||||
LineTotal | decimal | - | ||
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
ManualTotalEntry | bit | Manual Amount | - | |
Description:No description available | ||||
MarginAmt | decimal | - | ||
Description:The quote's estimated margin amount. | ||||
MarginPct | decimal | Est. Margin (%) | - | |
Description:The quote's estimated margin percent. | ||||
NetSalesTotal | decimal | - | ||
Description:The sum of the line amounts without the taxes and with the applied group and document discounts. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpportunityAddressID | int | CRAddress | ||
Description:No description available | ||||
OpportunityClassID | nvarchar(10) | Opportunity Class | CROpportunityClass | |
Description:No description available | ||||
OpportunityContactID | int | CRContact | ||
Description:No description available | ||||
OpportunityID | nvarchar(15) | Opportunity ID | CROpportunity | |
Description:No description available | ||||
OpportunityIsActive | bit | Opportunity Is Active | - | |
Description:No description available | ||||
OpportunityStageChangedDate | datetime | Opportunity Stage Change Date | - | |
Description:No description available | ||||
OpportunityStageID | nvarchar(2) | Opportunity Stage | - | |
Description:No description available | ||||
OpportunityStatus | char(1) | Opportunity Status | - | |
Description:No description available | ||||
OrderDiscTotalNonexistent in DB | decimal? | Discount Total | - | |
Description:The total discount of the document, which is calculated as the sum of document and line discounts of the opportunity. | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
ProductCntr | int | - | ||
Description:No description available | ||||
ProductsAmount | decimal | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
QuoteID | uniqueidentifier | - | ||
Description:No description available | ||||
QuoteNbr | nvarchar(15) | Quote Nbr. | - | |
Description:No description available | ||||
QuoteProjectID | int | Project ID | PMProject | |
Description:No description available | ||||
QuoteType | char(1) | Type | - | |
Description:No description available | ||||
RCreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
RCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
RCreatedDateTime | datetime | - | ||
Description:No description available | ||||
RLastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
RLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
RLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
RNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RefOpportunityID | nvarchar(15) | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
SalesCostTotal | decimal | - | ||
Description:The sum of the extended costs of the detail lines for which the margin is not empty. The line's extended cost is used with the negative sign for the receipt lines. | ||||
SaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShipAddressID | int | CRAddress | ||
Description:No description available | ||||
ShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
ShipContactID | int | CRContact | ||
Description:No description available | ||||
ShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
ShipZoneID | nvarchar(15) | Shipping Zone | ShippingZone | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
Subject | nvarchar(255) | Description | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Credit Terms | Terms | |
Description:The identifier of the default terms, which are applied to the documents of the customer. | ||||
TextForProductsGridNonexistent in DB | string | Availability footer | - | |
Description:The text for display subtotals on products grid | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||