ShoppingCatalogSmartFormDetailsattachments
Holds references to files attached to a smart form, such as instructions or supplementary materials for the shopper.
Columns
| Name | Type | Description |
| ShoppingCatalogSmartFormDetailsSmartFormId [KEY] | Long | The unique identifier for the smart form associated with the attachment. Example: 1001 for the smart form ID. |
| AttachedDocumentId [KEY] | Long | The unique identifier for the attached document. Example: 2001 for the document ID of the attached file. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated. Example: '2023-06-01 12:00:00' for the last update timestamp. |
| LastUpdatedBy | String | The user who last updated the attachment record. Example: 'Jane Doe' for the person who modified the attachment details. |
| DatatypeCode | String | A code representing the data type of the attachment. Example: 'PDF' for a Portable Document Format attachment. |
| FileName | String | The name of the attached file. Example: 'Invoice_12345.pdf' for a specific invoice file. |
| DmFolderPath | String | The path of the folder where the attachment file is stored. Example: '/documents/invoices' for the folder containing the attachment. |
| DmDocumentId | String | The document ID from which the attachment is created. Example: 'DOC-12345' for a document ID associated with the file. |
| DmVersionNumber | String | The version number of the document from which the attachment was created. Example: 'v1.0' for the version of the original document. |
| Url | String | The URL of the web page type attachment. Example: 'https://www.example.com/file.pdf' for the online URL of the file. |
| CategoryName | String | The category under which the attachment falls. Example: 'Invoice' for an attachment categorized as an invoice document. |
| UserName | String | The username of the person who created the attachment record. Example: 'jdoe' for the user who uploaded the file. |
| Uri | String | The URI of a Topology Manager type attachment. Example: '/path/to/attachment/abc123' for the URI to access the attachment. |
| FileUrl | String | The URL to access the attachment file. Example: 'https://www.example.com/file.pdf' for the location of the uploaded file. |
| UploadedText | String | The text content of a new text attachment. Example: 'Important document regarding the purchase order.' |
| UploadedFileContentType | String | The content type of the attached file, indicating its format. |
| UploadedFileLength | Long | The size of the attachment file in bytes. Example: 204800 for a 200 KB file. |
| UploadedFileName | String | The name to assign to the new attachment file. Example: 'Invoice_12345.pdf' for the designated file name. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared. Example: true if the file is shared with others, false if not. |
| Title | String | The title of the attachment. Example: 'Purchase Order Invoice' for the title used for the attachment. |
| Description | String | A description of the attachment. Example: 'This document contains the invoice for order #12345.' |
| ErrorStatusCode | String | The error code, if any, associated with the attachment upload. Example: 'ERR001' for a generic upload error code. |
| ErrorStatusMessage | String | The error message, if any, associated with the attachment upload. Example: 'File format not supported.' |
| CreatedBy | String | The user who created the attachment record. Example: 'John Doe' for the user who uploaded the file. |
| CreationDate | Datetime | The date and time when the attachment was created. Example: '2023-05-01 10:00:00' for the timestamp when the attachment was first uploaded. |
| FileContents | String | The contents of the attachment, if it is a text-based file. Example: 'This is the text content of the uploaded document.' |
| ExpirationDate | Datetime | The expiration date for the attachment contents. Example: '2023-12-31 23:59:59' for when the attachment expires. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment. Example: 'jdoe' for the last user who modified the attachment. |
| CreatedByUserName | String | The username of the person who initially created the attachment. Example: 'mdoe' for the creator of the attachment. |
| AsyncTrackerId | String | An identifier used by the Attachment UI components to assist in uploading files asynchronously. Example: 'tracker123' for tracking the upload process. |
| FileWebImage | String | The Base64 encoded image of the file displayed in .png format, if the source file is a convertible image. Example: 'data:image/png;Base64,...' for a Base64 encoded image. |
| DownloadInfo | String | A JSON object represented as a string containing the necessary information to retrieve the attachment programmatically. Example: '{\url\ |
| PostProcessingAction | String | The action that can be performed after the attachment is uploaded. Example: 'Notify User' for sending an email notification after upload completion. |
| Finder | String | A placeholder or reference for searching and locating attachment records. Example: 'Search by Document Type' or 'Search by Attachment ID'. |
| SmartFormId | Long | The unique identifier for the smart form associated with the attachment. Example: 1003 for the associated smart form ID. |
| SysEffectiveDate | String | The system-effective date used for filtering the resources based on their effective date. Example: '2023-06-01' for filtering by this date. |
| EffectiveDate | Date | This query parameter is used to fetch resources that are effective as of the specified start date. Example: '2023-06-01' for filtering resources effective from June 1st, 2023. |