Invoicesattachments
Stores attachments linked to an invoice header (for example, supporting documents), ensuring transparent record-keeping.
Columns
| Name | Type | 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 | 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. |