🇬🇧
Simetrik Academy (EN)
  • 🏡Simetrik Academy
  • 📺Youtube • Simetrik
  • 🚀What's new
    • Transformations improvement
    • Groupings
      • Cumulative groupings
    • Crossover rules
    • Link to Quicksight
    • Archive reconciliations
  • 🦮Quick guide
    • Create your first reconciliation
    • Accounts and workspaces
      • Account creation
      • Auth0 Guardian Authentication
    • 1. Prepare your sources
    • 2. Configure your crossover
    • Glossary
    • Folder manager for sources, reconciliations and dashboards
    • 3.Check your results
  • 📄Sources
    • Uploading TXT files
    • Sources management
    • Updating sources
    • What can you find in your source?
      • Automatic duplicates column
      • Automatic columns
      • Applying Filters
      • Reconcilable Groups
      • Groupings
      • Transformation columns
      • Duplicate columns
    • Deleting multiple files
    • Automatic columns
    • Join of sources
  • 🔁Reconciliations
    • Creation of crossover keys
    • Collisions
    • Modification of crossover keys
    • Reconciliation sweeps
    • Sweep robustness
    • Tolerance and non-equal keys
    • Edit reconciliation
    • Manual reconciliations
    • Crossover Types Configuration
    • Chained reconciliation
    • Reconciliation tables
    • VLookUp column
    • Validation of amounts in Manual Reconciliation
    • Record adjustment
    • Archive reconciliations
    • Multiple manual reconciliations
    • Reconciliation Folders
    • Status of a reconciliation
  • 📊Dashboards
    • Dashboards name edition
    • Reconciliation Percentage
    • Custom dashboard
    • Pivot table
    • Delete Dashboard
  • 🔔Alarms
    • Alarms and notifications
  • 🔌Integrations
    • What is an integration?
    • Types of input integration
      • SFTP
  • Training session
    • Training of Trainers
  • FAQ & Tips
    • ❔FAQ
    • 🎇Tips
Powered by GitBook
On this page

Was this helpful?

  1. Sources
  2. What can you find in your source?

Automatic columns

When uploading a file, Simetrik will automatically generate 4 columns with information for all transactions.

PreviousAutomatic duplicates columnNextApplying Filters

Last updated 3 years ago

Was this helpful?

Identification of automatic columns

In the following image you can identify the automatic columns provided by Simetrik to control and audit your transactions in a simpler way.

Automatic columns The automatic columns generated by Simetrik are:

  1. SKT_ID: Corresponds to a unique ID that Simetrik assigns to each of the transactions in the sources and reconciliations.

  2. SKT_CREATED_AT: Corresponds to the date and time when a SKT_ID was created, that is, a record/transaction in Simetrik.

  3. SKT_CREATED_DATE: Corresponds to the date when a SKT_ID was created, that is, a record/transaction in Simetrik.

  4. FILE_ID: Corresponds to a unique ID or identification that Simetrik gives to each file loaded in the system.

  5. FILENAME: Corresponds to the original name of the file that was uploaded to the source.

  6. SKT_UNIQUENESS: Corresponds to the automatic identification of duplicates on the tool. If you want to explore more about this column, go to the next section where you can go into detail about it.

The automatic columns SKT_ID, SKT_CREATED_AT, SKT_CREATED_DATE and SKT_UNIQUENESS can be identified by the following icon on the left side of the name:

📄