Data Types and Shared Multivalue Table Name
The following table lists the data types and their shared multivalue table names:
Data Type | Multivalue Table Name |
---|---|
String and File | MV_SHARED_STRING_TABLE |
Integer | MV_SHARED_INTEGER_TABLE |
Decimal, Custom Decimal, and Amount
Note: While creating a new multivalue attribute of Custom Decimal type in SQL Server; if you change the default precision (18+12), the Multivalue Shared Table option for storage does not work. Hence, in this case do not select the Use Common Table checkbox. Use a separate table for storage. |
MV_SHARED_DECIMAL_TABLE |
Date and Timestamp | MV_SHARED_DATE_TABLE |
Copyright © Cloud Software Group, Inc. All rights reserved.