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

 

Published on Feb 24, 2020 in Technical Bulletin

 

Find Another Article