SupplierRegistrationQuestionnaireResponsesquestionnaireAttachments
Facilitates attachments (for example, supporting documents) to questionnaire responses, adding evidence or documentation during supplier onboarding.
Columns
Name | Type | Description |
SupplierRegistrationQuestionnaireResponsesQuestnaireRespHeaderId [KEY] | Long | A unique identifier for the header of the questionnaire response. This ID links the attached documents to the specific questionnaire response header. |
SupplierRegistrationQuestionnaireResponsesSupplierRegistrationKey [KEY] | String | A unique key that links the attachment to the supplier’s registration process. It ensures that the attachment is associated with the correct supplier registration record. |
AttachedDocumentId [KEY] | Long | A unique identifier assigned to the attached document. This ID is generated when a document is attached to the questionnaire response and is used to track the file. |
LastUpdateDate | Datetime | The date and time when the attached document was last updated. This field is used to track the most recent modification to the attachment. |
LastUpdatedBy | String | The user who last updated the attached document. This field records who made the most recent change to the attachment. |
DatatypeCode | String | An abbreviation that identifies the type of data for the attached document. Values might include 'FILE', 'TEXT', 'IMAGE', or 'PDF'. A list of accepted values is typically defined in a lookup type. |
FileName | String | The name of the file attached to the questionnaire response. This field represents the file name as it was uploaded. |
DmFolderPath | String | The folder path in the document management system (DMS) where the attached document is stored. |
DmDocumentId | String | A unique identifier for the document in the document management system (DMS). This ID is used to track the document in the system. |
DmVersionNumber | String | The version number of the attached document in the document management system (DMS). Each update to the document is assigned a new version number. |
Url | String | The URL where the attached document can be accessed. This link points directly to the document in the system. |
CategoryName | String | The category to which the attached document belongs. This could help classify the document, such as 'Contract', 'Invoice', or 'Supplier Form'. |
UserName | String | The username of the person who uploaded the document. This field tracks the user responsible for the document attachment. |
Uri | String | A uniform resource identifier (URI) pointing to the location of the document in the system. |
FileUrl | String | The URL of the attached document, providing access to the file for viewing or downloading. |
UploadedText | String | Any additional text associated with the uploaded document, such as comments or descriptions provided by the user when uploading the file. |
UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
UploadedFileLength | Long | The size of the uploaded file, measured in bytes. |
UploadedFileName | String | The name of the file as it was uploaded. This might differ from the original file name if the system renames the file during the upload process. |
ContentRepositoryFileShared | Bool | Indicates whether the file is shared in the content repository. If true, the file is shared; if false, it is not. |
Title | String | The title or name given to the attached document. This might provide a more descriptive label than the file name. |
Description | String | A brief description of the document attached. This field is used to describe the content or purpose of the document. |
ErrorStatusCode | String | An abbreviation that identifies any error encountered with the document attachment process. For example, this might include values like 'UPLOAD_FAILED' or 'INVALID_FORMAT'. |
ErrorStatusMessage | String | A detailed message describing the error encountered with the document attachment process. This provides more information about the error described in the 'ErrorStatusCode'. |
CreatedBy | String | The user who created the attachment record. This field tracks who initially uploaded the document. |
CreationDate | Datetime | The date and time when the attachment was created. This marks when the document was first uploaded into the system. |
FileContents | String | The content of the file in a Base64-encoded string format. This field holds the actual content of the file that was uploaded. |
ExpirationDate | Datetime | The date and time when the attached document expires. After this date, the document may no longer be accessible or may be flagged for review. |
LastUpdatedByUserName | String | The username of the person who last updated the document record. This field tracks who made changes to the document or its metadata. |
CreatedByUserName | String | The username of the person who initially created the attachment record, typically the person who uploaded the document. |
AsyncTrackerId | String | An identifier used for tracking the status of asynchronous file uploads or processing activities. |
FileWebImage | String | The web image of the file, typically stored in Base64 encoding, representing the file visually if it is an image or document that can be displayed. |
DownloadInfo | String | A JSON object in string format containing information that can be used to programmatically retrieve the file attachment, such as download URL or authentication details. |
PostProcessingAction | String | The name of an action that can be performed after the document is uploaded. This could include actions like 'APPROVE', 'REVIEW', or 'ARCHIVE'. |
Finder | String | A search term or keyword used to locate the document attachment within the system. This term helps streamline document searches for specific content. |
QuestnaireRespHeaderId | Long | The unique identifier for the questionnaire response header that the document is attached to. This links the document to the specific response. |
SupplierRegistrationKey | String | The unique identifier for the supplier registration associated with this document. This ensures the attachment is linked to the correct supplier's registration record. |