CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175