JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

ApprovedSupplierListSourceDocuments

The Approved Supplier List Source Documents resource maintains a repository that links approved supplier list entries to source documents. This resource can be used with the Procurement Approved Supplier List Entries resource to manage the approved supplier list. Source documents that are specific to a ship-to organization can't be added, updated, retrieved, or deleted for approved supplier list entries that have a global scope. Additionally, source documents can't be added, updated, retrieved, or deleted for approved supplier list entries of category type or for those of manufacturer or distributor business types.

Columns

Name Type Description
AslSourceDocumentsId [KEY] Long Identifier of the approved supplier list??s source document.
AslId Long Unique identifier of the approved supplier list entry.
AslAttributesId Long Identifier of the approved supplier list??s supplier item attribute.
ProcurementBUId Long Value that uniquely identifies the business unit that manages and owns the approved supplier list entry.
ProcurementBU String Business unit that manages and owns the purchasing document.
ScopeCode String ScopeCode of ApprovedSupplierListSourceDocuments
Scope String Scope of ApprovedSupplierListSourceDocuments
ShipToOrganizationId Long Value that uniquely identifies the inventory organization that receives the item.
ShipToOrganization String Name of the inventory organization to which the supplier should ship the goods.
ItemId Long Value that uniquely identifies the item on the approved supplier list entry.
Item String Anything that a business makes, purchases, or sells, including components, subassemblies, finished products, or supplies.
SupplierId Long Value that uniquely identifies the supplier who fulfills the order.
Supplier String Organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.
SupplierSiteId Long Value that uniquely identifies the location that the supplier uses to fulfill the order.
SupplierSite String Entity that models how the buying organization conducts business with the supplier.
AgreementTypeCode String Code that indicates the type of document.
AgreementType String Type of agreement associated with the requested item. Applicable types are blanket purchase agreement and contract purchase agreement.
AgreementId Long Identifier of the purchasing document's header.
Agreement String Contract stating the terms of a purchase.
AgreementLineId Long Identifier of the purchasing document's line.
AgreementLine Decimal Agreement line number with which the approved supplier list entry is associated.
AgreementStatus String AgreementStatus of ApprovedSupplierListSourceDocuments
AgreementStartDate Date AgreementStartDate of ApprovedSupplierListSourceDocuments
AgreementEndDate Date AgreementEndDate of ApprovedSupplierListSourceDocuments
Finder String Finder of ApprovedSupplierListSourceDocuments

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