Table Description
Quotation: An estimate of entitlement provided by the organization to a customer.

The estimate is based on evidence (either hard or soft) as supplied by the customer.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::CRM::Entity Objects::Quotation::Quotation
Controlling File: core\model\Packages\Crm_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
quotationIDkeynoUnique reference number assigned by the system to a Quotation recordQUOTATION_ID SVR_INT64
concernRoleIDdetailsnoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
productIDdetailsnoUnique reference number assigned by the system to a Product recordPRODUCT_ID SVR_INT64
communicationIDdetailsyesUnique reference number assigned by the system to a Communication record.INTERNAL_ID SVR_INT64
evidenceTextdetails Data upon which the quotation was based.EVIDENCE_TEXT SVR_STRING<1048576>
effectiveFromDatedetails Start Date for testing Eligibility.CURAM_DATE SVR_DATE
effectiveToDatedetails End date for testing eligibility.CURAM_DATE SVR_DATE
datadetails A summary of the quotation produced by the system for the customer.QUOTATION_DATA SVR_STRING<100>
issueDatedetails Date on which the Quotation was given to the customerCURAM_DATE SVR_DATE
validToDatedetails Date quotation is valid until.CURAM_DATE SVR_DATE
creationDatedetails Date Quotation record was created on the system.CURAM_DATE SVR_DATE
initReasonTextdetails Description of the reason why a quotation was started.INITIATION_REASON_TEXT SVR_STRING<50>
ticketIDdetailsyesUnique reference number assigned by the system to a Ticket record generated following a direct or indirect query in relation to a Concern or Prospect. Optional foreign key to WMTicket.TICKET_ID SVR_INT64
userNamedetailsnoUnique Reference Number assigned by the system for a User.USER_NAME SVR_STRING<64>
referredBydetails Free text to record the name, address and telephone number of the Person or Organization who referred the Prospective CustomerREFERRED_BY SVR_STRING<60>
Foreign Keys (6)
ChildParent
Quotation.concernRoleIDConcernRole.concernRoleID
Quotation.productIDProduct.productID
Quotation.userNameUsers.userName
QuotationDecisionComponent.quotationIDQuotation.quotationID
QuotationDecisionEvidence.quotationIDQuotation.quotationID
QuotationDecision.quotationIDQuotation.quotationID
Indices (3)
Index NameAttributes
IND__982594242concernRoleID
IND_177221431productID
IND__504114583userName
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
Related Pages (0)