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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||