Automatic columns

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

Automatic column identification

In the following image you will be able to identify the automatic columns that Simetrik generates so you can control and audit your transactions in a simpler way.

The automatic columns generated by Simetrik are:

1. SKT_ID: Unique ID that Simetrik assigns to each of the source transactions and reconciliations.

2. SKT_CREATED_AT: Date and time an SKT_ID was created, that is, a record/transaction in Simetrik.

3. SKT_CREATED_DATE: Date on which an SKT_ID was created, that is, a record/transaction in Simetrik.

4. FILE_ID: Unique ID or identification that Simetrik gives to each file uploaded to the system.

5. FILENAME: Original name of the file that was loaded in the source.

6. FILE_ROW_NUM: Row number where that line is located in the file loaded in the system.

7. SKT_UNIQUENESS: It is a column of duplicates that includes all the original columns of the file as criteria.

You can identify the automatic columns with the following icon on the left side of the name: