Create an ERP export entry for quotations. A detailed description of the basic settings for an ERP export via SQLite can be found in the following chapter: Settings for a basic ERP export with SQLite
After you have made the basic settings, click on the "Database" tab.
Activate under "Flags" the options "Estimation" and "Quotation Prices".
Then click on the "Edit SQL" button and the SQL Editor appears.
Activate the following options in the "Database Structure" area on the right side:
- "Projects"
- "Phases"
- "ElevationGroups"
- "Elevations"
- "ReportOfferTexts"
By using this selection, the following data is written into the SQLite3 file:
Projects
All project-related information is stored under "Projects".
Examples:
- Name: Project name
- OrderNo: Oder number
- OfferDiscount1: The first quotation discount
Phases
If available, the phase information is displayed in the Phases table. The table is linked to the projects table via the ProjectID.
ElevationGroups
The table ElevationGroups is linked to the phase via PhaseID.
Elevations
In the table Elevation you find all information about a position. The table is linked to the table ElevationGroups via the ElevationGroupID.
Examples:
- Name: Position name
- Description: Position description
- Amount: Amount of positions
ReportOfferTexts
Here the individual quotation areas are listed (as displayed under Settings + quotation). The table is linked to the Elevations table via the ElevationID.
Examples:
- Description: Path + file name to an RTF file with the quotation text
- ReportOfferTexts.Price: Price of the quotation area. The sum per ElevationID determines the position price.