Actualization Tab UI Elements

The Actualization tab displays information related to actualizing committed Cost Lines.

The Actualization tab contains the following elements:

	Item	Description
1	Campaign Header
2	Standard and Margin selection	Click to switch between the Standard Actualization grid and the Margin Actualization grid.
3	Filters icon	Click the Filters icon to open the filter pane and filter through the list of all committed Cost Lines within the campaign.
4	Search bar	Search for a Cost Line by Entity (Supplier or Order Partner) or ID.
5	Roll settings	Click the Roll settings to select how any under- or over-delivery balance is carried over to future months: None: The balance is not distributed. Instead, the overall totals on the Schedule Grid line are updated Proportionally: The balance is evenly distributed over the remaining months of the campaign Next Month: The entire balance is carried over to the next month of the campaign Last Month: The entire balance is carried over to the final month of the campaign See: Types of Delivery Balance Roll
6	Apply Source button The Apply Source button is only available on the Standard Actualization grid.	Click the Apply Source button to overwrite the Schedule grid's Actual Cost for Period, Actual Rate, and Actual Units column values: Committed: The values of the Actual columns are reset to the media schedule values Site: The values of the Actual columns are updated to match the values of the Site columns 3rd Party: The values of the Actual columns are updated to match the values of the 3rd Party columns
7	Actualize button	If no Actualization grid lines are selected, the Actualize button is inactive. If one or more Actualization grid lines are selected, the Actualize button is active. Click the Actualize button to actualize the selected lines.
8	Billing Period(s) filter	Click the Billing Period(s) filter to select the billing periods that are displayed in the Actualization grid. By default, only one billing period (month) is selected and displayed on the Actualization grid. If the campaign is in-flight, the default billing period is the previous month of the campaign If the campaign has not started yet, the default billing period is the first month of the campaign If the campaign has already finished, the default billing period is the last month of the campaign
9	Actualization grid	A list of a campaign's committed Cost Lines, grouped by order and broken down into selected billing periods. For more information, see Actualization Grid Reference.

Actualization Grid Reference

The Actualization grid is a list of a campaign's committed Cost Lines, grouped by order and broken down into the selected billing period(s). By default, only one billing period (month) is selected:

If the campaign is in-flight, the default billing period is the previous month of the campaign
If the campaign has not started yet, the default billing period is the first month of the campaign
If the campaign has already finished, the default billing period is the last month of the campaign

There are two types of Actualization grids:

Standard Actualization grid: Used to actualize standard Cost Lines
Margin Actualization grid: Used to actualize margin Cost Lines

Standard Actualization Grid Reference

The Standard Actualization grid is used to actualize standard Cost Lines, Cost Lines that have a Cost Method value of Standard.

The table below describes the Standard Actualization grid columns:

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

Actualization Grid Type	Column Name	Description	Line Type: Order	Line Type: Cost Line	Line Type: Billing Period
Standard, Margin	Line Type	The type of the Actualization grid line, according to the following hierarchy: Media Order Cost Line (Cost Package, Media Package, Placement) Billing Period Non-Media Order Cost Line (Fee) Billing Period	N/A	N/A	N/A
Standard, Margin	Status (Actualization Status)	The actualization status of the Actualization grid line.	The possible actualization statuses are: Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata		The possible actualization statuses are: Not Actualized: The Billing Period line is not actualized in OneStrata Actualized: The Billing Period line is actualized in OneStrata
Standard, Margin	Invoice Status	The invoice status of the Actualization Grid line.	The possible invoice statuses are: Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced		The possible invoice statuses are: Not Invoiced: The Billing Period line is not invoiced (no invoice has been created for the billing period) Invoiced: The Billing Period line is invoiced (an invoice has been created for the billing period)
Standard, Margin	Entity Name	The name and identification number of the entity associated with the Actualization grid line.	The displayed values are: Order Partner: The name of the Order Partner of the order. Click the Entity Name link to open the Order Details page of the order. Order ID: The OneStrata-generated identification number of the order	The displayed values are: Supplier: The Supplier entity assigned to the Cost Line Cost Line ID: The OneStrata-generated identification number of the Cost Line	This displayed values are: Month & Year: The calendar month and year of the Billing Period line Billing Period ID: The OneStrata-generated identification number of the Billing Period line
Standard, Margin	Line Name	The name of the Actualization grid line.	N/A	The name of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	External ID	The external identification number of the Actualization grid line.	N/A	N/A	The identification number used by the external financial system to reference the Billing Period line. Only available if the Billing Period line has been exported to an external financial system.
Standard, Margin	Start and End Date	The start and end dates of the Actualization grid line.	N/A	The start and end dates of the Cost Line. Copied from the media schedule.	The start and end dates of the Billing Period line. Copied from the media schedule.
Standard, Margin	Contract Total	The total committed vendor cost of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The total committed vendor cost of the entire order. Copied from the order.	The total committed vendor cost of the Cost Line. Copied from the media schedule.	The committed vendor cost of the Billing Period line. Copied from the media schedule.
Standard, Margin	Rate Type	The Rate Type of the Actualization grid line.	N/A	The Rate Type of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The committed vendor rate of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	N/A	The committed vendor rate of the Cost Line. Copied from the media schedule.	The committed vendor rate of the Billing Period line. Copied from the media schedule.
Margin	Client Net Rate (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Rate (VC) of the Actualization grid line.	N/A	The client net rate of the Cost Line. Copied from the media schedule.	The client net rate of the Billing Period line. Copied from the media schedule.
Standard, Margin	Units	The total number of committed units for the Actualization grid line.	The total number of committed units for the entire order.	The total number of committed units for the Cost Line. Copied from the media schedule.	The number of committed units for the Billing Period line. Copied from the media schedule.
Standard, Margin	Current for Period	The committed vendor cost of the Actualization grid line, for the selected billing period(s). Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The committed vendor cost of the order, for the selected billing period(s).	The committed vendor cost of the Cost Line, for the selected billing period(s).	The committed vendor cost of the Billing Period line
Standard, Margin	Pre-Actualized	The pre-actualization vendor cost of the Actualization grid line, for the selected billing period(s). If the line has never been actualized, the Pre-Actualized value is equal to the Current for Period value. Once the line is actualized, the Pre-Actualized value becomes locked and no longer changes, even if the Current for Period value (which is copied from the media schedule) changes. For example, imagine a Cost Line that has never been actualized: Its Current for Period value is $100. Its Pre-Actualized value is set to whatever the Current for Period value is, which is $100. If the Cost line's Current for Period value changes, its Pre-Actualized value also changes. Then, the Cost line is actualized: At the time of actualization, its Current for Period value is $100. The Pre-Actualized value is locked to $100. Afterwards, if the Cost Line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change.	The pre-actualization vendor cost of the order, for the selected billing period(s).	The pre-actualization vendor cost of the Cost Line, for the selected billing period(s).	The pre-actualization vendor cost of the Billing Period line.
Standard, Margin	Balance	The cost balance of the Actualization grid line, for the selected billing period(s). The cost balance is the difference between the Actual Cost for Period (the actualized value) and the Current for Period (the committed value).	The cost balance of the order, for the selected billing period(s).	The cost balance of the Cost Line, for the selected billing period(s).	The cost balance of the Billing Period line.
Standard	Actual Source	The source(s) of the Actualization grid line's Actual Cost for Period, Actual Rate, and Actual Units values. The possible values are: Committed: The values are copied from the media schedule Site: The values are copied from the Site columns 3rd Party: The values are copied from the 3rd Party columns Manual: The user has manually changed one or more values	The source(s) of the actual values of the order.	The source(s) of the actual values of the Cost Line.	The source(s) of the actual values of the Billing Period line.
Standard	Actual Cost for Period This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor cost of the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The actual vendor cost of the order, for the selected billing period(s).	The actual vendor cost of the Cost Line, for the selected billing period(s).	The actual vendor cost of the Billing Period line.
Standard	Actual Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor rate of the Actualization grid line. When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate) If the Actual Source value is Site or 3rd Party, the value of Actual Rate is calculated according to the following formula: Actual Rate = Actual Cost / Actual Units	N/A	The actual vendor rate of the Cost Line.	The actual vendor rate of the Billing Period line.
Standard	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system.	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Standard	Site Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Site source (if any). The possible Site sources are: Vendor Inbox: If the Cost Line is part of an order that was sent to an In-System Order Partner, the Order Partner can send delivery data through Vendor Inbox. An external integration provider DV360 : If the Cost Line is linked to a DV360 insertion order, delivery data is automatically retrieved from DV360 once per day, at around midnight local time. Google Ads: If the Cost Line is linked to a Google Ads campaign, delivery data is automatically retrieved from Google Ads once per day, at around midnight local time. If a Cost Line has delivery data from both Vendor Inbox and an external integration provider, the Site Cost and Site Units columns display the Vendor Inbox values, not the external integration provider values.	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Billing Period line, as retrieved from the Site source.
Standard	Site Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Site source (if any). See Site Cost (above) for more information about Site-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Billing Period line, as retrieved from the Site source.
Standard	3rd Party Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Ad Server provider (if any). If the two conditions below are met, delivery data is automatically retrieved from the Ad Server provider once per day, at around midnight local time: The Cost Line contains one or more Ad Placements that were uploaded to a campaign on the Ad Server provider The Supplier of the Cost Line is mapped to an Ad Server provider site/supplier	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Billing Period line, as retrieved from the Ad Server provider.
Standard	3rd Party Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Ad Server provider (if any). See 3rd Party Cost (above) for more information about 3rd party-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Billing Period line, as retrieved from the Ad Server provider.
Margin	Vendor Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Vendor Net Cost (VC) of the Actualization grid line, for the selected billing period(s).	The vendor net cost of the order, for the selected billing period(s).	The total vendor net cost of the Cost Line, for the selected billing period(s).	The vendor net cost of the Billing Period line.
Margin	Margin % This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Margin % of the Actualization grid line, for the selected billing period(s).	N/A	The average margin percentage of the Cost Line, for the selected billing period(s).	The margin percentage of the Billing Period line.
Margin	Client Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Cost (VC) of the Actualization grid line, for the selected billing periods(s).	N/A	The client net cost of the Cost Line, for the selected billing period(s).	The client net cost of the Billing Period line.
Margin	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s).	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Margin	Other Income (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The margin amount (the difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values) of the Actualization grid line, for the selected billing period(s). Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC)	The margin amount of the order, for the selected billing period(s).	The margin amount of the Cost Line, for the selected billing period(s).	The margin amount of the Billing Period line.
Standard, Margin	Invoiced Amount	The sum of all invoices that have been matched or cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the order, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Billing Period line.
Standard, Margin	Cleared Invoiced Amount	The sum of all invoices that have been cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been cleared against the order, for the selected billing period(s).	The sum of all invoices that have been cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been cleared against the Billing Period line.

Margin Actualization Grid Reference

The Margin Actualization grid is used to actualize margin Cost Lines, Cost Lines that have a Cost Method value of Margin.

The table below describes the Margin Actualization grid columns:

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

Actualization Grid Type	Column Name	Description	Line Type: Order	Line Type: Cost Line	Line Type: Billing Period
Standard, Margin	Line Type	The type of the Actualization grid line, according to the following hierarchy: Media Order Cost Line (Cost Package, Media Package, Placement) Billing Period Non-Media Order Cost Line (Fee) Billing Period	N/A	N/A	N/A
Standard, Margin	Status (Actualization Status)	The actualization status of the Actualization grid line.	The possible actualization statuses are: Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata		The possible actualization statuses are: Not Actualized: The Billing Period line is not actualized in OneStrata Actualized: The Billing Period line is actualized in OneStrata
Standard, Margin	Invoice Status	The invoice status of the Actualization Grid line.	The possible invoice statuses are: Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced		The possible invoice statuses are: Not Invoiced: The Billing Period line is not invoiced (no invoice has been created for the billing period) Invoiced: The Billing Period line is invoiced (an invoice has been created for the billing period)
Standard, Margin	Entity Name	The name and identification number of the entity associated with the Actualization grid line.	The displayed values are: Order Partner: The name of the Order Partner of the order. Click the Entity Name link to open the Order Details page of the order. Order ID: The OneStrata-generated identification number of the order	The displayed values are: Supplier: The Supplier entity assigned to the Cost Line Cost Line ID: The OneStrata-generated identification number of the Cost Line	This displayed values are: Month & Year: The calendar month and year of the Billing Period line Billing Period ID: The OneStrata-generated identification number of the Billing Period line
Standard, Margin	Line Name	The name of the Actualization grid line.	N/A	The name of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	External ID	The external identification number of the Actualization grid line.	N/A	N/A	The identification number used by the external financial system to reference the Billing Period line. Only available if the Billing Period line has been exported to an external financial system.
Standard, Margin	Start and End Date	The start and end dates of the Actualization grid line.	N/A	The start and end dates of the Cost Line. Copied from the media schedule.	The start and end dates of the Billing Period line. Copied from the media schedule.
Standard, Margin	Contract Total	The total committed vendor cost of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The total committed vendor cost of the entire order. Copied from the order.	The total committed vendor cost of the Cost Line. Copied from the media schedule.	The committed vendor cost of the Billing Period line. Copied from the media schedule.
Standard, Margin	Rate Type	The Rate Type of the Actualization grid line.	N/A	The Rate Type of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The committed vendor rate of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	N/A	The committed vendor rate of the Cost Line. Copied from the media schedule.	The committed vendor rate of the Billing Period line. Copied from the media schedule.
Margin	Client Net Rate (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Rate (VC) of the Actualization grid line.	N/A	The client net rate of the Cost Line. Copied from the media schedule.	The client net rate of the Billing Period line. Copied from the media schedule.
Standard, Margin	Units	The total number of committed units for the Actualization grid line.	The total number of committed units for the entire order.	The total number of committed units for the Cost Line. Copied from the media schedule.	The number of committed units for the Billing Period line. Copied from the media schedule.
Standard, Margin	Current for Period	The committed vendor cost of the Actualization grid line, for the selected billing period(s). Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The committed vendor cost of the order, for the selected billing period(s).	The committed vendor cost of the Cost Line, for the selected billing period(s).	The committed vendor cost of the Billing Period line
Standard, Margin	Pre-Actualized	The pre-actualization vendor cost of the Actualization grid line, for the selected billing period(s). If the line has never been actualized, the Pre-Actualized value is equal to the Current for Period value. Once the line is actualized, the Pre-Actualized value becomes locked and no longer changes, even if the Current for Period value (which is copied from the media schedule) changes. For example, imagine a Cost Line that has never been actualized: Its Current for Period value is $100. Its Pre-Actualized value is set to whatever the Current for Period value is, which is $100. If the Cost line's Current for Period value changes, its Pre-Actualized value also changes. Then, the Cost line is actualized: At the time of actualization, its Current for Period value is $100. The Pre-Actualized value is locked to $100. Afterwards, if the Cost Line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change.	The pre-actualization vendor cost of the order, for the selected billing period(s).	The pre-actualization vendor cost of the Cost Line, for the selected billing period(s).	The pre-actualization vendor cost of the Billing Period line.
Standard, Margin	Balance	The cost balance of the Actualization grid line, for the selected billing period(s). The cost balance is the difference between the Actual Cost for Period (the actualized value) and the Current for Period (the committed value).	The cost balance of the order, for the selected billing period(s).	The cost balance of the Cost Line, for the selected billing period(s).	The cost balance of the Billing Period line.
Standard	Actual Source	The source(s) of the Actualization grid line's Actual Cost for Period, Actual Rate, and Actual Units values. The possible values are: Committed: The values are copied from the media schedule Site: The values are copied from the Site columns 3rd Party: The values are copied from the 3rd Party columns Manual: The user has manually changed one or more values	The source(s) of the actual values of the order.	The source(s) of the actual values of the Cost Line.	The source(s) of the actual values of the Billing Period line.
Standard	Actual Cost for Period This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor cost of the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The actual vendor cost of the order, for the selected billing period(s).	The actual vendor cost of the Cost Line, for the selected billing period(s).	The actual vendor cost of the Billing Period line.
Standard	Actual Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor rate of the Actualization grid line. When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate) If the Actual Source value is Site or 3rd Party, the value of Actual Rate is calculated according to the following formula: Actual Rate = Actual Cost / Actual Units	N/A	The actual vendor rate of the Cost Line.	The actual vendor rate of the Billing Period line.
Standard	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system.	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Standard	Site Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Site source (if any). The possible Site sources are: Vendor Inbox: If the Cost Line is part of an order that was sent to an In-System Order Partner, the Order Partner can send delivery data through Vendor Inbox. An external integration provider DV360 : If the Cost Line is linked to a DV360 insertion order, delivery data is automatically retrieved from DV360 once per day, at around midnight local time. Google Ads: If the Cost Line is linked to a Google Ads campaign, delivery data is automatically retrieved from Google Ads once per day, at around midnight local time. If a Cost Line has delivery data from both Vendor Inbox and an external integration provider, the Site Cost and Site Units columns display the Vendor Inbox values, not the external integration provider values.	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Billing Period line, as retrieved from the Site source.
Standard	Site Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Site source (if any). See Site Cost (above) for more information about Site-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Billing Period line, as retrieved from the Site source.
Standard	3rd Party Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Ad Server provider (if any). If the two conditions below are met, delivery data is automatically retrieved from the Ad Server provider once per day, at around midnight local time: The Cost Line contains one or more Ad Placements that were uploaded to a campaign on the Ad Server provider The Supplier of the Cost Line is mapped to an Ad Server provider site/supplier	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Billing Period line, as retrieved from the Ad Server provider.
Standard	3rd Party Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Ad Server provider (if any). See 3rd Party Cost (above) for more information about 3rd party-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Billing Period line, as retrieved from the Ad Server provider.
Margin	Vendor Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Vendor Net Cost (VC) of the Actualization grid line, for the selected billing period(s).	The vendor net cost of the order, for the selected billing period(s).	The total vendor net cost of the Cost Line, for the selected billing period(s).	The vendor net cost of the Billing Period line.
Margin	Margin % This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Margin % of the Actualization grid line, for the selected billing period(s).	N/A	The average margin percentage of the Cost Line, for the selected billing period(s).	The margin percentage of the Billing Period line.
Margin	Client Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Cost (VC) of the Actualization grid line, for the selected billing periods(s).	N/A	The client net cost of the Cost Line, for the selected billing period(s).	The client net cost of the Billing Period line.
Margin	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s).	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Margin	Other Income (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The margin amount (the difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values) of the Actualization grid line, for the selected billing period(s). Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC)	The margin amount of the order, for the selected billing period(s).	The margin amount of the Cost Line, for the selected billing period(s).	The margin amount of the Billing Period line.
Standard, Margin	Invoiced Amount	The sum of all invoices that have been matched or cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the order, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Billing Period line.
Standard, Margin	Cleared Invoiced Amount	The sum of all invoices that have been cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been cleared against the order, for the selected billing period(s).	The sum of all invoices that have been cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been cleared against the Billing Period line.

Actualization Grid Reference

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

Actualization Grid Type	Column Name	Description	Line Type: Order	Line Type: Cost Line	Line Type: Billing Period
Standard, Margin	Line Type	The type of the Actualization grid line, according to the following hierarchy: Media Order Cost Line (Cost Package, Media Package, Placement) Billing Period Non-Media Order Cost Line (Fee) Billing Period	N/A	N/A	N/A
Standard, Margin	Status (Actualization Status)	The actualization status of the Actualization grid line.	The possible actualization statuses are: Not Actualized: None of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Partially Actualized: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata Actualized: All of the Billing Period lines displayed under the Order line or Cost Line are actualized in OneStrata		The possible actualization statuses are: Not Actualized: The Billing Period line is not actualized in OneStrata Actualized: The Billing Period line is actualized in OneStrata
Standard, Margin	Invoice Status	The invoice status of the Actualization Grid line.	The possible invoice statuses are: Not Invoiced: None of the Billing Period lines displayed under the Order line or Cost Line are invoiced Partially Invoiced: At least one, but not all, of the Billing Period lines displayed under the Order line or Cost Line are invoiced Invoiced: All of the Billing Period lines displayed under the Order line or Cost Line are invoiced		The possible invoice statuses are: Not Invoiced: The Billing Period line is not invoiced (no invoice has been created for the billing period) Invoiced: The Billing Period line is invoiced (an invoice has been created for the billing period)
Standard, Margin	Entity Name	The name and identification number of the entity associated with the Actualization grid line.	The displayed values are: Order Partner: The name of the Order Partner of the order. Click the Entity Name link to open the Order Details page of the order. Order ID: The OneStrata-generated identification number of the order	The displayed values are: Supplier: The Supplier entity assigned to the Cost Line Cost Line ID: The OneStrata-generated identification number of the Cost Line	This displayed values are: Month & Year: The calendar month and year of the Billing Period line Billing Period ID: The OneStrata-generated identification number of the Billing Period line
Standard, Margin	Line Name	The name of the Actualization grid line.	N/A	The name of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	External ID	The external identification number of the Actualization grid line.	N/A	N/A	The identification number used by the external financial system to reference the Billing Period line. Only available if the Billing Period line has been exported to an external financial system.
Standard, Margin	Start and End Date	The start and end dates of the Actualization grid line.	N/A	The start and end dates of the Cost Line. Copied from the media schedule.	The start and end dates of the Billing Period line. Copied from the media schedule.
Standard, Margin	Contract Total	The total committed vendor cost of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The total committed vendor cost of the entire order. Copied from the order.	The total committed vendor cost of the Cost Line. Copied from the media schedule.	The committed vendor cost of the Billing Period line. Copied from the media schedule.
Standard, Margin	Rate Type	The Rate Type of the Actualization grid line.	N/A	The Rate Type of the Cost Line. Copied from the media schedule.	N/A
Standard, Margin	Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The committed vendor rate of the Actualization grid line. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	N/A	The committed vendor rate of the Cost Line. Copied from the media schedule.	The committed vendor rate of the Billing Period line. Copied from the media schedule.
Margin	Client Net Rate (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Rate (VC) of the Actualization grid line.	N/A	The client net rate of the Cost Line. Copied from the media schedule.	The client net rate of the Billing Period line. Copied from the media schedule.
Standard, Margin	Units	The total number of committed units for the Actualization grid line.	The total number of committed units for the entire order.	The total number of committed units for the Cost Line. Copied from the media schedule.	The number of committed units for the Billing Period line. Copied from the media schedule.
Standard, Margin	Current for Period	The committed vendor cost of the Actualization grid line, for the selected billing period(s). Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The committed vendor cost of the order, for the selected billing period(s).	The committed vendor cost of the Cost Line, for the selected billing period(s).	The committed vendor cost of the Billing Period line
Standard, Margin	Pre-Actualized	The pre-actualization vendor cost of the Actualization grid line, for the selected billing period(s). If the line has never been actualized, the Pre-Actualized value is equal to the Current for Period value. Once the line is actualized, the Pre-Actualized value becomes locked and no longer changes, even if the Current for Period value (which is copied from the media schedule) changes. For example, imagine a Cost Line that has never been actualized: Its Current for Period value is $100. Its Pre-Actualized value is set to whatever the Current for Period value is, which is $100. If the Cost line's Current for Period value changes, its Pre-Actualized value also changes. Then, the Cost line is actualized: At the time of actualization, its Current for Period value is $100. The Pre-Actualized value is locked to $100. Afterwards, if the Cost Line's Current for Period value changes (for example, it increases to $125), its Pre-Actualized value does not change.	The pre-actualization vendor cost of the order, for the selected billing period(s).	The pre-actualization vendor cost of the Cost Line, for the selected billing period(s).	The pre-actualization vendor cost of the Billing Period line.
Standard, Margin	Balance	The cost balance of the Actualization grid line, for the selected billing period(s). The cost balance is the difference between the Actual Cost for Period (the actualized value) and the Current for Period (the committed value).	The cost balance of the order, for the selected billing period(s).	The cost balance of the Cost Line, for the selected billing period(s).	The cost balance of the Billing Period line.
Standard	Actual Source	The source(s) of the Actualization grid line's Actual Cost for Period, Actual Rate, and Actual Units values. The possible values are: Committed: The values are copied from the media schedule Site: The values are copied from the Site columns 3rd Party: The values are copied from the 3rd Party columns Manual: The user has manually changed one or more values	The source(s) of the actual values of the order.	The source(s) of the actual values of the Cost Line.	The source(s) of the actual values of the Billing Period line.
Standard	Actual Cost for Period This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor cost of the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate)	The actual vendor cost of the order, for the selected billing period(s).	The actual vendor cost of the Cost Line, for the selected billing period(s).	The actual vendor cost of the Billing Period line.
Standard	Actual Rate This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The actual vendor rate of the Actualization grid line. When a Billing Period line is actualized, this value is sent to the external finance system. Standard Actualization grid: Depending on the primary cost type of the campaign, this value is either vendor net (Vendor Net Cost / Vendor Net Rate) or vendor gross (Vendor Gross Cost / Vendor Gross Rate). Primary cost type is an enterprise-level setting that is managed on the Administration > Cost Model Settings page. Margin Actualization grid: This value is vendor net (Vendor Net Cost / Vendor Net Rate) If the Actual Source value is Site or 3rd Party, the value of Actual Rate is calculated according to the following formula: Actual Rate = Actual Cost / Actual Units	N/A	The actual vendor rate of the Cost Line.	The actual vendor rate of the Billing Period line.
Standard	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s). When a Billing Period line is actualized, this value is sent to the external finance system.	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Standard	Site Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Site source (if any). There are two possible Site sources: Vendor Inbox: If the Cost Line is part of an order that was sent to an In-System Order Partner, the Order Partner can send delivery data through Vendor Inbox. DV360 : If the Cost Line is linked to a DV360 insertion order, delivery data is automatically retrieved from DV360 once per day, at around midnight local time. If a Cost Line has delivery data from both Site sources, the Site Cost and Site Units columns display the Vendor Inbox values, not the DV360 values.	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The vendor delivery cost of the Billing Period line, as retrieved from the Site source.
Standard	Site Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Site source (if any). See Site Cost (above) for more information about Site-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Site source.	The number of delivered units for the Billing Period line, as retrieved from the Site source.
Standard	3rd Party Cost	The vendor delivery cost of the Actualization grid line for the selected billing period(s), as retrieved from the Ad Server provider (if any). If the two conditions below are met, delivery data is automatically retrieved from the Ad Server provider once per day, at around midnight local time: The Cost Line contains one or more Ad Placements that were uploaded to a campaign on the Ad Server provider The Supplier of the Cost Line is mapped to an Ad Server provider site/supplier	The vendor delivery cost of the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The vendor delivery cost of the Billing Period line, as retrieved from the Ad Server provider.
Standard	3rd Party Units	The number of delivered units for the Actualization grid line for the selected billing periods(s), as retrieved from the Ad Server provider (if any). See 3rd Party Cost (above) for more information about 3rd party-sourced delivery data.	The number of delivered units for the order, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Cost Line, for the selected billing period(s), as retrieved from the Ad Server provider.	The number of delivered units for the Billing Period line, as retrieved from the Ad Server provider.
Margin	Vendor Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Vendor Net Cost (VC) of the Actualization grid line, for the selected billing period(s).	The vendor net cost of the order, for the selected billing period(s).	The total vendor net cost of the Cost Line, for the selected billing period(s).	The vendor net cost of the Billing Period line.
Margin	Margin % This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Margin % of the Actualization grid line, for the selected billing period(s).	N/A	The average margin percentage of the Cost Line, for the selected billing period(s).	The margin percentage of the Billing Period line.
Margin	Client Net Cost (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The Client Net Cost (VC) of the Actualization grid line, for the selected billing periods(s).	N/A	The client net cost of the Cost Line, for the selected billing period(s).	The client net cost of the Billing Period line.
Margin	Actual Units This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The number of actual units for the Actualization grid line, for the selected billing periods(s).	N/A	The number of actual units for the Cost Line, for the selected billing period(s).	The number of actual units for the Billing Period line.
Margin	Other Income (VC) This value is part of a triangulation set. For more information, see Apply Standard Actualization Triangulation and Apply Margin Actualization Triangulation.	The margin amount (the difference between the Client Net Cost (VC) and Vendor Net Cost (VC) values) of the Actualization grid line, for the selected billing period(s). Other Income (VC) = Client Net Cost (VC) - Vendor Net Cost (VC)	The margin amount of the order, for the selected billing period(s).	The margin amount of the Cost Line, for the selected billing period(s).	The margin amount of the Billing Period line.
Standard, Margin	Invoiced Amount	The sum of all invoices that have been matched or cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the order, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been matched or cleared against the Billing Period line.
Standard, Margin	Cleared Invoiced Amount	The sum of all invoices that have been cleared against the Actualization grid line, for the selected billing period(s).	The sum of all invoices that have been cleared against the order, for the selected billing period(s).	The sum of all invoices that have been cleared against the Cost Line, for the selected billing period(s).	The sum of all invoices that have been cleared against the Billing Period line.

Content

Space Tools

Table of Contents

Actualization Tab UI Elements

Actualization Grid Reference

Standard Actualization Grid Reference

Margin Actualization Grid Reference

Actualization Grid Reference

Provide feedback on this article

Content

Space Tools

Actualization Tab UI Reference

Table of Contents

Actualization Tab UI Elements

Actualization Grid Reference

Standard Actualization Grid Reference

Margin Actualization Grid Reference

Actualization Grid Reference

Provide feedback on this article