This report prints all external supplier services with full price details, discount options and other properties.
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.
The placeholders of the row must be placed within the Excel table range named "___Lines___" (3 leading and trailing underscore characters). Click here for more details on table ranges.
A report prints the raw data in rows. Each row, you can use any of the following placeholders:
|
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 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.DiscountPT100Prev> |
The discount 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 words that were pre-translated at 110% (perfect pre-translations) from a previous document version in percentage form. |
|
<#Lines.DiscountPTFuzzy> |
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. |