The cell address that holds the label of the Participant used for access authorization checks when accessing fusion_place data.

The cell address that holds the Ledger Edition Key specifying the ledger edition to be accessed. The two representative ledger edition keys are as follows:

For details on ledger edition keys, refer to "Ledger Data Edition Management."

Specifies the ledger (label) used as the source or destination for data retrieval or reflection.

Specifies whether this data region is included in reflection processing.

Specifies whether to automatically toggle the lock attributes of cells during retrieval or reflection processing, according to whether the corresponding ledger cells are editable (ON / OFF).

When lock attributes are toggled, cell colors are also switched accordingly. For details, refer to "Toggling Cell Locking and Cell Colors."

Specifies the cell that defines the color applied to locked cells. If no lock color specified cell is set, the lock color defaults to light blue.

⚠ To cancel a lock color specified cell after setting it, click the button labeled
X to the right of the specification field.

The cell address that holds the display unit for amounts or numbers. The display unit is specified as "Excel Sheet Unit ÷ Ledger Unit". For example, if data is stored in the ledger in yen units and you want to display or input the data in thousand-yen units on the Excel sheet, set "1000" in the display unit cell.

Specifies how many decimal places are treated as significant digits. Up to 12 digits can be specified.

During retrieval, the amount or number in the ledger is first divided by the display unit, and then digits beyond the specified significant decimal places are rounded.
During reflection, digits beyond the specified significant decimal places are rounded based on the sheet cell value, and then the display unit is multiplied to calculate the value.

Note that the precision of numeric data in the ledger is up to the 4th decimal place. When writing data to the ledger, the result of the above calculation is rounded at the 5th decimal place, and values up to the 4th decimal place are written.

Specifies how to process fractions beyond the significant decimal places in the above display unit conversion. Select one of the following:
・Round Half Up
・Round Down
・Round Up

Specifies the sign display method when retrieving amounts or numbers to the sheet. Select one of the following three options:
・Display according to account attributes
・Always display as Debit () + ・Always display as Credit ()

If ON, an error message is displayed during reflection processing when a value entered in a cell within the data region does not match the data type of the corresponding ledger cell.

If OFF, no error message is displayed. In this case, if an invalid value is specified, the target ledger cell value is initialized (zero for numeric cells, blank for other cells).

If ON, when retrieving a string value, the system determines whether the string can be interpreted as a date. If it can, the value is converted to a date and written to the cell. Introduced in version 4.3.2. In versions 4.3.1 and earlier, this processing was performed when this setting was ON. Therefore, to maintain compatibility, this setting is ON for link regions created in versions 4.3.1 and earlier (can be changed manually).

If ON, for ledger cell values classified as enumerated or boolean values according to the Ledger Cell Data Type, the name is displayed instead of the value (label). During reflection processing, names are accepted as cell values, and labels are not accepted.

If OFF, the value itself (label) is displayed. During reflection processing, labels are accepted as cell values, and names are not accepted.

(This item applies only to Template Processing.)

If ON, this link region is intentionally excluded from data presence determination during template processing. That is, regardless of other conditions, this link region is not treated as a Control Region.

This setting is valid only when the processing type is "Reflect" or "Retrieve and Reflect."

If ON, an error message is displayed during reflection if data cannot be written to the ledger under the following conditions: