Skip to content

Create Quotation Entities

Key Lesson: A Quotation stores vendor and currency information, while QuotationItem stores the individual lines and quoted prices that belong to it.

Begin the Request Quotations stage by extending the purchasing data model with two Entities:

  • Quotation represents a vendor quotation entry linked to a purchase request.
  • QuotationItem represents one line item and its quoted price.

The Request Quotations Screen creates a Quotation entry for each vendor to contact for an RFQ. It captures the vendor name only; it does not capture quoted prices or QuotationItem records.

The relationships between these Entities and the existing purchase request model are configured in the next tutorial step.

  1. Go to Design.
  2. Under Object Types, select Entity.
  3. Select + to create a new Entity.
  4. Enter Quotation in the Id field, then select OK.
  5. In the GENERAL section, set Id type to number.
  6. Add the following properties:
NAMETYPEDEFAULT EXPRESSIONNotes
vendorstring(leave blank)Vendor to contact for an RFQ
currency
This.Currency
This.Currency.Usd
References the Currency static entity and defaults to USD
  1. Leave all other properties at their default values.

  2. Save and close the editor.

  1. Go to Design.
  2. Under Object Types, select Entity.
  3. Select + to create a new Entity.
  4. Enter QuotationItem in the Id field, then select OK.
  5. In the GENERAL section, set Id type to number.
  6. Add the following properties:
NAMETYPENotes
descriptionstringLine item description
quantitynumberQuantity quoted
unitPricenumberSupplier's quoted unit price
  1. Leave the property default expressions at their editor defaults.
  2. Leave all other properties at their default values.

  3. Save and close the editor.

Note

QuotationItem.unitPrice stores a currency amount. Its persisted precision is set to 2 later in Extend Storage and Access for Quotation Data, before the Request Quotations Screen is built.