In this chapter, we will cover the following recipes:
- Creating a new project, package, and model
- Creating a new number sequence
- Renaming the primary key
- Adding a document handling note
- Using a normal table as a temporary table
- Copying a record
- Building a query object
- Using a macro in a SQL statement
- Executing a direct SQL statement
- Enhancing the data consistency checks
- Using the date effectiveness feature