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:
Quotationrepresents a vendor quotation entry linked to a purchase request.QuotationItemrepresents 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. Create the Quotation Entity
Section titled “1. Create the Quotation Entity”- Go to Design.
- Under Object Types, select Entity.
- Select + to create a new Entity.
- Enter
Quotationin the Id field, then select OK. - In the GENERAL section, set Id type to
number. - Add the following properties:
| NAME | TYPE | DEFAULT EXPRESSION | Notes |
|---|---|---|---|
| vendor | string | (leave blank) | Vendor to contact for an RFQ |
| currency | | | References the Currency static entity and defaults to USD |
-
Leave all other properties at their default values.
-
Save and close the editor.
2. Create the QuotationItem Entity
Section titled “2. Create the QuotationItem Entity”- Go to Design.
- Under Object Types, select Entity.
- Select + to create a new Entity.
- Enter
QuotationItemin the Id field, then select OK. - In the GENERAL section, set Id type to
number. - Add the following properties:
| NAME | TYPE | Notes |
|---|---|---|
| description | string | Line item description |
| quantity | number | Quantity quoted |
| unitPrice | number | Supplier's quoted unit price |
- Leave the property default expressions at their editor defaults.
-
Leave all other properties at their default values.
-
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.