XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XMrchHrDeptDesc 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 |
dept |
number4 |
1 |
1 |
The number which uniquely identifies the department. This value cannot be modified. |
deps |
dept |
number |
4 |
Yes |
The number which uniquely identifies the department. This value cannot be modified. |
dept_name |
varchar2120 |
1 |
1 |
The name of the department. |
deps |
dept_name |
varchar2 |
120 |
Yes |
The name of the department. |
buyer |
number4 |
0 |
1 |
The number of the buyer associated to the department. This value must be predefined on the BUYER table. |
deps |
buyer |
number |
4 |
No |
The number of the buyer associated to the department. This value must be predefined on the BUYER table. |
purchase_type |
number1 |
1 |
1 |
The code which indicates whether items in this department are normal merchandise (0) or consignment stock (1). This field cannot be modified. |
deps |
purchase_type |
varchar2 |
6 |
Yes |
The code which indicates whether items in this department are normal merchandise (0) or consignment stock (1). This field cannot be modified. |
total_market_amt |
number24_4 |
0 |
1 |
The total market amount that is expected for the department. This value cannot be less than 1000. |
deps |
total_market_amt |
number |
24 |
No |
The total market amount that is expected for the department. This value cannot be less than 1000. |
merch |
number4 |
0 |
1 |
The number of the merchandiser that is associated to the department. This value must be predefined on the MERCHANT table. |
deps |
merch |
number |
4 |
No |
The number of the merchandiser that is associated to the department. This value must be predefined on the MERCHANT table. |
group_no |
number4 |
1 |
1 |
The number of the group to which the department belongs. This value must be predefined on the GROUPS table. |
deps |
group_no |
number |
4 |
Yes |
The number of the group to which the department belongs. This value must be predefined on the GROUPS table. |
bud_mkup |
number12_4 |
0 |
1 |
The budgeted markup percentage. The markup percent of cost. If this value is not populated on the message it will be calculated to be the inverse of the budgeted intake percentage. This column will hold 70% as 70, not .70. |
deps |
bud_mkup |
number |
12 |
No |
The budgeted markup percentage. The markup percent of cost. If this value is not populated on the message it will be calculated to be the inverse of the budgeted intake percentage. This column will hold 70% as 70, not .70. |
profit_calc_type |
number1 |
1 |
1 |
The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This value cannot be modified. |
deps |
profit_calc_type |
number |
1 |
Yes |
The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This value cannot be modified. |
markup_calc_type |
varchar22 |
1 |
1 |
The code letter that indicates how markup is calculated in this department. Valid values are cost (C) and retail (R). |
deps |
markup_calc_type |
varchar2 |
2 |
Yes |
The code letter that indicates how markup is calculated in this department. Valid values are cost (C) and retail (R). |
otb_calc_type |
varchar21 |
0 |
1 |
The code letter which indicates how OTB is calculated for this department. Valid values are cost (C) and retail (R). This value cannot be modified. |
deps |
otb_calc_type |
varchar2 |
1 |
Yes |
The code letter which indicates how OTB is calculated for this department. Valid values are cost (C) and retail (R). This value cannot be modified. |
max_avg_counter |
number5 |
0 |
1 |
The maximum count of days with acceptable data to include in an average for items within the department. This value is required if RPM is installed. |
deps |
max_avg_counter |
number |
5 |
No |
The maximum count of days with acceptable data to include in an average for items within the department. This value is required if RPM is installed. |
avg_tolerance_pct |
number12_4 |
0 |
1 |
The tolerance percentage value used in averaging for items within this value. This column will hold 70% as 70, not .70. This value is required if RPM is installed. |
deps |
avg_tolerance_pct |
number |
12 |
No |
The tolerance percentage value used in averaging for items within this value. This column will show 70% as 70, not .70. This value is required if RPM is installed. |
bud_int |
number12_4 |
0 |
1 |
The budgeted intake percentage. The percent of the total take that is income. If this field is not populated on the message it will be calculated as the inverse of the budgeted markup percentage. This column will hold 70% as 70, not .70. |
deps |
bud_int |
number |
12 |
No |
The budgeted intake percentage, also known as the percentage of the total take that is income. If this field is not populated in the message it will be calculated as the inverse of the budgeted markup percentage. This column will show 70% as 70, not .70. |
XMrchHrDeptVAT
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|