ProcessWorkOrdersProcessWorkOrderResourceResourceAttachment
Manages documentation and attachments related to resources used in operations, improving resource transparency.
Columns
Name | Type | Description |
ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to its resource attachments, enabling tracking of documents and files related to work order resources. |
ProcessworkorderresourceWorkOrderOperationResourceId [KEY] | Long | The unique identifier for the resource within the work order operation associated with the attachment. This identifier links the document to a specific resource. |
AttachedDocumentId [KEY] | Long | The unique identifier for the document attached to the resource. This identifier tracks the attachment in the document management system. |
LastUpdateDate | Datetime | The date and time when the resource attachment record was last updated. These metrics provide a historical reference for changes. |
LastUpdatedBy | String | The name or identifier of the user who last updated the attachment record. This identifier ensures accountability and traceability for modifications. |
DatatypeCode | String | Specifies the type of data in the attachment (for example, 'PDF,' 'IMAGE,' or 'TEXT'). This type indicates the format of the file. |
FileName | String | The name of the file attached to the resource. This name helps users identify and reference the attached document. |
DmFolderPath | String | The folder path in the document management system 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. This identifier enables direct access to the stored file. |
DmVersionNumber | String | The version number of the document in the document management system. This number tracks revisions and updates to the file. |
Url | String | The URL linking to the document in the document management system. Enables quick access to the attached file. |
CategoryName | String | Specifies the category or classification of the attachment, such as 'Technical Manual' or 'Inspection Report.' This classification helps organize documents. |
UserName | String | The name of the user associated with the attachment, such as the uploader or owner of the document. |
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 | The text content extracted from the uploaded file. This extracted content is useful for searchable attachments or text-based documents. |
UploadedFileContentType | String | Specifies the content type of the uploaded file. This value indicates the format of the file. |
UploadedFileLength | Long | The size of the uploaded file in bytes. This value helps understand 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 (DMS). |
ContentRepositoryFileShared | Bool | Indicates whether the file is shared within the content repository. The value 'true' means it is accessible to multiple users or systems. |
Title | String | The title of the attachment, often summarizing its purpose or content for quick identification. |
Description | String | A detailed description of the attachment, explaining its relevance or purpose in the context of the work order resource. |
ErrorStatusCode | String | Specifies the error code, if any, related to the attachment upload or processing. UThis 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 provides accountability for the initial upload. |
CreationDate | Datetime | The date and time when the attachment record was created. These metrics help track when the document was added to the system. |
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 in the system. |
ExpirationDate | Datetime | The date when the attachment is set to expire or become invalid. This metric is useful for managing 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 identify 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.This preview is useful for quickly visualizing the content of the document. |
DownloadInfo | String | Details or metadata about downloading the attached file, such as permissions, restrictions, or download URLs. |
PostProcessingAction | String | Specifies the action to be performed on the attachment after processing, such as archiving, notification, or updating metadata. |
BackToBackFlag | String | Indicates whether the resource attachment is part of a back-to-back process, directly linking the attachment to specific customer-driven operations. |
ContractMfgFlag | String | Indicates whether the resource attachment is associated with contract manufacturing, where production is outsourced to external suppliers or partners. |
DueDays | Int | The number of days remaining until the resource attachment is due for use or processing. This value helps in scheduling and prioritization. |
Finder | String | Represents the search mechanism or criteria used to locate specific resource attachments within the system for quick access. |
FirmPlannedFlag | String | Indicates whether the attachment or associated resource is firm planned, preventing changes to its allocation or schedule. |
InventoryItemId | Long | The unique identifier for the inventory item associated with the resource attachment. This identifier links the attachment to specific materials used in production. |
ItemNumber | String | The unique number assigned to the inventory item associated with the resource attachment. This number aids in identification and tracking of related items. |
MaterialItemId | Long | The unique identifier for the material item related to the resource attachment. This identifier tracks materials associated with the attachment for resource usage. |
OrganizationId | Long | The unique identifier for the organization where the resource attachment is managed. This identifier represents the production facility or warehouse. |
PlannedCompletionDate | Datetime | The planned date and time for completing the operation or task associated with the resource attachment. These metrics support scheduling and tracking. |
PlannedStartDate | Datetime | The planned date and time for starting the operation or task linked to the resource attachment. These metrics ensure alignment with production schedules. |
ProductSerialId | Long | The unique identifier for the product serial number associated with the resource attachment. This identifier enables serialized tracking of items linked to the attachment. |
ResourceId | Long | The unique identifier for the resource associated with the attachment. This identifier tracks which resource is linked to the document for production purposes. |
SerialNumber | String | The serial number of the resource or item associated with the attachment. This serial number provides precise tracking and traceability for serialized items. |
SourceHeaderReferenceId | Long | The unique identifier for the source header linking the resource 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 attachment, providing additional traceability to upstream systems. |
SourceLineReferenceId | Long | The unique identifier for the source line linking the resource attachment to a specific line item in the originating transaction. |
SourceLineRefId | Long | An alternate unique identifier for the source line associated with the resource attachment. This identifier offers additional traceability. |
SourceSystemId | Long | The unique identifier for the source system that provided the data related to the resource attachment. This identifier is useful for tracking integrations with external systems. |
Tolerance | Int | Specifies the allowable tolerance level for the resource or its associated attachment. This attribute helps manage acceptable variances in usage or delivery. |
WoProjectNumber | String | The project number associated with the resource attachment. This number links the attachment to specific project-related tasks or deliverables. |
WorkAreaId | Long | The unique identifier for the work area where the resource attachment is used. This identifier helps organize attachments by production zones. |
WorkCenterId | Long | The unique identifier for the work center where the resource attachment is associated. This identifier tracks attachments at specific production locations. |
WorkOrderId | Long | The unique identifier for the work order linked to the resource attachment. This identifier connects the attachment to broader production activities. |
WorkOrderNumber | String | The unique number assigned to the work order associated with the resource attachment. This number aids in tracking attachments within workflows. |
WorkOrderStatusId | Long | The unique identifier for the current status of the work order linked to the resource 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 resource attachment. This attribute tracks attachments at the task level for production steps. |