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. |