Field Validation

This section provides additional information on Thredd's field validation checks, which are run on numerical data fields containing amounts and phone numbers.

For information on additional field validation and string cleaning reformatting on other types of fields containing alphabetical data, see String Cleaning and Approved Characters.

Amount Validation

Amount value validation is run on any field that contains an amount value. For example: LoadValue, LoadFee, AmtUnLoad, AmtTxn, Fee and AmtAdjustment.

Validation Rules

• Amounts can be up to a maximum value of 15 digit numbers + 4 decimal places. For example:
  123456789012345.1234

• Amounts must contain proper amount values only.

  • Negative values are not permitted. For example, the following will be rejected:
    -123.22

  • Values starting with a '+' sign are not permitted. For example, the following will be rejected:
    +123.22

• Amounts must not contain any commas, letters, spaces, special characters or more than one decimal indicator. For example, the following will be rejected:

  Invalid Amount	Reason for rejection
  124.99$	No special characters allowed.
  123456 GBP	No letters allowed.
  123,45	No commas allowed.
  91 987	No spaces allowed.
  12.34.5	Only one decimal indicator is allowed.

   

  In regions where commas are used to indicate decimal places, these should be converted to decimal points. Your systems should remove any currency signs, spaces, currency letters or direction indicators (+ or - signs) before submitted a web service to Thredd.
  

Action Codes

For invalid amount values, our systems respond with action code: 439. See Action Codes.

Phone Number Validation

Phone number value validation is run on the following fields that contain a phone number: Mobile, Tel, Mobtel and Worktel.

Validation Rules

• Phone numbers can be up to a maximum value of 15 digit numbers. For example:
  123456789012345

A standard phone number cannot contain more than 15 digits according to the international E.164 numbering plan, which sets the maximum at 15 digits including the country code.

• Phone number must be properly formatted.

  • Starting a number with an optional single '+' sign is allowed. But double plus (++) is not allowed. For example:
    +442037409682 is allowed.
    ++442037409682 is not allowed

  • Negative values (starting with minus '-' symbol) are not allowed. For example:
    -442037409682 is not allowed.

• Only numbers from 0 to 9 are allowed. Phone numbers must not contain any commas, letters, spaces, special characters or decimal indicators. For example, the following will be rejected:

Invalid Amount	Reason for rejection
UK 2037409682	No letters allowed.
203,740,9682	No commas allowed.
203.740.9682	No decimal indicators allowed.

For information on string cleaning reformatting run on phone numbers, see String Cleaning and Approved Characters.

Action Codes

For invalid phone number values, our systems respond with action code: 439. See Action Codes.