MSF0P6

The MSF0P6 table holds the image and CLOB/BLOB custom attribute values stored against the object where the custom attribute's PROP_DATA_TYPE is M—Image.

Name Type Null Comment
ENTITY_KEY VARCHAR2 1000 NOT NULL

Key of the entity associated with the custom attribute:

  • UID link to the custom attribute, where the associated entity has an ID field, for example, CCJOB.ID, or

  • Holds the concatenated business key that make the record unique, where the associated entity does not have an ID field. For example, where the associated entity is CCPRICECAT, then this is a concatenation of PRICE_CAT_CODE + LAB_CODE + ORG_CODE.
ENTITY_TYPE VARCHAR2 100 NOT NULL

The Service.Service.Object.CustomProperty. For example, CCJobService.CCJob.CUSTOM_IMAGE, or QCTypeService.CCQCType.RULE.
PROPERTY_VALUE VARCHAR2 1000  

The property value, as a string, maximum 100 characters.

Where the custom attribute's PROP_DATA_TYPE is of a:

  • M—Image, then set to '(BLOB)'. The MSFRTA table contains a record with the specific content

  • All other types, then empty.
VAL_DATA_DESC     For images only; the Description of the image, entered at time of file or image upload.
VAL_DATA_FILE_EXT     For images only; the extension of the selected file or image file, for example, 'png'.
VAL_DATA_NAME     For images only; the Name of the image or file, entered at time of file or image upload.
VAL_DATA_SIZE_BYTES     For images only; the size of the uploaded file.
LAST_MOD_TIME CHAR 6 NOT NULL  
LAST_MOD_USER VARCHAR2 254 NOT NULL  
LAST_MOD_DATE CHAR 8 NOT NULL  
LAST_MOD_EMP CHAR 254 NOT NULL