Qbyte Metrix Interface

Inbound / Outbound Use

• Outbound

Directory Path 

The directory in which revenue interfaces that have been processed by Qbyte Metrix are stored.

Include Month in Path 

• No 

Province

• The province where the product is located.

• This value can be selected from a drop-down.

Product

• The product that is produced.

• This value can be selected from a drop-down.

General

Choose from SALE, CRWN, ROY, etc

Specific Type 

Choose from Crown Royalties, Non Residents Tax, Contract Fees, etc. Only a general type is required.

• This field is optional. 

Entry Required 

Indicates whether an entry is required during the revenue interface. Valid values are:

• Y - Yes

• N - No 

Debit Account

The description of the debit account that will be used for this entry type. 

Credit Account 

The description of the credit account that will be used for this entry type. 

Taken in Kind 

Indicates whether the entry definition is for Taken In Kind sales. Valid values are:

• Y - Yes

• N - No 

Vendor

Used if entries from a specific vendor require a specific debit and credit account, the vendor ID is entered. WIO/Vendor Exceptions entries will be required if this field is populated.

• This field is optional.

Working Interest Owner

Used if entries from a specific working interest owner require a specific debit and credit account, the working interest owner is entered. WIO/Vendor Exceptions entries will be required for this Working Interest Owner. 

• This field is optional.

Sub-Entry Key 

Used to book an entry differently from similar screens for specific properties. (e.g. gas sales for a property is booked to DR Accts Rec and CS Gas Sales, but for a specific property the debit entry is DR Gas Mktg).

Note: This field must be used in conjunction with the Sub Entry field on the Journal Voucher Definition Master.

Sub-Entry Code 

Used in conjunction with the Sub-Entry Key from a previous entry definition that is identical. When these are used together, the created entry is repeated, and each entry can be booked to different debit and credit accounts.

Account Name 

The description of the account. 

GL Account Number  

The net account from Qbyte Financial. During the revenue interface, the appropriate gross account will be found for this entry.

Note: If entering a major account with four characters, enter the account without spaces. If entering a major account with three characters, enter the account with a space.

Cost Centre Required 

Indicates whether the account requires a cost centre. Valid values include:

• Yes

• No

• Income - used for facility charge income accounts.

• O - Override - a valid cost centre must be entered.

Volume Required

Indicates whether the account requires a volume. Valid values include:

• Yes

• No 

Booking Code

The booking code of the account. Valid values include:

• Blank - No distribution required - Used for payable and receivable accounts. 

• B - Billable - Used for the partner's share of revenue or expenses on joint interest billing.

• K - Taken in Kind

• D - Distributed - Used for entries that will be distributed in Qbyte Financial.

• N - Net - Used for entries for partner share of revenue or expenses.

The no bill flag is B on all sales, royalties and expense transactions that are distributed to partners.

Vendor Type

The vendor type of the account. Valid values include:

• V ND - Purchaser or Royalty Owner.

• WIO - Working Interest Owner.

• OVR - Override Vendor used for all transactions. (e.g. Receiver General would be used for GST and NRWT).

Source Vendor Type

The source vendor type of the account. Valid values include: 

• V - Vendor will enter the purchaser or royalty owner as the source vendor on the financial transaction.

• W - Working Interest Owner

• O - Override Vendor used for all transactions.

Detail Required

Indicates whether additional detail is used. Additional detail is required in the following situations:

• Sales and royalty accounts that have reference formats assigned for source invoice links. Distribution lines may be incorrectly assigned to a source invoice where there is more than one royalty to the same Royalty Owner, or sales for an owner are allocated to more than one purchaser if the Detail Required flag is not set to Yes.

• Unit sales, crown, GORR and freehold royalties calculated at the tract level and assigned to a unit cost centre.

• More than one royalty to the same royalty owner on a well / cost centre where the same partner participates in both with different WI%.

• Facility charges with different expense types assigned to the same account where the same partner participates in both with different WI%.

• Different wells assigned to the same cost centre where the same partner participates in both with different WI%.

Additional detail is not required in the following situations:

• Accounts payable accounts.

• Accounts receivable accounts.

• Accounts where gross is not required. 

Calculate Gross Values

Indicates whether gross values are calculated. Valid values are:

• Yes - Used for revenue and royalty accounts. All entries booked to the same account code and order number are summarized to obtain gross values. The journal voucher report will have an asterisk line with the calculated gross when this option is selected.

• No - Used for accounts payable accounts, accounts receivable accounts, and accounts where gross is not required.

GST Code

Enter 99. 

Sort Order

Used to sort accounts on the Voucher report.

This field will default to 00.  

Comment Type

The description displayed on the journal voucher for the account definition. Valid values are:

• ACTNAM - Account Name

• ENTID - Entity ID

• ENTNAM - Entity Name

• SRCNAM - Source Vendor Name

• VNDNAM - Vendor Name

• NONE - No comment

Break on Tract Entity

Valid values are:

• Yes - Tract entity entries are detailed on the voucher.

• No - Tract entity entries are summarized at the unit for the voucher. 

Reference Format

Used to create the invoice number. Valid values are:

• CTLG - Control Group (MMMYYGGGGGGGGGGGGGGGG)

• MREF - Month Reference MMMCCC

• CINV - Crown Invoice Number

• DATE - Month Year MMMYY

• VCHR - Voucher Description

• DREF - Date Reference MMMCCCYYYY

Reference Number

The reference number that is used in the reference format for payable and receivable accounts. 

Entity Type

The entity type of the voucher. Valid values are:

• Battery

• Unit

• Control Group 

Entity ID

The battery ID, unit ID or control group to be included in the voucher. 

Voucher Required

Indicates whether the property should be booked. 

Voucher Number 

The voucher number assigned for the voucher definition. 

Voucher Description 

The description of the voucher. 

Sub Entry Code 

The sub entry code works in conjunction with the Sub Entry field on the Entry Definitions tab. Together they allow entries for selected properties to be booked differently.

Type

The type of the WIO/Vendor exception. Valid values include:

• Owner - Partner in a well or facility.

• Vendor - Purchaser or Royalty Owner. 

Owner ID

The ID of the owner or vendor in the WIO/Vendor exception. 

Owner Name 

The name of the owner or vendor in the WIO/Vendor exception.

LDR_PATH

The directory in which the revenue interface control file is stored.

SHL_PATH 

The directory in which the revenue interface shell script is stored.

TRUNCATE_ALLOWED 

Indicates whether the temporary tables which store revenue interface data are truncated at the beginning of each revenue interface process. The temporary tables are:

• PA_INTERFACE_DATA

• PA_INVOICE_XREFS

• PA_VOUCHER_XREFS 

Valid values are:

• Y - The temporary tables will be truncated at the beginning of the Revenue Interface process

• N - The temporary tables are deleted at the beginning of the Revenue Interface process. 

BATCH_EDIT_TRANS_TOLERANCE

The maximum tolerance allowed for balancing a revenue interface voucher.

REVENUE_HISTORY_DATA_PATH

The directory in which revenue interfaces that have been processed by Qbyte Financial are stored.

Once the Revenue Interface is processed, the report ID will be appended to the file name, and the CSV file created by Qbyte Metrix will be moved to this directory.

REVENUE_INTERFACE_DATA_PATH

The directory in which revenue interfaces that have been processed by Qbyte Metrix are stored.

REV_INT_IGNORE_CLIENT_ID_X

The business associate IDs (e.g. Purchasers, Royalty Owners, Partners) that will be ignored by the Revenue Interface process. Each additional business associate entered will have a sequential number entered in X (e.g. REV_INT_IGNORE_CLIENT_ID_2)

Business associate 999999 is typically entered here, as it is used for Taken in Kind revenue transactions and royalty gross up transactions

REV_INT_INVOICE_DATE_SOURCE

The invoice date used in Qbyte Financial.

Information on how the invoice date is generated can be found here.

REV_INT_NOBILL_INDICATOR_CODE 

Codes defined will create intercompany transactions where the business associate is an organization. Typically all billable transactions to insider organizations will have a no bill indicator of B entered. Each additional no bill indicator entered will have a sequential number entered in X (e.g. REV_INT_NOBILL_INDICATOR_CODE2)

REV_INT_PAYABLE_INVC_DAY 

The day of the payable invoices created during the interface process. (e.g. 15 would represent the 15th of the month).

REV_INT_RECEIVABLE_INVC_DAY 

The day of the receivable invoices created during the interface process. (e.g. 25 would represent the 25th of the month).

Production Date

The production date of the financial interface.

This value will default to the current production month.

Entity Type

The type of entity to be processed. Valid values are:

• Control Group

• Financial Group 

Entity

The name of the control group or financial group of the financial interface.

Production Date

The production date of the financial interface.

This value will default to the current production month.

Entity Type

The type of entity to be processed. Valid values are:

• Control Group

• Financial Group 

Entity

The name of the control group or financial group of the financial interface.

ProductionDate

The production date of the financial interface.

This value will default to the current production month.

Entity Type

This field will default to Region.

Entity

The region of the financial interface.

This field will default to the region assigned to the Master Owner.

Include Amendments 

Indicates whether to include amendments in the financial interface. Valid values are: 

• Yes - All amendments available for the financial interface for the region selected will be included.

• No - Only transactions for the production date entered will be included.

Production Date

The production date of the financial interface.

This value will default to the current production month.

Entity Type

This field will default to Region.

Entity

The region of the financial interface

This field will default to the region assigned to the Master Owner.

Include Amendments 

Indicates whether to include amendments in the financial interface. Valid values are: 

• Yes - All amendments available for the financial interface for the region selected will be included.

• No - Only transactions for the production date entered will be included.

Accounting Date

The accounting date of the financial interface.

• This field will default to the current month.

Transactions 

Indicates which transactions to display. Valid values are:

• All Transactions

• Freehold and Override Royalties Only

• All Except Freehold and Override Royalties 

Separate Royalty Reports by Owners

Valid values are:

• Yes

• No 

Include Net Zero Records

Valid values are:

• Yes

• No 

Financial Interface IDs

The name of the financial interface. 

Organization ID

The organization that the revenue interface will be processed in.

Accounting Period End Date 

The accounting period that the revenue interface will be processed in. 

Metrix Batch Number 

The batch number of the revenue interface.

Load Upload Data Files (Y/N) 

Indicates whether the file generated by Qbyte Metrix will be processed. Enter Y to upload the revenue interface file.

PA Filename 

The name of the revenue interface file generated by Qbyte Metrix. 

Print Detail Report (Y/N)

Indicates whether the Production Accounting Interface Audit report will be run during the process.

Batch ID

The report ID of the report that processed the revenue interface. 

Voucher Number

The number of the voucher. 

Voucher Type Code

The type of the voucher. 

Organization ID

The organization that the revenue interface will be processed in.

Accounting Period End Date 

The accounting period that the revenue interface will be processed in. 

Override User ID 

The user that processed the revenue interface. 

Source Module ID 

The module ID to process.