Source tables for receiving data

<< Prev   Next >>

The Receipt method attribute specifies the source data type. By default, data is received from the current infobase. The list of methods for receiving data from external 1C:Enterprise 8 infobases is similar to the list of methods for the current database. To switch data source to an external database, set the Infobase type attribute to any value except Current infobase. To view the available fields of the source infobase, go to the corresponding table.

The following source data is available for the 1C:Enterprise 8 infobases:

• Custom statement indicator values. Specify report type and indicator. Only applies to the current infobase.
• Accumulation register data. Specify register name and resource. Depending on the nature of received data, the following options can be available:
  • □ Opening and closing balance. Specify a total kind.
  • □ Records. Select a total kind if all data required to fill the data consumer fields is available in the register dimensions. Otherwise, select the check box for using the main register table. In this case, both the register attributes and the recorder fields are available, but data selection may take a long time.
• Accounting register data. Specify an accounting register, chart of accounts (in case of multiple accounts), account, register resource, and total kind. If you select the Correspondent turnover total kind, you also need to specify a correspondent account. In this case, recorder fields also can be selected.

• Information register data. Specify register name and resource. For periodic registers, specify slice type: first or last.
• Catalog data. Select a catalog to receive data from its header or selected tabular section.
• Arbitrary query. Selecting this option displays a text field. Type in a 1C:Enterprise 8 query in this field. To switch to the query editing mode, click Edit text. To save and process the query, click Finish editing. If you choose to receive data from the current infobase, you can use the query designer to create a query. If you choose to receive data from an external infobase, it is recommended that you use the query designer to create a query in it, and then copy the query text. After you finish editing the query, the selected fields and query parameters are added to the Data source fields table on the Data filter and dimension mapping tab.

If drilling down the resulting values requires any fields that are not directly used by the source data consumer and are not necessary to populate it, you can add these fields to the query text as query builder instructions in {} brackets.

If the Connect via ADO connection type is selected for the infobase type , only the Tables from ADO connection selection method is available for external infobases. In this case, select a table. Working with this table is similar to the register tables.

<< Prev   Next >>