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. |