SalesOrdersForOrderHublinesattachments
Manages documents and files attached to both sales order headers and order lines for better traceability.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the attachment to the parent order and enabling cross-referencing between order lines and attachments. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the order, used to track the specific line for which the attachment is provided. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the attached document, ensuring that each attachment can be distinctly referenced in the system. |
| LastUpdateDate | Datetime | Date and time when the attachment was last updated, providing a timestamp for when the last changes were made to the attachment record. |
| LastUpdatedBy | String | Username of the person who last updated the attachment details, enabling traceability for changes made to the attachment record. |
| DatatypeCode | String | Abbreviation that identifies the data type of the attachment, used to categorize the attachment based on its content type (for example, PDF, image). |
| FileName | String | Name of the attachment file, helping to identify the file in the system and allowing users to locate or download the attachment. |
| DmFolderPath | String | Path to the folder where the attachment is stored, used to locate the directory containing the file within the document management system. |
| DmDocumentId | String | Unique identifier for the document in the document management system, ensuring that the attachment is accurately linked to its corresponding document. |
| DmVersionNumber | String | Version number of the attached document, used to track and differentiate between different versions of the same document. |
| Url | String | URL (Uniform Resource Locator) that links directly to the attachment file, allowing users to access or download the attachment via the web. |
| CategoryName | String | Name of the category assigned to the attachment, used to classify attachments and facilitate searches or filtering by category. |
| UserName | String | Username of the person who uploaded the attachment, providing accountability and traceability for who added the file. |
| Uri | String | URI (Uniform Resource Identifier) that uniquely identifies the attachment file, offering a standard reference for the attachment within the system. |
| FileUrl | String | URL that locates the attachment file, ensuring users can access the file directly via the provided link. |
| UploadedText | String | Text or content that the attachment contains, offering a brief summary or description of the attachment’s contents. |
| UploadedFileContentType | String | Content type of the uploaded attachment file, describing its format. |
| UploadedFileLength | Long | Length of the attachment file, in bytes, providing information on the size of the file for storage and transfer considerations. |
| UploadedFileName | String | Name of the file that was uploaded, which may include the document title, extension, or any user-defined name. |
| ContentRepositoryFileShared | Bool | Flag indicating whether the attachment file is shared in the content repository. If true, the file is shared; if false, it is not. |
| Title | String | Title of the attachment, used for identifying and describing the content of the file when it is displayed in user interfaces. |
| Description | String | Detailed description of the attachment, providing context or additional information about the file’s contents or purpose. |
| ErrorStatusCode | String | Code representing the status of the attachment upload process, used to identify any issues encountered during the upload. |
| ErrorStatusMessage | String | Message describing any error that occurred during the attachment upload, helping to troubleshoot and resolve issues. |
| CreatedBy | String | Username of the person who created the attachment record, ensuring accountability and traceability for the attachment’s initial creation. |
| CreationDate | Datetime | Date and time when the attachment was created in the system, providing a record of when the attachment was first added. |
| FileContents | String | Raw content of the attachment file, stored as a string, typically for text-based attachments or metadata extraction. |
| ExpirationDate | Datetime | Date and time when the attachment is set to expire, helping to manage and track the lifecycle of temporary or time-sensitive files. |
| LastUpdatedByUserName | String | Username of the person who last updated the attachment, providing traceability for any modifications made to the attachment record. |
| CreatedByUserName | String | Username of the person who initially created the attachment, ensuring accountability for the upload process. |
| AsyncTrackerId | String | Identifier used for tracking the progress of file uploads in asynchronous processes, enabling monitoring of file status during uploads. |
| FileWebImage | String | Path or identifier for a web image version of the attachment, used to display a thumbnail or preview of the file on user interfaces. |
| DownloadInfo | String | JSON object containing metadata and information used to retrieve the attachment file programmatically, facilitating automation and file management. |
| PostProcessingAction | String | Name of the action that can be performed after the attachment is uploaded, providing users with options for processing the file further (for example, indexing, categorization). |
| Finder | String | Method or tool used to search for and locate specific attachment records, helping to filter and identify relevant attachments in the system. |
| FromDate | Date | Start date from which the attachment is valid, indicating when the attachment information should start being considered. |
| HeaderId | Long | Identifier for the header of the order line, linking the attachment to the overall order and ensuring it is associated with the correct order line. |
| OrderKey | String | Key used to uniquely identify the order line associated with the attachment, ensuring the attachment is tied to the correct transaction. |
| OrderNumber | String | Unique order number assigned to the sales order, used for tracking the order throughout its lifecycle. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the attachment to its original transaction in external systems. |
| SourceTransactionSystem | String | Name of the system from which the transaction originated, providing context for the attachment’s origin and data flow. |
| ToDate | Date | End date after which the attachment is no longer valid or relevant, marking the end of the period during which the attachment should be considered. |