XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for DiffDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
diff_id |
varchar210 |
1 |
1 |
This field will hold a unique number (identifier) of the differentiator. |
diff_ids |
diff_id |
null |
null |
Yes |
This field contains a unique number to identify the differentiator. |
diff_type |
varchar26 |
1 |
1 |
This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table. |
diff_ids |
diff_type |
null |
null |
Yes |
This field contains a value of all possible differential types. Valid values are stored in the code_detail table with a code_type of DIFF. Valid values are also found in the diff_type table. |
diff_desc |
varchar2120 |
1 |
1 |
Not Yet Available |
diff_ids |
diff_desc |
varchar2 |
120 |
Yes |
Description of the differential ID. |
industry_code |
varchar210 |
0 |
1 |
A unique number that represents all possible combinations of sizes according to the National Retail Federation. |
diff_ids |
industry_code |
varchar2 |
10 |
No |
A unique number that represents all possible combinations of sizes, according to the National Retail Federation. |
industry_subcode |
varchar210 |
0 |
1 |
A unique number that represents all different color range groups. |
diff_ids |
industry_subgroup |
varchar2 |
10 |
No |
A unique number that represents all different color range groups. |