PurchaseAgreementLinesitemAttributes
Contains auxiliary item data in a purchase agreement (supplier part number, manufacturer info) to ensure accurate fulfillment.
Columns
| Name | Type | Description |
| PurchaseAgreementLinesAgreementLineId [KEY] | Long | The unique identifier for the agreement line in the purchase agreement, linking the item attributes to a specific line in the agreement. |
| AttributeValuesId [KEY] | Long | The unique identifier for the set of attribute values associated with the purchase agreement line item, enabling the storage and retrieval of item-specific details. |
| AttributeValuesTlpId | Long | The unique identifier for the translation of attribute values, used to track multilingual attribute data for the purchase agreement line item. |
| LongDescription | String | A detailed description of the purchase agreement line item, providing comprehensive information about the item’s features and specifications. |
| SupplierURL | String | The URL for the supplier’s website, providing direct access to the supplier's online presence for more information about the item or their services. |
| Manufacturer | String | The name of the manufacturer for the item specified on the purchase agreement line, indicating the origin or creator of the item. |
| ManufacturerURL | String | The URL for the manufacturer’s website, offering access to the manufacturer's online resources, product catalogs, and support services. |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer to the item specified on the purchase agreement line, used for cataloging and identification. |
| AttachmentURL | String | The URL for any attachments related to the item, such as product manuals, specifications, or certification documents. |
| Alias | String | An alternative identifier for the item specified on the purchase agreement line, providing flexibility in referencing the item under different naming conventions. |
| LeadTimeDays | Decimal | The number of days required for the item to be delivered once ordered, helping to manage and plan for the item’s arrival and integration into the procurement process. |
| UNSPSC | String | The United Nations Standard Products and Services Code (UNSPSC) for the item, used for consistent classification and categorization of products and services in global trade. |
| ImageURL | String | The URL for an image of the item, providing a visual representation of the item specified on the purchase agreement line. |
| ThumbnailImageURL | String | The URL for a smaller version of the image file, typically used for quick previews or in product listings to minimize load times. |
| Availability | String | The status of the item’s availability from the supplier, indicating whether the item is in stock, out of stock, or available for backorder. |
| RoundingFactor | Double | An attribute indicating how the quantity for the item should be rounded during internal requisitioning, particularly when converting between different units of measure. |
| PackagingString | String | A string that describes how the item is packaged by the supplier, providing essential information for handling, storage, and shipping. |
| CreatedBy | String | The name of the person or system that created the item attributes for the purchase agreement line, providing accountability for the entry. |
| CreationDate | Datetime | The date and time when the item attributes for the purchase agreement line were created, providing historical context for the data entry. |
| LastUpdateDate | Datetime | The date and time when the item attributes for the purchase agreement line were last updated, ensuring the most recent data is available. |
| LastUpdatedBy | String | The name of the person or system that last updated the item attributes for the purchase agreement line, providing accountability for modifications. |
| AgreementLineId | Long | The unique identifier for the agreement line in the purchase agreement, connecting the item attributes to the specific line for tracking and processing. |
| Finder | String | The function or mechanism used to search for or retrieve the item attributes associated with the purchase agreement line, helping to locate specific data based on criteria. |