OneStrata Analytics Data Dictionary

The type of the external ad server placement.

Possible values:

The possible ad server placement types depend on the Ad Server provider and service type.

For a linked Ad Placement, the external integration provider's identifier for the ad server placement linked to the Ad Placement.

Note:

For example, if the Ad Placement is linked to a Campaign Manager 360 (CM360) placement, this value is the CM360 identifier of the CM360 placement.

Whether or not the Ad Placement is linked to an ad server placement.

The status of the link between this Ad Placement and an ad server placement.

Possible values:

• Error: A link between the Ad Placement and an ad server placement exists, but some error occurred when creating or updating the ad server placement.
• Sent: A link between the Ad Placement and an ad server placement exists. The ad server placement was succcessfully created, linked, or updated.
• Archived: A link between the Ad Placement and an ad server placement existed, but both the Ad Placement and ad server placement were canceled.
• None: N/A

For a linked Ad Placement, the provider type of the external integration provider.

Possible values:

• Ad Server

For a linked Ad Placement, the external integration provider of the Ad Placement.

Possible values:

• Campaign Manager 360
• Amazon Ad Server
• Flashtalking

For a linked Ad Placement, the type of external entity linked to the Ad Placement.

Possible values:

• Placement: The Ad Placement is linked to an ad server placement.

The OneStrata-generated identifier of the Ad Placement.

The name of the Ad Placement.

The name of the Ad Placement Package.

The OneStrata-generated identifier of the Tech Assignment.

Whether or not the provider of this Tech Assignment is the payable source.

Note:

If an Ad Placement has multiple Tech Assignments, the payable source determines which provider's delivery data is displayed in the 3rd Party columns on the Actualization tab.

The service type of the Tech Assignment, as an ID value.

Possible values:

• 0: None
• 1: AdServing
• 2: Tracking
• 3: ContentVerification

The format dimensions of the Ad Unit.

Note:

• If the Ad Unit format is a display type like Banner, this value is in pixel dimensions.
• If the Ad Unit format is a video type like _Pre-Roll :30, this value is in seconds.

The dimension type of the Ad Unit, as an ID value.

Possible values:

• 0: NA
• 1: Display
• 2: Video
• 3: Audio

The format of the Ad Unit. For example, Banner or Pre-Roll :30.

A code or phrase that represents the format of this Ad Unit, typically used for billing or reporting.

The OneStrata-generated identifier of the Ad Unit.

The cost distribution setting of the Media Line, as an ID value.

Possible values:

• 0: ProRata
• 1: Even
• 2: Custom

The end date of the Media Line, in yyyy-MM-dd format.

The format dimensions of the Media Line.

Note:

• If the Media Line format is a display type like Banner, this value is in pixel dimensions.
• If the Media Line format is a video type like _Pre-Roll :30, this value is in seconds.

The dimension type of the Media Line, as an ID value.

Possible values:

• 0: NA
• 1: Display
• 2: Video
• 3: Audio

The format of the Media Line. For example, Banner or Pre-Roll :30.

A code or phrase that represents the format of this Media Line, typically used for billing or reporting.

The grouping structure of the Media Line, as an ID value.

Possible values:

• 0: The Media Line is a standalone or secondary Placement.
• 1: The Media Line is a secondary Media Package or child Placement.

The OneStrata-generated identifier of the Media Line.

The name of the Media Line.

The (primary) rate type of the Media Line, as an ID value.

Possible values:

For a list of possible rate types, see Rate Type Reference.

The start date of the Media Line, in yyyy-MM-dd format.

The name of the Ad Unit.

A code or phrase that represents the Agency, typically used for billing or reporting.

The date that the Agency record was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the Agency.

Whether or not the Agency record is active.

The date that the Agency record was last modified, in yyyy-MM-dd format.

The localized name of the Agency.

A URL to a page or file that hosts the Agency's logo.

The name of the Agency.

The legal name of the Agency.

The OneStrata identifier of the parent agency of this Agency (the Agency that this Agency belongs to).

The default payment terms of the Agency.

A shortened or alternate version of the Agency's name, typically used for fields with character length limits.

The start date of the Agency record's validity period, in yyyy-MM-dd format.

Note:

An Agency can only be assigned to campaigns that start and end within the Agency record's validity period.

The end date of the Agency record's validity period, in yyyy-MM-dd format.

Note:

An Agency can only be assigned to campaigns that start and end within the Agency record's validity period.

The actualization status of the billing period.

Possible values:

• NotActualized: The billing period is not actualized in OneStrata
• Actualized: The billing period is actualized in OneStrata.

The end date of the billing period, in yyyy-MM-dd format.

The identifier of the billing period in an external, non-OneStrata system.

The OneStrata-generated identifier of the billing period.

The invoice lock status of the billing period.

Possible values:

• Unlock: The billing period is not locked.
• PartialLock: N/A
• Lock: The billing period is hard locked.

The invoice status of the billing period.

Possible values:

• NotInvoiced: The external finance system does not have an invoice record reconciled against the billing period.
• Matched: The external finance system has an invoice matched against the billing period.
• Cleared: The external finance system has cleared an invoice for payment against the billing period.

The number of days in the billing period with media activity.

The start date of the billing period, in yyyy-MM-dd format.

The billing period month, as a date number from 1 (January) to 12 (December).

The full name of the billing period month.

The quarter that the billing period falls into, as a number from 1 to 4.

The quarter and year that the billing period falls into, in "QX yyyy" format.

The year that the billing period falls into, in yyyy format.

The status of the billing period.

Possible values:

• Active: The billing period is active.
• Cancelled: The billing period is canceled.

A code or phrase that represents the Business Unit, typically used for billing or reporting.

The date that the Business Unit record was created, in yyyy-MM-dd format.

The identifier of the Business Unit in an external, non-OneStrata system.

The OneStrata-generated identifier of the Business Unit.

Whether or not the Business Unit record is active.

The date that the Business Unit record was last modified, in yyyy-MM-dd format.

The legal name of the Business Unit.

The localized name of the Business Unit.

A URL to a page or file that hosts the Business Unit's logo.

The name of the Business Unit.

The legal name of the Business Unit.

The default payment terms of the Business Unit.

A shortened or alternate version of the Business Unit's name, typically used for fields with character length limits.

The start date of the Business Unit record's validity period, in yyyy-MM-dd format.

Note:

A Business Unit can only be assigned to campaigns that start and end within the Business Unit record's validity period.

The end date of the Business Unit record's validity period, in yyyy-MM-dd format.

Note:

A Business Unit can only be assigned to campaigns that start and end within the Business Unit record's validity period.

The Advertiser Approval status of the campaign schedule.

Possible values:

• NotRequired: The schedule does not require advertiser approval.
• Required: The schedule requires advertiser approval, but the advertiser has not been requested to approve the schedule yet.
• PendingApproval: The advertiser was requested to approved the schedule, but has not responded yet.
• Approved: The schedule was approved by the advertiser.
• Declined: The schedule was rejected by the advertiser.

The Agency Approval status of the campaign schedule.

Possible values:

• NotRequired: The schedule does not require agency approval.
• Required: The schedule requires agency approval, but the agency has not been requested to approve the schedule yet.
• PendingApproval: The agency was requested to approved the schedule, but has not responded yet.
• Approved: The schedule was approved by the agency.
• Declined: The schedule was rejected by the agency.

The monetary budget of the campaign.

The currency of the campaign budget, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The cost type of the campaign budget.

Possible values:

• ClientGross: The amount of the campaign budget refers to the Client Gross Cost.
• ClientNet: The amount of the campaign budget refers to the Client Net Cost.
• ClientTotal: The amount of the campaign budget refers to the Client Total Cost.
• ClientTotalWithTax: The amount of the campaign budget refers to the Client Total With Tax Cost.

The first and last name of the user who created this campaign.

The date that the campaign was created, in yyyy-MM-dd format.

The end date of the campaign, in yyyy-MM-dd format.

A description of the campaign goals.

For future use.

The OneStrata-generated identifier of the Campaign Group.

The name of the Campaign Group.

The OneStrata-generated identifier of the campaign.

The first and last name of the user who last modified this campaign.

The date that the campaign was last modified, in yyyy-MM-dd format.

The name of the campaign.

The first and last name of the user who owns this campaign. By default, the campaign owner is the user who created the campagn.

The primary cost type of the campaign. This value is determined by the cost model of the campaign.

Possible values:

• VendorGross
• VendorNet

The start date of the campaign, in yyyy-MM-dd format.

The status of the campaign.

Possible values:

• Active: The status of the campaign in the UI is Active or Archived.
• Cancelled: The status of the campaign in the UI is Manually Archived or Cancelled - Archived.

For future use.

A code or phrase that represents the Client, typically used for billing or reporting.

The date that the Client record was created, in yyyy-MM-dd format.

The currency that the client uses, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

A code or phrase that represents the ERP (enterprise resource planning) system of this Client, typically used for billing or reporting.

The identifier of the Client in an external, non-OneStrata system.

A code or phrase that represents the Client Group, typically used for billing or reporting.

The date that the Client Group record was created, in yyyy-MM-dd format.

The identifier of the Client Group in an external, non-OneStrata system.

The OneStrata-generated identifier of the Client Group.

The industry of the Client Group.

Whether or not the Client Group record is active.

The date that the Client Group record was last modified, in yyyy-MM-dd format.

The localized name of the Client Group.

A URL to a page or file that hosts the Client Group's logo.

The name of the Client Group.

The legal name of the Client Group.

The default payment terms of the Client Group.

A shortened or alternate version of the Client Group's name, typically used for fields with character length limits.

The start date of the Client Group record's validity period, in yyyy-MM-dd format.

Note:

A Client Group can only be assigned to campaigns that start and end within the Client Group record's validity period.

The end date of the Client Group record's validity period, in yyyy-MM-dd format.

Note:

A Client Group can only be assigned to campaigns that start and end within the Client Group record's validity period.

The OneStrata-generated identifier of the Client.

The industry of the Client.

The ERP (enterprise resource planning) interface system of the Client.

Whether or not the Client record is active.

The date that the Client record was last modified, in yyyy-MM-dd format.

The localized name of the Client.

A URL to a page or file that hosts the Client's logo.

The name of the Client.

The legal name of the Client.

The default payment terms of the Client.

A shortened or alternate version of the Client's code, typically used for fields with character length limits.

A shortened or alternate version of the Client's name, typically used for fields with character length limits.

The start date of the Client record's validity period, in yyyy-MM-dd format.

Note:

A Client can only be assigned to campaigns that start and end within the Client record's validity period.

The end date of the Client record's validity period, in yyyy-MM-dd format.

Note:

A Client can only be assigned to campaigns that start and end within the Client record's validity period.

The date that the Client Passback record was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the Client Passback record.

Whether or not the Client Passback record is active.

The date that the Client Passback record was last modified, in yyyy-MM-dd format.

The decimal percentage of the vendor discount that is passed on to the client.

Note:

This value is determined by the applied Client > Passback record.

The start date of the Client Passback record's validity period, in yyyy-MM-dd format.

Note:

A Client Passback record can only be applied to Cost Lines that start and end within the Client Passback record's validity period.

The end date of the Client Passback record's validity period, in yyyy-MM-dd format.

Note:

A Client Passback record can only be applied to Cost Lines that start and end within the Client Passback record's validity period.

The date and time that data was most recently retrieved from the OneStrata data warehouse, in yyyy-MM-dd HH:mm:ss format and in the time zone of the Analytics query.

The date that the Contract record was created, in yyyy-MM-dd format.

The default currency of the Contract, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

Whether or not the Contract exists at the enterprise level.

Possible values:

• TRUE / Yes: The Contract can be applied to Cost Lines in any campaign.

• FALSE / No: The Contract can only be applied to Cost Lines in campaigns for specific Agencies and/or Business Units.

The OneStrata-generated identifier of the Contract.

Whether or not the Contract record is active.

The date that the Contract record was last modified, in yyyy-MM-dd format.

The name of the Contract.

An array of the other (non-default) currencies on the Contract, where each currency is a three-letter currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The start date of the Contract record's validity period, in yyyy-MM-dd format.

Note:

A Contract (a valid combination of Payee, Supplier, and Order Partner) can only be applied to Cost Lines that start and end within the Contract record's validity period.

The end date of the Contract record's validity period, in yyyy-MM-dd format.

Note:

A Contract (a valid combination of Payee, Supplier, and Order Partner) can only be applied to Cost Lines that start and end within the Contract record's validity period.

For future use.

The date that the Cost Category record was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the cost category.

The name of the cost category.

The start date of the Cost Category record's validity period, in yyyy-MM-dd format.

Note:

A cost category can only be applied to Cost Lines that start and end within the Cost Category record's validity period.

The end date of the Cost Category record's validity period, in yyyy-MM-dd format.

Note:

A cost category can only be applied to Cost Lines that start and end within the Cost Category record's validity period.

The cost of the media buy and any associated fees for this delivery period.

The number of clicks delivered during this delivery period.

The currency of the delivery costs, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The end date of the delivery period, in yyyy-MM-dd format.

The number of impressions delivered during this delivery period.

The date and time that data for this delivery period was most recently received, in yyyy-MM-dd format.

The cost of the media buy for this delivery period.

The number of post-click conversions delivered during this delivery period.

The number of post-view conversions delivered during this delivery period.

The number of units (for the primary unit type) delivered during this delivery period.

The end date of the delivery period, in yyyy-MM-dd format.

The number of video ads that played 100% of the ad content, during this delivery period.

The number of video ads that played 25% of the ad content, during this delivery period.

The number of video ads that played 50% of the ad content, during this delivery period.

The number of video ads that played 75% of the ad content, during this delivery period.

The number of video views delivered during this delivery period.

The percent of video ads that played 100% of the ad content, during this delivery period.

The percent of video ads that played 25% of the ad content, during this delivery period.

The percent of video ads that played 50% of the ad content, during this delivery period.

The percent of video ads that played 75% of the ad content, during this delivery period.

The number of viewable impressions delivered during this delivery period.

The number of visits delivered during this delivery period.

The name of the Agency assigned to this estimate.

For future use.

The amount budgeted for this estimate.

The currency of the estimate budget, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The currency of the estimate budget.

Possible values:

For a list of possible currencies, see Currency Reference.

The total spend committed against this estimate.

This value is calculated by summing the cost of all committed Cost Lines linked to this estimate.

The cost type of the estimate.

The first and last name of the user who created this estimate.

The date that the estimate was created, in yyyy-MM-dd format.

The approval status of the estimate.

Possible values:

• ApprovalRequired: No request to approve the estimate has been sent.
• PendingApproval: An approver (a user with the appropriate permissions) was requested to approve the estimate, but has not responded yet.
• Approved: The estimate was approved by the requested user.
• Declined: The estimate was rejected by the requested user.

The end date of the estimate, in yyyy-MM-dd format.

The identifier of the estimate in an external, non-OneStrata system.

The OneStrata-generated identifier of the estimate.

Whether or not the estimate is active.

The first and last name of the user who last modified this estimate.

The date that the estimate was last modified, in yyyy-MM-dd format.

The name of the estimate.

The start date of the estimate, in yyyy-MM-dd format.

The ratio of the number of units allocated to this flight period to the total number of units in the Media Line that contains the flight period, as a decimal.

The end date of the flight period, in yyyy-MM-dd format.

The OneStrata-generated identifier of the flight period.

The number of units in the flight period.

The start date of the flight period, in yyyy-MM-dd format.

The status of the flight period.

Possible values:

• Active: The flight period is active.
• Cancelled: The flight period is canceled.

A code or phrase that represents the Media Type, typically used for billing or reporting.

The date that the Media Type was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the Media Type.

Whether or not the Media Type is active.

The date that the Media Type was last modified, in yyyy-MM-dd format.

The system media type of the Media Type.

System media types are defined by OneStrata, Media Types are defined by individual enterprises.

Possible values:

• TV
• Radio
• Digital
• Print
• OOH

The name of the Media Type.

The start date of the Media Type's validity period, in yyyy-MM-dd format.

Note:

A Media Type can only be assigned to campaigns that start and end within the Media Type's validity period.

The end date of the Media Type's validity period, in yyyy-MM-dd format.

Note:

A Media Type can only be assigned to campaigns that start and end within the Media Type's validity period.

The number of acquisitions committed against the Media Line.

The number of actions committed against the Media Line.

The number of add-to-carts committed against the Media Line.

The number of clicks committed against the Media Line.

The number of completed views committed against the Media Line.

The number of content views committed against the Media Line.

The number of conversions committed against the Media Line.

The number of engagements committed against the Media Line.

The number of impressions committed against the Media Line.

The number of landing page views committed against the Media Line.

The number of lands committed against the Media Line.

The number of leads committed against the Media Line.

The number of lifts committed against the Media Line.

The number of likes committed against the Media Line.

The number of link clicks committed against the Media Line.

The number of messages committed against the Media Line.

The number of units committed against the Media Line, for the primary unit type.

The number of purchases committed against the Media Line.

The number of reads committed against the Media Line.

The number of sent InMails committed against the Media Line.

The number of swipe-ups committed against the Media Line.

The number of unique reaches committed against the Media Line.

The number of viewable completed views committed against the Media Line.

The number of viewable impressions committed against the Media Line.

The number of viewable views committed against the Media Line.

The number of views committed against the Media Line.

The number of visits committed against the Media Line.

For an allocated Cost Line, the budget of the Cost Line, in the Client Currency.

Note:

This value is manually entered.

For an allocated Cost Line, the sum of all allocated fees assigned to the Cost Line, in the Client Currency.

Note:

This value is calculated from the assigned allocated fees.

The agency commission charged to the client, in the Agency Currency.

Note:

This value is calculated from the client gross cost or client net cost, depending on the cost basis of the applied Commission record:

• Client Commission = Client Gross * Client Commission Percentage
• Client Commission = Client Net * Client Commission Percentage

The agency commission charged to the client, in the Client Currency.

Note:

This value is calculated from the client gross cost or client net cost, depending on the cost basis of the applied Commission record:

• Client Commission = Client Gross * Client Commission Percentage
• Client Commission = Client Net * Client Commission Percentage

The decimal percentage of the client gross/net cost charged as an agency commission to the client.

Note:

This value is defined by the applied Commission record.

The Commission record applied to this Cost Line, as a dictionary inside an array.

The discount given by the agency to the client, in the Agency Currency.

Note:

This value is calculated according to one of the following formulas:

• Client Discount = Client Gross * Client Discount Percentage
• Client Discount = (Client Net / (1 - Client Discount Percentage) - Client Net

The discount given by the agency to the client, in the Client Currency.

Note:

This value is calculated according to one of the following formulas:

• Client Discount = Client Gross * Client Discount Percentage
• Client Discount = (Client Net / (1 - Client Discount Percentage) - Client Net

The decimal percentage of the client gross cost given as a discount by the agency to the client.

Note:

This value is calculated according to the following formula:

• Client Discount Percentage = Vendor Discount Percentage * Client Pass Back Percentage

The Client Discount rule applied to this Cost Line, as a dictionary inside an array.

Note:

This rule is calculated according to the following formula:

• Client Discount Percentage = Vendor Discount Percentage * Client Pass Back Percentage

The cost to the client before any discounts, commissions, or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Gross = Client Net + Client Discount

The cost to the client before any discounts, commissions, or taxes are added, in the Client Currency.

Note:

This value can be manually entered or calculated according to the following formula:

• Client Gross = Client Net + Client Discount

The cost per unit to the client before any discounts, commissions, or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Gross Rate = (Client Gross / Units) * Unit Type Rate Divider

The cost per unit to the client before any discounts, commissions, or taxes are added, in the Client Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Client Gross Rate = (Client Gross / Units) * Unit Type Rate Divider

The cost to the client after any discounts are added but before any commissions or taxes are added, in the Agency Currency.

Note:

This value is calculated according to one of the following formulas:

• Client Net = Client Gross - Client Discount
• For allocated Cost Lines only: Client Net = Allocated Amount - Allocated Fee Cost

The cost to the client after any discounts are added but before any commissions or taxes are added, in the Client Currency.

Note:

This value can be manually entered or calculated according to one of the following formulas:

• Client Net = Client Gross - Client Discount
• For allocated Cost Lines only: Client Net = Allocated Amount - Allocated Fee Cost

The cost to the client after any discounts are added but before any commissions or taxes are added, in the Vendor Currency.

Note:

This value can be manually entered or calculated according to one of the following formulas:

• Client Net = Client Gross - Client Discount
• For allocated Cost Lines only: Client Net = Allocated Amount - Allocated Fee Cost

The cost per unit to the client after any discounts are added but before any commissions or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Net Rate = (Client Net / Units) * Unit Type Rate Divider

The cost per unit to the client after any discounts are added but before any commissions or taxes are added, in the Client Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Client Net Rate = (Client Net / Units) * Unit Type Rate Divider

The cost per unit to the client after any discounts are added but before any commissions or taxes are added, in the Vendor Currency.

Note:

This value is calculated according to the following formula:

• Client Net Rate = (Client Net / Units) * Unit Type Rate Divider

The decimal percentage of the vendor discount that is passed on to the client.

Note:

This value is determined by the applied Client > Passback record.

The tax on activity charged to the client, in the Agency Currency.

Note:

This value is calculated from the client gross cost, client net cost, vendor gross cost, or vendor net cost, depending on the cost basis of the applied Client Tax record:

• Client Tax = Client Gross * Client Tax Percentage
• Client Tax = Client Net * Client Tax Percentage
• Client Tax = Vendor Gross * Client Tax Percentage
• Client Tax = Vendor Net * Client Tax Percentage

The tax on activity charged to the client, in the Client Currency.

Note:

This value is calculated from the client gross cost, client net cost, vendor gross cost, or vendor net cost, depending on the cost basis of the applied Client Tax record:

• Client Tax = Client Gross * Client Tax Percentage
• Client Tax = Client Net * Client Tax Percentage
• Client Tax = Vendor Gross * Client Tax Percentage
• Client Tax = Vendor Net * Client Tax Percentage

The tax on commission charged to the client, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Tax on Commission = Client Commission * Client Tax Percentage

The tax on commission charged to the client, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Client Tax on Commission = Client Commission * Client Tax Percentage

The decimal percentage of the client cost charged as a tax to the client.

Note:

This value is defined by the applied Client Tax record.

The cost to the client after any discounts and commissions are added but before any taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Total = Client Net + Client Commission

The cost to the client after any discounts and commissions are added but before any taxes are added, in the Client Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Client Total = Client Net + Client Commission

The cost per unit to the client after any discounts and commissions are added but before any taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Total Rate = (Client Total / Units) * Unit Type Rate Divider

The cost per unit to the client after any discounts and commissions are added but before any taxes are added, in the Client Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Client Total Rate = (Client Total / Units) * Unit Type Rate Divider

The total cost to the client after any discounts, commissions, and taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Total With Tax = Client Total + Client Tax + Client Tax on Commission

The total cost to the client after any discounts, commissions, and taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Client Total With Tax = Client Total + Client Tax + Client Tax on Commission

The total cost per unit to the client after any discounts, commissions, and taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Client Total With Tax Rate = (Client Total With Tax / Units) * Unit Type Rate Divider

The total cost per unit to the client after any discounts, commissions, and taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Client Total With Tax Rate = (Client Total With Tax / Units) * Unit Type Rate Divider

The end date of the Cost Line, in yyyy-MM-dd format.

The start date of the Cost Line, in yyyy-MM-dd format.

For a margin Cost Line, the difference between the client net cost and the vendor net cost, as a decimal percentage of the client net cost.

Note:

This value can be manually entered or calculated according to the following formula:

• Margin Percentage = (Client Net - Vendor Net) / Client Net

The total number of units in the order.

The difference between the client net cost and vendor net cost, in the Agency Currency.

Represents additional income (not including any commissions) or costs for the agency.

Note:

This value is calculated according to the following formula:

• Other Income = Client Net - Vendor Net

The difference between the client net cost and vendor net cost, in the Client Currency.

Represents additional income (not including any commissions) or costs for the agency.

Note:

This value is calculated according to the following formula:

• Other Income = Client Net - Vendor Net

The difference between the client net cost and vendor net cost, in the Vendor Currency.

Represents additional income (not including any commissions) or costs for the agency.

Note:

This value is calculated according to the following formula:

• Other Income = Client Net - Vendor Net

The pre-actualization vendor gross cost, in the Vendor Currency.

Note:

Before a billing period is actualized, its pre-actualization vendor cost is equal to its committed vendor cost.

Once a billing period is actualized, its pre-actualization vendor cost value becomes fixed.

The pre-actualization vendor net cost, in the Vendor Currency.

Note:

Before a billing period is actualized, its pre-actualization vendor cost is equal to its committed vendor cost.

Once a billing period is actualized, its pre-actualization vendor cost value becomes fixed.

The discount given by the vendor to the agency, in the Agency Currency.

Note:

This value is calculated according to one of the following formulas:

• Vendor Discount = Vendor Gross * Vendor Discount Percentage
• Vendor Discount = (Vendor Net / (1 - Vendor Discount Percentage) - Vendor Net

The discount given by the vendor to the agency, in the Client Currency.

Note:

This value is calculated according to one of the following formulas:

• Vendor Discount = Vendor Gross * Vendor Discount Percentage
• Vendor Discount = (Vendor Net / (1 - Vendor Discount Percentage) - Vendor Net

The discount given by the vendor to the agency, in the Vendor Currency.

Note:

This value is calculated according to one of the following formulas:

• Vendor Discount = Vendor Gross * Vendor Discount Percentage
• Vendor Discount = (Vendor Net / (1 - Vendor Discount Percentage) - Vendor Net

The decimal percentage of the vendor gross cost given as a discount by the vendor to the agency.

Note:

This value is defined on the Contract applied to the Cost Line.

The Vendor Discount rule applied to this Cost Line, as a dictionary inside an array.

Note:

This rule is defined on the Contract applied to the Cost Line.

The cost to the agency before any discounts, commissions, or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Gross = Vendor Net + Vendor Discount

The cost to the agency before any discounts, commissions, or taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Gross = Vendor Net + Vendor Discount

The cost to the agency before any discounts, commissions, or taxes are added, in the Vendor Currency

Note:

This value can be manually entered or calculated according to the following formula:

• Vendor Gross = Vendor Net + Vendor Discount

The cost per unit to the agency before any discounts, commissions, or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Gross Rate = (Vendor Gross / Units) * Unit Type Rate Divider

The cost per unit to the agency before any discounts, commissions, or taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Gross Rate = (Vendor Gross / Units) * Unit Type Rate Divider

The cost per unit to the agency before any discounts, commissions, or taxes are added, in the Vendor Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Vendor Gross Rate = (Vendor Gross / Units) * Unit Type Rate Divider

The cost to the agency after any discounts are added but before any commissions or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Net = Vendor Gross - Vendor Discount

The cost to the agency after any discounts are added but before any commissions or taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Net = Vendor Gross - Vendor Discount

The cost to the agency after any discounts are added but before any commissions or taxes are added, in the Vendor Currency.

Note:

This value can be manually entered or calculated according to the following formula:

• Vendor Net = Vendor Gross - Vendor Discount

The cost per unit to the agency after any discounts are added but before any commissions or taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Net Rate = (Vendor Net / Units) * Unit Type Rate Divider

The cost per unit to the agency after any discounts are added but before any commissions or taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Net Rate = (Vendor Net / Units) * Unit Type Rate Divider

The cost per unit to the agency after any discounts are added but before any commissions or taxes are added, in the Vendor Currency.

Note:

This value is manually entered or calculated according to the following formula:

• Vendor Net Rate = (Vendor Net / Units) * Unit Type Rate Divider

The tax on activity charged to the agency, in the Agency Currency.

Note:

This value is calculated from the vendor gross cost or vendor net cost, depending on the cost basis of the applied Vendor Tax record:

• Vendor Tax = Vendor Gross * Vendor Tax Percentage
• Vendor Tax = Vendor Net * Vendor Tax Percentage

The tax on activity charged to the agency, in the Client Currency.

Note:

This value is calculated from the vendor gross cost or vendor net cost, depending on the cost basis of the applied Vendor Tax record:

• Vendor Tax = Vendor Gross * Vendor Tax Percentage
• Vendor Tax = Vendor Net * Vendor Tax Percentage

The tax on activity charged to the agency, in the Vendor Currency.

Note:

This value is calculated from the vendor gross cost or vendor net cost, depending on the cost basis of the applied Vendor Tax record:

• Vendor Tax = Vendor Gross * Vendor Tax Percentage
• Vendor Tax = Vendor Net * Vendor Tax Percentage

The decimal percentage of the vendor cost charged as a tax to the agency.

Note:

This value is defined by the applied Vendor Tax record.

The total cost to the agency after any discounts and taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax = Vendor Net + Vendor Tax

The total cost to the agency after any discounts and taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax = Vendor Net + Vendor Tax

The total cost to the agency after any discounts and taxes are added, in the Vendor Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax = Vendor Net + Vendor Tax

For future use.

The total cost per unit to the agency after any discounts and taxes are added, in the Agency Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax Rate = (Vendor Total With Tax / Units) * Unit Type Rate Divider

The total cost per unit to the agency after any discounts and taxes are added, in the Client Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax Rate = (Vendor Total With Tax / Units) * Unit Type Rate Divider

The total cost per unit to the agency after any discounts and taxes are added, in the Vendor Currency.

Note:

This value is calculated according to the following formula:

• Vendor Total With Tax Rate = (Vendor Total With Tax / Units) * Unit Type Rate Divider

The Agency Currency of the order, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The Agency Currency of the order.

Possible values:

For a list of possible currencies, see Currency Reference.

The exchange rate from the Agency Currency to the Client Currency.

The date that the most recent order approval request was accepted or rejected, in yyyy-MM-dd format.

The email address of the person who was requested to approve this order.

The date that the order approval request was sent, in yyyy-MM-dd format.

The confirmation/approval status of the order.

Possible values:

• New: No request to confirm the order has ever been sent to the Order Partner.
• AwaitingConfirmation: The Order Partner was requested to confirm the order but has not responded yet.
• AwaitingCancellation: The Order Partner was requested to cancel the order, which was previously confirmed. If the Order Partner accepts the cancellation request, the status changes to Cancelled.
• AmendedAwaitingConfirmation: The Order Partner was requested to confirm a change to the order but has not responded yet.
• Confirmed: The order was confirmed by the Order Partner.
• Declined: The order was rejected by the Order Partner.
• Cancelled: The order was previously confirmed but is now canceled by the Order Partner.
• Updated: The order was previously confirmed but has new changes that have not been sent to the Order Partner yet. When a new confirmation request is sent the Order Partner, the status changes to AmendedAwaitingConfirmation.
• UnSentCancellation: The order was previously confirmed but is now canceled in OneStrata. When the cancellation request is sent to the Order Partner, the status changes to Awaiting Cancellation.
• None: N/A

The version number of the order.

The Client Currency of the order, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The Client Currency of the order.

Possible values:

For a list of possible currencies, see Currency Reference.

See Order Costs > Client Gross Rate AC.

See Order Costs > Client Gross Rate CC.

See Order Costs > Client Net Rate AC.

See Order Costs > Client Net Rate CC.

See Order Costs > Client Net Rate VC.

The cost method of the Cost Line.

Possible values:

• Standard: The cost line uses the Standard cost method.
• Margin: The cost line uses the Margin cost method.
• Allocated: The cost line uses the Allocated cost method.

Whether the Cost Line was manually created or generated.

Possible values:

• Manually: The Cost Line was manually created.
• Generated: The Cost Line was generated by The system.

The cost distribution setting of the Cost Line.

Possible values:

• ProRata: Budget is distributed proportionately, according to the number of days in each flight period.

• Even: Budget is distributed evenly among flight periods, with each flight period receiving the same amount.

• Custom: The budget for each flight period is manually entered.

The end date of the Cost Line, in yyyy-MM-dd format.

The grouping structure of the Cost Line.

Possible values:

• Single: The Cost Line is a standalone Placement or standalone Media Package.
• Package: The Cost Line is a Cost Package.
• NoMediaLine: The Cost Line is a fee.

The OneStrata-generated identifier of the Cost Line.

The name of the Cost Line.

The rate divider of the Cost Line's rate type.

Possible values:

For a list of possible rate types, see Rate Type Reference.

The rate type of the Cost Line.

Possible values:

For a list of possible rate types, see Rate Type Reference.

The start date of the Cost Line, in yyyy-MM-dd format.

Whether the Supplier of the order is a media or non-media Supplier.

Possible values:

• Media: The Supplier of the order is a media Supplier.
• NonMedia: The Supplier of the order is a non-media Supplier.

The Financial Bridge export status of the newest financial order generated from this order.

Possible values:

• None: N/A
• Unsent: No export of the financial order to the Financial Bridge has been initiated.
• InTransit: The export of the financial order to the Financial Bridge was initiated but has not been completed yet.
• Pending: The financial order was successfully exported to the Financial Bridge but has not been exported to the external system yet.
• Sent: The financial order was successfully exported to the Financial Bridge and to the external system.
• Failed: The financial order was not successfully uploaded to the Financial Bridge or external system.
• Created: The financial order was created in FDM. No export of the financial order to the Financial Bridge has ever been initiated.

For a linked Cost Line, the external integration provider's identifier for the entity linked to the Cost Line.

Whether or not the Cost Line is linked to an external entity.

The status of the link between this Cost Line and an external entity.

Possible values:

• Error: A link between the Cost Line and an external entity exists, but some error occurred when creating or updating the external entity.
• Sent: A link between the Cost Line and an external entity exists. The external entity was successfully created, linked, or updated.
• Archived: N/A
• None: N/A

For a linked Cost Line, the provider type of the external integration provider.

Possible values:

• DSP (Demand-Side Platform)
• Search Platform
• Social Platform

For a linked Cost Line, the external integration provider of the Cost Line.

Possible values:

• Beeswax
• Display & Video 360
• The Trade Desk
• Google Ads
• Meta

For a linked Cost Line, the type of external entity linked to the Cost Line.

Possible values:

• AdGroup: The Cost Line is linked to a DSP insertion order.
• Campaign: The Cost Line is linked to a DSP, Seach, or Social campaign.

The OneStrata-generated identifier of the order.

Whether or not the order is regulated.

Note:

Regulated orders include client billing information, because vendors charge (and are paid by) the client directly for regulated orders.

The first and last name of the user who last modified this order.

The date that the order was last modified, in yyyy-MM-dd format.

The status of the order.

Possible values:

• Active: The order is active.
• Cancelled: The order is canceled.

The Vendor Currency of the order, as a three-letter ISO currency code.

Possible values:

For a list of possible currencies, see Currency Reference.

The Vendor Currency of the order.

Possible values:

For a list of possible currencies, see Currency Reference.

See Order Costs > Vendor Gross Rate AC.

See Order Costs > Vendor Gross Rate CC.

See Order Costs > Vendor Gross Rate VC.

See Order Costs > Vendor Net Rate AC.

See Order Costs > Vendor Net Rate CC.

See Order Costs > Vendor Net Rate VC.

The exchange rate from the Vendor Currency to the Agency Currency.

The version number of the order.

The order confirmation type of the Order Partner.

Possible values:

• AgencyAutoConfirmation: The Order Partner is configured for auto-confirmation.
• InSystemVendorConfirmation: The Order Partner is configured for in-system confirmation.
• ExternalConfirmation: The Order Partner is configured for external confirmation.

The date that the Order Partner record was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the Order Partner.

The date that the Order Partner record was last modified, in yyyy-MM-dd format.

The localized name of the Order Partner.

A URL to a page or file that hosts the Order Partner's logo.

The market where the Order Partner runs its media activity,

The name of the Order Partner.

The registration number of the Payee.

The date that the Payee record was created, in yyyy-MM-dd format.

The identifier of the Payee in an external, non-OneStrata system.

The OneStrata-generated identifier of the Payee.

The date that the Payee record was last modified, in yyyy-MM-dd format.

The legal name of the Payee.

The localized name of the Payee.

The name of the Payee.

Additional information about the Payee.

A code or phrase that represents the Product, typically used for billing or reporting.

The date that the Product record was created, in yyyy-MM-dd format.

The identifier of the Product in an external, non-OneStrata system.

A code or phrase that represents the Product Group, typically used for billing or reporting.

The date that the Product Group record was created, in yyyy-MM-dd format.

The identifier of the Product Group in an external, non-OneStrata system.

The OneStrata-generated identifier of the Product Group.

Whether or not the Product Group record is active.

The date that the Product Group record was last modified, in yyyy-MM-dd format.

The localized name of the Product Group.

A URL to a page or file that hosts the Product Group's logo.

The name of the product group.

The legal name of the Product Group.

A shortened or alternate version of the Product Group's name, typically used for fields with character length limits.

The start date of the Product Group record's validity period, in yyyy-MM-dd format.

Note:

A Product Group can only be assigned to campaigns that start and end within the Product Group record's validity period.

The end date of the Product Group record's validity period, in yyyy-MM-dd format.

Note:

A Product Group can only be assigned to campaigns that start and end within the Product Group record's validity period.

The OneStrata-generated identifier of the Product.

Whether or not the Product record is active.

The date that the Product record was last modified, in yyyy-MM-dd format.

The localized name of the Product.

A URL to a page or file that hosts the Product's logo.

The name of the Product.

The legal name of the Product.

A shortened or alternate version of the Product's code, typically used for fields with character length limits.

A shortened or alternate version of the Product's name, typically used for fields with character length limits.

The start date of the Product record's validity period, in yyyy-MM-dd format.

Note:

A Product can only be assigned to campaigns that start and end within the Product record's validity period.

The end date of the Product record's validity period, in yyyy-MM-dd format.

Note:

A Product can only be assigned to campaigns that start and end within the Product record's validity period.

The date that the Supplier record was created, in yyyy-MM-dd format.

The OneStrata-generated identifier of the Supplier.

The date that the Supplier record was last modified, in yyyy-MM-dd format.

The localized name of the Supplier.

A URL to a page or file that hosts the Supplier's logo.

The name of the Supplier.

Additional information about the Supplier.

A shortened or alternate version of the Supplier's name, typically used for fields with character length limits.

For future use.

Whether the Supplier is a media Supplier or a non-media Supplier.

Possible values:

• Media: The Supplier is a media Supplier.
• NonMedia: The Supplier is a non-media Supplier.

The OneStrata identifier of the Alternate Tax Option assigned to this Tax record.

The name of the Alternate Tax Option assigned to this Tax record.

For a Client Tax record, the cost type that the client tax rate applies to.

Possible values:

• VendorGross
• VendorNet
• ClientGross
• ClientNet
• ClientGrossAndCommission
• ClientNetAndCommission
• CommissionOnly

For a Client Tax record, the client tax rate as a decimal.

For a Client Tax record, the type of the client tax.

Possible values:

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

Whether the Tax record is a Client Tax record or a Vendor Tax record.

Possible values:

• AccountsReceivable: The Tax record is a Client Tax record.
• AccountsPayable: The Tax record is a Vendor Tax record.

The OneStrata-generated identifier of the Tax record.

For a Client Tax record, the date that the Tax Category assigned to this Tax record was created, in yyyy-MM-dd format.

For a Client Tax record, the identifier of the Tax Category assigned to this Tax record in an external, non-OneStrata system.

For a Client Tax record, the date that the Tax Category assigned to this Tax record was last modified, in yyyy-MM-dd format.

For a Client Tax record, the name of the Tax Category assigned to this Tax record.

The identifier of the Tax Category assigned to this Tax record in an external, non-OneStrata system.

Note:

• If the Tax record is a Client Tax record, this value is the external identifier of a Client Tax Category.
• If the Tax record is a Vendor Tax record, this value is the external identifier of a Vendor Tax Category.

For a Vendor Tax record, the date that the Tax Category assigned to this Tax record was created, in yyyy-MM-dd format.

For a Vendor Tax record, the identifier of the Tax Category assigned to this Tax record in an external, non-OneStrata system.

For a Vendor Tax record, the date that the Tax Category assigned to this Tax record was last modified, in yyyy-MM-dd format.

For a Vendor Tax record, the name of the Tax Category assigned to this Tax record.

A code or phrase that represents the Tax record, typically used for billing or reporting.

Whether the Tax record is a Client Tax record or a Vendor Tax record.

Possible values:

• Client: The Tax record is a Client Tax record.
• Vendor: The Tax record is a Vendor Tax record.

The start date of the Tax record's validity period, in yyyy-MM-dd format.

Note:

A tax can only be applied to Cost Lines that start and end within the Tax record's validity period.

The end date of the Tax record's validity period, in yyyy-MM-dd format.

Note:

A tax can only be applied to Cost Lines that start and end within the Tax record's validity period.

For a Vendor Tax record, the cost type that the vendor tax rate applies to.

Possible values:

• VendorGross
• VendorNet

For a Vendor Tax record, the vendor tax rate as a decimal.

For a Vendor Tax record, the type of the vendor tax.

Possible values:

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