The complete export of your company account data allows you to follow your activity and to create personalized reports. Thanks to this export you can optimize the management of your activities.
We have developed a new version of your export with more useful information for your reports, for example :
- details on the entities
- opening of RFPs
- type of intermediation on each service...
This article details all the modifications and additions made to your export.
- RFPs
- Proposals
- Projects - POs
- Activity Reports-invoices
- Cost Breakdown
- Negotiations: new tab
- Information
I. How the export works
1. Depth of the export
The export covers the current year N and the year N-1.
It is based on the projects carried out during the period covered. For a project taking place during this period, the call for tenders is included (even if it is prior to year N-1) and all ARCs, even prior to N-1 and up to +2 months in the future (from the date of generation of the export).
Only proposals sent during the period covered are included in the export.
Example:
if the export is generated in 2021, it includes the year 2021 and the year 2020
if a Call for Tenders is created in November 2019 for a project taking place in 2020: then this Call for Tenders is displayed in the export, but not all the proposals sent for this Call for Tenders are displayed; only the accepted proposal that allowed the project to start is kept
on the other hand, if a Call for Tenders is created in 2020 or 2021: all the proposals sent for this Call for Tenders are displayed in the export.
2. Maximum number of lines
Maximum number of lines generated for an export: 200,000 lines
3. Frequency of the export
The export will be generated three times a day, every 8 hours. This allows the data to be refreshed at least once a day (over a working day) for the users of the platform, regardless of their time zone.
Defined times (GMT +1): 8am, 4pm, 00am.
II. Client export pages
ORANGE: MODIFIED
GREEN: ADDED
1. RFPs
Column name |
Column content |
Changes |
---|---|---|
Project ID |
Project identification number |
|
RFP ID |
RFP identification number |
Renamed |
RFP Title |
RFP Title |
|
RFP Status |
RFP Status among :
|
|
RFP validation workflow |
Name of the RFP validation workflow |
|
Buyer’s first name |
First name of the person assigned as a buyer on the RFP |
|
Buyer’s last name |
Last name of the assigned affected as a buyer on the RFP |
|
Operational manager’s first name |
First name of the person assigned as operational manager on the RFP. |
|
Operational manager’s last name |
Last name of the person assigned as operational manager on the RFP. |
|
Legal entity |
Legal entity issuing the RFP |
changed from entity → legal entity |
Legal entity identification key |
ID number linked to the legal entity |
|
Organisational entity |
Organisational entity (linked to the legal entity) issuing the RFP |
|
Organisational entity identification key |
ID number linked to the organisational entity |
|
Project location |
Project location mentioned in the RFP |
|
Project location title |
Name of project location (only if a roject location is configured in the RFP) |
|
Project location identification key |
External reference of project location (only if a project location is configured in the RFP) |
|
Number of profiles required |
Number of profiles required in a multi-project RFP |
|
Skills |
Skills required in the RFP; the skills are listed without the required skill level |
|
RFP open to |
Explains to whom is open the RFP :
|
|
Publication date |
RFP publication date (DD/MM/YYYY) |
|
Last modification date |
RFP last modification date (DD/MM/YYYY) |
|
Expiry date |
RFP expiry date (DD/MM/YYYY) |
change : “closure date” is renamed “expiry validité” |
Closure date |
RFP closure date. This date represents :
|
New information added under the name “closure date” |
PO start date |
PO start date (DD/MM/YYYY) mentioned in the RFP |
|
PO end date |
PO end date (DD/MM/YYYY) mentioned in the RFP |
|
Profile code |
Profile code mentioned in the RFP |
|
Budget name |
Name of the budget linked to the RFP expense line |
|
Budget identification key |
Budget identification key linked to the RFP expense line |
|
Expense line name |
Name of the RFP expense line |
|
Expense line identification key |
RFP expense line identification key |
|
Type of work unit |
Type of work unit specified in the RFP, among : “DAYS”, “HOURS“, “MONTHLY_PACKAGE“, “PACKAGE“ |
|
Number of units |
Number of units provisioned in the PO |
|
Price per unit |
Price per unit excl. tax specified in the RFP |
|
Amount provsioned |
Amount provisioned for the project excl. tax: number of units * price per unit |
|
Currency |
Proposition currency symbol |
|
Region of issuing entity |
Region of entity issuing the RFP |
Deleted :
-
client name
-
SIRET number
-
number of propositions received
-
number of propositions
-
number of propositions selected
2. Proposals
Column name |
Column content |
Changes |
---|---|---|
Project ID |
Project identification number |
|
RFP ID |
RFP identification number |
|
Proposition ID |
Proposition identification number |
|
Supplier name |
Name of the supplier who sent a proposition |
|
Supplier identification key |
Supplier identification key entered by the client regarding the preferred supplier; this line returns N/A if it isn’t a preferred supplier. |
|
Consultant’s first name |
First name of the person assigned as a consultant on the proposition; this line returns N/A if a skills portfolio is submitted. |
|
Consultant’s last name |
Last name of the assigned affected as a consultant on the proposition; this line returns N/A if a skills portfolio is submitted. |
|
Skills portfolio name |
Name of the skills portfolio sent by the provider; this line returns N/A if a consultant profile is submitted. |
|
Business manager’s first name |
First name of the person assigned as a business manager on the proposition; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Business manager’s last name |
Last name of the person assigned as a business manager on the proposition; if there are several people, the last names are displayed by alphabetical order. |
|
Availability date |
Consultant availability date (DD/MM/YYYY) |
|
Proposal status |
Proposition status among :
|
|
Proposal date |
Date of proposal submission by the supplier (DD/MM/YYYY) |
|
Meeting request |
Indicates if a meeting request has been sent: Yes/No |
|
Price per unit offered by the supplier |
Price per unit excl. tax offered by the supplier (markup included) |
The markup amount is now integrated to the price |
Total daily expenses per unit |
Total of all daily expenses of the proposition excl. tax - if the feature is activated for the client. |
|
Currency |
Proposition currency symbol |
|
Deleted :
-
client name
-
client SIRET number
-
provider SIRET number
-
Buyer’s first name
-
Buyer’s last name
-
Operational manager’s first name
-
Operational manager’s last name
-
RFP title
-
RFP status
-
Entity
-
Entity identification key
-
Publication date
-
Modification date
-
Closure date
-
PO start date
-
PO end date
-
Profile code
-
Budget name
-
Expense line name
-
External ID
-
Price per unit
-
Amount provisioned
-
Proposition modification date
-
Commercial pitch
-
Internal notes
3. Projects - POs
Column name |
Column content |
Changes |
---|---|---|
Project ID |
Project identification number |
|
RFP ID |
RFP identification number |
|
Proposal ID |
Proposition identification number |
|
PO ID |
PO identification number |
|
Supplier name |
Name of the supplier who won the RFP |
|
Supplier identification key |
Supplier identification key entered by the client regarding the preferred supplier; this line returns N/A if it isn’t a preferred supplier. |
|
Consultant’s first name |
First name of the person assigned as a consultant on the PO; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Consultant’s last name |
Last name of the assigned affected as a consultant on the PO; if there are several people, the last names are displayed by alphabetical order. |
|
Business manager’s first name |
First name of the person assigned as a business manager on the PO; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Business manager’s last name |
Last name of the person assigned as a business manager on the PO; if there are several people, the last names are displayed by alphabetical order. |
|
Consultant reference number |
Consultant reference number - if filled in by the client |
|
Buyer’s first name |
First name of the person assigned as a buyer on the PO; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Buyer’s last name |
Last name of the assigned affected as a buyer on the PO; if there are several people, the last names are displayed by alphabetical order. |
|
Operational manager’s first name |
First name of the person assigned as operational manager on the PO; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Operational manager’s last name |
Last name of the person assigned as operational manager on the PO; if there are several people, the last names are displayed by alphabetical order. |
|
Legal entity |
Legal entity issuing the RFP |
changed : entity → legal entity |
Legal entity identification key |
ID number linked to the legal entity |
|
Organisational entity |
Organisational entity (linked to the legal entity) issuing the RFP |
|
Organisational entity identification key |
ID number linked to the organisational entity |
|
Project location |
Project location mentioned in the RFP |
|
Project location title |
Name of project location (only if a project location is configured in the RFP) |
|
Project location identification key |
External reference of project location (only if a project location is configured in the RFP) |
|
Project status |
PO status among :
|
|
Project title |
Project title |
|
PO start date |
PO start date (DD/MM/YYYY) |
|
PO end date |
PO end date (DD/MM/YYYY) |
|
Portage contract by LBC (yes/no) |
Indicates if the project is intermediated by LittleBig Connection |
|
Type of service |
Type of service among :
|
|
PO renewal index |
PO renewal index; the 1st PO bears #1, then the number is incremented with each renewal |
renamed |
PO number |
PO number |
|
Profile code |
Profile code mentioned in the PO |
|
Budget name |
Name of the budget linked to the PO expense line |
|
Budget identification key |
Budget identification key linked to the PO expense line |
|
Expense line name |
Name of the PO expense line |
|
Expense line identification key |
PO expense line identification key |
|
Type of unit |
Type of work unit specified in the PO, among : “DAYS”, “HOURS“, “MONTHLY_PACKAGE“, “PACKAGE“ |
|
Number of units |
Number of units provisioned in the PO |
|
Price per unit |
Price per unit excl. tax - markup included |
The markup amount is now integrated to the price |
Free work units |
Free hours/days/months agreed on during the negotiation phase |
|
Daily expense amount per unit |
Total amount of daily expenses per unit excl. tax |
Daily expenses are now displayed per unit (instead of showing the total of all daily expenses for the PO) |
Amount provisioned |
Amount engaged on the PO excl. tax: number of units * price per unit (markup included) + daily expenses * number of units |
Calculation method modified to include the free work units : total number of units - number of free units |
Currency |
PO currency symbol |
|
Region of issuing entity |
Region of entity issuing the PO |
|
Deleted :
-
Client name
-
Client SIRET number
-
Provider SIRET number
-
Client PO number (entry date)
-
Project code
-
External ID
4. Activity Reports - Invoices
Column name |
Column content |
Changes |
---|---|---|
Project ID |
Project identification number |
|
RFP ID |
RFP identification number |
|
Proposal ID |
Proposition identification number |
|
PO ID |
PO identification number |
|
Activity Report ID |
Activity Report identification number |
|
Supplier name |
Name of the supplier who won the RFP |
|
Supplier identification key |
Supplier identification key entered by the client regarding the preferred supplier; this line returns N/A if it isn’t a preferred supplier. |
|
Consultant’s first name |
First name of the person assigned as a consultant on the Activity Report; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Consultant’s last name |
Last name of the assigned affected as a consultant on the Activity Report; if there are several people, the last names are displayed by alphabetical order. |
|
Business manager’s first name |
First name of the person assigned as a business manager on the Activity Report; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Business manager’s last name |
Last name of the person assigned as a business manager on the Activity Report; if there are several people, the last names are displayed by alphabetical order. |
|
Buyer’s first name |
First name of the person assigned as a buyer on the Activity Report; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Buyer’s last name |
Last name of the assigned affected as a buyer on the Activity Report; if there are several people, the last names are displayed by alphabetical order. |
|
Operational manager’s first name |
First name of the person assigned as operational manager on the Activity Report; if there are several people, the first names are displayed following the last names' alphabetical order. |
|
Operational manager’s last name |
Last name of the person assigned as operational manager on the Activity Report; if there are several people, the last names are displayed by alphabetical order. |
|
Activity Report start date |
Activity Report start date (first day of the month on the Activity Report) (DD/MM/YYYY) |
|
Activity Report end date |
Activity Report end date (last day of the month on the Activity Report) (DD/MM/YYYY) |
|
Date of Activity Report input by the consultant |
Date of Activity Report input by the consultant (DD/MM/YYYY) |
|
Date of Activity Report validation by the business manager |
Date of Activity Report validation by the business manager (DD/MM/YYYY) |
|
Date of validation by the client |
Date of validation by the client (DD/MM/YYYY) |
|
Activity Report status |
Activity Report validation status among :
|
|
Type of unit |
Type of work unit specified in the Activity Report, among : “DAYS”, “HOURS“, “MONTHLY_PACKAGE“, “PACKAGE“ |
|
Price per unit |
Price per unit excl. tax specified in the Activity Report |
|
Daily expense amount per unit |
Total amount of daily expenses per unit excl. tax |
|
Free work units |
Free hours/days/months agreed on during the negotiation phase |
|
Number of units |
Number of units reported on the Activity Report |
|
Regulations |
Regulations amount excl. tax reported on the Activity Report |
|
Extra-time amount |
Extra-time amount excl. tax reported on the Activity Report |
|
Total Price excl. tax |
Total price excl. tax calculated on the Activity Report: Price per unit * (Number of units - free units) + Price per unit * regulation + extra time + total daily expenses If daily expenses are calculated on a prorata basis: exact number of units is used to calculate daily expenses Otherwise: daily expenses are rounded up to the higher unit |
Calculation method modified to include the free work units : total number of units - number of free units Calculation method for daily expenses is taken into account (prorata / no prorata) |
Expense amount |
Total expense amount incl. tax reported on the Activity Report |
|
Tax total |
Tax amount reported on the Activity Report |
|
Total price tax incl. |
Total price incl. tax calculated on the Activity Report: Total price excl. tax + Tax total + Expense amount |
|
Invoice number |
Invoice number - if it exists |
|
Currency |
Activity Report currency symbol |
|
Deleted :
-
client name
-
client SIRET number
-
provider SIRET number
-
Project title
-
Entity
-
Entity identification key
-
PO number
-
Budget name
-
Expense line name
-
External ID
5. Cost Breakdown
Column name |
Column content |
---|---|
Activity Report ID |
Activity Report identification number |
Project code |
Project code linked to the Activity Report |
Type of unit |
Type of work unit specified in the Activity Report, among : “DAYS”, “HOURS“, “MONTHLY_PACKAGE“, “PACKAGE“ |
Number of units |
Number of units reported on the Activity Report |
Deleted: Comment
6. Premium Feature - Negotiation: new tab
Column name |
Column content |
---|---|
Proposition ID |
Proposition identification number |
First proposition |
Indicates if this proposition is the first proposition : yes/no |
Final proposition |
Indicates if this proposition is the final proposition : yes/no |
Proposition accepted |
Indicates if this proposition has been accepted : yes/no Helps distinguish successful negotiations from refused negotiations (leading to a cancelled proposition) |
Proposition number |
Propositions numbered from 1 to N |
Price per unit offered |
Price per unit excl. tax offered by stakeholder (provider or client) |
Daily expenses per unit |
Daily expenses excl. tax offered by stakeholder (provider or client) (sum of all daily expenses if different types of daily expenses exist) |
Free work units |
Number of offered free hours/days/months numbered from 1 to N |
Submitted by |
Indicates which stakeholder submitted the proposition: provider or client |
7. Information
Nom de la ligne |
Contenu de la ligne |
---|---|
Date of extract |
Date of data extract (DD/MM/YYYY) |
Hour of extract |
Hour of data extract (00:00) |
User requesting the extract |
Name of user requesting the extract |
Client corporate name |
Client name |
SIRET number |
Client SIRET Number |
Project date range |
From January of year N-1 au to month M of year N (current month of current year) |