--- schema_version: "1" id: 5b01ee18312d32e718650268c19a74fa97adf83e85c65d2bf726e67b6859a572 title: Oracle Fusion Cloud SCM Connector Objects (SupplyChainPlanning Schema) collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/oraclescm/c360-a-oraclescm-objects-supplychainplanning.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-oraclescm-objects-supplychainplanning.html source_site: developer.salesforce.com content_type: documentation content_hash: 03ce71522a21e90a735375845fe1316c9ca39f11b043878f4641e6aecf46e21c products: - Data 360 Integration Guide - Data 360 Developer Documentation --- # Oracle Fusion Cloud SCM Connector Objects (SupplyChainPlanning Schema) **note:** This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at [Agreements and Terms.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com) ## Objects Supported | Name | Description | | ----------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------- | | [CollaborationOrderForecastRequests](#collaborationorderforecastrequests) | Facilitates supplier collaboration by requesting order forecasts and tracking the status of submitted requests. | | [CollaborationOrderForecastRequestsdetails](#collaborationorderforecastrequestsdetails) | Manages detailed information about requested collaboration order forecasts for streamlined planning. | | [CollaborationOrderForecastRequestsrequestStatusDetails](#collaborationorderforecastrequestsrequeststatusdetails) | Tracks and manages the status of collaboration order forecasts, including processing details and error messages. | | [CollaborationOrderForecasts](#collaborationorderforecasts) | Provides access to published order forecasts for supplier collaboration and enables response submissions for supply commitments. | | [CollaborationOrderForecastscommitQuantities](#collaborationorderforecastscommitquantities) | Retrieves and manages commit measure details associated with collaboration order forecasts, including supply commit responses. | | [CollaborationOrderForecastsexceptionQuantities](#collaborationorderforecastsexceptionquantities) | Highlights forecast and commit exceptions, such as changes or mismatches, to ensure planning accuracy. | | [CollaborationOrderForecastsforecastQuantities](#collaborationorderforecastsforecastquantities) | Manages forecast measure details, allowing updates and new entries for collaboration order forecasts. | | [CollaborationOrderForecastsreferenceQuantities](#collaborationorderforecastsreferencequantities) | Provides access to additional measures for collaboration order forecasts, such as purchasing metrics, enhancing decision-making. | | [Finders](#finders) | Lists finder names and associated attributes for specific views, aiding in efficient data retrieval. | | [FlexFndDffDescriptiveFlexfieldContexts](#flexfnddffdescriptiveflexfieldcontexts) | Enables management and retrieval of descriptive flexfield contexts using REST API endpoints. | | [FlexFndPvsCharacterIdCharacterValues](#flexfndpvscharacteridcharactervalues) | Supports retrieval of character-based flexfield values through REST API endpoints for enhanced data configuration. | | [FlexFndPvsCharacterValues](#flexfndpvscharactervalues) | Facilitates access to character-based flexfield values, enabling detailed customizations in Oracle SCM. | | [FlexFndPvsNumberIdCharacterValues](#flexfndpvsnumberidcharactervalues) | Manages numeric flexfield values for extended data configuration and retrieval. | | [StandardLookupsLOV](#standardlookupslov) | Provides a queryable list of standard lookup codes and their descriptions, supporting consistent reference data sharing. | ## CollaborationOrderForecastRequests | Name | Type | ReadOnly | References | FilterOnly | Description | | ----------------------------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastRequestId [KEY] | Long | False | | No | A unique identifier for the collaboration order forecast request. | | StatusCode | String | False | | No | The status code indicating the current state of the collaboration order forecast request. | | SupplyPlanName | String | False | | No | The name of the supply plan used to generate the collaboration order forecast. | | SupplyPlanDescription | String | False | | No | A description of the supply plan used to generate the collaboration order forecast. | | ProcurementBUName | String | False | | No | The name of the business unit responsible for procurement. The application assigns the supplier to this business unit. | | ShipFromSupplierName | String | False | | No | The name of the supplier that ships the requested item. | | ShipFromSupplierSiteName | String | False | | No | The name of the specific supplier site from which the item is shipped. | | ShipToOrganizationCode | String | False | | No | The code identifying the organization receiving the item. | | ShipToCustomerName | String | False | | No | The name of the customer receiving the item. | | ShipToCustomerSiteName | String | False | | No | The name of the specific customer site where the item is delivered. | | ShipToCustomerSiteNumber | String | False | | No | A unique identifier for the customer site that received the item. | | ItemNumber | String | False | | No | A unique identifier for the item being forecasted. | | UnitOfMeasure | String | False | | No | The unit of measure in which the item is quantified. | | UOMCode | String | False | | No | The abbreviation representing the unit of measure for the item. | | SourceSystem | String | False | | No | The source system from which the collaboration order forecast request originates. | | SourceSystemCode | String | False | | No | The code representing the source system for the collaboration order forecast request. | | CreatedBy | String | False | | No | The username or system identifier of the user who created the request. | | CreationDate | Datetime | False | | No | The date and time when the collaboration order forecast request was created. | | ProcessId | Long | False | | No | A unique identifier for the process associated with the collaboration order forecast request. | | NoteToSupplier | String | False | | No | A message from the collaboration planner to the supplier regarding the forecast request. | | NoteToPlanner | String | False | | No | A message from the supplier to the collaboration planner regarding the forecast request. | | Finder | String | False | | No | A system-generated reference used to locate the collaboration order forecast request. | [Return to Top](#objects-supported) ## CollaborationOrderForecastRequestsdetails | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------------------------------------------- | ------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastRequestsCollaborationOrderForecastRequestId [KEY] | Long | False | | No | A unique identifier linking the forecast request details to the corresponding collaboration order forecast request. | | CollaborationOrderForecastRequestId | String | False | | No | A unique identifier for the collaboration order forecast request. | | PublisherOrderTypeCode | String | False | | No | The code representing the type of order for the reference quantity. Accepted values are defined in the lookup type ORA_VCS_COLLAB_ORDER_TYPES. These values can be managed in the Setup and Maintenance work area under the Manage Supply Chain Collaboration Lookups task. | | BucketStartDate | Date | False | | No | The date when the time bucket for the forecast period begins. | | Quantity | Decimal | False | | No | The forecasted quantity associated with the specified order type. | | ReferenceHeaderId | Long | False | | No | A unique identifier for the reference header of a measure originating in Oracle Cloud. For measures outside Oracle Cloud, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | ReferenceLineId | Long | False | | No | A unique identifier for the reference line of a measure originating outside Oracle Cloud. For external measures, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | ReferenceLineLocationId | Long | False | | No | A unique identifier for the reference line location of a measure originating outside Oracle Cloud. For external measures, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | ReferenceHeaderNumber | String | False | | No | The reference header number for a measure originating in Oracle Cloud. For measures outside Oracle Cloud, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | ReferenceLineNumber | String | False | | No | A unique number identifying the reference line for a measure originating outside Oracle Cloud. For external measures, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | ReferenceLineLocationNumber | String | False | | No | A unique number identifying the reference line location for a measure originating outside Oracle Cloud. For external measures, use the Reference Header Number column. Each read-only reference measure must include a reference header, line, and location. A purchase order is an example of a reference measure. | | Finder | String | False | | No | A system-generated reference used to locate the collaboration order forecast request details. | [Return to Top](#objects-supported) ## CollaborationOrderForecastRequestsrequestStatusDetails | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------------------------------------------------------- | ------ | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastRequestsCollaborationOrderForecastRequestId [KEY] | Long | False | | No | A unique identifier linking the status details to the corresponding collaboration order forecast request. | | CollaborationOrderForecastRequestId | Long | False | | No | A unique identifier for the collaboration order forecast request associated with this status detail. | | RequestDetailId [KEY] | Long | False | | No | A unique identifier for the specific request detail entry within the collaboration order forecast request. | | StatusDetailType | String | False | | No | The type of status detail associated with the forecast request, indicating the nature of the update or processing stage. | | StatusDetailCode | String | False | | No | A code representing the specific status detail of the collaboration order forecast request, providing insight into processing or approval stages. | | Finder | String | False | | No | A system-generated reference used to locate the status details of the collaboration order forecast request. | [Return to Top](#objects-supported) ## CollaborationOrderForecasts | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------------ | -------- | -------- | ---------- | ---------- | -------------------------------------------------------------------------------- | | CollaborationOrderForecastId [KEY] | Long | False | | No | A unique identifier for the collaboration order forecast. | | CorrelationCode | String | False | | No | A code used to correlate related collaboration order forecasts. | | SupplyPlanName | String | False | | No | The name of the supply plan associated with this collaboration order forecast. | | SupplyPlanDescription | String | False | | No | A description of the supply plan used for the collaboration order forecast. | | SupplyPlanVersion | Int | False | | No | The version number of the supply plan used for this forecast. | | SourceSystemCode | String | False | | No | A code representing the source system that provided the forecast data. | | SourceSystem | String | False | | No | The source system from which the collaboration order forecast originates. | | CollaborationSourceId | Long | False | | No | A unique identifier for the collaboration source related to the forecast. | | CollaborationPlanId | Long | False | | No | A unique identifier for the collaboration plan associated with the forecast. | | CollaborationPlanName | String | False | | No | The name of the collaboration plan linked to the forecast. | | PlanningCycleStartDate | Date | False | | No | The start date of the planning cycle for this forecast. | | PlanningCycleEndDate | Date | False | | No | The end date of the planning cycle for this forecast. | | ShipFromSupplierId | Long | False | | No | A unique identifier for the supplier shipping the item. | | ShipFromSupplierName | String | False | | No | The name of the supplier shipping the item. | | ShipFromSupplierNumber | String | False | | No | The unique number identifying the supplier shipping the item. | | ShipFromSupplierDUNS | String | False | | No | The DUNS number associated with the supplier shipping the item. | | ShipFromSupplierAlternateName | String | False | | No | An alternate name for the supplier shipping the item. | | ShipFromSupplierSiteId | Long | False | | No | A unique identifier for the supplier site shipping the item. | | ShipFromSupplierSiteName | String | False | | No | The name of the supplier site shipping the item. | | ProcurementBUId | Long | False | | No | A unique identifier for the procurement business unit responsible for the order. | | ProcurementBUName | String | False | | No | The name of the procurement business unit responsible for the order. | | ShipToOrganizationId | String | False | | No | A unique identifier for the organization receiving the shipment. | | ShipToOrganizationCode | String | False | | No | A code representing the organization receiving the shipment. | | ShipToOrganizationName | String | False | | No | The name of the organization receiving the shipment. | | ShipToSupplierId | Long | False | | No | A unique identifier for the supplier delivering to the ship-to location. | | ShipToSupplierName | String | False | | No | The name of the supplier delivering to the ship-to location. | | ShipToSupplierSiteId | Long | False | | No | A unique identifier for the supplier site delivering to the ship-to location. | | ShipToSupplierSiteName | String | False | | No | The name of the supplier site delivering to the ship-to location. | | ShipToCustomerId | Long | False | | No | A unique identifier for the customer receiving the shipment. | | ShipToCustomerName | String | False | | No | The name of the customer receiving the shipment. | | ShipToCustomerSiteId | Long | False | | No | A unique identifier for the customer site receiving the shipment. | | ShipToCustomerSiteName | String | False | | No | The name of the customer site receiving the shipment. | | InventoryItemId | String | False | | No | A unique identifier for the inventory item included in the forecast. | | ItemNumber | String | False | | No | A unique identifier for the item in the forecast. | | ItemDescription | String | False | | No | A detailed description of the item in the forecast. | | ItemCategory | String | False | | No | The category or classification of the item in the forecast. | | UOMCode | String | False | | No | A code representing the unit of measure for the item. | | UnitOfMeasure | String | False | | No | The unit of measure in which the item is quantified. | | SupplierItemNumber | String | False | | No | The supplier's unique identifier for the item. | | ManufacturerName | String | False | | No | The name of the manufacturer of the item. | | ManufacturerPartNumber | String | False | | No | The manufacturer's part number for the item. | | ForecastTotalForecastHorizonQuantity | Decimal | False | | No | The total forecasted quantity for the forecast horizon. | | ForecastTotalCommitHorizonQuantity | Decimal | False | | No | The total committed quantity for the commit horizon. | | CommitTotalQuantity | Decimal | False | | No | The total quantity committed by the supplier. | | OnHandQuantity | Decimal | False | | No | The quantity of the item currently available on hand. | | SupplierOnHandQuantity | Decimal | False | | No | The quantity of the item reported by the supplier as on hand. | | SupplierOnHandPublishedDate | Datetime | False | | No | The date and time when the supplier's on-hand quantity was published. | | SupplierOnHandPublishedByUserName | String | False | | No | The username of the person who published the supplier's on-hand quantity. | | PublishedDate | Datetime | False | | No | The date and time when the forecast was published. | | PublishedByPersonId | Long | False | | No | A unique identifier for the person who published the forecast. | | PublishedByUserName | String | False | | No | The username of the person who published the forecast. | | OnHandPublishedDate | Datetime | False | | No | The date and time when the on-hand quantity was published. | | OnHandPublishedByUserName | String | False | | No | The username of the person who published the on-hand quantity. | | CommitDate | Datetime | False | | No | The date when the commitment was made. | | CommitDueDate | Datetime | False | | No | The date by which the committed quantity is expected to be fulfilled. | | Status | String | False | | No | The current status of the collaboration order forecast. | | StatusCode | String | False | | No | A code representing the current status of the forecast. | | CollaborationCycleVersion | Int | False | | No | The version of the collaboration cycle for this forecast. | | CreatedByPersonId | Long | False | | No | A unique identifier for the person who created the forecast. | | CreatedBy | String | False | | No | The username of the person who created the forecast. | | CreationDate | Datetime | False | | No | The date and time when the forecast was created. | | LastUpdatedBy | String | False | | No | The username of the person who last updated the forecast. | | LastUpdateDate | Datetime | False | | No | The date and time when the forecast was last updated. | | B2BOnlyFlag | Bool | False | | No | Indicates whether the forecast is restricted to B2B transactions. | | DropShipFlag | Bool | False | | No | Indicates whether the forecast is for a drop-shipment order. | | NoteToSupplier | String | False | | No | A note from the collaboration planner to the supplier regarding the forecast. | | NoteToPlanner | String | False | | No | A note from the supplier to the collaboration planner regarding the forecast. | | Finder | String | False | | No | A system-generated reference used to locate the collaboration order forecast. | [Return to Top](#objects-supported) ## CollaborationOrderForecastscommitQuantities | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------------------------------------- | -------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | False | | No | A unique identifier linking the committed quantities to the corresponding collaboration order forecast. | | CollaborationOrderForecastId | Long | False | | No | A unique identifier for the collaboration order forecast associated with this commit quantity. | | CollaborationOrderForecastDetailsId [KEY] | Long | False | | No | A unique identifier for the detailed record associated with the collaboration order forecast. | | BucketId [KEY] | Long | False | | No | A unique identifier for the time bucket used in the commit quantity. | | CorrelationCode | String | False | | No | A unique code identifying the orchestration process instance. | | BucketStartDate | Date | False | | No | The date when the time bucket for the commit quantity begins. | | BucketEndDate | Date | False | | No | The date when the time bucket for the commit quantity ends. | | BucketAggregationCode | String | False | | No | The code indicating the bucket aggregation type for the commit quantity. Accepted values are defined in the lookup type ORA_VCS_BUCKET_AGGR_LEVEL. These values can be managed in the Setup and Maintenance work area under the Manage Supply Chain Collaboration Lookups task. | | Quantity | Decimal | False | | No | The quantity that the supplier has committed to supply. | | CommitMismatchReasonCode | String | False | | No | A code representing the reason the supplier could not commit to the requested forecast quantity, resulting in a mismatch. | | CommitMismatchReason | String | False | | No | A description of the reason for the commit mismatch between the requested and committed quantities. | | Version | Int | False | | No | The version number of the commit time bucket for the collaboration order forecast. | | CommittedByPersonId | Long | False | | No | A unique identifier for the user who committed the quantity. | | CommittedByUserName | String | False | | No | The username of the person who committed the quantity. | | CommitDate | Datetime | False | | No | The date and time when the commit quantity was last confirmed. | | CommittedByPartyCode | String | False | | No | A code identifying the type of user who performed the commit action. Accepted values are defined in the lookup type ORA_VCS_PARTY_ORIGIN. These values can be managed in the Setup and Maintenance work area under the Manage Supply Chain Collaboration Lookups task. | | Finder | String | False | | No | A system-generated reference used to locate the committed quantities for the collaboration order forecast. | [Return to Top](#objects-supported) ## CollaborationOrderForecastsexceptionQuantities | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------------------------------------- | ------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | False | | No | A unique identifier linking the exception quantities to the corresponding collaboration order forecast. | | CollaborationOrderForecastId | Long | False | | No | A unique identifier for the collaboration order forecast associated with this exception quantity. | | ExceptionId [KEY] | Long | False | | No | A unique identifier for the exception record related to the forecast. | | BucketId [KEY] | Long | False | | No | A unique identifier for the time bucket in which the exception occurred. | | ExceptionTypeCode | String | False | | No | A code representing the type of exception that occurred in the forecasted quantities. | | BucketAggregationCode | String | False | | No | A code indicating the bucket aggregation type for the exception quantity. | | BucketStartDate | Date | False | | No | The date when the time bucket for the exception quantity begins. | | BucketEndDate | Date | False | | No | The date when the time bucket for the exception quantity ends. | | ExceptionFactor | Decimal | False | | No | A numerical factor representing the magnitude or severity of the exception. | | PrimaryExceptionVariable | Decimal | False | | No | The primary variable contributing to the exception in the forecast. | | SecondaryExceptionVariable | Decimal | False | | No | The secondary variable contributing to the exception in the forecast. | | MaximumCommitVersion | Int | False | | No | The highest commit version impacted by the exception. | | MaximumForecastVersion | Int | False | | No | The highest forecast version impacted by the exception. | | Finder | String | False | | No | A system-generated reference used to locate the exception quantities for the collaboration order forecast. | [Return to Top](#objects-supported) ## CollaborationOrderForecastsforecastQuantities | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------------------------------------- | -------- | -------- | ---------- | ---------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | False | | No | A unique identifier linking the forecast quantities to the corresponding collaboration order forecast. | | CollaborationOrderForecastId | Long | False | | No | A unique identifier for the collaboration order forecast associated with this forecast quantity. | | CorrelationCode | String | False | | No | A unique code identifying the orchestration process instance. | | CollaborationOrderForecastDetailsId [KEY] | Long | False | | No | A unique identifier for the detailed record associated with the collaboration order forecast. | | BucketId [KEY] | Long | False | | No | A unique identifier for the time bucket used in the forecast quantity. | | BucketStartDate | Date | False | | No | The date when the time bucket for the forecast quantity begins. | | BucketEndDate | Date | False | | No | The date when the time bucket for the forecast quantity ends. | | BucketAggregationCode | String | False | | No | The code indicating the bucket aggregation type for the forecast quantity. Accepted values are defined in the lookup type ORA_VCS_BUCKET_AGGR_LEVEL. These values can be managed in the Setup and Maintenance work area under the Manage Supply Chain Collaboration Lookups task. | | Quantity | Decimal | False | | No | The forecasted supply quantity for the specified time bucket. | | Version | Int | False | | No | The version number of the forecast time bucket for the collaboration order forecast. | | PublishedByPersonId | Long | False | | No | A unique identifier for the person who last published the forecast quantity. | | PublishedByUserName | String | False | | No | The username of the person who most recently published the forecast quantity. | | PublishedDate | Datetime | False | | No | The date and time when the forecast quantity was published. | | PublishSourceCode | String | False | | No | A code identifying the type of user who performed the publish action. Accepted values are defined in the lookup type ORA_VCS_PARTY_ORIGIN. These values can be managed in the Setup and Maintenance work area under the Manage Supply Chain Collaboration Lookups task. | | Finder | String | False | | No | A system-generated reference used to locate the forecast quantities for the collaboration order forecast. | [Return to Top](#objects-supported) ## CollaborationOrderForecastsreferenceQuantities | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------------------------------------- | -------- | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------------------------------- | | CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | False | | No | A unique identifier linking the reference quantities to the corresponding collaboration order forecast. | | CollaborationOrderForecastId | Long | False | | No | A unique identifier for the collaboration order forecast associated with this reference quantity. | | RefercenceDetailsId [KEY] | Long | False | | No | A unique identifier for the reference details record related to the forecast. | | BucketId | Long | False | | No | A unique identifier for the time bucket in which the reference quantity applies. | | PublisherOrderTypeCode | String | False | | No | A code representing the type of order for the reference quantity. | | BucketStartDate | Date | False | | No | The date when the time bucket for the reference quantity begins. | | BucketEndDate | Date | False | | No | The date when the time bucket for the reference quantity ends. | | Quantity | Decimal | False | | No | The reference quantity associated with the forecast. | | DocumentReferenceNumber | String | False | | No | A reference number linking the forecast quantity to an external document or transaction. | | PublishedByPersonId | Long | False | | No | A unique identifier for the person who last published the reference quantity. | | PublishedByUserName | String | False | | No | The username of the person who published the reference quantity. | | PublishDate | Datetime | False | | No | The date and time when the reference quantity was published. | | PublishSourceCode | String | False | | No | A code identifying the type of user who performed the publish action. | | Finder | String | False | | No | A system-generated reference used to locate the reference quantities for the collaboration order forecast. | [Return to Top](#objects-supported) ## Finders | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------- | ------ | -------- | ---------- | ---------- | ----------------------------------------------------------------------- | | ViewName | String | False | | No | The name of the database view for which the finder is being identified. | | FinderName | String | False | | No | The name of the finder used to locate specific records within the view. | | AttributeFinderColumn | String | False | | No | The name of the attribute used as a search parameter in the finder. | | Type | String | False | | No | The data type of the finder attribute. | [Return to Top](#objects-supported) ## FlexFndDffDescriptiveFlexfieldContexts | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------------------ | ------ | -------- | ---------- | ---------- | ------------------------------------------------------------------------------------------ | | ApplicationId [KEY] | Long | False | | No | A unique identifier for the application associated with the descriptive flexfield context. | | DescriptiveFlexfieldCode [KEY] | String | False | | No | A code representing the descriptive flexfield within the application. | | ContextCode [KEY] | String | False | | No | A unique code identifying the specific context for the descriptive flexfield. | | Name | String | False | | No | The name assigned to the descriptive flexfield context. | | Description | String | False | | No | A description providing details about the descriptive flexfield context. | | EnabledFlag | String | False | | No | Indicates whether the descriptive flexfield context is enabled. | | Bind_ApplicationId | Long | False | | No | A reference to the application ID associated with the flexfield binding. | | Bind_DescriptiveFlexfieldCode | String | False | | No | A reference to the descriptive flexfield code used in binding. | | Finder | String | False | | No | A system-generated reference used to locate the descriptive flexfield contexts. | [Return to Top](#objects-supported) ## FlexFndPvsCharacterIdCharacterValues | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | ------ | -------- | ---------- | ---------- | ---------------------------------------------------------------------------------- | | Id [KEY] | String | False | | No | A unique identifier for the character value in the flexfield. | | Value | String | False | | No | The actual character value associated with the flexfield. | | Description | String | False | | No | A description providing details about the character value. | | StartDateActive | Date | False | | No | The date when the character value becomes active. | | EndDateActive | Date | False | | No | The date when the character value is no longer active. | | EnabledFlag | String | False | | No | Indicates whether the character value is enabled. | | SummaryFlag | String | False | | No | Indicates whether the character value is a summary value. | | ValueSetCode | String | False | | No | A code representing the value set associated with this character value. | | Bind_DataSource | String | False | | No | The data source associated with the flexfield binding. | | Bind_FinderContext | String | False | | No | The finder context used in the flexfield binding. | | Bind_FinderDateFlag | String | False | | No | Indicates whether the finder uses a date-based validation. | | Bind_ValidationDate | Date | False | | No | The date used for validation in the flexfield binding. | | Finder | String | False | | No | A system-generated reference used to locate the character values in the flexfield. | | Flex_vst_bind1 | String | False | | No | Reserved flexfield binding parameter 1. | | Flex_vst_bind10 | String | False | | No | Reserved flexfield binding parameter 10. | | Flex_vst_bind11 | String | False | | No | Reserved flexfield binding parameter 11. | | Flex_vst_bind12 | String | False | | No | Reserved flexfield binding parameter 12. | | Flex_vst_bind13 | String | False | | No | Reserved flexfield binding parameter 13. | | Flex_vst_bind14 | String | False | | No | Reserved flexfield binding parameter 14. | | Flex_vst_bind15 | String | False | | No | Reserved flexfield binding parameter 15. | | Flex_vst_bind16 | String | False | | No | Reserved flexfield binding parameter 16. | | Flex_vst_bind17 | String | False | | No | Reserved flexfield binding parameter 17. | | Flex_vst_bind18 | String | False | | No | Reserved flexfield binding parameter 18. | | Flex_vst_bind19 | String | False | | No | Reserved flexfield binding parameter 19. | | Flex_vst_bind2 | String | False | | No | Reserved flexfield binding parameter 2. | | Flex_vst_bind20 | String | False | | No | Reserved flexfield binding parameter 20. | | Flex_vst_bind3 | String | False | | No | Reserved flexfield binding parameter 3. | | Flex_vst_bind4 | String | False | | No | Reserved flexfield binding parameter 4. | | Flex_vst_bind5 | String | False | | No | Reserved flexfield binding parameter 5. | | Flex_vst_bind6 | String | False | | No | Reserved flexfield binding parameter 6. | | Flex_vst_bind7 | String | False | | No | Reserved flexfield binding parameter 7. | | Flex_vst_bind8 | String | False | | No | Reserved flexfield binding parameter 8. | | Flex_vst_bind9 | String | False | | No | Reserved flexfield binding parameter 9. | [Return to Top](#objects-supported) ## FlexFndPvsCharacterValues | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | ------ | -------- | ---------- | ---------- | -------------------------------------------------------------------------------- | | Value [KEY] | String | False | | No | The character value associated with the flexfield. | | Description | String | False | | No | A description providing details about the character value. | | StartDateActive | Date | False | | No | The date when the character value becomes active. | | EndDateActive | Date | False | | No | The date when the character value is no longer active. | | EnabledFlag | String | False | | No | Indicates whether the character value is enabled. | | SummaryFlag | String | False | | No | Indicates whether the character value is a summary value. | | ValueSetCode | String | False | | No | A code representing the value set associated with this character value. | | Bind_AttrMap | String | False | | No | The attribute mapping used in the flexfield binding. | | Bind_DataSource | String | False | | No | The data source associated with the flexfield binding. | | Bind_DataSourceDiscr | String | False | | No | The discriminator value used to differentiate data sources in flexfield binding. | | Bind_FinderContext | String | False | | No | The finder context used in the flexfield binding. | | Bind_FinderDateFlag | String | False | | No | Indicates whether the finder uses a date-based validation. | | Bind_ValidationDate | Date | False | | No | The date used for validation in the flexfield binding. | | Finder | String | False | | No | A system-generated reference used to locate character values in the flexfield. | | Flex_vst_bind1 | String | False | | No | Reserved flexfield binding parameter 1. | | Flex_vst_bind10 | String | False | | No | Reserved flexfield binding parameter 10. | | Flex_vst_bind11 | String | False | | No | Reserved flexfield binding parameter 11. | | Flex_vst_bind12 | String | False | | No | Reserved flexfield binding parameter 12. | | Flex_vst_bind13 | String | False | | No | Reserved flexfield binding parameter 13. | | Flex_vst_bind14 | String | False | | No | Reserved flexfield binding parameter 14. | | Flex_vst_bind15 | String | False | | No | Reserved flexfield binding parameter 15. | | Flex_vst_bind16 | String | False | | No | Reserved flexfield binding parameter 16. | | Flex_vst_bind17 | String | False | | No | Reserved flexfield binding parameter 17. | | Flex_vst_bind18 | String | False | | No | Reserved flexfield binding parameter 18. | | Flex_vst_bind19 | String | False | | No | Reserved flexfield binding parameter 19. | | Flex_vst_bind2 | String | False | | No | Reserved flexfield binding parameter 2. | | Flex_vst_bind20 | String | False | | No | Reserved flexfield binding parameter 20. | | Flex_vst_bind3 | String | False | | No | Reserved flexfield binding parameter 3. | | Flex_vst_bind4 | String | False | | No | Reserved flexfield binding parameter 4. | | Flex_vst_bind5 | String | False | | No | Reserved flexfield binding parameter 5. | | Flex_vst_bind6 | String | False | | No | Reserved flexfield binding parameter 6. | | Flex_vst_bind7 | String | False | | No | Reserved flexfield binding parameter 7. | | Flex_vst_bind8 | String | False | | No | Reserved flexfield binding parameter 8. | | Flex_vst_bind9 | String | False | | No | Reserved flexfield binding parameter 9. | [Return to Top](#objects-supported) ## FlexFndPvsNumberIdCharacterValues | Name | Type | ReadOnly | References | FilterOnly | Description | | ------------------- | ------- | -------- | ---------- | ---------- | ------------------------------------------------------------------------------ | | Id [KEY] | Decimal | False | | No | A unique numeric identifier for the character value in the flexfield. | | Value | String | False | | No | The character value associated with the flexfield. | | Description | String | False | | No | A description providing details about the character value. | | StartDateActive | Date | False | | No | The date when the character value becomes active. | | EndDateActive | Date | False | | No | The date when the character value is no longer active. | | EnabledFlag | String | False | | No | Indicates whether the character value is enabled. | | SummaryFlag | String | False | | No | Indicates whether the character value is a summary value. | | ValueSetCode | String | False | | No | A code representing the value set associated with this character value. | | Bind_DataSource | String | False | | No | The data source associated with the flexfield binding. | | Bind_FinderContext | String | False | | No | The finder context used in the flexfield binding. | | Bind_FinderDateFlag | String | False | | No | Indicates whether the finder uses a date-based validation. | | Bind_ValidationDate | Date | False | | No | The date used for validation in the flexfield binding. | | Finder | String | False | | No | A system-generated reference used to locate character values in the flexfield. | | Flex_vst_bind1 | String | False | | No | Reserved flexfield binding parameter 1. | | Flex_vst_bind10 | String | False | | No | Reserved flexfield binding parameter 10. | | Flex_vst_bind11 | String | False | | No | Reserved flexfield binding parameter 11. | | Flex_vst_bind12 | String | False | | No | Reserved flexfield binding parameter 12. | | Flex_vst_bind13 | String | False | | No | Reserved flexfield binding parameter 13. | | Flex_vst_bind14 | String | False | | No | Reserved flexfield binding parameter 14. | | Flex_vst_bind15 | String | False | | No | Reserved flexfield binding parameter 15. | | Flex_vst_bind16 | String | False | | No | Reserved flexfield binding parameter 16. | | Flex_vst_bind17 | String | False | | No | Reserved flexfield binding parameter 17. | | Flex_vst_bind18 | String | False | | No | Reserved flexfield binding parameter 18. | | Flex_vst_bind19 | String | False | | No | Reserved flexfield binding parameter 19. | | Flex_vst_bind2 | String | False | | No | Reserved flexfield binding parameter 2. | | Flex_vst_bind20 | String | False | | No | Reserved flexfield binding parameter 20. | | Flex_vst_bind3 | String | False | | No | Reserved flexfield binding parameter 3. | | Flex_vst_bind4 | String | False | | No | Reserved flexfield binding parameter 4. | | Flex_vst_bind5 | String | False | | No | Reserved flexfield binding parameter 5. | | Flex_vst_bind6 | String | False | | No | Reserved flexfield binding parameter 6. | | Flex_vst_bind7 | String | False | | No | Reserved flexfield binding parameter 7. | | Flex_vst_bind8 | String | False | | No | Reserved flexfield binding parameter 8. | | Flex_vst_bind9 | String | False | | No | Reserved flexfield binding parameter 9. | [Return to Top](#objects-supported) ## StandardLookupsLOV | Name | Type | ReadOnly | References | FilterOnly | Description | | --------------------------- | ------ | -------- | ---------- | ---------- | ------------------------------------------------------------------------ | | LookupType [KEY] | String | False | | No | The category or type of lookup associated with the value. | | LookupCode [KEY] | String | False | | No | A unique code representing a specific lookup value. | | Meaning | String | False | | No | The user-friendly meaning or label associated with the lookup code. | | Description | String | False | | No | A detailed description of the lookup value. | | Tag | String | False | | No | An optional tag used for classification or grouping of the lookup value. | | ActiveDate | Date | False | | No | The date when the lookup value becomes active. | | Bind_ParentLookupCode | String | False | | No | The parent lookup code to which this lookup value is related. | | Bind_ParentSetidDetermType | String | False | | No | Specifies the determination type for the parent set ID. | | Bind_ParentSetidDetermValue | String | False | | No | The value used to determine the parent set ID. | | Bind_RelationshipId | Long | False | | No | A unique identifier for the relationship between lookups. | | BindActiveDate | Date | False | | No | The active date for the bound lookup relationship. | | BindLookupCode | String | False | | No | The lookup code to which this lookup value is bound. | | BindLookupType | String | False | | No | The lookup type to which this lookup value is bound. | | BindTag | String | False | | No | A tag associated with the bound lookup relationship. | | Finder | String | False | | No | A system-generated reference used to locate lookup values. | | NewLookupCode1 | String | False | | No | A new or alternative lookup code that can be used as a reference. | | NewLookupCode2 | String | False | | No | A second alternative lookup code that can be used as a reference. | | NewLookupCode3 | String | False | | No | A third alternative lookup code that can be used as a reference. | | NewLookupCode4 | String | False | | No | A fourth alternative lookup code that can be used as a reference. | | NewLookupCode5 | String | False | | No | A fifth alternative lookup code that can be used as a reference. | [Return to Top](#objects-supported)