Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

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.

Table Specific Information

Select

The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.

For example, the following query is processed server side:

SELECT * FROM [Cdata].[Procurement].[ApprovedSupplierListSourceDocuments] WHERE AslSourceDocumentsId = 10003

Insert

Create an ApprovedSupplierListSourceDocument.

INSERT into ApprovedSupplierListSourceDocuments(ProcurementBU,Supplier,SupplierSite,Item,AgreementType,Agreement,AgreementLine) values ('UK Business Unit','Edison Co','Edison UK','WT800127','Blanket Purchase Agreement','6247',1)

Update

The Oracle Fusion Cloud Financials API uses AslSourceDocumentsUniqId instead of AslSourceDocumentsId as a path parameter in the URL to update the record.

If you want to update a record directly using the id (without any other filter), you can update the record in the following way:

Update [Cdata].[Procurement].[ApprovedSupplierListSourceDocuments] set Item='RCV-100' where AslSourceDocumentsUniqId=454545454;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use AslSourceDocumentsId instead of AslSourceDocumentsUniqId. You can update the record in the following way:

Update [Cdata].[Procurement].[ApprovedSupplierListSourceDocuments] set Item='RCV-100' where AslSourceDocumentsId=454545454 and Item='RCV-14';

Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.

Delete

The Oracle Fusion Cloud Financials API uses AslSourceDocumentsUniqId instead of AslSourceDocumentsId as a path parameter in the URL to delete the record.

If you want to delete a record directly using the id (without any other filter), you can delete the record in the following way:

Delete from [Cdata].[Procurement].[ApprovedSupplierListSourceDocuments] where AslSourceDocumentsUniqId=454545454;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use AslSourceDocumentsId instead of AslSourceDocumentsUniqId. You can delete the record in the following way:

Delete from [Cdata].[Procurement].[ApprovedSupplierListSourceDocuments] where AslSourceDocumentsId=454545454 and Item='RCV-14';

Columns

Name Type ReadOnly Description
AslSourceDocumentsId [KEY] Long False

Identifier of the approved supplier list??s source document.

AslSourceDocumentsUniqId [KEY] String True

Identifier of the approved supplier list's source document. Use this column's value in insert, update and delete operations, wherever applicable, instead of AslSourceDocumentsId

AslId Long False

Unique identifier of the approved supplier list entry.

AslAttributesId Long False

Identifier of the approved supplier list??s supplier item attribute.

ProcurementBUId Long False

Value that uniquely identifies the business unit that manages and owns the approved supplier list entry.

ProcurementBU String False

Business unit that manages and owns the purchasing document.

ScopeCode String True

Code that identifies if the approved supplier list entry is used by a ship-to organization or by all ship-to organizations serviced by the procurement business unit.

Scope String True

Identifies if the approved supplier list entry is used by a ship-to organization or by all ship-to organizations serviced by the procurement business unit.

ShipToOrganizationId Long False

Value that uniquely identifies the inventory organization that receives the item.

ShipToOrganization String False

Name of the inventory organization to which the supplier should ship the goods.

ItemId Long False

Value that uniquely identifies the item on the approved supplier list entry.

Item String False

Anything that a business makes, purchases, or sells, including components, subassemblies, finished products, or supplies.

SupplierId Long False

Value that uniquely identifies the supplier who fulfills the order.

Supplier String False

Organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.

SupplierSiteId Long False

Value that uniquely identifies the location that the supplier uses to fulfill the order.

SupplierSite String False

Entity that models how the buying organization conducts business with the supplier.

AgreementTypeCode String False

Code that indicates the type of document.

AgreementType String False

Type of agreement associated with the requested item. Applicable types are blanket purchase agreement and contract purchase agreement.

AgreementId Long False

Identifier of the purchasing document's header.

Agreement String False

Contract stating the terms of a purchase.

AgreementLineId Long False

Identifier of the purchasing document's line.

AgreementLine Decimal False

Agreement line number with which the approved supplier list entry is associated.

AgreementStatus String True

Indicates the state of the document with reference to the entire document lifecycle. For example, Incomplete, or Open.

AgreementStartDate Date True

Date on which the agreement associated with the approved supplier list entry becomes effective.

AgreementEndDate Date True

Date after which the agreement isn't usable.

DFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

Finder String True

finder

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

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