ItemsV2ItemRevisionRevisionAttachment
Manages attachments related to specific item revisions, providing additional documentation or reference.
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to revision-level document attachments, ensuring proper documentation control and compliance. |
| ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization managing the item. This identifier ensures that attachments related to item revisions are correctly associated with the appropriate business unit, supporting document governance and access control. |
| ItemrevisionInventoryItemId [KEY] | Long | The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures accurate document attachment to revised inventory items for reference and compliance tracking. |
| ItemrevisionOrganizationId [KEY] | Long | The identifier representing the organization responsible for managing the item revision. This identifier ensures that document attachments are linked to the correct organization for regulatory compliance and internal audit purposes. |
| ItemrevisionRevisionId [KEY] | Long | The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of engineering, manufacturing, or compliance-related document attachments for historical reference. |
| AttachedDocumentId [KEY] | Long | The system-generated unique identifier for the document attached to the item revision. This identifier serves as a reference for retrieving engineering drawings, compliance documents, or other supporting files. |
| LastUpdateDate | Datetime | The timestamp indicating the most recent update to the attached document record. This timestamp helps track modifications and ensures users access the latest version of the document. |
| LastUpdatedBy | String | The username or system entity responsible for the most recent modification of the document attachment. This user name or system entity supports audit tracking and accountability. |
| DatatypeCode | String | The code representing the type of data stored in the attachment, such as PDF, DOCX, or CAD file formats. This code helps categorize and control document handling. |
| FileName | String | The original name of the attached file as uploaded by the user. This field provides visibility into the document’s content and helps users locate relevant files. |
| DmFolderPath | String | The structured folder path within the document management system (DMS) where the file is stored. This path ensures easy retrieval and organization of attachments. |
| DmDocumentId | String | The unique identifier assigned to the document in the document management system. This identifier ensures accurate referencing and integration with external systems. |
| DmVersionNumber | String | The version number of the document within the document management system. This number supports revision control by maintaining a historical record of document updates. |
| Url | String | The direct Uniform Resource Locator (URL) reference for accessing the attached document. This URL allows users to quickly retrieve and view the file. |
| CategoryName | String | The category assigned to the attachment, enabling structured classification of documents based on purpose, such as engineering, compliance, or manufacturing. |
| UserName | String | The name of the user who uploaded the document attachment. This name helps track ownership and accountability for document submissions. |
| Uri | String | The Uniform Resource Identifier (URI) linking to the stored document. This URI ensures a globally unique reference for document retrieval. |
| FileUrl | String | The web-accessible URL for downloading or viewing the attached file. This URL facilitates remote access to important revision-related documents. |
| UploadedText | String | The extracted text content from an uploaded document, applicable to text-based attachments. This extracted content allows for content indexing and searching within the document repository. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. This content type helps determine how the file should be handled in system workflows. |
| UploadedFileLength | Long | The file size of the uploaded document in bytes. This metric helps manage storage allocation and ensure file size limitations are adhered to. |
| UploadedFileName | String | The original file name of the uploaded attachment, retained for reference and document tracking. |
| ContentRepositoryFileShared | Bool | A flag indicating whether the document is shared within the content repository. If set to 'true', multiple users or departments can access the same document. |
| Title | String | The title or display name of the attached document. This title or name provides a user-friendly identifier for document searches and references. |
| Description | String | The detailed description of the attached document. This description provides context about its purpose and contents. |
| ErrorStatusCode | String | The system-generated error code related to any issues encountered while processing the document attachment. This error code aids in troubleshooting and system monitoring. |
| ErrorStatusMessage | String | A human-readable error message explaining the status code. This error message helps users understand and resolve document-related issues. |
| CreatedBy | String | The username or system entity that originally created the attachment record. This username or system entity is essential for audit tracking and document lifecycle management. |
| CreationDate | Datetime | The timestamp indicating when the document attachment record was initially created. This timestamp ensures proper tracking of document history. |
| FileContents | String | The binary or text representation of the attachment's contents. This representation can be used for direct storage of document data within the database. |
| ExpirationDate | Datetime | The optional expiration date for the attached document. This date indicates when it should no longer be considered valid or relevant. |
| LastUpdatedByUserName | String | The full username of the individual who last updated the attachment. This field supports document lifecycle tracking and accountability. |
| CreatedByUserName | String | The full username of the individual who created the attachment record. This field helps maintain a clear history of document origin. |
| DownloadInfo | String | Metadata related to file downloads, including access logs and download status. This metadata supports document audit and security tracking. |
| DocumentURL | String | The direct hyperlink to the document stored in an external document management system, ensuring seamless access to supporting files. |
| AcdType | String | The classification type associated with the attachment. This classification type defines its relevance within business workflows such as compliance audits or engineering change orders. |
| ChangeLineId | Long | The unique identifier linking the document attachment to a specific change request or engineering change order (ECO). This identifier ensures traceability of document revisions related to item changes. |
| Finder | String | The reference to an internal search or query mechanism that allows users to efficiently locate document attachments. This reference enhances usability and document retrieval efficiency. |
| InventoryOrganizationId | Long | The unique identifier of the inventory organization responsible for managing the attached document. This identifier ensures proper linkage of documents to inventory operations and business units. |
| ItemId | Long | The unique identifier for the item to which the document is attached. This identifier ensures that documents are correctly associated with the appropriate product or component. |
| ItemNumber | String | A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference. |
| OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for the document attachment. This code ensures consistency in record-keeping across multiple business units. |
| OrganizationId | Long | The unique identifier representing the organization associated with the attached document. This identifier ensures that documents are linked to the correct business entity for governance and compliance. |
| VersionId | Long | The system-generated identifier representing the version of the document attachment record. This identifier allows historical tracking of changes to attached files, ensuring regulatory and business compliance. |