This report prints all external supplier services with full price details, discount options and other properties.
| Table of Contents |
|---|
Report content
Each line shows one specific service.
Template
Screenshot of default template:
Global placeholders
These can be placed in any location in the Excel and are general properties applicable to all the report.
| Placeholder name | Description |
|---|---|
| <#StartDate> | The start date selected when creating the report. The date is adjusted to the time zone you have configured. |
| <#EndDate> | The end date selected when creating the report. The date is adjusted to the time zone you have configured. |
| <#GeneratedDate> | The date when the report was generated. |
| <#MasterCurrency> | Your default currency as 3 letter ISO code (such as EUR or USD). This is taken from the default price list you configured in the My Company page of your platform. Read more. |
Data rows and placeholders
Each row in the report corresponds to a job documentsupplier service. In other words, all information of a specific invoice supplier service will be contained in one single row.
...
| Placeholder name | Description | ||||
|---|---|---|---|---|---|
| Project fields | The project to which an invoice refers to. | ||||
| <#Lines.First> | Prints a * (star) if this is the first line for a project. The report contains as many lines per project as there are jobs and documents. | ||||
| <#Lines.ProjectReference> | The project reference. | ||||
| <#Lines.ProjectStatus> | The project status title. | ||||
| <#Lines.ProjectType> | The type of project. Prints either "Standard" or "Codyt". The former is for standard projects and the latter for Codyt projects. This title is not localized. | ||||
| Job details | Shows all the job Supplier | Shows all the supplier details for this line. | |||
| <#Lines.JobReference>Company> | The reference of the job. With Codyt jobs this is equivalent to the document name of the job.supplier company. | ||||
| <#Lines.JobStatus>Person> | The status title of the job. Note that status titles are localizedsupplier person. | ||||
| <#Lines. | JobAllocMode>The mode of allocation of the job. Either one of Fixed assignment, Job opening or Crowd. In the case of job openings, the mode is changed to fixed assignment once a supplier is assignedPersonId> | The supplier person ID. | |||
| <#Lines. | JobTaskCode>PersonRole> | The task code such as TR for translation or PROOF for proofreading. These codes can be viewed in Wordbee under Settings > Task categories.supplier person role. | |||
| <#Lines.JobTaskName> | The task. Tasks are "Translation", "Revision", etc. Note that the task name is localized. For example, if an invoice contains details for translation then this field will be "Translation". | ||||
| <#Lines.JobSourceLocale> | The list of all target language ISO codes contained in the invoice and separated by commas. Note that the language names are localized. | ||||
| <#Lines.JobSourceLocale> | The source language ISO code. Note that thelanguage names are localized. | ||||
| <#Lines.JobSourceLocaleName> | The source language name. Note that the language names are localized. | ||||
| <#Lines.JobTargetLocale> | The target language ISO code. Note that thelanguage names are localized. | ||||
| <#Lines.JobTargetLocaleName> | The target language name. Note that the language names are localized. | ||||
| <#Lines.JobCompany> | If assigned, the company name of the supplier. | ||||
| <#Lines.JobPerson> | If assigned, the person first and last name of the supplier. | ||||
| <#Lines.JobCreationDate> | The date when the job was created in the system. This is a native Excel date. | ||||
| <#Lines.JobDeadline> | The job deadline, if any. This is a native Excel date. | ||||
| <#Lines.JobCompanyAssignDate> | The date when the job was assigned to a supplier. Empty if not assigned. | ||||
| <#Lines.JobPersonAssignDate> | The date when the job was assigned to a specific person at the supplier company. Empty if the job is not assigned to a supplier at all or not to a specific person. | ||||
| <#Lines.JobStartDate> | The date when the job status moves to In Progress. | ||||
| <#Lines.JobEndDate> | The date when the job status moves to Completed. | ||||
| <#Lines.JobDeadlineYM> | The job deadline formatted as "year-month" such as in 2016-10 or 2014-02. | ||||
| <#Lines.JobCreationDateYM> | The job creation date formatted as "year-month" such as in 2016-10 or 2014-02. | ||||
| <#Lines.JobStartDateYM> | The job in progress date formatted as "year-month" such as in 2016-10 or 2014-02. | ||||
| <#Lines.JobEndDateYM> | The job completion date formatted as "year-month" such as in 2016-10 or 2014-02. | ||||
| Job invoice | Contains details on the supplier invoice. With standard jobs this requires that an invoice was created for the job. With Codyt jobs this requires that the cost was assigned to the job (the invoice is optional). | ||||
| <#Lines.InvoiceReference> | The invoice reference. | ||||
| <#Lines.InvoiceStatus> | The localized status of the invoice. The status also indicates if the invoice document is still a quotation or already an "invoice". Note that cancelled invoices are not included in this report. | ||||
| <#Lines.InvoiceEffectiveDate> | The effective date of the invoice. he financial period to which an invoice is attributed. Assigned when an invoice status moves from quotation to "Draft invoice". | ||||
| <#Lines.InvoiceNo> | The accounting invoice number. Assigned when the invoice status us set to "Approved". Inside Wordbee you can configure if this number is automatically assigned and how it is formatted. | ||||
| <#Lines.ConvertToCurrency> | The currency to which the above amount is converted. Same as <#MasterCurrency> (see this field on how the currency is configured). Formatted as 3 letter ISO code. | ||||
| <#Lines.InvoiceChangeDate> | The last status change of the invoice. | ||||
| <#Lines.InvoiceDate> | The accounting date of the invoice. Assigned when the invoice status us set to "Approved". Inside Wordbee you can configure if this number is automatically assigned and how it is formatted. | ||||
| Job cost | Shows the total cost of the job. Standard jobs: If a Standard job has multiple documents then the cost is shown in the Excel line of the first document only. Codyt jobs: The cost information is taken from the costing saved with the job and not the invoice. If you edit the cost directly in the invoice (something you should not do anyway), you will not see the edits below. | ||||
| <#Lines.CostCurrency> | The currency code of the invoice, such as EUR, USD... Formatted as 3 letter ISO code. | ||||
| <#Lines.CostExVAT> | The total invoice amount excluding VAT. | ||||
| <#Lines.CostExVATConv> | The total ex VAT amount converted to your currency (<#MasterCurrency>). Formatted as 3 letter ISO code. | ||||
| <#Lines.CostExVATBase> | The total invoice amount (ex VAT) before application of discounts are applied. Discounts may be applied for pre-translations, repetitions or fuzzy matches. Discounts are shown in the invoice or cost calculation. | ||||
| <#Lines.CostExVATBaseConv> | Value of <#Lines.CostExVATBase> converted to your currency (<#MasterCurrency>). Formatted as 3 letter ISO code. | ||||
| <#Lines.DiscountExVAT> | The discount amount. Same as <#Lines.CostExVATBase> - <#Lines.CostExVAT>. | ||||
| <#Lines.DiscountExVATConv> | The discount amount in your currency. Same as <#Lines.CostExVATBaseConv> - <#Lines.CostExVATConv>. | ||||
| Custom Fields | You can include any of your job and project custom fields in your report: | ||||
<#Lines.JobCF1> ... <#Lines.JobCF20> | Job custom fields 1 to 20. As the platform administrator you can create up to 20 custom fields for orders. To find out the ID (1, 2, ... 20) of a specific custom field, edit the custom field in "Settings" > "Custom Fields" > "Job". The ID is shown at the bottom of the editing popup. Also read: Finding Custom Field ID | ||||
<#Lines.ProjectCF1> ... <#Lines.ProjectCF20> | Project custom fields 1 to 20. As the platform administrator you can create up to 20 custom fields for orders. To find out the ID (1, 2, ... 20) of a specific custom field, edit the custom field in "Settings" > "Custom Fields" > "Project". The ID is shown at the bottom of the editing popup. Also read: Finding Custom Field ID | ||||
| Client details | |||||
| <#Lines.ClientCompany> | The client company name. | ||||
| Word counts | The word count details for the document above. If the scope of the job is for a portion of the document only, then word counts are for that portion. Please note that word counts are optional and any of the below fields may be empty. | ||||
| <#Lines.DocumentCount> | Total documents in this job. For Codyt jobs this is always one. For Standard jobs this can be zero, 1 or more documents. | ||||
| <#Lines.WCSegments> | Total segments. | ||||
| <#Lines.WCWords> | Total words. | ||||
| <#Lines.WCCharacters> | Total characters. | ||||
| <#Lines.WCMinutes> | Total minutes worked. This optional value is filled in by the supplier or the project manager in the jobs page - it is not calculated by the system. | ||||
| <#Lines.WCPages> | Total pages. This optional value is filled in by the project manager in the jobs page - it is not calculated by the system. | ||||
| Advanced counters - Word based | |||||
| <#Lines.WCNoMatchWords> | Total words that were not leveraged. | ||||
| <#Lines.WCWordsExcluded> | Total number of words in the original text that are excluded from translation (do not require translation). | ||||
| <#Lines.WCWordsPretransFuzzy> | Total words of fuzzy (< 100%) pre-translations. | ||||
| <#Lines.WCWordsPretransIdentical> | TotalIsActive> | Indicates if the supplier is active. | |||
| <#Lines.ActiveTitle> | Indicates if the supplier is active, in string format. | ||||
<#Lines.CCF1>... <#Lines.CCF10> | The supplier company custom fields. As the platform administrator you can create up to 10 custom fields for companies. | ||||
| Service | Shows all fields relative to the supplier service for this line. | ||||
| <#Lines.LocaleSource> | The source language | ||||
| <#Lines.LocaleTarget> | The target language | ||||
| <#Lines.Task> | The task name. | ||||
| <#Lines.LocaleSourceCode> | The source language ISO code. | ||||
| <#Lines.LocaleTargetCode> | The target language ISO code. | ||||
| <#Lines.TaskCode> | The task code such as TR for translation or PROOF for proofreading. These codes can be viewed in Wordbee under Settings > Task categories. | ||||
| <#Lines.ServiceID> | The ID of the service. | ||||
| <#Lines.Enabled> | Indicates if service is enabled. | ||||
| <#Lines.BackupServiceID> | The service ID of the backup service. | ||||
| <#Lines.BackupCompanyName> | The company name of the backup company. | ||||
| <#Lines.BackupPriceListId> | The pricelist ID of the backup service. | ||||
| <#Lines.BackupPriceList> | The pricelist name of the backup service. | ||||
| Price | Shows all fields relative to the supplier service prices for this line. | ||||
| <#Lines.PriceListId> | The pricelist ID for the service. | ||||
| <#Lines.ParentPriceListId> | The parent pricelist ID for the service. | ||||
| <#Lines.PriceListCode> | The pricelist code for the service. | ||||
| <#Lines.UnitCode> | The price unit code for the service. | ||||
| <#Lines.Units> | The price units for the service. | ||||
| <#Lines.ProductCode> | The product code for the service. | ||||
| <#Lines.Amount> | The price amount for the service. | ||||
| <#Lines.Currency> | The price currency. | ||||
| Discounts | Shows all fields relative to the supplier service pre-translation discounts for this line. | ||||
| <#Lines.DCMode> | The discount mode in string format. | ||||
| <#Lines.DiscountMT> | The Machine Translation (MT) discount in negative percent form. | ||||
<#Lines.DiscountPT100> | The discount for total words that are pre-translated at 100% or above in percentage form. | ||||
| <#Lines. | WCWordsPretransIdenticalCtx>TotalDiscountPT100Prev> | The discount for total words that | wereare pre-translated at | 110%100%( | perfectidentical pre-translations) from memories or termbases, in percentage form. |
| <#Lines. | WCWordsPretransIdenticalPrevCtx>Total words that were pre-translated at 110% (DiscountPT110> | The discount for total words of perfect pre-translations | ) from a previous document version(110%) in percentage form. | ||
| <#Lines. | WCWordsPretransIdenticalPrev>TotalDiscountPT110Prev> | The discount for total words that were pre-translated at | 100%110% ( | identicalperfect pre-translations) from | memories or termbasesa previous document version in percentage form. |
| <#Lines. | WCWordsPretransIdenticalMT>Total words that were machine translated. | ||||
| <#Lines.WCPretrans110> | Total words of perfect pre-translations (110%). This is equivalent to the sum of <#Lines.WCWordsPretransIdenticalCtx> and <#Lines.WCWordsPretransIdenticalPrevCtx>. | ||||
| <#Lines.WCPretrans100> | Total words of identical pre-translations (100%).
| ||||
| <#Lines.WCTransWords> | Total number of words in the translated texts. This value can be calculated by the system with a button press once translations are done. | ||||
<#Lines.WCFuzzy1> | Total words of fuzzy matches or repetitions without pre-translation. This is the 1st interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCFuzzy2> | Total words of fuzzy matches or repetitions without pre-translation. This is the 2nd interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCFuzzy3> | Total words of fuzzy matches or repetitions without pre-translation. This is the 3rd interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCFuzzy4> | Total words of fuzzy matches or repetitions without pre-translation. This is the 4th interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCFuzzy5> | Total words of fuzzy matches or repetitions without pre-translation. This is the 5th interval among 5 that can be configured in the word count profile. | ||||
| Advanced counters - Characters based | |||||
| <#Lines.WCCharsNoMatch> | Total characters that were not leveraged. | ||||
| <#Lines.WCCharsExcluded> | Total number of characters in the original text that are excluded from translation (do not require translation). | ||||
| <#Lines.WCCharsPretransFuzzy> | Total characters of fuzzy (< 100%) pre-translations. | ||||
| <#Lines.WCCharsPretransIdentical> | Total characters that are pre-translated at 100% or above. | ||||
| <#Lines.WCCharsPretransIdenticalCtx> | Total characters that were pre-translated at 110% (perfect pre-translations) from memories or termbases. | ||||
| <#Lines.WCCharsPretransIdenticalPrevCtx> | Total characters that were pre-translated at 110% (perfect pre-translations) from a previous document version. | ||||
| <#Lines.WCCharsPretransIdenticalPrev> | Total characters that were pre-translated at 100% (identical pre-translations) from memories or termbases. | ||||
| <#Lines.WCCharsPretransIdenticalMT> | Total characters that were machine translated. | ||||
| <#Lines.WCCharsPretrans110> | Total characters of perfect pre-translations (110%). This is equivalent to the sum of <#Lines.WCCharsPretransIdenticalCtx> and <#Lines.WCCharsPretransIdenticalPrevCtx>. | ||||
| <#Lines.WCCharsPretrans100> | Total characters of identical pre-translations (100%).
| ||||
| <#Lines.WCTransCharacters> | Total number of characters in the translated texts. This value can be calculated by the system with a button press once translations are done. | ||||
<#Lines.WCCharsFuzzy1> | Total characters of fuzzy matches or repetitions without pre-translation. This is the 1st interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCCharsFuzzy2> | Total characters of fuzzy matches or repetitions without pre-translation. This is the 2nd interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCCharsFuzzy3> | Total characters of fuzzy matches or repetitions without pre-translation. This is the 3rd interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCCharsFuzzy4> | Total characters of fuzzy matches or repetitions without pre-translation. This is the 4rth interval among 5 that can be configured in the word count profile. | ||||
| <#Lines.WCCharsFuzzy5> | Total characters of fuzzy matches or repetitions without pre-translation. This is the 5th interval among 5 that can be configured in the word count profileDiscountPTFuzzy> | The discount for total words of fuzzy (< 100%) pre-translations in percentage form. | |||
<#Lines.Interval1>... <#Lines.Interval5> | The discount intervals in string form. The report prints intervals from 1 to 5. | ||||
<#Lines.Discount1>... <#Lines.Discount5> | The discount in each interval in negative percent form. | ||||
| Service Details | Shows all fields relative to the supplier service details for this line. | ||||
| <#Lines.Rating> | The rating for the service. | ||||
| <#Lines.LeadTime> | The lead time for the service in numeric format. | ||||
| <#Lines.LeadTimeLabel> | The lead time for the service in string format. | ||||
| <#Lines.Capacity> | The capacity of the service.It describes delay in units per day. | ||||
| <#Lines.CapacityLabel> | The capacity label in string format. It also contains lead time information as it is displayed in the UI. (e.g: 2d1h+2 ) | ||||
| <#Lines.Comments> | The comments for the service. |