Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderResourceWorkOrderOperationResourceAttachment

Stores documents attached to resources used in work order operations for improved resource documentation.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier for the work order associated with this resource attachment. This identifier ensures that resource-related attachments are correctly linked to the work order execution.
WorkorderresourceWorkOrderOperationResourceId [KEY] Long The unique identifier for the operation resource within the work order. This identifier links attachments to specific resources utilized in the production process.
AttachedDocumentId [KEY] Long The unique identifier for the document attached to this work order resource. This identifier helps maintain reference documents such as specifications, manuals, and compliance reports.
LastUpdateDate Datetime The date and time when this attachment record was last updated. These metrics ensure visibility into recent modifications and version control.
LastUpdatedBy String The user who last modified this attachment record. This field provides accountability and traceability for document management.
DatatypeCode String The data type of the attached document (for example, 'PDF', 'DOCX', or 'XML'). This data type helps categorize file types for compatibility and access control.
FileName String The name of the attached document. This name provides an easily recognizable reference for resource-related documentation.
DmFolderPath String The digital folder path where this document is stored. This path ensures easy retrieval and organization of work order attachments.
DmDocumentId String The unique identifier for the document within the document management system. This identifier allows seamless integration with enterprise document repositories.
DmVersionNumber String The version number of the attached document. This number helps maintain proper version control and ensures the use of the most updated file.
Url String The web-accessible URL for the document. This URL enables quick access to external or cloud-hosted documents.
CategoryName String The category under which the document is classified (for example, 'Work Instructions' or 'Safety Guidelines'). This category supports organized document management.
UserName String The name of the user associated with the document upload or modification. This name helps track document ownership.
Uri String The system-generated Uniform Resource Identifier (URI)) for accessing the document. This URI ensures document accessibility across systems.
FileUrl String The direct link to download or preview the document. This link facilitates quick access to necessary work order resource files.
UploadedText String Any textual content extracted from the uploaded file. This content supports text-based searching and indexing of attached documents.
UploadedFileContentType String The content type of the uploaded file. This type ensures proper file handling and compatibility.
UploadedFileLength Long The size of the uploaded document in bytes. This metric helps monitor storage utilization and file size limits.
UploadedFileName String The original name of the uploaded file. This namepreserves file naming conventions for easier reference.
ContentRepositoryFileShared Bool Indicates whether the file is shared across multiple work orders or work centers. If the value is 'true', the document is accessible to multiple entities.
Title String The title of the attached document, if specified. This field provides a human-readable name for quick identification.
Description String A brief description of the document's purpose or contents. This description helps provide context for users accessing the attachment.
ErrorStatusCode String The error code, if any, related to the document upload or retrieval process. This error code helps diagnose and resolve attachment issues.
ErrorStatusMessage String A descriptive message detailing any errors encountered during the document upload or retrieval process.
CreatedBy String The user who originally created this attachment record. This field supports audit tracking and document management oversight.
CreationDate Datetime The date and time when this attachment record was created. These metrics ensure historical tracking of document associations.
FileContents String The raw content of the uploaded file. This content allows for text processing and searching within attachments.
ExpirationDate Datetime The expiration date for the document. This date ensures outdated documents are reviewed or replaced when necessary.
LastUpdatedByUserName String The username of the individual who last updated the document record. This field supports accountability in document version control.
CreatedByUserName String The username of the individual who originally created the document record. This field helps track document ownership.
AsyncTrackerId String A system-generated identifier for tracking asynchronous upload or processing tasks related to the document. This identifier ensures efficient handling of bulk document operations.
FileWebImage String The URL or reference to a web-accessible image version of the document. This URL is useful for previewing image-based attachments.
DownloadInfo String Additional metadata related to the document download process, such as timestamp, user details, or download restrictions.
PostProcessingAction String Specifies the action to be taken after the work order operation resource attachment is processed (for example, 'archive' or 'notify'). This field supports automation and task management in document workflows.
BackToBackFlag String Indicates whether the attachment is associated with a back-to-back manufacturing process. This flag ensures proper linkage between demand and supply in production.
ContractMfgFlag String Indicates whether the attachment is related to a contract manufacturing process. This flag helps in tracking documentation for outsourced production activities.
DueDays Int The number of days remaining until the planned due date for completing the operation or task associated with this attachment. This metric supports production scheduling.
Finder String A search key or identifier used to locate specific attachment records related to work order resources in the system.
FirmPlannedFlag String Indicates whether the attachment or related resource plan is firm planned, meaning it is locked and not subject to changes. This flag ensures stability in resource planning.
InventoryItemId Long The unique identifier for the inventory item associated with this attachment. This identifier supports traceability of materials or components.
ItemNumber String The specific item number linked to the attachment. This number ensures accurate tracking of materials or resources in the work order process.
MaterialItemId Long The unique identifier for the material associated with the attachment. This identifier ensures proper allocation and tracking of raw materials in the work order.
OrganizationId Long The identifier for the organization managing this attachment. This identifier supports tracking of document associations across multiple business units.
PlannedCompletionDate Datetime The planned date and time for completing the operation or task associated with this attachment. These metrics ensure alignment with production schedules.
PlannedStartDate Datetime The planned date and time for starting the operation or task linked to this attachment. These metrics support precise scheduling and resource allocation.
ProductSerialId Long The unique identifier for the serialized product associated with this attachment. This identifier helps maintain traceability for serialized inventory.
ResourceId Long The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') associated with this attachment. This identifier ensures proper resource tracking and utilization.
SerialNumber String The serial number of the product or material linked to this attachment. This serial number ensures precise tracking of serialized components or items.
SourceHeaderReferenceId Long The reference identifier linking this attachment to the header of a source document (for example, 'purchase order' or 'production plan'). This identifier helps establish traceability.
SourceHeaderRefId Long An alternate reference identifier for the source document header. This identifier ensures compatibility with external systems or legacy integrations.
SourceLineReferenceId Long The reference identifier linking this attachment to a specific line item in the source document (for example, a purchase order line or bill-of-materials line).
SourceLineRefId Long An alternate reference identifier for the source line. This identifier supports integration with external systems and accurate tracking of resources.
SourceSystemId Long The identifier for the external system from which this attachment data originates. This identifier ensures proper synchronization of data across platforms.
Tolerance Int The allowable tolerance for variations in resource or material allocation linked to this attachment. This metric helps maintain flexibility in operations.
WoProjectNumber String The project number associated with this attachment. This number links documentation to broader project tracking and reporting.
WorkAreaId Long The unique identifier for the work area where this attachment is relevant. This identifier ensures proper allocation of documentation within specific production zones.
WorkCenterId Long The unique identifier for the work center associated with this attachment. This identifier supports tracking of documentation within specific production facilities.
WorkOrderId Long The unique identifier for the work order associated with this attachment. This identifier ensures correct linkage of documentation to work orders.
WorkOrderNumber String The user-friendly work-order number associated with this attachment. This number simplifies document identification and reporting.
WorkOrderStatusId Long The unique identifier representing the current status of the work order associated with this attachment. This identifier helps track document relevance to ongoing operations.
WoTaskNumber String The task number within the work order associated with this attachment. This number links documentation to specific tasks in the production workflow.

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