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. |