Periodic registers of information in 1C 8.3. Search and read in the information register

Other registers 1s This is a structured set of data with measurements and resources. Designed to store periodic information.

Periodicity

The information is stored in the context of measurements and periods. Register information, you can specify frequency:

Non-periodic
by registrar
second
a week
month
quarter

Periodicity is needed to select information from the register for a certain period of time. If you specify the frequency, records to the register will be made with a period when recording was made. Suppose if you look at the Register of Romenclature, you can see the price change history, with what measurements and at what period of time record was made.

The frequency in information registers is needed for information that changes during time, for example: currency courses, price ranges, discounts and range of nomenclature, etc.

Registrars

If you record in the information register using the document, you need to set the recording mode: "submission to the registrar" and select a document that will be recorded in the register. Then in the register will appear the "Registrar" field, where information will be stored, which document recorded. Also, the registrar can be used as a period, for this, specify in the field "Periodicity" - "by the Registrar". Submission to the registrar makes when it is necessary to rigorously bind the register to the document and changing records in the register in manual mode becomes not affordable.

Documents that will be in the role of registrars may be several. In order to add the recorder, you need to go to the properties of the desired information register, go to the "Registrars" tab and set the checkboxes opposite the documents that will perform the role of the registrar.

Watch the movements that the recorder makes from the document. To do this, go to the document you are interested in, click: Go - Movement of the document on the registrar.

In the register properties, do not forget to add rights, you can assign them on the "Rights" tab. Then, in the role list, you need to select the role that you want to add the rights to the register and in the Rights list to establish rights to the selected role.

Uniqueness of records

The uniqueness of the recording depends on the period and measurements. For example, if you want to record a record with the same measurements, in the same day, then you will not succeed and the program will cause an error, since the frequency of the register within the day.

If the frequency is asked by the registrar, it also participates in the uniqueness of the record.

For non-periodic and non-dependent registers, uniqueness depends on the measurement combination.

Forms

To view the entries, use the list form, you can set the selection in the field you are interested in, to see the record history and change them through the record form. You can see the register entries as follows: In the upper menu, click the "Operations" button - "Information Registers". In the window that opens, select the register you need. After that, the form of a list in the form of a table will open, where each runoff is a unique entry.

To edit / create, use the recording form if the record is subordinate to the registrar, then the field will not be available and the form cannot be created.

Add shapes are needed in the configurator, going into the information register, in the "Form" tab and click on the "Lupu" in the desired form of the form. Next, the window will open where you can configure the fields of the future form (location, name and register functional).

Measurements, resources and details

Measurements are designed to form the uniqueness of the recording, on them can be selected in the future and make a slice on a specific measurement. The combination of measurements and generates the record key. It is better not to create a large number of measurements so that the table is not expanded and in the process of working with it, did not slow down.

Measurements have a "master" checkbox if it is installed that the record will be stored in the database, as long as this measurement exists. Master measurements can be done several. For example, in the register of information "Nomenclature Prices", the value of the measurement is the nomenclature if you delete the nomenclature that participates in the record, then the entry will automatically be recorded in the information register for this nomenclature.

Resources are intended for storage of sums: quantity, price, etc. Resources will continue to receive for a certain period of time (if the periodic register), for measurements.

Details, in most cases, are intended for storing additional information, they do not participate in the uniqueness of the record. For example, in details you can make information such as the author, comment, etc.

The following actions can be performed with the information register:

Delete recording in the 1C information register

Features

- Uniqueness of measurement settings: Each entry in the information register is a new resource value.

- records of the information register can be both periodic and not.

- The information register may be dependent and independent of the registrar.

- It is possible to make a cut first and last records for the desired date. This is implemented by virtual tables: "sliced" and "cut-out". To use these tables, you can use both the selection and the query (in the query constructor you will make these virtual tables and you can make a request for them). These tables will be available if the recorder is periodic.

The image shows that the frequency is installed within the day. It means that the price can be changed once a day for unique measurements during the day.

The register is subordinate to the "Settlement price setting" document. So, the record in the register comes from this document. Movements on a specific document can be viewed from the form of the document "Setting the price of the nomenclature".

The register is designed to store information on the price of the nomenclature, with the measurements of the "Price type", "nomenclature" and "characteristic of the nomenclature". The leading measurements are all three measurement fields, it will be possible to make a selection when sampling.

Conclusion: After reading the article, you can create an information register 1c, add measurements and resources, configure editing and list forms. Create a record and make a sample of existing records. If you have any questions, use the comments in the article, I will try to promptly answer the question of interest to you.

There are several types of registers in 1C:

Accumulations storing residues or revs in numerical form;
Calculation that stores the types of calculations and the calculations themselves are commonly used to calculate the salary;
Accounting data on accounting calculations in the form of DT-CT;
Information registers.

On the latter, we will dwell in more detail because they allow you to compile data from the database for measurement cuts. For example, in the "price-based account", data is stored for a specific nomenclature and characteristics by a specific type of prices.

Fig.1 Register of "PricesNactore"

Characteristics

The register can be both periodic and non-periodic when you do not need to save the sequence of changes. But if you still need to store, it is installed, within what period, the program will establish control of the uniqueness of records: per second, per day, month, for the quarter and year.

Fig.2 Periodicity and recording mode

If you try to create two entries within the same period, the program will give an error "Recording with such key fields exists!" And it will not give a record to the database.

You can also specify recording mode. The first with the "submission of the Registrar", in which the records will be recorded by documents and the recorder will be specified in each of them. If you choose the second - independent mode, then the data is recorded not by the registrar, but are added, for example, directly from the list or as processing.

Fig.3 Record Modes

The peculiarity of a periodic register is that it is possible to use a cut of an extreme or first, receiving ready-made values \u200b\u200bfrom the database on the last / first set value to a specific date.

Entry in the 1C information register

Rows in the register with a period and a registrar containing information about resources in terms of measurements are called records.

To add an entry to the register are used or record manager, or a set of records. If recordings in the register have a common key, then you must use a set of records. And to record one single entry, if in the register all records are unique, you must use the manager.

An example of recording when using a registering object.

Using the Recording Manager:

New recording \u003d registers. Coursales. Create money. New Revolutionary. Wayt \u003d References. Racuta. Intepponation ("USD"); New recording. Period \u003d date (31,12,2016); New recording. Cours \u003d 100; New recruitment \u003d 1; New register. recruit ();

When you use a set of records and the "Write" method, recorded in the record setup register. In this case, it can occur both simply adding strings and replacement of already available lines in the register. For independent registers, without installing selections, all entries will be deleted in the register and replacing the recorded records.

If you write the data without selection in the subordinate register, an error will occur.

An example of an entry using a set of records to the subordinate to the registrar register of information PRICE INFORMATION:

Newnabinets \u003d Registribution. Central Summary. Create Research (); Newnabinet.Tebor.Registrator. Install (link); New marking \u003d newnabinet. Add (); New marker.period \u003d reference. Data; New marker.NewClature \u003d reference. Namerenclature; New marker. Price \u003d reference. Price; Newnabinet. To recruit ();

An example of writing through the recording manager:

Recording \u003d Registributions. Curvivatt. Create money (); Recording. Period \u003d date; Recording. Coursp \u003d course; Recording. Calculate \u003d currency; Recording. Recruit ();

Search and read in the information register

To find an entry and read it in the information register, you need help help. For example, we need to get prices made by a specific registrar:

Choose priced value. Namerenclature, priceAnchlasture. Price from registerings. Priceennenclature as prices of price Industry where pricesCometer

Change and delete records

To delete information register, for example, all EUR currency courses, use the following code:

Structuring \u003d New Structure ("Currency", Reference Tools. Rays.Nightyponiament ("EUR")); Sampling \u003d registributions. CoursaValuta. Clear (, structures); While the sample. Next () Cycle ManagerApisius \u003d Sampling. Folded Server (); Sampling. EasternateCompani (). Delete (); EndCycle;

You can use the following code for quickly cleaning the register:

New recording \u003d registribution. Details Research. Create registration (); New register. recruit ();

To adjust and change the register, as well as quickly fill out the data register, you can write universal processing.

Registers- This is a set of entries about objects. They not only store the attributes of the program objects, but also write movements on these parameters. Their destination is to save data and providing reports according to certain parameters.

Parameters can be diverse, depending on the type of information being saved. The tables store properties of objects. For example, for the cost of the goods it will be:

Name
Manufacturer
Packaging
Purchase price

The registers record the results of operations conducted in the system. Each of the documents writes its results. Such records are called movements. You can spend sorting and comparison of data.

If you add an additional time parameter, for example, the price for a specific date, then the sample can also be done by period of time. Storing information with the period value helps to structure and filter the desired data.

Setting in 1C 8.3 information registers

Configuring such depth elements of the program, mainly the occupation of programmers and work with them every day you do not have to work. Depending on the type of register, it can be accessible under different buttons to control the corresponding subsystem.

As a rule, users do not need information where there is a register of information in 1C 8.3. Let's just say that the main access to them is in the configuration section.

As in 1C 8.3 Make an entry in the information register

Register entries are a consequence of operations in various parts of the program. But it is possible to make direct changes. This provides for the ability to record in the information register 1C 8.3 programmatically (let an example of the analyst of currency fluctuations):

We use the recording manager to perform one action:

New recording \u003d registers. Coursales. Create money.

Novaya register. Rally \u003d reference books. Avaluta. Intepponation ("UA");

New recording. Period \u003d date (30.07,2018);

Novaya register. Cours \u003d 50;

New recruitment \u003d 1;

New register. recruit ();

Take a set of records for several administrations:

Newnabinets \u003d Registributions. CoursaValuto. Create an order ();

//Attention! It is important to specify the selection criteria. Otherwise, all the records made before the records will disappear.

Newnabinet.Tebor.Valuta. Set (hryvnia, truth);

Newnabinet.Tebor.Teriod. Set (date (30.07,2018), truth);

// Now you can proceed to recording the set itself

New marking \u003d newnabinet. Add ();

New marketing. Rally \u003d reference books. Avaluta .Nightyponiament ("UA");

New marker.period \u003d date (30.07,2018);

New marking. Cours \u003d 50;

New marking. Cause \u003d 1;

Newnabinet. To recruit ();

How to delete an information register in 1C 8.3

In the program 1C 8.3 add an entry to the information register relatively easy. Now consider the option of deletion. Take a hypothetical option where you need to delete information about the organization. In this case, the Parameter of the Banner will have a link.

We carry out such actions:

Code 1c v 8.x
Set records \u003d registers. Positioning the organizers. Create registration ();
Set records. Observation. Organization. Software (BUT LIBRANCE);
Set records. To recruit ();

After that, you need to create a variational set of recordings, where to make a sample on the company is the same as the Laborization. It turns out an empty set of records. To complete deletion, you need to write it down with the replacement. Thus, all information intended for erasing is replaced by empty values.

Please note that the sample of such a set of records is set exclusively on equality.

Register of information 1C 8 is an object of metadata intended for storing reference information in the context of the defined measurement developer.

A typical example of using the information register is the storage of information about the exchange rate in the context of the currency and the period.

Consider in more detail the properties and settings of the information register.

Two main property registers. Periodicity and Recording mode.

These are the unique properties of the information register, which is no longer any metadata object. Consider them in more detail.

This property allows you to add additional measurement to the measurement list - Period. With it, you can solve a large number of tasks: storing information in the database, given the relevance to a specific date. Applied Examples of Use of Performances Set: Storage Currency Value for every day, Storage of price Nomenclature, etc.

Periodicity can take the following values:

Non-periodic
Within a second
Within the day
Within a month
Within a quarter
Within the year

Get 267 video tutorials for 1C for free:

When choosing a frequency other than the embodiment, the system will control the uniqueness of the records within a specified period of time. If the record is not unique, the 1C system will give a message and will not allow you to write to the database.

And one of the main features of the periodic register of information is the ability to get ready-made values \u200b\u200bof the "cut first" and "recent cut." This information allows you to quickly get information about the last (first) set value for a specific date from the database.

Recording register mode

In 1C 8.2 and 8.3, this property can be either in the value "independent" or - "submission to the registrar." In the first case, the record can be made both programmatically and from the list of information list. In the second case, it is necessary to specify the recorder recorder document. This imposes certain limitations, but at the same time opens up new opportunities.

Properties of measurement of information

Also, you should pay attention to the properties of the measurement properties of 1C 8.3. Especially on the flags leading and the main selection:

Master - The measurement property implies information that no value of this measurement does not make sense without the value of this measurement. In fact, this means that the system when removing a value from the measurement also removes the record of the register with the "leading" dimension. Only one dimension can be installed.
Main selection - If the register is independent, changes to the exchange plan will be installed on these dimensions. Similarly, use Primary selectionincludes the main selection for the periodic registers.

Software entry in the information register 1c

Add new entries to the information register in two ways - using the recording manager and using the recording set. The first case is suitable for a single recording, the second - for two and or more records.

Using the Recording Manager:

New recording \u003d registers. Coursales. Create money.
New Revolutionary. Wayt \u003d References. Racuta. Intepponation ("USD");
New recording. Period \u003d date (31,12,2016);
New recording. Cours \u003d 100;
New recruitment \u003d 1;
New register. recruit ();

Using a set of registration records of 1C information:

Newnabinets \u003d Registributions. CoursaValuto. Create an order ();
// If you do not set the selection - all records of information records will be deleted
Newnabinet.Tebor.Valuta. Sust (dollar, truth);
Newnabinet.Tebor.period. Set (date (31,12,2016), truth);
// We form directly recording
New marking \u003d newnabinet. Add ();
New marker. Ivuta \u003d reference books. Avaluta. Intepponation ("USD");
New marker.period \u003d date (31,12,2016);
New marking.kurs \u003d 100;
New marking. Cause \u003d 1;
Newnabinet. To recruit ();