These are being used in the RTLFiRST Database for the Realtime Lookup function to work within the RTLFiRST.

RTLLookupFieldConfigOP – it contains the return parameters of the Realtime Lookup.

RTLLookupFieldConfigIP – it contains the search parameters used for the Exact and Wild Search in Realtime Lookup

 

RTLLookupFieldConfigOP.txt

USE [CheckPro#]
GO
/****** Object: Table [dbo].[RTLLookupFieldConfigOP] Script Date: 05/04/2012 11:26:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RTLLookupFieldConfigOP](

[LookUpIndex] [int] NOT NULL,
[OPFieldNo] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPDisplayName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPReturnField] [int] NULL,
[OPFieldNameReturn] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPParam] [int] NULL,
[OPParamIndex] [int] NULL,
[OPSearchType] [int] NULL

) ON [PRIMARY]

RTLLookupFieldConfigIP.txt

USE [CheckPro#]
GO
/****** Object: Table [dbo].[RTLLookupFieldConfigIP] Script Date: 05/04/2012 11:26:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RTLLookupFieldConfigIP](

[LookUpIndex] [int] NOT NULL,
[IPParam] [int] NULL,
[IPParamFieldName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPDisplayName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPSearchType] [int] NULL,
[IPValueFromField] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPParamIndex] [int] NULL,
[IPRequired] [int] NULL

) ON [PRIMARY]

Need help? Email Us Here! Chat With Us Now!

← Prev Step

Thank you for contacting us. We'll get back to you as soon as we can.

Please provide a valid name, email, and question.

Powered by LivelyChat
Powered by LivelyChat Delete History