XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for DiffDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
diff_id |
varchar210 |
1 |
1 |
This field will hold a unique number (identifier) of the differentiator. |
DIFFERENTIATOR |
ID |
VARCHAR2 |
10 |
Yes |
This field will hold a unique number (identifier) of 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. |
DIFFERENTIATOR |
DIFF_TYPE_ID |
VARCHAR2 |
10 |
No |
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_desc |
varchar2120 |
1 |
1 |
Not Yet Available |
DIFFERENTIATOR |
DESCRIPTION |
VARCHAR2 |
255 |
Yes |
description of the differential number. (for example, blueberry, shower fresh, red, etc.) |
industry_code |
varchar210 |
0 |
1 |
A unique number that represents all possible combinations of sizes according to the National Retail Federation. |
Fill application table name. |
null |
varchar2 |
10 |
null |
Not used in SIM |
industry_subcode |
varchar210 |
0 |
1 |
A unique number that represents all different color range groups. |
Fill application table name. |
null |
varchar2 |
10 |
null |
Not used in SIM |