Why are HANA sequence numbers rounding up in data extraction csv file?

[Lexie]

Hello, everyone, Thrilled I'm finally able to post here.  I have created a stored procedure in HANA to extract transactions from SAP Success Factors into a csv file that drops into our SFTP server.  I am using Express Data Loader as part of this process. 

My question concerns the sequence numbers in the output file. All of them are automatically "rounded" down to the tenths or hundredths place.  For example, 14636698789000369 becomes 14636698789000300. 

Also, we have two types of transactions: imported and manual.  We extract these into separate files. The rounding doesn't seem to happen in the "imported" extraction csv, only in the "manual" one. 

Any help would be appreciated.

[HakanHaslaman]

There could be several reasons why the sequence numbers are rounding up in the data extraction CSV file.

I would check, if the data type of the sequence number column in the database table matches the data type of the corresponding column in the CSV file. If there is a mismatch, it could cause rounding or truncation of the values.
If you are performing any data transformations or calculations on the sequence numbers during the extraction process, such as converting them to a different data type or applying mathematical operations, it could result in rounding errors.
Also, should check the formatting settings of the CSV file. It is possible that the file is configured to round or truncate the values during the export process. Ensure that the formatting settings are configured correctly to preserve the precision of the sequence numbers.
Then review the settings of the Express Data Loader tool you are using for the extraction process. There might be specific configuration options related to rounding or truncation of numeric values. May adjusting these settings could help resolve the issue.