XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for MrchHrDeptDesc 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 |
Contains the number which uniquely identifies the department. |
deps |
dept |
number |
4 |
Yes |
Contains the number to uniquely identify the department. |
dept_name |
varchar2120 |
0 |
1 |
Not used by SIM |
deps |
dept_name |
null |
null |
Yes |
Contains the name of the department. |
buyer |
number4 |
0 |
1 |
Contains the number which uniquely identifies the buyer for that department. |
deps |
buyer |
number |
4 |
No |
Contains the number to uniquely identify the buyer for that department. |
purchase_type |
varchar26 |
0 |
1 |
Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment Stock. |
deps |
purchase_type |
null |
|
Yes |
Contains a code to indicate whether items in this department are normal merchandise or consignment stock. Valid values are 0 (normal merchandise) and 1 (consignment stock). |
total_market_amt |
number24_4 |
0 |
1 |
Contains the total market amount that is expected for the department. The field can be used for analytics or reporting. |
deps |
total_market_amt |
number |
24 |
No |
Contains the total market amount expected for the department. The field can be used for analytics or reporting. |
merch |
number4 |
0 |
1 |
Contains the number which uniquely describes the merchandiser for that department. |
deps |
merch |
number |
4 |
No |
Contains the number to uniquely describe the merchandiser for that department. |
group_no |
number4 |
0 |
1 |
Contains the number of the group in which the department exists. |
deps |
group_no |
null |
null |
Yes |
Contains the number of the group in which the department exists. |
bud_mkup |
number12_4 |
0 |
1 |
Contains the Budgeted Markup percentage. This term is synonymous with the term Markup Percent of Cost. |
deps |
bud_mkup |
null |
null |
Yes |
Contains the Budgeted Markup percentage (synonymous with Markup Percent of Cost). |
profit_calc_type |
number1 |
0 |
1 |
Contains a number which indicates whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are:1 = Direct Cost, 2 = Retail Inventory |
deps |
profit_calc_type |
null |
|
Yes |
Contains a number to indicate whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are 1 (direct cost) and 2 (retail inventory). |
markup_calc_type |
varchar22 |
0 |
1 |
Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, R = Retail |
deps |
markup_calc_type |
null |
|
Yes |
Contains the code (letter) that determines how markup is calculated in this department. Valid values are C (cost) and R (retail). |
otb_calc_type |
varchar21 |
0 |
1 |
Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, R = Retail |
deps |
otb_calc_type |
null |
|
Yes |
Contains the code (letter) that determines how OTB is calculated in this department. Valid values are C (cost) and R (retail). |
max_avg_counter |
number5 |
0 |
1 |
A maximum average counter will hold the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is 'Y' (yes) on the system_options table, then this field will be required when maintaining departments online. |
deps |
max_avg_counter |
null |
null |
No |
A maximum average counter contains the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is Y in the system_options table, the field is required when maintaining departments. |
avg_tolerance_pct |
number12_4 |
0 |
1 |
A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column |
deps |
avg_tolerance_pct |
number |
12 |
No |
A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data. This column shows 70% as 70, not 0.70. |
bud_int |
number12_4 |
0 |
1 |
Contains the Budgeted Intake percentage. Budgeted Intake is the percent of total take that is income and is synonymous with the term Markup Percent of Retail. |
deps |
bud_int |
null |
null |
Yes |
Contains the budgeted intake percentage, which is the percent of total take that is income (synonymous with Markup Percent of Retail). |
dept_vat_incl_ind |
varchar21 |
0 |
1 |
This indicator will be be used only to default to the class level indicator when classes are initially set up for the department and will only be available when the system level class vat option is on. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. |
deps |
dept_vat_incl_ind |
null |
null |
Yes |
This indicator is used only to default to the class level indicator when classes are initially set up for the department and is available only when the system level class VAT option is on. When VAT is turned on in the system and not defined at the class level, the field defaults to Y. When VAT is turned off in the system, the field defaults to N. |