ExpensesAttachments
Handles attachments directly tied to individual expenses, enhancing record completeness and verification.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record. This ID is used to reference and track specific expenses in the system. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the document attached to the expense record, facilitating file management and retrieval. |
| LastUpdateDate | Datetime | Timestamp indicating the last time the expense record was updated, useful for tracking changes and version control. |
| LastUpdatedBy | String | Username of the individual who last updated the expense record, providing audit trail and accountability. |
| DatatypeCode | String | Code that indicates the data type of the element, aiding in data validation and type-specific operations. |
| FileName | String | The name of the file associated with the attachment, which helps in identifying and accessing the file. |
| DmFolderPath | String | The folder path in the document management system where the attached file is stored, allowing for structured file organization. |
| DmDocumentId | String | Document ID representing the original document from which the attachment was created, used for document tracking. |
| DmVersionNumber | String | Version number of the document from which the attachment originates, helping to track document revisions. |
| Url | String | URL pointing to a web-based attachment, used to reference an external or online file related to the expense record. |
| CategoryName | String | The category under which the attachment is classified, aiding in organizing and filtering attachments. |
| UserName | String | Username of the individual who created the attachment, important for tracking user actions and file ownership. |
| Uri | String | URI pointing to the attachment in the Topology Manager system, used for managing and referencing attached files. |
| FileUrl | String | URL or link to access the file attached to the expense record, allowing users to download or view the file. |
| UploadedText | String | Text content included with a text attachment, typically used for adding comments, notes, or additional information to the record. |
| UploadedFileContentType | String | The content type of the uploaded attachment, specifying the format. |
| UploadedFileLength | Long | Size of the uploaded file in bytes, providing information for file size management and transfer considerations. |
| UploadedFileName | String | The name assigned to the new file being uploaded as an attachment, helping to identify and manage the file. |
| ContentRepositoryFileShared | Bool | Boolean flag indicating whether the file is shared with other users or systems, controlling file access permissions. |
| Title | String | The title given to the attachment, providing a brief and descriptive label for the file. |
| Description | String | Detailed description of the attachment, explaining its content, context, or relevance to the associated expense record. |
| ErrorStatusCode | String | Error code, if any, generated during the attachment process, useful for identifying and resolving issues. |
| ErrorStatusMessage | String | Detailed error message, if any, explaining the nature of any problems encountered during the attachment process. |
| CreatedBy | String | Username of the individual who initially created the expense record, useful for identifying the origin of the record. |
| CreationDate | Datetime | Timestamp of when the expense record was created, providing a reference for historical tracking and data integrity. |
| FileContents | String | The actual content of the attachment, which may include text, images, or other data stored as part of the file. |
| ExpirationDate | Datetime | The expiration date of the attachment, indicating when the content becomes outdated or no longer valid. |
| LastUpdatedByUserName | String | Username of the individual who last updated the record, helping to track modifications and maintain an audit trail. |
| CreatedByUserName | String | Username of the person who created the record, identifying the original creator for accountability purposes. |
| AsyncTrackerId | String | Unique identifier used by the attachment UI components for tracking and managing asynchronous file upload processes. |
| FileWebImage | String | Base64-encoded image representation of the file, typically used to display image previews in PNG format. |
| DownloadInfo | String | JSON object containing metadata and instructions for programmatically retrieving the attached file, useful for automation. |
| PostProcessingAction | String | The name of the action to be executed after the attachment is successfully uploaded, such as 'index', 'convert', or 'notify'. |
| ExpenseId | Long | Unique identifier for the expense entry, used to associate attachments with the correct expense record. |
| Finder | String | Search term or filter used to locate specific records or attachments, typically used in the system’s search functionality. |
| PersonId | String | Identifier for the person associated with the expense record, used for linking expenses to individuals in the system. |
| Request | String | The request associated with the expense record, typically referring to the request or approval process related to the expense. |
| SysEffectiveDate | String | System-defined effective date, used to manage the validity of data and its impact on financial reporting or processes. |
| CUReferenceNumber | Int | Reference number used to link child aggregates to parent tables, facilitating the management of hierarchical data. |
| EffectiveDate | Date | Date representing when the resource or expense record becomes effective, used for filtering records based on their validity date. |