OneStrata Data Warehouse Data Dictionary

The date and time that this row was added to the AD_PLACEMENT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The primary key value of the AD_PLACEMENT row.

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.

The type of the Ad Placement, as an ID value.

Possible values:

• 0: None
• 1: Display
• 2: Video
• 3: Tracking
• 4: Mobile
• 5: Interstitial
• 6: VideoTracking
• 7: VerificationTracking
• 8: InStreamAudio
• 9: Native
• 99: Other

The OneStrata identifier of the Ad Unit that generated this Ad Placement.

A foreign key in the AD_PLACEMENT view that references the AD_UNIT.AD_UNIT_KEY column.

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 automatically generated name of the Ad Placement, if a concatenated formula for Ad Placement names exists.

The OneStrata-generated identifier of the Ad Placement.

The name of the Ad Placement.

A foreign key in the AD_PLACEMENT view that references the ORDER_DETAIL.ORDER_KEY column.

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 GUID of the provider of this Tech Assignment.

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

Possible values:

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

The status of the Tech Assignment, as an ID value.

Note:

For the descriptive string version of this dimension, see AD_PLACEMENT.TECH_ASSIGNMENT_STATUS_TEXT.

Possible values:

• _0: Active
• 1: Cancelled

The status of the Tech Assignment.

Note:

For the ID value version of this dimension, see AD_PLACEMENT.TECH_ASSIGNMENT_STATUS.

Possible values:

• Active: The Tech Assignment is active.
• Cancelled: The Tech Assignment is canceled.

The date and time that this row was added to the AD_UNIT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

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.

Note:

For the ID value version of this dimension, see AD_UNIT.AD_UNIT_FORMAT_DIMENSIONTYPE.

Possible values:

• NA
• Display: The Ad Unit represents a display ad unit.
• Video: The Ad Unit represents a video ad unit.
• Audio: The Ad Unit represents an audio ad unit.

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

Note:

For the descriptive string version of this dimension, see AD_UNIT.AD_UNIT_FORMAT_DIMENSIONTEXT.

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 primary key value of the AD_UNIT row.

The names and values of any Ad Unit-level custom data fields, as a dictionary inside an array.

The OneStrata-generated identifier of the Ad Unit.

The names and values of any Media Line-level custom data fields, as a dictionary inside an array.

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.

Note:

For the ID value version of this dimension, see AD_UNIT.MEDIA_LINE_FORMAT_DIMENSIONTYPE.

Possible values:

• NA
• Display: The Media Line contains a display ad unit.
• Video: The Media Line contains a video ad unit.
• Audio: The Ad Unit contains an audio ad unit.

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

Note:

For the descriptive string version of this dimension, see AD_UNIT.MEDIA_LINE_FORMAT_DIMENSIONTEXT.

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.

Note:

For Cost Line-level grouping structure, see ORDER_DETAIL.COST_LINE_GROUPING and ORDER_DETAIL.COST_LINE_GROUPING_TEXT.

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 data warehouse identifier of the Media Line that this Ad Unit is in.

The name of the Media Line.

The (primary) rate type of the Media Line.

Note:

For the ID value version of this dimension, see AD_UNIT.MEDIA_LINE_RATE_TYPE.

Possible values:

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

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

Note:

For the descriptive string version of this dimension, see AD_UNIT.MEDIA_LINE_RATE_TEXT.

Possible values:

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

The primary and secondary (if any) rate types and units of the Media Line, as a dictionary inside an array.

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

The status of the Media Line, as an ID value.

Note:

For the descriptive string version of this dimension, see AD_UNIT.MEDIA_LINE_STATUS.

Possible values:

• 0: Active
• 1: Cancelled

The status of the Media Line.

Note:

For the ID value version of this dimension, see AD_UNIT.MEDIA_LINE_STATUS.

Possible values:

• Active: The Media Line is active.
• Cancelled: The Media Line is canceled.

The GUID of the Supplier assigned to this Media Line.

The name of the Ad Unit.

A foreign key in the AD_UNIT view that references the ORDER_DETAIL.ORDER_KEY column.

The status of the Ad Unit, as an ID value.

Note:

For the descriptive string version of this dimension, see AD_UNIT.STATUS_TEXT.

Possible values:

• 0: Active
• 1: Cancelled

The status of the Ad Unit.

Note:

For the ID value version of this dimension, see AD_UNIT.STATUS.

Possible values:

• Active: The Ad Unit is active.
• Cancelled: The Ad Unit is canceled.

The date and time that this row was added to the AGENCY view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The legal address of the Agency, as a dictionary inside an array.

The primary key value of the AGENCY row.

The primary key value of the AGENCY row that represents the parent agency of this Agency (the Agency that this Agency belongs to).

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

The date and time that the Agency record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the AGENCY view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Agency.

Whether or not the Agency record is active.

The date and time that the Agency record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Agency.

The start date and time of the Agency record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The end date and time of the Agency record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The date and time that this row was added to the BILLING_PERIOD view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The actualization status of the billing period, as an ID value.

Note:

For the descriptive string version of this dimension, see BILLING_PERIOD.ACTUALIZATION_STATUS_TEXT.

Possible values:

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

The actualization status of the billing period.

Note:

For the ID value version of this dimension, see BILLING_PERIOD.ACTUALIZATION_STATUS_ID.

Possible values:

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

The primary key value of the BILLING_PERIOD row.

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

A foreign key in the BILLING_PERIOD view that references the ENTERPRISE.ENTERPRISE_KEY column.

A foreign key in the BILLING_PERIOD view that references the ESTIMATE.ESTIMATE_KEY column.

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, as an ID value.

Note:

For the descriptive string version of this dimension, see BILLING_PERIOD.INVOICE_LOCK_TEXT.

Possible values:

• 0: Unlock
• 1: PartialLock
• 2: Lock

The invoice lock status of the billing period.

Note:

For the ID value version of this dimension, see BILLING_PERIOD.INVOICE_LOCK_ID.

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, as an ID value.

Note:

For the descriptive string version of this dimension, see BILLING_PERIOD.INVOICE_STATUS_TEXT.

Possible values:

• 0: NotInvoiced
• 1: Matched
• 2: Cleared

The invoice status of the billing period.

Note:

For the ID value version of this dimension, see BILLING_PERIOD.INVOICE_STATUS_ID.

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.

A foreign key in the BILLING_PERIOD view that references the ORDER_DETAIL.ORDER_KEY column.

A foreign key in the BILLING_PERIOD view that references the PURCHASE_ORDER.PURCHASE_ORDER_KEY column.

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

The status of the billing period, as an ID value.

Note:

For the descriptive string version of this dimension, see BILLING_PERIOD.STATUS_TEXT.

Possible values:

• 0: Active
• 1: Cancelled

The status of the billing period.

Note:

For the ID value version of this dimension, see BILLING_PERIOD.STATUS.

Possible values:

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

The date and time that this row was added to the BUSINESS_UNIT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The legal address of the Business Unit, as a dictionary inside an array.

The OneStrata identifier of the Agency that this Business Unit belongs to.

A foreign key in the BUSINESS_UNIT view that references the AGENCY.AGENCY_KEY column.

The primary key value of the BUSINESS__UNIT row.

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

The date and time that the Business Unit record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the BUSINESS_UNIT view that references the ENTERPRISE.ENTERPRISE_KEY column.

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 and time that the Business Unit record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Business Unit.

The start date and time of the Business Unit record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Business Unit record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The date and time that this row was added to the CAMPAIGN view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The Advertiser Approval status of the campaign schedule, as an ID value.

Note:

For the descriptive string version of this dimension, see CAMPAIGN.ADVERTISER_SCHEDULE_APPROVAL_STATUS_TEXT.

Possible values:

• 0: NotRequired
• 1: Required
• 2: PendingApproval
• 3: Approved
• 4: Declined

The Advertiser Approval status of the campaign schedule.

Note:

For the ID value version of this dimension, see CAMPAIGN.ADVERTISER_SCHEDULE_APPROVAL_STATUS_ID.

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, as an ID value.

Note:

For the descriptive string version of this dimension, see CAMPAIGN.AGENCY_SCHEDULE_APPROVAL_STATUS_TEXT.

Possible values:

• 0: NotRequired
• 1: Required
• 2: PendingApproval
• 3: Approved
• 4: Declined

The Agency Approval status of the campaign schedule.

Note:

For the ID value version of this dimension, see CAMPAIGN.AGENCY_SCHEDULE_APPROVAL_STATUS_ID.

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.

Note:

For the ID value version of this dimension, see CAMPAIGN.BUDGET_TYPE.

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 cost type of the campaign budget, as an ID value.

Note:

For the descriptive string version of this dimension, see CAMPAIGN.BUDGET_TEXT.

Possible values:

• 0: ClientGross
• 1: ClientNet
• 2: ClientTotal
• 3: ClientTotalWithTax

The primary key value of the CAMPAIGN row.

The OneStrata identifier of the Client that this campaign is for.

A foreign key in the CAMPAIGN view that references the CLIENT.CLIENT_KEY column.

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

The date and time that the campaign was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

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

A foreign key in the CAMPAIGN view that references the ENTERPRISE.ENTERPRISE_KEY column.

An array of foreign key values that reference the ESTIMATE.ESTIMATE_KEYcolumn, in the CAMPAIGN view.

An array of GUID values, where each value is the GUID of an estimate linked to this campaign.

A description of the campaign goals.

For future use.

The GUID of the Client Group assigned to this Campaign Group.

The GUID of the Client assigned to this Campaign Group.

The OneStrata-generated identifier of the Campaign Group.

The name of the Campaign Group.

The GUID of the Product Group assigned to this Campaign Group.

The GUID of the Product assigned to this Campaign Group.

The GUID 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 and time that the campaign was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the CAMPAIGN view that references the MEDIA.MEDIA_KEY column.

The GUID of the Media Type assigned to this campaign.

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 OneStrata identifier of the campaign product.

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

The status of the campaign, as an ID value.

Note:

For the descriptive string version of this dimension, see CAMPAIGN.STATUS_TEXT.

Possible values:

• 0: Active
• 1: Cancelled

The status of the campaign.

Note:

For the ID value version of this dimension, see CAMPAIGN.STATUS.

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.

The GUID of the campaign.

The date and time that this row was added to the CLIENT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The billing and/or legal address of the Client, as a dictionary inside an array.

The OneStrata identifier of the Agency that this Client belongs to.

The OneStrata identifier of the Business Unit that this Client belongs to.

A foreign key in the CLIENT view that references the BUSINESS_UNIT.BUSINESS_UNIT_KEY column.

The primary key value of the CLIENT row.

For future use.

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

The date and time that the Client record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 foreign key in the CLIENT view that references the ENTERPRISE.ENTERPRISE_KEY column.

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.

The billing address of the Client Group, as a dictionary inside an array.

The OneStrata identifier of the Business Unit that this Client Group belongs to.

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

The date and time that the Client Group record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time that the Client Group record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Client Group.

The start date and time of the Client Group record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Client Group record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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.

Whether or not the Client record is active.

The date and time that the Client record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Client.

The start date and time of the Client record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The end date and time of the Client record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The date and time that this row was added to the CLIENT_PASSBACK view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

A foreign key in the CLIENT_PASSBACK view that references the CLIENT.CLIENT_KEY column.

The primary key value of the CLIENT_PASSBACK row.

The GUID of the Client that this Client Passback record is for.

The date and time that the Client Passback record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the CLIENT_PASSBACK view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Client Passback record.

Whether or not the Client Passback record is active.

The date and time that the Client Passback record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Client Passback record.

The start date and time of the Client Passback record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Client Passback record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 version number of the Client Passback record.

The date and time that this row was added to the CONTRACT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The primary key value of the CONTRACT row.

The date and time that the Contract record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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.

A foreign key in the CONTRACT view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Contract.

Whether or not the Contract record is active.

The date and time that the Contract record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

An array of dictionaries, where each dictionary represents a Media Type and Media Type discount on this Contract.

The name of the Contract.

A foreign key in the CONTRACT view that references the ORDER_PARTNER.ORDER_PARTNER_KEY column.

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.

A foreign key in the CONTRACT view that references the PAYEE.PAYEE_KEY column.

A foreign key in the CONTRACT view that references the SUPPLIER.SUPPLIER_KEY column.

The GUID of the Contract.

The start date and time of the Contract record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Contract record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 date and time that this row was added to the COST_CATEGORY view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

For future use.

For future use.

The primary key value of the COST_CATEGORY row.

The date and time that the Cost Category record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the COST_CATEGORY view that references the ENTERPRISE.ENTERPRISE_KEY column.

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

The OneStrata-generated identifier of the cost category.

Whether or not the Cost Category record is active.

The date and time that the Cost Category record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

An array of foreign key values that reference the MEDIA.MEDIA_KEYcolumn, in the COST_CATEGORY view.

The name of the cost category.

The GUID of the cost category.

The start date and time of the Cost Category record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Cost Category record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 date and time that this row was added to the DELIVERY view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

A foreign key in the DELIVERY view that references the AGENCY.AGENCY_KEY column.

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

The number of clicks delivered during this delivery period.

A foreign key in the DELIVERY view that references the CLIENT.CLIENT_KEY column.

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 primary key value of the DELIVERY row.

The number of opened emails delivered during this delivery period.

The number of sent emails delivered during this delivery period.

The end date and time of the delivery period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

If the value of DELIVERY.START_DATE is identical to DELIVERY.END_DATE, the delivery period is the day specified by DELIVERY.START_DATE.

A foreign key in the DELIVERY view that references the ENTERPRISE.ENTERPRISE_KEY column.

The number of impressions delivered during this delivery period.

The difference between the billable cost and payable cost for this delivery period.

For more information, see DELIVERY.BILLABLE_COST and DELIVERY.PAYABLE_COST.

The date and time that data for this delivery period was most recently received, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the DELIVERY view that references the ORDER_DETAIL.ORDER_KEY column.

The cost of the media buy for this delivery period.

A foreign key in the DELIVERY view that references the AD_PLACEMENT.AD_PLACEMENT_KEY column.

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 start date and time of the delivery period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

If the value of DELIVERY.START_DATE is identical to DELIVERY.END_DATE, the delivery period is the day specified by DELIVERY.START_DATE.

A foreign key in the DELIVERY view that references the SUPPLIER.SUPPLIER_KEY column.

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 date and time that this row was added to the ENTERPRISE view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The account type of the enterprise.

Possible values:

• Live: The enterprise is live.
• UAT: The enterprise is for testing.

Optional, additional information about the enterprise.

The date and time that the enterprise was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Whether or not Adazzle Analytics is enabled in this enterprise.

Whether or not Analytics is enabled in this enterprise.

The primary key value of the ENTERPRISE row.

The OneStrata-generated identifier of the enterprise.

The date and time that the enterprise was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The name of the enterprise.

The GUID of the enterprise.

The date and time that this row was added to the ESTIMATE view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The name of the Agency assigned to this estimate.

The GUID of the Agency assigned to this estimate.

For future use.

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 name of the Business Unit assigned to this estimate.

The GUID of the Business Unit assigned to this estimate.

The name of the Client assigned to this estimate.

The GUID of the Client assigned to this estimate.

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.

Note:

For the ID value version of this dimension, see ESTIMATE.COST_TYPE_ID.

The cost type of the estimate, as an ID value.

Note:

For the descriptive string version of this dimension, see ESTIMATE.COST_TYPE.

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

The date and time that the estimate was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 names and values of any estimate-level custom fields, as a dictionary inside an array.

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

A foreign key in the ESTIMATE view that references the ENTERPRISE.ENTERPRISE_KEY column.

The GUID of the enterprise that this estimate is in.

The primary key value of the ESTIMATE row.

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 and time that the estimate was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the ESTIMATE view that references the MEDIA.MEDIA_KEY column.

The name of the Media Type assigned to this estimate.

The GUID of the Media Type assigned to this estimate.

The name of the estimate.

A foreign key in the ESTIMATE view that references the PRODUCT.PRODUCT_KEY column.

The name of the Product assigned to this estimate.

The GUID of the Product assigned to this estimate.

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

The GUID of the estimate.

The date and time that this row was added to the EXCHANGE_RATE view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

A foreign key in the EXCHANGE_RATE view that references the AGENCY.AGENCY_KEY column.

A foreign key in the EXCHANGE_RATE view that references the BUSINESS_UNIT.BUSINESS_UNIT_KEY column.

A foreign key in the EXCHANGE_RATE view that references the CLIENT.CLIENT_KEY column.

The currency that the Exchange Rate record converts from, as a three-letter ISO code.

The currency that the Exchange Rate record converts to, as a three-letter ISO code.

A foreign key in the EXCHANGE_RATE view that references the ENTERPRISE.ENTERPRISE_KEY column.

The rate at which the CURRENCY_FROM currency is converted to the CURRENCY_TO currency, as defined by the Exchange Rate record.

The primary key value of the EXCHANGE_RATE row.

The OneStrata-generated identifier of the Exchange Rate record.

The date and time that the Exchange Rate record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The GUID of the Exchange Rate record.

The start date and time of the Exxchange Rate record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

An exchange rate can only be added to campaigns that start and end within the Exchange Rate record's validity period.

The end date and time of the Exchange Rate record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

An exchange rate can only be added to campaigns that start and end within the Exchange Rate record's validity period.

The date and time that this row was added to the FLIGHT_PERIOD view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The OneStrata identifier of the Ad Unit that this flight period is for.

A foreign key in the FLIGHT_PERIOD view that references the AD_UNIT.AD_UNIT_KEY column.

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 primary key value of the FLIGHT_PERIOD row.

The OneStrata-generated identifier of the flight period.

The number of units in the flight period.

A foreign key in the FLIGHT_PERIOD view that references the ORDER_DETAIL.ORDER_KEY column.

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

The status of the flight period, as an ID value.

Note:

For the descriptive string version of this dimension, see FLIGHT_PERIOD.STATUS_TEXT.

Possible values:

• 0: Active
• 1: Cancelled

The status of the flight period.

Note:

For the ID value version of this dimension, see FLIGHT_PERIOD.STATUS.

Possible values:

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

The date and time that this row was added to the MEDIA view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

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

The date and time that the Media Type was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the MEDIA view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Media Type.

Whether or not the Media Type is active.

The date and time that the Media Type was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The primary key value of the MEDIA row.

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 GUID of the Media Type.

The start date and time of the Media Type's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Media Type's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The date and time that this row was added to the MEDIA_LINE_METRICS view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

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.

A foreign key in the MEDIA_LINE_METRICS view that references the AD_UNIT.MEDIA_LINE_KEY column.

The primary key value of the MEDIA_LINE_METRICS row.

The number of messages committed against the Media Line.

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

A foreign key in the MEDIA_LINE_METRICS view that references the ORDER_DETAIL.ORDER_KEY column.

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.

The date and time that this row was added to the ORDER_COST view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

A foreign key in the ORDER_COST view that references the AGENCY.AGENCY_KEY column.

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.

A foreign key in the ORDER_COST view that references the BILLING_PERIOD.BILLING_PERIOD_KEY column.

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

A foreign key in the ORDER_COST view that references the CAMPAIGN.CAMPAIGN_KEY column.

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 GUID of the Commission record applied to this Cost Line.

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

For future use.

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

A foreign key in the ORDER_COST view that references the CLIENT.CLIENT_KEY column.

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

For future use.

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 Client Tax record applied to this Cost Line, as a dictionary inside an array.

A foreign key in the ORDER_COST view that references the TAX.TAX_KEY column, in a subset of the TAX view that only includes Client Tax records.

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

For future use.

A foreign key in the ORDER_COST view that references the COST_CATEGORY.COST_CATEGORY_KEY column.

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

The OneStrata-generated identifier of the Cost Line.

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

The BigQuery identifier of the order.

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 primary key value of the ORDER_COST row.

The OneStrata-generated identifier of the order.

A foreign key in the ORDER_COST view that references the ORDER_DETAIL.ORDER_KEY column.

A foreign key in the ORDER_COST view that references the ORDER_PARTNER.ORDER_PARTNER_KEY column.

The GUID of 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

A foreign key in the ORDER_COST view that references the PAYEE.PAYEE_KEY column.

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 rate type of the Cost Line, as an ID value.

Possible values:

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

A foreign key in the ORDER_COST view that references the SUPPLIER.SUPPLIER_KEY column.

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 GUID of the Vendor Discount rule applied to this Cost Line.

Note:

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

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

For future use.

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 Vendor Tax record applied to this Cost Line, as a dictionary inside an array.

A foreign key in the ORDER_COST view that references the TAX.TAX_KEY column, in a subset of the TAX view that only includes Vendor Tax records.

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.

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

For future use.

The date and time that this row was added to the ORDER_DETAIL view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

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.

A foreign key in the ORDER_DETAIL view that references the AGENCY.AGENCY_KEY column.

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

The GUID of the Agency that this order is for.

The date and time that the most recent approval request for this order was accepted or rejected, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

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

The date and time that the most recent approval request for this order was sent, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The confirmation/approval status of the order, as an ID value.

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.APPROVAL_STATUS_TEXT.

Possible values:

• 0: New
• 1: AwaitingConfirmation
• 2: AwaitingCancellation
• 3: AmendedAwaitingConfirmation
• 4: Confirmed
• 5: Declined
• 6: Cancelled
• 7: UnSent
• 8: UnSentCancellation
• 9: None

The confirmation/approval status of the order.

Note:

For the ID value version of this dimension, see ORDER_DETAIL.APPROVAL_STATUS_ID.

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.

A foreign key in the ORDER_DETAIL view that references the CAMPAIGN.CAMPAIGN_KEY column.

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_COST.CLIENT_GROSS_RATE_AC.

See ORDER_COST.CLIENT_GROSS_RATE_CC.

The OneStrata identifier of the Client that this order is for.

A foreign key in the ORDER_DETAIL view that references the CLIENT.CLIENT_KEY column.

See ORDER_COST.CLIENT_NET_RATE_AC.

See ORDER_COST.CLIENT_NET_RATE_CC.

See ORDER_COST.CLIENT_NET_RATE_VC.

The GUID of the Client that this order is for.

The GUID of the Contract associated with this order.

A foreign key in the ORDER_DETAIL view that references the COST_CATEGORY.COST_CATEGORY column.

The GUID of the cost category of this Cost Line.

The cost method of the Cost Line, as an ID value.

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.COST_LINE_COST_METHOD_TEXT.

Possible values:

• 0: Standard
• 1: Margin
• 2: Allocated

The cost method of the Cost Line.

Note:

For the ID value version of this dimension, see ORDER_DETAIL.COST_LINE_COST_METHOD.

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, as an ID value.

Possible values:

• 0: Manually
• 1: Generated

The names and values of any Cost Line-level custom data fields, as a dictionary inside an array.

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

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.COST_LINE_DISTRIBUTION_METHOD_TEXT.

Possible values:

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

The cost distribution setting of the Cost Line.

Note:

For the ID value version of this dimension, see ORDER_DETAIL.COST_LINE_DISTRIBUTION_METHOD.

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, as an ID value.

Note:

• For the descriptive string version of this dimension, see ORDER_DETAIL.COST_LINE_GROUPING_TEXT.
• For Media Line-level grouping structure, see AD_UNIT.MEDIA_LINE_GROUPING.

Possible values:

• 0: Single
• 1: Package
• 2: NoMediaLine

The grouping structure of the Cost Line.

Note:

• For the ID value version of this dimension, see ORDER_DETAIL.COST_LINE_GROUPING.
• For Media Line-level grouping structure, see AD_UNIT.MEDIA_LINE_GROUPING.

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.

Note:

For the ID value version of this dimension, see ORDER_DETAIL.COST_LINE_RATE_TYPE.

Possible values:

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

The rate type of the Cost Line, as an ID value.

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.COST_LINE_RATE_TEXT.

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.

The GUID of the Supplier of this Cost Line.

The names and values of any order-level custom data data fields, as a dictionary inside an array.

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

Note:

For the ID value version of this dimension, see ORDER_DETAIL.DATA_TYPE.

Possible values:

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

Whether the Supplier of the order is a media or non-media Supplier, as an ID value.

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.DATA_TEXT.

Possible values:

• 0: Media
• 1: NonMedia

A foreign key in the ORDER_DETAIL view that references the ESTIMATE.ESTIMATE column.

For future use.

The Financial Bridge export status of the newest financial order generated from this order, as an ID value.

Note:

For the descriptive string version of this dimension, see ORDER_DETAIL.EXPORT_STATUS_TEXT.

Possible values:

• 0: None
• 1: Unsent
• 2: InTransit
• 3: Pending
• 4: Sent
• 5: Failed
• 6: Created

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

Note:

For the ID value version of this dimension, see ORDER_DETAIL.EXPORT_STATUS.

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 and time that the order was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The OneStrata identifier of the Media Type assigned to the campaign that this order is for.

A foreign key in the ORDER_DETAIL view that references the MEDIA.MEDIA_KEY column.

The primary key value of the ORDER_DETAIL row.

A foreign key in the ORDER_DETAIL view that references the ORDER_PARTNER.ORDER_PARTNER_KEY column.

The GUID of the Order Partner of this order.

A foreign key in the ORDER_DETAIL view that references the PAYEE.PAYEE_KEY column.

The GUID of the Payee of this order.

The status of the order, as an ID value.

Possible values:

• 0: Active
• 1: Cancelled

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.

A foreign key in the ORDER_DETAIL view that references the SUPPLIER.SUPPLIER_KEY column.

The GUID of the order.

See ORDER_COST.VENDOR_GROSS_RATE_AC.

See ORDER_COST.VENDOR_GROSS_RATE_CC.

See ORDER_COST.VENDOR_GROSS_RATE_VC.

See ORDER_COST.VENDOR_NET_RATE_AC.

See ORDER_COST.VENDOR_NET_RATE_CC.

See ORDER_COST.VENDOR_NET_RATE_VC.

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

The version number of the order.

The date and time that this row was added to the ORDER_PARTNER view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The billing address of the Order Partner, as a dictionary inside an array.

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.

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

The address of the Order Partner contact.

The email address of the Order Partner contact.

The name of the Order Partner contact.

The telephone number of the Order Partner contact.

The date and time that the Order Partner record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The OneStrata identifier of the enterprise that this Order Partner is in.

A foreign key in the ORDER_PARTNER view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Order Partner.

Whether or not the Order Partner record is active.

The date and time that the Order Partner record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 primary key value of the ORDER_PARTNER row.

The GUID of the Order Partner.

The version number of the Order Partner record.

The date and time that this row was added to the PAYEE view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The billing address of the Payee, as a dictionary inside an array.

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

The registration number of the Payee.

The date and time that the Payee record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The names and values of any Payee-level custom fields, as a dictionary inside an array.

The OneStrata identifier of the enterprise that this Payee is in.

A foreign key in the PAYEE view that references the ENTERPRISE.ENTERPRISE_KEY column.

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

The OneStrata-generated identifier of the Payee.

Whether or not the Payee record is active.

The date and time that the Payee record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The legal name of the Payee.

The localized name of the Payee.

The name of the Payee.

Additional information about the Payee.

The primary key value of the PAYEE row.

A foreign key in the PAYEE view that references the TAX.TAX_GROUP_KEY column.

The GUID of the Payee.

The version number of the Payee record.

The date and time that this row was added to the PREFERRED_VENDOR view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The date and time that the Preferred Vendor record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the PREFERRED_VENDOR view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Preferred Vendor record.

Whether or not the Preferred Vendor record is active.

The date and time that the Preferred Vendor record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the PREFERRED_VENDOR view that references the MEDIA.MEDIA_KEY column.

A foreign key in the PREFERRED_VENDOR view that references the PAYEE.PAYEE_KEY column.

The primary key value of the PREFERRED_VENDOR row.

A foreign key in the PREFERRED_VENDOR view that references the SUPPLIER.SUPPLIER_KEY column.

The GUID of the Preferred Vendor.

The start date and time of the Preferred Vendor record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The end date and time of the Preferred Vendor record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The date and time that this row was added to the PRODUCT view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The billing address of the Product, as a dictionary inside an array.

The OneStrata identifier of the Agency that this Product belongs to.

The OneStrata identifier of the Business Unit that this Product belongs to.

The OneStrata identifier of the Client that this Product belongs to.

A foreign key in the PRODUCT view that references the CLIENT.CLIENT_KEY column.

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

The date and time that the Product record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

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

The billing address of the Product Group, as a dictionary inside an array.

The OneStrata identifier of the Client that this Product Group belongs to.

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

The date and time that the Product Group record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time that the Product Group record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 GUID of the Product Group.

The start date and time of the Product Group record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Product Group record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time that the Product record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ 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.

The primary key value of the PRODUCT row.

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 GUID of the Product.

The start date and time of the Product record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The end date and time of the Product record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

Note:

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

The date and time that this row was added to the PURCHASE_ORDER view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The GUID of the Agency assigned to this purchase order.

The GUID of the Business Unit assigned to this purchase order.

A foreign key in the PURCHASE_ORDER view that references the CLIENT.CLIENT_KEY column.

The GUID of the Client assigned to this purchase order.

The GUID of the enterprise that this purchase order is in.

The OneStrata-generated identifier of the purchase order.

The GUID of the Media Type assigned to this purchase order.

The GUID of the Product assigned to this purchase order.

The primary key value of the PURCHASE_ORDER view.

The reference number of this purchase order.

The GUID of the purchase order.

The date and time that this row was added to the ROLE_PERMISSION view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The date and time that the User Role record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the ROLE_PERMISSION view that references the ENTERPRISE.ENTERPRISE_KEY column.

The GUID of the enterprise that this user role is in.

Whether or not the User Role record is active.

The date and time that the User Role record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The OneStrata-generated identifier of the user role permission.

The name of the user role permission.

The name of the user role.

The primary key value of the ROLE_PERMISSION row.

The GUID of the user role.

The date and time that this row was added to the SUPPLIER view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The legal address of the Supplier, as a dictionary inside an array.

The date and time that the Supplier record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The OneStrata identifier of the enterprise that this Supplier is in.

A foreign key in the SUPPLIER view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Supplier.

Whether or not the Supplier record is active.

The date and time that the Supplier record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The localized name of the Supplier.

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

An array of dictionaries, where each dictionary represents a Media Type that this Supplier supports.

An array of foreign key values that reference the MEDIA.MEDIA_KEYcolumn, in the SUPPLIER view.

For future use.

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.

The primary key value of the SUPPLIER row.

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 GUID of the Supplier.

The version number of the Supplier record.

The date and time that this row was added to the TAX view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

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.

A foreign key in the TAX view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata identifier of the Tax Category assigned to this Tax record.

Note:

• If the Tax record is a Client Tax record, this value is the identifier of a Client Tax Category (TAX.TAX_CATEGORY_CLIENT_ID).
• If the Tax record is a Vendor Tax record, this value is the identifier of a Vendor Tax Category (TAX.TAX_CATEGORY_VENDOR_ID).

The OneStrata-generated identifier of the Tax record.

For a Client Tax record, the date and time that the Tax Category assigned to this Tax record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 OneStrata identifier of the Tax Category assigned to this Tax record.

For a Client Tax record, the date and time that the Tax Category assigned to this Tax record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

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

For a Client Tax record, the GUID 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 and time that the Tax Category assigned to this Tax record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 OneStrata identifier of the Tax Category assigned to this Tax record.

For a Vendor Tax record, the date and time that the Tax Category assigned to this Tax record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

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

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

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

The primary key value of the TAX row.

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 GUID of the Tax record.

The start date and time of the Tax record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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 and time of the Tax record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ 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).

The date and time that this row was added to the TERMS_AND_CONDITION view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

A foreign key in the TERMS_AND_CONDITION view that references the AGENCY.AGENCY_KEY column.

A foreign key in the TERMS_AND_CONDITION view that references the BUSINESS_UNIT.BUSINESS_UNIT_KEY column.

The OneStrata identifier of the Client Group assigned to this Terms & Conditions record.

A foreign key in the TERMS_AND_CONDITION view that references the CLIENT.CLIENT_KEY column.

The text contents of a manually entered Terms & Conditions record.

The date and time that the Terms & Conditions record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the TERMS_AND_CONDITION view that references the ENTERPRISE.ENTERPRISE_KEY column.

The OneStrata-generated identifier of the Terms & Conditions record.

The date and time that the Terms & Conditions record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

A foreign key in the TERMS_AND_CONDITION view that references the MEDIA.MEDIA_KEY column.

The name of the Terms & Conditions record.

A foreign key in the TERMS_AND_CONDITION view that references the ORDER_PARTNER.ORDER_PARTNER_KEY column.

The primary key value of the TERMS_AND_CONDITION row.

The type of the Terms & Conditions record, as an ID value.

Possible values:

• 0: None
• 1: AdvertiserView (the Terms & Conditions record is available on the Advertiser View page)
• 2: Order (the Terms & Conditions record is available on the Order Details page)

The GUID of the Terms & Conditions record.

The date and time that this row was added to the USER view, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

For future use.

For future use.

The date and time that the User record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The email address of the user.

A foreign key in the USER view that references the ENTERPRISE.ENTERPRISE_KEY column.

The GUID of the enterprise that this user is in.

The finance initials of the user.

The first name of the user.

For future use.

The OneStrata-generated identifier of the user.

Whether or not the User record is active.

The job title of the user.

The date and time that the User record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format.

The last name of the user.

The phone number of the user.

The Analytics permission type of the user.

Possible values:

For more information, see User Role Permissions Reference.

• View: The user has the "View Reports" permission.
• Manage: The user has the "Create/Modify Reports" permission.