ExpenseReportsExpenseAttachments
Enables users to upload documents for individual expense items, reinforcing traceability and validation.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report in the system. This is used to reference specific expense reports throughout the application. |
| ExpenseExpenseId [KEY] | Long | Unique identifier for the expense associated with the expense report, allowing for detailed tracking and reference. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the document attached to the expense report, facilitating the retrieval and management of associated files. |
| LastUpdateDate | Datetime | Timestamp indicating when the record was last updated, providing a reference for data version control and audit tracking. |
| LastUpdatedBy | String | The username of the person who last updated the record, useful for auditing and tracking user actions in the system. |
| DatatypeCode | String | Code that indicates the type of data stored in the column, helping in data validation and interpretation. |
| FileName | String | Name of the file attached to the expense report, allowing users to identify and manage attached files more easily. |
| DmFolderPath | String | The file path from the document management system that points to the folder where the attachment is stored, aiding in the organization and retrieval of files. |
| DmDocumentId | String | The unique document ID associated with the attachment, used to track and link the file to its original document in the document management system. |
| DmVersionNumber | String | The version number of the document associated with the attachment, useful for tracking document revisions and managing different versions of files. |
| Url | String | URL pointing to a web-based resource or attachment, useful for referencing online content or external files related to the expense report. |
| CategoryName | String | Name of the category under which the attachment is classified, helping to organize and filter attachments by type or content. |
| UserName | String | Login credentials of the user who uploaded the attachment, used for access control and to track the source of attachments. |
| Uri | String | Uniform Resource Identifier (URI) for Topology Manager-based attachments, used for managing complex system configurations and linking to associated resources. |
| FileUrl | String | URL or link to the file, allowing users to access, download, or view the attached file directly from the web interface. |
| UploadedText | String | Text content included in a text-based attachment, such as comments or notes related to the expense report. |
| UploadedFileContentType | String | The content type of the uploaded file, used to specify the format of the file and ensure correct handling during upload. |
| UploadedFileLength | Long | The size of the uploaded file in bytes, providing information about the file's storage requirements and size restrictions. |
| UploadedFileName | String | Name assigned to the uploaded file during the upload process, allowing for proper identification and organization of the file. |
| ContentRepositoryFileShared | Bool | Boolean flag indicating whether the file attachment is shared with other users or systems, which helps control file access permissions. |
| Title | String | The title or label of the attachment, used to provide a clear and concise name for the file when displayed in the user interface. |
| Description | String | Detailed description of the attachment, providing more context or explanation of the file's contents and its relevance to the expense report. |
| ErrorStatusCode | String | Code representing any error that occurred during the attachment process, used for troubleshooting and tracking file upload issues. |
| ErrorStatusMessage | String | Detailed error message associated with any issues encountered while processing the attachment, aiding in troubleshooting. |
| CreatedBy | String | Username of the individual who initially created the record, providing information about the origin of the data for auditing purposes. |
| CreationDate | Datetime | Timestamp indicating when the record was created, useful for historical tracking and maintaining data integrity. |
| FileContents | String | Text or data content of the attachment, stored in a readable format when the file type allows for such content. |
| ExpirationDate | Datetime | The expiration date after which the contents of the attachment are no longer valid or accessible, often used for document retention policies. |
| LastUpdatedByUserName | String | The username of the person who last updated the record, used for tracking modifications and maintaining an audit trail. |
| CreatedByUserName | String | The username of the person who originally created the record, providing context for accountability and historical reporting. |
| AsyncTrackerId | String | Unique identifier used for tracking asynchronous file uploads, assisting with error handling and monitoring progress during the file upload process. |
| FileWebImage | String | Base64-encoded PNG image representing the attachment, displayed for preview if the file source is a convertible image. |
| DownloadInfo | String | JSON object containing metadata and instructions for programmatically retrieving the file, useful for integration with external systems and automated processes. |
| PostProcessingAction | String | Action that can be triggered after the file has been uploaded, such as 'convert', 'index', or 'notify user', allowing post-upload automation. |
| BusinessUnit | String | The business unit associated with the expense report, used for organizational classification and reporting purposes. |
| ExpenseReportId | Long | Unique identifier for the related expense report, linking attachments and other data elements to a specific expense record for easy reference. |
| Finder | String | Search term or filter used to locate specific records or attachments, typically used in search functionality within the system. |
| SysEffectiveDate | String | System-defined effective date used to determine the validity of data for specific time periods, ensuring the correct data is accessed or processed. |
| CUReferenceNumber | Int | Identifier used to relate child aggregates to parent tables, typically used for managing hierarchical or aggregated data structures. |
| EffectiveDate | Date | Date representing when a resource or record became effective, helping to filter data and retrieve only relevant information based on the specified start date. |