Defining XBRL files

You can define ACL tables from XBRL files. The Data Definition Wizard allows you to select the elements to import, and customize column headings and data types for the elements you are importing.

To create a table from an XBRL file:

  1. Select File > New > Table.
  2. If the Select Platform for Data Source page is displayed, select Local and click Next.
  3. In the Select Local Data Source page, select Disk and click Next.
  4. In the Select File to Define dialog box, locate and select the file you want to create the ACL table from and click Open.

    XBRL 2.1 files have a .xbrl or .xml file extension. The difference between an XBRL file and other XML files is that in the XBRL file the top-level, or root, element tag is <xbrl>.

  5. In the File Format page, verify that the XBRL 2.1 file option has been selected and click Next.
  6. In the Select XBRL Contexts to Import page, select the XBRL contexts to include in the ACL table and click Next. For details on this process, see Selecting XBRL contexts.
  7. In the Select Elements to Import page, select the elements to include in the ACL table and click Next. For details on this process, see Selecting XBRL elements.
  8. In the Preview Data page, you can modify the name and properties for each field by selecting the appropriate column heading in the preview table, in the bottom half of the page, and updating any of the following properties:
    • Ignore this field – If you do not want the field to be included in the ACL table layout, select this checkbox.

    • Name – Keep the name assigned by ACL for the field in the table layout, or enter a different name.

    • Column Title – Enter the column title to display in the default ACL view. If a column title is not specified the Name value is used.

    • Type – Select the appropriate data type from the drop-down list. For information about the supported data types in ACL, see ACL data types.

      The Decimal and Input text boxes appear automatically when you select the corresponding data type.

    • Value – A read-only property that displays the first value in the field. The value is updated based on any edits you make.

    • Decimal (numeric fields only) – Specify the appropriate number of decimal places.

    • Input (datetime fields only) – Specify the format that matches the data. For more information about date and time formats, see Formats of date and time source data.

  9. Click Next after you have finished editing the field properties you want to change.
  10. In the Save Data File As dialog box, enter a name for the ACL data file, and if necessary modify the location where the file will be saved, and click Save.
  11. In the Final page, verify the settings for the new ACL table and click Finish.
  12. Enter a name for the ACL table you are adding to the project, or keep the default name, and click OK.


(C) 2015 ACL Services Ltd. All Rights Reserved.