Automatic columns
When uploading a file, Simetrik will automatically generate 4 columns with information for all transactions.
Last updated
When uploading a file, Simetrik will automatically generate 4 columns with information for all transactions.
Last updated
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:
SKT_ID: Corresponds to a unique ID that Simetrik assigns to each of the transactions in the sources and reconciliations.
SKT_CREATED_AT: Corresponds to the date and time when a SKT_ID was created, that is, a record/transaction in Simetrik.
SKT_CREATED_DATE: Corresponds to the date when a SKT_ID was created, that is, a record/transaction in Simetrik.
FILE_ID: Corresponds to a unique ID or identification that Simetrik gives to each file loaded in the system.
FILENAME: Corresponds to the original name of the file that was uploaded to the source.
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:
