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 |
|---|---|
| <#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 supplier service. In other words, all information of a specific supplier service will be contained in one single row.
...
| Placeholder name | Description | ||
|---|---|---|---|
| Supplier | Shows all the supplier details for this line. | ||
| <#Lines.Company> | The supplier company. | ||
| <#Lines.Person> | The supplier person. | ||
| <#Lines.PersonId> | The supplier person ID. | ||
| <#Lines.PersonRole> | The supplier person role. | ||
| <#Lines.IsActive> | 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 Back up service IDservice 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 for total words that are pre-translated at 100% or above in percentage form. | ||
| <#Lines.DiscountPT100Prev> | The discount for for total words that are pre-translated at 100%(identical pre-translations) from memories or termbases, in percentage form. | ||
| <#Lines.DiscountPT110> | The discount for total words of perfect pre-translations (110%) in percentage form. | ||
| <#Lines.DiscountPT110Prev> | The discount for Total for total words that were pre-translated at 110% (perfect pre-translations) from a previous document version in percentage form. | <#Lines.DiscountPT110Prev> | The discount in percent form. |
| <#Lines.DiscountPTFuzzy> | The discount for Total total words of fuzzy (< 100%) pre-translations in percentage form. | ||
<#Lines.Interval1>... <#Lines.Interval5> | The discount intervals in string form. the 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. | ||
| 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.Rating> | The rating for the service. | |
| <#Lines. | WCWordsPretransFuzzy>Total words of fuzzy (< 100%) pre-translations. | ||
| <#Lines.WCWordsPretransIdentical> | Total words that are pre-translated at 100% or above. | ||
| <#Lines.WCWordsPretransIdenticalCtx> | Total words that were pre-translated at 110% (perfect pre-translations) from memories or termbases. | ||
| <#Lines.WCWordsPretransIdenticalPrevCtx> | Total words that were pre-translated at 110% (perfect pre-translations) from a previous document version. | ||
| <#Lines.WCWordsPretransIdenticalPrev> | Total words that were pre-translated at 100% (identical pre-translations) from memories or termbases. | ||
| <#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 profileLeadTime> | 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. |