Oracle Portal
Retail Integration Bus Mappings Report   

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemDesc.xsd
Tag Name Table Name Column Name API Req Description
ItemHdrDesc * * * *
ItemSupDesc * * * *
ItemSupCtyDesc * * * *
ISCDimDesc * * * *
ItemUDALOVDesc * * * *
ItemUDAFFDesc * * * *
ItemUDADateDesc * * * *
ItemImageDesc * * * *
ItemUPCDesc * * * *
ItemBOMDesc * * * *
ItemTcktDesc * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemHdrDesc
Tag Name Table Name Column Name API Req Description
item item_master item_id Yes *
item_number_type * * * *
format_id n/a n/a No Not used in RWMS.
prefix n/a n/a No Not used in RWMS.
item_parent n/a n/a No Not used in RWMS.
item_grandparent n/a n/a No Not used in RWMS.
pack_ind n/a n/a No Not used in RWMS.
item_level n/a n/a No Not used in RWMS.
tran_level n/a n/a No Not used in RWMS.
diff_1 item_differentiator diff_id No *
diff_1_type item_differentiator diff_type No *
diff_2 item_differentiator diff_id No *
diff_2_type item_differentiator diff_type No *
diff_3 item_differentiator diff_id No *
diff_3_type item_differentiator diff_type No *
diff_4 item_differentiator diff_id No *
diff_4_type item_differentiator diff_type No *
dept item_master department No *
dept_name n/a n/a No Not used in RWMS.
class item_master class No *
class_name n/a n/a No Not used in RWMS.
subclass item_master sub_class No *
sub_name n/a n/a No Not used in RWMS.
status n/a n/a No Not used in RWMS.
item_desc item_master description No *
short_desc n/a n/a No Not used in RWMS.
desc_up n/a n/a No Not used in RWMS.
primary_ref_item_ind n/a n/a No Not used in RWMS.
retail_zone_group_id n/a n/a No Not used in RWMS.
cost_zone_group_id n/a n/a No Not used in RWMS.
standard_uom item_master standard_uom No *
uom_conv_factor item_master uom_conv_factor No *
package_size * * No *
package_uom * * No *
merchandise_ind * * No *
store_ord_mult * * No *
forecast_ind * * No *
mfg_rec_retail n/a n/a No Not used in RWMS.
retail_label_type n/a n/a No Not used in RWMS.
retail_label_type_desc n/a n/a No Not used in RWMS.
retail_label_value n/a n/a No Not used in RWMS.
handling_temp n/a n/a No Not used in RWMS.
handling_temp_desc n/a n/a No Not used in RWMS.
handling_sensitivity n/a n/a No Not used in RWMS.
handling_sensitivity_desc * * * *
catch_weight_ind item_master catch_weight No *
waste_type n/a n/a No Not used in RWMS.
waste_type_desc n/a n/a No Not used in RWMS.
waste_pct n/a n/a No Not used in RWMS.
default_waste_pct n/a n/a No Not used in RWMS.
const_dimen_ind n/a n/a No Not used in RWMS.
simple_pack_ind n/a n/a No Not used in RWMS.
contains_inner_ind n/a n/a No Not used in RWMS.
sellable_ind n/a n/a No Not used in RWMS.
orderable_ind n/a n/a No Not used in RWMS.
pack_type n/a n/a No Not used in RWMS.
order_as_type n/a n/a No Not used in RWMS.
comments n/a n/a No Not used in RWMS.
unit_retail item_master retail_price No *
item_service_level n/a n/a No Not used in RWMS.
gift_wrap_ind n/a n/a No Not used in RWMS.
ship_alone_ind item_master ship_alone No *
vendor_style item_master vendor_style No *
std_unit_weight item_master std_unit_weight No *
single_price_flag item_master single_price_flag No *
preticket_flag item_master preticket_flag No *
planned_residual item_master planned_residual No *
autopackable item_master autopackable No *
sortable item_master sortable No *
item_master_uda1 item_master item_master_uda1 No *
item_master_uda2 item_master item_master_uda2 No *
item_master_uda3 item_master item_master_uda3 No *
item_master_uda4 item_master item_master_uda4 No *
item_master_uda5 item_master item_master_uda5 No *
item_master_uda6 item_master item_master_uda6 No *
item_master_uda7 item_master item_master_uda7 No *
item_master_uda8 item_master item_master_uda8 No *
item_master_uda9 item_master item_master_uda9 No *
item_master_uda10 item_master item_master_uda10 No *
item_master_uda11 item_master item_master_uda11 No *
item_master_uda12 item_master item_master_uda12 No *
item_master_uda13 item_master item_master_uda13 No *
item_master_uda14 item_master item_master_uda14 No *
item_master_uda15 item_master item_master_uda15 No *
ship_alone item_master ship_alone No *
slottable item_master slottable No *
freight_class item_master freight_class No *
new_item item_master new_item No *
brand item_master brand No *
break_case_ups item_master break_case_ups No *
rigid item_master rigid No *
fragile item_master fragile No *
container_type item_master container_type No *
conveyable_flag item_master conveyable_flag No *
hazard_matl_code item_master hazard_matl_code No *
velocity item_master velocity No *
high_value_ind item_master high_value_ind No *
ticket_type item_master ticket_type No *
color item_master color No *
size1 item_master size1 No *
fit item_master fit No *
shade item_master shade No *
single_contain_bulk item_master single_contain_bulk No *
unit_pick_system_code item_master unit_pick_system_code No *
roundable_flag item_master roundable_flag No *
perishable_ind item_master perishable_ind No *
division item_master division No *
vendor_nbr item_master vendor_nbr No *
kitting_wip_code item_master kitting_wip_code No *
unit_ticket_qty item_master unit_ticket_qty No *
item_length item_master item_length No *
item_width item_master item_width No *
item_height item_master item_height No *
item_weight item_master item_weight No *
item_cube item_master item_cube No *
std_unit_factor item_master std_unit_factor No *
std_unit_qty item_master std_unit_qty No *
expiration_days item_master expiration_days No *
putaway_by_volume item_master putaway_by_volume No *
putaway_plan item_master putaway_plan No *
item_type item_master item_type No *
sorter_group item_master sorter_group No *
sku_optimization item_master sku_optimization No *
ext_source_system * * * *
item_xform_ind * * * *
inventory_ind * * * *
order_type * * * *
sale_type * * * *
deposit_item_type * * * *
container_item * * * *
deposit_in_price_per_uom * * * *
transport_ind * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemSupDesc
Tag Name Table Name Column Name API Req Description
item item_supplier item_id * *
supplier item_supplier vendor_nbr * *
primary_supp_ind item_supplier primary_supp_ind * *
vpn * * * *
supp_label * * * *
consignment_rate * * * *
supp_diff_1 * * * *
supp_diff_2 * * * *
supp_diff_3 * * * *
supp_diff_4 * * * *
pallet_name item_supplier pallet_name * *
case_name item_supplier case_name * *
inner_name item_supplier inner_name * *
supp_discontinue_date * * * *
direct_ship_ind * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemSupCtyDesc
Tag Name Table Name Column Name API Req Description
item * * * *
supplier * * * *
origin_country_id * * * *
primary_supp_ind * * * *
primary_country_ind * * * *
unit_cost n/a n/a No Not used in RWMS.
lead_time item_supp_country lead_time No *
pickup_lead_time n/a n/a No Not used in RWMS.
supp_pack_size item_supp_country supp_pack_size No *
inner_pack_size * * * *
round_lvl n/a n/a No Not used in RWMS.
min_order_qty n/a n/a No Not used in RWMS.
max_order_qty n/a n/a No Not used in RWMS.
packing_method item_supp_country packing_method No *
default_uop n/a n/a No Not used in RWMS.
ti * * * *
hi * * * *
cost_uom * * * *
tolerance_type * * * *
max_tolerance * * * *
min_tolerance * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ISCDimDesc
Tag Name Table Name Column Name API Req Description
item item_supp_country_dim item_id Yes *
supplier item_supp_country_dim vendor_nbr Yes *
origin_country item_supp_country_dim origin_country_id Yes *
dim_object item_supp_country_dim dim_object Yes *
object_desc item_supp_country_dim dim_object_desc No *
presentation_method n/a n/a No Not used in RWMS.
method_desc n/a n/a No Not used in RWMS.
length item_supp_country_dim length No *
width item_supp_country_dim width No *
height item_supp_country_dim height No *
lwh_uom item_supp_country_dim lwh_uom No *
weight item_supp_country_dim weight No *
net_weight n/a n/a No Not used in RWMS.
weight_uom item_supp_country_dim weight_uom No *
liquid_volume item_supp_country_dim liquid_volume No *
liquid_volume_uom item_supp_country_dim liquid_volume_uom No *
stat_cube n/a n/a No Not used in RWMS.
tare_weight item_supp_country_dim tare_weight No *
tare_type item_supp_country_dim tare_type No *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemUDALOVDesc
Tag Name Table Name Column Name API Req Description
item item_attributes item_id Yes *
uda_id item_attributes attribute_type Yes *
uda_value item_attributes attribute Yes *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemUDAFFDesc
Tag Name Table Name Column Name API Req Description
item * * * *
uda_id * * * *
uda_text * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemUDADateDesc
Tag Name Table Name Column Name API Req Description
item * * * *
uda_id * * * *
uda_date * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemImageDesc
Tag Name Table Name Column Name API Req Description
item * * * *
image_name * * * *
image_addr * * * *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemUPCDesc
Tag Name Table Name Column Name API Req Description
item_id item_upc upc Yes *
item_parent item_upc item_id No *
primary_ref_item_ind item_upc primary_upc_ind No *
format_id n/a n/a No Not used in RWMS.
prefix n/a n/a No Not used in RWMS.
item_number_type n/a n/a No *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemBOMDesc
Tag Name Table Name Column Name API Req Description
pack_no bill_of_materials master_item_id Yes *
item bill_of_materials component_item_id Yes *
pack_qty bill_of_materials unit_qty Yes *

Application Name: Retail Warehouse Management System
XML-Schema or Node Name:ItemTcktDesc
Tag Name Table Name Column Name API Req Description
item * * * *
ticket_type_id * * * *