SSIS Components for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseAgreementslinesitemAttributes

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

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