COLDFUSION ASSIGNMENT

[login to view URL] Customer ALL THE FIELDS IN THE CUSTOMER TABLE WITH LOOKUP IN ROWWISE [login to view URL] CUSTOMER IN SINGLE EACH SHOULD CONTAIN TWO LINKS: [login to view URL] MESS REPORT [login to view URL] ACCOUNTS ONCLICK THE PAGE SHOULD OPEN IN NEW PAGE WITH FOLLOWING SHOULD BE WITH PAGINATION 15 RECORDS PER PAGE [login to view URL] MESS REPORT CUSTOMER TABLE : CUSTOMERS CUSTOMERID,FIRSTNAME ,LASTNAME,MOBILE,COMPANYNAME NESSLOG TABLE : ALL THE FIELDS AND RECORD IN THE MESSLOG TABLE SHOULD BE WITH LOOKUP TABLE [login to view URL] ACCOUNTS TABLE MessAccounts CUSTOMER TABLE : CUSTOMERID,FIRSTNAME,LASTNAME,MOBILE,COMPANYNAME MESSACCOUNTS : ALL THE FIELDS WITH LOOKUP OUTSTANDING AMOUNT SHOULD BE IN THE TOP [login to view URL] PURCHASE REPORT USER WILL SELECT MORE THAN 3 LABEL THE REPORT SHOULD BE TWO DATES TABLE TO USE : CREDITPURCHASE THERE SHOULD BE A FORM FOR [login to view URL] DATE [login to view URL] DATE [login to view URL] OF LABELS FROM LABELS TABLE A)MORE THAN ONE LABEL SHOULD BE SELECTED AND UPTO 4 LABELS ALLOWED. B)ON SELECT AND SUBMIT BUTTON REPORT SHOULD OPEN IN SEPARATE PAGE AS BELOW DATE OPENINGBALANCE CLOSINGBALANCE SALES 1/1/2010 1000 200 50 1/2/2010 2533 563 25 2/2/2010 56 656 65 AT BOTTOM THERE SHOULD BE SUBTOTAL FOR EARCH COLOUMN REFER LABEL TABLE [login to view URL] TABLE DATA ENTRY PAGE FOR MESSACCOUNTS TABLE [login to view URL] SHOULD BE SELECT FIRST FROM A DROPDOWN BOX WITH CUSTOMER LIST (FIRSTNAME AND LAST) AND SUBMIT [login to view URL] SELECTING THE CUSTOMER'S CURRENT BALANCE SHOULD BE SHOWN IN A LABEL (CAN BE CALCULATED FROM MESSACCOUNTS TABLE) [login to view URL] SAME PAGE A FORM WITH ALL THE FIELD MESSACOUNTS TABLE SHOULD BE DISPLAYED MESSMONTH SHOULD HAVE JAVASCRIPT CALENDAR DEBITORCREDIT FIELD SHOULD BE OPTION BUTTON WITH DEBIT CHECKED BY DEFAULT REPORTRUNON FIELD SHOULD DATE SAVED. LABEL SHOULD BE TEXT FIELD - ITS A COMMENTS AMOUNT CUSTOMERID USERID WHO SAVED THE [login to view URL] CAN PUT 1 JAVASCRIPT VALIDATION SHOULD BE THERE AMOUNT SHOULD BE VALID SHOULD USE THE TEMPLATES FOR THE HEADER AND [login to view URL] BE PROVIEDED AFTER WINNING THE PROJECT REFER THE [login to view URL] FILE ATTACHED