PurchaseOrderslinesschedulesattachments
Manages attachments for purchase order schedules, such as shipping instructions or agreement references.
Columns
| Name | Type | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the header of the purchase order in the PurchaseOrderslinesschedulesattachments table. |
| LinesPOLineId [KEY] | Long | The identifier for the individual line item in the purchase order related to the attachment, linking to the PurchaseOrderslinesschedulesattachments table. |
| SchedulesLineLocationId [KEY] | Long | The identifier for the location associated with the specific schedule line for the purchase order in the PurchaseOrderslinesschedulesattachments table. |
| AttachedDocumentId [KEY] | Long | The unique identifier assigned to the document attached to the purchase order line schedule, linking the document to the schedule. |
| LastUpdateDate | Datetime | The date and time when the record for the attachment was last modified. |
| LastUpdatedBy | String | The name or identifier of the user who last made changes to the attachment record. |
| DatatypeCode | String | A code that represents the type of data for the attachment (for example, text, file, image). |
| FileName | String | The name of the file attached to the purchase order line schedule, typically the document's original name. |
| DmFolderPath | String | The folder path in the document management system where the attachment was stored or retrieved from. |
| DmDocumentId | String | The document ID that identifies the source document from which the attachment is created in the document management system. |
| DmVersionNumber | String | The version number of the document associated with the attachment, indicating which version of the document is being referenced. |
| Url | String | The URL pointing to a web page representing the attachment, typically for web-based document types. |
| CategoryName | String | The category or type classification for the attachment (for example, Invoice, Receipt, Purchase Order). |
| UserName | String | The username of the individual who uploaded or created the attachment. |
| Uri | String | The URI associated with a Topology Manager attachment, pointing to its location or resource. |
| FileUrl | String | The URI or link to access the attached file, often used to directly download or view the attachment. |
| UploadedText | String | The textual content for an attachment of type text, such as a description, notes, or comments associated with the attachment. |
| UploadedFileContentType | String | The content type of the attachment, indicating its format. |
| UploadedFileLength | Long | The size of the attachment file in bytes. |
| UploadedFileName | String | The name assigned to a new attachment file being uploaded, which could be different from the original file name. |
| ContentRepositoryFileShared | Bool | Indicates whether the attached file is shared with other users or entities (True/False). |
| Title | String | The title or name of the attachment, often used for display or identification purposes in the system. |
| Description | String | A description providing context or additional information about the attached file or document. |
| ErrorStatusCode | String | The error code indicating any issue encountered during the attachment upload or processing. |
| ErrorStatusMessage | String | A detailed error message explaining any issue or failure related to the attachment. |
| CreatedBy | String | The name or identifier of the user who created the attachment record. |
| CreationDate | Datetime | The date and time when the attachment record was initially created in the system. |
| FileContents | String | The contents or raw data of the attachment file, typically in Base64 encoding for non-file attachments. |
| ExpirationDate | Datetime | The expiration date of the attachment content, after which the attachment may no longer be accessible or valid. |
| LastUpdatedByUserName | String | The username of the individual who last updated or modified the attachment record. |
| CreatedByUserName | String | The username of the individual who initially created the attachment record. |
| AsyncTrackerId | String | An identifier used by the Attachment UI components to track and manage the asynchronous process of file uploads. |
| FileWebImage | String | The Base64 encoded image of the file displayed in .png format, if the source attachment is an image that can be rendered. |
| DownloadInfo | String | A JSON object represented as a string containing information required to programmatically retrieve or download the attached file. |
| PostProcessingAction | String | The name of the action or process to be executed after the attachment has been successfully uploaded (for example, validation, conversion). |
| Finder | String | A placeholder or reference used for searching or locating the attachment within the system. |
| Intent | String | A placeholder or reference used to define the purpose or intent of the attachment within the system (for example, Review, Approval). |
| POHeaderId | Long | The identifier for the purchase order header associated with the attachment, used for linking the attachment to the purchase order. |
| SysEffectiveDate | String | The system effective date for the attachment data, indicating when the data was last valid or applied. |
| EffectiveDate | Date | The date from which the attachment is considered effective, used as a filter for retrieving attachments based on their validity. |