Defining Data Source Properties

Use the following steps to define the properties of a data source.

  1. Enter an ID for the data source and a descriptive name.

    The ID must be an alphanumeric value that is less than or equal to 27 bytes. Special characters allowed are period (.), underscore (_), and hyphen (-).

    Note:

    You cannot use the name, Reconciliation ID, as an ID since it is a reserved ID.
  2. Indicate whether the data source is a Source System or a Sub System data source.
  3. Decide whether you want to allow deletion of transactions by users for this data source. For information about deleting transactions, see Deleting Transactions
  4. Decide whether you want to allow split of transactions by users for this data source. Then, click Save. For information about splitting transactions, see Splitting Unmatched Transactions
  5. In Data Source Attributes, click + (New Attribute) to start adding attributes to describe how the data in this column should appear. Keep in mind that this is how you can use the powerful calculated attributes feature to normalize and enrich your data before using the matching engine in Transaction Matching.

    See About Data Source Attributes for details about the information that must be provided when creating a data source attribute.

    When you select Group under Type, select the required group attribute from the list of available group attributes in Group Name. Note that the list include only group attributes defined in the Group Attributes tab in Transaction Matching. The ID and Name fields are disabled and their values are automatically updated based on your selection.

    Note:

    You must create a Date type attribute that is required to represent the Accounting Date.
  6. (Calculated attributes only) To create a calculated attribute, select Calculation.

    See About Calculated Attributes for additional information about calculated attributes.

    • Under Calculation Type, select one of the following options: Assign Value to List, Assign List To Value, Conditional, or Scripted.

      Note that the options listed depend on the data type selected for the attribute. See About Data Source Attributes.

    • When you select Scripted Calculation type, to enter a free-form calculation equation, use the Add Attribute and Add Function:

      • Add Attribute—Select an attribute and click Add to insert the attribute into the Calculation Definition box at the location of the cursor. If the cursor is in the middle of a word or attribute, the word/attribute will be replaced in the definition. Any attribute that is added will have brackets {} around the name, according to the scripting format.

      • Add Function—Select a function and click Add to add the function to the Calculation Definition. The Function is added with placeholders for each parameter.

  7. Click Save to continue adding the next attribute.