ExpenseCashAdvancesAttachments
Enables document uploads and management (for example, receipts or justifications) for recorded cash advances.
Columns
| Name | Type | Description |
| ExpenseCashAdvancesCashAdvanceId [KEY] | Long | The unique identifier assigned to each cash advance record, used to track and reference cash advances within the system. |
| AttachedDocumentId [KEY] | Long | The identifier for the document attached to the cash advance record, enabling linkage to relevant documentation. |
| LastUpdateDate | Datetime | The timestamp indicating the most recent date and time the record was updated, providing an audit trail for changes. |
| LastUpdatedBy | String | The username of the individual who last modified the record, ensuring traceability of updates. |
| DatatypeCode | String | A code that specifies the type of data, helping to categorize and validate the information stored in the record. |
| FileName | String | The name of the file attached to the record, providing an easy way to identify and reference the file. |
| DmFolderPath | String | The path to the folder where the attachment is stored, assisting in locating and managing document storage locations. |
| DmDocumentId | String | The document identifier linked to the attachment, used to reference the source document within the document management system. |
| DmVersionNumber | String | The version number of the document from which the attachment was created, ensuring version control and consistency in document management. |
| Url | String | The URL representing the web link to the attached resource, used when the attachment is a web-based resource. |
| CategoryName | String | The classification or category of the attachment, helping to organize and filter attachments based on their type. |
| UserName | String | The login credentials of the user who uploaded or created the attachment, enabling user accountability. |
| Uri | String | The URI of the attachment when the source is related to Topology Manager, providing a reference link to the specific resource. |
| FileUrl | String | The complete URL pointing directly to the file, used for direct access or download of the attachment. |
| UploadedText | String | The text content for a new text-based attachment, capturing non-binary data such as notes or descriptions in an attachment. |
| UploadedFileContentType | String | The content type of the uploaded file, helping to categorize the file type. |
| UploadedFileLength | Long | The size, in bytes, of the uploaded file, used for managing storage and handling file transfer limits. |
| UploadedFileName | String | The desired name assigned to the uploaded file, which may differ from the original file name for internal organization. |
| ContentRepositoryFileShared | Bool | A Boolean flag indicating whether the file is shared across multiple users or systems, impacting access permissions. |
| Title | String | The title or name of the attachment, providing a brief and descriptive label for easy identification. |
| Description | String | A detailed description of the attachment, offering context or additional information about the content of the attachment. |
| ErrorStatusCode | String | The error code, if applicable, providing a numeric or alphanumeric identifier for any issues encountered during the attachment process. |
| ErrorStatusMessage | String | The error message, if applicable, offering a textual explanation of the issues or failures encountered during the attachment process. |
| CreatedBy | String | The username of the user who created the record, enabling identification of the originator of the record. |
| CreationDate | Datetime | The date and time when the record was initially created, offering a historical reference for when the data was first entered into the system. |
| FileContents | String | The actual contents of the attachment when the file is a text-based resource, representing the data included in the attachment. |
| ExpirationDate | Datetime | The expiration date for the attachment content, indicating when the file or document is no longer valid or accessible. |
| LastUpdatedByUserName | String | The username of the person who last updated the record, ensuring proper tracking of changes. |
| CreatedByUserName | String | The username of the person who created the record, providing accountability for initial data entry. |
| AsyncTrackerId | String | A unique identifier for tracking the status of asynchronous file uploads, aiding in managing the upload process. |
| FileWebImage | String | A Base64-encoded representation of the file's image in .png format, displayed when the attachment is a convertible image. |
| DownloadInfo | String | A JSON-formatted string containing metadata and instructions needed to programmatically download the file attachment. |
| PostProcessingAction | String | The action to be performed on the attachment after it is uploaded, such as indexing or sending for review. |
| CashAdvanceId | Long | The unique identifier for the cash advance record, used to reference a specific cash advance transaction within the system. |
| Finder | String | A search parameter that helps filter or locate specific records based on a defined criteria, such as a name, code, or reference number. |
| EffectiveDate | Date | The date on which the resource or record becomes effective. This parameter is used to fetch records that are valid as of the specified date, ensuring the selection of up-to-date data. |