ProcessWorkOrdersProcessWorkOrderOutputOutputAttachment
Manages attachments linked to operation outputs, providing documentation for output-related processes.
Columns
| Name | Type | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to its output attachments, enabling tracking of associated documents and files. |
| ProcessworkorderoutputWorkOrderOperationOutputId [KEY] | Long | The unique identifier for the specific output within a work order operation that is linked to the attachment. Ensures the document is tied to the correct production output. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attached document. Tracks the document in the document management system and links it to the output. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated. These metrics provide an audit trail for modifications to the attachment. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the attachment record. This identifier ensures accountability for changes made to the record. |
| DatatypeCode | String | Specifies the type of data in the attachment (for example, 'PDF,' 'TEXT,' or 'IMAGE'), helping to identify the file format. |
| FileName | String | The name of the file attached to the output. This name helps identify the document for reference or review. |
| DmFolderPath | String | The folder path in the document management system (DMS) where the attachment is stored. This path provides the logical location for retrieval. |
| DmDocumentId | String | The unique identifier for the document in the document management system, enabling direct access to the stored file. |
| DmVersionNumber | String | The version number of the document in the document management system. This number tracks changes and updates to the file. |
| Url | String | The URL linking to the attachment in the document management system. This URL enables quick access to the document. |
| CategoryName | String | Specifies the category or classification of the attachment, such as 'Technical Manual' or 'Inspection Report,' helping to organize documents. |
| UserName | String | The name of the user associated with the attachment, such as the uploader or creator of the file. |
| Uri | String | The Uniform Resource Identifier (URI) for the attachment. This URI provides a standardized location reference for the document. |
| FileUrl | String | The direct URL for accessing or downloading the attached file. This URL facilitates easy retrieval of the document. |
| UploadedText | String | Text content extracted from the uploaded file. The extracted text is useful for searchable attachments or text-based documents. |
| UploadedFileContentType | String | Specifies the content type of the uploaded file, indicating the file format. |
| UploadedFileLength | Long | The size of the uploaded file in bytes. This value helps in understanding storage requirements and file properties. |
| UploadedFileName | String | The name of the file as uploaded by the user, which might differ from the stored file name in the document management system. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared in the content repository. A value of 'true' means the file is accessible by multiple users or systems. |
| Title | String | The title of the attachment, often summarizing the purpose or content of the document. |
| Description | String | A detailed description of the attachment, explaining its relevance or purpose in the context of the work order output. |
| ErrorStatusCode | String | Specifies the error code, if any, related to the attachment upload or processing. This error code is useful for troubleshooting issues. |
| ErrorStatusMessage | String | A descriptive message providing details about errors encountered during attachment upload or processing. |
| CreatedBy | String | The name or identifier of the user who created the attachment record. This identifier ensures accountability for the initial upload. |
| CreationDate | Datetime | The date and time when the attachment record was created. These metrics provide a historical reference for when the document was added. |
| FileContents | String | The actual content of the uploaded file, stored as text or binary data. This attribute is used when file content needs to be retained within the system. |
| ExpirationDate | Datetime | The date when the attachment is set to expire or become invalid. This metric is useful for managing temporary or time-sensitive documents. |
| LastUpdatedByUserName | String | The username of the individual who last updated the attachment record. This username adds another layer of traceability. |
| CreatedByUserName | String | The username of the individual who created the attachment record. This username helps in identifying the uploader. |
| AsyncTrackerId | String | The unique identifier used for tracking asynchronous operations related to the attachment, such as uploads or processing tasks. |
| FileWebImage | String | A web-friendly preview or thumbnail image of the attached file, useful for quickly visualizing the document's content. |
| DownloadInfo | String | Details or metadata about downloading the attached file, such as permissions or download URLs. |
| PostProcessingAction | String | Specifies any actions to be taken on the attachment after processing, such as archiving or notifying users. |
| BackToBackFlag | String | Indicates whether the output attachment is associated with a back-to-back manufacturing process, where production is directly linked to specific customer demand. |
| ContractMfgFlag | String | Indicates whether the output attachment is related to contract manufacturing, where production tasks are outsourced to an external supplier or partner. |
| DueDays | Int | Specifies the number of days remaining until the output or attachment reaches its due date, helping to monitor deadlines and manage timelines. |
| Finder | String | Represents the search criteria or mechanism used to locate the output attachment within the system for quick retrieval. |
| FirmPlannedFlag | String | Indicates whether the output or its attachment is firm planned, meaning that changes to the schedule or allocation are restricted. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the output attachment. This identifier tracks the item in the inventory system and links it to the document. |
| ItemNumber | String | The unique number assigned to the inventory item associated with the output attachment. This number helps in identification and traceability of the related item. |
| MaterialItemId | Long | The unique identifier for the material item associated with the output attachment, allowing linkage between the material and its corresponding documentation. |
| OrganizationId | Long | The unique identifier for the organization where the output attachment is used. This identifier links the attachment to a specific production facility or entity. |
| PlannedCompletionDate | Datetime | The planned date and time for completing the work order output associated with the attachment. These metrics help in tracking progress and scheduling. |
| PlannedStartDate | Datetime | The planned date and time for starting the work order output associated with the attachment. These metrics ensure that production schedules are adhered to. |
| ProductSerialId | Long | The unique identifier for the product serial number linked to the output attachment. This identifier facilitates serialized tracking of output items. |
| ResourceId | Long | The unique identifier for the resource (for example, equipment or personnel) associated with the output attachment. This identifier tracks which resource is linked to the attachment. |
| SerialNumber | String | The serial number of the item associated with the output attachment, enabling precise tracking and traceability. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header linking the output attachment to its originating transaction, such as a sales order or production request. |
| SourceHeaderRefId | Long | An alternate unique identifier for the source header associated with the output attachment, offering additional linkage and traceability. |
| SourceLineReferenceId | Long | The unique identifier for the source line linking the output attachment to a specific line item in the originating document, such as a sales order line. |
| SourceLineRefId | Long | An alternate unique identifier for the source line reference associated with the output attachment, providing additional traceability. |
| SourceSystemId | Long | The unique identifier for the source system that provided the data related to the output attachment. This identifier is useful for integrating external systems or upstream transactions. |
| Tolerance | Int | Defines the allowable tolerance for the associated output, such as acceptable variances in quantity, quality, or delivery timing. |
| WoProjectNumber | String | The project number associated with the output attachment. This number links the attachment to project-specific deliverables or objectives. |
| WorkAreaId | Long | The unique identifier for the work area where the output or its attachment is used. This identifier helps in organizing attachments by production zones. |
| WorkCenterId | Long | The unique identifier for the work center where the output or its attachment is managed. This identifier tracks the attachment at the specific location. |
| WorkOrderId | Long | The unique identifier for the work order associated with the output attachment. This identifier links the attachment to the specific job or operation. |
| WorkOrderNumber | String | The unique number assigned to the work order associated with the output attachment. This number aids in tracking attachments within broader production workflows. |
| WorkOrderStatusId | Long | The unique identifier for the status of the work order linked to the output attachment. This identifier indicates whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | The task number within the work order associated with the output attachment. This attribute enables task-level tracking and document association. |