Suppliersattachments
Provides attachment capabilities for supplier records (for example, contracts, certifications), enhancing reference documentation.
Columns
| Name | Type | Description |
| SuppliersSupplierId [KEY] | Long | The unique identifier for the supplier associated with the attachment in the Suppliersattachments table. |
| AttachedDocumentId [KEY] | Long | A primary key that uniquely identifies the attachment. This ID is generated by the application when a user attaches a document to a record. |
| LastUpdateDate | Datetime | The timestamp of the most recent update made to the attachment record. |
| LastUpdatedBy | String | The user or system responsible for the last update made to the attachment record. |
| DatatypeCode | String | An abbreviation representing the data type of the attachment, indicating the format or kind of the attached file. |
| FileName | String | The name of the file attached to the supplier record. |
| DmFolderPath | String | The file path where the document is stored in the document management system. |
| DmDocumentId | String | A unique identifier for the document within the document management system. |
| DmVersionNumber | String | A version number assigned to the document, allowing tracking of changes over time. |
| Url | String | A URI (Uniform Resource Identifier) pointing to the location of the attachment. |
| CategoryName | String | The category or classification assigned to the attachment, such as 'Invoice,' 'Contract,' or 'Tax Form.' |
| UserName | String | The username of the individual who uploaded or is associated with the attachment. |
| Uri | String | A URI (Uniform Resource Identifier) that identifies the attachment, typically used for accessing or linking the file. |
| FileUrl | String | A URL (Uniform Resource Locator) pointing to the location where the attachment can be accessed or downloaded. |
| UploadedText | String | The text content of the uploaded attachment, if applicable, such as in a text-based file. |
| UploadedFileContentType | String | The content type of the attachment file, indicating its format. |
| UploadedFileLength | Long | The size of the uploaded file, measured in bytes. |
| UploadedFileName | String | The original file name given to the attachment when it was uploaded. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared (true) or not shared (false) in the content repository. The default value is false. |
| Title | String | The title or subject of the attachment, providing a brief description of its content. |
| Description | String | A detailed description of the attachment, explaining its purpose or contents. |
| ErrorStatusCode | String | An error code that identifies the issue, if any, related to the attachment. |
| ErrorStatusMessage | String | A message explaining the error, if any, associated with the attachment. |
| CreatedBy | String | The user or system responsible for creating the attachment record. |
| CreationDate | Datetime | The timestamp when the attachment was originally created or uploaded to the system. |
| FileContents | String | The contents of the attachment, stored as text, if the file type allows it. |
| ExpirationDate | Datetime | The date when the attachment is no longer valid or accessible, marking its expiration. |
| LastUpdatedByUserName | String | The username of the individual who last updated the attachment record. |
| CreatedByUserName | String | The username of the individual who originally created the attachment record. |
| AsyncTrackerId | String | An identifier used for tracking the asynchronous file upload process. |
| FileWebImage | String | An image associated with the file, typically used for web display or previews of the attachment. |
| DownloadInfo | String | A JSON object containing information required to programmatically retrieve the attachment file. |
| PostProcessingAction | String | The action that can be taken after the attachment is uploaded, such as processing, validating, or moving the file. |
| BilltoBuId | Long | The unique identifier for the billing business unit associated with the attachment. |
| BindPurchaseFlag | String | Indicates whether the attachment is bound to purchase-related activities (true) or not (false). |
| BindReqBuId | Long | The unique identifier for the business unit that is required for processing the attachment. |
| BindSourcingOnlyFlag | String | Indicates whether the attachment is bound to sourcing-related activities only (true) or available for other uses (false). |
| BindSysdate | Date | The system date when the attachment binding action was executed. |
| Finder | String | A reference to a lookup or search function used for finding or retrieving the attachment. |
| SupplierId | Long | The unique identifier for the supplier associated with this attachment record. |