...
| Placeholder name | Description |
|---|---|
| Company details | The supplier's company. |
| <#Lines.IsExternal> | Boolean true/false. True if the company is an external supplier. False if it is the platform's company (of internal workers). |
| <#Lines.Id> | The unique company ID (number). |
| <#Lines.Company> | The client company name. |
| <#Lines.Type> | The project status title. |
| <#Lines.CountryCode> | A three letter ISO country code. |
| <#Lines.Country> | Country name. |
| <#Lines.TZ> | The timezone code of the company. |
| <#Lines.TZMin> | The timezone offset in minutes from UTC. For example: 60, 120, -360... |
| <#Lines.TZOffset> | The timezone offset in easy readable form. For example: UTC+1, UTC-10.... |
| <#Lines.AccountingCode> | The company accounting code |
| <#Lines.City> | The city. |
| <#Lines.Code> | The company code (a free text field that can be supplied in the company details page). |
| <#Lines.ContactEmail> | The company contact email. |
| <#Lines.ContactPhone> | The company contact phone. |
| <#Lines.State> | The company state if supplied. |
| <#Lines.Zip> | The company zip code if supplied. |
| <#Lines.CCF1> ... <#Lines.CCF20> | Company custom fields 1 to 20. Each of your custom fields has a numeric ID. Finding Custom Field ID |
| Person details | Filled in if the line refers to an internal worker. For external suppliers all person fields are empty. |
| <#Lines.PersonId> | The unique internal ID of the person. |
| <#Lines.PersonFirstName> | Person first name. |
| <#Lines.PersonLastName> | Person last name. |
| <#Lines.PersonCode> | Person code as supplied in the person details page. |
| <#Lines.PersonRole> | The person's role in the company. |
| <#Lines.PersonEmail> | Person email address. |
| <#Lines.PersonPhone> | Person phone. |
| <#Lines.PersonTitle> | Person title such as Mr. or Mrs. |
| <#Lines.PCF1> ... <#Lines.PCF20> | Person custom fields 1 to 20. Each of your custom fields has a numeric ID. Finding Custom Field ID |
| Work time | |
| <#Lines.DaysWorked> | Total days worked. |
| <#Lines.HoursWorked> | Total hours worked. This takes into account the weekly work time information stored with each supplier. However it does not take into account the (optional) time limitation set on an off day. A day is always counted in full. |
| Date columns | Per each calendar date, a column is added to Excel. The columns are numbered 0 for the first date and up to 61 for the last date |
<#Lines.EVT0> <#Lines.EVT1> ... <#Lines.EVT61> | Column Lines.EVT0 corresponds to the first date in the selected date range. Column #1 to the second date, up to column #61 to the last date. This allows to display up to 2 months. The content of each cell is:
The cell may be suffixed with L to indicate that the off-day is restricted to specific languages (and matches the services in the row). Example:
|