ProcessWorkOrdersOperationMaterialMaterialAttachment
ProcessWorkOrdersOperationMaterialMaterialAttachment
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | Parent work order identifier (references process work order). | |
| OperationWorkOrderOperationId [KEY] | Long | Parent operation identifier for the work order. | |
| MaterialWorkOrderOperationMaterialId [KEY] | Long | Identifier of the material record within the operation (parent). | |
| AttachedDocumentId [KEY] | Long | Unique identifier of the attached document. | |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | Date/time when this attachment record was last updated (UTC). |
| LastUpdatedBy | String | User who last updated this attachment record. | |
| DatatypeCode | String | Code indicating the attachment data type (e.g., file, URL). | |
| FileName | String | Original file name of the attachment. | |
| DmFolderPath | String | Document management folder path for the attachment. | |
| DmDocumentId | String | Document ID from the document management system. | |
| DmVersionNumber | String | Version number of the source document. | |
| Url | String | URL of the attachment (for web link attachments). | |
| CategoryName | String | The category of the attachment. | |
| UserName | String | The login credentials of the user who created the attachment. | |
| Uri | String | The URI of a Topology Manager type attachment. | |
| FileUrl | String | The URI of the file. | |
| UploadedText | String | The text content for a new text attachment. | |
| UploadedFileContentType | String | The content type of the attachment. | |
| UploadedFileLength | Long | The size of the attachment file. | |
| UploadedFileName | String | The name to assign to a new attachment file. | |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared | |
| Title | String | The title of the attachment. | |
| Description | String | The description of the attachment. | |
| ErrorStatusCode | String | The error code, if any, for the attachment. | |
| ErrorStatusMessage | String | The error message, if any, for the attachment. | |
| CreatedBy | String | The user who created the record. | |
| CreationDate | Datetime | The date when the record was created. | |
| FileContents | String | The contents of the attachment. | |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. | |
| LastUpdatedByUserName | String | The user name who last updated the record. | |
| CreatedByUserName | String | The user name who created the record. | |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. | |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. | |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. | |
| PostProcessingAction | String | The name of the action that can be performed after an attachment is uploaded. | |
| BackToBackFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the work order is back-to-back (back-to-back flag). |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Flag indicating contract manufacturing status. |
| DueDays | Int | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Number of days until (or past) the due date for the work order. |
| Finder | String | Finder identifier used to select specific finder logic or view. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Flag indicating whether the work order is firm planned. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByModifiedDate, WorkOrderByWorkAreaWorkCenter | Identifier of the inventory item associated with the work order or material. |
| ItemNumber | String | WorkOrderB2BCM | Item number or SKU associated with the work order/material. |
| MaterialItemId | Long | WorkOrderByComponent | Identifier of the material item used in the operation. |
| OrganizationId | Long | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderBySerialNumber, WorkOrderByWorkAreaWorkCenter, WorkOrderByWorkOrderNumber | Identifier of the organization responsible for the work order. |
| PlannedCompletionDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned completion date/time for the work order (UTC). |
| PlannedStartDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned start date/time for the work order (UTC). |
| ProductSerialId | Long | WorkOrderBySerial | Identifier for the product serial number associated with the work order. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | Identifier of the resource assigned to the operation/work order. |
| SerialNumber | String | WorkOrderBySerialNumber | Serial number of the product or component. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier for the source header associated with this record. |
| SourceHeaderRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference identifier for the source header (alternate field). |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier for the source line associated with this record. |
| SourceLineRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference identifier for the source line (alternate field). |
| SourceSystemId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier of the source system that provided this record. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Tolerance value for the work order/material (units depend on context). |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | Project number associated with the work order. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier of the work area where the operation is scheduled. |
| WorkCenterId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier of the work center where the operation will be performed. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | Primary identifier of the work order. |
| WorkOrderNumber | String | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkOrderNumber | Human-readable work order number/code. |
| WorkOrderStatusId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier representing the current status of the work order. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | Task number within the work order (if applicable). |