SupplierNegotiationssectionsrequirementsattachments
Stores supplementary files associated with specific negotiation requirements, such as reference documents or images.
Columns
| Name | Type | Description |
| SupplierNegotiationsAuctionHeaderId [KEY] | Long | Unique identifier for the auction header, linking the attachment to a specific auction event. This ID connects the attachment data to its corresponding auction and can be found in the auction-related tables in the system. |
| SectionsSectionId [KEY] | Long | Unique identifier for the section within the auction, associating each attachment to a specific section. This helps categorize and organize attachments in the auction. |
| RequirementsRequirementId [KEY] | Long | Unique identifier for each requirement, allowing tracking and reference for attachments related to that requirement. This ID ensures proper association between attachments and their corresponding requirements. |
| AttachedDocumentId [KEY] | Long | Primary key that the system generates for each document attached, allowing each attachment to be uniquely identified. |
| LastUpdateDate | Datetime | Date and time when the record was last updated. This field provides a timestamp for when the attachment record was modified. |
| LastUpdatedBy | String | Name or identifier of the user who last updated the record. This field tracks who modified the attachment data. |
| DatatypeCode | String | Abbreviation that identifies the type of data in the attachment. Accepted values include 'FILE', 'FOLDER', 'TEXT', or 'WEB_PAGE', helping categorize the type of attachment. |
| FileName | String | Name of the attached file, typically representing the original file name when it was uploaded. |
| DmFolderPath | String | Folder path of the attachment in the document management system. This value helps locate where the attachment is stored within the system. |
| DmDocumentId | String | Unique identifier assigned to the document by the document management system, allowing the system to track and manage the document. |
| DmVersionNumber | String | Version number of the attached document. This ensures that different versions of the same document can be tracked and accessed. |
| Url | String | Uniform Resource Locator (URL) of the attachment. This provides the web address for accessing the document. |
| CategoryName | String | Category of the attachment, helping to group and classify attachments based on their purpose or content type. |
| UserName | String | Login credentials of the user who created the attachment record. This field tracks who originally uploaded the attachment. |
| Uri | String | Uniform Resource Identifier (URI) of the attachment, offering a unique link to the document. |
| FileUrl | String | URL that points directly to the location of the attachment, enabling access to the document through a standard web browser. |
| UploadedText | String | Text associated with the attachment, often used for metadata or additional context about the document. |
| UploadedFileContentType | String | The content type of the attachment, indicating its format |
| UploadedFileLength | Long | Size of the file in bytes. This indicates the file's storage size, helping the system manage disk space. |
| UploadedFileName | String | Name of the file uploaded to the system. This typically reflects the original file name at the time of upload. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared or not. If true, the file is shared; if false, it is not. The default value is false. |
| Title | String | Title of the attachment. This field is used to provide a brief, human-readable identifier for the document. |
| Description | String | Description of the attachment, providing additional context and details about the document's content. |
| ErrorStatusCode | String | Abbreviation identifying any error related to the attachment. This could include values like 'FILE_TOO_LARGE' or 'UPLOAD_FAILED'. |
| ErrorStatusMessage | String | Text describing the error encountered during the attachment process. This message provides more detailed information about the error condition. |
| CreatedBy | String | Name or identifier of the user who created the attachment record. This tracks the original uploader. |
| CreationDate | Datetime | Date and time when the attachment was first created in the system. This field provides a timestamp for when the attachment record was initiated. |
| FileContents | String | The actual contents of the attachment, typically stored in a binary format or Base64 encoding. |
| ExpirationDate | Datetime | Date when the contents of the attachment expire or are no longer considered valid. This field helps manage document lifecycle. |
| LastUpdatedByUserName | String | The user name of the person who last updated the record. This helps in identifying who made the last change to the attachment data. |
| CreatedByUserName | String | The user name of the person who created the attachment record. This tracks the user responsible for the initial upload. |
| AsyncTrackerId | String | An identifier used for tracking the uploaded files asynchronously, helping to monitor the upload process if done in the background. |
| FileWebImage | String | Base64-encoded image representing the file, typically used for previewing file content (for example, thumbnail for PDF or image file). |
| DownloadInfo | String | JSON string containing information used to programmatically retrieve a file attachment, such as access credentials and location. |
| PostProcessingAction | String | Name of the action that can be performed after the attachment is uploaded, such as 'extract text' or 'generate preview'. |
| AuctionHeaderId | Long | Links the attachment to a specific auction, ensuring the attachment is associated with the correct auction event. |
| Finder | String | Search reference used for filtering or locating specific attachment records in the system. |
| EffectiveDate | Date | This field is used to fetch records that are valid as of the specified date, ensuring only relevant and up-to-date attachments are included in results. |