Retail Integration Bus Mappings Report
Release: 13.0.1
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:MrchHrDeptDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dept
deps
dept
Yes
Contains the
number which uniquely identifies the department.
dept_name
deps
dept_name
Yes
Contains the
name of the department.
buyer
deps
buyer
No
Contains the
number which uniquely identifies the buyer for that
department.
purchase_type
deps
purchase_type
Yes
Contains a code
which indicates whether items in this department are normal merchandise or
consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment
Stock.
total_market_amt
deps
total_market_amt
No
Contains the
total market amount that is expected for the department. The field can be
used for analytics or reporting.
merch
deps
merch
No
Contains the
number which uniquely describes the merchandiser for that
department.
group_no
deps
group_no
Yes
Contains the
number of the group in which the department exists.
bud_mkup
deps
bud_mkup
Yes
Contains the
Budgeted Markup percentage. This term is synonymous with the term Markup
Percent of Cost.
profit_calc_type
deps
profit_calc_type
Yes
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
markup_calc_type
deps
markup_calc_type
Yes
Contains the
code letter which determines how markup is calculated in this department.
Valid values are:C = Cost, R = Retail
otb_calc_type
deps
otb_calc_type
Yes
Contains the
code letter which determines how OTB is calculated in this department.
Valid values are:C = Cost, R = Retail
max_avg_counter
deps
max_avg_counter
No
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.
avg_tolerance_pct
deps
avg_tolerance_pct
No
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
bud_int
deps
bud_int
Yes
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.
dept_vat_incl_ind
deps
dept_vat_incl_ind
Yes
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'.
