Salesforce Docs Portal

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. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name Description
CollaborationOrderForecastRequests Facilitates supplier collaboration by requesting order forecasts and tracking the status of submitted requests.
CollaborationOrderForecastRequestsdetails Manages detailed information about requested collaboration order forecasts for streamlined planning.
CollaborationOrderForecastRequestsrequestStatusDetails Tracks and manages the status of collaboration order forecasts, including processing details and error messages.
CollaborationOrderForecasts Provides access to published order forecasts for supplier collaboration and enables response submissions for supply commitments.
CollaborationOrderForecastscommitQuantities Retrieves and manages commit measure details associated with collaboration order forecasts, including supply commit responses.
CollaborationOrderForecastsexceptionQuantities Highlights forecast and commit exceptions, such as changes or mismatches, to ensure planning accuracy.
CollaborationOrderForecastsforecastQuantities Manages forecast measure details, allowing updates and new entries for collaboration order forecasts.
CollaborationOrderForecastsreferenceQuantities Provides access to additional measures for collaboration order forecasts, such as purchasing metrics, enhancing decision-making.
Finders Lists finder names and associated attributes for specific views, aiding in efficient data retrieval.
FlexFndDffDescriptiveFlexfieldContexts Enables management and retrieval of descriptive flexfield contexts using REST API endpoints.
FlexFndPvsCharacterIdCharacterValues Supports retrieval of character-based flexfield values through REST API endpoints for enhanced data configuration.
FlexFndPvsCharacterValues Facilitates access to character-based flexfield values, enabling detailed customizations in Oracle SCM.
FlexFndPvsNumberIdCharacterValues Manages numeric flexfield values for extended data configuration and retrieval.
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

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

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

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

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

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

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

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

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

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

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

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

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

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