ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175