Custom Lookup Data field specifications

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

Col. Field Name Type Size/Format Description
1 WBCLDT_ID* Number 22 The custom lookup data type ID from the WB_CUSTOM_LOOKUP_DATA_TYPE table.
2 WBCLD_NAME* Varchar2 40 The Custom Lookup Data name.
3 WBCLD_DESC Varchar2 100 The description for the Custom Lookup Data.
4 WBCLD_TEXT1 Varchar2 400 User defined field.
5 WBCLD_TEXT2 400 User defined field.
6 WBCLD_TEXT3 400 User defined field.
7 WBCLD_TEXT4 400 User defined field.
8 WBCLD_TEXT5 400 User defined field.
9 WBCLD_TEXT6 400 User defined field.
10 WBCLD_TEXT7 400 User defined field.
11 WBCLD_TEXT8 400 User defined field.
12 WBCLD_TEXT9 400 User defined field.
13 WBCLD_TEXT10 400 User defined field.
14 WBCLD_CHAR1 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.

15 WBCLD_CHAR2 Varchar2 1 One-character flag for general use.
16 WBCLD_CHAR3 Varchar2 1 One-character flag for general use.
17 WBCLD_CHAR4 Varchar2 1 One-character flag for general use.
18 WBCLD_CHAR5 Varchar2 1 One-character flag for general use.
19 WBCLD_CHAR6 Varchar2 1 One-character flag for general use.
20 WBCLD_CHAR7 Varchar2 1 One-character flag for general use.
21 WBCLD_CHAR8 Varchar2 1 One-character flag for general use.
22 WBCLD_CHAR9 Varchar2 1 One-character flag for general use.
23 WBCLD_CHAR10 Varchar2 1 One-character flag for general use.
24 WBCLD_DATE1 Date yyyyMMdd User defined field.
25 WBCLD_DATE2 Date yyyyMMdd User defined field.
26 WBCLD_DATE3 Date yyyyMMdd User defined field.
27 WBCLD_DATE4 Date yyyyMMdd User defined field.
28 WBCLD_DATE5 Date yyyyMMdd User defined field.
29 WBCLD_DATE6 Date yyyyMMdd User defined field.
30 WBCLD_DATE7 Date yyyyMMdd User defined field.
31 WBCLD_DATE8 Date yyyyMMdd User defined field.
32 WBCLD_DATE9 Date yyyyMMdd User defined field.
33 WBCLD_DATE10 Date yyyyMMdd User defined field.
34 WBCLD_NUM1 Number 22 User defined field.
35 WBCLD_NUM2 Number 22 User defined field.
36 WBCLD_NUM3 Number 22 User defined field.
37 WBCLD_NUM4 Number 22 User defined field.
38 WBCLD_NUM5 Number 22 User defined field.
39 WBCLD_NUM6 Number 22 User defined field.
40 WBCLD_NUM7 Number 22 User defined field.
41 WBCLD_NUM8 Number 22 User defined field.
42 WBCLD_NUM9 Number 22 User defined field.
43 WBCLD_NUM10 Number 22 User defined field.
44 WBCLD_DEC1 Number 22 User defined field.
45 WBCLD_DEC2 Number 22 User defined field.
46 WBCLD_DEC3 Number 22 User defined field.
47 WBCLD_DEC4 Number 22 User defined field.
48 WBCLD_DEC5 Number 22 User defined field.
49 WBCLD_DEC6 Number 22 User defined field.
50 WBCLD_DEC7 Number 22 User defined field.
51 WBCLD_DEC8 Number 22 User defined field.
52 WBCLD_DEC9 Number 22 User defined field.
53 WBCLD_DEC10 Number 22 User defined field.