/
Facility Charges

Facility Charges

Owned by IFS Energy and Resources (Deactivated)
Last updated: Jan 15, 2025 by IFS Energy & Resources
66 min read

 

Search the Qbyte Metrix Wiki
 

Back to Set Up Masters          

      

Introduction

Facility Charges are used to charge well and unit Owners with the costs of operating and delivering products. Facility Charges can be trucking expenses, compression, processing, treating, or marketing costs, for example. Facility Charges are set up and processed by Control Group and therefore can only be set up for facilities that are attached to a Control Group and/or any Units that are associated with wells attached to a Control Group. As of Release 25.1, Injection Facilities can be attached to a Control Group, therefore Facility Charges can be set up at an injection facility. For more information on attaching injection facilities to control groups see Injection Facilities within Control Groups.

  • Formulas are linked to charges and can be set up first.

  • Global Formulas are set up at the menu level. Local formulas are set up through Explorer at the Control Group level.

  • Charges are set up through Explorer at the Control Group level. Charges can be set up at all entity levels.

There are three types of data used in building Facility Charges:

1. Facility Charges – Creates the Master Data record for the expenses by identifying the Facility to charge, product, charge type, and Formula ID.

Jump to Facility Charge Maintenance.

2. Formulas – Formula IDs are created and can be linked to multiple facilities. These determine calculation methods and formula line details.

Jump to Facility Charge Formulas.

3. Factors – Allows the user to create Global, Facility level, Facility plus well level, and Facility Charge level factors that can be utilized when building Formula details.

Steps:

  • Factors, if required by a Formula,  should be set up first.

  • Formulas should be set up next.

  • Charges are set up last and include a link to Formula IDs.

 

Facility Charge Formulas

Facility Charge Formula Types

Facility Charge formulas calculate the value that will be expensed out to participants in a charge. The Formula is an equation that uses Qbyte Metrix data and/or input data together with math operators to calculate the charge. Formulas can be set up via two different methods:

1. Global Formula: This creates a formula that can be utilized by all Control Groups and can be attached to multiple charges. The benefit of using this method is it reduces the number of masters within the system and ensures consistency where applicable. Production Accounting/Overhead fees are an excellent example of this. Making changes to a Global Formula affects all Charges using that Formula.

2. Local Formula: This formula cannot be linked to any other Control Group but the Control Group where it was created. Local Formulas should be used to address specific agreements for a given facility. A Local Formula can be linked to multiple Facilities within the Control Group and making changes to a Local Formula changes all Charges using that formula.

 

Creating a Formula Master

The steps are the same if you access the formula from Explorer for Local Formulas, or if you access it through the menu for Global Formulas. Remember that setting up a formula from the menu will create a Global Formula that all users are able to link to their charges. If a formula is set up within the Control Group/Facility Charges, then you will be creating a Local Formula and only Facilities within that Control Group can link charges to that formula.

Global Formulas

Global Formulas are formulas that can be utilized by all Control Groups are maintained from the Facility Charge Global Formula Maintenance tab. Global Formulas can only be created or edited from this new screen.

Select View to see Global Formulas.

The screen will open with a grid showing previously set up Formulas. The first formula will be highlighted, and the details will appear beneath the grid.

  • The grid can be sorted and filtered.

  • Highlight another formula to change the focus. 

  • Select Create New Formula  to open a screen to create a new Global Formula.

Action buttons include Save, Revert, Copy From, Delete Formula, Usage, Cancel, Create Shutin Table, and Edit Shutin table.

NEW FORMULA FIELDS

NEW FORMULA FIELDS

Formula Id

User-defined (16 characters max).

Formula Description

User-defined Description (40 Characters).

Primary Retrieval Type

Base for the Calculation, i.e. Sales Volume or Charge per Entity. The first line in the Formula equation. 
Use type-ahead or Advanced Search.

Volume Definition

  • Main Retrieval as is: Results in the volume identified by the Main Retrieval Type selection being used.

  • Designated in Formula: Uses the volume as designated in the calculation.

  • Main Prorated by Input: The global input volume will be prorated to the volume that is identified by the Main Retrieval Type.

  • Designated and Prorated by Input: The global input volume will be prorated to the volume as designated in the calculation.

  • Set Volume to 0: Volumes will be reset to zero.

Value Definition

  • Formula Result Value: Value is calculated by the formula.

  • Designated Value in Formula: Value is designated in the formula.

  • Global Rate Input: Value will be calculated by a Global Rate (provided in the Factor table) against the calculated volume.

  • Global Value Input Prorated: Prorates the value calculated, using the global rate provided in the entity screen.

Monthly Input ID

Allows a formula to use values not available in Qbyte Metrix.

Unit/Tract Criteria

Defines how to handle the allocation to the unit and tract.

Options include:

  • Split Unit totals through tracts

  • Do not split unit totals through tracts

  • Do not accum unit wells to Units

Shutin Look up Table

Used to validate Charges based on the number of months a well is shut in. 
Use type-ahead or Advanced Search or Create Shutin Table.

After entering the required data, click Save to open the Formula window.

Click the Add button to open the Formula Builder screen.

Action buttons include Add, Apply, Revert, and Delete.

NEW FORMULA FIELDS

NEW FORMULA FIELDS

Sub-Calculation

  • N/A

  • Open Sub Calc: Open bracket

  • Sub Calc Body: Within bracket

  • Close Sub Calc: Close bracket

Operator

Factor Type

  • System Value: Values that exist within Qbyte Metrix. If this value is required for a calculation, the system can simply look up the value and use it for the calculation.

  • Fixed Value: Factor does not change; therefore you must enter it only once. This factor does not exist anywhere within Qbyte Metrix.

Factor

System Values: 

  • Factor= Sub group total: Must be the first line of any Sub calculation section of a formula.

  • Table Look Up Factor: Selecting this option allows a user to activate an additional table to enter multi-layered calculation factors.
    Note: Only one Table Lookup Factor can exist for a formula.

  • User Defined Global factor: When selecting this option, a user-Defined Global Factor ID must be identified to be used.

  • Memory 1 to 9: Depending on the operand chosen, the system will either store the result of the previous line calculation or will recall the value previously stored to that memory number and apply the operand to that value.

  • Designated Expense Volume: Used in conjunction with a Volume Definition Type of Designated Volume in Formula.

  • Designated Expense Value: Used in conjunction with a Value Definition Type of Designated Value in Formula.

  • Pseudo Commingled Factor: This returns the Commingled Percentage for the well. If the well is not commingled,100% will be returned.

  • Subtotal: Any calculation within the formula can be subtotaled prior to moving on to the next calculation in the formula.

User Description

Used as a Description for reporting. 

Formula Factor

User-defined value to be used in the Formula line. 

Percentage

Is the entered Formula Factor a percentage?

  • Yes/No.

Add a Formula line by entering the following details:

  • Choose Sub-Calculation option

  • Choose an Operator

  • Choose a Factor Type

  • Optionally enter a Description for the Factor that will appear on Facility Charge Reporting.

  • Enter the Factor.

  • Apply the Formula Line. This will appear in the Formula grid.

  • Repeat by selecting the Add button for each Formula  Line.

  • Click Save after all formula lines have been applied.

Completed Formula example:

Local Formulas

Local Formulas are maintained within the Facility Charge Formula Maintenance tab for the Control Group in Explorer. This Formula Type can only be used and maintained within the Control Group where it was created. Control Groups can copy a Local Formula from another Control Group and make it their own.

When coming to the Formula tab after selecting a facility charge, the user will be positioned to that charge in the Facility Charge Formula grid.

The Facility Charge Formula grid will only display Local Formulas related to the Control Group that you are in. Highlighting a formula within the grid will display the formula details below the grid, and the View Primary Retrieval and View Shutin Table buttons are available for additional information.

Select the Formulas tab to set up Local Formulas. If a Local Formula is highlighted in the grid, a user may be able to Create New or Edit the formula depending on their security access.

Note: If the selected formula is a Global Formula, the Edit button will be disabled. Global Formulas are maintained through the Facility Charge Global Formula Maintenance screen only.

Action buttons include Cancel, Usage, Create New Formula, and Edit.

The screen will open with a grid showing previously set up formulas. The first formula will be highlighted, and the details will appear beneath the grid. The grid can be sorted and filtered. Highlight another formula to change the focus. Local Formulas can be edited from this screen.

Select Create New Formula to open a screen to create a new Local Formula.

Action buttons include Save, Revert, Copy From, Delete Formula, Usage, Cancel, Create Shutin Table, and Edit Shutin table.

NEW FORMULA FIELDS

NEW FORMULA FIELDS

Formula Id

User-defined (16 characters max).

Formula Description

User-defined Description (40 Characters).

Primary Retrieval Type

Base for the Calculation i.e. Sales Volume or Charge per Entity. The first line in the Formula equation.

  • Use type-ahead or Advanced Search. See Appendix A for a list.

Volume Definition

  • Main Retrieval as is: Results in the volume identified by the Main Retrieval Type selection being used.

  • Designated in Formula: Uses the volume as designated in the calculation.

  • Main Prorated by Input: The global input volume will be prorated to the volume that is identified by the Main Retrieval Type.

  • Designated and Prorated by Input: The global input volume will be prorated to the volume as designated in the calculation.

  • Set Volume to 0: Volumes will be reset to zero.

Value Definition

  • Formula Result Value: Value is calculated by the formula.

  • Designated Value in Formula: Value is designated in the formula.

  • Global Rate Input: Value will be calculated by a Global Rate (provided in the Factor table) against the calculated volume.

  • Global Value Input Prorated: Prorates the value calculated, using the global rate provided in the entity screen.

Monthly Input ID

Allows a formula to use values not available in Qbyte Metrix.

Unit/Tract Criteria

Defines how to handle the allocation to the unit and tract.

Options include:

  • Split Unit totals through tracts

  • Do not split unit totals through tracts

  • Do not accum unit wells to Units

Shutin Look up Table

Used to validate Charges based on the number of months a well is shut in. Use type-ahead or Advanced Search or Create Shutin Table.

After entering the required data, click Save to open the Formula Equation window.

Action buttons include Save, Revert, Copy From, Delete Formula, Usage, Cancel, Create Shutin Table, Edit Shutin Table, and Add.

Click the Add button to open the Formula Builder screen.

Action buttons include Add, Apply, Revert, and Delete.

Add a formula line by entering the following details:

  • Choose Sub-Calculation option.

  • Choose an Operator.

  • Choose a Factor Type.

  • Optionally enter a Description for the Factor that will appear on Royalty Reporting.

  • Enter the Factor (min/max).

  • Apply the formula line – it will appear in the Formula grid.

  • Repeat by selecting the Add button for each formula line.

  • Click Save after all formula lines have been applied.

NEW FORMULA FIELDS

NEW FORMULA FIELDS

Sub Calculation

  • N/A

  • Open Sub Calc: Open bracket

  • Sub Calc Body: Within bracket

  • Close Sub Calc: Close bracket

Operator

Used to calculate the equation. 

Factor Type

  • System Value: Values that exist within Qbyte Metrix. If this value is required for a calculation, the system can simply look up the value and use it for the calculation.

  • Fixed Value: Factor does not change; therefore you must enter it only once. This factor does not exist anywhere within Qbyte Metrix.

Factor

System Values:

  • Factor = Sub Group Total: Must be the first line of any Sub calculation section of a formula.

  • Table Look Up Factor: Selecting this option allows a user to activate an additional table to enter multi-layered calculation factors.
    Note: Only one Table Lookup Factor can exist for a formula.

  • User Defined Global factor: When selecting this option, a user-Defined Global Factor ID must be identified to be used.

  • Memory 1 to 9: Depending on the operand chosen, the system will either store the result of the previous line calculation or will recall the value previously stored to that memory number and apply the operand to that value.

  • Designated Expense Volume: Used in conjunction with a volume definition type of Designated Volume in Formula.

  • Designated Expense Value: Used in conjunction with a value definition type of Designated Value in Formula.

  • Pseudo Commingled Factor: This returns the Commingled Percentage for the well. If the well is not commingled,100% will be returned.

  • Subtotal: Any calculation within the formula can be subtotaled prior to moving on to the next calculation in the formula.

User Description

Used as a description for reporting.

Formula Factor

User-defined volume/value to be used in the Formula equation. This is enabled when Factor Type is Fixed Value.

Percentage

Is the entered Formula Factor a Percentage?

  • Yes/No

 

Creating Formula using Copy From

There is a Copy From Formula option on Create New Master Formula record only. On Edit, the Copy From Formula will not be available to the user.

This feature allows a user to copy from any existing formulas in the system (Global and Local) from any Production Period that exists.

The copy function will copy the Main Retrieval, Volume Definition, Value Definition, the Shutin Lookup Table, and the Formula lines that are associated with the Formula ID.

Mandatory fields that must be acknowledged prior to selecting the Copy From Formula include:

  • Formula ID

  • Formula Description

If other fields are completed prior to selecting the Copy, the system will overwrite the values.

Editing or Deleting a Formula Master

At any time changes can be made to all fields on the Formula Master with the exception of the Formula ID. When a change is made to any other field and the user selects Save, Qbyte Metrix will bring up an Impact Window. This window will list all Control Groups, Facility Type, Facility ID, and the Charge information that is using that Formula for the month that changes are being made to.

The user can continue on with saving the changes or they can exit out of the save and all changes will revert back to their original value.

Shutin Lookup Tables

The Shutin Lookup Table is an incremental table of factors that validates the charges based on the number of months a well has been shutin. Once a Shutin Lookup Table has been established for an individual ID, that same table is available to any expense formula master by referencing the table with the same ID.

The user has the ability to view, create, and edit Shutin Lookup Tables from within the Formula tab.

Create a Shutin Lookup Table

Action buttons include Apply, Revert, and Add. The field is Shutin Table Name.

Click the Add button to add lines.

Click Apply to add the table to the Formula.

Click Save to retain the Shutin Table.

Examples of Shutin Lookup Tables

A table where after three months of shutin status, no overhead charge should be charged on the 4th month of being shutin:

A table where there are different rate depending on how many months the well is shutin:

 

Editing a Shutin Lookup Table

Users are able to edit existing Shutin Lookup Tables. It is important to be very careful when editing an existing Shutin Lookup Table, as these tables can be utilized by all Formulas (Local and Global). If you are in the Formula Builder screen from Explorer, users can edit only the Shutin Tables when they are either creating or editing a Local Formula Master.

If you wish to edit the Shutin Lookup Table attached to the Global Formula, you must go to the menu for Global Formula and make appropriate changes there. When making any changes (edit, add, or delete) to a pre-existing Shutin Lookup Table, Qbyte Metrix will notify the user with an Impact window upon saving the record. This table lists all areas that are currently using the Shutin Lookup Table. It gives the user the option to either commit the change or cancel the action (save/delete) and the system will revert the value(s) to its/their original value(s).

Example of an Impact Window:

 

Well Shutin Months

Initial Shutin Maintenance allows users to setup shut-in months prior to the time the well was implemented on Qbyte Metrix. Facility Charges will read this table and apply the shut-in months for the Well when it is attached to formulas that utilize a Shutin Lookup Table.

Click Edit to add new records.

Action buttons include Cancel, Create New, Delete Row, Save, and Revert.

MAINTAIN SHUTIN MONTH FIELDS

MAINTAIN SHUTIN MONTH FIELDS

Pre Implementation Date

The month prior to well set to ON Production in Qbyte Metrix.

Well ID

Use type-ahead.

Shut In months

The months the well has been shut in PRIOR to being on Qbyte Metrix.

Refresh FC Schematic

When setting up Facility Charges at a Control Group, a schematic of the facilities within the Control Group is used to make it easier for the user to view and maintain the Facility Charges associated with each facility. The schematic used by Facility Charges is essentially the same as the Control Group schematic the user sees on the Explorer, however the Facility Charge schematic will also include Units as child entities under batteries that have unitized wells. When the user modifies the Control Group Schematic through the Control Group Maintenance screen, the Facility Charge schematic is automatically refreshed to reflect any changes to the Control Group Schematic. The unitization is also re-evaluated to ensure that the correct Units are included in the Facility Charge schematic. Since unitization and battery/well linkages can be modified without the user making any modification to the Control Group Schematic, the user should remember to use the Refresh FC Schematic option on the Explorer to force a re-evaluation of unitization and ensure that the Facility Charge schematic reflects the correct Units.

Refreshing the Facility Charge schematic is done by selecting the Refresh FC Schematic option at the Control Group level through the Explorer.

Once selected the following screen will be displayed. Clicking Refresh will cause the Facility Charge schematic to be re-evaluated and refreshed. This refresh occurs immediately, it is not submitted. When the refresh is complete a message will appear at the top of the screen.

Facility Charges

Facility Charge Maintenance

Facility Charges are set up at the Control Group level through Explorer.

Select the Facility Charge menu item, and the Facility Charge window opens.

  • The Explorer view displays on the left.

Highlight an entity to see the charges that are set up for that entity. 

There are three tabs: Facility Charges, Formulas, and Factors. The system defaults to Facility Charges.

The screen will show the Facility Charge schematic and the first Entity will be highlighted. Current Charges for the highlighted entity will appear in the grid. The grid can be sorted and filtered. 

Note: Unlike the Control Group schematic, the Facility Charge schematic includes Units as children under the batteries that have unitized wells attached. If you do not see a Unit that you are expecting or you see one or more Units that you do not think should be shown then you should use the Refresh FC Schematic  functionality to have the Facility Charge hierarchy refreshed based on current set up.

The Charge Type filter to the left of the grid allows the user to find the entities where Facility Charges exist with the selected Charge Type. The Active flag beneath the Charge Type can then be used as a drop-down to find Active and Inactive Facility Charges within the schematic view below. Entities are bolded when matching charges are found for the entered criteria.

Action Buttons include Refresh, Cancel, and Edit.

Click Edit to set up New Charges or edit existing Charges for the highlighted facility.

  • A new window opens with the highlighted charge displayed.

Action Buttons include Save, Revert, Create New, and Delete.

Click the Create New button to add a Facility Charge.

  • A new window opens.

Action buttons include Save, Revert, Copy From, Cancel and Create New Formula Link: Advanced search.

FACILITY CHARGE FIELDS

FACILITY CHARGE FIELDS

Product

The Main retrieval type will affect and validate the product options which include:

  • NA - Not Applicable

  • RAWGAS - Raw Gas

  • OIL - Oil

  • GAS - Gas

  • CO2 - Carbon Dioxide

  • CO2MX - Carbon Dioxide Mix

  • CO2SP - Carbon Dioxide Spec

  • C1MX - Methane Mix

  • LITEMIX - Lite Mix

  • H2O - Water

  • COND - Condensate

  • LPGNGL - LPG/NGL

  • C2 - Ethane

  • C2MX - Ethane Mix

  • C2SP - Ethane Spec

  • C3 - Propane

  • C3MX - Propane Mix

  • C3SP - Propane Spec

  • C4 - Butane

  • C4MX - Butane Mix

  • C4SP - Butane Spec

  • IC4MX - Iso-Butane Mix

  • IC4SP - Iso-Butane Spec

  • NC4MX - Normal Butane Mix

  • NC4SP - Normal Butane Spec

  • C5 - Pentane

  • C5MX - Pentane Mix

  • C5SP - Pentane Spec

  • IC5MX - Iso-Pentane Mix

  • IC5SP - Iso-Pentane Spec

  • NC5MX - Normal Pentane Mix

  • NC5SP - Normal Pentane Spec

  • C6 - Pentane Plus

  • C6MX - Pentane Plus Mix

  • C6SP - Pentane Plus Spec

  • SUL - Sulphur

Note:

  • If the charge is set up on C2 then the system will accumulate C2, C2MX, and C2SP and calculate the charge on the sum. 

    • If the charge is set up on C2MX it will only use the data for the C2MX product.

  • If the charge is set up on C3 then the system will accumulate C3, C3MX, and C3SP and calculate the charge on the sum. 

    • If the charge is set up on C3MX it will only use the data for the C3MX product.

  • If the charge is set up on C4 then the system will accumulate C4, C4MX, C4SP, IC4MX, IC4SP, NC4MX, and NC4SP and calculate the charge on the sum. 

    • If the charge is set up on C4MX it will use only the data for the C4MX product.

  • If the charge is set up on C5 then the system will accumulate C5, C5MX, C5CP, IC5MX, IC5SP, NC5MX, and NC5SP and calculate the charge on the sum. 

    • If the charge is set up on C5MX it will use only the data for the C5MX product.

  • If the charge is set up on C6 then the system will accumulate C6, C6MX, and C6SP and calculate the charge on the sum. 

    • If the charge is set up on C6MX it will use only the data for the C6MX product.

Charge Type

Used for Financial Booking.

  • See Appendix B for pre-loaded examples and Charge Type for information. 

Sequence #

This is a numerical field.

Active

  • Defaulted to Yes. The status of the flag can be changed while creating or editing a Charge. Inactive Facility Charges are not booked into financial.

  • The ability to Inactivate and Activate a Facility Charge is most helpful during the implementation of Facility Charges or even when adding new charges at a later date.

  • You can set up Charges and test results without having to complete and book into Financials during the current month.

Formula ID

Use type-ahead or Advanced Search or Create a New Formula.

Revenue Cost Centre

Cost Centre to be used to book the Revenue into a Financial system.

Expense DOI Ext.

Optional, must be previously set up.

Revenue DOI Ext.

Optional, must be previously set up.

Book at Unit

Yes/No: This provides the ability to roll unit well/tract level charges up to the unit level for financial booking. The default is No which means that the charge will be booked at the calculated level - tracts or wells depending on the Primary Retrieval type of the selected formula. If you require financial booking at the unit level, then this flag can be changed to Yes and the charge will be booked at the unit Level only.

Taxes Applicable

Yes/No: This provides the option of calculating GST and/or PST within Metrix. The default for this drop-down field is No which means that GST/PST will not be charged. If Yes and there is a GST rate set up on the System Configuration screen, Qbyte Metrix will calculate and charge GST to the Owners associated with the charge. If there is also a PST rate set up for the province of the charge facility, the Owners will also be charged PST. Account and Entry Definitions will be required for financial bookings if GST and/or PST are to be calculated within Qbyte Metrix.



Creating a Charge Using Copy From

The Copy From Charge feature will copy from any charge in the system, from any month, as long as the user is in the Add Record stage.

Action buttons include Search, Clear, and Select and Return.

Select the appropriate charge, Select Select and Return. Once back in the Create New screen, click Save to retain the charge.

 

Facility Charge Maintenance - Entity Exceptions

The Entities Exceptions screen is where you can include or exclude specific facilities for the Charge to apply to.

Schematic View

The Schematic tab shows the facilities and entities that are directly connected to the Control Group being displayed.

On a new setup, all Entities within the Facility in focus and any level of the schematic below that Facility are included in the Charge by default. The Well grid can be sorted and filtered.

Action buttons include Save, Revert, Clear All, Expand All, Collapse All, and Exclude (Include).

Including/Excluding Entities

1. Select an Entity in the grid.

Note: Entities that have other entities below them. Highlighting an entity will include all linked Entities.

2. Select the appropriate button to include or exclude the selection.

Colour Indicators:

  • If an Entity is RED, the Facility or Well/Tract is excluded from the Charge.

  • If an Entity is GREEN, the Facility or Well/Tract is included in the Charge.

  • If an Entity is  BOLD GREEN, the entities linked to Facility have a mixture of both included and excluded entities.

Clear All will clear all selections and reset the setup to include all entities at all levels.

List View

This List Tab is an alternative view that allows you to maintain a list of included entities regardless of their physical attachment to the current charge facility. For example, cross Control Group transfers where you may want to include/exclude some entities.

Action buttons include Add, Save, Revert, Clear All, Select All, Deselect All and Exclude (Include).

  • Enter an Entity Type and Entity ID and click Add to add an Entity to the list.

If the list is empty, that means all entities (entities that are included in the initial Retrieval Type) are included. It is recommended that the list be deleted first if edits are to be made to the schematic. This makes it easier for the user to clearly identify the included entities in the charge after the change.

Facility Charge Maintenance - Owner Exceptions

From the Owners screen, a list of Owners can be created and designated if that list of Owners will either be Included or Excluded from the Charge. This step is not required if all Owners based on the Charge and Entity Selection are to be included in the Charge.

Action Buttons include Save, Revert, Add, Select All, Deselect All and Delete Row(s).

Fields include Owner ID Link: Advanced search.

In the Owner ID field, enter a partial or complete Owner ID or Name. When the correct Owner appears, select the Add button.

List Type: Choose whether the list of Owners is to be Included or Excluded.


Deleting Owners

Highlight Owner(s) from the list to be deleted.

Facility Charge Maintenance - From/To Exceptions

From/To functionality allows the user to apply the charge to a specific receipt or disposition within the total value that is created in the Main Retrieval.

The From/To function is only available for use with specific Main Retrieval types.

Action buttons include Save, Revert, Add, Select All, Deselect All and Delete Row(s)

FROM/TO EXCEPTION FIELDS

FROM/TO EXCEPTION FIELDS

Disposition Type

See Appendix C for a full list. Examples are Delivery or Transfer.

From/To Type

Delivery System, GGS, or Plant.

ID

Corresponds to the type.

Once a selection is added the grid will have data lines. These lines can be deleted by highlighting one or more lines.



Facility Charge Maintenance - Purchaser Exceptions

This feature gives the ability to calculate on certain Purchaser volumes based on the Main Retrieval. Depending on the Main Retrieval Type used in the Formula that is attached to the Charge, the ability to specify purchasers may be enabled or disabled.

The following is a list of Main Retrievals that allow the user to either Include or Exclude the list created in the CO2/Purchaser.

RETRIEVAL DESCRIPTION

RETRIEVAL DESCRIPTION

Allocated CO2 by WIO

Sales Volume by WIO

Sales Volume less Crown by WIO

Sales Volume less Royalty TIK by WIO

Sales Value by WIO

Sales Value less Crown by WIO 

Sales Value less Royalty TIK by WIO

Sales Value less Transportation by WIO

BYP Sales Volume by WIO

BYP Sales Volume less Roy TIK by WIO

GBP Sales Value by WIO

GBP Sales Value less Royalty TIK by WIO

GBP Sales Value less Transportation by WIO

Action buttons include Cancel, Save, Revert, Add, Select All, Deselect All, and Delete Rows.

ADD DISPOSITION/DELIVERY SYSTEM

ADD DISPOSITION/DELIVERY SYSTEM

List Type

Purchasers to be Included/Purchasers to be Excluded.

Purchaser Type

Dilution Gas, Facility Transfer, In Transit, Loss due to Fire, Theft or Spill, Netted return Fuel, or Purchaser. 

Purchaser ID

Use type-ahead or Advanced Search.

Once the purchaser record is Saved the Purchaser will be displayed in the Grid.

The grid can be sorted and filtered.

PURCHASER EXCEPTIONS GRID COLUMNS

PURCHASER EXCEPTIONS GRID COLUMNS

Purchaser Type

Dilution Gas, Facility Transfer, In Transit, Loss due to Fire, Theft or Spill, Netted return Fuel, or Purchaser.

Purchaser ID 

Use type-ahead or Advanced Search.

Purchaser Name

Corresponds to ID.

All Sequences

  • Yes/No.

Purchaser Sequence Number

If Sequence is toggled Yes, a data entry field opens.

  • Enter the sequence # that corresponds to Market Master.

  • Use to exclude or include a specific Facility Charge sequence.

To Delete a Purchaser, highlight the line(s) and click the Delete Row(s) button.

  • Click Save.

 

DOI

The DOI tab displays the DOIs for the select facility and Exception DOIs associated with the facility. The DOIs and exceptions displayed within this tab are for the selected facility and not for the selected/highlighted Facility Charge. Using this tab allows users to quickly and conveniently create a DOI if needed and set up DOI exceptions for facility charges without having to leaving the Facility Charge Maintenance screen.

In Edit mode, the DOI screen allows users to edit/create DOIs and to edit/create Facility Charge DOI Exceptions. This screen is similar to the DOI screen accessible from the menu, except that notes cannot be entered from within Facility Charges. See DOI (Division of Interest) for more information on how to create/edit a DOI. 

 

Facility Charge DOI Exceptions

DOI Exceptions apply an Extension Number to a specific DOI at a Facility/Well/Tract. This number then is applied to the Facility Charge so that Qbyte Metrix will link to the correct DOI for the Expense and the correct DOI for the Revenue side of the entry.

  • If no DOI Exceptions are set up for the Expense side and it is for Wells/Tracts, Qbyte Metrix will look for the Well/Tract default DOI.

  • If no DOI Exceptions are set up for the Revenue side, then Qbyte Metrix will book all the Revenue to 100% the Owning Company.

In order to establish a DOI Exception, the DOI must be set up first. Prior to setting up the DOI Exception, the Product, and Expense (Charge) Type that the DOI Exception will be utilized for should be identified.

Click Edit to open the screen.

Action Buttons include Save, Revert, Cancel, and Create New.

Click Create New to add a record.

CREATE NEW EXCEPTION DOI FIELDS

CREATE NEW EXCEPTION DOI FIELDS

Product

  • N/A, RAWGAS, OIL, GAS, H2O, COND, LPGNGL, C3, C4, C5, C2, SUL.

  • Corresponds to the Facility Charge.

DOI Extension ID

User-defined. Must be a higher number than the Default DOI.

Effective Date

The date the DOI will be effective from.

Charging Entity Type

  • Battery, GGS: Plant, Unit.

  • Must match the Charge being set up.

Charging Entity ID

  • Corresponds to ID.

  • Must match the Charge being set up.

Charge Type

Enter the Charge Type the DOI will apply to on the Facility Charge Master. This must match the Charge being set up.

Revenue/Expense

Choose Revenue or Expense.


Factors

The Factor tab/Global Factors is where a user can identify and establish the characteristics of factors to be used in the Formula Builder. These factors are referenced within the Formula when a System Value of User-Defined Global Factor with a specific ID is identified. These IDs are set up and maintained under the Factor tab for all factors except Global Level Factors. Global Factors are set up at the Menu level. Global Factors roll with each month end and the values will stay as is until modified by the user.

The different types of Factors that are available are:

NAME/DESCRIPTION

NAME/DESCRIPTION

Global Level

This level only requires a Factor ID, Factor Description, and Factor. A global level factor would generally be used for a charge that has the same rate and spans multiple Control Groups (i.e., Overhead Fees).

This can only be set up through the menus.

Facility Level

This level requires a valid Facility Type and Facility ID along with the Factor ID, Description and Factor. The Facility level factor is used to provide different rates to the same expense master. This allows unique rates at different facilities with the same charge.

Expense Level

This level requires all the above input as well as the product code, expense type, and sequence number. This factor is generally used for a charge that is related to a specific expense type.

Well Specific Level

This level requires all the above input as well as a valid Well ID. This factor is generally used for a charge that is Well-specific.



Global Factors

Factors are set up at the Menu Level.

Action buttons include Cancel, Create New, Delete Row, Save, and Revert.

CREATE NEW GLOBAL FACTOR FIELDS

CREATE NEW GLOBAL FACTOR FIELDS

ID 

  • Enter a unique ID (16 Characters).

Description

  • Enter a Description (40 Characters).

Factor

  • Enter the factor to be used.

Select Save. The Factor is now available for use in a Formula.



Entity Level Factors

Entity Level Factors (Facility Level, Expense Level, and Well Level) are set up through Explorer/ Facility Charges.

Click Edit to open the screen for editing and to Create New.

Click Create New to open a new window.

Action Buttons include Save, Revert, Delete, and Cancel.

CREATE NEW FACTOR FIELDS

CREATE NEW FACTOR FIELDS

Factor Level

Facility Level, Facility Charge plus well, and Facility Charge Level.

Input

  • Yes/No.

  • Relates to the Value definition and/or Volume definition.

Factor

  • Enter the value to be used.

  • This can be Value, Volume or Rate.

Global Factor ID

  • Enter a unique ID (16 Characters).

Description

  • Enter a description for this new Factor (40 Characters).

Input Type

  • Volume, Value, or Rate.

Facility Type/ID

  • Battery, Plant, GGS, or Unit.

  • Where the Charge is set.

  • Must match the Charge that will be using this Factor.

Product

Optional, depends on Factor level.

  • Must match the Charge that will be using this Factor. 

Charge Type

  • See Appendix B.

  • Must match the Charge that will be using this Factor.

Sequence Number

Unique identifier.

  • Must match the Charge that will be using this Factor. 

Well/Tract

Well or Tract; Optional depending on the Factor level.

  • Must match the Charge that will be using this Factor.

Well ID/Name/UWI

Corresponds to Well/tract.

  • Must match the Charge that will be using this Factor.

Enter the values enabled by the Factor level chosen and click Save.

The Factor is now available for use in a Formula.

Note: For each factor level different fields are required (see the screenshots).

 

Monthly Factor Input

Factors that are set up in a Facility Charge Master to require monthly data are entered on this screen.

  • Click Edit then highlight the line to be edited. 

  • The details for the line will appear below the grid with a field to enter the current month’s factor data.

  • Click Save.

 

Monthly Input

Facility Charge Monthly Input functionality allows users to enter or upload volumes/values that are not available within Qbyte Metrix or require some adjustment prior to use in facility charge calculations. These volumes/values can be used as the base for facility charge calculations at a well/Owner or other entity level. Formulas that require monthly data entry will create an entry in this table using typical Control Group access security. Data can be imported or entered manually.

The Monthly Input primary retrieval type is available within the Monthly Input screen. This new primary retrieval type is used to link the volumes/values on the Monthly Input screen to Facility Charge formulas.

  • To set up a Facility Charge formula using the data from Monthly Input screen, simply select Monthly Input as the Primary Retrieval Type and enter the Monthly Input ID.

During the Monthly Close, the Monthly Input ID, Monthly Input Name, and all of the Monthly Input data within the Monthly Input tab will all be retained. The Base Value of the Monthly Input Data will be initialized to zero, the Source Type will be set to Manual, and the Active Status will be set to Yes. If a new spreadsheet upload occurs in the new month, matching Monthly Input rows will be updated.

The Security Component (FCMonthlyInputEdit) must be added to the Role of the users that require access to the Facility Charge Monthly Input screen. Only users with Full Access will be able to Create New or Edit Monthly Inputs.

 

Facility Charge Monthly Input - Screen

Facility Charge Monthly Inputs are created and maintained on the Facility Charge Monthly Input screen.

  • This screen can be found under the Facility Charges – Monthly Inputs tabs. From this screen the user is able to view existing Facility Charge Monthly Inputs by typing the name or ID directly into the Monthly Input ID/Name field. Authorized users are also able to Create New or Edit Monthly Inputs.

Action buttons include Create New and View.

Click Create New.


All fields on this screen are mandatory input fields. The Monthly Input IDs created on this screen will be linked to Facility Charge formulas.

Action Buttons include Upload Monthly Input, Cancel, Save, Revert, Delete, and Usage.

MONTHLY INPUT CREATE NEW FIELDS

MONTHLY INPUT CREATE NEW FIELDS

Production Date

  • Defaults to current or can be entered.

Monthly Input Id

  • Unique ID (16 Characters max).

Monthly Input Name

  • Unique Name (40 Characters max).


Clicking the Save button will open the Edit screen.

Within this screen, the user can manually input or upload data into the Monthly Input table for use in facility charge calculations.

Action Buttons include Upload Monthly Input, Cancel, Save Revert, Delete, Usage, and Create New

Facility Charge Monthly Input - Manual Data Entry

To manually set up the information to be used for facility charge calculations, click the Create New button.

Action Buttons include Save, Save and Create New, Revert, and Cancel.

MONTHLY INPUT FIELDS

MONTHLY INPUT FIELDS

Expense Entity Type

Well, Plant, GGS, Injection Facility, Battery and Unit or Tract.

Expense Entity Id

Corresponds to Type.

Owner Id

Optional. Used to limit entities affected.

For example, if an Owner is identified in this field, only that Owner will be charged (regardless of whether the Owner is set up in the DOI for the Expense Entity or not).

  • If the Owner ID field is left blank, the DOI for the expense entity will be used. 

Base

  • Mandatory.

  • Volume or value that will be used as the Basis for the Facility Charge.

Charge Entity Type

  • Optional.

  • Used to limit which entities will use the data. 

Charge Entity ID

Corresponds to Entity Type.

  • For example, if left blank, the same product volume can be used to charge fees across multiple gathering systems/plants.

  • If a Charge Entity is identified in this field, then the product volume can only be used at the specified entity.

Product

  • Optional.

  • This is used to select the product to be used in the charge.

  • For example, if left as the default (N/A), the volume/value entered can be used in charges for multiple products. If a specific product is selected the fee can only be applied to that product.

Charge Type

  • Optional – Used to limit which Facility Charge types will use the Monthly data. i.e. If left blank the same product volume can be used for a variety of fees (gathering, compression and processing etc.) at multiple facilities. If a specific Charge Type and sequence number are identified in conjunction with an entity, then the same product volume would only be used for that Charge Type and sequence at the indicated entity (a certain compression fee at a specific gathering system, etc.).

Charge Seq#

  • Optional.

  • This corresponds to Type.

Enter the fields that are required by your situation.

Clicking the Save button will add the data to the Monthly Input table. Save and Create New will commit the data to the Monthly Input table and advance to the next line to be created.

Lines within the Monthly Input table can be edited by selecting them. All of the fields for the selected line are editable except the Expense Entity Type and the Expense Entity ID.

Selected lines may also be deleted or deactivated. Deactivating a line will retain the data in the table but Active Status will be changed to No and the data will not be used for facility charge processing.

To facilitate navigation of the Monthly Input table, sorting and filtering is available on all columns except the Base.

If several monthly input rows are required with similar values (i.e. multiple Owners for the same well), the Duplicate button will copy and paste the data from the row the user is currently editing into a new row for quick set-up. 

The user can then modify the data for that one record and save it. 

  • If the user does not modify the newly duplicated record and tries to save, duplicate record errors will result.

  • The user may only duplicate one row at a time. The Duplicate button appears when editing a specific record.

 

Facility Charge Monthly Input - Upload

As an alternative to manually entering the monthly inputs, a file can be uploaded in order to populate the Monthly Input table. The upload file must be a CSV file which is case sensitive (all capitals) and should be in the following format:

  • Date, Monthly Input ID, Charge Entity Type, Charge Entity ID, Product, Charge Type, Charge Sequence, Expense Entity Type, Expense Entity ID, Owner ID, Base. 

  • For details on the layout see Facility Charge Monthly Input Upload.

The Date and Monthly Input ID in the CSV file must match the Date and Monthly Input ID you are uploading data into.

Below is an example of an upload.

To upload the file, click the Upload Monthly Input button.

When the Upload Monthly Input pop-up screen appears, click the Add button to find and select the CSV file. After the file has been added, click the Import button to upload and validate.

If there are no validation errors in the file you will return to the Monthly Input tab.

The Results tab will show you the validation on the file.

If errors were found within the file, you are automatically taken to the Results tab in order to review the errors found. When a line is highlighted within the Error Message section, the file line number(s) and charge details for the selected message will be displayed in the Error Details section.

The Monthly Input tab will show only those lines free of validation errors.

Errors can be addressed by correcting the data within the CSV file and re-importing or by manually creating the lines on the Monthly Input tab.

Unlike manually input lines, only the Base field can be edited on lines that have been created from a Monthly Input Upload.

A line created by a Monthly Input Upload cannot be deleted. If the Delete button is selected, the line will be retained and be deactivated instead.

The Upload File column in the Monthly Input table will indicate if a line has been created from a Monthly Input Upload or by manual input.

 

Facility Charge Monthly Input - Monthly Input Primary Retrieval Type

The Monthly Input Primary Retrieval Type is available within the Monthly Input screen. This Primary Retrieval Type is used to link the volumes/values on the Monthly Input screen to Facility Charge formulas.

To set up a facility charge formula using the data from Monthly Input screen, simply select Monthly Input as the Primary Retrieval Type and enter the Monthly Input ID.

Facility Charge Monthly Input - Monthly Close

During the Monthly Close, the Monthly Input ID,  Monthly Input Name, and all of the Monthly Input data within the Monthly Input tab will all be retained. The Base Value of the Monthly Input Data will be initialized to zero, the Source Type will be set to Manual, and the Active Status will be set to Yes. If a new spreadsheet upload occurs in the following month, the retained data rows will be updated accordingly.

 

Facility Charge Schematic Filtering

Upon entering the Facility Charge screen, the Facility Charge Schematic will show all entities attached to the Control Group. Entities that have at least one facility charge attached to it will be bolded.

A Charge Type field and Active field is available above the Facility Charge Schematic.

 

Charge Type

Upon selecting a specific charge type using the drop-down menu, the Facility Charge Schematic will change so that only facilities containing facility charges using the indicated Charge Type will be bolded.

Changing the Charge Type field back to a blank value will return the user to the default view.

  • All facilities with charges are highlighted.

 

Active 

See the following link above:

For more detailed information, see:

 

Facility Charge Copy

Mass Copy of Charges allows you to copy all Charges or a specific Charge for a Control Group/Facility to either the same Control Group/Facility or a different Control Group for a range of time. Within this Charge copy, the system gives you the option to also include the Formula in the copy process. If the Formula is included in this copy process, then the system will allow you to determine if you would like to copy the other feature of the charge – Owners, Entity Linkages, From/To, and Purchaser Setups.

If the Charge(s) that is being copied already exists in the date ranges you are copying to for the Control Group you are copying to, then an option to Update the existing Charge or Ignore the existing Charge is provided.

Qbyte Metrix offers users the ability to copy a Facility Charge in three different ways:

1.  From One Month to Another.

2. From One Control Group to Another.

3. From One Entity to Another in the Same Control Group.

 

Copy from One Month to Another

By default, the Duplication Type is set to From one Month to another which assumes you are copying a Facility Charge from one entity to the same entity in a different month(s). As with other Qbyte Metrix Copy Features, the two-phase copy starts with selecting the Facility Charge(s) you want to copy (called the Source) and then identifying where the Facility Charge(s) should be copied to (called the Destination).

1. In the Source section, begin entering mandatory fields for the Control Group and Entity Id.

  • If you know Product and Charge Type, you can also use the drop-down list to make a selection. 

  • If you do not know which Charge Type or Product you want to copy, click the View Source button and the entire list will be populated for you to choose from. 

2. Next, select a row (by clicking anywhere in the row to highlight it) for the Facility Charge that you want to copy. You may select more than one or Select All.

3. In the Destination section, populate the Start Date, choose to include Entities, Owners, From/To, and Purchaser.

  • You can also update the Charge if one already exists, but you would likely overwrite it.

  • If you choose Yes to  Update Charge,  Update Formula becomes visible.

At this point you can choose to update the formula as well.

  • Yes, is selected by default for Update Formula.

  • Update Factor and Update Shutin Table will then become enabled and customizable.

4. Select View Destination.

To duplicate:

1. Highlight the row in the Destination grid.

2. Click Perform Duplication. If that charge is used elsewhere, a pop up showing the impact your duplication will have will be displayed.

3. Click Continue with Save if you would like to proceed.

  • Otherwise, Cancel will take you back so you can modify the selections you made in the Destination.

    • If the charge did not exist before, there will be a green confirmation on the top of the screen indicating the Duplication results are saved.

    • If the charge already exists and it appears that you have not actually made any changes, an additional message will be displayed in green.

The Source section will retain all the original selections from before. This allows you to move faster through copying Facility Charges without having to re-enter the source data if you have multiple charges to be copied.

Action Buttons include Reset, View Source, Select All, Deselect All, View Destinations, Perform Duplication, and Print Friendly.

COPY CHARGE FIELDS

COPY CHARGE FIELDS

Production Date

Defaults to the Current or Enter a Date.

Control Group

Use type-ahead.

Entity Type

Plant, GGS, Injection Facility, Battery, or Unit.

Entity ID

Corresponds to Type. 

Product 

N/A, RAWGAS, OIL, GAS, H2O, COND, LPGNGL, C3, C4, C5, C2, SUL.

Charge Type

Seq

  • Unique #.

To Start Date

Enter the first month to start Copy into.

To End Date

Enter the last month to Copy into.

 

COPY CHARGE FLAGS

COPY CHARGE FLAGS

Include

Entities, Owners, From/To, Purchaser

Update Charge

Yes/No.

  • Yes, will replace the existing Charge.

  • No, will leave existing.

Update Formulas

Yes/No.

  • Yes, will replace the existing Formula.

  • No, will leave existing.

Update Factor

Yes/No.

  • Yes, will replace the existing Factor.

  • No, will leave existing. 

Update Shutin Table

Yes/No.

  • Yes, will replace the existing Shutin Table.

  • No, will leave existing. 

 

From One Control Group to Another

When moving to another Duplication Type, the Source data is retained from before.

  • Click View Source to see the grid again.

  • Select the charge you wish to duplicate.

You now have the option to copy to another Control Group. You will need to enter the Control Group, Entity Type, and Entity ID. The rest of the customization options are the same as before.

1. Click View Destination.

2. Highlight the charge.

3. Click Perform Duplication.

Action Buttons include Reset, View Source, Select All, Deselect All, View Destinations, Perform Duplication, and Print Friendly.

 

From One Entity to Another in the Same Control Group

1. Enter all the Source information.

  • If you were working on a different Duplication Type previously, the Source information will be retained.

2. Select the Facility Charge you wish to copy and enter the Destination information as per previous screens.

3. Select which options you would like to include with the Copy.

4. Select View Destination.

5. Highlight the charge and select Perform Duplication.

Action Buttons include Reset, View Source, Select All, Deselect All, View Destinations, Perform Duplication, and Print Friendly.

 

Copy from within a Facility Charge

A Facility Charge can be copied from within the Facility Charge Maintenance screen when creating a New Facility Charge.

 

Detached Facility Charges

Detached Facility charges are created when a Facility with Facility Charges is detached from a Control Group. These detached Facility Charges will exist with an Active Status of Detached until the Facility is re-attached to a Control Group , in which case they become Active again under the new Control Group. If the facility is not re-attached to a Control Group prior to the Control Group they were detached from being closed, then the Detached charges are deleted when that Control Group is closed (during its Region Close).

  • When copying Facility Charges using any of the Duplicate Types (mentioned above), the Source grid will never show any Detached Facility Charges.

  • All displayed Source Charges will contain an Active Status of Yes or No.

  • Once Facility Charges are selected to be copied and the View Destination button is clicked, if there are any Detached Facility charges in the Destination, they will be displayed in the Destination grid with an Active status of Detached.

When the Perform Duplication button is clicked, any selected Detached Charges will be updated regardless of the Update Charge option.



Copy Facility Charge Formulas

Action buttons activate when data is entered. Actions buttons include View Source, Select All, Deselect All, View destination, Perform Duplication, and Print Friendly.



How to Move Facility Charges between Control Groups

Monthly Processes

Step Processing

Facility Charges are calculated at Step04 – Facility Charges. Processing is done at the Control Group level in Explorer.

To be able to run the Facility Charge process, the Control Group must be at Step 3 or higher except when you have the Function Implementation flag (Administration → System Configuration → Function Implementation) enabled to allow you to run Step 4 (Facility Charges) when the Control Group is only at Step 2 (Sales and Transfers).



Facility Charges at a Parent Product

For Facility Charges setup at a Parent product level, the actual charge calculation will be based on the accumulation of all products that are considered to be under that product, including itself.

For example, a charge set up on C4 would be based on the accumulation of any C4, C4MX, C4SP, IC4MX, IC4SP, NC4MX, and NC4SP data, of the appropriate primary retrieval type, for the entities being charged.

 

Region Close

Both Active and Inactive Facility Charges are copied to the new month during the Region Close process. The status (Active/Inactive) will remain the same in the new month.

 

System Configuration

Configuration

Exclude Master Owner is a corporate setting that will automatically exclude the Master Owner from all facility charges.

  • This corporate setting can be overridden during facility charge set up by Including or Excluding the master Owner on the Facility Charge Owner Exception screen. 

If GST rate is set, Qbyte Metrix will calculate and charge GST to the Owners associated with the charge.

If there is also a Provincial Tax (PST) rate set up for the province of the charge facility, the Owners will also be charged PST.

 

Functional Implementation

The Allow Facility Charge calculation before Pricing option allows you to decide whether to run Step 4 (Facility Charges) when a Control Group is only at Step 2 (Sales and Transfers).

  • If this flag is set to Yes, you are allowed to run Step 4 without entering any prices, i.e., run Step 4 before Step 3 is complete.

Financial Definitions

If Qbyte Metrix is configured to calculate GST and/or PST, additional Account and Entry definitions will be required for financial bookings. The General accounts used for GST/PST are DEDG – GST on Facility Charge and DEDP – PST on Facility Charge.

Note: An entry definition will be required for each Specific Account (i.e. OVHD) on which GST/PST will be charged.

Below are examples of possible Account and Entry Definitions.

 

GST Account Definitions



 GST Entry Definitions


PST Account Definitions

PST Entry Definitions 

PST1.jpg



Security Components

Use the security component GlobalFcFormulaEdit to control access to the Facility Charge Global Formula Maintenance screen.

MaintainRole.jpg

 

Use the security component:

  • FacilityChargeEdit to grant access to create/edit Facility Charges.

  • FacilityChargeFormulaEdit to grant access to edit Local Formulas.

  • FacilityChargeMonthlyInputEdit to grant access to edit Monthly Input Factors.

MaintainRole2.jpg



Reports

Master Reports

Calculation Reports

Financial Reports

 

Appendix

Appendix A - Primary Retrieval Types

Primary Retrieval

Description

Valid Exceptions

Primary Retrieval

Description

Valid Exceptions

Consumption: Acid Gas Volume

  • Acid Gas volume for charge facility.

  • Calculate/Split on Owners based on DOI (Charge Facility default or Expense Exception).

  • Owner selections will be ignored. 

  • Charge Facility should be a plant.

None

Consumption: Acid Gas Volume by WIO

  • Acid Gas volume for charge facility.

  • Calculate on charge facility and allocate to Owners based on charge facility default DOI.

  • Owner selections applied during calculation.

  • Re-split expense only if expense exception DOI.

Owners

Consumption: Facility Acid Gas by WIO

  • Acid Gas volume for well/tract/owner at charge facility. 

  • Calculate on volumes allocated to well/tract/owner level from Acid Gas Usages at charge facility in Step 1 processing. 

  • Owner selections applied during calculation. 

  • Re-split only if expense exception DOI.

  • Charge facility must be a plant.

  • Volumes allocated to Outside Receipts will not be charged.

Entities, Owners

Consumption: Facility Flare by WIO

  • Flare volume for well/tract/owner at charge facility. 

  • Calculate on volumes allocated to well/tract/owner level from Flare Usages at charge facility in Step 1 processing. 

  • Owner selections applied during calculation. 

  • Re-split only if expense exception DOI.

  • Volumes allocated to Outside Receipts will not be charged.

Entities, Owners

Consumption: Facility Lease Fuel by WIO

  • Lease Fuel volume for well/tract/owner at charge facility. 

  • Calculate on volumes allocated to well/tract/owner level from Lease Fuel Usages at charge facility in Step 1 processing. 

  • Owner selections applied during calculation. 

  • Re-split only if expense exception DOI.

  • Volumes allocated to Outside Receipts will not be charged.

Entities, Owners

Consumption: Facility Vent by WIO

  • Vent volume for well/tract/owner at charge facility. 

  • Calculate on volumes allocated to well/tract/owner level from Vent Usages at charge facility in Step 1 processing. 

  • Owner selections applied during calculation. 

  • Re-split only if expense exception DOI. 

  • Volumes allocated to Outside Receipts will not be charged.

Entities, Owners

Consumption: Wellhead Flare

  • Wellhead Flare volume for well. 

  • Calculate/Split on owners based on DOI (Entity default or Expense Exception). 

  • Owner selections applied during calculation. 

  • Charge Facility should be a battery.

Entities, Owners

Consumption: Wellhead Lease Fuel

  • Wellhead Lease Fuel volume for well. 

  • Calculate/Split on owners based on DOI (Entity default or Expense Exception). 

  • Owner selections applied during calculation. 

  • Charge Facility should be a battery.

Entities, Owners

Consumption: Wellhead Vent

  • Wellhead Vent volume for well. 

  • Calculate/Split on owners based on DOI (Entity default or Expense Exception). 

  • Owner selections applied during calculation. 

  • Charge Facility should be a battery.

Entities, Owners

Deliveries: Disposition Volume by WIO

  • Product disposition volume for well/tract/Owner at charge facility.

  • Calculate on volumes allocated to well/tract/Owner level at charge facility in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Product cannot be Oil, Water, or NA.

Entities, Owners, From/To

Deliveries: Emulsion Volume from Facility

  • Water delivery volume calculated and allocated (in Facility Charges) to wells attached to the battery based on water production at the wells PLUS oil sales volume from the same battery for each well allocated water. 

  • Split on Owners based on DOI (Entity default or Expense Exception).

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable.

  • Charge Facility should be a battery.

Entities, Owners, From/To

Deliveries: Emulsion Volume by WIO with Outside Receipts

  • Water disposition volumes with a matching Oil disposition (same disposition type, destination facility, and sequence number) included.

    • Water volumes will be allocated between production and water receipts and traced back until fully allocated to a producing well or a battery-level (outside receipt).
      Note: If the water is traced back to a battery with no water production or receipts then the volume will be allocated to the battery and the battery DOI will be used to split the water volume.

    • Water volume allocated back to a well will use the well's default DOI.
      Note: Unitized wells will need a DOI entered.

    • Water volume allocated back to a battery (outside receipt) will use the battery's default DOI.

    • Oil disposition volumes are at the owner-level from Step 2 processing.

      • Oil volume from an outside receipt will be based on the owner entered on the outside receipt.
        Note: Injection dispositions will not be included.

  • From/To exceptions, including sequence numbers, can be used to control which dispositions are to be included/excluded.
    Note: The requirement that there must be a matching oil disposition still applies regardless of the From/To exceptions entered.

  • Entity exceptions can be used.
    Note: Outside receipt volumes allocated back to a battery-level will always be included in the charge as only well/tracts can be on the Entity Exceptions list.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Charge Facility must be a battery.

  • Charge Product must be Not Applicable.
    Note: Water volumes will be at the well level, even for unitized wells, but the oil volumes will typically be at the tract level. If you include/exclude a unit well but not the tracts, then you will be including/excluding only the water volume. Similarly, if you include/exclude tracts but not the wells, then you will be including/excluding only the oil volume. Since the oil is at the tract level (sum of all wells in the unit) there is no way to include/exclude a single well in a multi-well unit.

Entities, Owners, From/To

Deliveries: Emulsion Volume by WIO without Outside Receipts

  • Water disposition volumes with a matching Oil disposition (same disposition type, destination facility, and sequence number) included.

    • Water volumes will be allocated between production and water receipts and traced back until fully allocated to a producing well or a battery-level (outside receipt).
      Note: If the water is traced back to a battery with no water production or receipts, then the volume will be allocated to the battery and the battery DOI will be used to split the water volume.

    • Water volume allocated back to a well will use the well's default DOI.
      Note: Unitized wells will need a DOI entered.

    • Water volume allocated back to a battery (outside receipt) will not be included.

    • Oil disposition volumes are at the owner-level from Step 2 processing.

      • Oil volume from an outside receipt will not be included.
        Note: Injection dispositions will not be included.

  • From/To exceptions, including sequence numbers, can be used to control which dispositions are to be included/excluded.
    Note: The requirement that there must be a matching oil disposition still applies regardless of the From/To exceptions entered.

  • Entity exceptions can be used.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Charge Facility must be a battery.

  • Charge Product must be Not Applicable.
    Note: Water volumes will be at the well-level, even for unitized wells, but the oil volumes will typically be at the tract-level. If you include/exclude a unit well but not the tracts, then you will be including/excluding only the water volume. Similarly, if you include/exclude tracts but not the wells, then you will be including/excluding only the oil volume. Since the oil is at the tract-level (sum of all wells in the unit) there is no way to include/exclude a single well in a multi-well unit.

Entities, Owners, From/To

Deliveries: Oil Volume

  • Total product sales volume for well/tract (does not include battery-to-battery transfers). 

  • Split on Owners based on DOI. (Entity default or Expense Exception.)

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable. 

  • Charge Facility should be a battery.

Entities, Owners, From/To

Deliveries: Oil Volume by WIO

  • Oil delivery volume for well/tract/Owner at charge facility (includes battery-to-battery transfers).

    • Oil delivery volume allocated back to an outside receipt will not be included.

  • Calculate on volumes allocated well/tract/Owner level at charge facility in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge Facility must be a battery.

Entities, Owners, From/To

Deliveries: Oil Volume by WIO with Outside Receipts

  • Oil delivery volume for well/tract/Owner at charge facility (includes battery-to-battery transfers).

    • Oil delivery volume allocated back to an outside receipt will be included. The charge will be expensed to the Sending Battery associated with the outside receipt.

  • Calculate on volumes allocated well/tract/Owner level at charge facility in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge Facility must be a battery.

Entities, Owners, From/To

Deliveries: Water Volume

  • Water delivery volume calculated and allocated (in Facility Charges) to wells attached to the battery based on water production at the wells. 

  • Split on Owners based on DOI. (Entity default or Expense Exception.)

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable.

  • Charge Facility should be a battery.

Entities, Owners, From/To

Deliveries: Water Volume by WIO

  • Water delivery volume allocated (in Facility Charges) down to wells and/or any water receipts based on water production, split to Owners based on default DOI.

  • Owner selections applied during calculation.

  • Re-split if expense exception DOI.

  • Charge facility must be a battery.

  • Receipts from Delivery Systems and Injection Facilities will not have charges calculated.

Entities, Owners, From/To

Deliveries: Water Volume by WIO (F96)

  • Water delivery volume allocated (in Facility Charges) to wells or facilities that sent the water.

    • Exclude Injection deliveries to the Charge facility,

    • The delivery volume is allocated between water production, water receipts (includes all receipts except Injection receipts from the same battery and Previous Injection receipts) and load water recovery (from Previous Injection ).

      • The share allocated to water production is then allocated down to the wells based on water production.

      • The share allocated to water receipts will then be traced back to each facility that sent the water using this same functionality until all volume has been allocated to wells or facilities.

        • If the sending facility is a gathering system, injection facility, or OFF Production battery then the volume is charged to the facility level. The facility will require a DOI attached and should have a Cost Centre as well to ensure it is booked correctly.

        • If the sending facility is an ON Production battery, then the receipt share is allocated between water production, water receipts (includes all receipts except Injection receipts from the same battery and Previous Injection receipts), and load water recovery (from Previous Injection ).

        • Circular flow will be identified, and each battery will be processed only once per flow path. The allocation will stop when the flow gets back to a battery already processed and the remainder will be allocated to the last facility before the circle is closed.

      • The share allocated to load water recovery is then allocated down to the wells based on load water recovered from Previous Injection. (Injection recovery is ignored because that volume will have come either from battery production which was already included in the allocation or from a receipt which was already included in the allocation.)

  • From/To exceptions, including sequence numbers, can be used to control which deliveries are to be included/excluded.

  • Entity exceptions can be used.

    • Note: Outside receipt volumes allocated back to a battery, gathering system or injection facility will always be included in the charge as only well/tracts can be on the Entity Exceptions list.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Note: Unitized wells and outside receipt facilities (battery, gathering system or injection facility) will need a DOI entered.

  • Charge Facility must be a Battery.

Entities, Owners, From/To

Facility: Charge Per Entity

  • Charge for each well attached at the charge facility, if battery, injection facility or unit, otherwise charge for each well/tract processed at the charge facility.

    • Note: As of Release 25.1, formulas using this retrieval can be used on a charge at an Injection Facility. The wells associated with the Injection Facility will be based on those wells listed on the Injection Balance on the Production, Injection, and/or Project Injection tabs. The well will be considered shutin if the Production, Injection, and/or Project Injection records for the well all have zero volumes.

  • Split on Owners based on DOI (Entity default or Expense Exception).

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity is included in the charge and the Entity's total charge is attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.

Entities, Owners

Facility: Charge Per Entity by WIO

  • Charge for each well attached to the charge facility.

  • Calculate charge at the well level.

  • Split to Owners based on well DOI (Expense Exception DOI or default DOI).

  • Owner selections applied during split which may change the total Charge amount.

  • Charge facility must be a battery, injection facility or unit.

    • Note: As of Release 25.1, formulas using this retrieval can be used on a charge at an Injection Facility. The wells associated with the Injection Facility will be based on those wells listed on the Injection Balance on the Production, Injection, and/or Project Injection tabs. The well will be considered shutin if the Production, Injection, and/or Project Injection records for the well all have zero volumes.

  • For units, only wells attached for "any product" will be charged if the entered Shutin Lookup Table is used.

Entities, Owners

Facility: Charge Per Facility

  • Charge per charge facility. Calculate/Split on Owners based on DOI (Charge Facility default or Expense Exception). 

  • Owner selections will be ignored.

None

Facility: Charge Per Facility by WIO

  • Charge per charge facility. Calculate on charge facility. Split to Owners based on charge facility DOI (Expense Exception DOI or default DOI).

  • Owner selections applied during split which may change the total Charge amount.

Owners

Facility: Number of Entities at Facility

  • Charge based on the count of wells attached at the charge facility, if battery or unit; otherwise charge on the count of wells/tracts processed at the charge facility. 

  • Calculate/Split on Owners based on DOI (Entity default or Expense Exception).

  • Owner selections used to determine which entities to include in the count.

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity is included in the count. 

  • EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.

Entities, Owners

Facility: Number of Entities at Facility by WIO

  • Charge based on the number of wells attached to the charge facility.

  • Calculate on charge facility.

  • Split to Owners based on well DOI (Expense Exception DOI or default DOI).

  • Owner selections applied during split which may change the total Charge amount.

  • Charge facility must be a battery or unit.

  • For units, only wells attached for "any product" will be charged if the entered Shutin Lookup Table is used.

Entities, Owners

Gathered: Inlet Gathered

  • Total plant inlet theoretical volume for well/tract.

  • Calculate/Split on Owners based on DOI (Entity default or Expense Exception). 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed).

Entities, Owners

Gathered: Inlet Gathered by WIO

  • Inlet theoretical volume at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 1 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners

Gathered: Well Gathered

  • Wellhead gas production less wellhead consumption for well. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception).

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed).

  • Charge Facility should be a battery.

Entities, Owners

Gathered: Well Gathered by WIO

  • Wellhead gas production less wellhead consumption for well.

  • Calculate (in Facility Charges) on Owners based on default DOI.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI. Charge facility must be a battery.

Entities, Owners

Gathered: Well-Battery Gathered

  • Battery production less consumption prorated (in Facility Charges) back to wells attached to the battery based on wellhead production less wellhead consumption.

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.) 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed). 

  • Charge Facility should be a battery.

Entities, Owners

Gathered: Well/Battery Gathered by WIO

  • Battery production less consumption allocated (in Facility Charges) to wells attached to the battery based on well production less well consumption, split to Owners based on default DOI.

  • Owner selections applied during calculation.

  • Re-split if expense exception DOI.

  • Charge facility must be a battery.

Entities, Owners

Monthly Input

  • Charge based on monthly entered/uploaded amounts.

  • If no Owner specified, then split to entity default DOI.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Note: As of Release 25.1, formulas using this retrieval can be used on a charge at an Injection Facility.

Entities, Owners

Production: Emulsion Volume

  • Sum of oil production volume and water production volume for well. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.).

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed). 

  • Charge Facility should be battery.

Entities, Owners

Production: Emulsion Volume by WIO

  • Sum of oil production volume and water production volume for well.

  • Calculate (in Facility Charges) Owners based on default DOI.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge facility must be a battery.

Entities, Owners

Production: Royalty TIK at Facility by WIO

  • Royalty TIK volume (freeholds/overrides) at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 1 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners

Production: Volume

  • Total product production volume for well/tract.

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.)

  • Owner selections applied during calculation.(EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed).

Entities, Owners

Production: Volume at Facility by WIO

  • Product production volume at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 1 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners

Production: Wellhead Gas Production

  • Wellhead gas production for well.

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception). 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

  • Charge Facility should be a battery.

Entities, Owners

Production: Wellhead Gas Production by WIO

  • Wellhead gas production for well.

  • Allocate (in Facility Charges) to Owners based on default DOI for calculation.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge facility must be a battery.

Entities, Owners

Receipts: Emulsion Volume

  • Water receipt volume allocated (in Facility Charges) to wells in battery that sent the water based on water production PLUS oil receipt volume from the same battery allocated (in Facility Charges) to each well allocated water. 

  • Split on Owners based on DOI. (Entity default or Expense Exception.)

  • If there is an INCLUDE Owner list, and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable. 

  • Charge Facility should be a battery.

Entities, Owners

Receipts: Emulsion Volume by WIO with Outside Receipts

  • Water receipt volumes with a matching Oil receipt (same sending facility and sequence number) included.

    • Water volumes will be allocated between production and water receipts and traced back until fully allocated to a producing well or a battery-level (outside receipt).
      Note: If the water is traced back to a battery with no water production or receipts, then the volume will be allocated to the battery and the battery DOI will be used to split the water volume.

    • Water volume allocated back to a well will use the well's default DOI.
      Note: Unitized wells will need a DOI entered.

    • Water volume allocated back to a battery (outside receipt) will use the battery's default DOI.

    • Oil receipt volumes are at the owner-level from Step 2 processing.

      • Oil volume from an outside receipt will be based on the owner entered on the outside receipt.
        Note: Injection and Previous Injection receipts will not be included.

  • From/To exceptions, including sequence numbers, can be used to control which receipts are to be included/excluded.
    Note: The requirement that there must be a matching oil receipt still applies regardless of the From/To exceptions entered.

  • Entity exceptions can be used.
    Note: Outside receipt volumes allocated back to a battery-level will always be included in the charge as only well/tracts can be on the Entity Exceptions list.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Charge Facility must be a battery.

  • Charge Product must be Not Applicable.
    Note: Water volumes will be at the well-level, even for unitized wells, but the oil volumes will typically be at the tract-level. If you include/exclude a unit well but not the tracts, then you will be including/excluding only the water volume. Similarly, if you include/exclude tracts but not the wells, then you will be including/excluding only the oil volume. Since the oil is at the tract-level (sum of all wells in the unit), there is no way to include/exclude a single well in a multi-well unit.

Entities, Owners, From/To

Receipts: Emulsion Volume by WIO without Outside Receipts

  • Water receipt volumes with a matching Oil receipt (same sending facility and sequence number) included.

    • Water volumes will be allocated between production and water receipts and traced back until fully allocated to a producing well or a battery-level (outside receipt).
      Note: If the water is traced back to a battery with no water production or receipts, then the volume will be allocated to the battery and the battery DOI will be used to split the water volume.

    • Water volume allocated back to a well will use the well's default DOI.
      Note: Unitized wells will need a DOI entered.

    • Water volume allocated back to a battery (outside receipt) will not be included.

    • Oil receipt volumes are at the owner-level from Step 2 processing.

      • Oil volume from an outside receipt will not be included.
        Note: Injection and Previous Injection receipts will not be included.

  • From/To exceptions, including sequence numbers, can be used to control which receipts are to be included/excluded.
    Note: The requirement that there must be a matching oil receipt still applies regardless of the From/To exceptions entered.

  • Entity exceptions can be used.
    Note: Outside receipt volumes allocated back to a battery-level will always be included in the charge as only well/tracts can be on the Entity Exceptions list.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Charge Facility must be a battery.

  • Charge Product must be Not Applicable.
    Note: Water volumes will be at the well-level, even for unitized wells, but the oil volumes will typically be at the tract-level. If you include/exclude a unit well but not the tracts, then you will be including/excluding only the water volume. Similarly, if you include/exclude tracts but not the wells, then you will be including/excluding only the oil volume. Since the oil is at the tract-level (sum of all wells in the unit) there is no way to include/exclude a single well in a multi-well unit.

Entities, Owners, From/To

Receipts: Oil Volume

  • Oil receipt volume at charge facility for well/tract. 

  • Split on Owners based on DOI. (Entity default or Expense Exception.) 

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable. 

  • Charge Facility should be a battery. 

Entities, Owners

Receipts: Oil Volume by WIO

  • Oil receipt volume at charge facility for well/tract/Owner (excludes receipts for Load Oil Injection).

    • Oil receipt volume from an outside receipt will not be included.

  • Calculate on volumes allocated well/tract/Owner level at charge facility in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge facility must be a battery.

Entities, Owners, From/To

Receipts: Oil Volume by WIO with Outside Receipts

  • Oil receipt volume for well/tract/Owner at charge facility (excludes receipts for Load Oil Injection).

    • Oil receipt volume from an outside receipt will be included. The charge will be expensed to the Sending Battery associated with the outside receipt.

  • Calculate on volumes allocated well/tract/Owner level at charge facility in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge Facility must be a battery.

Entities, Owners, From/To

Receipts: Water Volume

  • Water receipt volume at charge facility allocated (in Facility Charges) to wells in battery that sent the water based on water production at the wells. 

  • Split on Owners based on DOI (Entity default or Expense Exception). 

  • If there is an INCLUDE Owner list and at least one Owner on the list is in the DOI for the Entity, then the Entity's total volume is included in the calculation of the charge and attributed to the first INCLUDED Owner in the list.

  • EXCLUDE list of Owners is not applicable. 

  • Charge Facility should be a battery.

Entities, Owners

Receipts: Water Volume by WIO

  • Water receipt volume allocated (in Facility Charges) to wells attached to the batteries that sent the water.

  • Calculate on Owners based on default DOI. Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

  • Charge facility must be a battery.

  • Include receipts for load water purposes unless from within the same battery.

  • Receipts from Delivery Systems and Injection Facilities will not have charges calculated.

Entities, Owners, From/To

Receipts: Water Volume by WIO (F97)

  • Water receipt volume allocated (in Facility Charges) to wells or facilities that sent the water.

    • Include receipts for Load Water purposes unless from within the same battery or a Previous Injection.

    • Exclude receipts from Delivery Systems.

  • From/To exceptions, including sequence numbers, can be used to control which receipts are to be included/excluded.

  • Entity exceptions can be used.

    • Note: Outside receipt volumes allocated back to a battery, gathering system or injection facility will always be included in the charge as only well/tracts can be on the Entity Exceptions list.

  • Owner exceptions are applied during the calculation of the charge. Including/excluding owners impacts which volumes are used when calculating the charge.

  • Using an Expense DOI Extension on the charge impacts how the calculated charge is distributed.

  • Note: Unitized wells and outside receipt facilities (battery, gathering system or injection facility) will need a DOI entered.

  • Charge Facility must be a Battery or Injection Facility.

    • Note: As of Release 25.1, formulas using this retrieval can be used on a charge at an Injection Facility.

  • For each Water receipt processed:

    • When the charge is at an Injection Facility, receipts of both Water and Fresh Water will be accumulated.

      • If there is no sending facility associated with the receipt, or the sending facility is a Delivery System or Unit, then the receipt will be ignored and an appropriate message generated. To have a charge calculated based on these receipts, a dummy battery/ggs/plant should be created to represent the sending facility with a cost centre and DOI.

    • If the sending facility is a gathering system, plant, injection facility or OFF Production battery then the volume is charged to the facility-level. The facility will require a DOI attached and should have a Cost Centre as well to ensure it is booked correctly.

    • If the sending facility is an ON Production battery, then the receipt volume is allocated between water production, water receipts (includes all receipts except Injection receipts from the same battery and Previous Injection receipts) and load water recovery (from Previous Injection).

      • The share allocated to water production is then allocated down to the wells based on water production.

      • The share allocated to water receipts will then be traced back to each facility that sent the water using this same functionality until all volume has been allocated to wells or facilities.

        • Circular flow will be identified, and each battery will only be processed once per flow path. The allocation will stop when the flow gets back to a battery already processed and the remainder will be allocated to the last facility before the circle is closed.

      • The share allocated to load water recovery is then allocated down to the wells based on load water recovered from Previous Injection. (Injection recovery is ignored because that volume will have either come from battery production which was already included in the allocation or from a receipt which was already included in the allocation.)

Entities, Owners, From/To

Sales: Allocated CO2

  • Allocated CO2 volume at charge facility for well/tract/Owner. 

  • Calculated on Step 2 calculated well/tract/Owner volumes. 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners, Purchaser

Sales: Allocated CO2 by WIO

  • Allocated CO2 volume at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: By-Product Volume by WIO

  • Sum of By-Product (excl. Sulphur) gross sales volume at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: By-Product Volume less Roy TIK by WIO

  • Sum of By-Product (excl. Sulphur) sales volume (less royalty TIK) at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Gas and By-Product Value

  • Sum of gas and By-Product sales value for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.)

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed).

Entities, Owners

Sales: Gas and By-Product Value by WIO

  • Sum of gas and By-Product gross sales value at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Gas and By-Product Value less Roy TIK by WIO

  • Sum of gas and By-Product sales value (less royalty TIK) at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Gas and By-Product Value less Transportation

  • Sum of gas and By-Product sales value less transportation costs for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.) 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Gas and By-Product Value less Transportation by WIO

  • Sum of gas and By-Product sales value (less transportation costs) at charge facility for well/tract/Owner. Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Gas and By-Product Volume

  • Sum of gas and By-Product sales volume for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception). 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Gigajoules by WIO

  • Product gross sales gigajoules at charge facility for well/tract/Owner. Calculate on gigajoules allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Gigajoules less Roy TIK by WIO

  • Product sales gigajoules (less royalty TIK sales + crown) at charge facility for well/tract/Owner.

  • Calculate on gigajoules allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Oil Volume Less Crown

  • Total oil sales volume (less crown) for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.) 

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Value

  • Total product sales value for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.)

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Value by WIO

  • Product gross sales value at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Value less Crown by WIO

  • Product sales value (less crown sales) at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Value less Roy TIK by WIO

  • Product sales value (less royalty TIK sales + crown) at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Value less Transportation

  • Total product sales value less transportation costs for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.)

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Value less Transportation by WIO

  • Product sales value (less transportation costs) at charge facility for well/tract/Owner.

  • Calculate on values allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Volume

  • Total product sales volume for well/tract. 

  • Calculate/Split on Owners based on DOI. (Entity default or Expense Exception.)

  • Owner selections applied during calculation. (EXCLUDE list of Owners is not applicable; only INCLUDE list will be processed.)

Entities, Owners

Sales: Volume by WIO

  • Product gross sales volume at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Volume less Crown by WIO

  • Product sales volume (less crown sales) at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

Sales: Volume less Roy TIK by WIO

  • Product sales volume (less royalty TIK sales + crown) at charge facility for well/tract/Owner.

  • Calculate on volumes allocated in Step 2 processing.

  • Owner selections applied during calculation.

  • Re-split only if expense exception DOI.

Entities, Owners, From/To, Purchaser

 

Appendix B - Facility Charge Types as Preloaded

Value

Specific Type

Description

Value

Specific Type

Description

01

TRAN

Gas Transportation Charge

02

TRKG

Oil Trucking Charge

03

EMUL

Emulsion Processing Fee

04

EMTR

Emulsion Trucking Fee

05

TERM

Terminal Charge

11

OVHD

Overhead

12

OVHU

Unit Overhead

21

CONT

Contract Operating

31

PROD

Production Accounting Fee

41

SWDF

Water Disposal Fee

50

PROC

Gas Processing Fee

52

COMP

Gas Compression Fee

54

GATH

Gas Gathering Fee

71

TARF

DED TARF Tariffs

Appendix C - Disposition Types

  • Fuel Sales

  • Return Consumption

  • Purchased Consumption

  • Inventory Transfer

  • Owner to Owner Transfer

  • Owner to Owner Sale

  • Plant to Plant

  • Delivery

  • Injection

  • Transfer

  • Transfer for Market

  • Transfer for Fuel

  • Transfer for Consumption

  • Consumption Lease Fuel

  • Consumption Flared

  • Consumption Vented

  • Consumption Metering Difference

  • Loss due to Fire

  • Loss due to Theft

  • Loss due to Spill

  • Blending Shrinkage

 

Appendix D - Operators

  • Set Value - The chosen factor is a set value, for example, a production or sales volume. 

  • Add - Adds the chosen factor value with the previous line.

  • Deduct - Subtracts the chosen factor value from the previous line.

  • Multiply - Multiplies the chosen factor value and the previous line.

  • Divide - Divides the previous line result with the chosen factor.

  • Subtotal - Creates a Subtotal line in the calculation.

  • Minimum - Determine a minimum value for the chosen factor.

  • Maximum - Determine a maximum value for the chosen factor.

  • Store - A value can be stored and be referenced in the rest of the formula.

  • Round - Round the result of the previous line to the entered number of decimals.

  • Truncate -  Truncates the result of the previous line to the entered number of decimals. 

 

How To

Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.