| Field |
Workflow Id |
Specifies the ID of the workflow. |
| Field |
No. |
Specifies the number of the reconciliation setup record. |
| Field |
Reconciliation Code |
Specifies the reconciliation code that identifies and links reconciliations, allowing you to view the lines of related reconciliations. |
| Field |
Description |
Specifies the description of the reconciliation. |
| Field |
Comparison Type |
Specifies the type of comparison to be performed for the reconciliation. For example, it can be a comparison between two tables, one table and a filter, or a date filter only. |
| Field |
Comments are Mandatory |
Specifies if a comment is mandatory to mark the reconciliation line as Handled. |
| Field |
Difference % Calculation |
Specifies the method to calculate the difference percentage for the reconciliation. The difference can be divided by Value, Value (Compared), or Index, where Index divides Value by Value (Compared). |
| Field |
Tolerance Code |
Specifies the reconciliation tolerance code used to identify tolerance settings for determining if a reconciliation line is within range and can be automatically marked as handled. |
| Field |
Exclude Values |
Specifies which values to exclude from the reconciliation lines. "Zero Values" excludes lines with 0 in Value, Value (Compared) and Value (Reference). "Zero Difference" excludes lines with 0 in Difference. |
| Field |
Table Setup Code |
Specifies the unique identifier for the table setup, which defines the table, drill-down page, and fields used to group the reconciliation lines for the Value field. |
| Field |
Opposite Sign |
Specifies whether to use the opposite sign for the Value field in the reconciliation. |
| Field |
Filter |
Specifies the filter that is applied to the table for reconciliation. |
| Field |
Period Code |
Specifies the period for the value. |
| Field |
Custom Name (Value) |
Specifies a custom name for the Value field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Field |
Table Setup Code (Compared) |
Specifies the unique identifier for the table setup, which defines the table, drill-down page, and fields used to group the reconciliation lines for the Value (Compared) field. |
| Field |
Filter (Compared) |
Specifies the filter that is applied to the compared table for reconciliation. |
| Field |
Period Code (Compared) |
Specifies the period for the compared value. |
| Field |
Number of Periods (Compared) |
Specifies the value used to divide the compared value. If left blank, the value will be calculated automatically. |
| Field |
Custom Name (Compared) |
Specifies a custom name for the Value (Compared) field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Field |
Reference Settings From |
Specifies the reference settings, which can be based on either the value or the compared value. |
| Field |
Period Code (Reference) |
Specifies the period for the reference value. |
| Field |
Number of Periods (Reference) |
Specifies the value used to divide the reference value. If left blank, the value will be calculated automatically. |
| Field |
Custom Name (Reference) |
Specifies a custom name for the Value (Reference) field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Field |
Reference 2 Settings From |
Specifies the reference settings for Reference 2, which can be based on either the value or the compared value. |
| Field |
Period Code (Reference 2) |
Specifies the period for the reference value 2. |
| Field |
Number of Periods (Reference 2) |
Specifies the value used to divide the reference value 2. If left blank, the value will be calculated automatically. |
| Field |
Custom Name (Reference 2) |
Specifies a custom name for the Value (Reference 2) field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Field |
Reference 3 Settings From |
Specifies the reference settings for Reference 3, which can be based on either the value or the compared value. |
| Field |
Period Code (Reference 3) |
Specifies the period for the reference value 3. |
| Field |
Number of Periods (Reference 3) |
Specifies the value used to divide the reference value 3. If left blank, the value will be calculated automatically. |
| Field |
Custom Name (Reference 3) |
Specifies a custom name for the Value (Reference 3) field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Field |
Reference 4 Settings From |
Specifies the reference settings for Reference 4, which can be based on either the value or the compared value. |
| Field |
Period Code (Reference 4) |
Specifies the period for the reference value 4. |
| Field |
Number of Periods (Reference 4) |
Specifies the value used to divide the reference value 4. If left blank, the value will be calculated automatically. |
| Field |
Custom Name (Reference 4) |
Specifies a custom name for the Value (Reference 4) field in the reconciliation. Use this to provide a more descriptive or meaningful name than the default. |
| Action |
Lines |
Open the setup page for the lines of the reconciliation. This page allows you to configure the details of the reconciliation line. Useful for setting up the lines for a balance sheet reconciliation. |
| Action |
Groups |
Open the setup page for the groups of reconciliation lines. This page allows you to configure the settings for groups instead of individual lines. |