when inputting an amount prevented from inputing more than 7 decimal places after the decimal

priyankamor
Tera Contributor

As Requester, when inputing an amount in the Amount Budget Transfer and Amount Budget Of Which, I must be prevented from inputing more than 7 decimal places after the decimal seperator (eg. 1 000,1234567 or 1,000.1234567)

 

 Seperating the thousandsSeparating decimal places
Frenchspace comma

English

commadot

 

Solution :

 

For Decimal field add attribute scale=7. attribute edge_encryption_enabled=true,scale=7 

 

In the context of ServiceNow, these specific dictionary attributes control how data fields are handled by the Edge Encryption proxy. 
  • edge_encryption_enabled=true: This attribute identifies a field as being designated for encryption. When this attribute is present and Edge Encryption is active, the system knows that the data in this field should be encrypted before it leaves the customer network and enters the ServiceNow cloud instance.
  • scale=7: This attribute is used for Decimal or Floating Point field types. It specifies the number of digits to the right of the decimal point that the system should maintain. In this case, it ensures the field supports a precision of seven decimal places. 
Together, these attributes define a database field that is both encrypted via an on-premise proxy and formatted to store high-precision numeric data. 
0 REPLIES 0