3512237 - Field Formats Used With Respect To Data Import And Export In SAP Sales And Service Cloud V2

This KBA gives a list of field formats/types that are used in Data Import And Export.

SAP Sales and Service Cloud V2

CODE_FORMAT -> Represents the code value for a field which is of the type list. You can find the code values by downloading the template in Data Import and Export view and opening the wanted the file starting with Code_.

 

STRING_FORMAT -> Text data.

 

URI_FORMAT -> URL format e.g. https://www.test.com

 

FLOAT_FORMAT -> Decimal number e.g 1.56

 

INT64_FORMAT -> Integer number, e.g. 2

 

DATETIME_FORMAT -> yyyy-mm-ddThh:mm:ssZ e.g. 2024-03-18T23:00:51Z

 

INT32_FORMAT -> Integer number, e.g. 5

 

DOUBLE_FORMAT > Decimal number.

 

TIME_FORMAT -> HH-MM-SS e.g. 18:00:00

Please find the below link for further information  https://help.sap.com/docs/CX_NG_SVC/56436b4e8fa84dc8b4408c7795a012c4/b8c4a73dc04347afbb30be6fc225441f.html?locale=en-US 

Data formats,  Data import and export, V2 , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , Problem

SAP Sales Cloud and SAP Service Cloud Version 2 1.0