Invoicesattachments
Stores attachments linked to an invoice header (for example, supporting documents), ensuring transparent record-keeping.
Columns
| Name | Type | SupportedFinders | Description |
| InvoicesInvoiceId [KEY] | Long | Unique identifier of the invoice associated with the attachment, helping to link the attachment to its corresponding invoice. | |
| AttachedDocumentId [KEY] | Long | Unique identifier for the document that is attached, providing a reference to the specific document in the system. | |
| LastUpdateDate | Datetime | Timestamp indicating when the attachment was last updated, tracking modifications made to the attachment. | |
| LastUpdatedBy | String | Username of the individual who last updated the attachment, providing accountability for changes made. | |
| FileName | String | Name of the file associated with the attachment, used to identify and reference the file. | |
| DmFolderPath | String | Folder path where the attachment is stored, helping to locate and manage the attachment in the document management system. | |
| DmDocumentId | String | Unique identifier for the document in the document management system, linking the attachment to its corresponding document. | |
| DmVersionNumber | String | Version number of the document, helping to track changes and updates to the attachment over time. | |
| Url | String | The URL where the attachment can be accessed, used for providing a link to the document or file. | |
| Uri | String | The URI for the attachment, providing a unique resource identifier for accessing the attachment. | |
| FileUrl | String | The URL of the attachment, allowing for direct access to the file from external sources. | |
| UploadedText | String | Text content of the attachment, typically used for text-based files or documents. | |
| UploadedFileContentType | String | The content type of the uploaded attachment, indicating the file format. | |
| UploadedFileLength | Long | The length (size) of the attachment file, used for file size validation and storage management. | |
| UploadedFileName | String | Name of the uploaded attachment file, used for identification and organization of files. | |
| ContentRepositoryFileShared | Bool | Flag indicating whether the attachment file is shared, helping to manage access permissions. | |
| Title | String | Title of the attachment, used for providing a brief description or label for the attachment. | |
| Description | String | Description of the attachment, providing further details or context for the attachment. | |
| ErrorStatusCode | String | Error code indicating any issues encountered during the attachment process, useful for debugging or troubleshooting. | |
| ErrorStatusMessage | String | Error message describing any issues or failures related to the attachment, providing more details on the error. | |
| CreatedBy | String | Username of the individual who created the attachment record, providing accountability for its creation. | |
| CreationDate | Datetime | Timestamp indicating when the attachment was created, helping to track when the attachment was initially added. | |
| FileContents | String | Contents of the attachment, typically used for representing the raw content of a text-based attachment. | |
| ExpirationDate | Datetime | Expiration date for the attachment content, indicating when the attachment is no longer valid or should be removed. | |
| LastUpdatedByUserName | String | Username of the individual who last updated the attachment record, for traceability and accountability. | |
| CreatedByUserName | String | Username of the individual who created the attachment, ensuring proper tracking of creation actions. | |
| AsyncTrackerId | String | Identifier used for tracking the status of file uploads asynchronously, helping to monitor and manage file upload processes. | |
| FileWebImage | String | Web image of the attachment, typically represented as a Base64-encoded image for displaying in web applications. | |
| DownloadInfo | String | JSON object containing the necessary information to programmatically retrieve the file attachment, providing metadata for download operations. | |
| PostProcessingAction | String | Action that can be performed after the attachment is uploaded, such as validation or notification actions. | |
| Category | String | Category of the attachment, used to classify attachments based on their type or purpose. | |
| Type | String | Type of the attachment, providing more specific classification of the document or file. | |
| Finder | String | Search term or identifier used to locate and retrieve specific attachment records, facilitating efficient data retrieval. | |
| InvoiceId | Long | PrimaryKey | Unique identifier of the invoice associated with the attachment, used for tracking the attachment in the context of the invoice. |
| CUReferenceNumber | Int | Reference number mapping the child aggregates with the parent tables, linking data between related entities. | |
| EffectiveDate | Date | Date parameter used to fetch resources that are effective as of a specified start date, ensuring accurate retrieval of time-sensitive data. |