Page 1 of 1
E-Procurement Solutions
Posted: Wed Jul 21, 2004 5:42 am
by amitg
Presently i m in charge of an E-Procurement project of france..some of the portions of the SRS i m not getting throughly..if anybody has past experience in E-CRM related project in PHP , Mysql ..plz contact me ASAP ..
looking for urgent reply from open source developer
Note : i just need some clarification on documents
bye

Posted: Wed Jul 21, 2004 5:30 pm
by McGruff
You're buying FRANCE?
Posted: Wed Jul 21, 2004 6:24 pm
by JAM
Well, the question itself is abit loose to me. I've created parts of global help-desk and claim systems solutions for the company currently employing me. But, if that fits the "experience" category I'm not sure. And what do you mean with "clarification of documents" in the sence of talking about CRM's?
Can you provide more info?
Posted: Wed Jul 21, 2004 11:35 pm
by amitg
i am showing the main part of the document in which some points i find very odd
this is the catalogue management module (which will be managed by supplier)
-------------------------------------------------------------------------------------
Information organization is based on two main tables: “CLASSEMENT” (classification table) which contain the relations between structures and hierarchical levels, and table “STRUCTURE” which contains the description for each structure.
The hierarchical system of classification is carried out based on the following models:
From more general to more detailed. It is composed in 4 tables, with the following hierarchical order:
Table “FAMILY” contain the categories or rubrics present on website homepage. It is the higher hierarchical level. For instance “Industrie/achat”, “Informatique/Tel”, “Matériel de bureau”, “Electricité”, “Communication”, “Retail CHR”, “Medical”, …
Table “SUB-FAMILY” containing subjects or “sub-rubrics” associated to a FAMILY Going further in our example: “Matériel de Bureau”>”Fourniture”
Table “SUB-SUB-FAMILY” containing subjects or “sub-sub-rubrics” associated to a “SUB-FAMILY”. To go further in our example: “Matériel de Bureau”>”Fournitures”>”Pens”
Each structure is having a space to present its actuality and/or its Hotdeals. That information is stocked into table “INFORMATION”.
Finally the Internet users will be able to react to an actuality or an Hotdeal. Reactions will be stocked into the table “REACTION”.
Each structure can be associated to a “SUB-SUB-FAMILY” or a “SUB-FAMILY” or a “FAMILY” or a “CATEGORY”. We agreed that each level is listing the names of the lower hierarchical level. The association of a structure to a subject is made in table “CLASSEMENT” with the following cells.
In our example, it will be possible to found the structure with the following entries:
- CATEGORY: in the exhaustive list of the entire entries corresponding to “Products”;
- FAMILY: in the list of the entire entries corresponding to “Matériel de bureau”;
- SUB-FAMILY: in the list of the entire entries corresponding to “Fournitures”;
- SUB-SUB-FAMILY: in the list of the entire entries corresponding to “Pens”;
- PRODUCT_SHEET: in the list of the entire entries corresponding to “Roller Pens”;
- STRUCTURE: product page
It will be possible to associate a STRUCTURE to multiple subjects (without limitation). For instance, the Purchasing Manager, on behalf a supplier previously registered, will be in charge of publishing suppliers catalogue. He can ask a Purchasing Manager to establish a bill of materials (BOM) in order to source relevant suppliers, publishing a request for quotes (RFQ) and/or information on the supplier Extranet.
For exemple, “Matériel de bureau”, “Fournitures” and “Roller Pens” could have the following entries:
The table “INFORMATION” is containing the actuality and Hotdeals relating to the structures and/or a hierarchical level. By defect, those peaces of information will be published by a project manager. However it will allow a remote publication for purchasing Managers (especially for Hotdeals).
Example:
After selecting the FAMILY “Matériel de bureaux”, the Internet user will be able to see all “actualities” and “hotdeals” associated.
When the Internet user is seeing this rubric for the first time, he comes from summary, thus from “CATEGORY”.
The page is listing all elements classified in the CATEGORIY with the “ACTIVATION” field active. It also lists the 10 first INFORMATION (Actuality and Hotdeals), which match the CATEGORY.
Next to the keyword research, the internet user can:
- Make an advanced research selecting a FAMILY or a SUB-FAMILY
- Search into database using keywords
In case an Internet user is selecting a FAMILY or a SUB-FAMILY, it is the page corresponding that will be displayed. But list of elements will only show the classified elements linked to the selected FAMILY or SUB-FAMILY.
The page is always displaying the 10 information from ACTUALITY corresponding to the FAMILY or SUB-FAMILY (if there is 10 elements for one or the other, it will be displayed the existing information and if not, it will be displayed the 10 information of the higher level. If there is always no information, it will display the general information located: table CLASS_ACTU without information classification)
Rubric INFORMATION is composed of 2 pages: one page ACTUALITIES and a page HOTDEALS.
The page ACTUALITIES: this page contains the information corresponding to the current rubrics when an Internet user asks for the page.
The page HOTDEALS is accessible with the following conditions:
- When an Internet user clicked on an ACTUALITIES or an HOTDEALS from the home page,
- When an Internet user clicked on an ACTUALITIES or an HOTDEALS from any page from the number 1, 2 or 3 list
2 different management s are possible:
- The list published is the list corresponding to the selected CATEGORY
- Or the list published is the list corresponding to the current level of consultation at the moment of consultation. (FAMILY, SUB-FAMILY, SUB-SUB-FAMILY, PRODUCT-SHEET)
It will be required to sign to publish the INFORMATION
------------------------------------------------------------------------------------
END
------------------------------------------------------------------------------------
Doubts
1.how structure relates to the hierarchy table
2.what is actuality and hot deals
3.how it relates to the structure
4.who will post the hot deals
Boss,try to find out these set of questions...other CRM module i understand in the system..but this catalogue management i dont get throughly
thanks for your reply
amit