DraftPurchaseOrderslinesschedulesattachments
Stores files tied to draft purchase order schedules, such as shipping instructions or special handling documents.
Columns
| Name | Type | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for a draft purchase order header, linking the attachment to the corresponding purchase order. |
| LinesPOLineId [KEY] | Long | The unique identifier for the specific purchase order line, linking this attachment to the relevant line item. |
| SchedulesLineLocationId [KEY] | Long | The identifier for the location associated with the purchase order line schedule to which the document is attached. |
| AttachedDocumentId [KEY] | Long | A unique identifier for the document that is attached to the purchase order schedule. This value is generated by the system when the document is uploaded. |
| LastUpdateDate | Datetime | The date and time when the attachment record was last updated in the system. |
| LastUpdatedBy | String | The user who last updated the attachment record, providing an audit trail of changes. |
| DatatypeCode | String | An abbreviation that identifies the type of data represented by the attached document, such as image, PDF, or text. |
| FileName | String | The file name of the attached document, which is used to identify and track the document. |
| DmFolderPath | String | The path in the document management system where the attached document is stored. |
| DmDocumentId | String | The unique identifier for the document in the document management system. |
| DmVersionNumber | String | The version number of the attached document, which helps track revisions and updates. |
| Url | String | The URI (Uniform Resource Identifier) that links directly to the location of the attached document. |
| CategoryName | String | The category of the attached document, used to classify the document (for example, contract, invoice, specification). |
| UserName | String | The login credentials of the user who created the attachment, providing traceability. |
| Uri | String | The URI (Uniform Resource Identifier) for the attached document, providing a direct link to access it. |
| FileUrl | String | The URL (Uniform Resource Locator) that provides access to download or view the attached document. |
| UploadedText | String | The text content of the attached document, if applicable, often used for text-based documents. |
| UploadedFileContentType | String | The content type of the uploaded document, describing its format. |
| UploadedFileLength | Long | The size of the uploaded document, typically in bytes, indicating how large the file is. |
| UploadedFileName | String | The name of the file as it was uploaded, which might differ from the original file name. |
| ContentRepositoryFileShared | Bool | Indicates whether the document is shared in the content repository. If true, the document is shared; if false, it is not. |
| Title | String | The title of the attached document, providing a brief descriptor or name for the document. |
| Description | String | A detailed description of the attached document, explaining its contents and purpose. |
| ErrorStatusCode | String | An abbreviation for the error code, if any, that was encountered during the attachment process. |
| ErrorStatusMessage | String | The error message, if any, providing details about issues encountered with the attachment. |
| CreatedBy | String | The user who created the attachment record, helping to track the origin of the attachment. |
| CreationDate | Datetime | The date and time when the attachment record was created. |
| FileContents | String | The contents of the attached document, typically stored as text or Base64-encoded data. |
| ExpirationDate | Datetime | The date when the content in the attached document is no longer valid or accessible. |
| LastUpdatedByUserName | String | The user name of the individual who last updated the attachment record. |
| CreatedByUserName | String | The user name of the individual who created the attachment record. |
| AsyncTrackerId | String | An identifier used to track the progress of asynchronous file uploads. |
| FileWebImage | String | The Base64 encoded image of the document, displayed in .png format if the file is a convertible image. |
| DownloadInfo | String | A JSON-formatted string that contains all necessary information to programmatically retrieve a large file attachment. |
| PostProcessingAction | String | The name of the action that should be performed after the attachment has been uploaded, such as validation or indexing. |
| Finder | String | A search identifier used to locate specific attachment records in the system. |
| Intent | String | Describes the intended purpose of the attachment, such as creating, reviewing, or updating an attachment. |
| POHeaderId | Long | The purchase order header ID that links the attached document to the corresponding purchase order. |
| SysEffectiveDate | String | The system’s effective date, indicating when the attachment record was created or last modified. |
| CUReferenceNumber | Int | An identifier used to map child aggregate records to their corresponding parent tables for data consistency. |
| EffectiveDate | Date | The date from which the attached document is considered effective or valid in relation to the purchase order. |