SupplierNegotiationssectionsrequirementsattachments
Stores supplementary files associated with specific negotiation requirements, such as reference documents or images.
Columns
| Name | Type | SupportedFinders | 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 | PrimaryKey | 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. |