XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for UDADesc in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
uda_id |
number5 |
1 |
1 |
Description is not available. |
attribute_type |
attribute_type |
number |
5 |
Yes |
Populates attribute_type in attribute_type table |
uda_desc |
varchar2120 |
1 |
1 |
Description is not available. |
attribute_type |
description |
varchar2 |
120 |
Yes |
Populates description in attribute_type table |
module |
varchar220 |
1 |
1 |
Indicates which system module the UDA belongs to. This will always be 'ITEM'. |
n/a |
n/a |
* |
* |
Yes |
Not used by RWMS. |
display_type |
varchar22 |
1 |
1 |
A code to indicate how the UDA will be displayed to the user. Values are in the UDIS code table. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
data_type |
varchar212 |
0 |
1 |
Optional field indicating what value types are valid for this UDA. Valid types are NUM, ALPHA, DATE. |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
data_length |
number3 |
0 |
1 |
Not used in RWMS. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS. |
single_value_ind |
varchar21 |
0 |
1 |
Y or N to indicate whether the UDA is limited to having at most one value. |
n/a |
n/a |
varchar2 |
1 |
No |
Not used by RWMS. |
host_ind |
varchar21 |
0 |
1 |
Description is not available. |
attribute_type |
host_type |
varchar2 |
1 |
No |
Populates host_type in attribute_type table. Uses Default of "U" if value is null. |
carton_group |
varchar21 |
0 |
1 |
Description is not available. |
attribute_type |
carton_group |
varchar2 |
1 |
No |
Valid Carton Group Identifier. Populates carton_group in attribute_type table. Uses Default of "N" if value is null. |
combinability |
varchar21 |
0 |
1 |
Description is not available. |
n/a |
n/a |
* |
* |
No |
Not used in RWMS |