ApprovedSupplierListSourceDocuments
Links source documents (like contracts or quotes) to approved supplier list entries, ensuring that procurement references are accurate and accessible.
Table-Specific Information
Select
The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.
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 an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, 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 the 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 an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, 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 |
Unique identifier for the source document related to the approved supplier list entry. This ID is used to link a specific supplier list entry to the corresponding document in the system. |
| AslSourceDocumentsUniqId [KEY] | String | True |
A unique identifier for the source document. This value should be used for insert, update, and delete operations, replacing the use of AslSourceDocumentsId to ensure proper management of operations related to the source document. |
| AslId | Long | False |
A unique identifier for each entry in the approved supplier list. This ID is essential for distinguishing individual supplier list entries and is used to link to other related data. |
| AslAttributesId | Long | False |
Identifier for the specific supplier item attribute related to the approved supplier list entry. It connects the supplier list entry to its corresponding supplier attributes such as pricing, delivery terms, or product specifications. |
| ProcurementBUId | Long | False |
Unique identifier for the business unit responsible for managing and owning the approved supplier list entry. This value helps to define the ownership of the list and its operations within the procurement process. |
| ProcurementBU | String | False |
The name of the business unit that manages the purchasing document associated with the approved supplier list entry. This field helps identify the responsible unit within the organization. |
| ScopeCode | String | True |
A code that indicates whether the approved supplier list entry is specific to a ship-to organization or applies to all organizations serviced by the procurement business unit. This helps define the scope of use for the supplier list. |
| Scope | String | True |
Indicates whether the approved supplier list entry applies to a specific ship-to organization or all organizations within the procurement business unit. This field is important for determining the reach of the list. |
| ShipToOrganizationId | Long | False |
Unique identifier for the inventory organization that receives the item from the supplier. This value is used to track the organization receiving and managing the goods supplied. |
| ShipToOrganization | String | False |
The name of the inventory organization to which the supplier should deliver the goods. This helps specify where the goods are to be shipped within the organization. |
| ItemId | Long | False |
Unique identifier for the item associated with the approved supplier list entry. This ID is used to track and identify individual products or services related to the supplier list. |
| Item | String | False |
Refers to any goods or services that a business purchases, sells, or manufactures, including parts, components, subassemblies, finished products, or supplies. |
| SupplierId | Long | False |
Unique identifier for the supplier responsible for fulfilling the order. This field is used to track and identify the specific supplier providing goods or services. |
| Supplier | String | False |
The organization or individual that provides goods or services to the buying organization in exchange for payment, bound by a contractual agreement. |
| SupplierSiteId | Long | False |
Unique identifier for the location where the supplier fulfills the order. This field helps track the supplier’s location used to complete the delivery or service. |
| SupplierSite | String | False |
The name or identifier of the location that the supplier uses to fulfill the order. This may include a warehouse, shipping facility, or other operational site. |
| AgreementTypeCode | String | False |
A code that identifies the type of agreement associated with the requested item. This helps to categorize the agreement, such as a blanket purchase agreement or a contract purchase agreement. |
| AgreementType | String | False |
Describes the type of agreement associated with the approved supplier list entry. This can include a blanket purchase agreement (for ongoing purchases) or a contract purchase agreement (for specific purchases). |
| AgreementId | Long | False |
Unique identifier for the header of the purchasing document associated with the approved supplier list entry. This field links the supplier list entry to the overarching purchase agreement. |
| Agreement | String | False |
The formal contract that outlines the terms and conditions of a purchase. This document governs the business relationship between the buyer and supplier. |
| AgreementLineId | Long | False |
Unique identifier for the line item in the purchasing document related to the approved supplier list entry. This value helps to associate each entry with a specific line in the purchase agreement. |
| AgreementLine | Decimal | False |
The line number within the purchasing document that corresponds to the approved supplier list entry. This value is used to identify which line in the agreement the item is associated with. |
| AgreementStatus | String | True |
Indicates the current status of the agreement, such as 'Incomplete', 'Open', or 'Closed'. This field tracks the lifecycle stage of the purchasing document. |
| AgreementStartDate | Date | True |
The date when the terms of the agreement become effective and applicable. This marks the start of the agreement’s validity period. |
| AgreementEndDate | Date | True |
The date after which the agreement is no longer valid. This field helps to define the expiration of the agreement and when it should no longer be used. |
| DFF | String | False |
This column is used only for insert operations. For updates and deletions, the child table's operations should be used, ensuring that changes are applied in a consistent and reliable manner. |
| Finder | String | True |
A field used to locate specific records in the system. It can contain search criteria or keywords to help users quickly find relevant supplier list entries. |
| EffectiveDate | Date | True |
A query parameter used to fetch resources that are effective as of the specified start date. This helps to ensure that only records that are valid as of the given date are returned. |