Create a new class table

A new class table for a class object (e.g. Customer) can be created using the Connector with spMFCreateTable

Insert a new record in a class table and ensure that the minimum requirements for columns are met.

Column

Description / default value

Process_ID

1

Valuelistitem _ ID

Include the MFID of the valuelist item. There is no need to include the label of the valuelist item.

Required properties

Columns related to required properties must have data

Dependencies

If the property has scripting, automation or concatenation then the columns for all the dependent properties have data

The following SELECT statement shows the required properties of a specific class.

SELECT mfms.TableName,
mfms.ColumnName
FROM dbo.MFvwMetadataStructure AS mfms
WHERE mfms.Required = 1
AND mfms.Property_MFID > 100
ORDER BY mfms.Class;