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