Oracle Fusion Cloud SCM Connector Objects (SupplyChainPlanning Schema)

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.

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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