Qbyte Exchange for Third Party

File Number*

File Status*

Code must exist in Validation Table.

Note: Generally, terminating/inactivating files should be done in the Qbyte CS Land application. IF the File Status is changed in Qbyte Exchange, remember to also update the Status Date.

Status Date*

Value must be in a yyyy-MM-dd format.

Lease Number

Reason For

Document Type*

Code must exist in Validation Table.

Document Date*

Value must be in a yyyy-MM-dd format.

Admin Company*

Code must exist in Validation Table.

Effective Date*

Value must be in a yyyy-MM-dd format.

Division*

Code must exist in Validation Table.

Lease Term

Code must exist in Validation Table.

Term Period

Expiry Date

Value must be in a yyyy-MM-dd format.

Area

Province

Not a column in the spreadsheet as the value is automatically populated during the save behind the scenes

Grantor

BA Code entered must exist in Business Associates.

Unit of Measure

Grantee

BA Code entered must exist in Business Associates.

Let / Take

Not a column in the spreadsheet as the value is automatically populated during the save behind the scenes

Prev Doc Number

Cost Centre

Cost Centre Code entered must exist in Cost Centres.

File Number*

When inserting new records, the File Number specified must already exist.

Area*

When inserting new Areas, the Area code must exist in the Area Validation Table. The applicable Province code will default automatically in the database when the Area code is saved.  No te:   After the initial Insert > Save, If still in Insert mode and the Area is changed, then a Save is performed, a second Area record will be added, leaving also the initial Area record. If any of the Areas are no longer required, they must be deleted in the application.

Updating Areas in Update mode is currently not allowed and will display an error when attempting a Validate or Save.

File Number*

Land Description*

File Number*

When inserting new Name Xref records, the File Number specified must already exist.  The File Number cannot be updated.

Name Type*

When inserting, the Code  must  exist in the Name Xref Validation Table.  The Name Type cannot be updated.

Name Cross Reference*

When inserting, the BA Code  entered  must  exist in Business Associates.  

When updating, the Name Cross Reference cannot be updated - a validation error will be given.  If required, change the Name Cross Reference BA Code in the Qbyte CS Land application.

Comments

Free-format up to 40 characters.  The Comment can be updated if required on existing rows.

File Number*

When inserting new records, the File Number specified must already exist.

TPA Status*

Code must exist in TPA Status Validation Table.

Rate Per Unit*

Rate per Unit must be entered OR the Flat rate, not both. If Rate per Unit is not applicable, 0 must be entered.

Flat Rate*

Flat Rate must be entered OR the Rate Per Unit, not both. If Flat Rate is not applicable, 0 must be entered.

Rate Frequency*

Must be A (Annual), SA (Semi-Annual), M (Monthly) or Q (Quarterly)

File Number*

When inserting new records, the File Number specified must already exist.

Well Occurrence

When inserting new records, do not populate this column. This is a system-generated value and it will be populated during Save.

When updating existing records, do not change this column.

User Well/Loc*

Valid values are W (Well), L (Location), or N (N/A).

UW/Loc Desc*

Enter UWI or Location.

If the User Well / Loc is a Well, enter the 16-character UWI. For example, 100132902512W400. 

If the User Well / Loc is a Location, enter the 12-character number in either DLS (including M for meridian) or NTS format, without spaces or slashes. For example, 110800108W4M. 

User Well Status*

Code must exist in the File Status User Well Validation Table...

User Well Status Date*

Value  must  be in a  yyyy-MM-dd  format. Cell format must be Text.

Well Licence

Free-format up to 15 characters.

Gen Desc

Free-format up to 60 characters.

Addendum Num

Free-format up to 20 characters.

Length

Enter a positive number with or with out decimals (Max 9999999)        

Cost Centre

Cost Centre must be exist in the Cost Centre master and must be Active.

Exclude from Utility*

Enter Y or N

Producing TPA Status

Enter only if your company is utilizing the Third Party Update Utility. 

Comment

Free-format up to 60 characters.

File Number*

When inserting new records, the File Number specified must already exist.  The File Number will be repeated on multiple rows if >1 Fee is applicable.

Well UWI*

When Inserting new records, enter the Grantee UWI.

When updating existing records, do not change this column.

Fee ID

When inserting new records, do not populate this column. This is a system-generated value and it will be populated during Save.

When updating existing records, do not change this column.

Note: this field is not visible in Qbyte CS Land.

Fee Type

Enter Fee type.  Validation table (TPA One Time Fee)

Rate

Enter dollar (Min 0.00 - Max 9999999.99).  If using Amount, enter 0 for Rate.

Amount

Enter Amount. (Min 0.00 - Max 9999999.99).  If using Rate, leave Amount blank, it will be calculated during Save.

Billing Date

Value must be in a  yyyy-MM-dd  format. Cell format must be Text.

File Number*

When inserting new records, the File Number specified must already exist.  The File Number will be repeated on multiple rows if >1 Fee is applicable.

Well UWI*

When Inserting new records, enter the Grantee UWI.

When updating existing records, do not change this column.

Fee ID

When inserting new records, do not populate this column. This is a system-generated value and it will be populated during Save.

When updating existing records, do not change this column.

Note: this field is not visible in Qbyte CS Land.

TPA Status*

Enter applicable TPA Status (E.g. TRUCKED, PIPELINE).  Validation table (TPA Status)

Start Date*

Date must be in a yyyy-MM-dd format.  Cell format must be Text.

End Date

When Inserting new records, leave blank.

When updating existing records, Date must be in a yyyy-MM-dd format.  Cell format must be Text.

File Number*

When inserting new records, the File Number specified must already exist.  The File Number will be repeated on multiple rows if >1 Distribution is applicable.

Well/Location*

When Inserting new records, enter the Grantee UWI.

When updating existing records, do not change this column.

Dist Occurrence

When Inserting new records, do not populate this column. This is a system-generated value, and it will be populated during Save.

When updating existing records, do not change this column.

Note: this field is not visible in Qbyte CS Land.

Grantor Well

If applicable, enter UWI that exists in Qbyte CS Land.  This Well can be updated.

Description

Free-format up to 40 characters.

Revenue Cost Centre*

Cost Centre must be entered, must exist in the Cost Centre master and must be Active.

Allocation %*

Enter percentage (Min 0.00 - Max 100.00000000)

Note: if Allocation is split amongst multiple Grantor Wells, the allocation percentage must equal 100%.

File Number*

When inserting new records, the File Number specified must already exist.

Occurrence

When Inserting new records, do not populate this column. This is a system-generated value, and it will be populated during Save.

Note : The  Occurrence (Occ) Number can be renumbered at any time in the Qbyte CS Land application (if required) to change the display order of the rows.

Delete

This value is applicable on the spreadsheet only and is not stored in the table. 

When inserting a new Remarks record, enter a value of "N".  If blank, "N" is assumed.

When updating, retrieve existing data via Get Data, the Delete value will default to "N".  Change the value to "Y" to indicate that you wish to delete the specific row.  If blank, "N" is assumed. 

• Validate will display a 'Conflict' error along with message 'Row will be deleted - are you sure?'.  Simply change the Delete column back to "N", if you change your mind.  

• Upon Save, the Remarks with a delete flag of "Y" are deleted from the database and the remaining remarks occurrence number will be renumbered.  However, the just deleted row will still appear temporarily on the spreadsheet with status = 'Deleted' as a visual indication that the row has been deleted and the occurrence renumber will not be apparent.  A subsequent Get Data will omit the deleted rows and display the reordered remarks occurrence. 

Remark Type*

Code must exist in Validation Table.

Remark Date*

Value must be in a yyyy-MM-dd format.

Remark*

Free-format up to 1910 characters.

File Number*

When inserting new records, the File Number specified must already exist.

Note: This field cannot be updated after Insert → Save is completed. If relationship is no longer required, it must be deleted in the application. When using 'get data' to retrieve existing data, you may want to sort by File Number to ensure all rows for each File Number appear grouped together.

Related Subsystem*

When inserting new records, enter the module for which the related files is part of.

Acceptable codes:  C (any Contract category), M (Mineral), S (any Surface category).  Qbyte Exchange has the same Related Files exceptions as Qbyte CS Land.

Note : This field cannot be updated after Insert → Save is completed. Well relationships for Third Party Agreements can not be inserted or updated in Exchange.

Related File Number*

When inserting new records, enter the file number for which you are relating to the file number specified in column A.

Note: This field cannot be updated after Insert → Save is completed.

Related File Sub

When inserting new records, enter a sub, if applicable to relate files at the sub level.

Note: This field cannot be updated after Insert → Save is completed.

Relationship

If entered, the code must exist in Relationship Validation Table.

Comment

Free-format up to 120 characters.

File Number*

When inserting new Obligation records, the File Number specified must already exist.  

When updating an existing Obligation, the File Number cannot be changed.

Occurrence*

When inserting a new row do not populate this column, this is a system-generated value, and it will be populated during Save.

Note: The  Occurrence (Occ) Number can be renumbered at any time in the Qbyte CS Land application (if required) to change the display order of the rows.

Delete

This value is applicable on the spreadsheet only and is not stored in the table. 

When inserting a new record, enter a value of "N".  If blank, "N" is assumed.

When updating, retrieve existing data via Get Data, the Delete value will default to "N".  Change the value to "Y" to indicate that you wish to delete the specific row.  If blank, "N" is assumed. 

• Validate will display a 'Conflict' error along with message 'Row will be deleted - are you sure?'.  Simply change the Delete column back to "N", if you change your mind.  

• Upon Save, the rows with a delete flag of "Y" are deleted from the database and the remaining rows occurrence number will be renumbered.  However, the just deleted row will still appear temporarily on the spreadsheet with status = 'Deleted' as a visual indication that the row has been deleted and the occurrence renumber will not be apparent.  A subsequent Get Data will omit the deleted rows and display the reordered rows occurrence. 

Obligation Type*

Code must exist in Validation Table – Obligation Surface.

Date*

Date must be in a yyyy-MM-dd format.  Cell format must be Text.

Frequency*

Value must be O, A, SA, Q, M, 2Y, 3Y, 4Y, 5Y, 10, 20, 21 or 25.

Company*

Value must be Y or N.

Satisfied*

Value must be Y or N.

Comp Date

Date must be in a yyyy-MM-dd format.  Cell format must be Text.

Party Resp*

Code must exist in Validation Table – Obligation Responsibility.

Description*

Free-format up to 1910 characters.

File Number*

When inserting a new Client Defined record, the File Number specified must already exist.  Any one File Number may have multiple rows in the spreadsheet if there are more than 1 applicable Client Defined Labels/Values.  

When updating an existing Client Defined record, the File Number cannot be changed.

Label*

When inserting a new Client Defined record, the Label must be entered exactly as it appears in the Qbyte CS Land window (or as defined in Admin > Client Defined Fields update screen). 

When updating an existing Client Defined record, the Label cannot be changed.

Value*

The Value is required when inserting new rows and can also be updated after the initial save.  The cell is always defined as Text in the Qbyte Exchange spreadsheet regardless of Value entered. 

Values entered are validated accordingly per the field setup in Qbyte CS Land:

• Dates can be entered with or without a format.   For example, if a date format of 'yyyy-mm-dd' has been defined, the date must be entered as '2022-12-13'. If a date format was not defined, the date can be entered as '2022-12-13', and Qbyte Exchange will format the date to the default date format of 'Dec 13, 2022' - just like it is in the application.

• Validation codes entered must exist in the applicable validation code table.

• String values entered must not exceed 1910 alpha/numeric characters.  Alt + Enter can be used to break the text string to a new line.

• Percentage can be entered with or without a format.  

• Number can be entered with or without a format.  For number fields setup with masks:

  • The 0 (zero) character will allow a leading zero to be entered in Qbyte CS Land and all leading zeroes will be visible when the field is imported to Qbyte Exchange.  For example, with mask 000-000-00000, entered as 00-000-0001 in Qbyte CS Land, will display as 000-000-0001 in Qbyte Exchange.

  • The # character will allow a leading zero to be entered in Qbyte CS Land only if there is a non-numeric character like a dash (-) in the mask.  Leading zeroes are not displayed when the field is imported to Qbyte Exchange.  For example, with mask ###-###-####, entered 000-000-0001 in Qbyte CS Land will display as '- -1' in Qbyte Exchange.

Note:  If a Client Defined field was setup in Qbyte CS Land as being mandatory, then in Qbyte Exchange a value must be provided for that field if that Label exists in the spreadsheet.  However, if there is not a row for the Label in the spreadsheet, there is not validation to indicate it is missing.