SalesOrdersForOrderHubattachments
Tracks documents attached to sales orders, ensuring proper documentation for order processing.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the attachment to the specific sales order. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the attached document, used to reference and track the specific attachment in the system. |
| LastUpdateDate | Datetime | The date and time when the attachment details were last updated, providing a timestamp for the most recent modification. |
| LastUpdatedBy | String | The name or identifier of the person or system who last updated the attachment details. |
| DatatypeCode | String | Code representing the data type of the attachment, helping categorize the file (for example, PDF, image, document). |
| FileName | String | The name of the file attached to the sales order, used for identifying the document within the system. |
| DmFolderPath | String | The path to the folder where the attachment is stored, typically used in a document management system for file organization. |
| DmDocumentId | String | Unique identifier for the attached document in the document management system, ensuring traceability of the document. |
| DmVersionNumber | String | Version number of the attached document, used to track revisions or changes made to the document. |
| Url | String | The URL (Uniform Resource Locator) pointing to the location where the attachment can be accessed online. |
| CategoryName | String | The category under which the attachment is classified, helping to organize and sort attachments (for example, invoice, contract). |
| UserName | String | The username of the person who uploaded or is associated with the attachment, used for tracking purposes. |
| Uri | String | The URI (Uniform Resource Identifier) that identifies the attachment file, providing a more technical address for locating the file. |
| FileUrl | String | URL used to locate the attachment file, typically provided for easy access to the file within a system. |
| UploadedText | String | Text content included within the attachment file, which may provide summary information or context about the document. |
| UploadedFileContentType | String | The content type of the attached file, describing its format. |
| UploadedFileLength | Long | The size of the attachment file in bytes, used for managing file storage and ensuring the file is within allowable size limits. |
| UploadedFileName | String | The name of the file as uploaded to the system, which could differ from the original file name if renamed during upload. |
| ContentRepositoryFileShared | Bool | Flag indicating whether the attachment file is shared in the content repository. If 'true', the file is accessible to other systems or users. |
| Title | String | The title or label of the attachment, providing a more descriptive or readable name for users reviewing the attachment. |
| Description | String | A textual description of the attachment, giving further context or information about its content. |
| ErrorStatusCode | String | Code representing the error status encountered during the upload process, used for troubleshooting attachment issues. |
| ErrorStatusMessage | String | Detailed message explaining the error encountered while uploading the attachment, helpful for resolving issues. |
| CreatedBy | String | The name or identifier of the person or system that created the attachment record. |
| CreationDate | Datetime | The date and time when the attachment was created, marking the point at which the file was first associated with the sales order. |
| FileContents | String | Contents of the attachment file represented as a string, potentially used for storing small files or metadata within the system. |
| ExpirationDate | Datetime | The date when the attachment expires, typically used for time-sensitive documents that are no longer needed after a certain period. |
| LastUpdatedByUserName | String | The username of the individual who last updated the attachment record, helping to identify the user responsible for recent changes. |
| CreatedByUserName | String | The username of the individual who created the attachment record, providing context for who originally added the attachment. |
| AsyncTrackerId | String | Identifier used to track the asynchronous upload process of the attachment, ensuring file uploads are monitored and managed properly. |
| FileWebImage | String | URL or reference to the image or preview representation of the attachment file, used for web-based display or interaction. |
| DownloadInfo | String | JSON object in string format containing information used to programmatically retrieve the attachment file, often used for automated downloads. |
| PostProcessingAction | String | The name of the action that can be performed after the attachment has been successfully uploaded, such as processing or validation. |
| Finder | String | A search or lookup tool used to locate specific attachments, typically employed for filtering or identifying particular files related to the sales order. |
| FromDate | Date | The start date for the period during which the attachment is valid or relevant, used to define when the document becomes applicable. |
| HeaderId | Long | Identifier for the sales order header that the attachment is linked to, helping to associate the file with a particular order. |
| OrderKey | String | Unique key for the sales order, used to reference and track the order in relation to the attachment. |
| OrderNumber | String | Order number associated with the sales order, providing a point of reference for identifying the specific order linked to the attachment. |
| SourceTransactionNumber | String | Transaction number from the source system that originated the sales order and is linked to the attachment. |
| SourceTransactionSystem | String | The system from which the original transaction for the sales order originated, providing context for the attachment's source. |
| ToDate | Date | The end date for the period during which the attachment is valid or relevant, marking when the document is no longer applicable. |