PurchaseAgreementImportRequestslinesitemAttributes
Captures extended item data, like manufacturer part numbers or supplier URLs, during purchase agreement imports.
Columns
Name | Type | Description |
PurchaseAgreementImportRequestsInterfaceHeaderId [KEY] | Long | The unique identifier for the interface header related to the purchase agreement import request item attributes. |
LinesInterfaceLineId [KEY] | Long | The unique identifier for the interface line associated with the purchase agreement import request item attributes. |
InterfaceAttributeId [KEY] | Long | The unique identifier for the interface line item attribute, linking it to a specific attribute of an item on the agreement. |
InterfaceLineId | Long | The unique identifier for the interface line related to the item attribute, helping to track individual line items in the purchase agreement. |
InterfaceHeaderId | Long | The unique identifier for the interface header, which contains details of the entire purchase agreement import request. |
InterfaceLineKey | String | A key that uniquely identifies the interface line for the item attribute, allowing precise tracking of item-specific data. |
InterfaceAttributeKey | String | A key that uniquely identifies the interface line item attribute, providing a reference to the specific attribute for the item. |
ThumbnailImageURL | String | The URL location for the small version of a larger image file associated with the item on the purchase agreement, often used for quick previews. |
ImageURL | String | The URL of the full-sized image file associated with the item listed on the purchase agreement line, typically used for detailed item visuals. |
ManufacturerPartNumber | String | The part number used by the manufacturer to identify the item specified on the blanket purchase agreement line, allowing cross-referencing with the manufacturer's catalog. |
RoundingFactor | Decimal | An attribute indicating how to round the quantity on requisition orders when converting between different units of measure for the item. |
Availability | String | The current availability status of the item from the supplier, indicating whether the item is in stock, out of stock, or on backorder. |
LeadTime | Decimal | The number of days required for the item, specified on the blanket purchase agreement, to be delivered after an order is placed. |
UNSPSC | String | The United Nations Standard Products and Services Code (UNSPSC) for the item, used for classification and categorization of products and services. |
AttachmentURL | String | The URL for any attachment associated with the item, providing additional documentation or resources related to the item on the purchase agreement. |
SupplierURL | String | The URL for the supplier's organization, providing a link to their website for additional product information or support. |
ManufacturerURL | String | The URL for the manufacturer of the item, used to link to the manufacturer's website for further details about the item or its specifications. |
PackagingString | String | A string describing how the item is packaged by the supplier, providing context for shipping and handling requirements. |
AttributeCategory | String | The category segment for the purchase agreement item attributes descriptive flexfield, allowing custom attributes for better classification. |
Attribute1 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute2 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute3 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute4 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute5 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute6 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute7 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute8 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute9 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute10 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute11 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute12 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute13 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute14 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute15 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute16 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute17 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute18 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute19 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
Attribute20 | String | Custom segment for additional descriptive information within the purchase agreement line item attributes flexfield. |
AttributeDate1 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate10 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate2 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate3 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate4 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate5 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate6 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate7 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate8 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeDate9 | Date | Date segment for the purchase agreement item attributes descriptive flexfield, providing specific date information related to the item. |
AttributeNumber1 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber10 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber2 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber3 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber4 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber5 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber6 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber7 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber8 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeNumber9 | Decimal | Number segment for the purchase agreement item attributes descriptive flexfield, allowing for numerical values to be assigned to attributes. |
AttributeTimestamp1 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp10 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp2 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp3 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp4 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp5 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp6 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp7 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp8 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
AttributeTimestamp9 | Datetime | Timestamp segment for the purchase agreement item attributes descriptive flexfield, allowing for date and time information related to the item. |
CreatedBy | String | The name of the person or system that created the purchase agreement import request item attribute. |
CreationDate | Datetime | The date and time when the purchase agreement import request item attribute was created. |
LastUpdatedBy | String | The name of the person or system that last updated the purchase agreement import request item attribute. |
LastUpdateDate | Datetime | The date and time when the purchase agreement import request item attribute was last updated. |
ProcessCode | String | The code identifying the process or action being executed for the purchase agreement import request item attribute. |
Finder | String | The search function used to retrieve or filter purchase agreement import request item attributes based on specific criteria. |