Custom Data field specifications
This table lists the field-column specifications in the Custom Data import interface. Fields
with the asterisk (*) symbol are required.
Note: Previously, WFM only
allowed the values Y and N when importing into single character fields for the
WB_CUSTOM_DATA table. With release 2023.11, you can import other single character values as
well, such as A, B, C.
To enable this option, update the WBCD_CHAR field with the additional parameter as shown in Sample XML and CSV files.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | WBCDT_ID* | Number | 22 | The custom data ID from the WB_CUSTOM_DATA_TYPE table. |
2 | WBCD_TEXT1 | Varchar2 | 400 | User defined field. |
3 | WBCD_TEXT2 | 400 | User defined field. | |
4 | WBCD_TEXT3 | 400 | User defined field. | |
5 | WBCD_TEXT4 | 400 | User defined field. | |
6 | WBCD_TEXT5 | 400 | User defined field. | |
7 | WBCD_TEXT6 | 400 | User defined field. | |
8 | WBCD_TEXT7 | 400 | User defined field. | |
9 | WBCD_TEXT8 | 400 | User defined field. | |
10 | WBCD_TEXT9 | 400 | User defined field. | |
11 | WBCD_TEXT10 | 400 | User defined field. | |
12 | WBCD_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. |
13 | WBCD_CHAR2 | Varchar2 | 1 | One-character flag for general use. |
14 | WBCD_CHAR3 | Varchar2 | 1 | One-character flag for general use. |
15 | WBCD_CHAR4 | Varchar2 | 1 | One-character flag for general use. |
16 | WBCD_CHAR5 | Varchar2 | 1 | One-character flag for general use. |
17 | WBCD_CHAR6 | Varchar2 | 1 | One-character flag for general use. |
18 | WBCD_CHAR7 | Varchar2 | 1 | One-character flag for general use. |
19 | WBCD_CHAR8 | Varchar2 | 1 | One-character flag for general use. |
20 | WBCD_CHAR9 | Varchar2 | 1 | One-character flag for general use. |
21 | WBCD_CHAR10 | Varchar2 | 1 | One-character flag for general use. |
22 | WBCD_DATE1 | Date | yyyyMMdd | User defined field. |
23 | WBCD_DATE2 | Date | yyyyMMdd | User defined field. |
24 | WBCD_DATE3 | Date | yyyyMMdd | User defined field. |
25 | WBCD_DATE4 | Date | yyyyMMdd | User defined field. |
26 | WBCD_DATE5 | Date | yyyyMMdd | User defined field. |
27 | WBCD_DATE6 | Date | yyyyMMdd | User defined field. |
28 | WBCD_DATE7 | Date | yyyyMMdd | User defined field. |
29 | WBCD_DATE8 | Date | yyyyMMdd | User defined field. |
30 | WBCD_DATE9 | Date | yyyyMMdd | User defined field. |
31 | WBCD_DATE10 | Date | yyyyMMdd | User defined field. |
32 | WBCD_NUM1 | Number | 22 | User defined field. |
33 | WBCD_NUM2 | Number | 22 | User defined field. |
34 | WBCD_NUM3 | Number | 22 | User defined field. |
35 | WBCD_NUM4 | Number | 22 | User defined field. |
36 | WBCD_NUM5 | Number | 22 | User defined field. |
37 | WBCD_NUM6 | Number | 22 | User defined field. |
38 | WBCD_NUM7 | Number | 22 | User defined field. |
39 | WBCD_NUM8 | Number | 22 | User defined field. |
40 | WBCD_NUM9 | Number | 22 | User defined field. |
41 | WBCD_NUM10 | Number | 22 | User defined field. |
42 | WBCD_DEC1 | Number | 22 | User defined field. |
43 | WBCD_DEC2 | Number | 22 | User defined field. |
44 | WBCD_DEC3 | Number | 22 | User defined field. |
45 | WBCD_DEC4 | Number | 22 | User defined field. |
46 | WBCD_DEC5 | Number | 22 | User defined field. |
47 | WBCD_DEC6 | Number | 22 | User defined field. |
48 | WBCD_DEC7 | Number | 22 | User defined field. |
49 | WBCD_DEC8 | Number | 22 | User defined field. |
50 | WBCD_DEC9 | Number | 22 | User defined field. |
51 | WBCD_DEC10 | Number | 22 | User defined field. |