CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175