JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseAgreementImportRequestslinesitemAttributes

Agreement item attribute captures additional information about the item on the agreement line such as supplier item auxiliary identifier, supplier URL, manufacturer name, manufacturer URL, manufacturer part number, United Nations Standard Products and Services Code, UNSPSC, and image URL. For example, Big Computers could be the manufacturer of a laptop whereas B004521 could be the manufacturer part number for a television.

Columns

Name Type Description
PurchaseAgreementImportRequestsInterfaceHeaderId [KEY] Long PurchaseAgreementImportRequestsInterfaceHeaderId of PurchaseAgreementImportRequestslinesitemAttributes
LinesInterfaceLineId [KEY] Long LinesInterfaceLineId of PurchaseAgreementImportRequestslinesitemAttributes
InterfaceAttributeId [KEY] Long Value that uniquely identifies the interface line item attribute.
InterfaceLineId Long Value that uniquely identifies the interface line for an item attribute.
InterfaceHeaderId Long Value that uniquely identifies the interface header.
InterfaceLineKey String Value that uniquely identifies the interface line for an item attribute.
InterfaceAttributeKey String Value that uniquely identifies the interface line item attribute.
ThumbnailImageURL String Location of the small version of a larger image file for the item specified on the blanket purchase agreement.
ImageURL String URL of the image file associated with the item specified on a blanket purchase agreement line.
ManufacturerPartNumber String Part number used to identify the item by the manufacturer of the item, that's specified on a blanket purchase agreement line.
RoundingFactor Decimal Attribute indicating how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item unit of issue.
Availability String Status of the item availability from supplier.
LeadTime Decimal The number of days in which the item, specified on the blanket purchase order line, can be delivered when ordered.
UNSPSC String The United Nations Standard Products and Services Code for the item specified on the blanket purchase agreement.
AttachmentURL String URL of the attachment associated with the item.
SupplierURL String URL of the supplier's organization.
ManufacturerURL String URL of the manufacturer of the item specified on a blanket purchase agreement line.
PackagingString String String that describes how the item is packed by the supplier.
AttributeCategory String Category segment for the purchase agreement item attributes descriptive flexfield.
Attribute1 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute2 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute3 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute4 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute5 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute6 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute7 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute8 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute9 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute10 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute11 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute12 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute13 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute14 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute15 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute16 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute17 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute18 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute19 String Segment for the purchase agreement line item attributes descriptive flexfield.
Attribute20 String Segment for the purchase agreement line item attributes descriptive flexfield.
AttributeDate1 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate10 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate2 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate3 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate4 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate5 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate6 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate7 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate8 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeDate9 Date Date segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber1 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber10 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber2 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber3 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber4 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber5 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber6 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber7 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber8 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeNumber9 Decimal Number segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp1 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp10 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp2 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp3 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp4 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp5 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp6 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp7 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp8 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
AttributeTimestamp9 Datetime Date and time segment for the purchase agreement item attributes descriptive flexfield.
CreatedBy String CreatedBy of PurchaseAgreementImportRequestslinesitemAttributes
CreationDate Datetime CreationDate of PurchaseAgreementImportRequestslinesitemAttributes
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementImportRequestslinesitemAttributes
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementImportRequestslinesitemAttributes
ProcessCode String ProcessCode of PurchaseAgreementImportRequestslinesitemAttributes
Finder String Finder of PurchaseAgreementImportRequestslinesitemAttributes

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062