Use * syntax for faster search

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:

To create a Fee record by entering all information manually, do the following:

  1. Go to the Admin > Reference Data > Fees & Tech Rates tab.

  2. Click the Create Fee button to open the Create Fee widget.

  3. 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
    GeneralNameEnter 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.

    1. For Payee, select the Payee of the fee.
    2. For Order Partner, select the Order Partner of the fee.
    3. For Supplier, select the Supplier of the fee.
    4. For Currency, select the currency of the fee.
    Vendor Rate DetailsCost 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:

    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:

    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:

    1. For Client, click Add Value. Then, select the level of the client rate by clicking All Clients or entering a specific Client/Client Group.

    2. For Commission, select the commission structure of the client rate.

    3. 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).


    4. Optional: For Valid From, enter the start date of the client rate's validity period.

    5. Optional: For Valid To, enter the end date of the client rate's validity period.

    6. 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.



  4. 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 a Tax Record

Create a Tax Category

To create a tax category, do the following:

  1. Go to the Admin > Reference Data > Taxes tab.

  2. Click Tax Category to open the Tax Category page.

  3. Click +Add Category.

  4. 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
    NameEnter the name of the tax category.
    Applies ToSelect whether the tax category is a client tax category or vendor tax category.
    External IDEnter an external identifier for the tax category.


  5. Click Save.

Create an Alternate Tax Option

To create an Alternate Tax Option, do the following:

  1. Go to the Admin > Reference Data > Taxes tab.

  2. Click Alternate Tax Option to open the Alternate Tax Option page.

  3. Click +Add Alt-Tax Option.

  4. Enter the following information:
    Field NameDescription
    NameEnter the name of the Alternate Tax Option.


  5. Click Save.

Create a Client Tax Record

To create a Client Tax record, do the following:

  1. Go to the Admin > Reference Data > Taxes tab.

  2. Click Client Taxes to open the Client Taxes page.

  3. Click Create Record to open the Create Client Tax widget.

  4. 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 CodeEnter 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 1Enter 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.


  5. Click Create.

Create a Vendor Tax Record

To create a Vendor Tax record, do the following:

  1. Go to the Admin > Reference Data > Taxes tab.

  2. Click Vendor Taxes to open the Vendor Taxes page.

  3. Click Create Record to open the Create Vendor Tax widget.

  4. 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 CodeEnter 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 1Enter 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.



  5. Click Create.

Create a Commission Record

To create a Commission record, do the following:

  1. Go to the Admin > Reference Data > Commission tab.

  2. Click Create Record to open the Create Commission widget.

  3. 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
    GeneralNameEnter 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 EntitiesAgency

    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.

    SupplierDefault Commission

    Optional: Set the Commission record as the default applied commission.



  4. 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 an Exchange Rate Record

To create an Exchange Rate record, do the following:

  1. Go to the Admin > Reference Data > Exchange Rate tab.

  2. Click Create Record to open the Create Exchange Rate widget.

  3. 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 DetailsValid 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,Rate 

    Export

    Not applicable when creating an Exchange Rate record.

    Currency From

    Currency To

    Rate

    To manually enter an exchange rate, do the following:

    1. Click Add Value.
    2. Select the currency to exchange from. This will automatically populate the Currency From field.
    3. For Currency To, click to open the currency dropdown. Select the currency to exchange to.
    4. For Rate, enter the exchange rate.


  4. Click Create.

Create a Terms & Conditions Record

To create a Terms & Conditions record, do the following:

  1. Go to the Admin > Reference Data > Terms & Conditions tab.

  2. Click Create Record to open the Create Terms & Conditions widget.

  3. 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.



  4. Click Create.

Create a Media Type

To create a Media Type, do the following:

  1. Go to the Admin > Reference Data > Media tab.

  2. Click +Add Media Type.

  3. Enter the following information:
    Field NameDescription
    Media TypeSelect Digital.
    UI NameEnter the name of the Media Type.
    Finance CodeEnter 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.



  4. Click Save.

Create a Cost Category

To create a cost category, do the following:

  1. Go to the Admin > Reference Data > Cost Categories tab.

  2. Click Create Cost Category to open the Create Cost Category widget.

  3. 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.



  4. Click Create.
  • No labels
Provide feedback on this article
You are evaluating Refined.
Back to Top