MS-SQL quairy + small web script

Closed

Description

Hello,

I want to know if an invoice that i sent recived by the customer. the app recive the information from a specific field in The DB - send it to the Israeli post web page ([url removed, login to view]) and create a table during to the status of the mail.

Te output is a table with 6 colums : DB name, customer name, invoice number, Delivery Tracking number, document total, create date, mail status.

there will be a "refresh" button, and option for auto-refresh by changeable interval time (every 1 hour, 2 hours, 1 day act...). the data will be able to be taken from several DBs.

the colums can be sortable (sort by name, sort by invoce number...)

I'm using SAP B1 (ms-sql DB). there will be an setting menu, and there i"ll configure the server name, DB name, DB password, tables name, field's names. the setting can be exportable and importable. Attached a sample of the table.

Regards,

Nadav

Skills: ActionScript, SAP, SQL, webMethods

See more: sap script, customer tracking app, invoce, web script, sql l, Sql 2012, SAP SQL, sap co, SAP B1, ms sql, invoice app, small data table, sap data output, sql create script, small web app, sortable table, auto send app, web server http, table sortable, post web, create tables sql 2012, create web page sql table, sap app, 2012 create web page, auto refresh page

Project ID: #4032644

Awarded to:

sadeque

Lets start

$100 USD in 7 days
(12 Reviews)
4.4

3 freelancers are bidding on average $117 for this job

kushanx

I am an expert web developer with more than 12 years of experience. I have requested more information on the PM

$100 USD in 3 days
(20 Reviews)
3.9
venkatreddyc

We will help you to build the script

$150 USD in 5 days
(0 Reviews)
0.0