ProcessWorkOrdersProcessWorkOrderAttachment
Manages attachments related to manufacturing work orders for documentation and reference.
Columns
| Name | Type | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | A unique identifier linking the attachment to the associated process work order. |
| AttachedDocumentId [KEY] | Long | A unique identifier for the document attached to the process work order. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the attachment. |
| DatatypeCode | String | Code representing the type of data (for example, text, image, or PDF) stored in the attachment. |
| FileName | String | The name of the file attached to the process work order. |
| DmFolderPath | String | The folder path in the document management system where the attachment is stored. |
| DmDocumentId | String | A unique identifier for the document in the document management system (DMS). |
| DmVersionNumber | String | The version number of the document in the document management system. |
| Url | String | The URL linking to the location of the attachment. |
| CategoryName | String | The category assigned to the attachment, used for classification or organization. |
| UserName | String | The name of the user associated with the attachment. |
| Uri | String | The Uniform Resource Identifier (URI) pointing to the attachment. |
| FileUrl | String | The URL for accessing the attached file directly. |
| UploadedText | String | Text content uploaded as part of the attachment. |
| UploadedFileContentType | String | The content type of the uploaded file. |
| UploadedFileLength | Long | The size of the uploaded file, measured in bytes. |
| UploadedFileName | String | The name of the file uploaded as an attachment. |
| ContentRepositoryFileShared | Bool | Indicates whether the file in the content repository is shared. A value of 'true' means it is shared, while a value of 'false' means it is private. |
| Title | String | The title or label assigned to the attachment. |
| Description | String | A detailed description of the attachment, explaining its purpose or contents. |
| ErrorStatusCode | String | The error status code, if any, associated with the attachment upload or processing. |
| ErrorStatusMessage | String | A message providing details about the error, if any, associated with the attachment upload or processing. |
| CreatedBy | String | The name or identifier of the user who created the attachment. |
| CreationDate | Datetime | The date and time when the attachment was created. |
| FileContents | String | The contents of the file uploaded as part of the attachment. |
| ExpirationDate | Datetime | The date and time when the attachment is set to expire or become invalid. |
| LastUpdatedByUserName | String | The user name of the individual who last updated the attachment. |
| CreatedByUserName | String | The user name of the individual who created the attachment. |
| AsyncTrackerId | String | A unique identifier for tracking asynchronous processes related to the attachment. |
| FileWebImage | String | A web-friendly image preview of the attached file. |
| DownloadInfo | String | Information about how the attachment can be downloaded. |
| PostProcessingAction | String | Specifies the action to be performed on the attachment after processing, such as archiving or notifying users. |
| BackToBackFlag | String | Indicates whether the attachment is related to a back-to-back manufacturing process. |
| ContractMfgFlag | String | Indicates whether the attachment is associated with a contract manufacturing process. If the value is 'true', the work order involves production through a third-party manufacturer. |
| DueDays | Int | Specifies the number of days remaining until the process work order or attachment reaches its due date. |
| Finder | String | A reference mechanism or criteria to locate and identify the attachment within the system. |
| FirmPlannedFlag | String | Indicates whether the associated work order is firm planned. A firm-planned flag prevents changes to the work order by scheduling or planning processes. |
| InventoryItemId | Long | A unique identifier for the inventory item linked to the attachment, used to track materials or finished goods associated with the work order. |
| ItemNumber | String | A unique number assigned to the inventory item associated with the attachment. |
| MaterialItemId | Long | A unique identifier for the material item linked to the attachment. This identifier tracks raw materials or components used in the process work order. |
| OrganizationId | Long | A unique identifier for the organization where the process work order is executed. This identifier helps distinguish between different facilities or inventory locations. |
| PlannedCompletionDate | Datetime | The planned completion date and time for the process work order or the attached document. This is set by the scheduling application and must align with the work order timeline. |
| PlannedStartDate | Datetime | The planned start date and time for the process work order or the attached document. This identifier is determined by the scheduling application and must fit within the work order's timeframe. |
| ProductSerialId | Long | A unique identifier for the product serial number associated with the process work order attachment. This identifier enables serialized tracking of finished goods or components. |
| ResourceId | Long | A unique identifier for the resource, such as equipment or personnel, linked to the process work order attachment. |
| SerialNumber | String | The serial number associated with the inventory item or finished product in the process work order attachment. Used for tracking and traceability. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header that links the attachment to its originating transaction or external system. |
| SourceHeaderRefId | Long | An alternate unique identifier for the source header reference linked to the attachment. |
| SourceLineReferenceId | Long | A unique identifier for the source line that links the attachment to a specific line item in the source document. |
| SourceLineRefId | Long | An alternate unique identifier for the source line reference linked to the attachment. |
| SourceSystemId | Long | A unique identifier for the source system from which the attachment or related data originates. |
| Tolerance | Int | The allowable tolerance level for the work order or attachment, such as variances in quantity or timing. |
| WoProjectNumber | String | The project number associated with the process work order attachment, used for project-specific tracking and reporting. |
| WorkAreaId | Long | A unique identifier for the work area where the process work order is executed. Work areas group resources within the manufacturing facility. |
| WorkCenterId | Long | A unique identifier for the work center where the process work order operations occur. This identifier tracks the specific area or equipment used. |
| WorkOrderId | Long | A unique identifier for the work order associated with the attachment. This identifier serves as a primary key for referencing the work order. |
| WorkOrderNumber | String | A unique number assigned to the work order associated with the attachment. This number helps identify and track the work order. |
| WorkOrderStatusId | Long | A unique identifier for the status of the work order linked to the attachment. Statuses indicate whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | The task number associated with the process work order attachment. This number is used for task-level tracking within the work order. |