Qbyte Exchange for Mineral Lease

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.  Cell format must be Text.

Lessor Type*

Code must exist in Validation Table...

Lease Number

Lease Type*

Code must exist in Validation Table.

Lease Date*

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

Admin Company*

Code must exist in Validation Table.

Effective Date*

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

Lease Payor*

BA Code entered must exist in Business Associates.

Lease Term*

Term Period*

Invoicing Company

BA Code entered must exist in Business Associates.

Expiry Date*

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

Rental Status

If entered, Code must exist in Validation Table.

Rental Period

Rental Dollar

Per Acre Hectare*

Value must be A or H. If A is entered, the Lease Gross Acre column must also be entered. If H is entered, the Lease Gross Hectare column must also be entered.

Total Lease Rental

Rental Date

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

Lease Gross Acre

Value must be entered if Per Acre Hectare = A. Upon Save, a calculation for Gross Hectare will be performed

Lease Gross Hectare

Value must be entered if Per Acre Hectare = H. Upon Save a calculation for Gross Acre will be performed

Surrender Days

Regist Interest

Min Tax Percent

Mineral Interest

If value not entered, 0 will be used as the default in the database.

Confid Land Ind*

Confidential Lands: must be Y for checked and N for not checked

Prev Doc Number

File Number*

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: 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.

Lessor*

BA Code entered must exist in Business Associates.

Lessor Amount*

Depository*

BA Code entered must exist in Business Associates.

Lessor Interest*

Withhold Tax

Bank Account

File Number*

Insert mode is not allowed on the Orig Acq tab and will display an error when attempting to Validate or Save.

Due to how/where the Orig Acq data is stored in the tables, the File Number will already exist. 

Acquired By*

Code must exist in Acquisition Types Validation Table.

Acquisition Date*

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

Cost Centre

Cost Centre must exist in the Cost Centre table.

Original Interest

Bonus Amount

Bonus Per A/H

Brokerage Fee

First Yr Rental

Other Cost

File Number*

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

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: 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.

Type*

Code must exist in Acquisition Types Validation Table.

Input Date*

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

Effective Date*

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

Division*

If System Table > AREADIV is Enabled, this column does not need to be entered, it will be populated by the Division defined in the Area table during Save..  

If System Table > AREADIV is not Enabled, Code must exist in Division Validation Table. 

Area *

Code must exist in Validation Table - Area.

Net Dollar Amount*

Enter dollar amount, if applicable, with or without a decimal. (Max 999,999,999.99).  If not applicable, enter 0.

UOM

When inserting new records, do not populate this column. This is a system-generated value that will be populated during the Save data to P2 step based on the UOM entered in the Per Hectare/Acre field on the Mineral Lease Base tab.  This value indicates whether columns J thru AA are Hectares (H) or Acres (A).

When updating existing records, do not change this column.

Prod Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprod Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Prod Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprod Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Prod Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprod Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Dev Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Undev Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Dev Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Undev Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Dev Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Undev Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Prov Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprov Gross

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Prov Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprov Net

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Prov Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Nprov Roy

Enter acreage value, if applicable, with or without a decimal. If UOM on Lease Base tab is Ha max value is 39,999,999.999 and if Ac max value is 99,999,999.999

Remarks

Free-format up to 1910 characters.  Note:  The system default in Qbyte CS Land is to place a period (.) in the Remarks data field.  If not removed in either Qbyte CS Land or Qbyte Exchange the period (.) will be saved to the database. 

Land Description

An example of a valid DLS Land Description is TWP 18 RGE 14 W4M LSD 15 SEC 12 or TWP 13 RGE 32 W1M S & NE 8

An example of a valid NTS Land Description is NTS 94-H-10 BLK D UNIT 12 13 22 23

Note: Any data in brackets ( ) is considered comments and not validated.

Rights Held

An example of a valid Rights Held is:

PNG TO BASE MANNVILLE
EXCL PNG IN BASAL_QUARTZ

Note: Any data in brackets ( ) is considered comments and not validated.

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*

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: 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*

Remark Date

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

Remark*

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.

File Number*

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

Occurrence

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

When updating existing Registration, this column can be used to change the occurrence order.

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.

Document Type*

Code  must  exist in Registration Types  Validation Table .

Document Date

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

Document Number*

Free-format up to 20 characters.

Withdrawal Date

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

District

Code  must  exist in District  Validation Table .

Register Number

Free-format up to 20 characters.

Comments

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 file is part of.

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

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

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 the 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 Mineral.

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 new records, the File Number specified must already exist.  

When updating an existing record, the File Number cannot be updated.

Rental Date*

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

When updating an existing record, the Rental Date cannot be updated.

Lessor*

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

When updating an existing record, the Lessor cannot be updated.

Depository*

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

When updating an existing record, the Depository cannot be updated.

Cheque Date*

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

When updating an existing records, the Cheque Date can be updated on the existing record.

Cheque Number*

When inserting new records, Free format up to 16 characters.

When updating an existing records, the Cheque Number cannot be updated.

Cheque Amount

Minimum = 0.01 and maximum = 9,999,999.99

WH Tax

Withholding Tax amount minimum = 0 and maximum = 9,999,999.99  Note: If left blank, it will be saved as 0.

Rental Amount

Minimum = 0 and maximum = 9,999,999.99  Note: If left blank, it will be saved as 0.

Comment

Free-format up to 100 characters. 

Delete

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

When inserting a new Rent Hist Manual 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 Rent Hist Manual records with a delete flag of "Y" are deleted from the database.  However, the just deleted records will still appear temporarily on the spreadsheet with status = 'Deleted' as a visual indication that the records have been deleted.  A subsequent Get Data will omit the deleted rows and display the remaining Rent Hist Manual records. 

COLUMN

HINTS & TIPS

Owner Company*

When updating an existing record, the File Number cannot be updated.

Select Date*

When updating an existing record, the Rental Date cannot be updated.

Rental Run Code

When updating an existing record, the File Number cannot be updated.

File Number*

When updating an existing record, the File Number cannot be updated.

Lessor*

When updating an existing record, the Lessor cannot be updated.

Depository*

When updating an existing record, the Depository cannot be updated.

Cheque Date*

When updating an existing record, the Cheque Date cannot be updated.

Cheque Number*

When updating an existing record, the Cheque Number cannot be updated.

Cheque Amount

When updating an existing record, the Cheque Amount cannot be updated.

WH Tax

When updating an existing record, the WH Tax cannot be updated.

Rental Amount

When updating an existing record, the Rental Amount cannot be updated.

Comment

Free format up to 100 characters.