Skip to main content

Hello,

we have a client who wants their ADDRESS_ID and CONTACT.CONTACT_SEQUENCE to always be 10 digits, for example, Address ID: 0012345678.

When we import the customer's current sample data, the leading zeros in Address ID (e.g., 00 in 0012345678) are not displayed. We only see 12345678.

In FSM, both of these fields are of the DECIMAL data type in the FSM Metadata, and it is not possible to override them with custom metadata.

Apart from using a user_def field with a column type of STRING, are there any other options?

Thank you in advance for your kind help.

 

@ChingL ,

Hi, 

You are correct those fields can not be altered to allow leading zero’s. If leading zero’s are needed you need to go the route of user defs.

Regards,

Morris

Hi @ChingL ,

As both of you mentioned, we cannot format the decimal type values with the expected output as the leading zeros are automatically eliminated by the application itself. You will require to setup this on a string type variable.

Reply


Terms & ConditionsCookie settings