CR
CROpportunityRevision
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMCuryEstimateTotal | decimal | Est. Amount | - | |
Description:No description available | ||||
AMEstimateQty | decimal | Estimate Qty | - | |
Description:No description available | ||||
AMEstimateTotal | decimal | Estimate Total | - | |
Description:No description available | ||||
AllowOverrideContactAddress | bit | Override | - | |
Description:No description available | ||||
AllowOverrideShippingContactAddress | bit | Override Shipping Info | - | |
Description:No description available | ||||
Amount | decimal | Amount | - | |
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BAccountID | int | Business Account | - | |
Description:No description available | ||||
BillAddressID | int | - | ||
Description:No description available | ||||
BillContactID | int | - | ||
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:No description available | ||||
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 | Amount | - | |
Description:No description available | ||||
CuryCostTotal | decimal | Total Cost | - | |
Description:No description available | ||||
CuryDiscTot | decimal | Discount | - | |
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). | ||||
CuryDocDiscTotNonexistent in DBObsolete | decimal? | - | ||
Description:No description available | ||||
CuryExtPriceTotal | decimal | Subtotal | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryLineDiscountTotal | decimal | Detail Discount Total | - | |
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 | ||||
CuryProgressiveTotal | decimal | Total Amount | - | |
Description:No description available | ||||
CuryTaxInclTotal | decimal | Inclusive Tax Total | - | |
Description:The total inclusive tax amount. | ||||
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 | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DiscTot | decimal | - | ||
Description:No description available | ||||
DocumentDate | datetime | Estimation | - | |
Description:No description available | ||||
ExtPriceTotal | decimal | - | ||
Description:No description available | ||||
ExternalRef | char(255) | External Ref. | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
FOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
Insurance | bit | Insurance | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
LanguageID | nvarchar(10) | Language/Locale | Locale | |
Description:The language in which the contact prefers to communicate. By default, the system fills in the box with the locale specified for the contact's country. This field is displayed on the form only if there are multiple active locales configured on the System Locales (SM200550) form (which corresponds to the LocaleMaintenance graph). | ||||
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 | - | |
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 | - | |
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. | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually. | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Business Account | - | |
Description:No description available | ||||
ProductCntr | int | - | ||
Description:No description available | ||||
ProductsAmount | decimal | Products Amount | - | |
Description:No description available | ||||
ProgressiveTotal | decimal | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectManager | int | Project Manager | EPEmployee | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
QuoteProjectCD | nvarchar | Project ID | - | |
Description:No description available | ||||
QuoteProjectID | int | Project ID | PMProject | |
Description:No description available | ||||
QuoteStatusNonexistent in DB | string | Quote Status | - | |
Description:No description available | ||||
RawAmountNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user. | ||||
SaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | 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 | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxInclTotal | decimal | 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 | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TemplateID | int | Template | PMProject | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
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 | ||||