ProcessWorkOrdersProcessWorkOrderMaterialMaterialAttachment
Handles attachments related to input materials, providing additional context and documentation for material usage.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to the material attachments, allowing tracking of related documentation for the work order. | |
| ProcessworkordermaterialWorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the specific material within a work order operation that is associated with the attachment. | |
| AttachedDocumentId [KEY] | Long | The unique identifier for the document attached to the material, enabling traceability and reference to associated documents. | |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when the material attachment was last updated, providing an audit trail for changes. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the material attachment record. | |
| DatatypeCode | String | Code representing the type of data stored in the attachment, such as 'PDF', 'TEXT', or 'IMAGE'. | |
| FileName | String | The name of the file attached to the material, which can include additional context or identification for the document. | |
| DmFolderPath | String | The folder path in the document management system (DMS) where the attachment is stored. | |
| DmDocumentId | String | The unique identifier for the document within the document management system, ensuring a direct reference to the file. | |
| DmVersionNumber | String | The version number of the document in the document management system, allowing tracking of document updates. | |
| Url | String | The URL linking to the attachment's location in the document management system or repository. | |
| CategoryName | String | The category or classification assigned to the attachment, which helps in organizing and searching for documents. | |
| UserName | String | The name of the user associated with the attachment, such as the uploader or creator. | |
| Uri | String | The Uniform Resource Identifier (URI) that specifies the location of the attachment in a standardized format. | |
| FileUrl | String | The direct URL for accessing the attached file, often used for downloading or viewing. | |
| UploadedText | String | The text content of the uploaded file. This content provides searchable or readable information within the attachment. | |
| UploadedFileContentType | String | The content type of the uploaded file, specifying the file format. | |
| UploadedFileLength | Long | The size of the uploaded file, measured in bytes, indicating the file's storage requirements. | |
| UploadedFileName | String | The name of the file uploaded as an attachment, which can differ from its stored name in the system. | |
| ContentRepositoryFileShared | Bool | Indicates whether the file stored in the content repository is shared. A value of 'true' means the file is accessible to multiple users or systems. | |
| Title | String | The title or label assigned to the attachment, often summarizing its purpose or content. | |
| Description | String | A detailed description of the attachment, explaining its relevance to the material or work order operation. | |
| ErrorStatusCode | String | The error code, if any, associated with the attachment upload or processing, useful for troubleshooting. | |
| ErrorStatusMessage | String | A descriptive message providing details about an error encountered during the attachment's upload or processing. | |
| CreatedBy | String | The name or identifier of the user who created the attachment record in the system. | |
| CreationDate | Datetime | The date and time when the attachment record was created in the system. | |
| FileContents | String | The contents of the file uploaded as an attachment, stored as text or binary data. | |
| ExpirationDate | Datetime | The date when the attachment is set to expire or become invalid. | |
| LastUpdatedByUserName | String | The username of the individual who last updated the attachment record. | |
| CreatedByUserName | String | The username of the individual who created the attachment record. | |
| AsyncTrackerId | String | The unique identifier used for tracking asynchronous processes related to the material attachment, such as uploads or processing workflows. | |
| FileWebImage | String | A web-friendly preview or thumbnail image of the attached file, providing a quick visual reference for the document. | |
| DownloadInfo | String | Details or metadata related to downloading the attached file, such as download URL or access permissions. | |
| PostProcessingAction | String | Specifies actions to be taken on the attachment after processing, such as archiving, sharing, or notifying users. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the material attachment is associated with a back-to-back manufacturing process, directly linking material supply to customer demand. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the material attachment is linked to contract manufacturing, where production tasks are outsourced to an external manufacturer. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the material attachment is required or reaches its due date. |
| Finder | String | The search criteria or mechanism used to locate the material attachment within the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the material attachment is associated with a firm planned work order, preventing changes by scheduling or planning processes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with the material attachment, enabling traceability and inventory management. |
| ItemNumber | String | WorkOrderB2BCM | The unique number assigned to the inventory item associated with the material attachment, aiding in identification and tracking. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the specific material item linked to the attachment, providing precise tracking of raw materials or components. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization where the material attachment is being used, representing a specific facility or inventory location. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned completion date and time for the operation or work order associated with the material attachment. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned start date and time for the operation or work order associated with the material attachment. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the product serial number linked to the material attachment, enabling serialized tracking of products or materials. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, equipment, personnel) associated with the material attachment. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number associated with the material or product linked to the attachment, used for tracking and traceability. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source header linking the material attachment to its originating transaction or external system. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate unique identifier for the source header reference associated with the material attachment. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source line linking the material attachment to a specific line item in the source document. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate unique identifier for the source line reference associated with the material attachment. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the source system from which the material attachment or related data originates. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance level associated with the material attachment, such as variances in quantity or specifications. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the material attachment, used for project-specific tracking and reporting. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area where the material attachment is used, representing a specific grouping of resources or activities. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center where the material attachment is applied, enabling tracking of location-specific tasks or resources. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order associated with the material attachment, enabling linkage to a specific job or operation. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The unique number assigned to the work order associated with the material attachment, aiding in identification and tracking. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier for the status of the work order linked to the material attachment, indicating whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The task number within the work order associated with the material attachment, enabling task-level tracking and reporting. |