DraftPurchaseOrdersattachments
Manages files attached to draft purchase orders, such as specs or contractual clauses, before finalization.
Columns
| Name | Type | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the purchase order header in the DraftPurchaseOrders table, used to link attachments to the relevant draft purchase order. |
| AttachedDocumentId [KEY] | Long | A unique identifier for the document that is attached to the purchase order. This value is generated when the user attaches a document to the purchase order. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated, helping track the most recent modifications. |
| LastUpdatedBy | String | The user who last updated the attachment record, useful for auditing purposes. |
| DatatypeCode | String | An abbreviation identifying the data type of the attached document, providing clarity on the document's format (for example, PDF, Word). |
| FileName | String | The name of the attached document file, typically including the document's name and file extension. |
| DmFolderPath | String | The folder path where the attached document is stored in the document management system. |
| DmDocumentId | String | A unique identifier for the document in the document management system, linking it to the purchase order attachment. |
| DmVersionNumber | String | The version number assigned to the attached document, used to track document revisions. |
| Url | String | The URI (Uniform Resource Identifier) that locates the attached document, enabling access to the file. |
| CategoryName | String | The category or classification of the attached document, which can help organize and identify the document type (for example, invoice, contract). |
| UserName | String | The login credentials of the user who created the attachment, typically their username within the system. |
| Uri | String | The URI (Uniform Resource Identifier) that identifies the attached document, used for accessing the file or resource. |
| FileUrl | String | The URL (Uniform Resource Locator) that directly links to the attached document, providing a web address for downloading or viewing the document. |
| UploadedText | String | The text content of the attached document, if applicable, providing a preview or extract of the document's contents. |
| UploadedFileContentType | String | The content type of the uploaded file, describing its format. |
| UploadedFileLength | Long | The size of the attached document in bytes, indicating the file's size and helping manage storage limits. |
| UploadedFileName | String | The name of the file as uploaded, which may differ from the document's original name if modified during the upload process. |
| ContentRepositoryFileShared | Bool | A flag indicating whether the attached document is shared with others. If true, the document is shared; if false, it is not. |
| Title | String | The title of the attached document, providing a brief description or heading to summarize the content of the document. |
| Description | String | A detailed description of the attached document, providing additional context about its contents and purpose. |
| ErrorStatusCode | String | An abbreviation identifying any error code related to the document attachment, useful for debugging or error handling. |
| ErrorStatusMessage | String | The error message text, providing further details on any issues encountered during document processing or upload. |
| CreatedBy | String | The user who created the attachment record, helping track who initiated the attachment process. |
| CreationDate | Datetime | The date and time when the attachment record was created, indicating when the document was first associated with the purchase order. |
| FileContents | String | The contents of the attached document, typically in Base64 encoding, used for transferring document data. |
| ExpirationDate | Datetime | The date when the attached document expires or becomes no longer valid, often used for temporary documents. |
| LastUpdatedByUserName | String | The username of the person who last updated the attachment record, providing visibility into who made the most recent changes. |
| CreatedByUserName | String | The username of the person who created the attachment record, useful for audit purposes. |
| AsyncTrackerId | String | An identifier used to track the asynchronous upload process of large files or attachments, helping monitor the status of file uploads. |
| FileWebImage | String | A Base64-encoded image of the attached file, displayed in PNG format if the file is an image and can be rendered visually. |
| DownloadInfo | String | A JSON-formatted string that contains information needed to programmatically retrieve large file attachments, such as download links or metadata. |
| PostProcessingAction | String | The name of the action to be performed after the attachment is uploaded, such as indexing, converting, or notifying the user. |
| Finder | String | The finder used for searching and referencing related attachment records, helping locate attachments associated with purchase orders. |
| Intent | String | The intent or purpose of the attachment, typically describing the role it serves in the procurement process. |
| POHeaderId | Long | The unique identifier for the purchase order header, used to link attachments to the correct purchase order. |
| SysEffectiveDate | String | The system-effective date, which specifies the period during which the attachment is valid or applicable. |
| CUReferenceNumber | Int | A reference number that maps child aggregates to the parent tables, used for linking data between related tables. |
| EffectiveDate | Date | The date used to fetch records that are effective as of a specified start date, typically used for tracking changes over time. |