File Number*

When inserting new files, this may be configured as a system-generated value.

Admin Company*

Code must exist in the Admin Company Validation Table .

Contract Name

Free-format up to 90 characters.

File Status*

Code must exist in the File Status Contract 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.

Contract Type*

Code must exist in the Contract Types Validation Table .

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

Revision Number

Free-format up to 6 characters.

Revision Date

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

Prev Doc Number

Free-format up to 2 0 characters.

Termination Date

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

Term

Code must exist in the Service Terms Validation Table . i.e. EVERGREEN

Term Notice

Code must exist in the Service Terms Notice Validation Table . i.e. 30D

Producer

BA Code  entered must exist in Business Associates.

Processor

BA Code  entered must exist in Business Associates.

Segregation*

Valid values are Y, N or X (Unknown).

Area*

Code must exist in the Area Validation Table.

Division

If AREADIV is Enabled, this column will be populated by the Division defined in the Area Validation Table .

File Number*

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

Occurrence

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

When updating existing Remarks, 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*

Code must exist in the Remarks Contract Validation Table .

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

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

Occurrence

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

When updating existing Amendments, 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 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 occurrence numbers 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 records. 

Amendment Type*

Code  must  exist in the Amendment Types  Validation Table.

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

Binding Date

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

Amendment *

Free-format up to  1910  characters.

File Number*

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

When updating existing records, do not change this column.

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.

Type*

Owner/Producer Type: enter W = Well, L = Location, N = N/A, F = Facilities, P = Pipelines

Location File Number

This is not displayed in Qbyte CS Land. 

Location File Number may be applicable if Owner/Producer Type (column C) is W, F, or P

When inserting new records:

• W, leave blank, the Well file number will automatically be populated (for display purposes) during the Save Data to P2 step.

• F or P and there is only one Facilities or Pipeline in the same location, leave blank, the file number will automatically be populated for display purposes in this column during the Save Data to P2 step.

• F or P and there is more than one Facilities or Pipeline in the same location, then the file number of the specific Pipeline or Facilities must be supplied.

When updating existing records, do not change this column.

Location/UWI*

When inserting a new record enter the Owner/Producer Location/UWI per the indicated Owner/Producer Type (column C):

• A Well 16-character UWI. For ex. 100040600107W400. Note: If Producer (on Base tab) is a Owner Company, then Well must exist in the Well module. 

• A Location, Facility or Pipeline 12-character number in either DLS (incl. M for meridian) or NTS format, without spaces or slashes. For ex. 110800108W4M.

• For N/A 16-characters free format.

When updating existing records, do not change this column.

Description

When inserting new records:

• If Owner/Producer Type (column C) is W, F, or P

  • And the setting (SYNCSRVLOC in the System Table) is enabled to automatically bring over the description, do not enter a value.  Description will be populated automatically during the Save Data to P2 step.  If a description is entered, it will be overwritten with the W, F or P description.

  • And the setting (SYNCSRVLOC in the System Table) is disabled to automatically bring over the description, enter the required value.  

• If Owner/Producer Type (column C) is N/A, or L enter a description free format up to 1910 characters.

When updating existing records:

• Do not change the description if Type = W, F, or P and the description was automatically populated.  The changed description will revert back to the W, F or P description.

• Update for Type = N/A or L as required.

Off Service Date

Display only field.  The Off Service Date functionality is only available in Qbyte CS Land.  Changes to this field, in either insert or update mode, will display an error message.

Cost Centre

Code entered must exist in Cost Centres master.

When inserting new records:

• If Owner/Producer Type (column C) is W, F, or P

  • And the setting (SYNCSRVLOC in the System Table) is enabled to automatically bring over the Cost Centre, do not enter a value.  Cost Centre will be populated automatically during the Save Data to P2 step.  If a Cost Centre is entered, it will be overwritten with the Well, Facilities or Pipelines Cost Centre.

  • And the setting (SYNCSRVLOC in the System Table) is disabled to automatically bring over the Cost Centre, enter the required value.  

• If Owner/Producer Type (column C) is N/A or L, enter a valid Cost Centre.

When updating existing records:

• Do not change the Cost Centre if Type = W, F, or P.  The changed Cost Centre will revert back to the W, F or P description.

• Update for Type = N/A or L as required.

Priority

Code must exist in Service Location Priority Validation Table.

File Number*

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

Loc Occurrence*

When inserting new records, the Occurrence of the Owner/Producer record is entered (from column B on the Srv Loc Producer tab).  This will indicate which Owner/Producer this Contractor/Processor row is associated to. 

When updating existing records, do not change this column.

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

Update History

When inserting new records, do not populate this column.  It is not applicable to new records.

When updating existing records, enter  Y (Yes), N (No) to indicate if History should be updated.  In Qbyte CS Land, this occurs as pop up question.  Note:  if the setting (SRVFEEHIST in the System Table) is disabled the history will never be saved even if the flag = Y. 

When using Get Data from P2 only the current records will be retrieved and the flag will be defaulted to Y.  Be sure to change the flag to N on any changed rows if you do not want history saved.

Effective Date*

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

Termination Date

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

Type *

Contractor/Processor Type: Valid values are F (Facility), L (Location), N (N/A), P (Pipeline) or W (Well).

Location File Number

This is not displayed in Qbyte CS Land. 

Location File Number may be applicable if Contractor/Processor Type (column G) is W, F, or P

When inserting new records:

• W, leave blank, the Well file number will automatically be populated (for display purposes) during the Save Data to P2 step.

• F or P and there is only one Facilities or Pipeline in the same location, leave blank, the file number will automatically be populated for display purposes in this column during the Save Data to P2 step.

• F or P and there is more than one Facilities or Pipeline in the same location, then the file number of the specific Pipeline or Facilities must be supplied.

When updating existing records, do not change this column.

Location/UWI*

When inserting new Contractor/Processor records enter:

• A Well 16-character UWI. For example 100040600107W400.  Note: If Producer (on Base tab) is a Owner Company, the Well must already exist in the Qbyte CS Land Wells module. 

• A Location, Facility or Pipeline 12-character number in either DLS (incl. M for meridian) or NTS format, without spaces or slashes. For ex. 110800108W4M.

• For N/A 16 characters free format.

When updating existing records, do not change this column.

Update Date

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

Description

When inserting new records:

• If Contractor/Processor Type (column G) is W, F, or P

  • And the setting (SYNCSRVLOC in the System Table) is enabled to automatically bring over the description, do not enter a value.  Description will be populated automatically during the Save Data to P2 step.  If a description is entered, it will be overwritten with the W, F or P description.

  • And the setting (SYNCSRVLOC in the System Table) is disabled to automatically bring over the description, enter the required value.  

• If Contractor/Processor Type (column G) is N/A or L, enter a description free format up to 1910 characters.

When updating existing records:

• Do not change the description if Type = W, F, or P and the description was automatically populated.  The changed description will revert back to the W, F or P description.

• Update for Type = N/A or L as required.

Service Term Date

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

PA Facility ID

Enter the Facility ID assigned to the processor by the production accounting department.

Cost Centre

Code entered must exist in Cost Centres master.

When inserting new records:

• If Contractor/Processor Type (column G) is W, F, or P

  • And the setting (SYNCSRVLOC in the System Table) is enabled to automatically bring over the Cost Centre, do not enter a value.  Cost Centre will be populated automatically during the Save Data to P2 step.  If a Cost Centre is entered, it will be overwritten with the Well, Facilities or Pipelines Cost Centre.

  • And the setting (SYNCSRVLOC in the System Table) is disabled to automatically bring over the Cost Centre, enter the required value.  

• If Contractor/Processor Type (column G) is N/A or L, enter a valid Cost Centre.

When updating existing records:

• Do not change the Cost Centre if Type = W, F, or P.  The changed Cost Centre will revert back to the W, F or P description.

• Update for Type = N/A or L as required.

Client Code

This is a client defined code that can be used for a purpose specific to each client.  The values must exist in the Service Location Client Code code table.

Service Type *

Code must exist in the Service Types Validation Table.  This field is an Insert only.

When Inserting new records enter a valid Service Type code.  Once saved, the field is changed to Read Only.  

When updating existing records, this value cannot be changed.  Any updates will revert back to the original value.

Volume Basis

Valid values are G (Gathered volume), I (Inlet volume), S Sales volume).

Reason for Change

Free format up to 40-characters

Fee Effective Date*

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

Basis of Fee*

Code must exist in Service Fees Basis Validation Table.

Gross/Net

Valid values are G (Gross), N (Net).

Capital Fees

Enter range min 0 to max 9,999,999.9999. Defaults to 0 if left blank.

Net %

Enter min 0 to max 100.  Only applies when Gross/Net (column U) = N. 

Operating Fees

Enter range min 0 to max 9,999,999.9999. Defaults to 0 if left blank in Qbyte Exchange.

Variable Fee*

Valid values are Y (Yes), N (No).

Operating Cost Centre

Cost Centre Code entered must exist in Cost Centres.

Comments

Free-format up to 120 characters.

Delivery Point Loc

Enter the location (max of 16 characters) reference for the processor’s delivery point.

DP Desc

Delivery Point Description.  Free format up to 40 characters.

Acceptance Point Loc

Enter the location (max of 16 characters) reference for the processor’s acceptance point.

AP Desc

Acceptance Point Description.  Free format up to 40 characters.

File Number*

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

Occurrence

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

When updating existing Terms, 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.

Term Type*

Code must exist in the Terms Contract Validation Table...

Term Date

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

Term *

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 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.  Well relationships for Service Agreements can not be inserted or updated in Exchange.

Note: this field cannot be updated after Insert > Save 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 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 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 Contract.

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.