Skip to content

Create Transactional Entities

Key Lesson: In this step, you learn how to create transactional entities and configure the properties that define the business data they store.

Create four transactional entities: PurchaseRequest, PurchaseRequestItem, Quotation, and QuotationItem.

Use these steps each time you create an entity:

  1. Go to Design.
  2. Select Entity under Object Types.
  3. Click + to create a new entity.
  1. Follow the Creating a new entity steps.
  2. Enter PurchaseRequest in the Id field and click OK.
  3. In the GENERAL section of the editor, set the Id type type to number.

Insight

When choosing data types, you can use the standard TypeScript types (string, number, and boolean) supported by Lowgile.

  1. Add the following properties:
NAMETYPENotes
costCenter
This.CostCenter
Lookup to the CostCenter static entity. Leave the default expression property empty to force the user to choose a cost center.
commentstringStores the comment entered by the Approver when reviewing the Purchase Request.
  1. Leave all other properties at their default values.

Tip

Typing This. in the Type or Default expression field displays suggestions for the static and transactional entities available in the module.

  1. Save and close the editor.

  1. Follow the Creating a new entity steps.
  2. Enter PurchaseRequestItem and click OK.
  3. Set the ID type to number.
  4. Add the following properties:
NAMETYPEDEFAULT EXPRESSIONNotes
descriptionstring(leave blank)Item description
quantitynumber1Requested quantity
unitPricenumber(leave blank)Price per unit
budgetAmountnumber(leave blank)Budget allocation for this line
currency
This.Currency
This.Currency.Usd
Lookup to the Currency static entity
  1. Leave all other properties at their default values.

  2. Save and close the editor.

  1. Follow the Creating a new entity steps.
  2. Enter Quotation and click OK.
  3. Set the ID type to number.
  4. Add the following properties:
NAMETYPEDEFAULT EXPRESSIONNotes
vendorstring(leave blank)Supplier providing the quotation
currency
This.Currency
This.Currency.Usd
Lookup to the Currency static entity
  1. Leave all other properties at their default values.

  2. Save and close the editor.

  1. Enter QuotationItem and click OK.
  2. Set the ID type to number.
  3. Add the following properties:
NAMETYPENotes
descriptionstringLine item description
quantitynumberQuantity quoted
unitPricenumberVendor’s unit price
  1. Leave all other properties at their default values.

  2. Save and close the editor.

Understand how entities and relationships provide screen data.

Understand how transactional entities store operational data and how their source types work.

Learn how relationships connect entities and support header-detail data structures.