Holds descriptive flexfields related to source documents on the approved supplier list, capturing extra procurement details.

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].[ApprovedSupplierListSourceDocumentsDFF] WHERE AslSourceDocumentsId = 10003

Insert

You need to provide ApprovedSupplierListSourceDocumentsUniqId, instead of ApprovedSupplierListSourceDocumentsAslSourceDocumentsId , to insert the record.

Create an ApprovedSupplierListSourceDocumentsDFF.

INSERT INTO [Cdata].[Procurement].[ApprovedSupplierListSourceDocumentsDFF](ApprovedSupplierListSourceDocumentsUniqId ,[__FLEX_Context_DisplayValue],[__FLEX_Context]) VALUES (45,'My Group 2','My Group 2')

Update

The Oracle Fusion Cloud Financials API uses ApprovedSupplierListSourceDocumentsUniqId instead of ApprovedSupplierListSourceDocumentsAslSourceDocumentsId and 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].[ApprovedSupplierListSourceDocumentsDFF] SET [__FLEX_Context]='asdw' WHERE ApprovedSupplierListSourceDocumentsUniqId=300000249243496 and AslSourceDocumentsUniqId=300000249243496

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 and ApprovedSupplierListSourceDocumentsAslSourceDocumentsId instead of ApprovedSupplierListSourceDocumentsUniqId. You can update the record in the following way:

UPDATE [Cdata].[Procurement].[ApprovedSupplierListSourceDocumentsDFF] SET [__FLEX_Context]='asdw' WHERE ApprovedSupplierListSourceDocumentsAslSourceDocumentsId=300000249243496

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 ApprovedSupplierListSourceDocumentsUniqId instead of ApprovedSupplierListSourceDocumentsAslSourceDocumentsId and 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].[ApprovedSupplierListSourceDocumentsDFF] WHERE ApprovedSupplierListSourceDocumentsUniqId=300000249243496 and AslSourceDocumentsUniqId=300000249243496

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 and ApprovedSupplierListSourceDocumentsAslSourceDocumentsId instead of ApprovedSupplierListSourceDocumentsUniqId. You can delete the record in the following way:

DELETE FROM [Cdata].[Procurement].[ApprovedSupplierListSourceDocumentsDFF] WHERE ApprovedSupplierListSourceDocumentsAslSourceDocumentsId=300000249243496

Columns

Name	Type	ReadOnly	Description
ApprovedSupplierListSourceDocumentsAslSourceDocumentsId [KEY]	Long	True	Finds and retrieves approved supplier list source documents based on the primary key of the source document. This field is used to search for specific source documents in the system based on their unique identifier.
ApprovedSupplierListSourceDocumentsUniqId [KEY]	String	True	Serves as an alternative unique identifier for finding approved supplier list source documents. This value should be used for insert, update, and delete operations instead of 'ApprovedSupplierListSourceDocumentsAslSourceDocumentsId' to ensure proper data manipulation.
AslSourceDocumentsId [KEY]	Long	False	The identifier for the approved supplier list source document in the 'ApprovedSupplierListSourceDocumentsDFF' context. This is used to link data in this specific table to the related source document.
AslSourceDocumentsUniqId [KEY]	String	True	This column holds a unique identifier for the approved supplier list source document and should be used for insert, update, and delete operations instead of the 'AslSourceDocumentsId'. It provides an alternative means for managing the data.
_FLEX_Context	String	False	Represents the context within which the 'ApprovedSupplierListSourceDocumentsDFF' operates. It provides metadata to identify the specific business context or process associated with the data stored in this table.
_FLEX_Context_DisplayValue	String	False	Displays a user-friendly prompt or description associated with the '_FLEX_Context' value. This is useful for providing additional context or labels when displaying the context to end users in the system interface.
Finder	String	True	A field used for searching or locating specific records in the system. It may contain query parameters or other search criteria to help users find relevant supplier documents or entries.
CUReferenceNumber	Int	False	Maps child aggregates to their parent tables in the database schema. This number helps to maintain the relationship between aggregate data in child tables and the parent records, ensuring proper data linkage and integrity.
EffectiveDate	Date	True	This query parameter is used to retrieve resources or records that were effective as of the specified start date. It ensures that only valid and active data is fetched, based on the date the query is executed.