ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

ApprovedSupplierListSourceDocumentsDFF

The operations from the Approved Supplier List Source Documents/Flexfields for Approved Supplier List Source Documents category.

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].[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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 approved supplier list source documents according to the primary source document key.

ApprovedSupplierListSourceDocumentsUniqId [KEY] String True

Finds approved supplier list source documents according to the primary source document key. Use this column's value for insert, update and delete operations, wherever applicable, instead of approvedSupplierListSourceDocumentsAslSourceDocumentsId.

AslSourceDocumentsId [KEY] Long False

AslSourceDocumentsId of ApprovedSupplierListSourceDocumentsDFF

AslSourceDocumentsUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of AslSourceDocumentsId

_FLEX_Context String False

__FLEX_Context of ApprovedSupplierListSourceDocumentsDFF

_FLEX_Context_DisplayValue String False

Context Prompt

Finder String True

finder

CUReferenceNumber Int False

Maps the child aggregates with Parent tables.

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