Table of Contents
Before Beginning
This section contains information that is important to know before creating a reference data record.
Users can only create Media Types and cost categories in OneStrata if the following conditions are met:
- The master data source of the OneStrata enterprise is internal.
- The user has the appropriate user role permissions.
If the master data source of the enterprise is external, any new Media Types or cost categories must be created in the linked external system.
Once a reference data record is created, certain values on the record cannot be changed. These values depend on the specific type of reference data record.
Once created, the following types of reference data records cannot be deactivated or archived:
- Tax categories and Alternate Tax Options
- Media Types
Create a Fee Record
There are two ways of creating a Fee record:
- By copying and modifying an existing record.
- By entering all information manually.
To create a Fee record by entering all information manually, do the following:
- Go to the Admin > Reference Data > Fees & Tech Rates tab.
- Click the Create Fee button to open the Create Fee widget.
- In the Create Fee widget, enter the following information:
Section Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action General Name Enter the name of the fee. Fee Type Select the fee type:
Editable in Schedule
The Editable in Schedule toggle is only available for Central fees.
For a Central fee, turn the Editable in Schedule toggle on or off:
- If the Editable in Schedule toggle is on: Any Central fee lines created from the Fee record can be edited within the Schedule grid.
- The Editable in Schedule toggle is off: Any Central fee lines created from the Fee record cannot be edited within the Schedule grid.
Media Type Select the Media Type of the fee.
The fee can only be applied to campaigns that have the same Media Type.
Valid From Select the start date of the Fee record's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Fee record's validity period.
Applicable To
Apply at Enterprise Level
or
Agency
Business Unit
Select whether or not the fee exists at the enterprise level:
- Apply at Enterprise Level: The fee can be applied to Cost Lines in any campaign.
- Agency and Business Unit: The fee can only be applied to Cost Lines in campaigns for the specified Agency and Business Unit.
Vendor Contract
Supplier Type
Select whether the Supplier of the fee is a media or non-media Supplier.
Vendor Contract
Payee
Order Partner
Supplier
Currency
Select the Payee, Order Partner, Supplier, and currency of the fee.
The vendor options are determined by the previously selected Supplier Type value and by existing Contract records:
- If Supplier Type is Media, the vendor options are restricted to vendors linked to a media Supplier through a Contract.
- If Supplier Type is Non-Media, the vendor options are restricted to vendors linked to a non-media Supplier through a Contract.
- For Payee, select the Payee of the fee.
- For Order Partner, select the Order Partner of the fee.
- For Supplier, select the Supplier of the fee.
- For Currency, select the currency of the fee.
Vendor Rate Details Cost Type Select the cost type of the fee (the amount that the fee is calculated on).
The cost type options depend on the previously selected Fee Type value:
- For Assigned fees, the cost type options are:
- Vendor Net Cost
- If the Allocated workflow is enabled, Allocated Amount
- For Central fees, the cost type options are:
Rate Type Select the rate type of the fee (how the fee is calculated).
The rate type options depend on the previously selected Fee Type value:
- For Assigned fees, the rate type options are:
- For Central fees, the rate type options are:
Cost Category
Select the cost category of the fee.
The cost category options depend on the previously selected Supplier and Media Type values.
Rate Enter the vendor "rate" of the fee.
Depending on the rate type of the Fee Record, this value is used to calculate the vendor net cost of the fee.
For more information, see Fee Record Rate Types.
Optional
Buffer
The Buffer field is only available for Assigned fees with a volume-based rate type.
Optional: For an Assigned Fee record with a volume-based rate type, enter the buffer percentage.
The buffer percentage is used when calculating the cost of the Assigned fee. For more information, see Rate Type Cost Formulas.
Default Technology Assignment
The Default Technology Assignment section is only available for Assigned fees.
If an Assigned Fee record has a default Tech Assignment, when the fee is applied to a Placement line, the default values are automatically added to the Technology Assignments column of that Placement.
Optional
Provider
Optional: Select the default provider of the Tech Assignment.
Optional
Service Type
Optional: Select the default service type of the Tech Assignment. Optional
Default External Placement
Optional: Select the default external placement type of the Tech Assignment. Client Rate Details
Client
Commission
Client Net Rate
Valid From
Valid To
Position
A Fee record must have at least one client rate.
To add a client rate, do the following:
- For Client, click Add Value. Then, select the level of the client rate by clicking All Clients or entering a specific Client/Client Group.
- For Commission, select the commission structure of the client rate.
- Optional: For Client Net Rate, enter the fee rate of the client rate.
Fee margins are a gated feature and not enabled by default.
If this feature is not enabled, margin fees cannot be created: the client fee rate must be the same as the vendor fee rate (the Client Net Rate value must match the Rate / Vendor Net Rate value).
- Optional: For Valid From, enter the start date of the client rate's validity period.
- Optional: For Valid To, enter the end date of the client rate's validity period.
- Optional: For Position, change the position number of the client rate.
The position number of a client rate does not impact how the rate is applied, and is only used to display client rates in the desired order.
- If the Editable in Schedule toggle is on: Any Central fee lines created from the Fee record can be edited within the Schedule grid.
- Click Create or Create and Create Another:
- Create: Save the record, close the Create Fee widget, and return to the Fees & Tech Rate tab.
- Create and Create Another: Save and copy the newly created Fee record. The Create Fee widget remains open, and fields in the copied Fee record can be edited as desired.
- Create: Save the record, close the Create Fee widget, and return to the Fees & Tech Rate tab.
Create a Tax Record
Create a Tax Category
To create a tax category, do the following:
- Go to the Admin > Reference Data > Taxes tab.
- Click Tax Category to open the Tax Category page.
- Click +Add Category.
- Enter the following information:
Field Name
The value of any fields with a red background cannot be changed after the tax category is created.
Description Name Enter the name of the tax category. Applies To Select whether the tax category is a client tax category or vendor tax category. External ID Enter an external identifier for the tax category. - Click Save.
Create an Alternate Tax Option
To create an Alternate Tax Option, do the following:
- Go to the Admin > Reference Data > Taxes tab.
- Click Alternate Tax Option to open the Alternate Tax Option page.
- Click +Add Alt-Tax Option.
- Enter the following information:
Field Name Description Name Enter the name of the Alternate Tax Option. - Click Save.
Create a Client Tax Record
To create a Client Tax record, do the following:
- Go to the Admin > Reference Data > Taxes tab.
- Click Client Taxes to open the Client Taxes page.
- Click Create Record to open the Create Client Tax widget.
- In the Create Client Tax widget, enter the following information:
Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action Read-only
Structure Type
The value of the Structure Type field is Client and cannot be changed. Tax Code Enter the name of the Client Tax record. Client Tax Category Select the client tax category of the Client Tax record.
A Client Tax record can only be applied to a Cost Line if the Cost Line is in a campaign for a Client that belongs to the same client tax category.
Optional
Vendor Tax Category
Optional: Select the vendor tax category of the Client Tax record.
If a Client Tax record also belongs to a vendor tax category, the Client Tax record can only be applied to a Cost Line if:
- The Cost Line is in a campaign for a Client that belongs to the same client tax category; and
- The Payee of the Cost Line belongs to the same vendor tax category.
Optional
Alternate Tax Option
Optional: Add an Alternate Tax Option to the Client Tax record. Tax Type 1 Select the type of tax defined by the Client Tax record:
- CCF: The Tax record represents a CCF (Co-Operative Compliance Framework) tax.
- GrossUp: The Tax record represents an additional cost.
- GST: The Tax record represents a GST (goods and services tax).
- HST: The Tax record represents a HST (harmonized sales tax).
- Local: The Tax record represents a local sales tax.
- PST: The Tax record represents a PST (provincial sales tax).
- SST: The Tax record represents an SST (sales tax and service tax).
- State: The Tax record represents a state sales tax.
- Surtax: The Tax record represents an additional tax.
- VAT: The Tax record represents a VAT (value-added tax).
Tax Rate 1 Enter the client tax rate. Tax Applies to 1 Select the cost type that the client tax rate applies to:
- Vendor Gross
- Vendor Net
- Client Gross
- Client Net
- Client Gross + Commission
- Client Net + Commission
- Commission Only
Valid From Select the start date of the Client Tax record's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Client Tax record's validity period. Optional
Set as default
Optional: Set the Tax record as the default applied tax. - Click Create.
Create a Vendor Tax Record
To create a Vendor Tax record, do the following:
- Go to the Admin > Reference Data > Taxes tab.
- Click Vendor Taxes to open the Vendor Taxes page.
- Click Create Record to open the Create Vendor Tax widget.
- In the Create Client Tax widget, enter the following information:
Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action Read-only
Structure Type
The value of the Structure Type field is Vendor and cannot be changed. Tax Code Enter the name of the Vendor Tax record. Vendor Tax Category
Select the vendor tax category of the Vendor Tax record.
A Vendor Tax record can only be applied to Cost Lines with a Payee that belongs to the same vendor tax category.
Optional
Alternate Tax Option
Optional: Add an Alternate Tax Option to the Vendor Tax record. Tax Type 1 Select the type of tax defined by the Vendor Tax record:
- CCF: The Tax record represents a CCF (Co-Operative Compliance Framework) tax.
- GrossUp: The Tax record represents an additional cost.
- GST: The Tax record represents a GST (goods and services tax).
- HST: The Tax record represents a HST (harmonized sales tax).
- Local: The Tax record represents a local sales tax.
- PST: The Tax record represents a PST (provincial sales tax).
- SST: The Tax record represents an SST (sales tax and service tax).
- State: The Tax record represents a state sales tax.
- Surtax: The Tax record represents an additional tax.
- VAT: The Tax record represents a VAT (value-added tax).
Tax Rate 1 Enter the vendor tax rate. Tax Applies to 1 Select the cost type that the vendor tax rate applies to:
- Vendor Gross
- Vendor Net
Valid From Select the start date of the Vendor Tax record's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Vendor Tax record's validity period.
Optional
Set as default
Optional: Set the Tax record as the default applied tax.
- Click Create.
Create a Commission Record
To create a Commission record, do the following:
- Go to the Admin > Reference Data > Commission tab.
- Click Create Record to open the Create Commission widget.
- In the Create Commission widget, enter the following information:
Section Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action General Name Enter the name of the commission. Valid From Select the start date of the Commission record's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Commission record's validity period.
Commission Percent
Client Commission Percentage
Enter the percentage of the commission.
Commission Basis Select the amount that the commission is calculated on:
- Client Net Media Cost
- Client Gross Media Cost
Agency Entities Agency Add an Agency to the Commission record.
The commission can only be applied to Cost Lines in campaigns for Clients in the specified Agency.
Optional
Business Unit
Optional: Add a Business Unit to the Commission record.
The commission can only be applied to Cost Lines in campaigns for Clients in the specified Business Unit.
Optional
Client Group
Optional: Add a Client Group to the Commission record.
The commission can only be applied to Cost Lines in campaigns for Clients in the specified Client Group.
Optional
Client
Optional: Add a Client to the Commission record.
The commission can only be applied to Cost Lines in campaigns for the specified Client.
Optional
Product
Optional: Add a Product to the Commission record.
The commission can only be applied to Cost Lines in campaigns for the specified Product.
Media Type & Cost Category Optional
Media Type
Optional: Add a Media Type to the commission.
The commission can only be applied to Cost Lines in campaigns that have the same Media Type.
Optional
Cost Categories
External ID
Code
Supplier
Optional: Add a cost category to the commission.
The commission can only be applied to Cost Lines that have the same cost category.
Supplier Default Commission Optional: Set the Commission record as the default applied commission.
- Click Create or Create and Create Another:
- Create: Save the record, close the Create Commission widget, and return to the Commission tab.
- Create and Create Another: Save and copy the newly created record. The Create Commission widget remains open, and fields in the copied Commission record can be edited as desired.
- Create: Save the record, close the Create Commission widget, and return to the Commission tab.
Create an Exchange Rate Record
To create an Exchange Rate record, do the following:
- Go to the Admin > Reference Data > Exchange Rate tab.
- Click Create Record to open the Create Exchange Rate widget.
- In the Create Exchange Rate widget, enter the following information:
Section Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action General Apply at Enterprise Level
or
Agency
Business Unit
Client Group or Client
Select whether or not the exchange rate exists at the enterprise level:
- Apply at Enterprise Level: The exchange rate can be applied to any campaign.
- Agency and Business Unit and Client Group or Client: The exchange rate can only be applied to campaigns for the specified Agency, Business Unit, or Client Group/Client.
Exchange Rate Details Valid From Select the start date of the Exchange Rate record's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Exchange Rate record's validity period.
Optional
Import .CSV
Optional: Import a CSV file that contains one or more exchange rates.
The CSV should have the following header:
Currency From,Currency To,RateExport
Not applicable when creating an Exchange Rate record. Currency From
Currency To
Rate
To manually enter an exchange rate, do the following:
- Click Add Value.
- Select the currency to exchange from. This will automatically populate the Currency From field.
- For Currency To, click to open the currency dropdown. Select the currency to exchange to.
- For Rate, enter the exchange rate.
- Apply at Enterprise Level: The exchange rate can be applied to any campaign.
- Click Create.
Create a Terms & Conditions Record
To create a Terms & Conditions record, do the following:
- Go to the Admin > Reference Data > Terms & Conditions tab.
- Click Create Record to open the Create Terms & Conditions widget.
- In the Create Terms & Conditions widget, enter the following information:
Section Field Name
The value of any fields with a red background cannot be changed after the record is created.
Action General Terms and Conditions Name
Enter the name of the Terms & Conditions record.
Terms and Conditions Type
Select the type of the Terms & Conditions record:
- Advertiser View: The set of terms & conditions is included when viewing or exporting the Advertiser View page.
- Order: The set of terms & conditions is included when sending orders.
Media Type
Select the Media Type of the Terms & Conditions record.
The set of terms & conditions only applies to campaigns that have the same Media Type.
Apply at Enterprise Level
or
Agency
Business Unit
Client Group or Client
Order Partner
Select whether or not the set of terms & conditions exists at the enterprise level:
- Apply at Enterprise Level: The set of terms & conditions can be applied to any campaign.
- Agency and Business Unit and Client Group or Client: The set of terms & conditions can only be applied to campaigns for the specified Agency, Business Unit, Client Group/Client, or Order Partner.
Terms & Conditions Attach File
or
Manual Entry
Attach a file that contains the terms & conditions or manually enter the terms & conditions.
- Click Create.
Create a Media Type
To create a Media Type, do the following:
- Go to the Admin > Reference Data > Media tab.
- Click +Add Media Type.
- Enter the following information:
Field Name Description Media Type Select Digital. UI Name Enter the name of the Media Type. Finance Code Enter an identifying code for the Media Type. Valid From Select the start date of the Media Type's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the Media Type's validity period.
- Click Save.
Create a Cost Category
To create a cost category, do the following:
- Go to the Admin > Reference Data > Cost Categories tab.
- Click Create Cost Category to open the Create Cost Category widget.
- In the Create Cost Category widget, enter the following information:
Section Field Name
The value of any fields with a red background cannot be changed after the cost category is created.
Action Cost Categories Name
Enter the name of the cost category.
Code
Enter an identifying code for the cost category.
Group
For future use.
External ID
Enter an external identifier for the cost category.
Valid From
Select the start date of the cost category's validity period. By default, the valid-from date is the date of the record's creation.
For more information, see Validity Dates.
Optional
Valid To
Optional: Select the end date of the cost category's validity period.
Access Restrictions All entities within <Enterprise Name>
or
Select specific entities
Select whether or not the cost category exists at the enterprise level:
- All entities within <Enterprise Name>: The cost category can be assigned to Cost Lines in any campaign.
- Select specific entities: The cost category can only be applied to Cost Lines in campaigns for the specified Agency/Agencies or Business Unit(s).
Media
Add one or more Media Types to the cost category.
The cost category can only be applied to Cost Lines in campaigns that have the same Media Type.
Regulated
or
Unregulated
The Regulated and Unregulated checkboxes are only available if the regulated workflow is enabled.
Select whether the cost category is regulated or unregulated.
For more information, see Regulated Workflow.
Channel Group
For future use.
- All entities within <Enterprise Name>: The cost category can be assigned to Cost Lines in any campaign.
- Click Create.