Billings Flow Intermediate Processing
After importing the input fields and augmenting them with the data from their lookup objects, the PS Cloud Analytics dataflow filters out non-relevant or repeated records.
You can use the dataflow editor in Analytics Studio to visualize the PS Cloud Analytics dataflow and its nodes. Alternatively, you can download the dataflow definition file which is a JSON file representing the dataflow and its logic. For more information on the dataflow editor and the dataflow definition file, see Configure the Dataflow in the Salesforce Help.
Dataflow Nodes
These are the main dataflow nodes in the Billings flow.
Dataflow Node |
Description |
---|---|
timecard_FILTER | Matches timecards that have the "Approved" status. |
expense_FILTER | Matches expenses that are included in financials. |
eva_FILTER | Matches estimates vs. actuals that have an assignment and a time period associated. |
miscAdjustment_passThrough_FILTER | Matches miscellaneous adjustments that are included in financials and that have a transaction category field "Pass-Through Ready-to-Bill Revenue". |
misc_adjustment_ready_to_bill__FILTER | Matches miscellaneous adjustments that are included in financials and that have a transaction category field "Ready-to-Bill Revenue". |
milestone__FILTER |
Categorizes the milestones by subtype. The filter logic is either:
|
billing_first_level_project_FILTER |
Ensures that only records associated with the top-level Project are included. |
Budget_FILTER |
Ensures that only budgets with the status "Approved" are included in the dataset. Budgets that have the "Draft", "Open", or "Rejected" status are discarded. The only budget types supported are:
The Type field from which these budget varieties are derived is renamed as "Subtype" in this filter node. |
Calculated Fields
These are the fields calculated by the Billings flow.