File Number*

When inserting new records, the File Number must be entered if Auto Numbering has not been configured. 

When updating existing records, the File Number specified must already exist 

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.

Prev Document Number

Free-format up to 20 characters.

ROFR

Will not be a column on the spreadsheet since the value is automatically populated behind the scenes when the row is saved.

Assignment*

Valid values are Y (Yes), N (No), and X (Unknown).

Assignment Terms

Valid values are Y (checked) and N (un checked).

Segregation*

Valid values are Y (Yes), N (No), and X (Unknown).

Operating Type

Display only, derived from the Type selection in the Operating Provisions tab.

ROFR

Display only, derived from the ROFR election in the Operating Provisions tab.

ROFR Comment

Free-format up to 30 characters. Can be used to help clarify the ROFR value.

Accounting Type

Display only, derived from the Type selection in the Accounting Provisions tab.

ORR Type

Display only, derived from the Type selection in the Overriding Royalty Procedure tab.

FO Royalty Type

Display only, derived from the Type selection in the Farmout Royalty Procedure tab.

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 records, 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.

Unlink

Do not update this field. This column displays the Subs that have not yet been linked to the Base Amendment.

Link

Enter all the Subs in this column that need to be linked to the Amendment. Use the format A, B, D  After the data is Saved to P2 (in Update mode), when the next Get Data is done, the Linked subs appear in the Linked column, and any subs that are still not linked to the Amendment are listed in the Unlinked column.

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.

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.

Partner Name*

Free-format up to 80  characters.

Percent*

The partner interest percentage entered on each row cannot be greater than 100%.

File Number*

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

Operating Type*

When inserting new records, enter CAPL and Year of CAPL combination.  Currently, valid values are CAPL81, CAPL90 and GENOPER.  The Operating Type entered determines validation that occurs on the row.

When updating rows, the Operating Type cannot be changed.

Marketing Price Definition

Clause 1.01 applicable to CAPL07 and CAPL15 

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

Production Facility

Clause 1.01 applicable to CAPL07 and CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

If Applies, Estimated cost less than $

Clause 1.01 applicable to CAPL07 and CAPL15

Enter dollar amount with or without a decimal (max value = 9,999,999.99)

Insurance

Clause 311 applicable to CAPL81, and CAPL90

Clause 3.11C Required Insurance applicable to CAPL07 and CAPL15

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

Marketing

Clause 604 applicable to CAPL90

Clause 604 (Alt B) applicable to CAPL90

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

a) Petroleum %

Clause 604 (Alt B) applicable to CAPL90

Enter percentage amount, if applicable, with or without a decimal. (Min 0 - Max 999.99999)

a) Petroleum $

Clause 604 (Alt B) applicable to CAPL90

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

b) NG %

Clause 604 (Alt B) applicable to CAPL90

Enter percentage amount, if applicable.  (Min 0% - Max 999.99999)

b) NG $

Clause 604 (Alt B) applicable to CAPL90

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

c) NGLs & Other excl PNG & Sulphur %

Clause 604 (Alt B) applicable to CAPL90

Enter percentage amount, if applicable.  (Min 0 - Max 999.99999)

c) NGLs & Other excl PNG & Sulphur $

Clause 604 (Alt B) applicable to CAPL90

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

d) Sulphur %

Clause 604 (Alt B) applicable to CAPL90

Enter percentage amount, if applicable.  (Max 999.99999)

d) Sulphur $

Clause 604 (Alt B) applicable to CAPL90

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

Casing Point

Clause 903 applicable to CAPL71, CAPL74, CAPL81, and CAPL90

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

Receiving Party May Not Defer Response

Clause 10.02 G applicable to CAPL07 and CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

If applies, True Vertical Depth in meters

Clause 10.02 G applicable to CAPL15

Enter Formation Code representing the True Vertical Depth.  Formation must exist in the Formation Validation table.

If applies, above base formation

Clause 10.02 G applicable to CAPL15

Operator for Independent Operation

Clause 10.04 A applicable to CAPL07 and CAPL15

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

Penalty (Dev)

Clause 1007 applicable to CAPL74, CAPL81, and CAPL90

Clause 10.07 A(e) applicable to CAPL07, and CAPL15

Clause 1008 applicable to CAPL71

Enter percentage of penalty (Max 999.99999)

Penalty (Expl)

Clause 1007 applicable to CAPL74, CAPL81, and CAPL90

Clause 10.07 A(e) applicable to CAPL07, and CAPL15

Clause 1008 applicable to CAPL71

Enter percentage of penalty (Max 999.99999)

Title Preserving Wells

Clause 1010(a)(iv) applicable to CAPL90

Clause 10.10 A applicable to CAPL07, and CAPL15

Enter number of days (Min 0 – Max 999)

Proposed Production Facility

Clause 10.13 B applicable to CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

Dispute Resolution

Clause 21.00 applicable to CAPL07, and CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

Arbitration Proceedings

Clause 21.03 (j) applicable to CAPL07

Clause 21.03 (k) applicable to CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

If Applies, estimated total adjustment less of $

Clause 21.03 (j) applicable to CAPL07

Clause 21.03 (k) applicable to CAPL15

Enter dollar amount, with or without decimals (Max 9,999,999.99)

Disposition of Interest

Clause 2401 applicable to CAPL74, CAPL81, and CAPL90

Clause 2601 applicable to CAPL71

Applicable to GENOPER

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

Disposition of Interest Days

Applicable to GENOPER

If Alternate B is selected, enter number of days. (Min 1 - Max 999) 

Right to Dispose

Clause 24.01 applicable to CAPL07, and CAPL15

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

Right to Dispose Alternate (B) the date at which ROFR Expires

Clause 24.01 applicable to CAPL07, and CAPL15

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

Exception to Disposition of Interest

Clause 24.02 (f) Exceptions to Clause 24.01 applicable to CAPL07, and CAPL15

Valid values are Y (Will Apply), N (Will Not Apply), X (Not Applicable)

Assignment

Clause 2404 applicable to CAPL90

Valid values are A (Alternate A), B (Alternate B) or X (Not Applicable)

File Number*

When inserting new records, the file number specified must already exist and a Oper Proc record for the File Number must already exist. 

Operating Type*

Enter CAPL and Year of CAPL combination.  Currently, valid values are CAPL81, CAPL90 and GENOPER. 

Clause Code*

Enter the applicable clause code (E.g., 311) for the specified Operating Type.  Note: It is important to enter the Clause Code in the exact format otherwise a validation error will occur.  A complete listing of Clause Codes can be found in the Contract Provisions validation Table.

Remark*

Remark must be entered.  Free format up to 1910 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.

(A) File Number*

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

(B) Acct Type*

When inserting new records, enter PASC and Year of PASC combination.  Currently, valid values are PASC88.  The Accounting Type entered determines validation that occurs on the row.

When updating rows, the Accounting Type cannot be changed.

(C) Eff Date

Effective Date

(D) CC & Adv

Cash Calls and Advances

Clause 104 applicable to PASC11

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(E) Adv%

Operating Advances

Clause 104 applicable to PASWC76,

Clause 105 applicable to PASWC83, PASC88, PASC96, PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(F) Adv Days

Operating Advances Days

Clause 104 applicable to PASWC76

Enter number of days (max value = 999)

(G) Unpd Accts%

Unpaid Accounts

Clause 105 applicable to PASWC76

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(H) App Clause

Agmt Clause

Clause 110 applicable to PASC96

Enter applicable Clause number e.g. 108 a)

(I) App - #Parties

Approvals Parties/Owners          

Clause 109 applicable to PASWC76, 

Clause 110 applicable to PASWC83, PASC88, PASC96      

Enter number of Parties/Owners (Min 0 - Max = 9,999)

(J) App - %

Approvals Percentage

Clause 109 applicable to PASWC76, 

Clause 110 applicable to PASWC83, PASC88, PASC96

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(K) AFE Single

AFE – Single Undertaking

Clause 111 applicable to PASC11

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(L) AFE Damage

AFE Damage Claims

Clause 111 applicable to PASC11

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(M) AFE

AFE – Over expenditure Explanation or Supplemental AFE’s

Clause 111(D) applicable to PASC11

Valid values are A (> 10% cost), B (Revised), X (Not Applicable)

(N) Exp lmt a)

Expenditure Limits

Clause 112 a) applicable to PASC96

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(O) Exp lmt c)

Expenditure Limits

Clause 112 c) applicable to PASC96

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(P) Labour - ICP Lim

Labour ICP Limitation

Clause 201 (F)(5) applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(Q) Labour 2nd Level

Labour 2^nd Level

Clause 202 applicable to PASC88,

Clause 201 (F)(3) applicable to PASC11

Valid values are Y (Chargeable), N (Not Chargeable), X (Not Applicable)

(R) Labour Technical

Labour Technical

Clause 202 applicable to PASC88

Valid values are Y (Chargeable), N (Not Chargeable), X (Not Applicable)

(S) Empl Bene - %

Employee Benefits

Clause 203(b) applicable to PASWC76, PASWC83, PASC88,

Clause 202(b) applicable to PASC96,

Clause 202(E) applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(T) Camp & House

Camp & House

Clause 213(b) applicable to PASC96

Valid values are Y (Chargeable), N (Not Chargeable) or X (Not Applicable)

(U) Whs Hdlg - Tublar - %

Warehouse Handling - Tubular

Clause 303 applicable to PASWC76,

Clause 218 applicable to PASWC83, 

Clause 217 applicable to PASC88, 

Clause 216 applicable to PASC96, 

Clause 205(B)(5) PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(V) Whs Hdlg - Excess$

Warehouse Handling - Excess

Clause 303 applicable to PASWC76, 

Clause 218 applicable to PASWC83, 

Clause 217 applicable to PASC88

Enter dollar amount, if applicable (Up to 2 decimals, Min .00 - Max 9,999,999.99)

(W) Whs Hdlg - Other - %

Warehouse Handling - Other

Clause 303 applicable to PASWC76, 

Clause 218 applicable to PASWC83, 

Clause 217 applicable to PASC88

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(X) Disp

Disposition

Clause 406 applicable to PASC96

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

(Y) Periodic Inv-Yr Intervals

Periodic Invoice Year – Intervals

Clause 505 applicable to PASWC76, 

Clause 501 applicable to PASWC83, PASC88

Enter number of days/years (Min 1 - Max 9,999) 

(Z) Art IV

Article IV

Article IV applicable to PASWC76, PASWC83, PASC88

Enter dollar amount, with or without decimal. (Up to 2 decimals, Min .00 - Max 9,999,999.99)

(AA) Oper Maint N/A

Operation Maintenance - N/A

Applicable to PASWC76, PASWC83, PASC88, PASC96, PASC11, GENACCT

Enter N if applies or Y if does not apply

(AB) Oper Maint Cost %

Operation Maintenance – Cost %

Applicable to PASWC76, PASWC83, PASC88, PASC96, PASC11, GENACCT

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AC) Oper Maint Oper Ind

Operation Maintenance – Operation Ind

Applicable to PASC88, PASC96

Either “and” or “or”

(AD) Oper Maint Prod Well

Operation Maintenance – Production Well

Applicable to PASWC76, PASWC83, PASC88, PASC96, PASC11, GENACCT

Enter dollar amount, with or without decimals (Max 9,999,999.99)

(AE) Oper Maint Flat $

Operation Maintenance – Flat $

Applicable to PASWC83, PASC88, PASC96, PASC11, GENACCT

Enter dollar amount, with or without decimals (Max 9,999,999.99)

(AF) Oper Maint Wells Only %

Operation Maintenance – Wells Only %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AG) Oper Maint Fac %

Operation Maintenance – Facility %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AH) Oper Maint Prop Tax %

Operation Maintenance – Property Tax %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AI) Oper Maint Cost %

Operation Maintenance – Cust %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AJ) Oper Maint Util %

Operation Maintenance – Utilities %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AK) Oper Maint Enviro %

Operation Maintenance – Environmental %

Applicable to PASC11

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

(AL) Oper Maint Adj Rates

Operation Maintenance – Adjustment Rates

Applicable to PASC88, PASC96

Valid values are Y (Apply), N (Not Apply) or X (Not Applicable)

File Number*

When inserting new Client Defined records, 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 Overhead Type.  

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

Acctg Type*

When inserting new records, enter PASC and Year of PASC combination.  Currently, valid values are PASC88.  The Accounting Type entered determines validation that occurs on the row.

When updating rows, the Accounting Type cannot be changed.

Overhead Type*

Enter EXPL, CONST, or DRILL.  Each Type must be entered on its own row.

Election Alternative

Required for PASC88 - Value to be entered is always B.  Note: This value is required in the database, but does not appear on Qbyte CS Land screen.

Not Applicable

Required for PASC88 - Not Applicable checkbox.  Enter C for Applicable and X for Not Applicable.

% of first

Applicable to PASC88

Enter percentage, up to 4 decimals (Min .0001 - Max 100)

$ plus

Applicable to PASC88

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

% of next

Applicable to PASC88

Enter percentage, up to 4 decimals (Min .0001 - Max 100)

$ plus2

Applicable to PASC88

Enter dollar amount, if applicable, with or without a decimal. (Max 9,999,999.99)

% of cost exceeding 1 and 2

Applicable to PASC88

Enter percentage, up to 4 decimals (Min .0001 - Max 100)

% of Cost or

Enter percentage, up to 4 decimals (Min .0000 - Max 100)

File Number*

When inserting new records, the file number specified must already exist and a Acctg Prov record for the File Number must already exist. 

When updating existing rows, the File Number cannot be changed.

Accounting Type*

When inserting new records, enter PASC and Year of PASC combination.  Currently, valid values are PASC88. 

When updating existing rows, the Accounting Type cannot be changed.

Clause Code*

Enter the applicable clause code (E.g., 105) for the specified Accounting Type.  Note: It is important to enter the Clause Code in the exact format otherwise a validation error will occur.  A complete listing of Clause Codes can be found in the Contract Provisions validation Table.

Remark*

Remark must be entered.  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 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 Relationship Validation Table.

Comment

Free format up to 120 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.