There have been the following changes to the ISSR table:
-added an additional field to the right of "ISSR_SIC_CD" (which appears on the Public Company screen of the MySQL database as "SIC Code") called "ISSR_IND_SCTR_NM." This field should be added with the same type of partial completion text box above it to the public company screen to the right of "SIC Code" and be labeled "SIC Description." This field should also appear in the "Company Details" sub-screen underneath "SIC Code."
-populated 4 fields to the right of ISSR_FYE; 1) ISSR_LRG_ACCLRTD_FLR_IN, 2) ISSR_ACCLRTD_FLR_IND, 3) ISSR_SML_RPTG_CPNY_IN, and 4) ISSR_WLL_KNWN_SND_ISSR_IN. These are true/false indicators that should be shown in the "view details" sub-screen of the Public Company screen underneath the "Fiscal Year End" field in the "Company Details" box..
-I removed one of the address fields so now there are only 3, but you will need to combine the address fields as you did before for the new issuers (see next point).
-There are several hundred new issuers that will need to be added but of course all of the IDs stay the same for the old ones - I assigned IDs to the new ones.
I also removed the "ISSR_ACTV_INDCTR field from the ISSR table but this wasn't being used in the MySQL database.
Much of the data in the ACCTG_FIRM_CLIENT table has been updated and there are new records in this table as well. I added a field for AUD_OPN_DT_4 but you do not need to add a new field, just update the data in the first three AUD-OPN fields.
The ACCT_FIRM table has been appended.
Also, I've adding a new table for fee data (ACCT_FIRM_FEES). The fee data is keyed to the ACCT_FIRM_CLIENT_ID field in the ACCT_FIRM_CLIENT table. I would like to have a new box labeled "Audit Fee Details" and include the data from this table for each of the ACCTG_FIRM_CLIENT relationships (the data isn't yet complete, so some companies will be blank but that's OK; I'll add the data later).
26 freelancers are bidding on average $504 for this job
Hi, PHP + Mysql expert here! I can do this perfectly! Completed nearly 30 projects related tp PHP + Mysql. Please check my profile for more details, send me a PM ...
Hello, I interested in your project and would like to make changes to your website, would you mind sharing more details about your web interface? Thanks