Custom Lookup Data Type field specifications

This table lists the field-column specifications in the Custom Lookup Data Type import interface. Fields with the asterisk (*) symbol are required.

Col. Field Name Type Size/Format Description
1 WBCLDT_NAME* Varchar2 40 The name of the custom lookup data type.
2 WBCLDT_DESC Varchar2 100 A description for the custom lookup data type.
3 WBCLDT_FLAG1 Varchar2 1 One-character flag for general use.

A {space} in one of the flag positions indicates no processing is to be done for that flag.

An ampersand (&) in one of the flag positions indicates the flag is to be blanked.
4 WBCLDT_FLAG2 Varchar2 1 One-character flag for general use.
5 WBCLDT_FLAG3 Varchar2 1 One-character flag for general use.
6 WBCLDT_FLAG4 Varchar2 1 One-character flag for general use.
7 WBCLDT_FLAG5 Varchar2 1 One-character flag for general use.
8 WBCLDT_UDF1 Varchar2 40 User defined field.
9 WBCLDT_UDF2 Varchar2 40 User defined field.
10 WBCLDT_UDF3 Varchar2 40 User defined field.
11 WBCLDT_UDF4 Varchar2 40 User defined field.
12 WBCLDT_UDF5 Varchar2 40 User defined field.
13 WBCLDT_TEXT1NAME Varchar2 40 User defined field.
14 WBCLDT_TEXT2NAME Varchar2 40 User defined field.
15 WBCLDT_TEXT3NAME Varchar2 40 User defined field.
16 WBCLDT_TEXT4NAME Varchar2 40 User defined field.
17 WBCLDT_TEXT5NAME Varchar2 40 User defined field.
18 WBCLDT_TEXT6NAME Varchar2 40 User defined field.
19 WBCLDT_TEXT7NAME Varchar2 40 User defined field.
20 WBCLDT_TEXT8NAME Varchar2 40 User defined field.
21 WBCLDT_TEXT9NAME Varchar2 40 User defined field.
22 WBCLDT_TEXT10NAME Varchar2 40 User defined field.
23 WBCLDT_CHAR1NAME Varchar2 40 User defined field.
24 WBCLDT_CHAR2NAME Varchar2 40 User defined field.
25 WBCLDT_CHAR3NAME Varchar2 40 User defined field.
26 WBCLDT_CHAR4NAME Varchar2 40 User defined field.
27 WBCLDT_CHAR5NAME Varchar2 40 User defined field.
28 WBCLDT_CHAR6NAME Varchar2 40 User defined field.
29 WBCLDT_CHAR7NAME Varchar2 40 User defined field.
30 WBCLDT_CHAR8NAME Varchar2 40 User defined field.
31 WBCLDT_CHAR9NAME Varchar2 40 User defined field.
32 WBCLDT_CHAR10NAME Varchar2 40 User defined field.
33 WBCLDT_DATE1NAME Varchar2 40 User defined field.
34 WBCLDT_DATE2NAME Varchar2 40 User defined field.
35 WBCLDT_DATE3NAME Varchar2 40 User defined field.
36 WBCLDT_DATE4NAME Varchar2 40 User defined field.
37 WBCLDT_DATE5NAME Varchar2 40 User defined field.
38 WBCLDT_DATE6NAME Varchar2 40 User defined field.
39 WBCLDT_DATE7NAME Varchar2 40 User defined field.
40 WBCLDT_DATE8NAME Varchar2 40 User defined field.
41 WBCLDT_DATE9NAME Varchar2 40 User defined field.
42 WBCLDT_DATE10NAME Varchar2 40 User defined field.
43 WBCLDT_NUM1NAME Varchar2 40 User defined field.
44 WBCLDT_NUM2NAME Varchar2 40 User defined field.
45 WBCLDT_NUM3NAME Varchar2 40 User defined field.
46 WBCLDT_NUM4NAME Varchar2 40 User defined field.
47 WBCLDT_NUM5NAME Varchar2 40 User defined field.
48 WBCLDT_NUM6NAME Varchar2 40 User defined field.
49 WBCLDT_NUM7NAME Varchar2 40 User defined field.
50 WBCLDT_NUM8NAME Varchar2 40 User defined field.
51 WBCLDT_NUM9NAME Varchar2 40 User defined field.
52 WBCLDT_NUM10NAME Varchar2 40 User defined field.
53 WBCLDT_DEC1NAME Varchar2 40 User defined field.
54 WBCLDT_DEC2NAME Varchar2 40 User defined field.
55 WBCLDT_DEC3NAME Varchar2 40 User defined field.
56 WBCLDT_DEC4NAME Varchar2 40 User defined field.
57 WBCLDT_DEC5NAME Varchar2 40 User defined field.
58 WBCLDT_DEC6NAME Varchar2 40 User defined field.
59 WBCLDT_DEC7NAME Varchar2 40 User defined field.
60 WBCLDT_DEC8NAME Varchar2 40 User defined field.
61 WBCLDT_DEC9NAME Varchar2 40 User defined field.
62 WBCLDT_DEC10NAME Varchar2 40 User defined field.