WorkOrdersWorkOrderResourceWorkOrderOperationResourceAttachment
Stores documents attached to resources used in work order operations for improved resource documentation.
Columns
| Name | Type | SupportedFinders | 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 | WorkOrderByModifiedDate | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | 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 | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the attachment is related to a contract manufacturing process. This flag helps in tracking documentation for outsourced production activities. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | 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 | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with this attachment. This identifier supports traceability of materials or components. |
| ItemNumber | String | WorkOrderB2BCM | The specific item number linked to the attachment. This number ensures accurate tracking of materials or resources in the work order process. |
| MaterialItemId | Long | WorkOrderByComponent | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The identifier for the organization managing this attachment. This identifier supports tracking of document associations across multiple business units. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time for completing the operation or task associated with this attachment. These metrics ensure alignment with production schedules. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | 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 | WorkOrderBySerial | The unique identifier for the serialized product associated with this attachment. This identifier helps maintain traceability for serialized inventory. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | 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 | WorkOrderBySerialNumber | 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 | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference identifier for the source document header. This identifier ensures compatibility with external systems or legacy integrations. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference identifier for the source line. This identifier supports integration with external systems and accurate tracking of resources. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier for the external system from which this attachment data originates. This identifier ensures proper synchronization of data across platforms. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance for variations in resource or material allocation linked to this attachment. This metric helps maintain flexibility in operations. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with this attachment. This number links documentation to broader project tracking and reporting. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center associated with this attachment. This identifier supports tracking of documentation within specific production facilities. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order associated with this attachment. This identifier ensures correct linkage of documentation to work orders. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The user-friendly work-order number associated with this attachment. This number simplifies document identification and reporting. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | 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 | FindByProjectNumberTaskNumber | The task number within the work order associated with this attachment. This number links documentation to specific tasks in the production workflow. |