Settings for ERP-Export of Assembly Lists

Create an ERP export entry for assembly lists. 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.

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"
• "Insertions"
• "Articles"
• "GasketFrames"
• "Glass"
• "Profiles"

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

Here 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

Insertions

Here you will find all information about the respective insertions. The table is linked to the Elevations table via the ElevationID.

Examples:

• InsertionNo = Insertion Number
• Description = Insertion Describtion
• Type = Type of Insertion

Articles

Here the single additional articles are listed.  The table is linked to the Elevations table via the ElevationID.

Examples

• ArticleCode = Article number
• Units_Output = Amount of articles per insertion
• Description = Article description
• ArticleType = Accessories, hardware, gaskets

Glass, GasketFrames und Profiles

The tables Glass, GasketFrames and Profiles shows you further articles from the parts list. Please note that the number of pieces may have to be multiplied with the number of pieces of the article (Elevations.Amount) to get the total number of pieces.