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