JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

PurchaseAgreementLinesitemAttributes

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
PurchaseAgreementLinesAgreementLineId [KEY] Long PurchaseAgreementLinesAgreementLineId of PurchaseAgreementLinesitemAttributes
AttributeValuesId [KEY] Long AttributeValuesId of PurchaseAgreementLinesitemAttributes
AttributeValuesTlpId Long AttributeValuesTlpId of PurchaseAgreementLinesitemAttributes
LongDescription String LongDescription of PurchaseAgreementLinesitemAttributes
SupplierURL String SupplierURL of PurchaseAgreementLinesitemAttributes
Manufacturer String Manufacturer of PurchaseAgreementLinesitemAttributes
ManufacturerURL String ManufacturerURL of PurchaseAgreementLinesitemAttributes
ManufacturerPartNumber String ManufacturerPartNumber of PurchaseAgreementLinesitemAttributes
AttachmentURL String AttachmentURL of PurchaseAgreementLinesitemAttributes
Alias String Alias of PurchaseAgreementLinesitemAttributes
LeadTimeDays Decimal LeadTimeDays of PurchaseAgreementLinesitemAttributes
UNSPSC String UNSPSC of PurchaseAgreementLinesitemAttributes
ImageURL String ImageURL of PurchaseAgreementLinesitemAttributes
ThumbnailImageURL String ThumbnailImageURL of PurchaseAgreementLinesitemAttributes
Availability String Availability of PurchaseAgreementLinesitemAttributes
RoundingFactor Double RoundingFactor of PurchaseAgreementLinesitemAttributes
PackagingString String PackagingString of PurchaseAgreementLinesitemAttributes
CreatedBy String CreatedBy of PurchaseAgreementLinesitemAttributes
CreationDate Datetime CreationDate of PurchaseAgreementLinesitemAttributes
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementLinesitemAttributes
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementLinesitemAttributes
AgreementLineId Long AgreementLineId of PurchaseAgreementLinesitemAttributes
Finder String Finder of PurchaseAgreementLinesitemAttributes

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