User-Defined Field Mapping for Retail Pro Prism
User-Defined Field Mapping for Retail Pro Prism
Retail Pro Prism and RIL both enable users to define custom field labels and field entries to store information specific to the retailer's operation. These are called user-defined fields (UDFs). There are differences in the numbering used by RIL and RP Prism.
Please refer to the following tables for information about how user-defined fields are mapped between RIL and RP Prism.
Inventory UDF Mapping
Inventory records in RP Prism hold five UDF string fields - UDF1_STRING through UDF5_STRING. These correspond to UDF2 through UDF6 in RIL. In the inventory resource in RPS they correspond to udf1_string through udf5_string.
Now there is a new child record called EXTENDED that contains udf6_string through udf15_string fields that correspond to RIL's AUX fields.
The exact mapping between RIL and RP Prism is listed below.
RP Prism |
RIL |
UDF Number in InvnUDF |
UDF1_DATE |
UDF1 |
1 |
UDF1_STRING |
UDF2 |
2 (This is not dictionary-based) |
UDF2_STRING |
UDF3 |
3 |
UDF3_STRING |
UDF4 |
4 |
UDF4_STRING |
UDF5 |
5 |
UDF5_STRING |
UDF6 |
6 |
EXTENDED.UDF6_STRING |
AUX1 |
7 |
EXTENDED.UDF7_STRING |
AUX2 |
8 |
EXTENDED.UDF8_STRING |
AUX3 |
9 |
EXTENDED.UDF9_STRING |
AUX4 |
10 |
EXTENDED.UDF10_STRING |
AUX5 |
11 |
EXTENDED.UDF11_STRING |
AUX6 |
12 |
EXTENDED.UDF12_STRING |
AUX7 |
13 |
EXTENDED.UDF13_STRING |
AUX8 |
14 |
Vendor UDF Mapping
RP Prism |
RIL |
UDF1_STRING |
UDF3 |
UDF2_STRING |
UDF4 |
UDF3_STRING |
UDF5 |
UDF4_STRING |
UDF6 |
UDF5_STRING |
UDF7 |
Invoice/SO UDF Mapping
RP Prism |
RIL |
UDF1_String |
POS flag 1 |
UDF2_String |
POS flag 2 |
UDF3_String |
POS flag 3 |
Customer UDF Mapping
The CustomerUDF resource contains dictionaries for all 18 UDFs (UDF1 and 2 are dates).
RP Prism |
RIL |
UDF Number in Customer UDF |
UDF1_Date |
UDF1 |
1 |
UDF2_DATE |
UDF2 |
2 |
UDFField01 |
UDF3 |
3 |
UDFField02 |
UDF4 |
4 |
UDFField03 |
UDF5 |
5 |
UDFField04 |
UDF6 |
6 |
UDFField05 |
UDF7 |
7 |
Extended.udf6_string |
UDF8 |
8 |
Extended.udf7_string |
AUX1 |
9 |
Extended.udf8_string |
AUX2 |
10 |
Extended.udf9_string |
AUX3 |
11 |
Extended.udf10_string |
AUX4 |
12 |
Extended.udf11_string |
AUX5 |
13 |
Extended.udf12_string |
AUX6 |
14 |
Extended.udf13_string |
AUX7 |
15 |
Extended.ud14_string |
AUX8 |
16 |
Extended.udf15_string |
AUX9 |
17 |
Extended.udf16_string |
AUX10 |
18 |
Extended.udf17_string |
AUX11 |
19 |
Extended.udf18_string |
AUX12 |
20 |