Spreadsheet Import

Back to Import or Export Back to Well Maintenance Back to Royalty Obligations Back to How To Integrate Royalties Back to How to Integrate Global Factors Back to How To: Spreadsheet Import Partner Operated Sales Back to Consumption Allocation Back to How To: Spreadsheet Import Default Price and Transportation Rates Back to Qbyte Metrix Home

1 Introduction
2 Templates
3 Import by Template
- 3.1 Menu Option
- 3.2 Import Screen
- 3.3 How to Import
4 Import Status Report
5 Appendix
- 5.1 DOIFACILITYCHARGEEXCEPTION (as of Release 23.4)
  - 5.1.1 Template for DOIFACILITYCHARGEEXCEPTION
- 5.2 DOIMASTER (as of Release 23.3)
  - 5.2.1 Template for DOIMASTER
  - 5.2.2 Sample Data for DOIMASTER Template
- 5.3 DOIOWNEXCEPTION (as of Release 23.4)
  - 5.3.1 Template for DOIOWNEXCEPTION
  - 5.3.2 Sample Data for DOIOWNEXCPTN Template
- 5.4 FACILITYCHARGEMONTHLYFACTORVALUE
  - 5.4.1 Template for FACILITYCHARGEMONTHLYFACTORVALUE
  - 5.4.2 Sample Data for FACILITYCHARGEMONTHLYFACTORVALUE Template
  - 5.4.3 Facility Charge Monthly Factor Values After Importing - FACILITYCHARGEMONTHLYFACTORVALUE
- 5.5 FACILITYCONSUSAGEENTITY
  - 5.5.1 Template for FACILITYCONSUSAGEENTITY
  - 5.5.2 Sample Data for FACILITYCONSUSAGEENTITY Template
- 5.6 FACILITYCONSUSAGEENTITYDELETE
  - 5.6.1 Template for FACILITYCONSUSAGEENTITYDELETE
  - 5.6.2 Sample Data for FACILITYCONSUSAGEENTITYDELETE Template
- 5.7 FACILITYCONSUSAGEGENERAL
  - 5.7.1 Template for FACILITYCONSUSAGEGENERAL
  - 5.7.2 Sample Data for FACILITYCONSUSAGEGENERAL Template
- 5.8 FACILITYDEFAULTPRICE
  - 5.8.1 Template for FACILITYDEFAULTPRICE
  - 5.8.2 Sample Data for FACILITYDEFAULTPRICE Template
- 5.9 FACILITYOVERRIDEPRODN
  - 5.9.1 Template for FACILITYOVERRIDEPRODN
  - 5.9.2 Sample Data for FACILITYOVERRIDEPRODN Template
- 5.10 FACILITYOVERRIDEOPNINV
  - 5.10.1 Template for FACILITYOVERRIDEOPNINV
  - 5.10.2 Sample Data for FACILITYOVERRIDEOPNINV Template
- 5.11 INDIANROYALTYGCA
  - 5.11.1 Template for INDIANROYALTYGCA
  - 5.11.2 Sample Data for INDIANROYALTYGCA Template
- 5.12 MMCONTRACTENERGY (as of Release 23.2)
  - 5.12.1 Template for MMCONTRACTENERGY
  - 5.12.2 Sample Data for MMCONTRACTENERGY Template
- 5.13 MMCONTRACTENERGYBYDESC (as of Release 23.2)
  - 5.13.1 Template for MMCONTRACTENERGYBYDESC
  - 5.13.2 Sample Data for MMCONTRACTENERGYBYDESC Template
- 5.14 MMCONTRACTPRICING
  - 5.14.1 Template for MMCONTRACTPRICING
  - 5.14.2 Sample Data for MMCONTRACTPRICING Template
- 5.15 MMCONTRACTPRICINGBYDESC
  - 5.15.1 Template for MMCONTRACTPRICINGBYDESC
  - 5.15.2 Sample Data for MMCONTRACTPRICINGBYDESC Template
- 5.16 MMCONTRACTUNITPRICE
  - 5.16.1 Template for MMCONTRACTUNITPRICE
  - 5.16.2 Sample Data for MMCONTRACTUNITPRICE Template
- 5.17 MMCONTRACTUNITPRICEBYDESC
  - 5.17.1 Template for MMCONTRACTUNITPRICEBYDESC
  - 5.17.2 Sample Data for MMCONTRACTUNITPRICEBYDESC Template
- 5.18 MMCONTRACTUSERINPUT (as of Release 23.2)
  - 5.18.1 Template for MMCONTRACTINPUT
  - 5.18.2 Sample Data for MMCONTRACTUSERINPUT Template
- 5.19 MMCONTRACTUSERINPUTBYDESC (as of Release 23.2)
  - 5.19.1 Template for MMCONTRACTUSERINPUTBYDESC
  - 5.19.2 Sample Data for MMCONTRACTUSERINPUTBYDESC Template
- 5.20 OBLIGATIONFACTORVALUE
  - 5.20.1 Template for OBLIGATIONFACTORVALUE
  - 5.20.2 Sample Data for OBLIGATIONFACTORVALUE
  - 5.20.3 Royalty Obligation Factor Values After Importing - OBLIGATIONFACTORVALUE
- 5.21 OILVALUATIONTRANS
  - 5.21.1 Template for OILVALUATIONTRANS
  - 5.21.2 Sample Data for OILVALUATIONTRANS Template
- 5.22 OWNERGOVTCODEUPD (as of Release 23.4)
  - 5.22.1 Template for OWNERGOVTCODEUPD
  - 5.22.2 Sample Data for OWNERGOVTCODEUPD Template
- 5.23 OWNERMASTER (as of Release 23.4)
  - 5.23.1 Template for OWNERMASTER
  - 5.23.2 Sample Data for OWNERMASTER Template
- 5.24 OWNERNAMEADDRESSUPD (as of Release 23.4)
  - 5.24.1 Template for OWNERNAMEADDRESSUPD
  - 5.24.2 Sample Data for OWNERNAMEADDRESSUPD Template
- 5.25 PARTNEROPPRICING (as of Release 24.3)
  - 5.25.1 Template for PARTNEROPPRICING
  - 5.25.2 Sample Data for PARTOPPRICING Template
- 5.26 PARTNEROPSALES
  - 5.26.1 Template for PARTNEROPSALES
  - 5.26.2 Sample Data for PARTNEROPSALES Template
- 5.27 ROYALTYGLOBALFACTOR
  - 5.27.1 Template for ROYALTYGLOBALFACTOR
  - 5.27.2 Sample Data for ROYALTYGLOBALFACTOR Template
  - 5.27.3 Royalty Global Factors After Importing - ROYALTYGLOBALFACTOR
- 5.28 ROYALTYOBLIGATION
  - 5.28.1 Template for ROYALTYOBLIGATION
  - 5.28.2 Sample Data for ROYALTYOBLIGATION Template
    - 5.28.2.1 By Qbyte Metrix Well ID/Tract ID:
  - 5.28.3 Royalty Obligations After Importing - ROYALTYOBLIGATION
- 5.29 ROYALTYOBLIGATIONDELETE
  - 5.29.1 Template for ROYALTYOBLIGATIONDELETE.
  - 5.29.2 Sample Data for ROYALTYOBLIGATIONDELETE Template
- 5.30 ROYALTYOBLIGATIONFACTOR
  - 5.30.1 Template for ROYALTYOBLIGATIONFACTOR
  - 5.30.2 Sample Data for ROYALTYOBLIGATIONFACTOR Template
  - 5.30.3 Royalty Obligation Factors After Importing - ROYALTYOBLIGATIONFACTOR
- 5.31 ROYALTYOBLIGATIONHDR
  - 5.31.1 Template for ROYALTYOBLIGATIONHDR
  - 5.31.2 Sample Data for ROYALTYOBLIGATIONHDR Template
    - 5.31.2.1 By Qbyte Metrix Well ID/Tract ID:
  - 5.31.3 Royalty Obligation After Importing - ROYALTYOBLIGATIONHDR
    - 5.31.3.1 Well
- 5.32 WELLABOILCROWN (as of Release 24.4)
  - 5.32.1 Template for WELLABOILCROWN
  - 5.32.2 Sample Data for WELLABOILCROWN
- 5.33 WELLCONSBYLABEL
  - 5.33.1 Template for WELLCONSBYLABEL
  - 5.33.2 Sample Data for WELLCONSBYLABEL Template
    - 5.33.2.1 By Qbyte Metrix Well ID:
    - 5.33.2.2 By UWI:
  - 5.33.3 Well Production After Importing - WELLCONSBYLABEL
- 5.34 WELLCONSDELETEBYLABEL
  - 5.34.1 Template for WELLCONSDELETEBYLABEL
  - 5.34.2 Sample Data for WELLCONSDELETEBYLABEL Template
- 5.35 WELLCONSUMPTION
  - 5.35.1 Template for WELLCONSUMPTION
  - 5.35.2 Sample Data for WELLCONSUMPTION Template
  - 5.35.3 Well Production After Importing - WELLCONSUMPTION
- 5.36 WELLCONSUMPTIONUPD
  - 5.36.1 Template for WELLCONSUMPTIONUPD
  - 5.36.2 Sample Data for WELLCONSUMPTIONUPD
  - 5.36.3 Well Production After Importing - WELLCONSUMPTIONUPD
- 5.37 WELLMASTERCREATION
  - 5.37.1 Template for WELLMASTERCREATION
  - 5.37.2 Sample Data for WELLMASTERCREATION Template
- 5.38 WELLMASTERGENERALUPD
  - 5.38.1 Template for WELLMASTERGENERALUPD
  - 5.38.2 Sample Data for WELLMASTERGENERALUPD Template
- 5.39 WELLMASTERGENERALUPDNORESET
  - 5.39.1 Template for WELLMASTERGENERALUPDNORESET
  - 5.39.2 Sample Data for WELLMASTERGENERALUPDNORESET Template
- 5.40 WELLMASTERUWIUPDNORESET
  - 5.40.1 Template for WELLMASTERUWIUPDNORESET
  - 5.40.2 Sample Data for WELLMASTERUWIUPDNORESET Template
    - 5.40.2.1 By Registry ID
    - 5.40.2.2 By Qbyte Metrix Well ID:
- 5.41 WELLPRODUCTIONFACTOR
  - 5.41.1 Template for WELLPRODUCTIONFACTOR
  - 5.41.2 Sample Data for WELLPRODUCTIONFACTOR
    - 5.41.2.1 Production Date
    - 5.41.2.2 Well
    - 5.41.2.3 WGR Factor
    - 5.41.2.4 WGR Test Date
    - 5.41.2.5 Oil Meter Factor
    - 5.41.2.6 EOR/HOR Rate
    - 5.41.2.7 Remaining Gas Option
    - 5.41.2.8 All Oil To Be Recovered
    - 5.41.2.9 All Water To Be Recovered
    - 5.41.2.10 Oil Gas Ratio Factor
    - 5.41.2.11 Oil Gas Ratio Test Date
    - 5.41.2.12 Gas Meter Factor
    - 5.41.2.13 Oil Gas Ratio Code
    - 5.41.2.14 Water Gas Ratio Code
    - 5.41.2.15 Water Meter Factor
    - 5.41.2.16 Battery GOR Exempt
    - 5.41.2.17 Crown Royalty Percent
    - 5.41.2.18 Freehold Royalty Percent
    - 5.41.2.19 Federal Percent
    - 5.41.2.20 Crown Acquired Percent
    - 5.41.2.21 Oil Density
    - 5.41.2.22 Crown Calculation Type
    - 5.41.2.23 Equivalent Use Sub Type
  - 5.41.3 Well Production After Importing - WELLPRODUCTIONFACTOR
- 5.42 WELLWGR
  - 5.42.1 Template for WELLWGR
  - 5.42.2 Sample Data for WELLWGR
  - 5.42.3 Well Production After Importing - WELLWGR
- 5.43 WELLWGROGR
  - 5.43.1 Template for WELLWGROGR
  - 5.43.2 Sample Data for WELLWGROGR
  - 5.43.3 Well Production After Importing - WELLWGROGR

Introduction

Qbyte Metrix can import some master data from spreadsheets to make mass changes easier.

For example, imports can be used for:

Mass changes to well master data for multiple months – You no longer must open for amendment at Step 1 to perform a master change.
Oil/water gas ratios – Input oil/water gas ratios for many wells in a spreadsheet import to update all the wells at once.
Spring/fall fuel rates – Create two spreadsheet imports, one for spring and one for fall fuel rates. Import the appropriate spreadsheet as required.
Create complete or partial royalty obligations for multiple wells/tracts at once.

Templates

Four templates are available to import or modify well master data.
Seven templates have been provided to import or modify well factors and well consumption factors.
One template is available to delete well consumption factors.
One template is available to import or modify royalty global factors.
Two templates are available to import or modify royalty obligation factors.
Two templates are available to import royalty obligations.
One template is available to delete royalty obligations.
One template is available to create/update facility consumption usages.
One template is available to create entity linkages on facility consumption usages.
One template is available to delete entity linkages on facility consumption usages.
One template is available to update facility default price, deduction rates and transportation rates.
Four templates are available to import facility purchaser contract pricing information.
Four templates are available to import facility purchaser contract user input and/or override energy.
One template is available to update facility production overrides.
One template is available to update facility inventory overrides.
One template is available to update facility charge monthly input factors.
One template is available to update oil valuation transportation rates.
One template is available to update IOGC Gas Cost Allowance (GCA).
One template is available to update Partner Operated Sales Transactions.
One template is available to update Partner Operated Battery Prices.
One template is available to create entity-level Division of Interests.
Three templates are available to create/update owner master data.
Two templates are available to create entity-level DOI Exceptions.

Template ID	Template Description	Template Type ID	Usage

Template ID	Template Description	Template Type ID	Usage
DOIFACILITYCHARGEEXCPTN	Create Facility Charge DOI Exceptions	DOIEXCEPTIONS	Create Facility Charge DOI Exceptions for valid entities (Battery, Gathering System, Plant, Tract, Unit, Well). User control group security access to DOIEdit will apply. There will be no checks for locked/closed on impacted entities, and they will not be reset. Available as of Release 23.4.
DOIMASTER	Create Entity Division of Interests	DOIMASTER	Create Division of Interests for valid entities (Battery, Gathering System, Injection Facility, Plant, Tract, Unit, Well). User corporate security access to DOIImportByTemplate will apply. There will be no checks for locked/closed on impacted entities, and they will not be reset. Available as of Release 23.3.
DOIOWNEXCPTN	Create Ownership DOI Exceptions	DOIEXCEPTIONS	Create Ownership Charge DOI Exceptions for valid entities (Tract, Unit, Well). User control group security access to DOIEdit will apply. There will be no checks for locked/closed on impacted entities, and they will not be reset. Available as of Release 23.4.
FACILITYCHARGEMONTHLYFACTORVALUE	Update Facility Charge Global Factor Value	FACILITYCHARGEGLOBALFACTORVALUE	Update Facility Charge Monthly Factor Values. User control group security access to FCGlobalFactorEdit will apply. Impacted control groups must not be locked/closed for Step 4.
FACILITYCONSUSAGEENTITY	Create Entity Linkage on Facility Consumption Usage IDs	FACILITYCONSUSAGE	Create Entity Linkage on Facility Consumption Usage IDs. Input volumes for Entity Linkages cannot be imported. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
FACILITYCONSUSAGEENTITYDELETE	Delete Entity Linkage on Facility Consumption Usage IDs	FACILITYCONSUSAGE	Delete Entity Linkage on Facility Consumption Usage IDs. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
FACILITYCONSUSAGEGENERAL	Create/Update Facility Consumption Usage IDs - No Input Volumes	FACILITYCONSUSAGE	Create/Update Facility Consumption Usage IDs. Input volumes for Usage IDs cannot be imported. To load input volumes for Usage IDs, use Field Data Capture and the CONSUSG layout. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
FACILITYDEFAULTPRICE	Update Facility Default Prices and Transportation Rates	FACILITYDEFAULTPRICE	Update Facility Default Prices, Deduction Rates and Transportation Rates. User control group access to PricingEdit will apply. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.
FACILITYOVERRIDEPRODN	Update Facility Production Overrides	FACILITYOVERRIDE	Update Facility Production Overrides. User control group security access to OverrideProductionEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
FACILITYOVERRIDEOPNINV	Update Facility Opening Inventory Overrides	FACILITYOVERRIDE	Update Facility Opening Inventory Overrides. User control group security access to OverrideOpeningInventoryEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
INDIANROYALTYGCA	Update IOGC GCA by Royalty Entity ID	INDIANROYALTYPRICEUPDATE	Update Gas Cost Allowance by Royalty Entity Type and ID. User corporate access to PriceByRoyaltyIDEdit will apply.
MMCONTRACTENERGY	Update Override GJs	MMCONTRACT	Update Facility Purchaser Contract Override Energy. Purchaser Contract must be for the product GAS or RAWGAS. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. User control group security access to MarketMasterEdit will apply. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes applied. Available as of Release 23.2.
MMCONTRACTENERGYBYDESC	Update Override GJs by Contract Description	MMCONTRACT	Update Facility Purchaser Contract Override Energy using Contract Description to identify Purchaser Contracts. Purchaser Contract must be for the product GAS or RAWGAS. When using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If that occurs an error will be generated, and that data will not be imported. User control group security access to MarketMasterEdit will apply. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes applied. Available as of Release 23.2.
MMCONTRACTPRICING	Update Facility Purchaser Contract Pricing	MMCONTRACT	Update Facility Purchaser Contract Pricing data, including Price Code, Price/Value, Transportation Type/Cost, and Pricing Deduction Type/Cost. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. User control group access to PricingEdit will apply. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.
MMCONTRACTPRICINGBYDESC	Update Facility Purchaser Contract Pricing by Contract Description	MMCONTRACT	Update Facility Purchaser Contract Pricing data, including Price Code, Price/Value, Transportation Type/Cost, and Pricing Deduction Type/Cost using Contract Description to identify Purchaser Contracts. When using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If that occurs an error will be generated, and that data will not be imported. User control group access to PricingEdit will apply. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.
MMCONTRACTUNITPRICE	Update Facility Purchaser Contract Unit Price	MMCONTRACT	Update Facility Purchaser Contract Unit Prices. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. Purchaser Contract must be set up to use Price Per Unit. User control group access to PricingEdit will apply. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.
MMCONTRACTUNITPRICEBYDESC	Update Facility Purchaser Contract Unit Price by Contract Description	MMCONTRACT	Update Facility Purchaser Contract Unit Prices using Contract Description to identify Purchaser Contracts. When using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. All matching records will be updated, if applicable (use Price Per Unit, are not locked/closed for Step03, etc.). User control group access to PricingEdit will apply. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.
MMCONTRACTUSERINPUT	Update User Input Volume and Override GJs	MMCONTRACT	Update Facility Purchaser Contract User Input Volume and Override Energy. Purchaser Contract must have Allocation Method set to User Input. Import of Override Energy is only valid when product is GAS or RAWGAS. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. User control group security access to MarketMasterEdit will apply. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes applied. Available as of Release 23.2.
MMCONTRACTUSERINPUTBYDESC	Update User Input Volume and Override GJs by Contract Description	MMCONTRACT	Update Facility Purchaser Contract User Input Volume and Override Energy using Contract Description to identify Purchaser Contracts. Purchaser Contract must have Allocation Method set to User Input. Import of Override Energy is only valid when product is GAS or RAWGAS. When using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If that occurs an error will be generated, and that data will not be imported. User control group security access to MarketMasterEdit will apply. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes applied. Available as of Release 23.2.
OBLIGATIONFACTORVALUE	Update Royalty Obligation Factor Values	OBLIGATIONFACTORVALUE	Update the factor values for Royalty Obligation Factors. User control group security access to RoyaltiesEdit will apply.
OILVALUATIONTRANS	Update Oil Valuation RTP Overrides	OILVALUATIONTRANS	Update Oil Valuation Overrides for Oil Valuation RTP submissions. User corporate access to OilValuation will apply.
OWNERGOVTCODEUPD	Update Owner Government Codes	OWNERMASTER	Update government codes for Owners. User corporate security access to OwnerEdit will apply. Available as of Release 23.4.
OWNERMASTER	Create/Update Owners	OWNERMASTER	Create a new Owner or update an existing Owner. User corporate security access to OwnerImportByTemplate will apply. Available as of Release 23.4.
OWNERNAMEADDRESSUPD	Update Owner Name and Addresses	OWNERMASTER	Update name, address lines and/or postal code for Owners. User corporate security access to OwnerEdit will apply. Available as of Release 23.4.
PARTNEROPPRICING	Create/Update Partner Operated Pricing	PARTNEROPPRICING	Create or Update Partner Operated Battery Prices. User control group security access to PartnerOpBatteryBalanceEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
PARTNEROPSALES	Update Partner Operated Sales Transactions	PARTNEROPTRANSACTIONUPD	Update Net/Gross Volume, Net/Gross Value, Net/Gross GJs, Net/Gross Transportation, Net/Gross Quality Adjustment, Net/Gross Tariff, Net/Gross Line Loss, Net/Gross Other#1, and Net/Gross Other#2 on Sales Transactions for Partner Operated Wells. User control group security access to PartnerOpBatteryBalanceEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.
ROYALTYGLOBALFACTOR	Create/Update Royalty Global Factor	ROYALTYGLOBALFACTOR	Create/update Royalty Global Factor Masters and Values. User corporate security access to RoyaltyUserDefinedFactorCreateDelete and/or RoyaltyUserDefinedFactorEdit will apply.
ROYALTYOBLIGATION	Create/Update Royalty Obligation Masters	ROYALTYOBLIGATION	Create/update Royalty Obligation Masters. User control group security access to RoyaltiesEdit will apply.
ROYALTYOBLIGATIONDELETE	Delete Royalty Obligation Masters	ROYALTYOBLIGATION	Delete Royalty Obligation Masters. User control group security access to RoyaltiesEdit will apply.
ROYALTYOBLIGATIONFACTOR	Create/Update Royalty Obligation Factor Masters	ROYALTYOBLIGATIONFACTOR	Create/update Royalty Obligation Factor Masters (ID and Description). User corporate security access to RoyaltyUserDefinedFactorCreateDelete and/or RoyaltyUserDefinedFactorEdit will apply.
ROYALTYOBLIGATIONHDR	Create Pending Royalty Obligation Masters	ROYALTYOBLIGATIONHDR	Create Royalty Obligation Masters with minimal data and set Active Status to Pending. User corporate security access to RoyaltiesImportByTemplate will apply.
WELLABOILCROWN	Update Alberta Well Oil Crown Factors	WELLPRODFACTORUPD	Update Alberta Well Oil Crown Factors (Oil Density, Crown Calculation Type, Equivalent Use Sub Type). User control group security access to WellFactorsEdit will apply. Available as of Release 24.4.
WELLCONSBYLABEL	Update Well Consumption Rates by Label	WELLCONSUMPTIONFACTORUPD	Update Rate on Well Consumption Factors using Label to identify the factor. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLCONSDELETEBYLABEL	Delete Well Consumption Factors	WELLCONSUMPTIONFACTORUPD	Delete Well Consumption Factors using Label to identify the factor. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after deletions are applied.
WELLCONSUMPTION	Create/Update Well Consumption Factors	WELLCONSUMPTIONFACTOR	Create/update Well Consumption Factors. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLCONSUMPTIONUPD	Update Well Consumption Factors	WELLCONSUMPTIONFACTORUPD	Update Well Consumption Factors (all fields) using Label to identify the factor. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLMASTERCREATION	Create Well Masters	WELLMASTERCREATE	Create Well Masters. User corporate access to WellMaintenanceEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLMASTERGENERALUPD	Update Well Master General Data (UWI, Name, User-Defined, Pool, etc.)	WELLMASTERUPD	Update general fields (UWI, Name, Field, Pool, Depth, Cost Centre, Partner Operated Petrinex Id, User-Defined1 and User-Defined2) on Well Master. User control group security access to WellMaintenanceEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLMASTERGENERALUPDNORESET	Update Well Master General Data - No Reset (UWI, Name, User-Defined, Pool, etc.)	WELLMASTERUPDNOCHECK	Update general fields (UWI, Name, Field, Pool, Depth, Cost Centre, Partner Operated Petrinex Id, User-Defined1 and User-Defined2) on Well Master. User corporate security access to ImportByTemplateNoReset will apply. There will be no checks for locked/closed on impacted facilities, and they will not be reset.
WELLMASTERUWIUPDNORESET	Update Well Master UWI Data - No Reset	WELLMASTERUPDNOCHECK	Update UWI on Well Master. User corporate security access to ImportByTemplateNoReset will apply. There will be no checks for locked/closed on impacted facilities, and they will not be reset.
WELLPRODUCTIONFACTOR	Update Well Production Factors	WELLPRODFACTORUPD	Update any/all Well Production Factors. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLWGR	Update Well Water Gas Ratio Factor	WELLPRODFACTORUPD	Update Well WGR Factor and/or Test Date. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.
WELLWGROGR	Update Well Water and Oil Gas Ratio Factors	WELLPRODFACTORUPD	Update Well WGR Factor, WGR Code, WGR Test Date, OGR Code, OGR Factor and OGR Test Date. User control group security access to WellFactorsEdit will apply. Impacted facilities must not be locked/closed for Step 1 and may be reset, if applicable, after changes are applied.

The format of sample templates can be generated from Import/Export > Template Based > Import Data by selecting a template and then clicking the Generate Sample button.

The template has a header row and an explanation/validation row. The second row provides the information/validation rules for populating the template. Reminder: This second row must always be deleted before importing.

See the Appendix section for additional information regarding templates.

When a template is used to update existing data, the exclamation mark can be used in columns that do not need to be updated.

See the Appendix section for examples on how to use the exclamation mark.

When new Qbyte Metrix IDs are being created through an import, they should not contain leading spaces, multiple consecutive spaces, or trailing spaces.

DOIFACILITYCHARGEEXCPTN - Create Facility Charge DOI Exceptions (as of Release 23.4)

This template can be used to create entity-level DOI Facility Charge Exceptions. Valid entities are Battery, Gathering System, Plant, Tract, Unit and Well. You must also have Full Access to the control group security component DOIEdit.

See the Template for DOIFACILITYCHARGEEXCPTN section for the import format and sample data.

DOIMASTER - Create Entity Division of Interests (as of Release 23.3)

This template can be used to create entity-level Division of Interests. Valid entities are Battery, Gathering System, Injection Facility, Plant, Tract, Unit and Well. You must also have Full Access to the corporate security component DOIImportByTemplate.

See the Template for DOIMASTER section for the import format and sample data.

DOIOWNEXCPTN - Create Ownership DOI Exceptions (as of Release 23.4)

This template can be used to create entity-level DOI Ownership Exceptions. Valid entities are Tract, Unit and Well. You must also have Full Access to the control group security component DOIEdit.

See the Template for DOIOWNEXCPTN section for the import format and sample data.

FACILITYCHARGEMONTHLYFACTORVALUE - Update Facility Charge Monthly Factor Values

This template can be used to update Facility Charge Monthly Factor Values. This template will not create Facility Charge Monthly Factors. You must also have Full Access to the corporate security component FCGlobalFactorEdit.

See the Template for FACILITYCHARGEMONTHLYFACTORVALUE section for the import format and sample data.

FACILITYCONSUSAGEENTITY - Create Entity Linkages on Facility Consumption Usage IDs - No Input Volumes

This template can be used to create Entity Linkages on Facility Consumption Usage IDs. Input Volumes for Entity Linkages cannot be imported. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.

See the Template for FACILITYCONSUSAGEENTITY section for the import format and sample data.

FACILITYCONSUSAGEENTITYDELETE - Delete Entity Linkages on Facility Consumption Usage IDs

This template can be used to delete Entity Linkages on Facility Consumption Usage IDs. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.

See the Template for FACILITYCONSUSAGEENTITYDELETE section for the import format and sample data.

FACILITYCONSUSAGEGENERAL - Create/Update Facility Consumption Usage IDs - No Input Volumes

This template can be used to update Facility Consumption Usage IDs. Input Volumes for Usage IDs cannot be imported. To load input volumes for Usage IDs, use Field Data Capture and the CONSUSG layout. User control group security access to BatteryBalanceEdit, GGSBalanceEdit or PlantBalanceEdit will apply, depending upon the Facility Type being imported. Impacted facilities must not be locked/closed for Step 1 and may be Reset, if applicable, after changes are applied.

See the Template for FACILITYCONSUSAGEGENERAL section for the import format and sample data.

FACILITYDEFAULTPRICE - Update Facility Default Prices and Transportation Rates

This template can be used to update Facility Default Prices, Deduction Rates and Transportation Rates. You must also have Full Access to the PricingEdit control group security component, as this component is used to determine if you can create or update prices for the Facility or Production Date(s).

See the Template for FACILITYDEFAULTPRICE section for the import format and sample data.
See How To: Spreadsheet Import Default Price and Transportation Rates for information on various methods for generating and importing data.

FACILITYOVERRIDEPRODN - Update Facility Production Overrides

This template can be used to update Facility Production Overrides. You must also have Full Access to the OverrideProductionEdit control group security component, as this component is used to determine if you can update production overrides for the Facility or Production Date(s).

See the Template for FACILITYOVERRIDEPRODN section for the import format and sample data.

FACILITYOVERRIDEOPNINV - Update Facility Opening Inventory Overrides

This template can be used to update Facility Inventory Overrides. To generate the data for the template, see How to: Spreadsheet Import Facility Override Inventory. You must also have Full Access to the OverrideOpeningInventoryEdit control group security component, as this component is used to determine if you can update production overrides for the Facility or Production Date(s).

See the Template for FACILITYOVERRIDEOPNINV section for the import format and sample data.
See How to: Spreadsheet Import Facility Override Inventory for information on various methods for generating and importing data.

INDIANROYALTYGCA - Update IOGC GCA by Royalty Entity ID

This template can be used to update the Gas Cost Allowance by Royalty Entity Type and ID. This template will not create Royalty Entity IDs. You must also have Full Access to the corporate security component PriceByRoyaltyIDEdit.

See the Template for INDIANROYALTYGCA section for the import format and sample data.

MMCONTRACTENERGY - Update Contract Override Energy (as of Release 23.2)

This template can be used to update Facility Purchaser Contract Override Energy data. Contracts must be for product GAS or RAWGAS. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. You must also have Full Access to MarketMasterEdit control group security component. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTENERGY section for the import format and sample data. Note: This data can also be exported from Qbyte Optix using the Facility Data Extract and the Commonly Used Attributes option of Purchaser Contract Override Energy.

MMCONTRACTENERGYYDESC - Update Contract Override Energy by Contract Description (as of Release 23.2)

This template can be used to update Facility Purchaser Contract Override Energy data using Contract Description to identify contract being updated. Contracts must be for product GAS or RAWGAS. When you are using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If this occurs an error will be generated, and the data will not be imported. You must also have Full Access to the MarketMasterEdit control group security component. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTENERGYBYDESC section for the import format and sample data.

MMCONTRACTPRICING - Update Contract Pricing

This template can be used to update Facility Purchaser Contract Pricing data. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. You must also have Full Access to PricingEdit control group security component. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTPRICING section for the import format and sample data.

MMCONTRACTPRICINGBYDESC - Update Contract Pricing by Contract Description

This template can be used to update Facility Purchaser Contract Pricing data using Contract Description to identify contract being updated. When you are using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If this occurs an error will be generated, and the data will not be imported. You must also have Full Access to the PricingEdit control group security component. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTPRICINGBYDESC section for the import format and sample data.

MMCONTRACTUNITPRICE - Update Contract Unit Prices

This template can be used to update Facility Purchaser Contract Unit Price. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. Purchaser Contract must be set up to use Price Per Unit. You must also have Full Access to PricingEdit control group security component. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTUNITPRICE section for the import format and sample data.
See How to: Spreadsheet Import Purchaser Contract Pricing for information on various method for generating and importing data.

MMCONTRACTUNITPRICEBYDESC - Update Contract Unit Prices by Contract Description

This template can be used to update Facility Purchaser Contract Unit Price using Contract Description to identify contract being updated. When you are using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. All matching records will be updated if applicable (use Price Per Unit, are not locked/closed for Step03, etc.). Only contracts set to use Price Per Unit will be updated. You must also have Full Access to PricingEdit control group security component. Impacted facilities must not be locked/closed for Step 3 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTUNITPRICEBYDESC section for the import format and sample data.
See How to: Spreadsheet Import Purchaser Contract Pricing for information on various method for importing data.

MMCONTRACTUSERINPUT - Update Contract User Input and Override Energy (as of Release 23.2)

This template can be used to update Facility Purchaser Contract User Input Volume and Override Energy data. Contracts must have the Allocation Method set to User Input and the Override Energy will only be imported when the product is GAS or RAWGAS. Requires full key for identifying Facility Purchaser Contract. There must be an exact match to one and only one record within Qbyte Metrix. You must also have Full Access to MarketMasterEdit control group security component. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTUSERINPUT section for the import format and sample data. Note: This data can also be exported from Qbyte Optix using the Facility Data Extract and the Commonly Used Attributes option of Purchaser Contract User Input.

MMCONTRACTUSERINPUTBYDESC - Update Contract User Input and Override Energy by Contract Description (as of Release 23.2)

This template can be used to update Facility Purchaser Contract User Input Volume and Override Energy data using Contract Description to identify contract being updated. Contracts must have the Allocation Method set to User Input and the Override Energy will only be imported when the product is GAS or RAWGAS. When you are using Contract Description there may be more than one matching Market Master Purchaser Contract record within Qbyte Metrix. If this occurs an error will be generated, and the data will not be imported. You must also have Full Access to the MarketMasterEdit control group security component. Impacted facilities must not be locked/closed for Step 2 and may be Reset, if applicable, after changes are applied.

See the Template for MMCONTRACTUSERINPUTBYDESC section for the import format and sample data.

OBLIGATIONFACTORVALUE - Update Royalty Obligation Factor Values

This template can be used to update Obligation Factor Values (Factor or Global Factor ID only). This template will not create any Obligation Factors. You must also have Full Access to the control group security component RoyaltiesEdit.

See the Template for OBLIGATIONFACTORVALUE section for the import format and sample data.

OILVALUATIONTRANS - Update Oil Valuation RTP Overrides

This template can be used to update Oil Valuation Overrides of Transportation and Quality Adjustment for RTP Submissions. This template will not create oil valuation override rows. You must also have Full Access to the corporate security component OilValuation.

See the Template for OILVALUATIONTRANS section for the import format and sample data.

OWNERGOVTCODEUPD - Update Owner Government Codes (as of Release 23.4)

This template can be used to update government codes for Owners. This template will not create Owner Masters, just update the government codes on existing Owners. You must have Full Access to the corporate security component OwnerEdit.

See the Template for OWNERGOVTCODEUPD section for the import format and sample data.

OWNERMASTER - Create/Update Owner Masters (as of Release 23.4)

This template can be used to create or update Owners. You must have Full Access to the corporate security component OwnerImportByTemplate.

See the Template for OWNERMASTER section for the import format and sample data.

OWNERNAMEADDRESSUPD - Update Owner Name and Addresses (as of Release 23.4)

This template can be used to update name, address lines, and postal code for Owners. This template will not create Owner Masters, just update the name, address lines and/or postal code on existing Owners. You must have Full Access to the corporate security component OwnerEdit.

See the Template for OWNERNAMEADDRESSUPD section for the import format and sample data.

PARTNEROPPRICING - Create/Update Partner Operated Pricing (as of Release 24.3)

This template can be used to create/update Partner Operated Pricing entries by Production Date, Battery, Transaction Type, Product, Plant, Purchaser/Royalty Owner ID, Purchaser Sequence, Destination Type, and Destination. You must also have Full Access to the Control Group security component PartnerOpBatteryBalanceEdit.

See the Template for PARTNEROPPRICING section for the import format and sample data. Note: This data can also be exported from Qbyte Optix using the Battery Data Extract and the Commonly Used Attributes option of Partner Operated Prices.

PARTNEROPSALES - Update Partner Operated Sales Transactions

This template can be used to update the Net/Gross Volume, Net/Gross Value, Net/Gross GJs, Net/Gross Transportation, Net/Gross Quality Adjustment, Net/Gross Tariff, Net/Gross Line Loss, Net/Gross Other#1, and Net/Gross Other#2 for Partner Operated Sales Transactions by Production Date, Battery, Well, Product, Purchaser ID, Purchaser Seq. #, Destination Type, and Destination ID. This template will not create Partner Operated Battery Sales transactions. To generate the data for the template, see How to: Import Partner Operated Sales Transactions. You must also have Full Access to the Control Group security component PartnerOpBatteryBalanceEdit.

See the Template for PARTNEROPSALES section for the import format and sample data.

ROYALTYGLOBALFACTOR - Create/Update Royalty Global Factor

This template can be used to create and/or update Royalty Global Factors. If the Royalty Global Factor from the Import file does not exist, the Royalty Global Factor will be created. If the Royalty Global Factor is found, all columns will be updated.

This template can be used when Royalty Global Factors need to be created for use within royalty formulas, or when the Royalty Global Factor value needs to be updated.

See the Template for ROYALTYGLOBALFACTOR section for the import format and sample data.

ROYALTYOBLIGATION - Create/Update Royalty Obligation Masters

This template can be used to create and/or update Royalty Obligation Masters. If the Royalty Obligation Master from the Import file does not exist, the Royalty Obligation Master will be created. If the Royalty Obligation Master is found, all columns will be updated.

You must have Full Access to the security component RoyaltiesEdit. After creating/updating royalty obligations, the facility/control group that the well/tract is attached to will not be reset.

If a Royalty Obligation is created/updated in a prior month, system-generated amendments will be created.

See the Template for ROYALTYOBLIGATION section for the import format and sample data.

ROYALTYOBLIGATIONDELETE - Delete Royalty Obligation Masters

This template can be used to delete Royalty Obligation Masters. You must have Full Access to the security component RoyaltiesEdit. After deleting royalty obligations, the facility/control group that the well/tract is attached to will not be reset.

If a Royalty Obligation is deleted in a prior month, system-generated amendments will be created.

See the Template for ROYALTYOBLIGATIONDELETE section for the import format and sample data.

ROYALTYOBLIGATIONFACTOR - Create/Update Royalty Obligation Factors

This template can be used to create and/or update Royalty Obligation Factor Masters. If the Royalty Obligation Factor Master from the Import file does not exist, the Royalty Obligation Factor Master will be created. If the Royalty Obligation Factor Master is found, the description will be updated. You must also have Full Access to the corporate security component RoyaltyUserDefinedFactorCreateDelete and/or RoyaltyUserDefinedFactorEdit.

See the Template for ROYALTYOBLIGATIONFACTOR section for the import format and sample data.

ROYALTYOBLIGATIONHDR - Create Pending Royalty Obligation Masters

This template can be used to create Royalty Obligation Masters with only a subset of the fields required to create a Royalty Obligation. To update existing Royalty Obligations, the ROYALTYOBLIGATION template must be used. All Royalty Obligation Masters created using this template will be created with an Active status of Pending.

This is most useful when you do not have all the information (i.e., Formula) required to create the obligation. You must also have Full Access to the security component RoyaltiesImportByTemplate, as this component allows you to create royalty obligation headers. After creating new Royalty Obligations, the facility/control group that the well is attached to will not be reset.

See the Template for ROYALTYOBLIGATIONHDR section for the import format and sample data.

WELLABOILCROWN - Update Alberta Well Oil Crown Factors (as of Release 24.4)

This template can be used to update various Oil crown fields (Oil Density, Crown Calculation Type, Equivalent Sub Use Type) for Alberta wells. You must have Full Access to the security component WellFactorsEdit, as this component allows you to update the Well Royalty Crown Factors for Alberta wells.

See the Template for WELLABOILCROWN for the import format and sample data.

WELLCONSBYLABEL - Update Well Consumption Rates by Label

This template can be used to Import Consumption Factor Rates for existing Consumption Factors (monthly, if necessary). This template will not create Consumption Factors; it will only update existing Consumption Factors. You must also have Full Access to the security component WellFactorsEdit, as this component allows you to update the Well Consumption Factors. After updating the Well Consumption Factors, the facility/control group that the well is attached to will be reset.

See the Template for WELLCONSBYLABEL for the import format and sample data.
Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating/importing Well Consumption Master data.

WELLCONSDELETEBYLABEL - Delete Well Consumption Factors by Label

This template can be used to delete Well Consumption Factors. You must have Full Access to the security component WellFactorsEdit. After deleting the Well Consumption Factors, the facility/control group that the well is attached to will be reset.

See the Template for WELLCONSDELETEBYLABEL for the import format and sample data.

WELLCONSUMPTION - Create/Update Well Consumption Factor

This template can be used to create and/or update Well Consumption Factors. If the Well Consumption Factor from the Import file does not exist, the Consumption Factor will be created. If the Well Consumption Factor is found, all columns will be updated.

This template can be used when Well Consumption Factors need to be added to wells, or when existing Well Consumption Factors need to be changed. You must also have Full Access to the security component WellFactorsEdit, as this component allows you to update the Well Consumption Factors. After updating the well, the facility/control group that the well is attached to will be reset.

See the Template for WELLCONSUMPTION section for the import format and sample data.
Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating/importing Well Consumption Master data.

WELLCONSUMPTIONUPD - Update Well Consumption Factors

This template can be used to update existing Well Consumption Factors. This template is like WELLCONSUMPTION; the difference is that this template cannot be used to add Well Consumption Factors. You must also have Full Access to the security component WellFactorsEdit, as this component allows you to update the Well Consumption Factors. After updating the well, the facility/control group that the well is attached to will be reset.

See the Template for WELLCONSUMPTIONUPD section for the import format and sample data.
Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating/importing Well Consumption Master data.

WELLMASTERCREATION - Create Well Masters

This template can be used to create Well Masters. This template is most useful when you need to create many wells. You must also have Full Access to the security component WellMaintenanceEdit, as this component allows you to create new wells.

See the Template for WELLMASTERCREATION section for the import format and sample data.

WELLMASTERGENERALUPD - Update Well Master General Data

This template can only be used to update Well Master Data. You must also have Full Access to the security component WellMaintenanceEdit, as this component allows you to update the well. After updating the well, the facility/control group that the well is attached to will be reset.

See the Template for WELLMASTERGENERALUPD section for the import format and sample data.

WELLMASTERGENERALUPDNORESET - Update Well Master General Data - No Reset

This template is like WELLMASTERGENERALUPD in the way of the columns available for update. However, this template will not check for Locked/Closed status, nor will it reset the facility/control group the well is attached to after the import. Instead of using the standard WellMaintenanceEdit security component, to use this template you must have Full Access to the security component ImportByTemplateNoReset.

See the Template for WELLMASTERGENERALUPDNORESET section for the import format and sample data.

WELLMASTERUWIUPDNORESET - Update Well Master UWI Data - No Reset

This template is like WELLMASTERGENERALUPDNORESET in the way that this template will not check for Locked/Closed status, nor will it reset the facility/control group the well is attached to after the import. Instead of using the standard WellMaintenanceEdit security component, to use this template you must have Full Access to the security component ImportByTemplateNoReset. This template can only be used to update the Location of the well.

See the Template for WELLMASTERUWIUPDNORESET section for the import format and sample data.

WELLPRODUCTIONFACTOR - Update Well Production Factors

This template can be used to update all the Well Production Factors such as Water Gas Ratio Factor, Water Gas Ratio Test Date, Oil Meter Factor, etc. If it is a Saskatchewan well, the HOR/EOR Rate can be updated as well. Note: This data can also be exported from Qbyte Optix using the Well Data Extract and the Commonly Used Attributes option of Production Factors.

See the Template for WELLPRODUCTIONFACTOR section for the import format and sample data.

WELLWGR - Update Well Water Gas Ratio Factor

This template can be used to update only the water gas ratio and the water gas ratio test date. No other data elements are updated.

See the Template for WELLWGR section for the import format and sample data.

WELLWGROGR - Update Well Water and Oil Gas Ratio Factors

This template can be used to update the Water and Oil Gas Ratio Factors, Codes and Test Dates. No other data elements are updated.

See the Template for WELLWGROGR section for the import format and sample data.

Import by Template

Menu Option

The menu option to import can be found within Import / Export > Template Based > Import Data By Template.

Note: This menu will not be displayed unless you have Full Access to the ImportByTemplate security component.

Import Screen

Field	Description

Field	Description
Name	Can be left blank, or any name can be entered. If left blank, the name will default to Filename with Current Production Month (e.g., WELLCONDBYLABEL_AKEIMPW01W01_200804.CSV).
Template ID*	Can be either entered or selected using the Advanced Search > Search.
Comment	This is not mandatory and can be left blank. This comment can be used to describe the import.
Filename*	Click the Add button to find and add the file to import.
File Includes Header	Indicates if the .CSV being used to import includes a header row or not.
Entity Key Mapping	The selected Mapped by Entity will be used to find matching records in the second column of the .CSV file. Valid Mapped By entities include: ID – Qbyte Metrix ID GOVT – Government Code UWI – For Wells, this is the location (formatted location without survey system). For Tracts, this is the Legal Presentation. UDF1 – User-defined 1 UDF2 – User-defined 2 REGTRY – Petrinex ID (i.e., AB BT 0000045) For example: If the spreadsheet uses UWIs as the Well IDs then the Mapped By should be UWI. The default is Well ID. Note: Not all templates will require fields with Key Mapping, and some may have multiple fields that can be mapped, each with their own Key Mapping values.

Generate Sample: Templates can be generated by clicking the Generate Sample button. When this button is clicked, the selected Template will open in .CSV format.

See the Spreadsheet Import Templates section for additional information regarding Templates.

Submit: This button will submit the Import. If an Import by the same name has been previously submitted, a message will display asking if the previous results can be overwritten.

How to Import

You must first decide which template to use. (See the Spreadsheet Import Templates section.) Once that is decided, a sample file with the correct template format can be generated by following the steps below:

1. Navigate to the Import Data by Template screen and enter the Template ID.

2. Click the Generate Sample button.

Note: This step is not required with each import because once you have a sample you can continue to use it. However, the templates may change over time, so you may need to update your sample files from time to time.

The Generate Sample button opens an Excel screen with the template information. All templates will have two rows populated. The first row is a header row with column headings, and the second row provides details indicating how to populate the column. Both rows can be deleted once the actual data is entered, as you can import a file with or without column headings.

However, if you are importing a file with headings, we are assuming only one row of headings, so the row containing details about each column should be deleted. Data can be created/updated in the following ways:

Using the rules and information on the second row, you can manually enter the data that needs to be uploaded.
Use an external system (i.e., FDC System) to generate the template using the rules provided by P2.

Note: When importing a file to update existing Qbyte Metrix data, you cannot leave columns blank that you do not want to change, as blank may be a valid option for a lot of Qbyte Metrix data columns. Instead, for columns that are required in the Import file, but that you do not want to be modified, you should enter an exclamation mark (!). This tells the import to leave the data in that column as it was. When you are creating new data within an import, the exclamation mark (!) is not valid as there is no pre-existing data to leave as is.

Once the data is entered, the .CSV file should be saved (i.e., MyImport.CSV).

See the Appendix section for examples of templates with sample data.

Now that your data is ready:

3. Navigate back into the Import by Template screen. A Name is optional.

Note: If the name is not provided, the process will create a name for you. If left blank, the name will default to Filename with Current Production Month (e.g., WELLCONDBYLABEL_AKEIMPW01W01_200804.CSV).

4. Select your Template ID and then select the Add button to select the file.

If the file you are importing contains a row for the column headers, leave the File Includes Header as Yes (default value).
If you removed all headers change this to No. If the Template ID you selected has fields that represent Qbyte Metrix entities, you may see rows in the Entity Key Mapping grid.
You can choose the Mapping option you used when you entered the data into the file to be imported.

Note: You must ensure that the method you used in the file is a valid option for the Template ID you selected.

5. Click the Submit button.

The Submit button will submit a job to import the data.

As shown below, the Process Monitor will provide the status of the job and all messages related to the Import process.
If there are errors, the Message Centre will display a message requesting you to look at the Import Process Status report within Qbyte Metrix Reporting. (See the Import Status report, Production > Interoperability > Metrix Imports, section below.) This report can also be accessed from within the Process Monitor for the Import by Template Process. Simply click the paper icon, and it will launch the corresponding Qbyte Optix report.
If no errors exist, the message will indicate that the job completed successfully.

Import Status Report

The Import Status report (Production > Interoperability > Qbyte Metrix Imports) displays the imported data elements and all errors and warnings that occurred during the Import.

Appendix

DOIFACILITYCHARGEEXCEPTION (as of Release 23.4)

Template for DOIFACILITYCHARGEEXCEPTION

Template ID	Column Header	Description

Template ID	Column Header	Description
DOIFACILITYCHARGEEXCPTN	Effective Date	Effective Date of DOI Facility Charge Exception. Format YYYYMM.
DOIFACILITYCHARGEEXCPTN	Entity Type	Entity type. Options include: B (Battery) G (Gathering System) P (Plant) T (Tract) U (Unit) W (Well)
DOIFACILITYCHARGEEXCPTN	Entity	Unique identifier for the Entity. Must exist in Effective Date
DOIFACILITYCHARGEEXCPTN	DOI Sub ID	Unique ID for the Sub within the Entity. Maximum size of 16 characters but it is recommended that you use 4 digits 0 filled (0001)
DOIFACILITYCHARGEEXCPTN	Product	Optional. Must be a valid Facility Charge Product or blank (N/A - Not Applicable)
DOIFACILITYCHARGEEXCPTN	DOI Extension Number	Extension ID. Maximum of 2 digits. Must be between 0 and 99.
DOIFACILITYCHARGEEXCPTN	Charge Entity Type	Charge Entity type. Options include: B (Battery) G (Gathering System) P (Plant) U (Unit)
DOIFACILITYCHARGEEXCPTN	Charge Entity	Unique Identifier for the Charge Entity. Must exist in Effective Date
DOIFACILITYCHARGEEXCPTN	Charge Type	Charge Type. Must be a valid Charge Type.
DOIFACILITYCHARGEEXCPTN	Revenue or Expense	Options are: R (Revenue) E (Expense)

Sample Data for DOIFACILITYCHARGEEXCPTN Template

^{Effective Date}	^{Entity Type}	^Entity	^{DOI Sub ID}	^Product	^{DOI Extension Number}	^{Charge Entity Type}	^{Charge Entity}	^{Charge Type}	^{Revenue or Expense}

^{Effective Date}	^{Entity Type}	^Entity	^{DOI Sub ID}	^Product	^{DOI Extension Number}	^{Charge Entity Type}	^{Charge Entity}	^{Charge Type}	^{Revenue or Expense}
200804	B	RLT10	0006		5	B	RLT10	06	R
200804	G	RLT28	0010	GAS	1	P	RLTP1	11	R

DOIMASTER (as of Release 23.3)

Template for DOIMASTER

Template ID	Column Header	Description

Template ID	Column Header	Description
DOIMASTER	Effective Date	Effective Date of Division of Interest. Format YYYYMM.
DOIMASTER	Entity Type	Entity type. Options include: B (Battery) G (Gathering System) I (Injection Facility) P (Plant) T (Tract) U (Unit) W (Well)
DOIMASTER	Entity	Unique identifier for the Entity. Must exist in Effective Date
DOIMASTER	DOI Sub ID	Unique ID for the Sub within the Entity. Maximum size of 16 characters but it is recommended that you use 4 digits 0 filled (0001)
DOIMASTER	DOI User Defined#1	Optional: Maximum size of 30 characters Note: The value for this column will only be read from the first record for the Sub. Any values in this column on subsequent records for the Sub will be ignored.
DOIMASTER	Integration Default	Options are: Y (Yes) N (No) Note: The value for this column will only be read from the first record for the Sub. Any values in this column on subsequent records for the Sub will be ignored.
DOIMASTER	Owner ID	Unique Identifier for an Owner. Must exist in Effective Date
DOIMASTER	Owner Interest Percent	Interest Percent Maximum size of 999.99999999 (3v8). Must be greater than or equal to 0 and less than or equal to 100
DOIMASTER	Silent Partner Parent ID	Unique Identifier for an Owner. Optional. Must exist in Effective Date Must exist as an Owner in the DOI Cannot be the same as the Owner ID Silent Partner Parent ID cannot be an Owner that itself has a Silent Partner Parent
DOIMASTER	Exclude Owner	Options are: Y (Yes) N (No)
DOIMASTER	DOI Sub Note	Optional: Maximum 4000 characters Note: The value for this column will only be read from the first record for the Sub. Any values in this column on subsequent records for the Sub will be ignored.

Sample Data for DOIMASTER Template

^{Effective Date}	^{Entity Type}	^Entity	^{DOI Sub ID}	^{DOI User Defined#1}	^{Integration Default}	^{Owner ID}	^{Owner Interest Percent}	^{Silent Partner Parent ID}	^{Exclude Owner}	^{DOI Sub Note}

^{Effective Date}	^{Entity Type}	^Entity	^{DOI Sub ID}	^{DOI User Defined#1}	^{Integration Default}	^{Owner ID}	^{Owner Interest Percent}	^{Silent Partner Parent ID}	^{Exclude Owner}	^{DOI Sub Note}
200804	B	RLT10	0006		N	999	100.00000000		N	Sub 0006 to be used for royalty obligations
200804	G	RLT28	0010	UDF1	N	999	50.00000000		N
200804	G	RLT28	0010			VEN700	25.00000000		N
200804	G	RLT28	0010			VEN7000	25.00000000	VEN700	N

DOIOWNEXCEPTION (as of Release 23.4)

Template for DOIOWNEXCEPTION

Template ID	Column Header	Description

Template ID	Column Header	Description
DOIOWNEXCPTN	Effective Date	Effective Date of DOI Facility Charge Exception. Format YYYYMM.
DOIOWNEXCPTN	Entity Type	Entity type. Options include: T (Tract) U (Unit) W (Well)
DOIOWNEXCPTN	Entity	Unique identifier for the Entity. Must exist in Effective Date
DOIOWNEXCPTN	DOI Sub ID	Unique ID for the Sub within the Entity. Maximum size of 16 characters but it is recommended that you use 4 digits 0 filled (0001)
DOIOWNEXCPTN	Exception Type	Exception Type. OWN - Ownership CRWN - Crown FRHD - Freehold ORR - Override FCLS - F-Class INDIAN - IOGC OTHER - Other CRAQ - Crown Acquired FHTX - Freehold Tax XMPT - Exempt Federal Units can only use CRWN, CRAQ, FHTX, XMPT exception types.
DOIOWNEXCPTN	Product	Must be a valid product. When Exception Type is CRAQ, product must be OIL or GAS. When the entity is a Saskatchewan Unit, product must be OIL or GAS. As of Release 24.4, the product BYP can be used when the Exception Type is CRWN, FRHD, ORR, FCLS, or OTHER.
DOIOWNEXCPTN	DOI Extension Number	Extension ID. Maximum of 2 digits. Must be between 0 and 99. When Exception Type is OWN, CRAQ, FHTX or XMPT, the Extension ID must be 1. When entity is a Saskatchewan Well or Tract and the Exception Type is CRWN, the Extension ID must be 1. When entity is a Unit not in Saskatchewan and the Exception Type is CRWN, the Extension ID must be 1.

Sample Data for DOIOWNEXCPTN Template

Effective Date	Entity Type	Entity	DOI Sub ID	Exception Type	Product	DOI Extension Number

Effective Date	Entity Type	Entity	DOI Sub ID	Exception Type	Product	DOI Extension Number
200804	W	RLT10W01	0006	OWN	OIL	1
200804	T	SKUN1T1	0005	ORR	GAS	5

FACILITYCHARGEMONTHLYFACTORVALUE

Template for FACILITYCHARGEMONTHLYFACTORVALUE

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYCHARGEMONTHLYFACTORVALUE	Production Date	Format YYYYMM.
FACILITYCHARGEMONTHLYFACTORVALUE	Control Group	Control Group ID Maximum 16 characters.
FACILITYCHARGEMONTHLYFACTORVALUE	Factor Level	Factor Level Options are: CHRG (Facility Charge) FACL (Facility) WELL (Facility Charge plus Well)
FACILITYCHARGEMONTHLYFACTORVALUE	Factor ID	Factor ID Maximum 16 characters.
FACILITYCHARGEMONTHLYFACTORVALUE	Charge Entity Type	Entity Type of Facility Charge. Options are: B (Battery) G (Gathering System) P (Plant) U (Unit)
FACILITYCHARGEMONTHLYFACTORVALUE	Charge Entity ID	Unique Identifier for Facility Charge Entity.
FACILITYCHARGEMONTHLYFACTORVALUE	Product	Optional Product of Facility Charge.
FACILITYCHARGEMONTHLYFACTORVALUE	Charge Type	Charge Type Maximum 16 characters.
FACILITYCHARGEMONTHLYFACTORVALUE	Facility Charge Sequence	Facility Charge Sequence Maximum 4 digits.
FACILITYCHARGEMONTHLYFACTORVALUE	Well/Tract Type	Well/Tract Type. Can be left blank for Default Source Well. Non-blank options: W (Well) T (Tract)
FACILITYCHARGEMONTHLYFACTORVALUE	Well/Tract	Unique Identifier for Well/Tract. Can be left blank.
FACILITYCHARGEMONTHLYFACTORVALUE	Factor Value	Maximum size of 9999999999.99999999 (10v8).

Sample Data for FACILITYCHARGEMONTHLYFACTORVALUE Template

^{Production Date}	^{Control Group}	^{Factor Level}	^{Factor ID}	^{Charge Entity Type}	^{Charge Entity ID}	^Product	^{Charge Type}	^{Facility Charge Sequence}	^{Well/Tract Type}	^Well/Tract	^{Factor Value}

^{Production Date}	^{Control Group}	^{Factor Level}	^{Factor ID}	^{Charge Entity Type}	^{Charge Entity ID}	^Product	^{Charge Type}	^{Facility Charge Sequence}	^{Well/Tract Type}	^Well/Tract	^{Factor Value}
201407	55501	FACL	BTYFAC	B	TGWBAT02			0			2.50
201407	AKEABFC	CHRG	82FACT	P	AKEABFCPL01	GAS	81	5			82.00
201407	AKEABFC2	WELL	GF-FCW	B	AKEABFCB04	OIL	97	5	W	AKEABFCB04W01	0.75
201407	AKEABFC2	WELL	GF-FCW	B	AKEABFCB04	OIL	97	5	W	AKEABFCB04W02	2.50

Facility Charge Monthly Factor Values After Importing - FACILITYCHARGEMONTHLYFACTORVALUE

FACILITYCONSUSAGEENTITY

Template for FACILITYCONSUSAGEENTITY

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYCONSUSAGEENTITY	Production Date	Format YYYYMM.
FACILITYCONSUSAGEENTITY	Facility Type	Facility type. Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYCONSUSAGEENTITY	Facility	Unique identifier for the Facility.
FACILITYCONSUSAGEENTITY	Usage ID	Unique ID for the Usage within the Facility.
FACILITYCONSUSAGEENTITY	Well/Tract Type	Options are: W (Well) T (Tract)
FACILITYCONSUSAGEENTITY	Well/Tract ID	Unique identifier for the Well/Tract.

Note: This cannot be used to update the Input Volume for an Entity Linkage.

Sample Data for FACILITYCONSUSAGEENTITY Template

Production Date	Facility Type	Facility ID	Usage ID	Well/Tract Type	Well/Tract ID

Production Date	Facility Type	Facility ID	Usage ID	Well/Tract Type	Well/Tract ID
200804	P	RLT GFCPNP1	TREATA	W	RLTGFCPNB1W01
200804	P	RLT GFCPNP1	TREATB	T	GFCPNUT1
200804	G	RLTGFCPNG1	FUEL1	W	RLTGFCPNB2W01

FACILITYCONSUSAGEENTITYDELETE

Template for FACILITYCONSUSAGEENTITYDELETE

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYCONSUSAGEENTITYDELETE	Production Date	Format YYYYMM.
FACILITYCONSUSAGEENTITYDELETE	Facility Type	Facility type. Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYCONSUSAGEENTITYDELETE	Facility	Unique identifier for the Facility.
FACILITYCONSUSAGEENTITYDELETE	Usage ID	Unique ID for the Usage within the Facility.
FACILITYCONSUSAGEENTITYDELETE	Well/Tract Type	Options are: W (Well) T (Tract)
FACILITYCONSUSAGEENTITYDELETE	Well/Tract ID	Unique identifier for the Well/Tract.

Sample Data for FACILITYCONSUSAGEENTITYDELETE Template

Production Date	Facility Type	Facility ID	Usage ID	Well/Tract Type	Well/Tract ID

Production Date	Facility Type	Facility ID	Usage ID	Well/Tract Type	Well/Tract ID
200804	P	RLT GFCPNP1	TREATA	W	RLTGFCPNB1W01
200804	P	RLT GFCPNP1	TREATB	T	GFCPNUT1
200804	G	RLTGFCPNG1	FUEL1	W	RLTGFCPNB2W01

FACILITYCONSUSAGEGENERAL

Template for FACILITYCONSUSAGEGENERAL

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYCONSUSAGEGENERAL	Production Date	Format YYYYMM.
FACILITYCONSUSAGEGENERAL	Facility Type	Facility type. Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYCONSUSAGEGENERAL	Facility	Unique identifier for the Facility.
FACILITYCONSUSAGEGENERAL	Usage ID	Unique ID for the Usage within the Facility.
FACILITYCONSUSAGEGENERAL	Label	Unique Label for the Usage within the Facility.
FACILITYCONSUSAGEGENERAL	Usage Type	Options are: ACID (Acid Gas) FLAR (Flare) FUEL (Lease Fuel) VENT (Vent) MD (Metering Difference)
FACILITYCONSUSAGEGENERAL	Proration Basis	Can be left blank (Gathered Volume Only). Non-blank options are: N2 (Nitrogen) CO2 (Carbon Dioxide) H2S (Hydrogen Sulphide) C1 (Methane) C2 (Ethane) C3 (Propane) IC4 or NC4 (Butane) IC5 or NC5 (Pentane) C6 (Hexane) C7 (Heptane Plus)
FACILITYCONSUSAGEGENERAL	Petrinex Province Code	Optional.
FACILITYCONSUSAGEGENERAL	Petrinex Facility Type	Optional.
FACILITYCONSUSAGEGENERAL	Petrinex Government Code	Optional.
FACILITYCONSUSAGEGENERAL	Petrinex Activity Code	Optional. This is only valid for Plants and Usage Type = ACID and must be blank or FLARE.
FACILITYCONSUSAGEGENERAL	Distribution Percent	Maximum size of 999.99999999 (3v8). Must be greater than or equal to 0 and less than or equal to 100.
FACILITYCONSUSAGEGENERAL	Adjust Theoretical	Options are: Y (Yes) N (No)

Note: This cannot be used to update the Input Volume for a Usage ID. To load input volumes for Usage IDs, use Field Data Capture and the CONSUSG layout.

Sample Data for FACILITYCONSUSAGEGENERAL Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^{Usage ID}	^Label	^{Usage Type}	^{Proration Basis}	^{Petrinex Province}	^{Petrinex Type}	^{Petrinex Gov't Code}	^{Petrinex Activity}	^{Distribution Percent}	^{Adjust Theoretical}

^{Production Date}	^{Facility Type}	^{Facility ID}	^{Usage ID}	^Label	^{Usage Type}	^{Petrinex Province}	^{Petrinex Type}	^{Petrinex Gov't Code}	^{Adjust Theoretical}
200804	P	RLT GFCPNP1	TREATA	treater a	FUEL				Y
200804	P	RLT GFCPNP1	TREATB	treater b	FUEL				Y
200804	G	RLTGFCPNG1	FUEL1	compres1	FUEL	AB	CS	0000034	N

FACILITYDEFAULTPRICE

Template for FACILITYDEFAULTPRICE

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYDEFAULTPRICE	Production Date	Format YYYYMM.
FACILITYDEFAULTPRICE	Facility Type	Facility type. Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYDEFAULTPRICE	Facility	Unique identifier for the facility.
FACILITYDEFAULTPRICE	Product	Must be a valid producing product for the facility.
FACILITYDEFAULTPRICE	Price	Maximum size of 9999.99999999 (4v8).
FACILITYDEFAULTPRICE	Transportation Rate	Maximum size of 99999999.99999 (8v5).
FACILITYDEFAULTPRICE	Quality Adj. Rate	Maximum size of 99999999.99999 (8v5).
FACILITYDEFAULTPRICE	Tariff Rate	Maximum size of 99999999.99999 (8v5).
FACILITYDEFAULTPRICE	Line Loss Rate	Maximum size of 99999999.99999 (8v5).
FACILITYDEFAULTPRICE	Other#1 Rate	Maximum size of 99999999.99999 (8v5).
FACILITYDEFAULTPRICE	Other#2 Rate	Maximum size of 99999999.99999 (8v5).

Note: This is an update only template; the Price, Transportation Rate, Quality Adj. Rate, Tariff Rate, Line Loss Rate, Other#1 Rate, and the Other#2 Rate are the only columns that can be updated.

Sample Data for FACILITYDEFAULTPRICE Template

Production Date	Facility Type	Facility	Product	Price	Transportation Rate

Production Date	Facility Type	Facility	Product	Price	Transportation Rate
201406	B	AKEUHOLB04	OIL	360.63	2.50
201406	B	AKEUHOLB03	OIL	355.9	2.50
201406	P	AKEUHOLP02	GAS	2.90123	0
201406	B	AKEABGFB04	RAWGAS	2	0
201406	B	AKEABGFB04	OIL	289.54	2.50
201406	G	AKEABGFGGS3	COND	349.12	1.85
201406	P	AKEABGFPLT1	GAS	2.12	0
201406	P	AKEABGFPLT1	C2	-10.706897	0
201406	P	AKEABGFPLT1	C4SP	401.85	.85
201406	P	AKEABGFPLT1	C4MX	445.35	.85

FACILITYOVERRIDEPRODN

Template for FACILITYOVERRIDEPRODN

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYOVERRIDEPRODN	Production Date	Format YYYYMM.
FACILITYOVERRIDEPRODN	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYOVERRIDEPRODN	Facility	Facility Unique identifier for Facility.
FACILITYOVERRIDEPRODN	Product	Product Must be a valid producing product for Facility.
FACILITYOVERRIDEPRODN	Well/Tract Type	Well/Tract Type W (Well) T (Tract) Can be left blank for Default Source Well.
FACILITYOVERRIDEPRODN	Well/Tract	Well/Tract Unique identifier for Well, Tract, or Default Source Well (Outside Receipt).
FACILITYOVERRIDEPRODN	Owner ID	Owner ID Unique identifier for Owner.
FACILITYOVERRIDEPRODN	Producing Battery	Producing Battery Unique identifier for Producing Battery.
FACILITYOVERRIDEPRODN	Sending Battery	Sending Battery Unique identifier for Sending Battery.
FACILITYOVERRIDEPRODN	Flow Group ID	Flow Group ID Optional. Only valid for Gas Flow facilities where the product is not a Balance Only product. Unique Identifier for Flow Group Available as of Release 24.4.
FACILITYOVERRIDEPRODN	Production Volume	Production Volume Maximum size of 999999999.9 (9v1). Must be greater than or equal to 0.

Note: This is an update only template. The facility production overrides must have already been created in Qbyte Metrix prior to importing any updates.

Sample Data for FACILITYOVERRIDEPRODN Template

^{Production Date}	^{Facility Type}	^Facility	^Product	^{Well/Tract Type}	^Well/Tract	^{Owner ID}	^{Producing Battery}	^{Sending Battery}	Flow Group ID	^{Production Volume}

^{Production Date}	^{Facility Type}	^Facility	^Product	^{Well/Tract Type}	^Well/Tract	^{Owner ID}	^{Producing Battery}	^{Sending Battery}	Flow Group ID	^{Production Volume}
200804	P	RLT GFCPNP1	C3	W	RLTGFCPNB1W01	1	RLTGFCPNB1	RLTGFCPNB1	RLTWHOLE	0.4
200804	P	RLT GFCPNP1	C3	W	RLTGFCPNB1W01	VEN67756	RLTGFCPNB1	RLTGFCPNB1	RLTWHOLE	10.6
200804	P	RLTCPNP1	C3	T	CPNUT2	VEN67756				65.4
200804	P	RLTCPNP1	C3	W	RLTCPNB1W01	999	RLTCPNB1	RLTCPNB1		2.0

FACILITYOVERRIDEOPNINV

Template for FACILITYOVERRIDEOPNINV

Template ID	Column Header	Description

Template ID	Column Header	Description
FACILITYOVERRIDEOPNINV	Production Date	Format YYYYMM.
FACILITYOVERRIDEOPNINV	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
FACILITYOVERRIDEOPNINV	Facility	Facility Unique identifier for Facility.
FACILITYOVERRIDEOPNINV	Product	Product Must be a valid producing product for Facility.
FACILITYOVERRIDEOPNINV	Well/Tract Type	Well/Tract Type W (Well) T (Tract) Can be left blank for Default Source Well.
FACILITYOVERRIDEOPNINV	Well/Tract	Well/Tract Unique identifier for Well, Tract, or Default Source Well (Outside Receipt).
FACILITYOVERRIDEOPNINV	Owner ID	Owner ID Unique identifier for Owner.
FACILITYOVERRIDEOPNINV	Participant Type	Participant Type CRWN (Crown Royalty) EXVA (Exchange Owner - Financial) EXVO (Exchange Owner - Volumetric) RLO (Recovered Injection) ROY (Production Royalty) WIO (Working Interest Owner) XCRWN (Crown Royalty Transfer) XRLO (Recovered Injection Transfer) XROY (Production Royalty Transfer) XWIO (Working Interest Transfer)
FACILITYOVERRIDEOPNINV	Producing Battery	Producing Battery Unique identifier for Producing Battery.
FACILITYOVERRIDEOPNINV	Sending Battery	Sending Battery Unique identifier for Sending Battery.
FACILITYOVERRIDEOPNINV	Flow Group ID	Flow Group ID Optional. Only valid for Gas Flow facilities where the product is not a Balance Only product. Must be blank when the product is OIL, even for Gas Flow batteries. Unique Identifier for Flow Group Available as of Release 24.4.
FACILITYOVERRIDEOPNINV	Reference Owner	Reference Owner Optional. Should be populated when Participant Type is CRWN, ROY, XCRWN or XROY. Unique Identifier for Reference Owner.
FACILITYOVERRIDEOPNINV	Obligation Product	Obligation Product Optional. Should be populated when Participant Type is ROY or XROY. Must be a valid royalty obligation product, if populated.
FACILITYOVERRIDEOPNINV	Obligation Number	Obligation Number Optional. Should be populated when Participant Type is ROY or XROY. A four-character field that must contain only digits typically containing leading zeros (i.e., 0001).
FACILITYOVERRIDEOPNINV	Inventory Volume	Inventory Volume Maximum size of 999999999.9 (9v1).

Note: This is an update only template. The facility opening inventory overrides must have already been created in Qbyte Metrix prior to importing any updates.

Sample Data for FACILITYOVERRIDEOPNINV Template

^{Production Date}	^{Facility Type}	^Facility	^Product	^{Well/Tract Type}	^Well/Tract	^{Owner ID}	^{Participant Type}	^{Producing Battery}	^{Sending Battery}	Flow Group ID	^{Reference Owner}	^{Obligation Product}	^{Obligation Number}	^{Inventory Volume}

^{Production Date}	^{Facility Type}	^Facility	^Product	^{Well/Tract Type}	^Well/Tract	^{Owner ID}	^{Participant Type}	^{Producing Battery}	^{Sending Battery}	^{Reference Owner}	^{Obligation Product}	^{Obligation Number}	^{Inventory Volume}
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	10114	CRWN	RLTCPNB1	RLTCPNB1	VEN7000			0.4
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	10114	CRWN	RLTCPNB1	RLTCPNB1	999			0.6
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	VEN7000	WIO	RLTCPNB1	RLTCPNB1				20.5
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	999	WIO	RLTCPNB1	RLTCPNB1				36.8
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	11	ROY	RLTCPNB1	RLTCPNB1	VEN7000	OIL	0001	1.2
200804	B	RLTCPNB1	OIL	W	RLTCPNB1W01	11	ROY	RLTCPNB1	RLTCPNB1	999	OIL	0001	2.8

INDIANROYALTYGCA

Template for INDIANROYALTYGCA

Template ID	Column Header	Description

Template ID	Column Header	Description
INDIANROYALTYGCA	Production Date	Format YYYYMM.
INDIANROYALTYGCA	Royalty Entity Type	Royalty Entity Type Options include: R (Royalty Entity)
INDIANROYALTYGCA	Royalty Entity ID	Royalty Entity ID Maximum 16 characters.
INDIANROYALTYGCA	Gas Cost Allowance	Gas Cost Allowance This must be greater than or equal to 0 and a maximum size of 999.9999 (3v4).

Note: This is an update only template; the Gas Cost Allowance is the only column that can be updated.

Sample Data for INDIANROYALTYGCA Template

Production Date	Royalty Entity Type	Royalty Entity ID	Gas Cost Allowance

Production Date	Royalty Entity Type	Royalty Entity ID	Gas Cost Allowance
201407	R	ROY-ID-123	15.012
201407	R	ROY-ID-124	133.0
201407	R	ROY-ID-126	101.1234
201407	R	ROY-ID-129	10.5

MMCONTRACTENERGY (as of Release 23.2)

Template for MMCONTRACTENERGY

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTENERGY	Production Date	Production Date Format YYYYMM.
MMCONTRACTENERGY	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTENERGY	Facility	Facility Unique identifier for Facility.
MMCONTRACTENERGY	Product	Product Must be GAS or RAWGAS. Must be a valid producing product for Facility.
MMCONTRACTENERGY	Disposition Type	Disposition Type Options include: DELV (Delivery) XFER (Transfer) INJ (Injection) XI (Inventory Transfer) LF (Return Consumption) LF99 (Purchased Consumption) XFRM (Transfer for Market) XCONS (Transfer for Consumption) XFUEL (Transfer for Fuel) FS (Fuel Sale) XP (Plant to Plant) EX1 (Owner to Owner Transfer) EX2 (Owner to Owner Sale)
MMCONTRACTENERGY	Destination Type	Destination Type Optional. Not all Disposition Types require a Destination (i.e., Fire, Theft). Options include: B (Battery) D (Delivery System) G (Gathering System) I (Injection Facility) P (Plant)
MMCONTRACTENERGY	Destination ID	Destination ID Unique identifier for Destination Facility or Delivery System. Optional. Must be populated when Destination Type is populated.
MMCONTRACTENERGY	Disposition Sequence	Disposition Sequence Maximum size of 9999.
MMCONTRACTENERGY	Allocation Number	Allocation Number Maximum size of 99.
MMCONTRACTENERGY	Purchaser Type	Purchaser Type Options include: PURCH (Purchaser) XFER (Facility Transfer) LOSS (Loss - Fire Theft Spill or Shrinkage) DILGS (Dilution Gas) RETFL (Netted Return Fuel)
MMCONTRACTENERGY	Purchaser ID	Purchaser ID Unique Identifier for Purchaser. Optional. Must be populated when Purchaser Type = PURCH.
MMCONTRACTENERGY	Purchaser Sequence	Purchaser Sequence Maximum size of 99.
MMCONTRACTENERGY	Override Energy	Override Energy (GJs) Maximum size of 999999999999 (12v0). Cannot be negative.

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates.

Sample Data for MMCONTRACTENERGY Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Override Energy (GJs)}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Override Energy (GJs)}
200804	P	RLTCPNP1	GAS	DELV	D	ALLIAD	0	2	PURCH	VEN1002	0	15245

MMCONTRACTENERGYBYDESC (as of Release 23.2)

Template for MMCONTRACTENERGYBYDESC

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTENERGYBYDESC	Production Date	Production Date Format YYYYMM.
MMCONTRACTENERGYBYDESC	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTENERGYBYDESC	Facility	Facility Unique identifier for Facility.
MMCONTRACTENERGYBYDESC	Product	Product Must be GAS or RAWGAS. Must be a valid producing product for Facility.
MMCONTRACTENERGYBYDESC	Contract Description	Contract Description Maximum size of 60 characters.
MMCONTRACTENERGYBYDESC	Override Energy	Override Energy (GJs) Maximum size of 999999999999 (12v0). Cannot be negative.

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates. There may be more than one market master facility purchaser contract with the same Contract Description; an error will be generated when more than one valid matching contract found.

Sample Data for MMCONTRACTENERGYBYDESC Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Contract Description}	^{Override Energy (GJs)}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Contract Description}	^{Override Energy (GJs)}
200804	P	RLTCPNP1	GAS	RLT23	16248

MMCONTRACTPRICING

Template for MMCONTRACTPRICING

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTPRICING	Production Date	Production Date Format YYYYMM.
MMCONTRACTPRICING	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTPRICING	Facility	Facility Unique identifier for Facility.
MMCONTRACTPRICING	Product	Product Must be a valid producing product for Facility.
MMCONTRACTPRICING	Disposition Type	Disposition Type Options include: DELV (Delivery) XFER (Transfer) INJ (Injection) XI (Inventory Transfer) LF (Return Consumption) LF99 (Purchased Consumption) XFRM (Transfer for Market) XCONS (Transfer for Consumption) XFUEL (Transfer for Fuel) FIRE (Fire) SPILL (Spill) THEFT (Theft) BLEND (Blending Shrinkage) FS (Fuel Sale) XP (Plant to Plant) EX1 (Owner to Owner Transfer) EX2 (Owner to Owner Sale)
MMCONTRACTPRICING	Destination Type	Destination Type Optional. Not all Disposition Types require a Destination (i.e., Fire, Theft). Options include: B (Battery) D (Delivery System) G (Gathering System) I (Injection Facility) P (Plant)
MMCONTRACTPRICING	Destination ID	Destination ID Unique identifier for Destination Facility or Delivery System. Optional. Must be populated when Destination Type is populated.
MMCONTRACTPRICING	Disposition Sequence	Disposition Sequence Maximum size of 9999.
MMCONTRACTPRICING	Allocation Number	Allocation Number Maximum size of 99.
MMCONTRACTPRICING	Purchaser Type	Purchaser Type Options include: PURCH (Purchaser) XFER (Facility Transfer) LOSS (Loss - Fire Theft Spill or Shrinkage) DILGS (Dilution Gas) RETFL (Netted Return Fuel)
MMCONTRACTPRICING	Purchaser ID	Purchaser ID Unique Identifier for Purchaser. Optional. Must be populated when Purchaser Type = PURCH.
MMCONTRACTPRICING	Purchaser Sequence	Purchaser Sequence Maximum size of 99.
MMCONTRACTPRICING	Price Code	Price Code Options include: DFLT (Default Price) UNIT (Price Per Unit) CONTRT (Total Contract Value) ZERO (Zero Price)
MMCONTRACTPRICING	Input Price	Input Price Optional. Only applicable when Price Code = UNIT. Maximum size of 9999.99999999 (4v8).
MMCONTRACTPRICING	Value	Contract Value Optional. Only applicable when Price Code = CONTRT. Maximum size of 999999999.99 (9v2)
MMCONTRACTPRICING	Transportation Type	Transportation Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Transportation Rate/Value	Transportation Rate/Value Optional. Only applicable when Transportation Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5).
MMCONTRACTPRICING	Quality Adj. Type	Quality Adjustment Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Quality Adj. Cost	Quality Adjustment Rate/Value Optional. Only applicable when Quality Adj. Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICING	Tariff Fee Type	Tariff Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Tariff Cost	Tariff Fee Rate/Value Optional. Only applicable when Tariff Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICING	Line Loss Type	Line Loss Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Line Loss	Line Loss Rate/value Optional. Only applicable when Line Loss Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICING	Other#1 Fee Type	Other#1 Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Other#1 Cost	Other#1 Fee Rate/Value Optional. Only applicable when Other#1 Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICING	Other#2 Fee Type	Other#2 Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICING	Other#2 Cost	Other#2 Fee Rate/Value Optional. Only applicable when Other#2 Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates.

Sample Data for MMCONTRACTPRICING Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Price Code}	^{Input Price}	^Value	^{Transportation Type}	^{Transportation Type/Value}	^{Quality Adj. Type}	^{Quality Adj. Cost}	^{Tariff Fee Type}	^{Tariff Cost}	^{Line Loss Type}	^{Line Loss}	^{Other#1 Fee Type}	^{Other#1 Cost}	^{Other#2 Fee Type}	^{Other#2 Cost}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Price Code}	^{Input Price}	^Value	^{Transportation Type}	^{Transportation Type/Value}	^{Quality Adj. Type}	^{Quality Adj. Cost}	^{Tariff Fee Type}	^{Tariff Cost}	^{Line Loss Type}	^{Line Loss}	^{Other#1 Fee Type}	^{Other#1 Cost}	^{Other#2 Fee Type}	^{Other#2 Cost}
200804	B	RLTT9	OIL	DELV	D	7341O	0	2	PURCH	VEN1002	0	UNIT	251.15		RATE	1.25	RATE	.45	NA	0	DFLT	0	NA	0	VALUE	12.45
200804	B	RLTT9	OIL	DELV	D	7341O	0	3	PURCH	115874	0	VALUE	0	15482.25	VALUE	852.25	RATE	.48	NA	0	RATE	.14	NA	0	NA	0

MMCONTRACTPRICINGBYDESC

Template for MMCONTRACTPRICINGBYDESC

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTPRICINGBYDESC	Production Date	Production Date Format YYYYMM.
MMCONTRACTPRICINGBYDESC	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTPRICINGBYDESC	Facility	Facility Unique identifier for Facility.
MMCONTRACTPRICINGBYDESC	Product	Product Must be a valid producing product for Facility.
MMCONTRACTPRICINGBYDESC	Contract Description	Contract Description Maximum size of 60 characters.
MMCONTRACTPRICINGBYDESC	Price Code	Price Code Options include: DFLT (Default Price) UNIT (Price Per Unit) CONTRT (Total Contract Value) ZERO (Zero Price)
MMCONTRACTPRICINGBYDESC	Input Price	Input Price Maximum size of 9999.99999999 (4v8).
MMCONTRACTPRICINGBYDESC	Value	Contract Value Optional. Only applicable when Price Code = CONTRT. Maximum size of 999999999.99 (9v2).
MMCONTRACTPRICINGBYDESC	Transportation Type	Transportation Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Transportation Rate/Value	Transportation Rate/Value Optional. Only applicable when Transportation Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5).
MMCONTRACTPRICINGBYDESC	Quality Adj. Type	Quality Adjustment Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Quality Adj. Cost	Quality Adjustment Rate/Value Optional. Only applicable when Quality Adj. Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICINGBYDESC	Tariff Fee Type	Tariff Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Tariff Cost	Tariff Fee Rate/Value Optional. Only applicable when Tariff Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICINGBYDESC	Line Loss Type	Line Loss Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Line Loss	Line Loss Rate/value Optional. Only applicable when Line Loss Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICINGBYDESC	Other#1 Fee Type	Other#1 Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Other#1 Cost	Other#1 Fee Rate/Value Optional. Only applicable when Other#1 Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).
MMCONTRACTPRICINGBYDESC	Other#2 Fee Type	Other#2 Fee Type Options include: NA (Not Applicable) RATE (Rate) VALUE (Total Amount) DFLT (Default Rate)
MMCONTRACTPRICINGBYDESC	Other#2 Cost	Other#2 Fee Rate/Value Optional. Only applicable when Other#2 Fee Type is RATE or VALUE. Maximum size of 99999999.99999 (8v5). When Quality Adj. Type = VALUE, maximum size is 99999999.99 (8v2).

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates. There may be more than one market master facility purchaser contract with the same Contract Description; an error will be generated when more than one valid matching contract found.

Sample Data for MMCONTRACTPRICINGBYDESC Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Contract Description}	^{Price Code}	^{Input Price}	^Value	^{Transportation Type}	^{Transportation Rate/Value}	^{Quality Adj. Type}	^{Quality Adj. Cost}	^{Tariff Fee Type}	^{Tariff Cost}	^{Line Loss Type}	^{Line Loss}	^{Other#1 Fee Type}	^{Other#1 Cost}	^{Other#2 Fee Type}	^{Other#2 Cost}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Contract Description}	^{Price Code}	^{Input Price}	^Value	^{Transportation Type}	^{Transportation Rate/Value}	^{Quality Adj. Type}	^{Quality Adj. Cost}	^{Tariff Fee Type}	^{Tariff Cost}	^{Line Loss Type}	^{Line Loss}	^{Other#1 Fee Type}	^{Other#1 Cost}	^{Other#2 Fee Type}	^{Other#2 Cost}
200804	B	RLTT9	OIL	RLT1	UNIT	251.15	0	DFLT	0	RATE	.56	NA	0	NA	0	VALUE	23.48	NA	0
200804	P	RLTCPNP1	GAS	RLT23	CONTRT	0	12000.25	NA	0	NA	0	RATE	.45	VALUE	250.10	NA	0	RATE	1.23

MMCONTRACTUNITPRICE

Template for MMCONTRACTUNITPRICE

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTUNITPRICE	Production Date	Production Date Format YYYYMM.
MMCONTRACTUNITPRICE	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTUNITPRICE	Facility	Facility Unique identifier for Facility.
MMCONTRACTUNITPRICE	Product	Product Must be a valid producing product for Facility.
MMCONTRACTUNITPRICE	Disposition Type	Disposition Type Options include: DELV (Delivery) XFER (Transfer) INJ (Injection) XI (Inventory Transfer) LF (Return Consumption) LF99 (Purchased Consumption) XFRM (Transfer for Market) XCONS (Transfer for Consumption) XFUEL (Transfer for Fuel) FIRE (Fire) SPILL (Spill) THEFT (Theft) BLEND (Blending Shrinkage) FS (Fuel Sale) XP (Plant to Plant) EX1 (Owner to Owner Transfer) EX2 (Owner to Owner Sale)
MMCONTRACTUNITPRICE	Destination Type	Destination Type Optional. Not all Disposition Types require a Destination (i.e., Fire, Theft). Options include: B (Battery) D (Delivery System) G (Gathering System) I (Injection Facility) P (Plant)
MMCONTRACTUNITPRICE	Destination ID	Destination ID Unique identifier for Destination Facility or Delivery System. Optional. Must be populated when Destination Type is populated.
MMCONTRACTUNITPRICE	Disposition Sequence	Disposition Sequence Maximum size of 9999.
MMCONTRACTUNITPRICE	Allocation Number	Allocation Number Maximum size of 99.
MMCONTRACTUNITPRICE	Purchaser Type	Purchaser Type Options include: PURCH (Purchaser) XFER (Facility Transfer) LOSS (Loss - Fire Theft Spill or Shrinkage) DILGS (Dilution Gas) RETFL (Netted Return Fuel)
MMCONTRACTUNITPRICE	Purchaser ID	Purchaser ID Unique Identifier for Purchaser. Optional. Must be populated when Purchaser Type = PURCH.
MMCONTRACTUNITPRICE	Purchaser Sequence	Purchaser Sequence Maximum size of 99.
MMCONTRACTUNITPRICE	Input Price	Input Price Maximum size of 9999.99999999 (4v8).

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates.

Sample Data for MMCONTRACTUNITPRICE Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Input Price}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{Input Price}
200804	B	RLTT9	OIL	DELV	D	7341O	0	2	PURCH	VEN1002	0	251.15
200804	B	RLTT9	OIL	DELV	D	7341O	0	3	PURCH	115874	0	245.88

MMCONTRACTUNITPRICEBYDESC

Template for MMCONTRACTUNITPRICEBYDESC

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTUNITPRICEBYDESC	Production Date	Production Date Format YYYYMM.
MMCONTRACTUNITPRICEBYDESC	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTUNITPRICEBYDESC	Facility	Facility Unique identifier for Facility.
MMCONTRACTUNITPRICEBYDESC	Product	Product Must be a valid producing product for Facility.
MMCONTRACTUNITPRICEBYDESC	Contract Description	Contract Description Maximum size of 60 characters.
MMCONTRACTUNITPRICEBYDESC	Input Price	Input Price Maximum size of 9999.99999999 (4v8).

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates. There may be more than one market master facility purchaser contract with the same Contract Description; all valid matching contracts will be updated.

Sample Data for MMCONTRACTUNITPRICEBYDESC Template

Production Date	Facility Type	Facility ID	Product	Contract Description	Input Price

Production Date	Facility Type	Facility ID	Product	Contract Description	Input Price
200804	B	RLTT9	OIL	RLT1	251.15
200804	P	RLTCPNP1	GAS	RLT23	5.48

MMCONTRACTUSERINPUT (as of Release 23.2)

Template for MMCONTRACTINPUT

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTUSERINPUT	Production Date	Production Date Format YYYYMM.
MMCONTRACTUSERINPUT	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTUSERINPUT	Facility	Facility Unique identifier for Facility.
MMCONTRACTUSERINPUT	Product	Product Must be a valid producing product for Facility.
MMCONTRACTUSERINPUT	Disposition Type	Disposition Type Options include: DELV (Delivery) XFER (Transfer) INJ (Injection) XI (Inventory Transfer) LF (Return Consumption) LF99 (Purchased Consumption) XFRM (Transfer for Market) XCONS (Transfer for Consumption) XFUEL (Transfer for Fuel) FIRE (Fire) SPILL (Spill) THEFT (Theft) BLEND (Blending Shrinkage) FS (Fuel Sale) XP (Plant to Plant) EX1 (Owner to Owner Transfer) EX2 (Owner to Owner Sale)
MMCONTRACTUSERINPUT	Destination Type	Destination Type Optional. Not all Disposition Types require a Destination (i.e., Fire, Theft). Options include: B (Battery) D (Delivery System) G (Gathering System) I (Injection Facility) P (Plant)
MMCONTRACTUSERINPUT	Destination ID	Destination ID Unique identifier for Destination Facility or Delivery System. Optional. Must be populated when Destination Type is populated.
MMCONTRACTUSERINPUT	Disposition Sequence	Disposition Sequence Maximum size of 9999.
MMCONTRACTUSERINPUT	Allocation Number	Allocation Number Maximum size of 99.
MMCONTRACTUSERINPUT	Purchaser Type	Purchaser Type Options include: PURCH (Purchaser) XFER (Facility Transfer) LOSS (Loss - Fire Theft Spill or Shrinkage) DILGS (Dilution Gas) RETFL (Netted Return Fuel)
MMCONTRACTUSERINPUT	Purchaser ID	Purchaser ID Unique Identifier for Purchaser. Optional. Must be populated when Purchaser Type = PURCH.
MMCONTRACTUSERINPUT	Purchaser Sequence	Purchaser Sequence Maximum size of 99.
MMCONTRACTUSERINPUT	User Input Volume	User Input Volume Maximum size of 99999999.9 (8v1). Cannot be negative.
MMCONTRACTUSERINPUT	Override Energy	Override Energy (GJs) Product must be GAS or RAWGAS for Override Energy to be imported. Maximum size of 999999999999 (12v0). Cannot be negative.

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates. The contract must also have an Allocation Method of User Input.

Sample Data for MMCONTRACTUSERINPUT Template

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{User Input Volume}	^{Override Energy (GJs)}

^{Production Date}	^{Facility Type}	^{Facility ID}	^Product	^{Disposition Type}	^{Destination Type}	^{Destination ID}	^{Disposition Sequence}	^{Allocation Number}	^{Purchaser Type}	^{Purchaser ID}	^{Purchaser Sequence}	^{User Input Volume}	^{Override Energy (GJs)}
200804	P	RLTCPNP1	GAS	DELV	D	ALLIAD	0	2	PURCH	VEN1002	0	550.2	15245
200804	P	RLTCPNP1	C3	DELV	D	00015D	0	0	PURCH	VEN2002	0	50.2	0

MMCONTRACTUSERINPUTBYDESC (as of Release 23.2)

Template for MMCONTRACTUSERINPUTBYDESC

Template ID	Column Header	Description

Template ID	Column Header	Description
MMCONTRACTUSERINPUTBYDESC	Production Date	Production Date Format YYYYMM.
MMCONTRACTUSERINPUTBYDESC	Facility Type	Facility Type Options include: B (Battery) G (Gathering System) P (Plant)
MMCONTRACTUSERINPUTBYDESC	Facility	Facility Unique identifier for Facility.
MMCONTRACTUSERINPUTBYDESC	Product	Product Must be a valid producing product for Facility.
MMCONTRACTUSERINPUTBYDESC	Contract Description	Contract Description Maximum size of 60 characters.
MMCONTRACTUSERINPUTBYDESC	User Input Volume	User Input Volume Maximum size of 99999999.9 (8v1) Cannot be negative.
MMCONTRACTUSERINPUTBYDESC	Override Energy	Override Energy (GJs) Product must be GAS or RAWGAS for Override Energy to be imported. Maximum size of 999999999999 (12v0). Cannot be negative.

Note: This is an update only template. The market master facility purchaser contract must have already been created in Qbyte Metrix prior to importing any updates. The contract must also have an Allocation Method of User Input. There may be more than one market master facility purchaser contract with the same Contract Description; an error will be generated when more than one valid matching contract found.

Sample Data for MMCONTRACTUSERINPUTBYDESC Template

Production Date	Facility Type	Facility ID	Product	Contract Description	User Input Volume	Override Energy (GJs)

Production Date	Facility Type	Facility ID	Product	Contract Description	User Input Volume	Override Energy (GJs)
200804	P	RLTCPNP1	GAS	RLT23	554.2	16248
200804	P	RLTCPNP1	C3	RLTIMP	22.3	0

OBLIGATIONFACTORVALUE

Template for OBLIGATIONFACTORVALUE

Template ID	Column Header	Description

Template ID	Column Header	Description
OBLIGATIONFACTORVALUE	Production Date	Format YYYYMM.
OBLIGATIONFACTORVALUE	Well/Tract Type	Well/tract type Options include: W (Well) T (Tract)
OBLIGATIONFACTORVALUE	Well/Tract	Unique identifier for Well or Tract.
OBLIGATIONFACTORVALUE	Product	Must be a valid product for Royalty Obligations.
OBLIGATIONFACTORVALUE	Obligation Number	A four-character field that must contain only digits typically containing several zeros (i.e., 0001).
OBLIGATIONFACTORVALUE	Obligation Factor ID	Factor ID Maximum 16 characters. Must be a Royalty Obligation factor.
OBLIGATIONFACTORVALUE	Required	Required flag with valid options of Y or N.
OBLIGATIONFACTORVALUE	Factor Value	Maximum size of 9999999999.99999999 (10v8).
OBLIGATIONFACTORVALUE	Global Factor ID	Factor ID Maximum 16 characters. Must be a Royalty Global factor.

Sample Data for OBLIGATIONFACTORVALUE

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Obligation Factor ID}	^Required	^{Factor Value}	^{Global Factor ID}

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Obligation Factor ID}	^Required	^{Factor Value}	^{Global Factor ID}
201407	W	ATESTB01W02	GAS	0001	ACHROYRATE2	Y	0.25
201407	W	03/07-17-123-05W6/0	BYP	1234	ACHROYRATE2	N	0	AKEROYFAC01
201407	T	UHOL2TRACT1	OIL	0002	ACHROYRATE2	Y	25.3

Royalty Obligation Factor Values After Importing - OBLIGATIONFACTORVALUE

OILVALUATIONTRANS

Template for OILVALUATIONTRANS

Template ID	Column Header	Description

Template ID	Column Header	Description
OILVALUATIONTRANS	Production Date	Format YYYYMM.
OILVALUATIONTRANS	Submitting Facility	Submitting facility Petrinex formatted identifier with or without spaces (i.e., SKBT0058723 or SK BT 0058723).
OILVALUATIONTRANS	Delivering Facility	Delivering facility Petrinex formatted identifier with or without spaces (i.e., SKBT0058723 or SK BT 0058723).
OILVALUATIONTRANS	Receiving Facility	Receiving facility Petrinex formatted identifier with or without spaces (i.e., SKBT0058723 or SK BT 0058723).
OILVALUATIONTRANS	Custody Transfer Facility	Custody transfer facility Petrinex formatted identifier with or without spaces (i.e., SKBT0058723 or SK BT 0058723).
OILVALUATIONTRANS	Transportation Rate	Transportation Rate Must be greater than or equal to 0. Maximum size of 9999.99999 (4v5). Valid for submitting facilities in AB, MB, and SK for any production date and for submitting facilities in BC prior to the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation.
OILVALUATIONTRANS	Default Transportation Type (available as of Release 24.2)	Default Transportation Type for any Transportation coming from Pricing data. Options are: TRANSPPL (Transportation - Pipeline) TRANSRL (Transportation - Rail) TRANSTRK (Transportation - Truck Only valid for BC submitting facilities and production dates on or after the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation. For prior dates it will be ignored and default to TRANSPPL. Note: As of August 2024, the BC government has delayed the implementation of the BC Valuation Changes 2024, indicating that they now believe this will not be implemented until 2027.
OILVALUATIONTRANS	Quality Adjustment Rate (available as of Release 24.2)	Quality Adjustment Rate Maximum size of 99999999.99 (8v2). Only valid for BC submitting facilities and production dates on or after the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation. Note: As of August 2024, the BC government has delayed the implementation of the BC Valuation Changes 2024, indicating that they now believe this will not be implemented until 2027.
OILVALUATIONTRANS	Transportation Pipeline Rate (available as of Release 24.2)	Transportation Pipeline Rate Maximum size of 99999999.99 (8v2). Only valid for BC submitting facilities and production dates on or after the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation. Note: As of August 2024, the BC government has delayed the implementation of the BC Valuation Changes 2024, indicating that they now believe this will not be implemented until 2027.
OILVALUATIONTRANS	Transportation Rail Rate (available as of Release 24.2)	Transportation Rail Rate Maximum size of 99999999.99 (8v2). Only valid for BC submitting facilities and production dates on or after the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation. Note: As of August 2024, the BC government has delayed the implementation of the BC Valuation Changes 2024, indicating that they now believe this will not be implemented until 2027.
OILVALUATIONTRANS	Transportation Truck Rate (available as of Release 24.2)	Transportation Truck Rate Maximum size of 99999999.99 (8v2). Only valid for BC submitting facilities and production dates on or after the BC Valuation Changes 2024 Implementation date as set in System Configuration - Function Implementation. Note: As of August 2024, the BC government has delayed the implementation of the BC Valuation Changes 2024, indicating that they now believe this will not be implemented until 2027.

Note: This is an update only template; the Transportation Rate, Default Transportation Type, Quality Adjustment Rate, Transportation Pipeline Rate, Transportation Rail Rate, and Transportation Truck Rate are the only columns that can be updated.

Sample Data for OILVALUATIONTRANS Template

^{Production Date}	^{Submitting Facility}	^{Delivering Facility}	^{Receiving Facility}	^{Custody Transfer Facility}	^{Transportation Rate}	^{Default Transportation Type}	^{Quality Adjustment Rate}	^{Transportation Pipeline Rate}	^{Transportation Rail Rate}	^{Transportation Truck Rate}

^{Production Date}	^{Submitting Facility}	^{Delivering Facility}	^{Receiving Facility}	^{Custody Transfer Facility}	^{Transportation Rate}	^{Default Transportation Type}	^{Quality Adjustment Rate}	^{Transportation Pipeline Rate}	^{Transportation Rail Rate}	^{Transportation Truck Rate}
201406	SKBTS4L7436		SKBTB4L3983	SKTMTT17008	3.31000
201406	SKBTB4M3639		SKPLOP00017	SKPLOP00017	2.93000
201406	SKUNU6113	SKBTB4L3991	SKBTB4L3926	SKPLOP00017	7.63001
202409	BCBT0006550		BCBT0006589	BCPL0009879	0.00000	TRANSPPL	-0.26	1.02	0.00	0.00

OWNERGOVTCODEUPD (as of Release 23.4)

Template for OWNERGOVTCODEUPD

Template ID	Column Header	Description

Template ID	Column Header	Description
OWNERGOVTCODEUPD	Production Date	Format YYYYMM.
OWNERGOVTCODEUPD	Owner ID	Owner ID Maximum 16 characters.
OWNERGOVTCODEUPD	AB Government Code	Alberta Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Alberta government code will be deleted.
OWNERGOVTCODEUPD	BC Government Code	British Columbia Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous British Columbia government code will be deleted.
OWNERGOVTCODEUPD	MB Government Code	Manitoba Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Manitoba government code will be deleted.
OWNERGOVTCODEUPD	ON Government Code	Ontario Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Ontario government code will be deleted.
OWNERGOVTCODEUPD	SK Government Code	Saskatchewan Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Saskatchewan government code will be deleted.
OWNERGOVTCODEUPD	Federal Government Code	Federal Government Code (used for IOGC reporting). Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Federal government code will be deleted.

Sample Data for OWNERGOVTCODEUPD Template

^{Production Date}	^{Owner ID}	^{AB Government Code}	^{BC Government Code}	^{MB Government Code}	^{ON Government Code}	^{SK Government Code}	^{Federal Government Code}

^{Production Date}	^{Owner ID}	^{AB Government Code}	^{BC Government Code}	^{MB Government Code}	^{ON Government Code}	^{SK Government Code}	^{Federal Government Code}
201407	RLT006	AR06	BR06
201407	RLT007	!	!	MR07	!	!	!

OWNERMASTER (as of Release 23.4)

Template for OWNERMASTER

Template ID	Column Header	Description

Template ID	Column Header	Description
OWNERMASTER	Production Date	Format YYYYMM.
OWNERMASTER	Owner ID	Owner ID Maximum 16 characters.
OWNERMASTER	Owner Name	Owner Name Maximum of 40 characters.
OWNERMASTER	Address Line#1	Address Line #1 Optional. Maximum of 30 characters.
OWNERMASTER	Address Line#2	Address Line #2 Optional. Maximum of 30 characters.
OWNERMASTER	Address Line#3	Address Line #3 Optional. Maximum of 30 characters.
OWNERMASTER	Address Line#4	Address Line #4 Optional. Maximum of 30 characters.
OWNERMASTER	Postal Code	Postal Code Optional. Maximum of 12 characters.
OWNERMASTER	Phone Number	Phone Number Optional. Maximum of 12 characters.
OWNERMASTER	Fax Number	Fax Number Optional. Maximum of 12 characters.
OWNERMASTER	Contact Name	Contact Name Optional. Maximum of 60 characters.
OWNERMASTER	User Defined#1	User Defined#1 Optional. Maximum of 16 characters. NOTE: This field may be mandatory depending upon system User Defined Labels for OwnerMaster.userDefined1.
OWNERMASTER	NRT Applicable	NRT Applicable Options are: Y - Yes N - No
OWNERMASTER	NRT Rate Override	NRT Rate Override Must be 0 when NRT Applicable is No. Must be between 0 and 99.999 when NRT Applicable is Yes. Maximum size of 999.999 (3v3).
OWNERMASTER	JIBLink Province	JIBLink Province Optional. Maximum of 2 characters.
OWNERMASTER	JIBLink Country	JIBLink Country Optional. Maximum of 2 characters.
OWNERMASTER	BC Reporting/RTP Override	BC Reporting/RTP Override Owner Optional. Must be blank when the owner being updated is a Region Master Owner. Must have a valid Owner Master for the production date. Cannot be an owner that is Inactive. Cannot be the same as the owner being updated. Cannot be an owner that, itself, has a BC Reporting/RTP Override owner for the production date. Maximum of 16 characters.
OWNERMASTER	Global Obligation Payor	Global Obligation Payor Options are: Y - Yes N - No Note: This field will be ignored when the system Function Implementation option Enable the use of Global Obligation Payors is not active for the production date, but if entered it must still pass data type validations. This means it must be Y, N, !, or blank.
OWNERMASTER	AB Government Code	Alberta Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Alberta government code will be deleted.
OWNERMASTER	BC Government Code	British Columbia Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous British Columbia government code will be deleted.
OWNERMASTER	MB Government Code	Manitoba Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Manitoba government code will be deleted.
OWNERMASTER	ON Government Code	Ontario Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Ontario government code will be deleted.
OWNERMASTER	SK Government Code	Saskatchewan Government Code. Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Saskatchewan government code will be deleted.
OWNERMASTER	Federal Government Code	Federal Government Code (used for IOGC reporting). Optional. Maximum of 30 characters. Note: Use an ! in this column to leave the government code as is. If left blank, then any previous Federal government code will be deleted.
OWNERMASTER	Note Text	Owner Note Optional. Maximum of 4000 characters.

Sample Data for OWNERMASTER Template

^{Production Date}	^{Owner ID}	^{Owner Name}	^{Address Line#1}	^{Address Line#2}	^{Address Line#3}	^{Address Line#4}	^{Postal Code}	^{Phone Number}	^{Fax Number}	^{Contact Name}	^{User Defined#1}	^{NRT Applicable}	^{NRT Rate Override}	^{JIBLink Province}	^{JIBLink Country}	^{BC Reporting/RTP Owner}	^{Global Obligation Payor}	^{AB Government Code}	^{BC Government Code}	^{MB Government Code}	^{ON Government Code}	^{SK Government Code}	^{Federal Government Code}	^{Note Text}

^{Production Date}	^{Owner ID}	^{Owner Name}	^{Address Line#1}	^{Address Line#2}	^{Address Line#3}	^{Address Line#4}	^{Postal Code}	^{Phone Number}	^{Fax Number}	^{Contact Name}	^{User Defined#1}	^{NRT Applicable}	^{NRT Rate Override}	^{JIBLink Province}	^{JIBLink Country}	^{BC Reporting/RTP Owner}	^{Global Obligation Payor}	^{AB Government Code}	^{BC Government Code}	^{MB Government Code}	^{ON Government Code}	^{SK Government Code}	^{Federal Government Code}	^{Note Text}
201407	RLT006	RLT Owner 6	301, 7648 5th St. S.W.	Calgary, Alberta	Canada		T2X7Y3	403-555-5555			006RLT	N	00.000				N	AR06	BR06	MR06		SR06	FR06	Added owner for a new WIO.
201407	RLT007	!	!	!	!	!	!	!	!	!	007RLT	Y	7.5	!	!	!	!	!	!	!	!	!	!	Updated User Defined and set NRT correctly.

OWNERNAMEADDRESSUPD (as of Release 23.4)

Template for OWNERNAMEADDRESSUPD

Template ID	Column Header	Description

Template ID	Column Header	Description
OWNERNAMEADDRESSUPD	Production Date	Format YYYYMM.
OWNERNAMEADDRESSUPD	Owner ID	Owner ID Maximum 16 characters.
OWNERNAMEADDRESSUPD	Owner Name	Owner Name Maximum of 40 characters.
OWNERNAMEADDRESSUPD	Address Line#1	Address Line #1 Optional. Maximum of 30 characters.
OWNERNAMEADDRESSUPD	Address Line#2	Address Line #2 Optional. Maximum of 30 characters.
OWNERNAMEADDRESSUPD	Address Line#3	Address Line #3 Optional. Maximum of 30 characters.
OWNERNAMEADDRESSUPD	Address Line#4	Address Line #4 Optional. Maximum of 30 characters.
OWNERNAMEADDRESSUPD	Postal Code	Postal Code Optional. Maximum of 30 characters.

Sample Data for OWNERNAMEADDRESSUPD Template

Production Date	Owner ID	Owner Name	Address Line#1	Address Line#2	Address Line#3	Address Line#4	Postal Code

Production Date	Owner ID	Owner Name	Address Line#1	Address Line#2	Address Line#3	Address Line#4	Postal Code
201407	RLT006	RLT Owner 6	301, 7648 5th St. S.W.	Calgary, Alberta	Canada		T2X7Y3
201407	RLT007	!	511, 748 8th Ave. S.W.	!	!		!

PARTNEROPPRICING (as of Release 24.3)

Template for PARTNEROPPRICING

Template ID	Column Header	Description

Template ID	Column Header	Description
PARTNEROPPRICING	Production Date	Format YYYYMM.
PARTNEROPPRICING	Battery	Unique Identifier for the Partner Operated Battery.
PARTNEROPPRICING	Transaction Type	Options are: CRWN (Crown) FRHD (Freehold) ORR (Override) REV (Sales)
PARTNEROPPRICING	Product	Must be a valid producing product for Partner Operated.
PARTNEROPPRICING	Plant	Optional. Unique Identifier for a Plant. Only valid for Sales (REV) transactions when Product is not Oil.
PARTNEROPPRICING	Purchaser/Royalty Owner ID	Unique Identifier for an Owner. Only valid for Sales (REV) transactions. Maximum 16 characters.
PARTNEROPPRICING	Purchaser Sequence	Optional. Only valid for Sales (REV) transactions. If entered, must be greater than or equal to 0 and a maximum size of 99 (2).
PARTNEROPPRICING	Destination Type	Optional. Only valid for Sales (REV) transactions. Options include: B (Battery) G (Gathering System) P (Plant) D (Delivery System) I (Injection Facility)
PARTNEROPPRICING	Destination	Optional. Unique Identifier for the Destination. Only valid for Sales (REV) transactions when Destination Type is not blank.
PARTNEROPPRICING	Pricing UDF1	Optional. Maximum size of 16 characters. May be mandatory based on Corporate setting of PartnerOpBatteryPrice.userDefined1 (PARTOPPRICEUSERDEFINED1).
PARTNEROPPRICING	Shipper Owner Contract	Optional. Maximum size of 60 characters. Only valid for Sales (REV) transactions when Product is Oil and province has implemented Oil Valuation RTP.
PARTNEROPPRICING	Pricing Option	Options are: CONTRT (Total Contract Value) UNIT (Price Per Unit)
PARTNEROPPRICING	Allocate By	Optional. Only valid for Gas Sales (REV) transactions. Options are: GJ (Gigajoules) SALE (Sales Volume).
PARTNEROPPRICING	Price/Value	Optional. When Pricing Option is CONTRT (Total Contract Value) maximum size is 999999999.99 (9v2). When Pricing Option is UNIT (Price Per Unit) maximum size is 9999.99999999 (4v8). If left blank, it will be set to 0.
PARTNEROPPRICING	Transportation Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Transportation Rate/Value	Optional. Only valid for Sales (REV) transactions when Transportation Type is not NA. When Transportation Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Transportation Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).
PARTNEROPPRICING	Quality Adjustment Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Quality Adjustment Rate/Value	Optional. Only valid for Sales (REV) transactions when Quality Adjustment Type is not NA. When Quality Adjustment Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Quality Adjustment Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).
PARTNEROPPRICING	Tariff Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Tariff Rate/Value	Optional. Only valid for Sales (REV) transactions when Tariff Type is not NA. When Tariff Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Tariff Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).
PARTNEROPPRICING	Line Loss Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Line Loss Rate/Value	Optional. Only valid for Sales (REV) transactions when Line Loss Type is not NA. When Line Loss Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Line Loss Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).
PARTNEROPPRICING	Other#1 Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Other#1 Rate/Value	Optional. Only valid for Sales (REV) transactions when Other#1 Type is not NA. When Other#1 Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Other#1 Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).
PARTNEROPPRICING	Other#2 Type	Optional. Only valid for Sales (REV) transactions. Options are: NA (Not Applicable) RATE (Rate) VALUE (Total Amount).
PARTNEROPPRICING	Other#2 Rate/Value	Optional. Only valid for Sales (REV) transactions when Other#2 Type is not NA. When Other#2 Type is RATE (Rate) maximum size is 9999.99999999 (4v8). When Other#2 Type is VALUE (Total Amount) maximum size is 999999999.99 (9v2).

Sample Data for PARTOPPRICING Template

^{Production Date}	^Battery	^{Transaction Type}	^Product	^Plant	^{Purchaser/Royalty Owner ID}	^{Purchaser Sequence}	^{Destination Type}	^Destination	^{Pricing UDF1}	^{Shipper Owner Contract}	^{Pricing Option}	^{Allocate By}	^Price/Value	^{Transportation Type}	^{Transportation Rate/Value}	^{Quality Adjustment Type}	^{Quality Adjustment Rate/Value}	^{Tariff Type}	^{Tariff Rate/Value}	^{Line Loss Type}	^{Line Loss Rate/Value}	^{Other#1 Type}	^{Other#1 Rate/Value}	^{Other#2 Type}	^{Other#2 Rate/Value}

^{Production Date}	^Battery	^{Transaction Type}	^Product	^Plant	^{Purchaser/Royalty Owner ID}	^{Destination Type}	^Destination	^{Shipper Owner Contract}	^{Pricing Option}	^{Allocate By}	^Price/Value	^{Transportation Type}	^{Transportation Rate/Value}	^{Quality Adjustment Type}	^{Quality Adjustment Rate/Value}	^{Tariff Type}	^{Tariff Rate/Value}	^{Line Loss Type}	^{Other#1 Type}	^{Other#2 Type}
201407	AKEABPARTOP	REV	C3MX	OF131281	000023				UNIT	SALE	85.49254	NA	0	NA	0	NA	0	NA	NA	NA
201407	AKEABPARTOP	REV	C3SP		000012	D	0000957		CONTRT	SALE	15487.35	RATE	5.4864	NA	0	NA	0	NA	NA	NA
201407	AKEABPARTOP		GAS	OF0001121	000012	D	DEL_POP		UNIT	GJ	6.857	NA	0	NA	0	RATE	.58	NA	NA	NA
201407	AKEABPARTOP		OIL		000021			CONT234	UNIT	SALE	500.487568	RATE	15.4876	RATE	-1.254	NA	0	NA	NA	NA

PARTNEROPSALES

Template for PARTNEROPSALES

Template ID	Column Header	Description

Template ID	Column Header	Description
PARTNEROPSALES	Production Date	Format YYYYMM.
PARTNEROPSALES	Battery	Unique Identifier for the Battery the well is attached to.
PARTNEROPSALES	Well	Unique identifier for a Well.
PARTNEROPSALES	Product	Must be a valid producing product for Facility.
PARTNEROPSALES	Purchaser	Unique Identifier for Purchaser. Maximum 16 characters.
PARTNEROPSALES	Purchaser Sequence	Must be greater than or equal to 0 and a maximum size of 99 (2).
PARTNEROPSALES	Facility Type	Facility type Options include: P (Plant) Note: This can be left blank if the Facility ID is blank.
PARTNEROPSALES	Facility	Unique Identifier for Facility. Can be left blank.
PARTNEROPSALES	Destination Type	Destination type Options include: B (Battery) G (Gathering System) P (Plant) D (Delivery System) I (Injection) blank (Not applicable)
PARTNEROPSALES	Destination	Unique Identifier for Destination. Note: This can be left blank if the Destination Type is blank.
PARTNEROPSALES	Net Volume	Maximum size of 99999999.9 (8v1)
PARTNEROPSALES	Net Value	Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net GJs	Maximum size of 999999999999 (12)
PARTNEROPSALES	Net Trans.	Net Transportation Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net Quality Adj.	Net Quality Adjustment Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net Tariff	Net Tariff Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net Line Loss	Net Line Loss Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net Other#1	Net Other#1 Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Net Other#2	Net Other#2 Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Volume	Maximum size of 99999999.9 (8v1)
PARTNEROPSALES	Gross Value	Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross GJs	Maximum size of 999999999999 (12)
PARTNEROPSALES	Gross Trans.	Gross Transportation Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Quality Adj.	Gross Quality Adjustment Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Tariff	Gross Tariff Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Line Loss	Gross Line Loss Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Other#1	Gross Other#1 Value. Maximum size of 999999999.99 (9v2)
PARTNEROPSALES	Gross Other#2	Gross Other#2 Value. Maximum size of 999999999.99 (9v2)

Note: This is an update only Template. The following columns are the only columns that can be updated using this template. Updating these columns is conditional to the Transaction Level (Gross Input, Net Input or Gross and Net Input) of the Partner Operated battery:

Net Volume, Value, GJs, Transportation, Quality Adjustment, Tariff, Line Loss, Other#1, and Other#2 .
Gross Volume, Value, GJs, Transportation, Quality Adjustment, Tariff, Line Loss, Other#1, and Other#2

Sample Data for PARTNEROPSALES Template

^{Production Date}	^Battery	^Well	^Product	^Purchaser	^{Purchaser Sequence}	^Facility^Type	^Facility	^Destination^Type	^Destination	^{Net Volume}	^{Net Value}	^{Net GJs}	^{Net Trans.}	^{Net Quality Adj.}	^{Net Tariff}	^{Net Line Loss}	^{Net Other#1}	^{Net Other#2}	^{Gross Volume}	^{Gross Value}	^{Gross GJs}	^{Gross Trans.}	^{Gross Quality Adj.}	^{Gross Tariff}	^{Gross Line Loss}	^{Gross Other#1}	^{Gross Other#2}

^{Production Date}	^Battery	^Well	^Product	^Purchaser	^Facility^Type	^Facility	^Destination^Type	^Destination	^{Net Volume}	^{Net Value}	^{Net GJs}	^{Net Trans.}	^{Net Quality Adj.}	^{Net Tariff}	^{Net Line Loss}	^{Net Other#1}	^{Net Other#2}	^{Gross Volume}	^{Gross Value}	^{Gross GJs}	^{Gross Trans.}	^{Gross Quality Adj.}	^{Gross Tariff}	^{Gross Line Loss}	^{Gross Other#1}	^{Gross Other#2}
201407	AKEABPARTOP	AKEABPARTOPW02	C3MX	000023	P	OF131281			12.5	2230.63						15.62		23.4	4175.73						29.25
201407	AKEABPARTOP	AKEABPARTOPW02	C3SP	000012			D	0000957	1.4	630.17								2.8	1260.34
201407	AKEABPARTOP	AKEABPARTOPW02	C4	000012			D	0000957	1.5	1337.24							7.50	3.1	395.13							15.50
201407	AKEABPARTOP	AKEABPARTOPW02	C5	000012			D	0000957	0.6	161.93								1.1	296.88
201407	AKEABPARTOP	AKEABPARTOPW02	GAS	000012	P	OF0001121	D	DEL_POP	16.0	2072.00	592			148.00				20.0	2590.00	740			185.00
201407	AKEABPARTOP	AKEABPARTOPW02	GAS	000012			D	0002229	12.0	1716.00	520				0.25			24.1	3445.2	1044				0.50
201407	AKEABPARTOP	AKEABPARTOPW02	GAS	000022					22.0	4802.6	814							25.0	5457.5	925
201407	AKEABPARTOP	AKEABPARTOPW02	OIL	000001					32.7	9834.20		20.00	16.35					33.5	10074.79		20.49	16.75
201407	AKEABPARTOP	AKEABPARTOPW02	OIL	000021					43.4	13052.12		22.00	21.70					44.2	13292.71		22.40	22.10

ROYALTYGLOBALFACTOR

Template for ROYALTYGLOBALFACTOR

Template ID	Column Header	Description

Template ID	Column Header	Description
ROYALTYGLOBALFACTOR	Production Date	Format YYYYMM.
ROYALTYGLOBALFACTOR	Factor ID	Factor I Maximum 16 characters.
ROYALTYGLOBALFACTOR	Description	Description Maximum 40 characters.
ROYALTYGLOBALFACTOR	Factor Value	Maximum size of 9999999999.99999999 (10v8)

Sample Data for ROYALTYGLOBALFACTOR Template

Production Date	Factor ID	Description	Factor Value

Production Date	Factor ID	Description	Factor Value
201406	AKEROYFAC01	Royalty Factor Rate = 5.1	5.1
201405	AKEROYFAC01	!	5.2
201404	AKEROYFAC01	Royalty Factor Rate = 5.12345678	5.12345678
201406	AKEROYFAC02	Royalty Factor Rate = 5.456	5.456
201405	AKEROYFAC01	Royalty Factor Rate = 6.456	6.456
201404	AKEROYFAC01	Royalty Factor Rate = 7.456	7.456

Royalty Global Factors After Importing - ROYALTYGLOBALFACTOR

ROYALTYOBLIGATION

Template for ROYALTYOBLIGATION

Template ID	Column Header	Description

Template ID	Column Header	Description
ROYALTYOBLIGATION	Production Date	Format YYYYMM.
ROYALTYOBLIGATION	Well/Tract Type	Well/tract type Options include: W (Well) T (Tract)
ROYALTYOBLIGATION	Well/Tract	Unique identifier for well or tract.
ROYALTYOBLIGATION	Product	Must be a valid product for Royalty Obligations.
ROYALTYOBLIGATION	Obligation Number	A four-character field that must contain only digits that typically contain several zeros (i.e., 0001).
ROYALTYOBLIGATION	Royalty Type	Indicates the type of obligation. Options include: CRWN (Crown) FCLS (F-Class) FRHD (Freehold) IOGC (IOGC) ORR (Override) OTHER (Other)
ROYALTYOBLIGATION	Royalty Owner ID	Unique Identifier for Royalty Owner. Maximum 16 characters.
ROYALTYOBLIGATION	Active	Indicates the Active status of the obligation. Options include: Y (Active) N (Inactive) P (Pending) E (Expired)
ROYALTYOBLIGATION	Taken In Kind	Indicates whether the Royalty Owner Takes In-Kind or not. Options include: Y (Yes) N (No)
ROYALTYOBLIGATION	Tax Type	Indicates the Tax Type for the obligation. Options include: EXEM (Exempt) PROD (Production) RESO (Resource)
ROYALTYOBLIGATION	Formula ID	Indicates the Royalty Formula ID to be used when calculating the obligation. Can be blank if Active = P or E. Maximum 16 characters.
ROYALTYOBLIGATION	Payment Type	Options include: INCOME (Royalty Income) OTHER (Paid On Our Behalf) SELF (Paid By Self) TIK (Take In Kind)
ROYALTYOBLIGATION	Payor Type	Indicates whether the payors are determined by Obligation or are Global. Options include: OBLG (Obligation Level) GLBL (Global Level)
ROYALTYOBLIGATION	DOI Extension ID	Indicates the DOI Extension number to be used for the obligation. If Default DOI, leave as blank. Maximum 2 digits.
ROYALTYOBLIGATION	Paid By Owner ID	When the obligation is Paid On Our Behalf this indicates the owner paying the Royalty Obligation for us. Maximum 16 characters.
ROYALTYOBLIGATION	User Defined 1	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATION	User Defined 2	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATION	User Defined 3	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATION	Note	Maximum 4000 characters.

Sample Data for ROYALTYOBLIGATION Template

By Qbyte Metrix Well ID/Tract ID:

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Royalty Type}	^{Royalty Owner ID}	^Active	^{Taken In Kind}	^{Tax Type}	^{Formula ID}	^{Payment Type}	^{Payor Type}	^{DOI Extension ID}	^{Paid By Owner ID}	^{User Defined 1}	^{User Defined 2}	^{User Defined 3}	^Notes

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Royalty Type}	^{Royalty Owner ID}	^Active	^{Taken In Kind}	^{Tax Type}	^{Formula ID}	^{Payment Type}	^{Payor Type}	^{DOI Extension ID}	^{Paid By Owner ID}	^{User Defined 1}	^{User Defined 2}	^{User Defined 3}	^Notes
201405	W	ATESTB01W02	OIL	0003	FRHD	900001	Y	Y	EXEM	TIKF2	TIK	OBLG	10				UD 301	DOI R RI
201405	W	ATESTB01W02	GAS	0004	ORR	900002	!	!	!	!	!	!	!	!	Change	!	!	update
201405	W	ATESTB01W02	BYP	0005	ORR	900003	Y	N	EXEM	RLTSALES	SELF	OBLG			UD102		UD 303
201405	W	ATESTB01W02	OIL	0006	FRHD	900001	N	Y	EXEM	TLOROY02	TIK	OBLG			UD102	UD201	UD 304	IActive RI
201405	W	ATESTB01W02	GAS	0007	ORR	900002	E	N	EXEM	ROYWELL1	SELF	OBLG	12			UD202	UD 305	Expired RI
201405	W	ATESTB01W02	BYP	0008	ORR	900003	N	N	EXEM	RLTSALES	OTHER	OBLG		000001		UD203	UD 306
201405	W	ATESTB01W02	GAS	0009	ORR	900004	P	N	EXEM		SELF	GLBL				UD204	UD 307	Pen RI
201405	T	UHOLTRACT2	OIL	0001	FRHD	900001	Y	N	EXEM	RLTSALES	SELF	OBLG				UDT201
201405	T	UHOLTRACT2	GAS	0002	FRHD	900002	Y	N	EXEM	TLOROY02	OTHER	OBLG		000001		UDT202
201405	T	UHOLTRACT2	BYP	0003	FRHD	900003	N	N	EXEM	TLOROY02	SELF	OBLG				UDT203
201405	T	UHOLTRACT3	BYP	0001	FRHD	900003	N	N	EXEM	TLOROY02	SELF	OBLG				UDT301

Royalty Obligations After Importing - ROYALTYOBLIGATION

A note will always be created by the process to indicate that the obligation was Imported by Template. If you had a note entered on the template for that obligation, it will be created as a second note.

ROYALTYOBLIGATIONDELETE

Template for ROYALTYOBLIGATIONDELETE.

Template ID	Column Header	Description

Template ID	Column Header	Description
ROYALTYOBLIGATIONDELETE	Production Date	Format YYYYMM.
ROYALTYOBLIGATIONDELETE	Well/Tract Type	Well/tract type Options include: W (Well) T (Tract)
ROYALTYOBLIGATIONDELETE	Well/Tract	Unique identifier for well or tract.
ROYALTYOBLIGATIONDELETE	Product	Must be a valid product for Royalty Obligations.
ROYALTYOBLIGATIONDELETE	Obligation Number	A four-character field that must contain only digits that typically contain several zeros (i.e., 0001).

Sample Data for ROYALTYOBLIGATIONDELETE Template

Production Date	Well/Tract Type	Well/Tract	Product	Obligation Number

Production Date	Well/Tract Type	Well/Tract	Product	Obligation Number
201405	W	ATESTB01W02	OIL	0003
201405	W	ATESTB01W02	BYP	0008
201405	W	ATESTB01W02	GAS	0009
201405	T	UHOLTRACT2	OIL	0001
201405	T	UHOLTRACT3	BYP	0001

ROYALTYOBLIGATIONFACTOR

Template for ROYALTYOBLIGATIONFACTOR

Template ID	Column Header	Description

Template ID

Column Header

Description

ROYALTYOBLIGATIONFACTOR

Production Date

Format YYYYMM.

ROYALTYOBLIGATIONFACTOR

Factor ID

Maximum 16 characters.

ROYALTYOBLIGATIONFACTOR

Description

Maximum 40 characters.

Sample Data for ROYALTYOBLIGATIONFACTOR Template

Production Date	Factor ID	Description

Production Date	Factor ID	Description
201407	ACHROYRATE2	ACH ROYALTY RATE 2 update
201407	ACHPERCENTOFPROD	ACH PERCENT OF PRODUCTION

Royalty Obligation Factors After Importing - ROYALTYOBLIGATIONFACTOR

ROYALTYOBLIGATIONHDR

Template for ROYALTYOBLIGATIONHDR

Template ID	Column Header	Description

Template ID	Column Header	Description
ROYALTYOBLIGATIONHDR	Production Date	Format YYYYMM.
ROYALTYOBLIGATIONHDR	Well/Tract Type	Well/tract type Options include: W (Well) T (Tract)
ROYALTYOBLIGATIONHDR	Well/Tract	Unique identifier for well or tract.
ROYALTYOBLIGATIONHDR	Product	Must be a valid product for Royalty Obligations.
ROYALTYOBLIGATIONHDR	Obligation Number	A four-character field that must contain only digits and typically contains several zeros (i.e., 0001).
ROYALTYOBLIGATIONHDR	Royalty Type	Indicates the type of obligation. Options include: CRWN (Crown) FCLS (F-Class) FRHD (Freehold) IOGC (IOGC) ORR (Override) OTHER (Other)
ROYALTYOBLIGATIONHDR	Royalty Owner ID	Unique Identifier for Royalty Owner. Maximum 16 characters.
ROYALTYOBLIGATIONHDR	Taken In Kind	Indicates whether the Royalty Owner Takes In-Kind or not. Options include: Y (Yes) N (No)
ROYALTYOBLIGATIONHDR	User Defined 1	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATIONHDR	User Defined 2	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATIONHDR	User Defined 3	Generic User-Defined field available to capture miscellaneous data. Maximum 16 characters.
ROYALTYOBLIGATIONHDR	Note	Maximum 4000 characters.

Sample Data for ROYALTYOBLIGATIONHDR Template

By Qbyte Metrix Well ID/Tract ID:

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Royalty Type}	^{Royalty Owner ID}	^{Taken In Kind}	^{User Defined 1}	^{User Defined 2}	^{User Defined 3}	^Notes

^{Production Date}	^{Well/Tract Type}	^Well/Tract	^Product	^{Obligation Number}	^{Royalty Type}	^{Royalty Owner ID}	^{Taken In Kind}	^{User Defined 1}	^{User Defined 2}	^{User Defined 3}	^Notes
201406	W	UNHOLB01W02	OIL	0001	FRHD	900001	Y			UD 301	Uploading Royalties
201406	W	UNHOLB01W02	GAS	0002	ORR	900002	N			UD 302
201406	W	UNHOLB01W02	BYP	0003	ORR	900003	N			UD 303
201406	T	UHOLTRACT1	OIL	0001	FRHD	900001	Y		UD T201	UD 301	Roy for Tract 1 TIK
201406	T	UHOLTRACT1	GAS	0002	ORR	900002	N		UD T202	UD 302
201406	T	UHOLTRACT1	BYP	0003	ORR	900003	N		UD T203	UD 303
201406	W	UNHOLB01W05	OIL	0001	FRHD	900001	Y	Test 4			Uploading Royalties B05
201406	T	UHOLTRACT2	OIL	0001	FRHD	900001	Y		UD T203	UD 301	Roy for Tract 2 TIK

Royalty Obligation After Importing - ROYALTYOBLIGATIONHDR

The Royalty Obligation will always be created with an Active Status of Pending. The Formula ID and Formula Description will be blank. A note will always be created by the process to indicate that the obligation was Imported by Template. If you had a note entered on the template for that obligation, it would be created as a second note.

Well

WELLABOILCROWN (as of Release 24.4)

Template for WELLABOILCROWN

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLABOILCROWN	Production Date	Format YYYYMM.
WELLABOILCROWN	Well	Unique identifier for a well.
WELLABOILCROWN	Oil Density	Must be greater than or equal to 0. Only valid for wells in Alberta. Maximum size is 9999.99 (4v2).
WELLABOILCROWN	Crown Calculation Type	Alberta Wells only. Options are: B - Bypass E - Equivalent Use MRFC - MRF 2017 C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) MRFPC - MRF 2017 Post C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) N - ARF 2009 Normal T - ARF 2009 Transitional
WELLABOILCROWN	Equivalent Use Sub Type	Alberta Wells only. MRFC - MRF 2017 C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) MRFPC - MRF 2017 Post C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) N - ARF 2009 Normal T - ARF 2009 Transitional Only allowed when Crown Calculation Type is E (Equivalent Use).

Sample Data for WELLABOILCROWN

^{Production Date}	^Well	Oil Density	Crown Calculation Type	Equivalent Use Sub Type

^{Production Date}	^Well	Oil Density	Crown Calculation Type	Equivalent Use Sub Type
201406	01/16-20-013-05w4/0	850.00	MRFC
201406	01/16-19-013-05w4/0	902.00	E	MRFC

WELLCONSBYLABEL

Template for WELLCONSBYLABEL

Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating/importing well consumption master data.

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLCONSBYLABEL	Production Date	Format YYYYMM.
WELLCONSBYLABEL	Well	Unique identifier for a well.
WELLCONSBYLABEL	Label of the Factor	The unique Qbyte Metrix Label assigned to the factor. This is the label column of the Gas Adjustment/Consumption Factors grid. (See below.)
WELLCONSBYLABEL	Rate	Must be greater than or equal to 0 and a maximum size of 999.99999999 (3v8). Note: Rate is not required if Calculation Basis is INPVOL.

Sample Data for WELLCONSBYLABEL Template

By Qbyte Metrix Well ID:

Production Date	Well	Label of the Factor	Rate

Production Date	Well	Label of the Factor	Rate
200804	AKEIMPW01W01	FUEL12	9
200804	AKEIMPW01W01	FUEL11	8
200804	AKEIMPW01W01	FLARE1	5
200804	AKEIMPW01W01	FLARE2	6
200804	AKEIMPW01W01	FLARE3	7
200804	AKEIMPW01W01	VENT21	11
200804	AKEIMPW01W01	VENT22	12
200804	AKEIMPW01W01	GATH99	0.22
200804	AKEIMPW01W01	GATH99	0.11
200804	AKEIMPW01W01	VENT23	22

By UWI:

Production Date	Well	Label of the Factor	Rate

Production Date	Well	Label of the Factor	Rate
200804	01/05-24-014-06w4/0	VNT	6
200804	01/05-24-013-06w4/0	FLR	3
200804	01/05-24-012-06w4/0	VENT1	2.2
200804	01/05-24-011-06w4/0	FUL	8.5

Well Production After Importing - WELLCONSBYLABEL

WELLCONSDELETEBYLABEL

Template for WELLCONSDELETEBYLABEL

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLCONSDELETEBYLABEL	Production Date	Format YYYYMM.
WELLCONSDELETEBYLABEL	Well	Unique identifier for a well.
WELLCONSDELETEBYLABEL	Label of the Factor	The unique Qbyte Metrix Label assigned to the factor.

Sample Data for WELLCONSDELETEBYLABEL Template

Production Date	Well	Label of the Factor

Production Date	Well	Label of the Factor
200804	AKEIMPW01W01	FUEL12
200804	AKEIMPW01W01	GATH99
200804	AKEIMPW01W01	VENT23

WELLCONSUMPTION

Template for WELLCONSUMPTION

Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating and importing well consumption master data.

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLCONSUMPTION	Production Date	Format YYYYMM.
WELLCONSUMPTION	Well	Unique identifier for a well.
WELLCONSUMPTION	Label of the Factor	The unique Qbyte Metrix Label assigned to the factor. This is the label column of the Gas Adjustment/Consumption Factors grid. (See below.)
WELLCONSUMPTION	Calculation Basis	Indicates the basis of the factor calculation. One of the following options must be entered. Options include: GASPRD (Gas Production) OILPRD (Oil Production) WTRPRD (Water Production) HRSPRD (Producing Hours) MINPRD (Producing Minutes) INPVOL (Manual Input) GOR (Gas Oil Ratio) STV (Stock Tank Vapour) GIS (Gas In Solution)
WELLCONSUMPTION	Rate	Must be greater than or equal to 0 and a maximum size of 999.99999999 (3v8). Note: Rate is not required if the Calculation Basis is INPVOL.
WELLCONSUMPTION	Usage Type	Used to indicate how the calculated factor volume is to be used. One of the following options must be entered. Options include: FLAR (Flared) FUEL (Fuel) VENT (Vented) GATH (Gathered)
WELLCONSUMPTION	Adjust Production	Used to indicate whether to adjust Gas Production by calculated factor volume. One of the following options must be entered; a blank indicates Not Applicable. Options include: Y (Both Well and Battery Production adjusted) N (Not adjusted) W (Well Production adjusted but not Battery) R (Receipt - Production not adjusted) blank (Not applicable)
WELLCONSUMPTION	Recalculate on Actuals	Used to indicate whether to adjust Gas Production by calculated factor volume. One of the following options must be entered; a blank indicates Not Applicable. Options include: Y (Both Well and Battery Production adjusted) N (Not adjusted) W (Well Production adjusted but not Battery) blank (Not applicable)
WELLCONSUMPTION	Include in Proration	Used to indicate whether the calculated factor should be included in gas proration. One of the following options must be entered; a blank indicates Not Applicable. Options include: Y (Include in Proration) N (Do not include in Proration) BTY (Include or not based on Battery Production options) blank (Not applicable)

Sample Data for WELLCONSUMPTION Template

^{Production Date}	^Well	^{Label of the Factor}	^{Calculation Basis}	^Rate	^{Usage Type}	^{Adjust Production}	^{Recalculate on Actuals}	^{Include in Proration}

^{Production Date}	^Well	^{Label of the Factor}	^{Calculation Basis}	^Rate	^{Usage Type}	^{Adjust Production}	^{Recalculate on Actuals}	^{Include in Proration}
200804	AKEIMPW01W02	FUEL12	INPVOL	9	FUEL	N
200804	AKEIMPW01W02	FUEL11	HRSPRD	8	FUEL	N
200804	AKEIMPW01W02	FLARE1	OILPRD	5	FLARE	N	N
200804	AKEIMPW01W02	FLARE2	GASPRD	6	FLARE	N	N
200804	AKEIMPW01W02	FLARE3	MINPRD	7	FLARE	N
200804	AKEIMPW01W02	VENT21	GIS	10	VENT	Y	Y	Y
200804	AKEIMPW01W02	VENT22	STV	11	VENT	Y	Y	Y
200804	AKEIMPW01W02	GATH99	GOR	0.22	GATH	Y	N	N
200804	AKEIMPW01W02	GATH99	GOR	0.11	GATH	Y	N	N

Well Production After Importing - WELLCONSUMPTION

WELLCONSUMPTIONUPD

Template for WELLCONSUMPTIONUPD

Also, see the Qbyte Metrix Well Consumption Master Imports presentation that shows detailed examples of creating/importing well consumption master data.

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLCONSUMPTIONUPD	Production Date	Format YYYYMM.
WELLCONSUMPTIONUPD	Well	Unique identifier for a well.
WELLCONSUMPTIONUPD	Label of the Factor	The unique Qbyte Metrix Label assigned to the factor. This is the label column of the Gas Adjustment/Consumption Factors grid. (See below.)
WELLCONSUMPTIONUPD	Calculation Basis	Indicates the basis of the factor calculation. One of the following options must be entered. Options include: GASPRD (Gas Production) OILPRD (Oil Production) WTRPRD (Water Production) HRSPRD (Producing Hours) MINPRD (Producing Minutes) INPVOL (Manual Input) GOR (Gas Oil Ratio) STV (Stock Tank Vapor) GIS (Gas In Solution)
WELLCONSUMPTIONUPD	Rate	Must be greater than or equal to 0 and a maximum size of 999.99999999 (3v8). Note: Rate is not required if the Calculation Basis is INPVOL.
WELLCONSUMPTIONUPD	Usage Type	Used to indicate how the calculated factor volume is to be used. One of the following options must be entered. Options include FLAR (Flared) FUEL (Fuel) VENT (Vented) GATH (Gathered)
WELLCONSUMPTIONUPD	Adjust Production	Used to indicate whether to adjust Gas Production by calculated factor volume. One of the following options must be entered; a blank indicates Not Applicable. Options include: Y (Both Well and Battery Production adjusted) N (Not adjusted) W (Well Production adjusted but not Battery) R (Receipt - Production not adjusted) blank (Not applicable)
WELLCONSUMPTIONUPD	Recalculate on Actuals	Used to indicate whether the factor should be re-calculated once actual volumes are available for the Calculation Basis. One of the following options must be entered; a blank indicates Not Applicable . Options include: Y (Recalculate using actuals) N (Calculate on estimates) blank (Not applicable)
WELLCONSUMPTIONUPD	Include in Proration	Used to indicate whether the calculated factor should be included in gas proration. One of the following options must be entered; a blank indicates Not Applicable. Options include: Y (Include in Proration) N (Do not include in Proration) BTY (Include or not based on Battery Production options) blank (Not applicable)

Sample Data for WELLCONSUMPTIONUPD

^{Production Date}	^Well	^{Label of the Factor}	^{Calculation Basis}	^Rate	^{Usage Type}	^{Adjust Production}	^{Recalculate on Actuals}	^{Include in Proration}

^{Production Date}	^Well	^{Label of the Factor}	^{Calculation Basis}	^Rate	^{Usage Type}	^{Adjust Production}	^{Recalculate on Actuals}	^{Include in Proration}
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^FUEL12	^INPVOL	⁰	^FUEL	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^FUEL11	^HRSPRD	⁸	^FUEL	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^FLARE1	^OILPRD	⁵	^FLAR	^N	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^FLARE2	^GASPRD	⁶	^FLAR	^N	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^FLARE3	^MINPRD	⁷	^FLAR	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^VENT21	^GIS	¹⁰	^VENT	^Y	^N	^Y
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^VENT22	^STV	¹¹	^VENT	^Y	^Y	^Y
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^GATH99	^GOR	^0.22	^GATH	^Y	^N	^N
²⁰⁰⁸⁰⁴	^AKEIMPW01W03	^GATH99	^GOR	^0.11	^GATH	^Y	^N	^N

Well Production After Importing - WELLCONSUMPTIONUPD

WELLMASTERCREATION

Template for WELLMASTERCREATION

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLMASTERCREATION	Production Date	Format YYYYMM.
WELLMASTERCREATION	Well ID	Well ID Maximum 16 characters.
WELLMASTERCREATION	Province	Province Options include: AB (Alberta) BC (British Columbia) MB (Manitoba) ON (Ontario) SK (Saskatchewan)
WELLMASTERCREATION	Name	The official name of the well. Maximum 30 characters.
WELLMASTERCREATION	Formatted Location	Well location. The Format depends on survey system selected. (i.e., 100/01-09-025-04w4/00 or 203-A-013-K-093P01-3).
WELLMASTERCREATION	Fluid Type	Fluid type Options include: OIL (Oil) GAS (Gas) WATR (Water) EFFL (Effluent)
WELLMASTERCREATION	Heavy Oil	Heavy oil indicator Options include: N (Non-Heavy Oil) Y (Heavy Oil) S (SW Saskatchewan Heavy)
WELLMASTERCREATION	Water Type	Water type Options include: H2O (Water) FSHWTR (Fresh Water) BRKWTR (Brackish Water)
WELLMASTERCREATION	Measurement Type	Measurement type Options include: MEAS (Measured) TEST (Test-to-Test)
WELLMASTERCREATION	Well Depth	Must be greater than or equal to 0 and maximum size of 9999.9 (4v1).
WELLMASTERCREATION	Field Code	Provincial Field Code Maximum 12 characters.
WELLMASTERCREATION	Pool Code	Provincial Pool Code Maximum 12 characters.
WELLMASTERCREATION	Field/Pool Code	Provincial Field/Pool Code Ontario Wells only. Maximum 16 characters.
WELLMASTERCREATION	Government License Number	Provincial License Number Code Ontario Wells only. Maximum 6 digits.
WELLMASTERCREATION	Cost Centre	Cost Centre Maximum 16 characters.
WELLMASTERCREATION	PA Responsible	PA Responsible Must be a valid Qbyte Metrix user.
WELLMASTERCREATION	User Defined #1	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERCREATION	User Defined #2	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERCREATION	Report Liquid as Condensate	Options include: Y (Yes) N (No)
WELLMASTERCREATION	Recombined Liquid and Gas	Options include: Y (Yes) N (No)
WELLMASTERCREATION	Report Zero Production	Options include: Y (Yes) N (No)
WELLMASTERCREATION	Partner Operated Petrinex ID	Override Petrinex Id for Partner Operated Wells. Maximum 30 characters.
WELLMASTERCREATION	Manitoba Well Type	Manitoba well type Options include: blank D (Dummy Tract) N (Non-Heavy Oil Well) Z (Horizontal)
WELLMASTERCREATION	Production Status	Production status Options include: ON (On Production) OFF (Off Production)
WELLMASTERCREATION	Battery	Options include: blank Unique identifier for the battery the well is attached to.
WELLMASTERCREATION	Note	Maximum 4000 characters

Sample Data for WELLMASTERCREATION Template

^{Production Date}	^{Well ID}	^Province	^Name	^{Formatted Location}	^{Fluid Type}	^{Heavy Oil}	^{Water Type}	^{Measurement Type}	^{Well Depth}	^{Field Code}	^{Pool Code}	^{Field/Pool Code}	^{Government License Number}	^{Cost Centre}	^{PA Responsible}	^{User Defined #1}	^{User Defined #2}	^{Report Liquid as Condensate}	^{Recombined Liquid and Gas}	^{Report Zero Production}	^{Partner Operated Petrinex ID}	^{Manitoba Well Type}	^{Production Status}	^Battery	^Note

^{Production Date}	^{Well ID}	^Province	^Name	^{Formatted Location}	^{Fluid Type}	^{Heavy Oil}	^{Water Type}	^{Measurement Type}	^{Well Depth}	^{Field Code}	^{Pool Code}	^{Field/Pool Code}	^{Government License Number}	^{PA Responsible}	^{User Defined #1}	^{User Defined #2}	^{Report Liquid as Condensate}	^{Recombined Liquid and Gas}	^{Report Zero Production}	^{Partner Operated Petrinex ID}	^{Manitoba Well Type}	^{Production Status}	^Battery
2001406	AKEABWELL01	AB	AB Template Well 1	101/05-10-013-06w4/0	EFFL	N	H2O	TEST	7200					axe0623	CODE1	CODE2	Y	N	Y	AB WI 101051001706W400		ON	TEMPAB1
201406	AKEABWELL02	AB	AB Template Well 2	101/05-10-014-06w4/0	GAS	Y	H2O	TEST	5900					axe0623			N	Y	Y	AB WI 101051001806W400		ON	TEMPAB2
201406	AKENCWELL01	BC	BC Template Well 1	201-A-006-A-006A02-5	GAS	N	H2O	TEST						axe0623			N	Y	Y	BC WI 201A015A006A025		OFF
201406	AKEBCWELL02	BC	BC Template Well 2	201-A-007-B-006A02	WATR	N	H2O	MEAS	7900					axe0623			N	Y	Y	BC WI 201A016B006A025		ON	TEMPBC2
201406	AKESKWELL01	SK	SK Template Well 1	100/05-11-015-06w3/0	OIL	Y	H2O	TEST	8000					axe0623			N	Y	Y	SK WI 100051101806W300		ON	TEMPSK1
201406	AKESKWELL02	SK	SK Template Well 2	100/05-11-016-06w3/0	OIL	S	H2O	MEAS						axe0623			N	Y	Y	SK WI 100051101906W300		ON	TEMPSK2
201406	AKEMBWELL01	MB	MB Template Well 1	100/06-12-017-01w1/1	OIL	N	H2O	TEST	9600	71245	8999			axe0623			Y	N	Y		N	ON	TEMPMB1
201406	AKEMBWELL02	MB	MB Template Well 2	100/06-12-018-01w1/1	GAS	N	H2O	MEAS	9300	71246	8999			axe0623			N	Y	Y		Z	ON	TEMPMB2
201406	AKEONWELL01	ON	ON Template Well 1	3BC-2-493-45878	OIL	Y	H2O	TEST	5500			COMBO1	328474	axe0623			N	N	Y	ON WI HG100412341		ON	TEMPON2
201406	AKEONWELL02	ON	ON Template Well 2	4493-7-49	GAS	N	H2O	MEAS	9999.1			COMBO2	328473	axe0623	CODE3	CODE4	N	N	Y	ON WI 005412		ON	TEMPON2

WELLMASTERGENERALUPD

Template for WELLMASTERGENERALUPD

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLMASTERGENERALUPD	Production Date	Format YYYYMM.
WELLMASTERGENERALUPD	Well	Unique identifier for a well.
WELLMASTERGENERALUPD	Formatted Location	Well Location. The Format depends on the Survey System selected. (i.e., 100/01-09-025-04w4/00 or 203-A-013-K-093P01-3).
WELLMASTERGENERALUPD	Name	The official name of the well. Maximum 30 characters.
WELLMASTERGENERALUPD	User-Defined #1	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERGENERALUPD	User-Defined #2	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERGENERALUPD	Field Code	Provincial Field Code Maximum 12 characters.
WELLMASTERGENERALUPD	Pool Code	Provincial Pool Code Maximum 12 characters.
WELLMASTERGENERALUPD	Well Depth	Must be greater than or equal to 0. Maximum size is 9999.9 (4v1).
WELLMASTERGENERALUPD	Cost Centre	Cost Centre Maximum 16 characters.
WELLMASTERGENERALUPD	Partner Operated Petrinex Id	Override Petrinex Id for Partner Operated Wells Maximum 30 characters.

Sample Data for WELLMASTERGENERALUPD Template

^{Production Date}	^Well	^{Formatted Location}	^Name	^{User Defined #1}	^{User Defined #2}	^{Field Code}	^{Pool Code}	^{Well Depth}	^{Cost Centre}	^{Part.Op. Petrinex ID}

^{Production Date}	^Well	^{Formatted Location}	^Name	^{User Defined #1}	^{User Defined #2}	^{Field Code}	^{Pool Code}	^{Well Depth}	^{Cost Centre}	^{Part.Op. Petrinex ID}
201405	AKEIMPW01W01	!	Changing to 888	Code 888	Code 887	Field 8	!	8888.7	MYCOSTCENTRE888	AB WI 888
201405	AKEIMPW01W02	!	!	Code 777	Code 778	Field 7	777	7777.8	MyCOSTCENTRE777	!

WELLMASTERGENERALUPDNORESET

Template for WELLMASTERGENERALUPDNORESET

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLMASTERGENERALUPDNORESET	Production Date	Format YYYYMM.
WELLMASTERGENERALUPDNORESET	Well	Unique identifier for a well.
WELLMASTERGENERALUPDNORESET	Formatted Location	Well Location The Format depends on the Survey System selected. (i.e., 100/01-09-025-04w4/00 or 203-A-013-K-093P01-3).
WELLMASTERGENERALUPDNORESET	Name	The official Name of the well. Maximum 30 characters.
WELLMASTERGENERALUPDNORESET	User-Defined #1	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERGENERALUPDNORESET	User-Defined #2	Generic user-defined field available to capture miscellaneous data. Maximum 16 characters.
WELLMASTERGENERALUPDNORESET	Field Code	Provincial Field Code Maximum 12 characters.
WELLMASTERGENERALUPDNORESET	Pool Code	Provincial Pool Code Maximum 12 characters.
WELLMASTERGENERALUPDNORESET	Well Depth	Must be greater than or equal to 0. Maximum size is 9999.9 (4v1).
WELLMASTERGENERALUPDNORESET	Cost Centre	Cost Centre Maximum 16 characters.
WELLMASTERGENERALUPDNORESET	Partner Operated Petrinex Id	Override Petrinex Id for Partner Operated Wells Maximum 30 characters.

Sample Data for WELLMASTERGENERALUPDNORESET Template

^{Production Date}	^Well	^{Formatted Location}	^Name	^{User Defined #1}	^{User Defined #2}	^{Field Code}	^{Pool Code}	^{Well Depth}	^{Cost Centre}	^{Part.Op. Petrinex ID}

^{Production Date}	^Well	^{Formatted Location}	^Name	^{User Defined #1}	^{User Defined #2}	^{Field Code}	^{Pool Code}	^{Well Depth}	^{Cost Centre}	^{Part.Op. Petrinex ID}
201405	AKEIMPW01W01	!	Changing to 888	Code 888	Code 887	Field 8	!	8888.7	MYCOSTCENTRE888	AB WI 888
201405	AKEIMPW01W02	!	!	Code 777	Code 778	Field 7	777	7777.8	MyCOSTCENTRE777	!

WELLMASTERUWIUPDNORESET

Template for WELLMASTERUWIUPDNORESET

Template ID	Column Header	Description

Template ID

Column Header

Description

WELLMASTERGENERALUPDNORESET

Production Date

Format YYYYMM.

WELLMASTERGENERALUPDNORESET

Well

Unique identifier for a well.

WELLMASTERGENERALUPDNORESET

Formatted Location

Well Location

The Format depends on Survey System selected (i.e., 100/01-09-025-04w4/00 or 203-A-013-K-093P01-3).

Sample Data for WELLMASTERUWIUPDNORESET Template

By Registry ID

Production Date	Well	Formatted Location

Production Date	Well	Formatted Location
200804	AB WI 0105240136w4	101/05-24-014-06w4/0
200804	BC WI A1A1102	200-A-001-B-001102-0

By Qbyte Metrix Well ID:

Production Date	Well	Formatted Location

Production Date	Well	Formatted Location
201405	AKEABDESB01W01	101/05-24-014-06w4/0
201405	AKEABDESB01W02	101/05-24-013-06w4/0
201405	AKEABDESB01W03	101/05-24-012-06w4/0
201405	AKEABDESB01W04	101/05-24-011-06w4/0
201405	AKEABDESB01W05	101/05-24-016-06w4/0
201405	AKEABCONDB01W01	101/05-24-015-06w4/0

WELLPRODUCTIONFACTOR

Template for WELLPRODUCTIONFACTOR

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLPRODUCTIONFACTOR	Production Date	Format YYYYMM.
WELLPRODUCTIONFACTOR	Well	Unique identifier for a well.
WELLPRODUCTIONFACTOR	WGR Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	WGR Test Date	Format YYYYMMDD. Can be left blank.
WELLPRODUCTIONFACTOR	Oil Meter Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	EOR/HOR Rate	Saskatchewan Wells only. Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	Remaining Gas Option	Used to indicate how to handle any remaining gas at the Well. One of the following options must be entered. Options include: MDIF (Metering Difference) FLAR (Flare) FUEL (Fuel) VENT (Vented)
WELLPRODUCTIONFACTOR	All Oil To Be Recovered	Options include: Y (Yes) N (No)
WELLPRODUCTIONFACTOR	All Water To Be Recovered	Options include: Y (Yes) N (No)
WELLPRODUCTIONFACTOR	Oil Gas Ratio Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	Oil Gas Ratio Test Date	Format YYYYMMDD. Can be left blank.
WELLPRODUCTIONFACTOR	Gas Meter Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	Oil Gas Ratio Code	Can be left blank. Non-blank options include: WELL (Well-level) BTY (Battery-level)
WELLPRODUCTIONFACTOR	Water Gas Ratio Code	Can be left blank. Non-blank options include: WELL (Well-level) BTY (Battery-level)
WELLPRODUCTIONFACTOR	Water Meter Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLPRODUCTIONFACTOR	Battery GOR Exempt	Options include: Y (Yes) N (No)
WELLPRODUCTIONFACTOR	Crown Royalty Percent	Must be greater than or equal to 0 and less than or equal to 100. Maximum size is 999.99999999 (3v8). Sum of Crown Royalty Percent, Freehold Royalty Percent, Federal Percent, and Crown Acquired Percent must total 100. Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Freehold Royalty Percent	Must be greater than or equal to 0 and less than or equal to 100. Maximum size is 999.99999999 (3v8). Sum of Crown Royalty Percent, Freehold Royalty Percent, Federal Percent, and Crown Acquired Percent must total 100. Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Federal Percent	Must be greater than or equal to 0 and less than or equal to 100. Maximum size is 999.99999999 (3v8). Sum of Crown Royalty Percent, Freehold Royalty Percent, Federal Percent, and Crown Acquired Percent must total 100. Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Crown Acquired Percent	Saskatchewan Wells only. Must be greater than or equal to 0 and less than or equal to 100. Maximum size is 999.99999999 (3v8). Sum of Crown Royalty Percent, Freehold Royalty Percent, Federal Percent, and Crown Acquired Percent must total 100. Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Oil Density	Must be greater than or equal to 0. Only valid for wells in Alberta. Maximum size is 9999.99 (4v2). Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Crown Calculation Type	Alberta Wells only. Options include: B - Bypass E - Equivalent Use MRFC - MRF 2017 C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) MRFPC - MRF 2017 Post C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) N - ARF 2009 Normal T - ARF 2009 Transitional Available as of Release 24.4.
WELLPRODUCTIONFACTOR	Equivalent Use Sub Type	Alberta Wells only. MRFC - MRF 2017 C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) MRFPC - MRF 2017 Post C* (only valid for dates after Alberta Modernized Royalty Framework 2017 is active) N - ARF 2009 Normal T - ARF 2009 Transitional Only allowed when Crown Calculation Type is E (Equivalent Use). Available as of Release 24.4.

Sample Data for WELLPRODUCTIONFACTOR

^{Production Date}	^Well	^{WGR Factor}	^{WGR Test Date}	^{Oil Meter Factor}	^{EOR/HOR Rate}	^{Remaining Gas Option}	^{All Oil To Be Recovered}	^{All Water To Be Recovered}	^{Oil Gas Ratio Factor}	^{Oil Gas Ratio Test Date}	^{Gas Meter Factor}	^{Oil Gas Ratio Code}	^{Water Gas Ratio Code}	^{Water Meter Factor}	^{Battery GOR Exempt}	^{Crown Royalty Percent}	^{Freehold Royalty Percent}	^{Federal Percent}	^{Crown Acquired Percent}	^{Oil Density}	^{Crown Calculation Type}	^{Equivalent Use Sub Type}

^{Production Date}	^Well	^{WGR Factor}	^{WGR Test Date}	^{Oil Meter Factor}	^{EOR/HOR Rate}	^{Remaining Gas Option}	^{All Oil To Be Recovered}	^{All Water To Be Recovered}	^{Oil Gas Ratio Factor}	^{Oil Gas Ratio Test Date}	^{Gas Meter Factor}	^{Oil Gas Ratio Code}	^{Water Gas Ratio Code}	^{Water Meter Factor}	^{Battery GOR Exempt}	^{Crown Royalty Percent}	^{Freehold Royalty Percent}	^{Federal Percent}	^{Crown Acquired Percent}	^{Oil Density}	^{Crown Calculation Type}	^{Equivalent Use Sub Type}
201406	01/16-20-013-05w4/0	0.2	20080101	0.4578		VENT	Y	N							N	100	0	0	0	850.00	MRFC
201406	01/16-19-013-05w3/0	0.05	20080915	0.98	0.789	MDIF	N	N							N	80.5	19.5	0	0

Well Production After Importing - WELLPRODUCTIONFACTOR

WELLWGR

Template for WELLWGR

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLWGR	Production Date	Format YYYYMM.
WELLWGR	Well	Unique identifier for a well.
WELLWGR	WGR Factor	Must be greater than or equal to 0. Maximum size of 999.99999999 (3v8).
WELLWGR	WGR Test Date	Format YYYYMMDD. Can be left blank.

Sample Data for WELLWGR

Production Date	Well	WGR Factor	WGR Test Date

Production Date	Well	WGR Factor	WGR Test Date
201406	IMPW04	4.5	20081001
201406	IMPW05	1.2

Well Production After Importing - WELLWGR

WELLWGROGR

Template for WELLWGROGR

Template ID	Column Header	Description

Template ID	Column Header	Description
WELLWGROGR	Production Date	Format YYYYMM.
WELLWGROGR	Well	Unique identifier for a well.
WELLWGROGR	Water Gas Ratio Code	Can be left blank. Non-blank options include: WELL (Well-level) BTY (Battery-level)
WELLWGROGR	WGR Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLWGROGR	WGR Test Date	Format YYYYMMDD. Can be left blank.
WELLWGROGR	Oil Gas Ratio Code	Can be left blank. Non-blank options include: WELL (Well-level) BTY (Battery-level)
WELLWGROGR	Oil Gas Ratio Factor	Must be greater than or equal to 0. Maximum size is 999.99999999 (3v8).
WELLWGROGR	Oil Gas Ratio Test Date	Format YYYYMMDD. Can be left blank.

Sample Data for WELLWGROGR

^{Production Date}	^Well	^{Water Gas Ratio Type}	^{WGR Factor}	^{WGR Test Date}	^{Oil Gas Ratio Type}	^{Oil Gas Ratio Factor}	^{Oil Gas Ratio Test Date}

^{Production Date}	^Well	^{Water Gas Ratio Type}	^{WGR Factor}	^{WGR Test Date}	^{Oil Gas Ratio Type}	^{Oil Gas Ratio Factor}	^{Oil Gas Ratio Test Date}
201406	AKEIMPW01W03	WELL	4.5	20081001	WELL	5.5	20140101
201406	AKEIMPW01W01	WELL	1.2		BTY
201406	AKEIMPW01W02	BTY			BTY
201406	AKEIMPW01W04	BTY			WELL	1.5	20140104
201406	AKEIMPW01W05	!	!	!	!	5.4	!