Database configurator.Each account in the ERP Platform is freely configurable and can be configured for the individual processes of the company. The configurator consists of 4 parts:
The DB configurator is a rather complex tool and is not intended for ordinary users.
Database ProgrammingThe built-in ERP-Script programming language gives organizations unlimited flexibility in database localization. ERP-Platform allows its clients to independently create and edit any data structures, customize any actions for events occurring in the system.
TablesThe programming system allows you to create or update any tables in the database.
Web-oriented PLSQL Procedures and TriggersThe creation of data processing procedures of any complexity is supported. You can customize the execution of the procedure by commands from the interface (for example, by pressing a button), upon a modification event in the database (in a trigger), or generate an execution plan according to a given schedule.
BlockChainBlockChain is a standard ERP-Script function and allows one-click connection to tables to calculate the checksum of records or a chain of record blocks. Checking the consistency of a block chain is built into procedures or triggers with one click. BlockChain functions are very convenient for reliable logging, or other functions where it is necessary to guarantee the accuracy of the information entered.
And alsobuilt-in CRUD (procedure creation automation), Snapshot procedures, data transfer to the API system, ... and much more.
TablesThe DB configurator allows you to make arbitrary editing of tables. You can create new tables, or add fields to existing ones.
The database structure supports all standard field types + an additional Image field. Image type - allows you to store images and work with them as with ordinary data in the database.
You can change the order and name of the fields. You can customize the relationship of key fields to other tables. Set up links with directories. Also, each field can be canceled, use it in the reporting system or not.
Each table can include a detailed log entry. The system will write logs on adding, changing and deleting data. What values were in which fields before modification and what became after modification.
This data is written to a separate database and does not clutter up the company's working base. Viewing these logs is available through a special interface in the "Settings-Logs" section.
ProceduresProcedures are the most flexible tool for receiving and processing data.
The procedures support full PL \ SQL. You can make queries, loops, conditions, string operations, data modification operations, etc. Lots of built-in system functions. There are also unusual structures. For example, you can embed API structures directly into a procedure / trigger. Those. directly from the trigger to the database (by event), transfer information somewhere outside. The user configures the API structure himself, and he configures the addresses where to transfer. You can embed procedures in procedures of any nesting. There is a task scheduler where you can put procedures in a scheduled launch on schedule.
The procedure can include the following types of blocks:
The procedure supports a wide variety of functions. Functions are grouped into thematic blocks: System, Data type conversion, String processing, Operations with dates. Functions can be used in any query fields, strings, modification operations, etc.
You can take a Snapshot of the procedure and roll back to its previous states in case of errors.
The procedures are fast thanks to compilation. Modern databases are quite a perfect tool, and there is no point in neglecting them. The procedure written by the user via the web interface is compiled.
The system works knowing the structure of the procedure and executing the necessary requests to an already compiled, fast working element.
TriggersA trigger is a procedure of a special type, which the user does not call directly, but whose execution is conditioned by the action of modifying the data: adding INSERT, deleting DELETE rows in a specified table, or changing UPDATE data in a specific column of a specified table.
The DB configurator allows you to create triggers for any type of modification or their combination.
Triggers use full procedure functionality, including API blocks. Those. by event in the database, you can transfer information to external systems.
The main purpose of triggers is to configure the system's response to events. For example, when a letter arrives via a postal channel - analyze the letter, calculate the client, create an application. Or, when adding a user to a task, write a notification to this user in the mailing system. And much, much more, the trigger is a very versatile mechanism for customizing reactions.
Triggers allow you to work with field values before and after modification. Those. if a data change event has occurred, the trigger can work both with the data values that existed before the modification, and with the newly assigned values.
BlockChainBlockChain is a built-in ERP-Script function. BlockChain or checksum calculation can be connected in any table of the system with one button.
Calculating BlockChain and ChecksumChecksum calculation only monitors the record within the data line. Any changes to the data will invalidate the old checksum.
BlockChain in the checksum also includes the checksum of the previous data line. This recording technology guarantees that when:
BlockChain and Checksum Validation FunctionsThe BlockChain record checking system is a standard feature, and can be built into any procedure or trigger with one click. Any output of information about checksums to the system interface can be organized in them.
«ERP-PLATFORM» LLC © 2021