WorkOrdersWorkOrderAttachment
Manages documents attached to work orders, providing comprehensive documentation for production.
Columns
Name | Type | Description |
WorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the attachment to its associated work order. This identifier ensures all attachments are correctly mapped to the relevant work order for traceability. |
AttachedDocumentId [KEY] | Long | The unique identifier for the attached document associated with the work order. This identifier allows tracking and referencing of specific attachments within the system. |
LastUpdateDate | Datetime | The date and time when the attachment record was last updated. This metric ensures traceability and reflects recent changes to the attachment. |
LastUpdatedBy | String | The username or identifier of the person who last updated the attachment. This identifier provides accountability for modifications made to the attachment record. |
DatatypeCode | String | Specifies the data type of the attached file (for example, 'PDF,' 'Image,' or 'Text'). This categorization ensures proper handling and rendering of the attachment. |
FileName | String | The name of the attached file. This name provides a reference for identifying and retrieving the file. |
DmFolderPath | String | The folder path in the document management system where the attachment is stored. This supports organization and retrieval of attachments. |
DmDocumentId | String | The unique identifier for the document in the document management system. This identifier ensures proper integration and referencing within external repositories. |
DmVersionNumber | String | The version number of the document in the document management system. This number supports version control for attachments. |
Url | String | The Uniform Resource Locator (URL) for accessing the attachment. This URL provides a direct link to the file for viewing or downloading. |
CategoryName | String | The category or classification of the attachment (for example, 'Design Document' or 'Inspection Report'). This classification helps in organizing attachments based on their purpose. |
UserName | String | The username of the person who uploaded or modified the attachment. This name ensures accountability and traceability. |
Uri | String | The Uniform Resource Identifier (URI) that uniquely identifies the attachment. This URI provides a global reference for accessing the attachment. |
FileUrl | String | The specific URL for accessing the attached file. This URL facilitates integration with web-based tools or applications. |
UploadedText | String | The textual content of the uploaded file. This field supports searching and referencing textual data within attachments. |
UploadedFileContentType | String | The content type of the uploaded file. This ensures correct rendering and processing of the file. |
UploadedFileLength | Long | The size of the uploaded file in bytes. This metric helps monitor storage usage and identify large attachments. |
UploadedFileName | String | The original name of the uploaded file. This name provides a reference for identifying and verifying the file. |
ContentRepositoryFileShared | Bool | Indicates whether the attached file is shared within the content repository. If the value is 'true', the file is accessible to multiple users or systems. |
Title | String | The title of the attachment. This field provides a descriptive label for the file, making it easier to identify in lists or reports. |
Description | String | A detailed description of the attachment, explaining its purpose or content. This description helps users understand the relevance of the file. |
ErrorStatusCode | String | Specifies the error code, if any, associated with the attachment process. This error code helps in identifying issues during file upload or retrieval. |
ErrorStatusMessage | String | Provides the error message, if any, associated with the attachment process. This error message helps in troubleshooting issues with file handling. |
CreatedBy | String | The username or identifier of the person who created the attachment record. This identifier ensures accountability and traceability for file creation. |
CreationDate | Datetime | The date and time when the attachment record was created. These metrics support audit trails and historical analysis. |
FileContents | String | The actual content of the attached file. This field is used for storing inline file data when direct access to the file system is unavailable. |
ExpirationDate | Datetime | The date when the attachment expires. This metric ensures that outdated or irrelevant files are automatically managed or removed. |
LastUpdatedByUserName | String | The username of the person who most recently updated the attachment record. This name provides a user-friendly reference for tracking modifications. |
CreatedByUserName | String | The username of the person who created the attachment record. This name provides a user-friendly reference for tracking the origin of the file. |
AsyncTrackerId | String | The identifier used for tracking asynchronous processes related to the attachment. This identifier supports integration with background processing tasks. |
FileWebImage | String | The Base64-encoded image of the file for web display purposes. This field enables quick previews of attached files in web interfaces. |
DownloadInfo | String | A JSON object containing information about the download (for example, file size, location, or metadata). This JSON object supports structured data handling for attachments. |
PostProcessingAction | String | Specifies actions to be taken after processing the attachment (for example, 'Archive' or 'Share'). This field supports workflow automation. |
BackToBackFlag | String | Indicates whether the attachment is part of a back-to-back process. This flag helps identify files tied to specific orders or customer demands. |
ContractMfgFlag | String | Indicates whether the work order is part of a contract manufacturing process. This field helps identify work orders tied to outsourced manufacturing activities. |
DueDays | Int | The number of days remaining until the work order attachment is due for review or action. This metric helps prioritize tasks associated with attachments. |
Finder | String | A utility field enabling advanced search and filtering capabilities for attachments. This field helps users efficiently locate specific attachment records. |
FirmPlannedFlag | String | Indicates whether the work order associated with the attachment is firm planned. If the value is 'true', the work order and its details are locked and not subject to changes from automated planning processes. |
InventoryItemId | Long | The unique identifier for the inventory item associated with the work order. This identifier ensures accurate linkage of attachments to their corresponding inventory records. |
ItemNumber | String | The unique number of the inventory item associated with the work order. This number provides a clear reference for identifying related items or materials. |
MaterialItemId | Long | The unique identifier for the material item associated with the work order. This identifier ensures that attachments are tied to the correct materials. |
OrganizationId | Long | The unique identifier for the inventory organization managing the work order. This identifier supports multi-organization workflows and ensures proper segmentation of attachment records. |
PlannedCompletionDate | Datetime | The scheduled completion date for the work order associated with the attachment. This metric ensures alignment between attachments and production timelines. |
PlannedStartDate | Datetime | The scheduled start date for the work order associated with the attachment. This metric supports proper planning and scheduling of attachment-related activities. |
ProductSerialId | Long | The unique identifier for the product serial number associated with the work order. This identifier supports detailed tracking of serialized products tied to attachments. |
ResourceId | Long | The unique identifier for the resource associated with the work order. This identifier ensures proper allocation and monitoring of resources related to attachments. |
SerialNumber | String | The serial number of the product associated with the work order attachment. This serial number provides traceability for serialized items in the work order process. |
SourceHeaderReferenceId | Long | The unique identifier for the source header reference linked to the work order. This identifier field ensures attachments are associated with their originating transactions or documents. |
SourceHeaderRefId | Long | An alternative identifier for the source header reference, supporting flexible integration with external systems. |
SourceLineReferenceId | Long | The unique identifier for the source line reference associated with the work order. This identifier ensures attachments are tied to specific line items from originating documents. |
SourceLineRefId | Long | An alternative identifier for the source line reference, supporting flexible integration with external systems. |
SourceSystemId | Long | The unique identifier for the source system that created the work order. This identifier ensures traceability across integrated systems. |
Tolerance | Int | The allowed deviation (in days) for completing tasks associated with the work order attachment. This metric ensures that minor delays are acceptable within defined thresholds. |
WoProjectNumber | String | The unique project number associated with the work order. This number ties attachments to specific projects for better tracking and reporting. |
WorkAreaId | Long | The unique identifier for the work area associated with the work order. This identifier ensures attachments are linked to specific operational zones. |
WorkCenterId | Long | The unique identifier for the work center associated with the work order. This identifier helps allocate and monitor resources related to the attachments. |
WorkOrderId | Long | The primary key uniquely identifying the work order associated with the attachment. This primary key ensures traceability and accurate mapping of attachment records to work orders. |
WorkOrderNumber | String | The unique number assigned to the work order. This number serves as a reference for identifying and tracking attachments linked to specific work orders. |
WorkOrderStatusId | Long | The unique identifier for the status of the work order associated with the attachment. This identifier ensures attachments are aligned with the overall status of the work order. |
WoTaskNumber | String | The unique task number associated with the work order. This number provides detailed tracking of tasks related to attachments within the work order. |