ItemsV2ItemAttachment
Handles the management of item-specific attachments, linking documents or files to individual items.
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | The unique identifier for an item in the ItemsV2 module, which links attachments to specific inventory records. This identifier ensures traceability of documents related to a particular item. |
ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization that owns or manages the item. This identifier ensures that attachments are properly associated with the correct business unit or entity. |
AttachedDocumentId [KEY] | Long | The unique system-generated identifier for a document attached to an item. This identifier serves as a reference to locate the document in the document management system. |
LastUpdateDate | Datetime | The timestamp indicating when the attachment record was last modified. This timestamp is crucial for tracking updates and maintaining version control. |
LastUpdatedBy | String | The username or system entity that performed the last modification on the attachment. This username or entity is used for audit logging and accountability. |
DatatypeCode | String | The code representing the data type of the attached document (for example, 'text', 'image', or 'PDF'). This code determines how the file should be processed and displayed. |
FileName | String | The original name of the attached file as uploaded by the user. This name is retained for user reference and easy identification of attachments. |
DmFolderPath | String | The structured file path where the attachment is stored within the document management system. This path aids in locating files within a complex directory structure. |
DmDocumentId | String | The unique identifier assigned to the document within the document management system. This identifier ensures a reliable reference to the document for retrieval and updates. |
DmVersionNumber | String | The version number of the document in the document management system. This number helps in maintaining a history of document revisions and preventing overwrites. |
Url | String | The direct Uniform Resource Locator (URL) reference for accessing the attached document. This URL enables users to quickly retrieve the file from the system. |
CategoryName | String | The classification category assigned to the attachment. This category helps in organizing and filtering attachments based on their purpose or content type. |
UserName | String | The name of the user who uploaded the attachment. This name is used for tracking document ownership and accountability. |
Uri | String | The Uniform Resource Identifier (URI) that uniquely references the stored attachment within the system. This URI ensures reliable file access. |
FileUrl | String | The web-accessible URL for downloading or viewing the attached file. This URL is useful for remote users who need access to documents without system login. |
UploadedText | String | The extracted text content from an uploaded file, applicable for text-based attachments such as plain text or scanned documents with OCR processing. |
UploadedFileContentType | String | The content type of the uploaded file. This content type determines how the file should be handled by the system. |
UploadedFileLength | Long | The size of the uploaded file in bytes. This metric information is useful for storage management and ensuring file size limitations are adhered to. |
UploadedFileName | String | The original name of the uploaded attachment before being stored in the system. This name helps users recognize files at a glance. |
ContentRepositoryFileShared | Bool | The flag indicating whether the file is shared within the content repository. If set to 'true', multiple users or departments can access the same file. |
Title | String | The title or display name of the attached document. This title or name provides a human-readable identifier for the file. |
Description | String | The detailed description of the attached document, explaining its purpose and contents for better understanding. |
ErrorStatusCode | String | A system-generated error code indicating any issues encountered while processing the attachment. This error code helps in debugging failures. |
ErrorStatusMessage | String | A detailed message associated with an error status code. This message provides human-readable troubleshooting information. |
CreatedBy | String | The username or system entity that originally created the attachment record. This username or entity helps track the source of the document. |
CreationDate | Datetime | The timestamp of when the attachment record was initially created. This timestamp is useful for tracking document history and lifecycle. |
FileContents | String | The binary or textual representation of the attachment's data. This representation can be used for direct storage of file content within the database. |
ExpirationDate | Datetime | The optional expiration date indicating when the attachment should no longer be considered valid or relevant. |
LastUpdatedByUserName | String | The full username of the individual who last updated the attachment. This username provides a clear audit trail for modifications. |
CreatedByUserName | String | The full username of the individual who created the attachment. This username helps track the origin of documents in the system. |
DownloadInfo | String | The metadata related to file downloads, including user activity and download history for audit purposes. |
DocumentURL | String | The direct hyperlink to the document stored in an external document management system, allowing seamless access. |
AcdType | String | The classification type of the attachment, which determines how it is processed and categorized within the system. |
ChangeLineId | Long | The identifier linking the attachment to a specific change record. This identifier ensures traceability of modifications related to a product or process. |
Finder | String | The reference to an internal search or retrieval mechanism that assists users in locating the attachment efficiently. |
InventoryOrganizationId | Long | The unique identifier of the inventory organization responsible for managing the item associated with the attachment. |
ItemId | Long | The unique identifier of the item that the attachment is linked to. This identifier ensures that documents are correctly associated with inventory records. |
ItemNumber | String | The human-readable item number associated with the attachment. This item number provides an easily recognizable reference. |
OrganizationCode | String | The standardized code representing the organization. This code is used for categorization and reporting purposes. |
OrganizationId | Long | The unique identifier of the organization associated with the attachment. This identifier ensures proper organizational mapping. |
VersionId | Long | The identifier representing the version of the attachment record. This identifier allows version control and historical tracking of file changes. |