CR
CRQuote
PX.Objects.CR103 of 103 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OpportunityID | nvarchar(15) | Opportunity ID | CROpportunity | |
Description:No description available | ||||
QuoteNbr | nvarchar(255) | Quote Nbr. | - | |
Description:No description available | ||||
AllowOverrideBillingContactAddressNonexistent in DB | bit | - | ||
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 | Approved | - | |
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
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 | ||||
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 | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:No description available | ||||
CuryExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
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 | CuryLineDocDiscountTotal | - | |
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
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 | datetime2 | Date | - | |
Description:No description available | ||||
ExpirationDate | datetime | Expiration Date | - | |
Description:No description available | ||||
ExternalRef | char(255) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
ExtPriceTotal | decimal | - | ||
Description:No description available | ||||
FOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
HoldNonexistent in DB | bit | Hold | - | |
Description:No description available | ||||
Insurance | bit | Insurance | - | |
Description:No description available | ||||
IsDisabledNonexistent in DB | bit | Disabled | - | |
Description:No description available | ||||
IsPrimaryNonexistent in DB | bit | Primary | - | |
Description:No description available | ||||
IsSetupApprovalRequiredNonexistent in DB | unspecified | 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 | ||||
OpportunityIsActive | bit | Opportunity Is Active | - | |
Description:No description available | ||||
OpportunityStageChangedDate | datetime2 | Opportunity Stage Change Date | - | |
Description:No description available | ||||
OpportunityStageID | varchar(2) | Opportunity Stage | - | |
Description:No description available | ||||
OpportunityStatus | char(1) | Opportunity Status | - | |
Description:No description available | ||||
OrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent 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 | ||||
QuoteProjectID | int | Project ID | PMProject | |
Description:No description available | ||||
QuoteType | char(1) | Type | - | |
Description:No description available | ||||
RCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
RCreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
RCreatedDateTime | datetime | - | ||
Description:No description available | ||||
RefOpportunityID | nvarchar(15) | - | ||
Description:No description available | ||||
Rejected | bit | Rejected | - | |
Description:No description available | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
RLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
RLastModifiedByScreenID | varchar(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 | 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:No description available | ||||
TextForProductsGridNonexistent in DB | nvarchar(MAX) | Availability footer | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||