DraftSupplierNegotiationResponsessectionsrequirementsattachments
Stores supporting files linked to a draft requirement, such as technical documents or references from the supplier.
Columns
| Name | Type | Description |
| DraftSupplierNegotiationResponsesResponseNumber [KEY] | Long | The unique identifier for the negotiation response, linking the attachment to a specific response within the negotiation. |
| SectionsResponseNumber [KEY] | Long | The unique identifier for the response within the section, linking the requirement attachment to the correct response. |
| SectionsSectionId [KEY] | Long | The unique identifier for the section in the response, associating the attachment with a specific section in the negotiation. |
| RequirementsRequirementId [KEY] | Long | The unique identifier for the requirement, linking the attachment to a specific requirement within the negotiation. |
| RequirementsResponseNumber [KEY] | Long | The unique identifier for the response within the requirement, linking the attachment to the specific supplier response for that requirement. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attachment, assigned by the system when the document is uploaded and linked to the negotiation. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated by the user, providing a record of the most recent changes. |
| LastUpdatedBy | String | The user who most recently updated the attachment, ensuring accountability for modifications made to the document. |
| DatatypeCode | String | An abbreviation identifying the data type of the attachment. Possible values include 'FILE', 'FOLDER', 'TEXT', or 'WEB_PAGE', denoting the format of the document. |
| FileName | String | The name of the attached file, used to identify the document in the system and by users. |
| DmFolderPath | String | The folder path within the document management system where the attachment is stored, specifying its location. |
| DmDocumentId | String | The unique identifier for the attached document in the document management system, allowing for its retrieval and management. |
| DmVersionNumber | String | The version number of the attached document, helping track changes or updates to the document over time. |
| Url | String | The URI (Uniform Resource Identifier) that points to the attachment, allowing access to the document. |
| CategoryName | String | The category assigned to the attachment, which helps identify its role in the negotiation process. Examples include 'From Supplier' or 'From Supplier: Technical'. |
| UserName | String | The sign-in credentials (user login) used by the person who added or modified the attachment, providing accountability for the attachment's entry. |
| Uri | String | The URI (Uniform Resource Identifier) for accessing the attachment, providing a direct reference to the document in the system. |
| FileUrl | String | The URL (Uniform Resource Locator) for the attachment, offering a direct link for users to view or download the document. |
| UploadedText | String | The textual content of the attachment, applicable when the attachment is a text-based document. |
| UploadedFileContentType | String | The content type of the attachment, indicating its format. |
| UploadedFileLength | Long | The size of the attached file, measured in bytes, providing information on the document's size. |
| UploadedFileName | String | The name of the uploaded file, which may be different from the original file name if modified during upload. |
| ContentRepositoryFileShared | Bool | A flag indicating whether the attachment is shared in the content repository. If true, the document is shared; if false, it is not. The default is false. |
| Title | String | The title of the attachment, used to provide a brief description or name for easy identification of the document. |
| Description | String | A detailed description of the attachment, providing additional context on the contents and purpose of the document. |
| ErrorStatusCode | String | The error code associated with the attachment, if any, providing a way to identify and address issues during the upload process. |
| ErrorStatusMessage | String | The error message describing any issues encountered during the attachment process, helping to diagnose problems. |
| CreatedBy | String | The user who created the attachment record, ensuring accountability for the document's initial upload. |
| CreationDate | Datetime | The date and time when the attachment record was created, establishing a timeline for the document's entry into the system. |
| FileContents | String | The contents of the attachment, typically stored as text or Base64-encoded data, allowing for inspection or processing of the document. |
| ExpirationDate | Datetime | The date when the attachment expires, indicating when the document is no longer considered valid or accessible. |
| LastUpdatedByUserName | String | The login details of the user who last updated the attachment, providing transparency on who made the most recent changes. |
| CreatedByUserName | String | The user name of the person who created the attachment record, offering context on the initial document upload. |
| AsyncTrackerId | String | An identifier used to track the status and progress of asynchronous file uploads, especially for large files. |
| FileWebImage | String | A Base64-encoded image of the attachment displayed in .png format if the file source is an image that can be converted for preview. |
| DownloadInfo | String | A JSON-formatted string containing information necessary to programmatically retrieve a large file attachment. |
| PostProcessingAction | String | The name of the action that can be performed after the attachment is uploaded, such as validating or indexing the document for future use. |
| Finder | String | A search identifier used to locate specific attachment records related to the negotiation response. |
| ResponseNumber | Long | The unique identifier for the supplier's response, linking the attachment to the corresponding response in the negotiation. |
| EffectiveDate | Date | The date from which the attachment is considered effective, marking when it is valid for use or review in the negotiation process. |