PurchaseAgreementslinesitemAttributes
Carries supplemental item information on a purchase agreement line, such as manufacturer details or supplier item reference.
Columns
| Name | Type | Description |
| PurchaseAgreementsAgreementHeaderId [KEY] | Long | The unique identifier for the purchase agreement header, linking all item attributes and related information to the overall purchase agreement. |
| LinesAgreementLineId [KEY] | Long | The unique identifier for the agreement line, used to distinguish individual items or terms within the purchase agreement. |
| AttributeValuesId [KEY] | Long | The unique identifier for the extended item attributes in the purchase agreement line, serving as the primary key for the Purchasing Attribute Values view object. |
| AttributeValuesTlpId | Long | The unique identifier for the item translation attributes in the purchase agreement line, serving as the primary key for the Purchasing Attribute Values Translation view object. |
| LongDescription | String | A detailed text description of the item specified in the blanket purchase agreement line, providing comprehensive details on the item’s features and specifications. |
| SupplierURL | String | The URL for the supplier's organization, offering a direct link to their website for more information about their products and services. |
| Manufacturer | String | The name of the manufacturer for the item specified in the blanket purchase agreement line, identifying the entity responsible for producing the item. |
| ManufacturerURL | String | The URL for the manufacturer’s website, providing access to their online resources and product catalogs. |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer to the item specified in the blanket purchase agreement line, used for cataloging and identification. |
| AttachmentURL | String | The URL for any attachment associated with the item, such as product manuals, specifications, or certification documents. |
| Alias | String | An alternate identifier for the item specified in the blanket 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 in the blanket 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 on an internal requisition should be rounded during conversions between the requisition line unit of measure and the item’s unit of issue. |
| PackagingString | String | A string describing how the item is packed 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, ensuring accountability for the data entry. |
| CreationDate | Datetime | The date and time when the item attributes for the purchase agreement line were created, providing a historical record for tracking and auditing. |
| 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, ensuring accountability for modifications. |
| AgreementHeaderId | Long | The unique identifier for the agreement header, used to link this record to the purchase agreement’s overall terms and conditions. |
| Finder | String | The search function or query used to locate or filter item attributes associated with the purchase agreement line, helping to find specific data based on criteria. |
| EffectiveDate | Date | The date used to retrieve item attributes that are effective as of this specified date, ensuring the correct version of the record is retrieved. |