In this article

This section describes LNP files integration between TJA LNP database and JeraSoft billing. It defines a list of fields for the database updates records.

File Format

Your LNP files need to be of .csv format with a semicolon delimiter, and with a header. Those files should be .zip archived.

Columns Description

As for the format, the TJA collector expects the following values to be present in the header:

Field NumberDefinitionDescriptionExample
1numberOriginal number0000
2rn_numberRouting number70003117
4ownerOwner of the number (used as a tag)


5effective_dateStart date of the number

2020-06-15 00:00:00 +0000

  • No labels