---
title: "OneStrata Data Warehouse Data Dictionary"
canonical: "https://hub.freewheel.tv/space/OS/114360388/OneStrata%20Data%20Warehouse%20Data%20Dictionary"
format: markdown
---
This dictionary provides descriptions for the fields in the OneStrata data warehouse. Schema Table Name Field Name Type Description DIMENSION AD_PLACEMENT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  AD_PLACEMENT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION AD_PLACEMENT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION AD_PLACEMENT _IS_ACTIVE BOOLEAN For future use. DIMENSION AD_PLACEMENT AD_PLACEMENT_KEY NUMBER The primary key value of the  AD_PLACEMENT  row. DIMENSION AD_PLACEMENT AD_PLACEMENT_TYPE VARCHAR 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. DIMENSION AD_PLACEMENT AD_PLACEMENT_TYPE_ID NUMBER 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 DIMENSION AD_PLACEMENT AD_UNIT_ID NUMBER The OneStrata identifier of the Ad Unit that generated this Ad Placement. DIMENSION AD_PLACEMENT AD_UNIT_KEY NUMBER A foreign key in the  AD_PLACEMENT  view that references the  AD_UNIT.AD_UNIT_KEY  column. DIMENSION AD_PLACEMENT EXTERNAL_LINK_ID VARCHAR 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. DIMENSION AD_PLACEMENT EXTERNAL_LINK_IS_ACTIVE BOOLEAN Whether or not the Ad Placement is linked to an ad server placement. DIMENSION AD_PLACEMENT EXTERNAL_LINK_STATUS VARCHAR 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 DIMENSION AD_PLACEMENT EXTERNAL_LINK_SYSTEM_GROUP VARCHAR For a linked Ad Placement, the provider type of the external integration provider. Possible values: Ad Server DIMENSION AD_PLACEMENT EXTERNAL_LINK_SYSTEM_TYPE VARCHAR For a linked Ad Placement, the external integration provider of the Ad Placement. Possible values: Campaign Manager 360 Amazon Ad Server Flashtalking DIMENSION AD_PLACEMENT EXTERNAL_LINK_TYPE VARCHAR 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. DIMENSION AD_PLACEMENT FORMULA_BASED_PLACEMENT_NAME VARCHAR The automatically generated name of the Ad Placement, if a concatenated formula for Ad Placement names exists. DIMENSION AD_PLACEMENT ID NUMBER The OneStrata-generated identifier of the Ad Placement. DIMENSION AD_PLACEMENT NAME VARCHAR The name of the Ad Placement. DIMENSION AD_PLACEMENT ORDER_KEY NUMBER A foreign key in the  AD_PLACEMENT  view that references the  ORDER_DETAIL.ORDER_KEY  column. DIMENSION AD_PLACEMENT PACKAGE_NAME VARCHAR The name of the Ad Placement Package. DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_ID NUMBER The OneStrata-generated identifier of the Tech Assignment. DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_IS_PAYABLE_SOURCE BOOLEAN 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. DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_PROVIDER_UID VARCHAR The GUID of the provider of this Tech Assignment. DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_SERVICE_TYPE NUMBER The service type of the Tech Assignment, as an ID value. Possible values: 0 : None 1 : AdServing 2 : Tracking 3 : ContentVerification DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_STATUS NUMBER 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 DIMENSION AD_PLACEMENT TECH_ASSIGNMENT_STATUS_TEXT VARCHAR 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. DIMENSION AD_UNIT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  AD_UNIT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION AD_UNIT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION AD_UNIT _IS_ACTIVE BOOLEAN For future use. DIMENSION AD_UNIT AD_UNIT_FORMAT_DIMENSION VARCHAR 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. DIMENSION AD_UNIT AD_UNIT_FORMAT_DIMENSIONTEXT VARCHAR 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. DIMENSION AD_UNIT AD_UNIT_FORMAT_DIMENSIONTYPE VARCHAR 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 DIMENSION AD_UNIT AD_UNIT_FORMAT_NAME VARCHAR The format of the Ad Unit. For example,  Banner  or  Pre-Roll :30 . DIMENSION AD_UNIT AD_UNIT_FORMAT_SHORT_CODE VARCHAR A code or phrase that represents the format of this Ad Unit, typically used for billing or reporting. DIMENSION AD_UNIT AD_UNIT_KEY NUMBER The primary key value of the  AD_UNIT  row. DIMENSION AD_UNIT CUSTOM_FIELDS ARRAY The names and values of any Ad Unit-level custom data fields, as a dictionary inside an array. DIMENSION AD_UNIT ID NUMBER The OneStrata-generated identifier of the Ad Unit. DIMENSION AD_UNIT MEDIA_LINE_CUSTOM_FIELDS ARRAY The names and values of any Media Line-level custom data fields, as a dictionary inside an array. DIMENSION AD_UNIT MEDIA_LINE_DISTRIBUTION_METHOD NUMBER The cost distribution setting of the Media Line, as an ID value. Possible values: 0 : ProRata 1 : Even 2 : Custom DIMENSION AD_UNIT MEDIA_LINE_END_DATE DATE The end date of the Media Line, in yyyy-MM-dd format. DIMENSION AD_UNIT MEDIA_LINE_FORMAT_DIMENSION VARCHAR 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. DIMENSION AD_UNIT MEDIA_LINE_FORMAT_DIMENSIONTEXT VARCHAR 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. DIMENSION AD_UNIT MEDIA_LINE_FORMAT_DIMENSIONTYPE VARCHAR 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 DIMENSION AD_UNIT MEDIA_LINE_FORMAT_NAME VARCHAR The format of the Media Line. For example,  Banner  or  Pre-Roll :30 . DIMENSION AD_UNIT MEDIA_LINE_FORMAT_SHORT_CODE VARCHAR A code or phrase that represents the format of this Media Line, typically used for billing or reporting. DIMENSION AD_UNIT MEDIA_LINE_GROUPING VARCHAR 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. DIMENSION AD_UNIT MEDIA_LINE_KEY NUMBER The data warehouse identifier of the Media Line that this Ad Unit is in. DIMENSION AD_UNIT MEDIA_LINE_NAME VARCHAR The name of the Media Line. DIMENSION AD_UNIT MEDIA_LINE_RATE_TEXT VARCHAR The (primary) rate type of the Media Line. Possible values: For a list of possible rate types, see  Rate Type Reference . DIMENSION AD_UNIT MEDIA_LINE_RATE_TYPE VARCHAR 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 . DIMENSION AD_UNIT MEDIA_LINE_SECONDARY_UNITS ARRAY The primary and secondary (if any) rate types and units of the Media Line, as a dictionary inside an array. DIMENSION AD_UNIT MEDIA_LINE_START_DATE DATE The start date of the Media Line, in yyyy-MM-dd format. DIMENSION AD_UNIT MEDIA_LINE_STATUS NUMBER The status of the Media Line, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION AD_UNIT MEDIA_LINE_STATUS_TEXT VARCHAR 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. DIMENSION AD_UNIT MEDIA_LINE_SUPPLIER_UID VARCHAR The GUID of the Supplier assigned to this Media Line. DIMENSION AD_UNIT NAME VARCHAR The name of the Ad Unit. DIMENSION AD_UNIT ORDER_KEY NUMBER A foreign key in the  AD_UNIT  view that references the  ORDER_DETAIL.ORDER_KEY  column. DIMENSION AD_UNIT STATUS NUMBER The status of the Ad Unit, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION AD_UNIT STATUS_TEXT VARCHAR 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. DIMENSION AGENCY _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  AGENCY  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION AGENCY _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION AGENCY _IS_ACTIVE BOOLEAN For future use. DIMENSION AGENCY ADDRESSES ARRAY The legal address of the Agency, as a dictionary inside an array. DIMENSION AGENCY AGENCY_KEY NUMBER The primary key value of the  AGENCY  row. DIMENSION AGENCY AGENCY_PARENT_KEY NUMBER The primary key value of the  AGENCY  row that represents the parent agency of this Agency (the Agency that this Agency belongs to). DIMENSION AGENCY CODE VARCHAR A code or phrase that represents the Agency, typically used for billing or reporting. DIMENSION AGENCY CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Agency record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION AGENCY ENTERPRISE_KEY NUMBER A foreign key in the  AGENCY  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION AGENCY ID NUMBER The OneStrata-generated identifier of the Agency. DIMENSION AGENCY IS_ACTIVE BOOLEAN Whether or not the Agency record is active. DIMENSION AGENCY LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Agency record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION AGENCY LOCAL_NAME VARCHAR The localized name of the Agency. DIMENSION AGENCY LOGO_URL VARCHAR A URL to a page or file that hosts the Agency's logo. DIMENSION AGENCY NAME VARCHAR The name of the Agency. DIMENSION AGENCY OFFICIAL_NAME VARCHAR The legal name of the Agency. DIMENSION AGENCY PARENT_ID NUMBER The OneStrata identifier of the parent agency of this Agency (the Agency that this Agency belongs to). DIMENSION AGENCY PAYMENT_TERMS VARCHAR The default payment terms of the Agency. DIMENSION AGENCY SHORT_NAME VARCHAR A shortened or alternate version of the Agency's name, typically used for fields with character length limits. DIMENSION AGENCY UID VARCHAR The GUID of the Agency. DIMENSION AGENCY VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION AGENCY VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION BILLING_PERIOD _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  BILLING_PERIOD  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION BILLING_PERIOD _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION BILLING_PERIOD _IS_ACTIVE BOOLEAN For future use. DIMENSION BILLING_PERIOD ACTUALIZATION_STATUS_ID NUMBER The actualization status of the billing period, as an ID value. Possible values: 0 : NotActualized - The billing period is not actualized in OneStrata. 1 : Actualized - The billing period is actualized in OneStrata. DIMENSION BILLING_PERIOD ACTUALIZATION_STATUS_TEXT VARCHAR 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. DIMENSION BILLING_PERIOD BILLING_PERIOD_KEY NUMBER The primary key value of the  BILLING_PERIOD  row. DIMENSION BILLING_PERIOD END_DATE DATE The end date of the billing period, in yyyy-MM-dd format. DIMENSION BILLING_PERIOD ENTERPRISE_KEY NUMBER A foreign key in the  BILLING_PERIOD  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION BILLING_PERIOD ESTIMATE_KEY NUMBER A foreign key in the  BILLING_PERIOD  view that references the  ESTIMATE.ESTIMATE_KEY  column. DIMENSION BILLING_PERIOD EXTERNAL_ID VARCHAR The identifier of the billing period in an external, non-OneStrata system. DIMENSION BILLING_PERIOD ID NUMBER The OneStrata-generated identifier of the billing period. DIMENSION BILLING_PERIOD INVOICE_LOCK_ID NUMBER The invoice lock status of the billing period, as an ID value. Possible values: 0 : Unlock 1 : PartialLock 2 : Lock DIMENSION BILLING_PERIOD INVOICE_LOCK_TEXT VARCHAR 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. DIMENSION BILLING_PERIOD INVOICE_STATUS_ID NUMBER 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 DIMENSION BILLING_PERIOD INVOICE_STATUS_TEXT VARCHAR 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. DIMENSION BILLING_PERIOD NUMBER_OF_DAYS NUMBER The number of days in the billing period with media activity. DIMENSION BILLING_PERIOD ORDER_KEY NUMBER A foreign key in the  BILLING_PERIOD  view that references the  ORDER_DETAIL.ORDER_KEY  column. DIMENSION BILLING_PERIOD PURCHASE_ORDER_KEY NUMBER A foreign key in the  BILLING_PERIOD  view that references the  PURCHASE_ORDER.PURCHASE_ORDER_KEY  column. DIMENSION BILLING_PERIOD START_DATE DATE The start date of the billing period, in yyyy-MM-dd format. DIMENSION BILLING_PERIOD STATUS NUMBER The status of the billing period, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION BILLING_PERIOD STATUS_TEXT VARCHAR The status of the billing period. Possible values: Active : The billing period is active. Cancelled : The billing period is canceled. DIMENSION BUSINESS_UNIT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  BUSINESS_UNIT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION BUSINESS_UNIT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION BUSINESS_UNIT _IS_ACTIVE BOOLEAN For future use. DIMENSION BUSINESS_UNIT ADDRESSES ARRAY The legal address of the Business Unit, as a dictionary inside an array. DIMENSION BUSINESS_UNIT AGENCY_ID NUMBER The OneStrata identifier of the Agency that this Business Unit belongs to. DIMENSION BUSINESS_UNIT AGENCY_KEY NUMBER A foreign key in the  BUSINESS_UNIT  view that references the  AGENCY.AGENCY_KEY  column. DIMENSION BUSINESS_UNIT BUSINESS_UNIT_KEY NUMBER The primary key value of the  BUSINESS__UNIT  row. DIMENSION BUSINESS_UNIT CODE VARCHAR A code or phrase that represents the Business Unit, typically used for billing or reporting. DIMENSION BUSINESS_UNIT CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Business Unit record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION BUSINESS_UNIT ENTERPRISE_KEY NUMBER A foreign key in the  BUSINESS_UNIT  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION BUSINESS_UNIT EXTERNAL_ID VARCHAR The identifier of the Business Unit in an external, non-OneStrata system. DIMENSION BUSINESS_UNIT ID NUMBER The OneStrata-generated identifier of the Business Unit. DIMENSION BUSINESS_UNIT IS_ACTIVE BOOLEAN Whether or not the Business Unit record is active. DIMENSION BUSINESS_UNIT LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Business Unit record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION BUSINESS_UNIT LEGAL_ENTITY VARCHAR The legal name of the Business Unit. DIMENSION BUSINESS_UNIT LOCAL_NAME VARCHAR The localized name of the Business Unit. DIMENSION BUSINESS_UNIT LOGO_URL VARCHAR A URL to a page or file that hosts the Business Unit's logo. DIMENSION BUSINESS_UNIT NAME VARCHAR The name of the Business Unit. DIMENSION BUSINESS_UNIT OFFICIAL_NAME VARCHAR The legal name of the Business Unit. DIMENSION BUSINESS_UNIT PAYMENT_TERMS VARCHAR The default payment terms of the Business Unit. DIMENSION BUSINESS_UNIT SHORT_NAME VARCHAR A shortened or alternate version of the Business Unit's name, typically used for fields with character length limits. DIMENSION BUSINESS_UNIT UID VARCHAR The GUID of the Business Unit. DIMENSION BUSINESS_UNIT VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION BUSINESS_UNIT VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION CAMPAIGN _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  CAMPAIGN  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CAMPAIGN _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION CAMPAIGN _IS_ACTIVE BOOLEAN For future use. DIMENSION CAMPAIGN ADVERTISER_SCHEDULE_APPROVAL_STATUS_ID NUMBER The Advertiser Approval status of the campaign schedule, as an ID value. Possible values: 0 : NotRequired 1 : Required 2 : PendingApproval 3 : Approved 4 : Declined DIMENSION CAMPAIGN ADVERTISER_SCHEDULE_APPROVAL_STATUS_TEXT VARCHAR 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. DIMENSION CAMPAIGN AGENCY_SCHEDULE_APPROVAL_STATUS_ID NUMBER The Agency Approval status of the campaign schedule, as an ID value. Possible values: 0 : NotRequired 1 : Required 2 : PendingApproval 3 : Approved 4 : Declined DIMENSION CAMPAIGN AGENCY_SCHEDULE_APPROVAL_STATUS_TEXT VARCHAR 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. DIMENSION CAMPAIGN AGENCY_SCHEDULE_APPROVED_BY_NAME VARCHAR The Agency Schedule Approver’s email address. DIMENSION CAMPAIGN BUDGET NUMBER The monetary budget of the campaign. DIMENSION CAMPAIGN BUDGET_CURRENCY_CODE VARCHAR The currency of the campaign budget, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION CAMPAIGN BUDGET_TEXT VARCHAR 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. DIMENSION CAMPAIGN BUDGET_TYPE VARCHAR 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 DIMENSION CAMPAIGN CAMPAIGN_KEY NUMBER The primary key value of the  CAMPAIGN  row. DIMENSION CAMPAIGN CLIENT_ID NUMBER The OneStrata identifier of the Client that this campaign is for. DIMENSION CAMPAIGN CLIENT_KEY NUMBER A foreign key in the  CAMPAIGN  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION CAMPAIGN CREATED_BY VARCHAR The first and last name of the user who created this campaign. DIMENSION CAMPAIGN CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the campaign was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CAMPAIGN END_DATE DATE The end date of the campaign, in yyyy-MM-dd format. DIMENSION CAMPAIGN ENTERPRISE_KEY NUMBER A foreign key in the  CAMPAIGN  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION CAMPAIGN ESTIMATE_KEYS ARRAY An array of foreign key values that reference the  ESTIMATE.ESTIMATE_KEY column, in the  CAMPAIGN  view. DIMENSION CAMPAIGN ESTIMATE_UIDS ARRAY An array of GUID values, where each value is the GUID of an estimate linked to this campaign. DIMENSION CAMPAIGN EXTERNAL_ID VARCHAR The identifier of the campaign in an external, non-OneStrata system. DIMENSION CAMPAIGN GOAL_DESCRIPTION VARCHAR A description of the campaign goals. DIMENSION CAMPAIGN GOAL_NOTES VARCHAR For future use. DIMENSION CAMPAIGN GROUP_CLIENT_GROUP_UID VARCHAR The GUID of the Client Group assigned to this Campaign Group. DIMENSION CAMPAIGN GROUP_CLIENT_UID VARCHAR The GUID of the Client assigned to this Campaign Group. DIMENSION CAMPAIGN GROUP_EXTERNAL_ID VARCHAR The identifier of the Campaign Group in an external, non-OneStrata system. DIMENSION CAMPAIGN GROUP_ID NUMBER The OneStrata-generated identifier of the Campaign Group. DIMENSION CAMPAIGN GROUP_NAME VARCHAR The name of the Campaign Group. DIMENSION CAMPAIGN GROUP_PRODUCT_GROUP_UID VARCHAR The GUID of the Product Group assigned to this Campaign Group. DIMENSION CAMPAIGN GROUP_PRODUCT_UID VARCHAR The GUID of the Product assigned to this Campaign Group. DIMENSION CAMPAIGN GROUP_UID VARCHAR The GUID of the Campaign Group. DIMENSION CAMPAIGN ID NUMBER The OneStrata-generated identifier of the campaign. DIMENSION CAMPAIGN LAST_MODIFIED_BY VARCHAR The first and last name of the user who last modified this campaign. DIMENSION CAMPAIGN LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the campaign was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CAMPAIGN MEDIA_KEY NUMBER A foreign key in the  CAMPAIGN  view that references the  MEDIA.MEDIA_KEY  column. DIMENSION CAMPAIGN MEDIA_UID VARCHAR The GUID of the Media Type assigned to this campaign. DIMENSION CAMPAIGN NAME VARCHAR The name of the campaign. DIMENSION CAMPAIGN OWNED_BY VARCHAR The first and last name of the user who owns this campaign. By default, the campaign owner is the user who created the campagn. DIMENSION CAMPAIGN PRIMARY_COST VARCHAR The primary cost type of the campaign. This value is determined by the cost model of the campaign. Possible values: VendorGross VendorNet DIMENSION CAMPAIGN PRODUCT_ID NUMBER The OneStrata identifier of the campaign product. DIMENSION CAMPAIGN START_DATE DATE The start date of the campaign, in yyyy-MM-dd format. DIMENSION CAMPAIGN STATUS NUMBER The status of the campaign, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION CAMPAIGN STATUS_TEXT VARCHAR 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 . DIMENSION CAMPAIGN UID VARCHAR The GUID of the campaign. DIMENSION CLIENT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  CLIENT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION CLIENT _IS_ACTIVE BOOLEAN For future use. DIMENSION CLIENT ADDRESSES ARRAY The billing and/or legal address of the Client, as a dictionary inside an array. DIMENSION CLIENT AGENCY_ID NUMBER The OneStrata identifier of the Agency that this Client belongs to. DIMENSION CLIENT BUSINESS_UNIT_ID NUMBER The OneStrata identifier of the Business Unit that this Client belongs to. DIMENSION CLIENT BUSINESS_UNIT_KEY NUMBER A foreign key in the  CLIENT  view that references the  BUSINESS_UNIT.BUSINESS_UNIT_KEY  column. DIMENSION CLIENT CLIENT_KEY NUMBER The primary key value of the  CLIENT  row. DIMENSION CLIENT CLIENT_TYPE VARCHAR For future use. DIMENSION CLIENT CODE VARCHAR A code or phrase that represents the Client, typically used for billing or reporting. DIMENSION CLIENT CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT CURRENCY_CODE VARCHAR The currency that the client uses, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION CLIENT ENTERPRISE_KEY NUMBER A foreign key in the  CLIENT  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION CLIENT ERP_CODE VARCHAR A code or phrase that represents the ERP (enterprise resource planning) system of this Client, typically used for billing or reporting. DIMENSION CLIENT EXTERNAL_ID VARCHAR The identifier of the Client in an external, non-OneStrata system. DIMENSION CLIENT GROUP_ADDRESSES ARRAY The billing address of the Client Group, as a dictionary inside an array. DIMENSION CLIENT GROUP_BUSINESS_UNIT_ID NUMBER The OneStrata identifier of the Business Unit that this Client Group belongs to. DIMENSION CLIENT GROUP_CODE VARCHAR A code or phrase that represents the Client Group, typically used for billing or reporting. DIMENSION CLIENT GROUP_CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client Group record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT GROUP_EXTERNAL_ID VARCHAR The identifier of the Client Group in an external, non-OneStrata system. DIMENSION CLIENT GROUP_ID NUMBER The OneStrata-generated identifier of the Client Group. DIMENSION CLIENT GROUP_INDUSTRY VARCHAR The industry of the Client Group. DIMENSION CLIENT GROUP_IS_ACTIVE BOOLEAN Whether or not the Client Group record is active. DIMENSION CLIENT GROUP_LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client Group record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT GROUP_LOCAL_NAME VARCHAR The localized name of the Client Group. DIMENSION CLIENT GROUP_LOGO_URL VARCHAR A URL to a page or file that hosts the Client Group's logo. DIMENSION CLIENT GROUP_NAME VARCHAR The name of the Client Group. DIMENSION CLIENT GROUP_OFFICIAL_NAME VARCHAR The legal name of the Client Group. DIMENSION CLIENT GROUP_PAYMENT_TERMS VARCHAR The default payment terms of the Client Group. DIMENSION CLIENT GROUP_SHORT_NAME VARCHAR A shortened or alternate version of the Client Group's name, typically used for fields with character length limits. DIMENSION CLIENT GROUP_UID VARCHAR The GUID of the Client Group. DIMENSION CLIENT GROUP_VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT GROUP_VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT ID NUMBER The OneStrata-generated identifier of the Client. DIMENSION CLIENT INDUSTRY VARCHAR The industry of the Client. DIMENSION CLIENT IS_ACTIVE BOOLEAN Whether or not the Client record is active. DIMENSION CLIENT LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT LOCAL_NAME VARCHAR The localized name of the Client. DIMENSION CLIENT LOGO_URL VARCHAR A URL to a page or file that hosts the Client's logo. DIMENSION CLIENT NAME VARCHAR The name of the Client. DIMENSION CLIENT OFFICIAL_NAME VARCHAR The legal name of the Client. DIMENSION CLIENT PAYMENT_TERMS VARCHAR The default payment terms of the Client. DIMENSION CLIENT SHORT_CODE VARCHAR A shortened or alternate version of the Client's code, typically used for fields with character length limits. DIMENSION CLIENT SHORT_NAME VARCHAR A shortened or alternate version of the Client's name, typically used for fields with character length limits. DIMENSION CLIENT UID VARCHAR The GUID of the Client. DIMENSION CLIENT VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT_PASSBACK _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  CLIENT_PASSBACK  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT_PASSBACK _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION CLIENT_PASSBACK _IS_ACTIVE BOOLEAN For future use. DIMENSION CLIENT_PASSBACK CLIENT_KEY NUMBER A foreign key in the  CLIENT_PASSBACK  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION CLIENT_PASSBACK CLIENT_PASSBACK_KEY NUMBER The primary key value of the  CLIENT_PASSBACK  row. DIMENSION CLIENT_PASSBACK CLIENT_UID VARCHAR The GUID of the Client that this Client Passback record is for. DIMENSION CLIENT_PASSBACK CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client Passback record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT_PASSBACK ENTERPRISE_KEY NUMBER A foreign key in the  CLIENT_PASSBACK  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION CLIENT_PASSBACK ID NUMBER The OneStrata-generated identifier of the Client Passback record. DIMENSION CLIENT_PASSBACK IS_ACTIVE BOOLEAN Whether or not the Client Passback record is active. DIMENSION CLIENT_PASSBACK LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Client Passback record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CLIENT_PASSBACK PERCENTAGE NUMBER 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. DIMENSION CLIENT_PASSBACK UID VARCHAR The GUID of the Client Passback record. DIMENSION CLIENT_PASSBACK VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT_PASSBACK VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION CLIENT_PASSBACK VERSION NUMBER The version number of the Client Passback record. DIMENSION CONTRACT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  CONTRACT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CONTRACT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION CONTRACT _IS_ACTIVE BOOLEAN For future use. DIMENSION CONTRACT CONTRACT_KEY NUMBER The primary key value of the  CONTRACT  row. DIMENSION CONTRACT CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Contract record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CONTRACT DEFAULT_CURRENCY VARCHAR The default currency of the Contract, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION CONTRACT ENTERPRISE_ACCESS BOOLEAN 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. DIMENSION CONTRACT ENTERPRISE_KEY NUMBER A foreign key in the  CONTRACT  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION CONTRACT ID NUMBER The OneStrata-generated identifier of the Contract. DIMENSION CONTRACT IS_ACTIVE BOOLEAN Whether or not the Contract record is active. DIMENSION CONTRACT LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Contract record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION CONTRACT MEDIA_MAPPINGS ARRAY An array of dictionaries, where each dictionary represents a Media Type and Media Type discount on this Contract. DIMENSION CONTRACT NAME VARCHAR The name of the Contract. DIMENSION CONTRACT ORDER_PARTNER_KEY NUMBER A foreign key in the  CONTRACT  view that references the  ORDER_PARTNER.ORDER_PARTNER_KEY  column. DIMENSION CONTRACT OTHER_CURRENCIES ARRAY 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 . DIMENSION CONTRACT PAYEE_KEY NUMBER A foreign key in the  CONTRACT  view that references the  PAYEE.PAYEE_KEY  column. DIMENSION CONTRACT SUPPLIER_KEY NUMBER A foreign key in the  CONTRACT  view that references the  SUPPLIER.SUPPLIER_KEY  column. DIMENSION CONTRACT UID VARCHAR The GUID of the Contract. DIMENSION CONTRACT VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION CONTRACT VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION COST_CATEGORY _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  COST_CATEGORY  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION COST_CATEGORY _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION COST_CATEGORY _IS_ACTIVE BOOLEAN For future use. DIMENSION COST_CATEGORY CHANNEL_GROUP DIMENSION For future use. DIMENSION COST_CATEGORY COST_CATEGORY_GROUP VARCHAR For future use. DIMENSION COST_CATEGORY COST_CATEGORY_KEY NUMBER The primary key value of the  COST_CATEGORY  row. DIMENSION COST_CATEGORY CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Cost Category record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION COST_CATEGORY ENTERPRISE_KEY NUMBER A foreign key in the  COST_CATEGORY  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION COST_CATEGORY EXTERNAL_ID VARCHAR The identifier of the cost category in an external, non-OneStrata system. DIMENSION COST_CATEGORY ID NUMBER The OneStrata-generated identifier of the cost category. DIMENSION COST_CATEGORY IS_ACTIVE BOOLEAN Whether or not the Cost Category record is active. DIMENSION COST_CATEGORY LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Cost Category record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION COST_CATEGORY MEDIA_KEYS ARRAY An array of foreign key values that reference the  MEDIA.MEDIA_KEY column, in the  COST_CATEGORY  view. DIMENSION COST_CATEGORY NAME VARCHAR The name of the cost category. DIMENSION COST_CATEGORY UID VARCHAR The GUID of the cost category. DIMENSION COST_CATEGORY VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION COST_CATEGORY VALID_TO TIMESTAMP_NTZ(9) 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. FACT DELIVERY _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  DELIVERY  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT DELIVERY _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. FACT DELIVERY _IS_ACTIVE BOOLEAN For future use. FACT DELIVERY AGENCY_KEY NUMBER A foreign key in the  DELIVERY  view that references the  AGENCY.AGENCY_KEY  column. FACT DELIVERY BILLABLE_COST NUMBER The cost of the media buy and any associated fees for this delivery period. FACT DELIVERY CLICKS NUMBER The number of clicks delivered during this delivery period. FACT DELIVERY CLIENT_KEY NUMBER A foreign key in the  DELIVERY  view that references the  CLIENT.CLIENT_KEY  column. FACT DELIVERY CURRENCY VARCHAR The currency of the delivery costs, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . FACT DELIVERY DELIVERY_KEY NUMBER The primary key value of the  DELIVERY  row. FACT DELIVERY EMAILS_OPENED NUMBER The number of opened emails delivered during this delivery period. FACT DELIVERY EMAILS_SENT NUMBER The number of sent emails delivered during this delivery period. FACT DELIVERY END_DATE TIMESTAMP_NTZ(9) The end date and time of the delivery period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT DELIVERY ENTERPRISE_KEY NUMBER A foreign key in the  DELIVERY  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. FACT DELIVERY IAS_TOTAL_TRACKED_ADS NUMBER The total number of tracked ads from IAS. FACT DELIVERY IAS_VIEWABLE_IMPRESSIONS NUMBER The number of viewable impressions from IAS. FACT DELIVERY IAS_MEASURED_ADS NUMBER The number of measured ads from IAS. FACT DELIVERY IAS_TOTAL_ELIGIBLE_ADS_FOR_BRAND_SAFETY NUMBER The total number of eligible ads for brand safety from IAS. FACT DELIVERY IAS_PASSED_ADS NUMBER The number of passed ads from IAS. FACT DELIVERY IAS_ELIGIBLE_ADS_FOR_INVALID_TRAFFIC_DETECTION NUMBER The number of eligible ads for invalid traffic detection from IAS. FACT DELIVERY IAS_ELIGIBLE_RATE_FOR_INVALID_TRAFFIC_DETECTION NUMBER The eligible rate for invalid traffic detection from IAS. FACT DELIVERY IAS_VALID_TRAFFIC NUMBER The valid traffic from IAS. FACT DELIVERY IAS_VALID_VIEWABLE_VIDEO_IMPRESSIONS NUMBER The number of valid viewable video impressions from IAS. FACT DELIVERY IMPRESSIONS NUMBER The number of impressions delivered during this delivery period. FACT DELIVERY MARGIN NUMBER The difference between the billable cost and payable cost for this delivery period. For more information, see  DELIVERY.BILLABLE_COST  and  DELIVERY.PAYABLE_COST . FACT DELIVERY MODIFIED_DATETIME TIMESTAMP_NTZ(9) The date and time that data for this delivery period was most recently received, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT DELIVERY ORDER_KEY NUMBER A foreign key in the  DELIVERY  view that references the  ORDER_DETAIL.ORDER_KEY  column. FACT DELIVERY PAYABLE_COST NUMBER The cost of the media buy for this delivery period. FACT DELIVERY PLACEMENT_KEY NUMBER A foreign key in the  DELIVERY  view that references the  AD_PLACEMENT.AD_PLACEMENT_KEY  column. FACT DELIVERY POST_CLICK_CONVERSIONS NUMBER The number of post-click conversions delivered during this delivery period. FACT DELIVERY POST_VIEW_CONVERSIONS NUMBER The number of post-view conversions delivered during this delivery period. FACT DELIVERY PRIMARY_UNITS NUMBER The number of units (for the primary unit type) delivered during this delivery period. FACT DELIVERY START_DATE TIMESTAMP_NTZ(9) The start date and time of the delivery period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT DELIVERY SUPPLIER_KEY NUMBER A foreign key in the  DELIVERY  view that references the  SUPPLIER.SUPPLIER_KEY  column. FACT DELIVERY VIDEO_100PCT_VIEWS NUMBER The number of video ads that played 100% of the ad content, during this delivery period. FACT DELIVERY VIDEO_25PCT_VIEWS NUMBER The number of video ads that played 25% of the ad content, during this delivery period. FACT DELIVERY VIDEO_50PCT_VIEWS NUMBER The number of video ads that played 50% of the ad content, during this delivery period. FACT DELIVERY VIDEO_75PCT_VIEWS NUMBER The number of video ads that played 75% of the ad content, during this delivery period. FACT DELIVERY VIDEO_VIEWS NUMBER The number of video views delivered during this delivery period. FACT DELIVERY VIDEORATE_100_PERCENT NUMBER The percent of video ads that played 100% of the ad content, during this delivery period. FACT DELIVERY VIDEORATE_25_PERCENT NUMBER The percent of video ads that played 25% of the ad content, during this delivery period. FACT DELIVERY VIDEORATE_50_PERCENT NUMBER The percent of video ads that played 50% of the ad content, during this delivery period. FACT DELIVERY VIDEORATE_75_PERCENT NUMBER The percent of video ads that played 75% of the ad content, during this delivery period. FACT DELIVERY VIEWABLE_IMPRESSIONS NUMBER The number of viewable impressions delivered during this delivery period. FACT DELIVERY VISITS NUMBER The number of visits delivered during this delivery period. DIMENSION ENTERPRISE _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ENTERPRISE  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ENTERPRISE _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION ENTERPRISE _IS_ACTIVE BOOLEAN For future use. DIMENSION ENTERPRISE ACCOUNT_TYPE VARCHAR The account type of the enterprise. Possible values: Live : The enterprise is live. UAT : The enterprise is for testing. DIMENSION ENTERPRISE COMMENT VARCHAR Optional, additional information about the enterprise. DIMENSION ENTERPRISE CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the enterprise was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ENTERPRISE ENABLE_ADAZZLE_REPORT BOOLEAN Whether or not Adazzle Analytics is enabled in this enterprise. DIMENSION ENTERPRISE ENABLE_REPORT BOOLEAN Whether or not Analytics is enabled in this enterprise. DIMENSION ENTERPRISE ENTERPRISE_KEY NUMBER The primary key value of the  ENTERPRISE  row. DIMENSION ENTERPRISE ID NUMBER The OneStrata-generated identifier of the enterprise. DIMENSION ENTERPRISE LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the enterprise was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ENTERPRISE NAME VARCHAR The name of the enterprise. DIMENSION ENTERPRISE UID VARCHAR The GUID of the enterprise. DIMENSION ESTIMATE _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ESTIMATE  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ESTIMATE _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION ESTIMATE _IS_ACTIVE BOOLEAN For future use. DIMENSION ESTIMATE AGENCY_NAME VARCHAR The name of the Agency assigned to this estimate. DIMENSION ESTIMATE AGENCY_UID VARCHAR The GUID of the Agency assigned to this estimate. DIMENSION ESTIMATE BILLING_ALLOCATION_TYPE_ID NUMBER For future use. DIMENSION ESTIMATE BILLING_ALLOCATION_TYPE_TEXT VARCHAR For future use. DIMENSION ESTIMATE BUDGET NUMBER The amount budgeted for this estimate. DIMENSION ESTIMATE BUDGET_CURRENCY_CODE VARCHAR The currency of the estimate budget, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ESTIMATE BUDGET_CURRENCY_NAME VARCHAR The currency of the estimate budget. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ESTIMATE BUSINESS_UNIT_NAME VARCHAR The name of the Business Unit assigned to this estimate. DIMENSION ESTIMATE BUSINESS_UNIT_UID VARCHAR The GUID of the Business Unit assigned to this estimate. DIMENSION ESTIMATE CLIENT_NAME VARCHAR The name of the Client assigned to this estimate. DIMENSION ESTIMATE CLIENT_UID VARCHAR The GUID of the Client assigned to this estimate. DIMENSION ESTIMATE COMMITTED_ESTIMATE_SPEND NUMBER The total spend committed against this estimate. This value is calculated by summing the cost of all committed Cost Lines linked to this estimate. DIMENSION ESTIMATE COST_TYPE VARCHAR The cost type of the estimate. DIMENSION ESTIMATE COST_TYPE_ID NUMBER The cost type of the estimate, as an ID value. DIMENSION ESTIMATE CREATED_BY VARCHAR The first and last name of the user who created this estimate. DIMENSION ESTIMATE CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the estimate was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ESTIMATE CURRENT_ESTIMATE_APPROVAL_STATE VARCHAR 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. DIMENSION ESTIMATE CUSTOM_FIELDS ARRAY The names and values of any estimate-level custom fields, as a dictionary inside an array. DIMENSION ESTIMATE END_DATE DATE The end date of the estimate, in yyyy-MM-dd format. DIMENSION ESTIMATE ENTERPRISE_KEY NUMBER A foreign key in the  ESTIMATE  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION ESTIMATE ENTERPRISE_UID VARCHAR The GUID of the enterprise that this estimate is in. DIMENSION ESTIMATE ESTIMATE_KEY NUMBER The primary key value of the  ESTIMATE  row. DIMENSION ESTIMATE EXTERNAL_ID VARCHAR The identifier of the estimate in an external, non-OneStrata system. DIMENSION ESTIMATE ID NUMBER The OneStrata-generated identifier of the estimate. DIMENSION ESTIMATE IS_ACTIVE BOOLEAN Whether or not the estimate is active. DIMENSION ESTIMATE LAST_MODIFIED_BY VARCHAR The first and last name of the user who last modified this estimate. DIMENSION ESTIMATE LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the estimate was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ESTIMATE MEDIA_KEY NUMBER A foreign key in the  ESTIMATE  view that references the  MEDIA.MEDIA_KEY  column. DIMENSION ESTIMATE MEDIA_NAME VARCHAR The name of the Media Type assigned to this estimate. DIMENSION ESTIMATE MEDIA_UID VARCHAR The GUID of the Media Type assigned to this estimate. DIMENSION ESTIMATE NAME VARCHAR The name of the estimate. DIMENSION ESTIMATE PRODUCT_KEY NUMBER A foreign key in the  ESTIMATE  view that references the  PRODUCT.PRODUCT_KEY  column. DIMENSION ESTIMATE PRODUCT_NAME VARCHAR The name of the Product assigned to this estimate. DIMENSION ESTIMATE PRODUCT_UID VARCHAR The GUID of the Product assigned to this estimate. DIMENSION ESTIMATE START_DATE DATE The start date of the estimate, in yyyy-MM-dd format. DIMENSION ESTIMATE UID VARCHAR The GUID of the estimate. DIMENSION EXCHANGE_RATE _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  EXCHANGE_RATE  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION EXCHANGE_RATE _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION EXCHANGE_RATE _IS_ACTIVE BOOLEAN For future use. DIMENSION EXCHANGE_RATE AGENCY_KEY NUMBER A foreign key in the  EXCHANGE_RATE  view that references the  AGENCY.AGENCY_KEY  column. DIMENSION EXCHANGE_RATE BUSINESS_UNIT_KEY NUMBER A foreign key in the  EXCHANGE_RATE  view that references the  BUSINESS_UNIT.BUSINESS_UNIT_KEY  column. DIMENSION EXCHANGE_RATE CLIENT_KEY NUMBER A foreign key in the  EXCHANGE_RATE  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION EXCHANGE_RATE CURRENCY_FROM VARCHAR The currency that the Exchange Rate record converts from, as a three-letter ISO code. DIMENSION EXCHANGE_RATE CURRENCY_TO VARCHAR The currency that the Exchange Rate record converts to, as a three-letter ISO code. DIMENSION EXCHANGE_RATE ENTERPRISE_KEY NUMBER A foreign key in the  EXCHANGE_RATE  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION EXCHANGE_RATE EXCHANGE_RATE FLOAT The rate at which the  CURRENCY_FROM  currency is converted to the  CURRENCY_TO  currency, as defined by the Exchange Rate record. DIMENSION EXCHANGE_RATE EXCHANGE_RATE_KEY NUMBER The primary key value of the  EXCHANGE_RATE  row. DIMENSION EXCHANGE_RATE ID NUMBER The OneStrata-generated identifier of the Exchange Rate record. DIMENSION EXCHANGE_RATE LAST_MODIFIED_DATETIME TIMESTAMP_NTZ(9) The date and time that the Exchange Rate record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION EXCHANGE_RATE UID VARCHAR The GUID of the Exchange Rate record. DIMENSION EXCHANGE_RATE VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION EXCHANGE_RATE VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION FLIGHT_PERIOD _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  FLIGHT_PERIOD  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION FLIGHT_PERIOD _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION FLIGHT_PERIOD _IS_ACTIVE BOOLEAN For future use. DIMENSION FLIGHT_PERIOD AD_UNIT_ID NUMBER The OneStrata identifier of the Ad Unit that this flight period is for. DIMENSION FLIGHT_PERIOD AD_UNIT_KEY NUMBER A foreign key in the  FLIGHT_PERIOD  view that references the  AD_UNIT.AD_UNIT_KEY  column. DIMENSION FLIGHT_PERIOD ALLOCATION_PERCENTAGE NUMBER 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. DIMENSION FLIGHT_PERIOD END_DATE DATE The end date of the flight period, in yyyy-MM-dd format. DIMENSION FLIGHT_PERIOD FLIGHT_PERIOD_KEY NUMBER The primary key value of the  FLIGHT_PERIOD  row. DIMENSION FLIGHT_PERIOD ID NUMBER The OneStrata-generated identifier of the flight period. DIMENSION FLIGHT_PERIOD NUMBER_OF_UNITS NUMBER The number of units in the flight period. DIMENSION FLIGHT_PERIOD ORDER_KEY NUMBER A foreign key in the  FLIGHT_PERIOD  view that references the  ORDER_DETAIL.ORDER_KEY  column. DIMENSION FLIGHT_PERIOD START_DATE DATE The start date of the flight period, in yyyy-MM-dd format. DIMENSION FLIGHT_PERIOD STATUS NUMBER The status of the flight period, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION FLIGHT_PERIOD STATUS_TEXT VARCHAR The status of the flight period. Possible values: Active : The flight period is active. Cancelled : The flight period is canceled. DIMENSION MEDIA _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  MEDIA  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION MEDIA _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION MEDIA _IS_ACTIVE BOOLEAN For future use. DIMENSION MEDIA CODE VARCHAR A code or phrase that represents the Media Type, typically used for billing or reporting. DIMENSION MEDIA CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Media Type was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION MEDIA ENTERPRISE_KEY NUMBER A foreign key in the  MEDIA  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION MEDIA ID NUMBER The OneStrata-generated identifier of the Media Type. DIMENSION MEDIA IS_ACTIVE BOOLEAN Whether or not the Media Type is active. DIMENSION MEDIA LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Media Type was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION MEDIA MEDIA_KEY NUMBER The primary key value of the  MEDIA  row. DIMENSION MEDIA MEDIA_TYPE VARCHAR 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 DIMENSION MEDIA UI_NAME VARCHAR The name of the Media Type. DIMENSION MEDIA UID VARCHAR The GUID of the Media Type. DIMENSION MEDIA VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION MEDIA VALID_TO TIMESTAMP_NTZ(9) 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. FACT MEDIA_LINE_METRICS _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  MEDIA_LINE_METRICS  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT MEDIA_LINE_METRICS _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. FACT MEDIA_LINE_METRICS _IS_ACTIVE BOOLEAN For future use. FACT MEDIA_LINE_METRICS ACQUISITIONS NUMBER The number of acquisitions committed against the Media Line. FACT MEDIA_LINE_METRICS ACTIONS NUMBER The number of actions committed against the Media Line. FACT MEDIA_LINE_METRICS ADD_TO_CARTS NUMBER The number of add-to-carts committed against the Media Line. FACT MEDIA_LINE_METRICS CLICKS NUMBER The number of clicks committed against the Media Line. FACT MEDIA_LINE_METRICS COMPLETED_VIEWS NUMBER The number of completed views committed against the Media Line. FACT MEDIA_LINE_METRICS CONTENT_VIEWS NUMBER The number of content views committed against the Media Line. FACT MEDIA_LINE_METRICS CONVERSIONS NUMBER The number of conversions committed against the Media Line. FACT MEDIA_LINE_METRICS ENGAGEMENTS NUMBER The number of engagements committed against the Media Line. FACT MEDIA_LINE_METRICS IMPRESSIONS NUMBER The number of impressions committed against the Media Line. FACT MEDIA_LINE_METRICS LANDING_PAGE_VIEWS NUMBER The number of landing page views committed against the Media Line. FACT MEDIA_LINE_METRICS LANDS NUMBER The number of lands committed against the Media Line. FACT MEDIA_LINE_METRICS LEADS NUMBER The number of leads committed against the Media Line. FACT MEDIA_LINE_METRICS LIFTS NUMBER The number of lifts committed against the Media Line. FACT MEDIA_LINE_METRICS LIKES NUMBER The number of likes committed against the Media Line. FACT MEDIA_LINE_METRICS LINK_CLICKS NUMBER The number of link clicks committed against the Media Line. FACT MEDIA_LINE_METRICS MEDIA_LINE_KEY NUMBER A foreign key in the  MEDIA_LINE_METRICS  view that references the  AD_UNIT.MEDIA_LINE_KEY  column. FACT MEDIA_LINE_METRICS MEDIA_LINE_METRICS_KEY NUMBER The primary key value of the  MEDIA_LINE_METRICS  row. FACT MEDIA_LINE_METRICS MESSAGES NUMBER The number of messages committed against the Media Line. FACT MEDIA_LINE_METRICS NUMBER_OF_UNITS NUMBER The number of units committed against the Media Line, for the primary unit type. FACT MEDIA_LINE_METRICS ORDER_KEY NUMBER A foreign key in the  MEDIA_LINE_METRICS  view that references the  ORDER_DETAIL.ORDER_KEY  column. FACT MEDIA_LINE_METRICS PURCHASES NUMBER The number of purchases committed against the Media Line. FACT MEDIA_LINE_METRICS READS NUMBER The number of reads committed against the Media Line. FACT MEDIA_LINE_METRICS SENT_IN_MAILS NUMBER The number of sent InMails committed against the Media Line. FACT MEDIA_LINE_METRICS SWIPE_UPS NUMBER The number of swipe-ups committed against the Media Line. FACT MEDIA_LINE_METRICS UNIQUE_REACH NUMBER The number of unique reaches committed against the Media Line. FACT MEDIA_LINE_METRICS VIEWABLE_COMPLETED_VIEWS NUMBER The number of viewable completed views committed against the Media Line. FACT MEDIA_LINE_METRICS VIEWABLE_IMPRESSIONS NUMBER The number of viewable impressions committed against the Media Line. FACT MEDIA_LINE_METRICS VIEWABLE_VIEWS NUMBER The number of viewable views committed against the Media Line. FACT MEDIA_LINE_METRICS VIEWS NUMBER The number of views committed against the Media Line. FACT MEDIA_LINE_METRICS VISITS NUMBER The number of visits committed against the Media Line. FACT ORDER_COST _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ORDER_COST  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. FACT ORDER_COST _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. FACT ORDER_COST _IS_ACTIVE BOOLEAN For future use. FACT ORDER_COST AGENCY_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  AGENCY.AGENCY_KEY  column. FACT ORDER_COST ALLOCATED_AMOUNT_CC NUMBER For an allocated Cost Line, the budget of the Cost Line, in the Client Currency. Note: This value is manually entered. FACT ORDER_COST ALLOCATED_FEE_COST_AMOUNT_CC NUMBER 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. FACT ORDER_COST BILLING_PERIOD_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  BILLING_PERIOD.BILLING_PERIOD_KEY  column. FACT ORDER_COST BILLING_PERIOD_START_DATE DATE The start date of the billing period, in yyyy-MM-dd format. FACT ORDER_COST CAMPAIGN_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  CAMPAIGN.CAMPAIGN_KEY  column. FACT ORDER_COST CLIENT_COMMISSION_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_COMMISSION_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_COMMISSION_CONTRACT_UID VARCHAR The GUID of the Commission record applied to this Cost Line. FACT ORDER_COST CLIENT_COMMISSION_PERCENTAGE NUMBER 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. FACT ORDER_COST CLIENT_COMMISSION_RULE ARRAY The Commission record applied to this Cost Line, as a dictionary inside an array. FACT ORDER_COST CLIENT_DISCOUNT_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_DISCOUNT_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_DISCOUNT_CONTRACT_UID VARCHAR For future use. FACT ORDER_COST CLIENT_DISCOUNT_PERCENTAGE NUMBER 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 FACT ORDER_COST CLIENT_DISCOUNT_RULE ARRAY 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 FACT ORDER_COST CLIENT_GROSS_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_GROSS_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_GROSS_RATE_AC NUMBER 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 FACT ORDER_COST CLIENT_GROSS_RATE_CC NUMBER 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 FACT ORDER_COST CLIENT_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  CLIENT.CLIENT_KEY  column. FACT ORDER_COST CLIENT_NET_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_NET_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_NET_AMOUNT_VC NUMBER 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 FACT ORDER_COST CLIENT_NET_RATE_AC NUMBER 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 FACT ORDER_COST CLIENT_NET_RATE_CC NUMBER 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 FACT ORDER_COST CLIENT_NET_RATE_VC NUMBER 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 FACT ORDER_COST CLIENT_PASS_BACK_PERCENTAGE NUMBER 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. FACT ORDER_COST CLIENT_TAX_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_TAX_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_TAX_CONTRACT_UID VARCHAR For future use. FACT ORDER_COST CLIENT_TAX_ON_COMMISSION_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_TAX_ON_COMMISSION_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_TAX_PERCENTAGE NUMBER 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. FACT ORDER_COST CLIENT_TAX_RULE ARRAY The Client Tax record applied to this Cost Line, as a dictionary inside an array. FACT ORDER_COST CLIENT_TAX_SET_UP_KEY NUMBER 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. FACT ORDER_COST CLIENT_TOTAL_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_RATE_AC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_RATE_CC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_WITH_TAX_AMOUNT_AC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_WITH_TAX_AMOUNT_CC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_WITH_TAX_RATE_AC NUMBER 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 FACT ORDER_COST CLIENT_TOTAL_WITH_TAX_RATE_CC NUMBER 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 FACT ORDER_COST COMMISSION_KEY NUMBER For future use. FACT ORDER_COST COST_CATEGORY_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  COST_CATEGORY.COST_CATEGORY_KEY  column. FACT ORDER_COST COST_END_DATE DATE The end date of the Cost Line, in yyyy-MM-dd format. FACT ORDER_COST COST_LINE_ID NUMBER The OneStrata-generated identifier of the Cost Line. FACT ORDER_COST COST_START_DATE DATE The start date of the Cost Line, in yyyy-MM-dd format. FACT ORDER_COST ID NUMBER The BigQuery identifier of the order. FACT ORDER_COST MARGIN_PERCENTAGE NUMBER 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 FACT ORDER_COST NUMBER_OF_UNITS NUMBER The total number of units in the order. FACT ORDER_COST ORDER_COST_KEY NUMBER The primary key value of the  ORDER_COST  row. FACT ORDER_COST ORDER_ID NUMBER The OneStrata-generated identifier of the order. FACT ORDER_COST ORDER_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  ORDER_DETAIL.ORDER_KEY  column. FACT ORDER_COST ORDER_PARTNER_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  ORDER_PARTNER.ORDER_PARTNER_KEY  column. FACT ORDER_COST ORDER_UID VARCHAR The GUID of the order. FACT ORDER_COST OTHER_INCOME_AMOUNT_AC NUMBER 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 FACT ORDER_COST OTHER_INCOME_AMOUNT_CC NUMBER 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 FACT ORDER_COST OTHER_INCOME_AMOUNT_VC NUMBER 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 FACT ORDER_COST PAYEE_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  PAYEE.PAYEE_KEY  column. FACT ORDER_COST PRE_ACTUALIZED_GROSS_COST_VC NUMBER 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. FACT ORDER_COST PRE_ACTUALIZED_NET_COST_VC NUMBER 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. FACT ORDER_COST RATE_TYPE VARCHAR The rate type of the Cost Line, as an ID value. Possible values: For a list of possible rate types, see  Rate Type Reference . FACT ORDER_COST SUPPLIER_KEY NUMBER A foreign key in the  ORDER_COST  view that references the  SUPPLIER.SUPPLIER_KEY  column. FACT ORDER_COST VENDOR_DISCOUNT_AMOUNT_AC NUMBER 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 FACT ORDER_COST VENDOR_DISCOUNT_AMOUNT_CC NUMBER 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 FACT ORDER_COST VENDOR_DISCOUNT_AMOUNT_VC NUMBER 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 FACT ORDER_COST VENDOR_DISCOUNT_CONTRACT_UID VARCHAR 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. FACT ORDER_COST VENDOR_DISCOUNT_PERCENTAGE NUMBER 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. FACT ORDER_COST VENDOR_DISCOUNT_RULE ARRAY 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. FACT ORDER_COST VENDOR_GROSS_AMOUNT_AC NUMBER 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 FACT ORDER_COST VENDOR_GROSS_AMOUNT_CC NUMBER 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 FACT ORDER_COST VENDOR_GROSS_AMOUNT_VC NUMBER 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 FACT ORDER_COST VENDOR_GROSS_RATE_AC NUMBER 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 FACT ORDER_COST VENDOR_GROSS_RATE_CC NUMBER 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 FACT ORDER_COST VENDOR_GROSS_RATE_VC NUMBER 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 FACT ORDER_COST VENDOR_NET_AMOUNT_AC NUMBER 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 FACT ORDER_COST VENDOR_NET_AMOUNT_CC NUMBER 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 FACT ORDER_COST VENDOR_NET_AMOUNT_VC NUMBER 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 FACT ORDER_COST VENDOR_NET_RATE_AC NUMBER 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 FACT ORDER_COST VENDOR_NET_RATE_CC NUMBER 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 FACT ORDER_COST VENDOR_NET_RATE_VC NUMBER 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 FACT ORDER_COST VENDOR_TAX_AMOUNT_AC NUMBER 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 FACT ORDER_COST VENDOR_TAX_AMOUNT_CC NUMBER 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 FACT ORDER_COST VENDOR_TAX_AMOUNT_VC NUMBER 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 FACT ORDER_COST VENDOR_TAX_CONTRACT_UID VARCHAR For future use. FACT ORDER_COST VENDOR_TAX_PERCENTAGE NUMBER 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. FACT ORDER_COST VENDOR_TAX_RULE ARRAY The Vendor Tax record applied to this Cost Line, as a dictionary inside an array. FACT ORDER_COST VENDOR_TAX_SET_UP_KEY NUMBER 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. FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_AMOUNT_AC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_AMOUNT_CC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_AMOUNT_VC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_CONTRACT_UID VARCHAR For future use. FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_PERCENTAGE NUMBER For future use. FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_RATE_AC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_RATE_CC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_RATE_VC NUMBER 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 FACT ORDER_COST VENDOR_TOTAL_WITH_TAX_RULE ARRAY For future use. DIMENSION ORDER_DETAIL _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ORDER_DETAIL  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_DETAIL _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION ORDER_DETAIL _IS_ACTIVE BOOLEAN For future use. DIMENSION ORDER_DETAIL AGENCY_CURRENCY_CODE VARCHAR The Agency Currency of the order, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL AGENCY_CURRENCY_NAME VARCHAR The Agency Currency of the order. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL AGENCY_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  AGENCY.AGENCY_KEY  column. DIMENSION ORDER_DETAIL AGENCY_TO_CLIENT_EXCHANGERATE NUMBER The exchange rate from the Agency Currency to the Client Currency. DIMENSION ORDER_DETAIL AGENCY_UID VARCHAR The GUID of the Agency that this order is for. DIMENSION ORDER_DETAIL APPROVAL_COMPLETED_AT TIMESTAMP_NTZ(9) 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. DIMENSION ORDER_DETAIL APPROVAL_EMAIL_RECIPIENT VARCHAR The email address of the person who was requested to approve this order. DIMENSION ORDER_DETAIL APPROVAL_REQUESTED_AT TIMESTAMP_NTZ(9) The date and time that the most recent approval request for this order was sent, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_DETAIL APPROVAL_STATUS_ID NUMBER The confirmation/approval status of the order, as an ID value. Possible values: 0 : New 1 : AwaitingConfirmation 2 : AwaitingCancellation 3 : AmendedAwaitingConfirmation 4 : Confirmed 5 : Declined 6 : Cancelled 7 : UnSent 8 : UnSentCancellation 9 : None DIMENSION ORDER_DETAIL APPROVAL_STATUS_TEXT VARCHAR 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 DIMENSION ORDER_DETAIL APPROVAL_VERSION NUMBER The version number of the order. DIMENSION ORDER_DETAIL CAMPAIGN_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  CAMPAIGN.CAMPAIGN_KEY  column. DIMENSION ORDER_DETAIL CLIENT_CURRENCY_CODE VARCHAR The Client Currency of the order, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL CLIENT_CURRENCY_NAME VARCHAR The Client Currency of the order. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL CLIENT_GROSS_RATE_AC NUMBER See  ORDER_COST.CLIENT_GROSS_RATE_AC . DIMENSION ORDER_DETAIL CLIENT_GROSS_RATE_CC NUMBER See  ORDER_COST.CLIENT_GROSS_RATE_CC . DIMENSION ORDER_DETAIL CLIENT_ID NUMBER The OneStrata identifier of the Client that this order is for. DIMENSION ORDER_DETAIL CLIENT_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION ORDER_DETAIL CLIENT_NET_RATE_AC NUMBER See  ORDER_COST.CLIENT_NET_RATE_AC . DIMENSION ORDER_DETAIL CLIENT_NET_RATE_CC NUMBER See  ORDER_COST.CLIENT_NET_RATE_CC . DIMENSION ORDER_DETAIL CLIENT_NET_RATE_VC NUMBER See  ORDER_COST.CLIENT_NET_RATE_VC . DIMENSION ORDER_DETAIL CLIENT_UID VARCHAR The GUID of the Client that this order is for. DIMENSION ORDER_DETAIL CONTRACT_UID VARCHAR The GUID of the Contract associated with this order. DIMENSION ORDER_DETAIL COST_CATEGORY_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  COST_CATEGORY.COST_CATEGORY  column. DIMENSION ORDER_DETAIL COST_LINE_COST_CATEGORY_UID VARCHAR The GUID of the cost category of this Cost Line. DIMENSION ORDER_DETAIL COST_LINE_COST_METHOD NUMBER The cost method of the Cost Line, as an ID value. Possible values: 0 : Standard 1 : Margin 2 : Allocated DIMENSION ORDER_DETAIL COST_LINE_COST_METHOD_TEXT VARCHAR 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. DIMENSION ORDER_DETAIL COST_LINE_CREATION_TYPE NUMBER Whether the Cost Line was manually created or generated, as an ID value. Possible values: 0 : Manually 1 : Generated DIMENSION ORDER_DETAIL COST_LINE_CUSTOM_FIELDS ARRAY The names and values of any Cost Line-level custom data fields, as a dictionary inside an array. DIMENSION ORDER_DETAIL COST_LINE_DISTRIBUTION_METHOD NUMBER The cost distribution setting of the Cost Line, as an ID value. Possible values: 0 : ProRata 1 : Even 2 : Custom DIMENSION ORDER_DETAIL COST_LINE_DISTRIBUTION_METHOD_TEXT VARCHAR 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. DIMENSION ORDER_DETAIL COST_LINE_END_DATE DATE The end date of the Cost Line, in yyyy-MM-dd format. DIMENSION ORDER_DETAIL COST_LINE_GROUPING NUMBER The grouping structure of the Cost Line, as an ID value. Possible values: 0 : Single 1 : Package 2 : NoMediaLine DIMENSION ORDER_DETAIL COST_LINE_GROUPING_TEXT VARCHAR 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. DIMENSION ORDER_DETAIL COST_LINE_ID NUMBER The OneStrata-generated identifier of the Cost Line. DIMENSION ORDER_DETAIL COST_LINE_NAME VARCHAR The name of the Cost Line. DIMENSION ORDER_DETAIL COST_LINE_RATE_MULTIPLIER NUMBER The rate divider of the Cost Line's rate type. Possible values: For a list of possible rate types, see  Rate Type Reference . DIMENSION ORDER_DETAIL COST_LINE_RATE_TEXT VARCHAR The rate type of the Cost Line. Possible values: For a list of possible rate types, see  Rate Type Reference . DIMENSION ORDER_DETAIL COST_LINE_RATE_TYPE VARCHAR 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 . DIMENSION ORDER_DETAIL COST_LINE_START_DATE DATE The start date of the Cost Line, in yyyy-MM-dd format. DIMENSION ORDER_DETAIL COST_LINE_SUPPLIER_UID VARCHAR The GUID of the Supplier of this Cost Line. DIMENSION ORDER_DETAIL CUSTOM_FIELDS ARRAY The names and values of any order-level custom data data fields, as a dictionary inside an array. DIMENSION ORDER_DETAIL DATA_TEXT VARCHAR 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. DIMENSION ORDER_DETAIL DATA_TYPE NUMBER Whether the Supplier of the order is a media or non-media Supplier, as an ID value. Possible values: 0 : Media 1 : NonMedia DIMENSION ORDER_DETAIL ESTIMATE_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  ESTIMATE.ESTIMATE  column. DIMENSION ORDER_DETAIL EXPORT_MESSAGE VARCHAR For future use. DIMENSION ORDER_DETAIL EXPORT_STATUS VARCHAR 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 DIMENSION ORDER_DETAIL EXPORT_STATUS_TEXT VARCHAR 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. DIMENSION ORDER_DETAIL EXTERNAL_LINK_ID VARCHAR For a linked Cost Line, the external integration provider's identifier for the entity linked to the Cost Line. DIMENSION ORDER_DETAIL EXTERNAL_LINK_IS_ACTIVE BOOLEAN Whether or not the Cost Line is linked to an external entity. DIMENSION ORDER_DETAIL EXTERNAL_LINK_STATUS VARCHAR 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 DIMENSION ORDER_DETAIL EXTERNAL_LINK_SYSTEM_GROUP VARCHAR For a linked Cost Line, the provider type of the external integration provider. Possible values: DSP (Demand-Side Platform) Search Platform Social Platform DIMENSION ORDER_DETAIL EXTERNAL_LINK_SYSTEM_TYPE VARCHAR 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 DIMENSION ORDER_DETAIL EXTERNAL_LINK_TYPE VARCHAR 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. DIMENSION ORDER_DETAIL ID NUMBER The OneStrata-generated identifier of the order. DIMENSION ORDER_DETAIL IS_REGULATED BOOLEAN Whether or not the order is regulated. DIMENSION ORDER_DETAIL LAST_MODIFIED_BY VARCHAR The first and last name of the user who last modified this order. DIMENSION ORDER_DETAIL LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the order was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_DETAIL MEDIA_ID NUMBER The OneStrata identifier of the Media Type assigned to the campaign that this order is for. DIMENSION ORDER_DETAIL MEDIA_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  MEDIA.MEDIA_KEY  column. DIMENSION ORDER_DETAIL ORDER_KEY NUMBER The primary key value of the  ORDER_DETAIL  row. DIMENSION ORDER_DETAIL ORDER_PARTNER_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  ORDER_PARTNER.ORDER_PARTNER_KEY  column. DIMENSION ORDER_DETAIL ORDER_PARTNER_UID VARCHAR The GUID of the Order Partner of this order. DIMENSION ORDER_DETAIL PAYEE_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  PAYEE.PAYEE_KEY  column. DIMENSION ORDER_DETAIL PAYEE_UID VARCHAR The GUID of the Payee of this order. DIMENSION ORDER_DETAIL STATUS NUMBER The status of the order, as an ID value. Possible values: 0 : Active 1 : Cancelled DIMENSION ORDER_DETAIL SUPPLIER_CURRENCY_CODE VARCHAR The Vendor Currency of the order, as a three-letter ISO currency code. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL SUPPLIER_CURRENCY_NAME VARCHAR The Vendor Currency of the order. Possible values: For a list of possible currencies, see  Currency Reference . DIMENSION ORDER_DETAIL SUPPLIER_KEY NUMBER A foreign key in the  ORDER_DETAIL  view that references the  SUPPLIER.SUPPLIER_KEY  column. DIMENSION ORDER_DETAIL UID VARCHAR The GUID of the order. DIMENSION ORDER_DETAIL VENDOR_GROSS_RATE_AC NUMBER See  ORDER_COST.VENDOR_GROSS_RATE_AC . DIMENSION ORDER_DETAIL VENDOR_GROSS_RATE_CC NUMBER See  ORDER_COST.VENDOR_GROSS_RATE_CC . DIMENSION ORDER_DETAIL VENDOR_GROSS_RATE_VC NUMBER See  ORDER_COST.VENDOR_GROSS_RATE_VC . DIMENSION ORDER_DETAIL VENDOR_NET_RATE_AC NUMBER See  ORDER_COST.VENDOR_NET_RATE_AC . DIMENSION ORDER_DETAIL VENDOR_NET_RATE_CC NUMBER See  ORDER_COST.VENDOR_NET_RATE_CC . DIMENSION ORDER_DETAIL VENDOR_NET_RATE_VC NUMBER See  ORDER_COST.VENDOR_NET_RATE_VC . DIMENSION ORDER_DETAIL VENDOR_TO_AGENCY_EXCHANGERATE NUMBER The exchange rate from the Vendor Currency to the Agency Currency. DIMENSION ORDER_DETAIL VERSION NUMBER The version number of the order. DIMENSION ORDER_PARTNER _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ORDER_PARTNER  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_PARTNER _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION ORDER_PARTNER _IS_ACTIVE BOOLEAN For future use. DIMENSION ORDER_PARTNER ADDRESSES ARRAY The billing address of the Order Partner, as a dictionary inside an array. DIMENSION ORDER_PARTNER APPROVAL_CONFIRMATION VARCHAR 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. DIMENSION ORDER_PARTNER CODE VARCHAR A code or phrase that represents the Order Partner, typically used for billing or reporting. DIMENSION ORDER_PARTNER CONTACT_ADDRESS VARCHAR The address of the Order Partner contact. DIMENSION ORDER_PARTNER CONTACT_EMAIL VARCHAR The email address of the Order Partner contact. DIMENSION ORDER_PARTNER CONTACT_NAME VARCHAR The name of the Order Partner contact. DIMENSION ORDER_PARTNER CONTACT_TELEPHONE VARCHAR The telephone number of the Order Partner contact. DIMENSION ORDER_PARTNER CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Order Partner record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_PARTNER ENTERPRISE_ID NUMBER The OneStrata identifier of the enterprise that this Order Partner is in. DIMENSION ORDER_PARTNER ENTERPRISE_KEY NUMBER A foreign key in the  ORDER_PARTNER  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION ORDER_PARTNER ID NUMBER The OneStrata-generated identifier of the Order Partner. DIMENSION ORDER_PARTNER IS_ACTIVE BOOLEAN Whether or not the Order Partner record is active. DIMENSION ORDER_PARTNER LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Order Partner record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ORDER_PARTNER LOCAL_NAME VARCHAR The localized name of the Order Partner. DIMENSION ORDER_PARTNER LOGO_URL VARCHAR A URL to a page or file that hosts the Order Partner's logo. DIMENSION ORDER_PARTNER MARKET VARCHAR The market where the Order Partner runs its media activity, DIMENSION ORDER_PARTNER NAME VARCHAR The name of the Order Partner. DIMENSION ORDER_PARTNER ORDER_PARTNER_KEY NUMBER The primary key value of the  ORDER_PARTNER  row. DIMENSION ORDER_PARTNER UID VARCHAR The GUID of the Order Partner. DIMENSION ORDER_PARTNER VERSION NUMBER The version number of the Order Partner record. DIMENSION PAYEE _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  PAYEE  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PAYEE _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION PAYEE _IS_ACTIVE BOOLEAN For future use. DIMENSION PAYEE ADDRESSES ARRAY The billing address of the Payee, as a dictionary inside an array. DIMENSION PAYEE CODE VARCHAR A code or phrase that represents the Payee, typically used for billing or reporting. DIMENSION PAYEE COMPANY_REG_NUMBER VARCHAR The registration number of the Payee. DIMENSION PAYEE CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Payee record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PAYEE CUSTOM_FIELDS ARRAY The names and values of any Payee-level custom fields, as a dictionary inside an array. DIMENSION PAYEE ENTERPRISE_ID NUMBER The OneStrata identifier of the enterprise that this Payee is in. DIMENSION PAYEE ENTERPRISE_KEY NUMBER A foreign key in the  PAYEE  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION PAYEE EXTERNAL_ID VARCHAR The identifier of the Payee in an external, non-OneStrata system. DIMENSION PAYEE ID NUMBER The OneStrata-generated identifier of the Payee. DIMENSION PAYEE IS_ACTIVE BOOLEAN Whether or not the Payee record is active. DIMENSION PAYEE LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Payee record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PAYEE LEGAL_NAME VARCHAR The legal name of the Payee. DIMENSION PAYEE LOCAL_NAME VARCHAR The localized name of the Payee. DIMENSION PAYEE NAME VARCHAR The name of the Payee. DIMENSION PAYEE NOTES VARCHAR Additional information about the Payee. DIMENSION PAYEE PAYEE_KEY NUMBER The primary key value of the  PAYEE  row. DIMENSION PAYEE TAX_GROUP_KEY NUMBER A foreign key in the  PAYEE  view that references the  TAX.TAX_GROUP_KEY  column. DIMENSION PAYEE UID VARCHAR The GUID of the Payee. DIMENSION PAYEE VERSION NUMBER The version number of the Payee record. DIMENSION PREFERRED_VENDOR _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  PREFERRED_VENDOR  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PREFERRED_VENDOR _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION PREFERRED_VENDOR _IS_ACTIVE BOOLEAN For future use. DIMENSION PREFERRED_VENDOR CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Preferred Vendor record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PREFERRED_VENDOR ENTERPRISE_KEY NUMBER A foreign key in the  PREFERRED_VENDOR  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION PREFERRED_VENDOR ID NUMBER The OneStrata-generated identifier of the Preferred Vendor record. DIMENSION PREFERRED_VENDOR IS_ACTIVE BOOLEAN Whether or not the Preferred Vendor record is active. DIMENSION PREFERRED_VENDOR LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Preferred Vendor record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PREFERRED_VENDOR MEDIA_KEY NUMBER A foreign key in the  PREFERRED_VENDOR  view that references the  MEDIA.MEDIA_KEY  column. DIMENSION PREFERRED_VENDOR PAYEE_KEY NUMBER A foreign key in the  PREFERRED_VENDOR  view that references the  PAYEE.PAYEE_KEY  column. DIMENSION PREFERRED_VENDOR PREFERRED_VENDOR_KEY NUMBER The primary key value of the  PREFERRED_VENDOR  row. DIMENSION PREFERRED_VENDOR SUPPLIER_KEY NUMBER A foreign key in the  PREFERRED_VENDOR  view that references the  SUPPLIER.SUPPLIER_KEY  column. DIMENSION PREFERRED_VENDOR UID VARCHAR The GUID of the Preferred Vendor. DIMENSION PREFERRED_VENDOR VALID_FROM TIMESTAMP_NTZ(9) The start date and time of the Preferred Vendor record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PREFERRED_VENDOR VALID_TO TIMESTAMP_NTZ(9) The end date and time of the Preferred Vendor record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  PRODUCT  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION PRODUCT _IS_ACTIVE BOOLEAN For future use. DIMENSION PRODUCT ADDRESSES ARRAY The billing address of the Product, as a dictionary inside an array. DIMENSION PRODUCT AGENCY_ID NUMBER The OneStrata identifier of the Agency that this Product belongs to. DIMENSION PRODUCT BUSINESS_UNIT_ID NUMBER The OneStrata identifier of the Business Unit that this Product belongs to. DIMENSION PRODUCT CLIENT_ID NUMBER The OneStrata identifier of the Client that this Product belongs to. DIMENSION PRODUCT CLIENT_KEY NUMBER A foreign key in the  PRODUCT  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION PRODUCT CODE VARCHAR A code or phrase that represents the Product, typically used for billing or reporting. DIMENSION PRODUCT CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Product record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT EXTERNAL_ID VARCHAR The identifier of the Product in an external, non-OneStrata system. DIMENSION PRODUCT GROUP_ADDRESSES ARRAY The billing address of the Product Group, as a dictionary inside an array. DIMENSION PRODUCT GROUP_CLIENT_ID NUMBER The OneStrata identifier of the Client that this Product Group belongs to. DIMENSION PRODUCT GROUP_CODE VARCHAR A code or phrase that represents the Product Group, typically used for billing or reporting. DIMENSION PRODUCT GROUP_CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Product Group record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT GROUP_EXTERNAL_ID VARCHAR The identifier of the Product Group in an external, non-OneStrata system. DIMENSION PRODUCT GROUP_ID NUMBER The OneStrata-generated identifier of the Product Group. DIMENSION PRODUCT GROUP_IS_ACTIVE BOOLEAN Whether or not the Product Group record is active. DIMENSION PRODUCT GROUP_LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Product Group record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT GROUP_LOCAL_NAME VARCHAR The localized name of the Product Group. DIMENSION PRODUCT GROUP_LOGO_URL VARCHAR A URL to a page or file that hosts the Product Group's logo. DIMENSION PRODUCT GROUP_NAME VARCHAR The name of the product group. DIMENSION PRODUCT GROUP_OFFICIAL_NAME VARCHAR The legal name of the Product Group. DIMENSION PRODUCT GROUP_SHORT_NAME VARCHAR A shortened or alternate version of the Product Group's name, typically used for fields with character length limits. DIMENSION PRODUCT GROUP_UID VARCHAR The GUID of the Product Group. DIMENSION PRODUCT GROUP_VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION PRODUCT GROUP_VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION PRODUCT ID NUMBER The OneStrata-generated identifier of the Product. DIMENSION PRODUCT IS_ACTIVE BOOLEAN Whether or not the Product record is active. DIMENSION PRODUCT LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Product record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PRODUCT LOCAL_NAME VARCHAR The localized name of the Product. DIMENSION PRODUCT LOGO_URL VARCHAR A URL to a page or file that hosts the Product's logo. DIMENSION PRODUCT NAME VARCHAR The name of the Product. DIMENSION PRODUCT OFFICIAL_NAME VARCHAR The legal name of the Product. DIMENSION PRODUCT PRODUCT_KEY NUMBER The primary key value of the  PRODUCT  row. DIMENSION PRODUCT SHORT_CODE VARCHAR A shortened or alternate version of the Product's code, typically used for fields with character length limits. DIMENSION PRODUCT SHORT_NAME VARCHAR A shortened or alternate version of the Product's name, typically used for fields with character length limits. DIMENSION PRODUCT UID VARCHAR The GUID of the Product. DIMENSION PRODUCT VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION PRODUCT VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION PURCHASE_ORDER _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  PURCHASE_ORDER  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION PURCHASE_ORDER _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION PURCHASE_ORDER _IS_ACTIVE BOOLEAN For future use. DIMENSION PURCHASE_ORDER AGENCY_UID VARCHAR The GUID of the Agency associated with this purchase order. DIMENSION PURCHASE_ORDER BUSINESS_UNIT_UID VARCHAR The GUID of the Business Unit associated with this purchase order. DIMENSION PURCHASE_ORDER CLIENT_KEY NUMBER A foreign key in the  PURCHASE_ORDER  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION PURCHASE_ORDER CLIENT_UID VARCHAR The GUID of the Client associated with this purchase order. DIMENSION PURCHASE_ORDER ENTERPRISE_UID VARCHAR The GUID of the enterprise that this purchase order is in. DIMENSION PURCHASE_ORDER ID NUMBER The OneStrata-generated identifier of the purchase order. DIMENSION PURCHASE_ORDER MEDIA_UID VARCHAR The GUID of the Media Type associated with this purchase order. DIMENSION PURCHASE_ORDER PRODUCT_UID VARCHAR The GUID of the Product associated with this purchase order. DIMENSION PURCHASE_ORDER PURCHASE_ORDER_KEY NUMBER The primary key value of the  PURCHASE_ORDER  view. DIMENSION PURCHASE_ORDER REFERENCE VARCHAR The reference number of the purchase order. DIMENSION PURCHASE_ORDER UID VARCHAR The GUID of the purchase order. DIMENSION ROLE_PERMISSION _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  ROLE_PERMISSION  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ROLE_PERMISSION _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION ROLE_PERMISSION _IS_ACTIVE BOOLEAN For future use. DIMENSION ROLE_PERMISSION CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the User Role record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ROLE_PERMISSION ENTERPRISE_KEY NUMBER A foreign key in the  ROLE_PERMISSION  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION ROLE_PERMISSION ENTERPRISE_UID VARCHAR The GUID of the enterprise that this user role is in. DIMENSION ROLE_PERMISSION IS_ACTIVE BOOLEAN Whether or not the User Role record is active. DIMENSION ROLE_PERMISSION LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the User Role record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION ROLE_PERMISSION PERMISSION_ID NUMBER The OneStrata-generated identifier of the user role permission. DIMENSION ROLE_PERMISSION PERMISSION_NAME VARCHAR The name of the user role permission. DIMENSION ROLE_PERMISSION ROLE_NAME VARCHAR The name of the user role. DIMENSION ROLE_PERMISSION ROLE_PERMISSION_KEY NUMBER The primary key value of the  ROLE_PERMISSION  row. DIMENSION ROLE_PERMISSION ROLE_UID VARCHAR The GUID of the user role. DIMENSION SUPPLIER _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  SUPPLIER  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION SUPPLIER _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION SUPPLIER _IS_ACTIVE BOOLEAN For future use. DIMENSION SUPPLIER ADDRESSES ARRAY The legal address of the Supplier, as a dictionary inside an array. DIMENSION SUPPLIER CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Supplier record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION SUPPLIER ENTERPRISE_ID NUMBER The OneStrata identifier of the enterprise that this Supplier is in. DIMENSION SUPPLIER ENTERPRISE_KEY NUMBER A foreign key in the  SUPPLIER  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION SUPPLIER ID NUMBER The OneStrata-generated identifier of the Supplier. DIMENSION SUPPLIER IS_ACTIVE BOOLEAN Whether or not the Supplier record is active. DIMENSION SUPPLIER LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Supplier record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION SUPPLIER LOCAL_NAME VARCHAR The localized name of the Supplier. DIMENSION SUPPLIER LOGO_URL VARCHAR A URL to a page or file that hosts the Supplier's logo. DIMENSION SUPPLIER MEDIA VARIANT An array of dictionaries, where each dictionary represents a Media Type that this Supplier supports. DIMENSION SUPPLIER MEDIA_KEYS ARRAY An array of foreign key values that reference the  MEDIA.MEDIA_KEY column, in the  SUPPLIER  view. DIMENSION SUPPLIER MEDIA_OWNER VARCHAR For future use. DIMENSION SUPPLIER NAME VARCHAR The name of the Supplier. DIMENSION SUPPLIER NOTES VARCHAR Additional information about the Supplier. DIMENSION SUPPLIER SHORT_NAME VARCHAR A shortened or alternate version of the Supplier's name, typically used for fields with character length limits. DIMENSION SUPPLIER SUPPLIER_GROUP VARCHAR For future use. DIMENSION SUPPLIER SUPPLIER_KEY NUMBER The primary key value of the  SUPPLIER  row. DIMENSION SUPPLIER SUPPLIER_TYPE VARCHAR 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. DIMENSION SUPPLIER UID VARCHAR The GUID of the Supplier. DIMENSION SUPPLIER VERSION NUMBER The version number of the Supplier record. DIMENSION TAX _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  TAX  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION TAX _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION TAX _IS_ACTIVE BOOLEAN For future use. DIMENSION TAX ALTERNATE_TAX_OPTION_ID NUMBER The OneStrata identifier of the Alternate Tax Option assigned to this Tax record. DIMENSION TAX ALTERNATE_TAX_OPTION_NAME VARCHAR The name of the Alternate Tax Option assigned to this Tax record. DIMENSION TAX CLIENT_TAX_1_APPLIES_TO VARCHAR For a Client Tax record, the cost type that the client tax rate applies to. Possible values: VendorGross VendorNet ClientGross ClientNet ClientGrossAndCommission ClientNetAndCommission CommissionOnly DIMENSION TAX CLIENT_TAX_1_RATE NUMBER For a Client Tax record, the client tax rate as a decimal. DIMENSION TAX CLIENT_TAX_1_TYPE VARCHAR 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). DIMENSION TAX DISCRIMINATOR VARCHAR 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. DIMENSION TAX ENTERPRISE_KEY NUMBER A foreign key in the  TAX  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION TAX GROUP_KEY NUMBER 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 ). DIMENSION TAX ID NUMBER The OneStrata-generated identifier of the Tax record. DIMENSION TAX TAX_CATEGORY_CLIENT_CREATED_DATE_TIME TIMESTAMP_NTZ(9) 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. DIMENSION TAX TAX_CATEGORY_CLIENT_EXTERNAL_ID VARCHAR For a Client Tax record, the identifier of the Tax Category assigned to this Tax record in an external, non-OneStrata system. DIMENSION TAX TAX_CATEGORY_CLIENT_ID NUMBER For a Client Tax record, the OneStrata identifier of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CATEGORY_CLIENT_LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) 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. DIMENSION TAX TAX_CATEGORY_CLIENT_NAME VARCHAR For a Client Tax record, the name of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CATEGORY_CLIENT_UID VARCHAR For a Client Tax record, the GUID of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CATEGORY_EXTERNAL_ID VARCHAR 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. DIMENSION TAX TAX_CATEGORY_VENDOR_CREATED_DATE_TIME TIMESTAMP_NTZ(9) 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. DIMENSION TAX TAX_CATEGORY_VENDOR_EXTERNAL_ID VARCHAR For a Vendor Tax record, the identifier of the Tax Category assigned to this Tax record in an external, non-OneStrata system. DIMENSION TAX TAX_CATEGORY_VENDOR_ID NUMBER For a Vendor Tax record, the OneStrata identifier of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CATEGORY_VENDOR_LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) 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. DIMENSION TAX TAX_CATEGORY_VENDOR_NAME VARCHAR For a Vendor Tax record, the name of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CATEGORY_VENDOR_UID VARCHAR For a Vendor Tax record, the GUID of the Tax Category assigned to this Tax record. DIMENSION TAX TAX_CODE VARCHAR A code or phrase that represents the Tax record, typically used for billing or reporting. DIMENSION TAX TAX_KEY NUMBER The primary key value of the  TAX  row. DIMENSION TAX TAX_TYPE VARCHAR 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. DIMENSION TAX UID VARCHAR The GUID of the Tax record. DIMENSION TAX VALID_FROM TIMESTAMP_NTZ(9) 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. DIMENSION TAX VALID_TO TIMESTAMP_NTZ(9) 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. DIMENSION TAX VENDOR_TAX_1_APPLIES_TO VARCHAR For a Vendor Tax record, the cost type that the vendor tax rate applies to. Possible values: VendorGross VendorNet DIMENSION TAX VENDOR_TAX_1_RATE NUMBER For a Vendor Tax record, the vendor tax rate as a decimal. DIMENSION TAX VENDOR_TAX_1_TYPE VARCHAR 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). DIMENSION TERMS_AND_CONDITION _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  TERMS_AND_CONDITION  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION TERMS_AND_CONDITION _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION TERMS_AND_CONDITION _IS_ACTIVE BOOLEAN For future use. DIMENSION TERMS_AND_CONDITION AGENCY_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  AGENCY.AGENCY_KEY  column. DIMENSION TERMS_AND_CONDITION BUSINESS_UNIT_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  BUSINESS_UNIT.BUSINESS_UNIT_KEY  column. DIMENSION TERMS_AND_CONDITION CLIENT_GROUP_ID NUMBER The OneStrata identifier of the Client Group assigned to this Terms & Conditions record. DIMENSION TERMS_AND_CONDITION CLIENT_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  CLIENT.CLIENT_KEY  column. DIMENSION TERMS_AND_CONDITION CONTENT VARCHAR The text contents of a manually entered Terms & Conditions record. DIMENSION TERMS_AND_CONDITION CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Terms & Conditions record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION TERMS_AND_CONDITION ENTERPRISE_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION TERMS_AND_CONDITION ID NUMBER The OneStrata-generated identifier of the Terms & Conditions record. DIMENSION TERMS_AND_CONDITION LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the Terms & Conditions record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION TERMS_AND_CONDITION MEDIA_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  MEDIA.MEDIA_KEY  column. DIMENSION TERMS_AND_CONDITION NAME VARCHAR The name of the Terms & Conditions record. DIMENSION TERMS_AND_CONDITION ORDER_PARTNER_KEY NUMBER A foreign key in the  TERMS_AND_CONDITION  view that references the  ORDER_PARTNER.ORDER_PARTNER_KEY  column. DIMENSION TERMS_AND_CONDITION TERMS_AND_CONDITION_KEY NUMBER The primary key value of the  TERMS_AND_CONDITION  row. DIMENSION TERMS_AND_CONDITION TERMS_AND_CONDITION_TYPE NUMBER 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) DIMENSION TERMS_AND_CONDITION UID VARCHAR The GUID of the Terms & Conditions record. DIMENSION USER _ACTIVE_FROM TIMESTAMP_NTZ(9) The date and time that this row was added to the  USER  view, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION USER _ACTIVE_TO TIMESTAMP_NTZ(9) For future use. DIMENSION USER _IS_ACTIVE BOOLEAN For future use. DIMENSION USER CREATED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the User record was created, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION USER EMAIL VARCHAR The email address of the user. DIMENSION USER ENTERPRISE_KEY NUMBER A foreign key in the  USER  view that references the  ENTERPRISE.ENTERPRISE_KEY  column. DIMENSION USER ENTERPRISE_UID VARCHAR The GUID of the enterprise that this user is in. DIMENSION USER FINANCE_INITIALS VARCHAR The finance initials of the user. DIMENSION USER FIRST_NAME VARCHAR The first name of the user. DIMENSION USER GROUP_UIDS ARRAY For future use. DIMENSION USER ID NUMBER The OneStrata-generated identifier of the user. DIMENSION USER IS_ACTIVE BOOLEAN Whether or not the User record is active. DIMENSION USER JOB_TITLE VARCHAR The job title of the user. DIMENSION USER LAST_MODIFIED_DATE_TIME TIMESTAMP_NTZ(9) The date and time that the User record was last modified, in yyyy-MM-ddTHH:mm:ss.SSSZ format. DIMENSION USER LAST_NAME VARCHAR The last name of the user. DIMENSION USER PHONE_NUMBER VARCHAR The phone number of the user. DIMENSION USER REPORTS_ANALYTICS VARCHAR 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. DIMENSION USER ROLE_UID VARCHAR The GUID of the user account's user role. DIMENSION USER UID VARCHAR The GUID of the user. DIMENSION USER USER_KEY NUMBER The primary key value of the  USER  row. DIMENSION USER USER_TYPES ARRAY The user type of the user account, as an array. Possible values: ["Agency"] : The user account is an Agency user. ["Seller"] : The user account is a Seller user. DIMENSION USER VALID_FROM TIMESTAMP_NTZ(9) The start date and time of the User record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. Note: A user account can only be accessed (logged in to) during the User record's validity period. DIMENSION USER VALID_TO TIMESTAMP_NTZ(9) The end date and time of the User record's validity period, in yyyy-MM-ddTHH:mm:ss.SSSZ format. Note: A user account can only be accessed (logged in to) during the User record's validity period. DIMENSION USER VERSION NUMBER The version number of the User record.