System and method for establishing pricing for telecom services

A system comprising:

• an email server for receiving an email from a telecommunications services supplier, the email including identification information of the telecommunications services supplier;
• and
• a costing system in data communication with the email server, the costing system comprising a multilayered architecture of at least five layers including (a) a firewall configured to validate requests from valid IP addresses, (b) a network load balancer configured to balance HTTP requests using a Random/Load based algorithm, (c) a web layer comprising an HTTP server on each of at least two redundant servers, (d) an application service layer comprising an application server HTTP module on each of the at least two redundant servers, and (e) a database layer comprising
• a costing database in data communication with a costing database server, the costing database configured to store data of at least one pre-approved telecommunications service supplier and telecommunications service rate information associated with the at least one pre-approved telecommunications service supplier, and
• a current rate summary database in communication with the costing database, the current rate summary database configured to store updated telecommunication services rate information associated with pre-approved telecommunication services suppliers;
• at least one costing interface in data communication with the costing database configured to one of view or replicate data in the costing database,
• wherein the costing database server of the costing system:
• determines whether the identification information of the telecommunications services supplier is one of the at least one pre-approved telecommunications services supplier stored in the costing database of the costing system;
• determines whether the email includes a rate sheet containing telecommunications services rate information of the telecommunications services supplier;
• classifies the email according to whether the telecommunications services supplier is one of the at least one pre-approved telecommunications services supplier and whether the email includes the rate sheet containing the telecommunications services rate information of the telecommunications services supplier;
• if the email is classified as being received from the at least one pre-approved telecommunications services supplier and includes the rate sheet, transmits updates to the telecommunications services rate information of the supplier stored in the costing database according to the telecommunications services rate information contained in the rate sheet, thereby causing the costing database to be updated based in part upon the automatic classification of emails;
• queues the rate sheet if the email is classified as being received from the at least one pre-approved telecommunications services supplier and includes the rate sheet;
• and
• overrides the queue based upon a Soonest Estimated Effective Date (SEED) of the rate sheet, the SEED based on a receive date of the rate sheet and a contractual notice period over which a rate in the rate sheet is contractually agreed upon to remain constant.

A system comprising:

• an email server for receiving an email from a telecommunications services supplier, the email including identification information of the telecommunications services supplier;
• and
• a costing system in data communication with the email server, the costing system comprising a multilayered architecture of at least five layers including (a) a firewall configured to validate requests from valid IP addresses, (b) a network load balancer configured to balance HTTP requests using a Random/Load based algorithm, (c) a web layer comprising an HTTP server on each of at least two redundant servers, (d) an application service layer comprising an application server HTTP module on each of the at least two redundant servers, and (e) a database layer comprising
• a costing database in data communication with a costing database server, the costing database configured to store data of at least one pre-approved telecommunications service supplier and telecommunications service rate information associated with the at least one pre-approved telecommunications service supplier, and
• a current rate summary database in communication with the costing database, the current rate summary database configured to store updated telecommunication services rate information associated with pre-approved telecommunication services suppliers;
• and
• at least one costing interface in data communication with the costing database configured to one of view or replicate data in the costing database,
• wherein the costing database server of the costing system:
• determines whether the identification information of the telecommunications services supplier is one of the at least one pre-approved telecommunications services supplier stored in the costing database of the costing system;
• determines whether the email includes a rate sheet containing telecommunications services rate information of the telecommunications services supplier;
• classifies the email according to whether the telecommunications services supplier is one of the at least one pre-approved telecommunications services supplier and whether the email includes the rate sheet containing the telecommunications services rate information of the telecommunications services supplier;
• if the email is classified as being received from the at least one pre-approved telecommunications services supplier and includes the rate sheet, transmits updates to the telecommunications services rate information of the supplier stored in the costing database according to the telecommunications services rate information contained in the rate sheet, thereby causing the costing database to be updated based in part upon the automatic classification of emails;
• and
• periodically reordering a queue, the periodic reordering comprising checking, at prescribed periods, Soonest Estimated Effective Dates (SEEDs) associated with each entry in the queue, and reordering the queue in ascending order of SEED, the SEED based on a receive date of the rate sheet and a contractual notice period over which a rate in the rate sheet is contractually agreed upon to remain constant.