ProcessWorkOrdersProcessWorkOrderMaterialMaterialAttachment
Handles attachments related to input materials, providing additional context and documentation for material usage.
Columns
| Name | Type | 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 | 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 | Indicates whether the material attachment is associated with a back-to-back manufacturing process, directly linking material supply to customer demand. |
| ContractMfgFlag | String | Indicates whether the material attachment is linked to contract manufacturing, where production tasks are outsourced to an external manufacturer. |
| DueDays | Int | 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 | Indicates whether the material attachment is associated with a firm planned work order, preventing changes by scheduling or planning processes. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the material attachment, enabling traceability and inventory management. |
| ItemNumber | String | The unique number assigned to the inventory item associated with the material attachment, aiding in identification and tracking. |
| MaterialItemId | Long | The unique identifier for the specific material item linked to the attachment, providing precise tracking of raw materials or components. |
| OrganizationId | Long | The unique identifier for the organization where the material attachment is being used, representing a specific facility or inventory location. |
| PlannedCompletionDate | Datetime | The planned completion date and time for the operation or work order associated with the material attachment. |
| PlannedStartDate | Datetime | The planned start date and time for the operation or work order associated with the material attachment. |
| ProductSerialId | Long | The unique identifier for the product serial number linked to the material attachment, enabling serialized tracking of products or materials. |
| ResourceId | Long | The unique identifier for the resource (for example, equipment, personnel) associated with the material attachment. |
| SerialNumber | String | The serial number associated with the material or product linked to the attachment, used for tracking and traceability. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header linking the material attachment to its originating transaction or external system. |
| SourceHeaderRefId | Long | An alternate unique identifier for the source header reference associated with the material attachment. |
| SourceLineReferenceId | Long | The unique identifier for the source line linking the material attachment to a specific line item in the source document. |
| SourceLineRefId | Long | An alternate unique identifier for the source line reference associated with the material attachment. |
| SourceSystemId | Long | The unique identifier for the source system from which the material attachment or related data originates. |
| Tolerance | Int | The allowable tolerance level associated with the material attachment, such as variances in quantity or specifications. |
| WoProjectNumber | String | The project number associated with the material attachment, used for project-specific tracking and reporting. |
| WorkAreaId | Long | The unique identifier for the work area where the material attachment is used, representing a specific grouping of resources or activities. |
| WorkCenterId | Long | The unique identifier for the work center where the material attachment is applied, enabling tracking of location-specific tasks or resources. |
| WorkOrderId | Long | The unique identifier for the work order associated with the material attachment, enabling linkage to a specific job or operation. |
| WorkOrderNumber | String | The unique number assigned to the work order associated with the material attachment, aiding in identification and tracking. |
| WorkOrderStatusId | Long | 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 | The task number within the work order associated with the material attachment, enabling task-level tracking and reporting. |