Invoice_tracking(JAVA related)

CLOSED
Bids
22
Avg Bid (INR)
577 / hr
Project Budget (INR)
₹400 - ₹750 / hr

Project Description:
Complete invoice tracking, which means when payment is done we get corresponding response
message as XML from the third party tool which we use.
With the help of response where we paid certain amount using Debit/Credit card
If total amount paid for month of January 2014 is $10,000 [INVOICE_TOTAL_AMOUNT] from Invoice table and the amount paid now by customer by selecting partial payment radio button and edited amount for each dealer_Id or CFD Number is about $5000 [PAYMENT_MADE_TODAY] from Invoice_Tracking table. Initially [OUTSTANDING_BALANCE] from Invoice_Tracking table will be $0. After the payment is done successfully then the [OUTSTANDING_BALANCE] will be changed to $5000 (which means subtraction of INVOICE_TOTAL_AMOUNT and PAYMENT_MADE_TODAY).
In Invoice_Tracking table PAYMENT_MADE_TODAY is same as TRANSACTION_AMOUNT (from
Payment_Request table)

INVOICE_SEQ_ID will get from Invoice table for that particular INVOICE_TOTAL_AMOUNT.
PAYMENT_RESPONSE_SEQ_ID will get from the Payment_Response table for that particular
transaction
OUTSTANDING_BALANCE will be stored into Invoice_Tracking by doing calculation, see above for description CREATE_DATE is the system date when the records are saved into Invoice_Tracking CREATE_USER_ID is the system user_Id who logged into application, will get from LoggedInUser.
getUserId(), same we stored for both payment_request and payment_response tables.
(for each dealer_Id will have their own InvoiceNumber for each BillingPeriod)
All records to be saved into Invoice_Tracking table
Response from the Third party will be like this for both success and declined transaction
From the complete response I have taken only CTR section anyhow the complete response is in
XML format which will be stored in Payment_Response table as CLOB

Error CTR_SECTION
=========== TRANSACTION RECORD ==========
SOC DEMO0059
abc street
San Francisco, CA 90001
United States
TYPE: Purchase
ACCT: Unknown 100.00 -
CARD NUMBER : ############1881
DATE/TIME : 09 Aug 13 17:16:23
REFERENCE # : M
AUTHOR. # :
TRANS. REF. : FA146798

Transaction not completed

Please retain this copy for your records.
=========================================
Success CTR_SECTION
=========== TRANSACTION RECORD ==========
SOC DEMO0059
abc street
San Francisco, CA 90001
United States
TYPE: Purchase
ACCT: Visa $ 210.00 USD
CARD NUMBER : ############1881
DATE/TIME : 09 Aug 13 18:08:13
REFERENCE # : 000194 M
AUTHOR. # : ET143815
TRANS. REF. : FA146798
Approved - Thank You 100

SIGNATURE
------------------------------------
Please retain this copy for your records.
Cardholder will pay above amount to card
issuer pursuant to cardholder agreement.
=========================================

Hours of work: 12 Project Duration: 1 - 4 weeks Skills required:
J2EE, Java, Javascript
Additional Files: Filestoworkon.docx Application Description.docx Application Files.zip All_Tables.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire sinharavi
₹842 / hr
Hours: 20 hr/ week
₹736 / hr
Hours: 20 hr/ week
Hire sagarshah1983
₹638 / hr
Hours: 25 hr/ week
Hire KnightLight
₹444 / hr
Hours: 20 hr/ week
Hire sekarj
₹400 / hr
Hours: 12 hr/ week
₹750 / hr
Hours: 12 hr/ week
₹736 / hr
Hours: 12 hr/ week
Hire nsarathk
₹666 / hr
Hours: 24 hr/ week
Hire nehajain2050
₹400 / hr
Hours: 12 hr/ week
Hire giribhavana
₹400 / hr
Hours: 12 hr/ week