CR
CROpportunityRevision
PX.Objects.CR.Standalone93 of 93 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
AllowOverrideContactAddress | bit | Override | - | |
Description:No description available | ||||
AllowOverrideShippingContactAddress | bit | Override Shipping Info | - | |
Description:No description available | ||||
Amount | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
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 | - | ||
Description:No description available | ||||
BillContactID | int | - | ||
Description:No description available | ||||
BranchID | int | Branch | 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(19, 4) | - | ||
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(19, 4) | Amount | - | |
Description:No description available | ||||
CuryCostTotal | decimal(19, 4) | Total Cost | - | |
Description:No description available | ||||
CuryDiscTot | decimal(19, 4) | 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(19, 4) | Subtotal | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryLineDiscountTotal | decimal(19, 4) | Detail Discount Total | - | |
Description:No description available | ||||
CuryLineDocDiscountTotal | decimal(19, 4) | CuryLineDocDiscountTotal | - | |
Description:No description available | ||||
CuryLineTotal | decimal(19, 4) | Detail Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | 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(19, 4) | Total | - | |
Description:No description available | ||||
CuryProgressiveTotal | decimal(19, 4) | Total Amount | - | |
Description:No description available | ||||
CuryTaxInclTotal | decimal(19, 4) | Inclusive Tax Total | - | |
Description:The total inclusive tax amount. | ||||
CuryTaxTotal | decimal(19, 4) | Tax Total | - | |
Description:No description available | ||||
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 | ||||
DisableAutomaticDiscountCalculation | bit | Disable Automatic Discount Update | - | |
Description:No description available | ||||
DiscTot | decimal(19, 4) | - | ||
Description:No description available | ||||
DocumentDate | datetime2 | Estimation | - | |
Description:No description available | ||||
ExternalRef | nvarchar(255) | External Ref. | - | |
Description:No description available | ||||
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 | ||||
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: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(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 | Location | |
Description:No description available | ||||
ManualTotalEntry | bit | Manual Amount | - | |
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 | ||||
OrderDiscTotal | 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 | Parent Account | - | |
Description:No description available | ||||
ProductCntr | int | - | ||
Description:No description available | ||||
ProductsAmount | decimal(19, 4) | Products Amount | - | |
Description:No description available | ||||
ProgressiveTotal | decimal(19, 4) | - | ||
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(30) | Project ID | - | |
Description:No description available | ||||
QuoteProjectID | int | Project ID | PMProject | |
Description:No description available | ||||
QuoteStatusNonexistent in DB | nvarchar(MAX) | Quote Status | - | |
Description:No description available | ||||
RawAmount | decimal | - | ||
Description:No description available | ||||
Rejected | bit | Rejected | - | |
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 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 | 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 | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
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: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 | ||||
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 | ||||