Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AllocDesc.xsd
Tag Name Table Name Column Name API Req Description
alloc_no
doc_type
physical_wh
wh
item
pick_not_before_date
pick_not_after_date
order_type
order_no
null
event
event_description
priority
ticket_type_id
AllocDtl * * * *
context_type
context_value

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AllocDtl
Tag Name Table Name Column Name API Req Description
physical_to_loc
to_loc
loc_type
qty_allocated
price
selling_uom
priority
store_ord_mult
AllocDtlTckt * * * *
in_store_date
rush_flag

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AllocDtlTckt
Tag Name Table Name Column Name API Req Description
comp_item
comp_price
comp_selling_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AllocRef.xsd
Tag Name Table Name Column Name API Req Description
alloc_no
doc_type
physical_wh
wh
item
AllocDtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AllocDtlRef
Tag Name Table Name Column Name API Req Description
to_loc

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AppointDesc.xsd
Tag Name Table Name Column Name API Req Description
from_location
to_location
appt_nbr
appt_start_ts
appt_action_status
AppointDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AppointDtl
Tag Name Table Name Column Name API Req Description
item_id
unit_qty
po_nbr
document_type
asn_nbr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AppointRef.xsd
Tag Name Table Name Column Name API Req Description
appt_nbr
from_location
AppointDtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AppointDtlRef
Tag Name Table Name Column Name API Req Description
item_id
po_nbr
asn_nbr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNInDesc.xsd
Tag Name Table Name Column Name API Req Description
to_location DO_CTL_INV ID_PRTY_TO_ICD No Not Yet Available
from_location DO_CTL_INV ID_PRTY_FM_ICD No Not Yet Available
asn_nbr DO_CTL_INV ASN_NUM No Not Yet Available
asn_type
container_qty
bol_nbr
shipment_date DO_CTL_INV TS_CRT_ICD No Not Yet Available
est_arr_date DO_CTL_INV DC_DV_EXP_ICD No Not Yet Available
ship_address1
ship_address2
ship_address3
ship_address4
ship_address5
ship_city
ship_state
ship_zip
ship_country_id
trailer_nbr
seal_nbr
carrier_code
vendor_nbr DO_CTL_INV ID_PRTY_FM_ICD No Not Yet Available
ship_pay_method
ASNInPO * * * *
comments DO_CTL_INV COMMENT_DESC No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNInPO
Tag Name Table Name Column Name API Req Description
po_nbr DO_CTL_INV ORDER_ID/REFERENCE_ID_ICD No Not Yet Available
doc_type DO_CTL_INV ID_ORGR_ICD No Not Yet Available
not_after_date
comments
ASNInCtn * * * *
ASNInItem * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNInCtn
Tag Name Table Name Column Name API Req Description
final_location
container_id RK_SHIP_CONT_ICD CONTAINER_ID No Not Yet Available
container_weight
container_length
container_width
container_height
container_cube
expedite_flag
in_store_date
rma_nbr
tracking_nbr
freight_charge
master_container_id
ASNInItem * * * *
comments

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNInItem
Tag Name Table Name Column Name API Req Description
final_location
item_id TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
unit_qty TR_LTM_ICD_MR QU_ITM No Not Yet Available
priority_level
vpn
order_line_nbr
lot_nbr
ref_item
distro_nbr
distro_doc_type
container_qty
comments TR_LTM_ICD_MR COMMENT_DESC No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNInRef.xsd
Tag Name Table Name Column Name API Req Description
to_location TBD TBD Not Yet Available Not Yet Available
from_location TBD TBD Not Yet Available Not Yet Available
asn_nbr TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNOutDesc.xsd
Tag Name Table Name Column Name API Req Description
to_location DO_CTL_INV ID_PRTY_TO_ICD No Not Yet Available
from_location
asn_nbr
asn_type
container_qty
bol_nbr
shipment_date
est_arr_date
ship_address1
ship_address2
ship_address3
ship_address4
ship_address5
ship_city
ship_state
ship_zip
ship_country_id
trailer_nbr
seal_nbr
carrier_code
transshipment_nbr
ASNOutDistro * * * *
comments DO_CTL_INV COMMENT_DESC No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNOutDistro
Tag Name Table Name Column Name API Req Description
distro_nbr DO_CTL_INV ID_ICD Yes Not Yet Available
distro_doc_type
customer_order_nbr
consumer_direct
ASNOutCtn * * * *
comments

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNOutCtn
Tag Name Table Name Column Name API Req Description
final_location DO_CTL_INV ID_PRTY_TO_ICD No Not Yet Available
container_id DO_CTL_INV ID_ICD Yes Not Yet Available
container_weight
container_length
container_width
container_height
container_cube
expedite_flag
in_store_date
rma_nbr
tracking_nbr
freight_charge
master_container_id
ASNOutItem * * * *
comments
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ASNOutItem
Tag Name Table Name Column Name API Req Description
item_id TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
unit_qty TR_LTM_ICD_MR QU_ITM No Not Yet Available
priority_level
order_line_nbr
lot_nbr
final_location DO_CTL_INV ID_PRTY_TO_ICD No Not Yet Available
from_disposition
to_disposition
voucher_number
voucher_expiration_date
container_qty
comments
unit_cost
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location RK_PRICE_CHANGE id_str_rt Yes Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
ClrPrcChgDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDtl
Tag Name Table Name Column Name API Req Description
clearance_id RK_PRICE_CHANGE change_id No Not Yet Available
item RK_PRICE_CHANGE id_item No Not Yet Available
effective_date RK_PRICE_CHANGE effective_date Yes Not Yet Available
selling_unit_retail RK_PRICE_CHANGE new_price Yes Not Yet Available
selling_uom RK_PRICE_CHANGE new_selling_uom No Not Yet Available
selling_currency
reset_clearance_id

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
location
loc_type
ClrPrcChgDtlref * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ClrPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
clearance_id
item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:CodeDtlDesc.xsd
Tag Name Table Name Column Name API Req Description
code_type
code
code_desc
required_ind
code_seq

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:CodeDtlRef.xsd
Tag Name Table Name Column Name API Req Description
code_type
code

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:CodeHdrDesc.xsd
Tag Name Table Name Column Name API Req Description
code_type
code_type_desc

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:CodeHdrRef.xsd
Tag Name Table Name Column Name API Req Description
code_type

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DiffDesc.xsd
Tag Name Table Name Column Name API Req Description
diff_id RK_DIFF_DESC diff_id Yes Not Yet Available
diff_type RK_DIFF_DESC diff_type No Not Yet Available
diff_desc RK_DIFF_DESC diff_desc Yes Not Yet Available
industry_code
industry_subcode

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DiffRef.xsd
Tag Name Table Name Column Name API Req Description
diff_id RK_DIFF_DESC TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DiffTypeDesc.xsd
Tag Name Table Name Column Name API Req Description
diff_type TBD TBD Not Yet Available Not Yet Available
diff_type_desc TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DiffTypeRef.xsd
Tag Name Table Name Column Name API Req Description
diff_type RK_DIFF_TYPE TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDDealsDesc.xsd
Tag Name Table Name Column Name API Req Description
DSDDeals * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDDeals
Tag Name Table Name Column Name API Req Description
order_no
supplier
store
dept
currency_code
paid_ind
ext_ref_no
proof_of_delivery_no
payment_ref_no
payment_date
deals_ind
shipment
invc_id
invc_ind
vdate
qty_sum
cost_sum

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDReceiptDesc.xsd
Tag Name Table Name Column Name API Req Description
DSDReceipt * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDReceipt
Tag Name Table Name Column Name API Req Description
supplier
origin_country_id
store DO_CTL_INV ID_PRTY_FM_ICD No Not Yet Available
dept AS_ITM ID_STRC_MR No Not Yet Available
currency_code
paid_ind
ext_ref_no DO_CTL_INV ID_CNTRT No Not Yet Available
proof_of_delivery_no
payment_ref_no
payment_date
invc_ind
deals_ind
DSDDtl * * * *
DSDNonMerch * * * *
ext_receipt_no DO_CTL_INV ID_ICD Yes Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDDtl
Tag Name Table Name Column Name API Req Description
item TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
qty_received TR_LTM_ICD_MR QU_ITM No Not Yet Available
unit_cost
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:DSDNonMerch
Tag Name Table Name Column Name API Req Description
non_merch_code
non_merch_amt
vat_code
service_perf_ind

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:InvAdjustDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id TBD TBD Not Yet Available Not Yet Available
InvAdjustDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:InvAdjustDtl
Tag Name Table Name Column Name API Req Description
item_id TBD TBD Not Yet Available Not Yet Available
adjustment_reason_code TBD TBD Not Yet Available Not Yet Available
unit_qty TBD TBD Not Yet Available Not Yet Available
transshipment_nbr
from_disposition TBD TBD Not Yet Available Not Yet Available
to_disposition TBD TBD Not Yet Available Not Yet Available
from_trouble_code
to_trouble_code
from_wip_code
to_wip_code
transaction_code
user_id TBD TBD Not Yet Available Not Yet Available
create_date TBD TBD Not Yet Available Not Yet Available
po_nbr
doc_type
aux_reason_code
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:InvReqDesc.xsd
Tag Name Table Name Column Name API Req Description
request_id RK_STORE_ORDER STORE_ORDER_ID No Not Yet Available
store RK_STORE_ORDER STORE_ID No Not Yet Available
request_type
InvReqItem * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:InvReqItem
Tag Name Table Name Column Name API Req Description
item RK_STORE_ORDER_LINE_ITEM ITEM_ID No Not Yet Available
qty_rqst RK_STORE_ORDER_LINE_ITEM QUANTITY No Not Yet Available
uop
need_date RK_STORE_ORDER REQ_DELIVERY_DATE No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ISCDimRef.xsd
Tag Name Table Name Column Name API Req Description
item
supplier
origin_country
dim_object

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemBOMRef.xsd
Tag Name Table Name Column Name API Req Description
item RK_STORE_ITEM_SOH id_itm No mapped to AS_ITM_RTL_STR, RK_ITEM_SUPPLIER, RK_ITEM_SUPP_COUNTRY, CO_CLN_ITM, AS_ITM as well. Not Yet Available
pack_no RK_STORE_ITEM_SOH TBD No mapped to AS_ITM_RTL_STR,RK_ITEM_SUPPLIER,RK_ITEM_SUPP_COUNTRY,CO_CLN_ITM,AS_ITM as well. Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
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: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemHdrDesc
Tag Name Table Name Column Name API Req Description
item AS_ITM ID_ITM No Not Yet Available
item_number_type AS_ITM ITEM_ID_TY No Not Yet Available
format_id
prefix
item_parent AS_ITM ID_PRT_ITM No Not Yet Available
item_grandparent
pack_ind AS_ITM PACK_IND Yes Not Yet Available
item_level AS_ITM ITEM_LEVEL No Not Yet Available
tran_level AS_ITM TRANS_LEVEL No Not Yet Available
diff_1 AS_ITM DIFF_1 No Not Yet Available
diff_1_type
diff_2 AS_ITM DIFF_2 No Not Yet Available
diff_2_type
diff_3 AS_ITM DIFF_3 No Not Yet Available
diff_3_type
diff_4 AS_ITM DIFF_4 No Not Yet Available
diff_4_type
dept AS_ITM ID_DPT_POS No Not Yet Available
dept_name
class AS_ITM ID_CLSS No Not Yet Available
class_name
subclass AS_ITM ID_SBCL No Not Yet Available
sub_name
status AS_ITM STATUS No Not Yet Available
item_desc
short_desc AS_ITM DE_ITM No Not Yet Available
desc_up
primary_ref_item_ind AS_ITM PRIMARY_REF No Not Yet Available
retail_zone_group_id AS_ITM RETAIL_ZONE_GRP_ID No Not Yet Available
cost_zone_group_id
standard_uom AS_ITM LU_UOM_DFT No Not Yet Available
uom_conv_factor
package_size AS_ITM DFT_CASE_SIZE No Not Yet Available
package_uom AS_ITM PACKAGE_UOM No Not Yet Available
merchandise_ind
store_ord_mult
forecast_ind
mfg_rec_retail
retail_label_type
retail_label_type_desc
retail_label_value
handling_temp
handling_temp_desc
handling_sensitivity
handling_sensitivity_desc
catch_weight_ind
waste_type
waste_type_desc c
waste_pct
default_waste_pct
const_dimen_ind
simple_pack_ind
contains_inner_ind
sellable_ind AS_ITM SELLABLE_IND Yes Not Yet Available
orderable_ind AS_ITM ORDERABLE_IND Yes Not Yet Available
pack_type
order_as_type AS_ITM LU_CLN_ORD No Not Yet Available
comments
unit_retail
item_service_level
gift_wrap_ind
ship_alone_ind
vendor_style
std_unit_weight
single_price_flag
preticket_flag
planned_residual
autopackable
sortable
item_master_uda1
item_master_uda2
item_master_uda3
item_master_uda4
item_master_uda5
item_master_uda6
item_master_uda7
item_master_uda8
item_master_uda9
item_master_uda10
item_master_uda11
item_master_uda12
item_master_uda13
item_master_uda14
item_master_uda15
ship_alone
slottable
freight_class
new_item
brand
break_case_ups
rigid
fragile
container_type
conveyable_flag
hazard_matl_code
velocity
high_value_ind
ticket_type
color
size1
fit
shade
single_contain_bulk
unit_pick_system_code
roundable_flag
perishable_ind
division
vendor_nbr
kitting_wip_code
unit_ticket_qty
item_length
item_width
item_height
item_weight
item_cube
std_unit_factor
std_unit_qty
expiration_days
putaway_by_volume
putaway_plan
item_type
sorter_group
sku_optimization
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: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemSupDesc
Tag Name Table Name Column Name API Req Description
item RK_ITEM_SUPPLIER ID_ITM No Not Yet Available
supplier RK_ITEM_SUPPLIER ID_SPR No Not Yet Available
primary_supp_ind RK_ITEM_SUPPLIER PRIMARY_IND No Not Yet Available
vpn RK_ITEM_SUPPLIER VPN No Not Yet Available
supp_label
consignment_rate
supp_diff_1
supp_diff_2
supp_diff_3
supp_diff_4
pallet_name
case_name
inner_name
supp_discontinue_date
direct_ship_ind

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemSupCtyDesc
Tag Name Table Name Column Name API Req Description
item RK_ITEM_SUPPLIER_COUNTRY ID_ITM No Not Yet Available
supplier RK_ITEM_SUPPLIER_COUNTRY ID_SPR No Not Yet Available
origin_country_id RK_ITEM_SUPPLIER_COUNTRY COUNTRY_ID No Not Yet Available
primary_supp_ind
primary_country_ind TBD TBD Not Yet Available Not Yet Available
unit_cost
lead_time
pickup_lead_time
supp_pack_size RK_ITEM_SUPPLIER_COUNTRY CASE_SIZE No Not Yet Available
inner_pack_size
round_lvl
min_order_qty
max_order_qty
packing_method
default_uop
ti
hi
cost_uom
tolerance_type
max_tolerance
min_tolerance

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ISCDimDesc
Tag Name Table Name Column Name API Req Description
item
supplier
origin_country
dim_object
object_desc
presentation_method
method_desc
length
width
height
lwh_uom
weight
net_weight
weight_uom
liquid_volume
liquid_volume_uom
stat_cube
tare_weight
tare_type

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDALOVDesc
Tag Name Table Name Column Name API Req Description
item
uda_id
uda_value

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDAFFDesc
Tag Name Table Name Column Name API Req Description
item
uda_id
uda_text

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDADateDesc
Tag Name Table Name Column Name API Req Description
item
uda_id
uda_date

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemImageDesc
Tag Name Table Name Column Name API Req Description
item
image_name
image_addr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUPCDesc
Tag Name Table Name Column Name API Req Description
item_id AS_ITM ID_ITM No Not Yet Available
item_parent AS_ITM ID_PRT_ITM No Not Yet Available
primary_ref_item_ind AS_ITM PRIMARY_REF No Not Yet Available
format_id
prefix
item_number_type AS_ITM ITEM_ID_TY No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemBOMDesc
Tag Name Table Name Column Name API Req Description
pack_no CO_CLN_ITM ID_ITM_CLN Yes Not Yet Available
item CO_CLN_ITM ID_ITM_MBR Yes Not Yet Available
pack_qty CO_CLN_ITM QU_ITM_PR_ASMB Yes Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemTcktDesc
Tag Name Table Name Column Name API Req Description
item AS_ITM ID_ITM No Not Yet Available
ticket_type_id AS_ITM SGGSTD_TICKET_TY_CDE No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemImageRef.xsd
Tag Name Table Name Column Name API Req Description
item
image_name

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocDesc.xsd
Tag Name Table Name Column Name API Req Description
item AS_ITEM_RTL_STR ID_ITEM No Not Yet Available
ItemLocPhys * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocPhys
Tag Name Table Name Column Name API Req Description
physical_loc AS_ITEM_RTL_STR ID_STR_RT No Not Yet Available
ItemLocVirt * * * *
ItemLocVirtRepl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocVirt
Tag Name Table Name Column Name API Req Description
loc
loc_type
local_item_desc
local_short_desc AS_ITEM_RTL_STR SHORT_DESC No Not Yet Available
status AS_ITEM_RTL_STR SC_ITM No Not Yet Available
primary_supp AS_ITEM_RTL_STR ID_SPR No Not Yet Available
primary_cntry
receive_as_type
taxable_ind
source_method
source_wh
unit_retail
selling_unit_retail AS_ITEM_RTL_STR RP_SLS_CRT No Not Yet Available
selling_uom
store_price_ind AS_ITEM_RTL_STR STR_CTL_PRICING No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocVirtRepl
Tag Name Table Name Column Name API Req Description
loc AS_ITEM_RTL_STR ID_STR_RT No Not Yet Available
loc_type
primary_repl_supplier
repl_method AS_ITEM_RTL_STR REPN_TYPE No Not Yet Available
reject_store_order_ind AS_ITEM_RTL_STR STR_ORD_REJECT No Not Yet Available
next_delivery_date AS_ITEM_RTL_STR NEXT_DELIVERY_DATE No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocRef.xsd
Tag Name Table Name Column Name API Req Description
item
ItemLocPhysRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocPhysRef
Tag Name Table Name Column Name API Req Description
physical_loc * * * *
ItemLocVirtRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemLocVirtRef
Tag Name Table Name Column Name API Req Description
loc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemRef.xsd
Tag Name Table Name Column Name API Req Description
item RK_ITM_LCN id_itm No Mapped to ,RK_ITEM_SUPPLIER,RK_ITEM_SUPP_COUNTRY,AS_ITM_RTL_STR,AS_ITM as well. Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemSupCtyRef.xsd
Tag Name Table Name Column Name API Req Description
item TBD id_itm No Not Yet Available
supplier TBD TBD Not Yet Available Not Yet Available
origin_country_id TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemSupRef.xsd
Tag Name Table Name Column Name API Req Description
item TBD TBD Not Yet Available Not Yet Available
supplier TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemTcktRef.xsd
Tag Name Table Name Column Name API Req Description
item * * * *
ticket_type_id * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDADateRef.xsd
Tag Name Table Name Column Name API Req Description
item
uda_id

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDAFFRef.xsd
Tag Name Table Name Column Name API Req Description
item
uda_id

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUDALOVRef.xsd
Tag Name Table Name Column Name API Req Description
item
uda_id
uda_value

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemUPCRef.xsd
Tag Name Table Name Column Name API Req Description
item TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZonePrcDesc.xsd
Tag Name Table Name Column Name API Req Description
ItemZoneGrp * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZoneGrp
Tag Name Table Name Column Name API Req Description
zone_group_id RK_ITEM_PRIZE_ZONE ZONE_GROUP_ID No Not Yet Available
item RK_ITEM_PRIZE_ZONE ID_ITM No Not Yet Available
ItemZone * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZone
Tag Name Table Name Column Name API Req Description
zone_id RK_ITEM_PRIZE_ZONE ZONE_ID No Not Yet Available
unit_retail RK_ITEM_PRIZE_ZONE UNIT_RETAIL No Not Yet Available
selling_unit_retail RK_ITEM_PRIZE_ZONE SELLING_UNIT_RETAIL No Not Yet Available
selling_uom RK_ITEM_PRIZE_ZONE SELLING_UOM No Not Yet Available
multi_units RK_ITEM_PRIZE_ZONE MULTI_UNITS No Not Yet Available
multi_unit_retail RK_ITEM_PRIZE_ZONE MULTI_UNIT_RETAIL No Not Yet Available
multi_selling_uom RK_ITEM_PRIZE_ZONE MULTI_SELLING_UOM No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZonePrcRef.xsd
Tag Name Table Name Column Name API Req Description
ItemZoneGrpRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZoneGrpRef
Tag Name Table Name Column Name API Req Description
zone_group_id
item
ItemZoneRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ItemZoneRef
Tag Name Table Name Column Name API Req Description
number

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODesc.xsd
Tag Name Table Name Column Name API Req Description
loc TBD TBD Not Yet Available Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
order_id RIB? TBD No Not Yet Available
source_type HARDCODED TBD No Not Yet Available
source_id ARTS_ID TBD No Not Yet Available
user_id ARTS_ID TBD No Not Yet Available
comments ENTERED TBD No Not Yet Available
order_status HARDCODED TBD No Not Yet Available
not_before_date TBD TBD No Not Yet Available
not_after_date TBD TBD No Not Yet Available
create_date
LocPODtl * * * *
orig_ind TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODtl
Tag Name Table Name Column Name API Req Description
item ARTS_ID TBD No Not Yet Available
pack_size RIB TBD No Not Yet Available
ordered_quantity RIB TBD No Not Yet Available
unit_cost
orig_qty
loc
loc_type

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODlsReq.xsd
Tag Name Table Name Column Name API Req Description
LocPODlsReqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODlsReqDtl
Tag Name Table Name Column Name API Req Description
source_id ARTS_ID TBD No Not Yet Available
loc ARTS_ID TBD No Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
item ARTS_ID TBD No Not Yet Available
not_before_date TBD TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODlsRsp.xsd
Tag Name Table Name Column Name API Req Description
LocPODlsRspDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODlsRspDtl
Tag Name Table Name Column Name API Req Description
deal_id READONLY * No Not Yet Available
deal_type READONLY * No Not Yet Available
active_date READONLY * No Not Yet Available
close_date READONLY * No Not Yet Available
deal_class READONLY * No Not Yet Available
limit_type READONLY * No Not Yet Available
value_type READONLY * No Not Yet Available
lower_limit READONLY * No Not Yet Available
upper_limit READONLY * No Not Yet Available
value READONLY * No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODtlsReq.xsd
Tag Name Table Name Column Name API Req Description
LocPODtlsReqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODtlsReqDtl
Tag Name Table Name Column Name API Req Description
order_id ENTERED TBD No Not Yet Available
source_type HARDCODED TBD No Not Yet Available
source_id ARTS_ID TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODtlsRsp
Tag Name Table Name Column Name API Req Description
order_id * * * *
loc * * * *
loc_type * * * *
user_id * * * *
comments * * * *
order_status * * * *
source_type * * * *
source_id * * * *
not_before_date * * * *
not_after_date * * * *
create_date * * * *
LocPODtlsRspDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPODtlsRspDtl
Tag Name Table Name Column Name API Req Description
item * * * *
pack_size * * * *
ordered_quantity * * * *
unit_cost * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOHdrsReq.xsd
Tag Name Table Name Column Name API Req Description
LocPOHdrsReqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOHdrsReqDtl
Tag Name Table Name Column Name API Req Description
order_id ENTERED TBD No Not Yet Available
item ARTS ID TBD No Not Yet Available
loc ARTS ID TBD No Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
source_type HARDCODED TBD No Not Yet Available
source_id ARTS ID TBD No Not Yet Available
order_status HARDCODED TBD No Not Yet Available
not_before_date TBD TBD No Not Yet Available
not_after_date TBD TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOHdrsRsp.xsd
Tag Name Table Name Column Name API Req Description
LocPOHdrsRspDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOHdrsRspDtl
Tag Name Table Name Column Name API Req Description
order_id * * * *
source_type * * * *
source_id * * * *
create_date * * * *
order_status * * * *
not_before_date * * * *
not_after_date * * * *
user_id * * * *
quantity * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOItemSlsReq.xsd
Tag Name Table Name Column Name API Req Description
LocPOItemSlsReqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOItmSlsReqDtl
Tag Name Table Name Column Name API Req Description
item ARTS ID TBD No Not Yet Available
loc ARTS ID TBD No Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOItemSlsRsp.xsd
Tag Name Table Name Column Name API Req Description
LocPOItemSlsRspDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPOItmSlsRspDtl
Tag Name Table Name Column Name API Req Description
eow_date * * * *
quantity * * * *
sales_value * * * *
sales_type * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPORsp.xsd
Tag Name Table Name Column Name API Req Description
LocPORspDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:LocPORspDtl
Tag Name Table Name Column Name API Req Description
order_id * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:OTBDesc.xsd
Tag Name Table Name Column Name API Req Description
OTB * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:OTB
Tag Name Table Name Column Name API Req Description
po_nbr
dept
class
subclass
unit_retail
unit_cost
receipt_qty
approved_qty

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PODesc.xsd
Tag Name Table Name Column Name API Req Description
doc_type RK_ORDERS TBD No Not Yet Available
order_no RK_ORDERS ORDER_ID No Not Yet Available
supplier RK_ORDERS SOURCE_ID Yes Not Yet Available
order_type_desc
dept
dept_name
buyer
buyer_name
supplier
promotion
prom_desc
qc_ind
not_before_date RK_ORDERS NOT_BEFORE_DATE No Not Yet Available
not_after_date RK_ORDERS NOT_AFTER_DATE No Not Yet Available
otb_eow_date
earliest_ship_date
latest_ship_date
close_date
terms
terms_code
freight_terms
cust_order
payment_method
payment_method_desc
backhaul_type
backhaul_type_desc
backhaul_allowance
ship_method
ship_method_desc
purchase_type
purchase_type_desc
status RK_ORDERS STATUS No Not Yet Available
ship_pay_method
ship_pay_method_desc
fob_trans_res
fob_trans_res_code_desc
fob_trans_res_desc
fob_title_pass
fob_title_pass_code_desc
fob_title_pass_desc
vendor_order_novendor_order_no
exchange_rate
factory
factory_desc
agent
agent_desc
discharge_port
discharge_port_desc
lading_port
lading_port_desc
bill_to_id
freight_contract_no
po_type
po_type_desc
pre_mark_ind
currency_code
contract_no
pickup_loc
pickup_no
pickup_date
app_datetime
comment_desc RK_ORDERS COMMENT_DESC No Not Yet Available
PODtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PODtl
Tag Name Table Name Column Name API Req Description
item RK_ORDER_ITM ID_ITM No Not Yet Available
ref_item
physical_location_type
physical_location RK_ORDER_ITM ID_STR_RT No Not Yet Available
physical_qty_ordered RK_ORDER_ITM QUANTITY_EXPECTED No Not Yet Available
unit_cost RK_ORDER_ITM UNIT_COST No Not Yet Available
origin_country_id
supp_pack_size
earliest_ship_date
latest_ship_date
pickup_loc
pickup_no
packing_method
round_lvl
door_ind
priority_level
new_item
quarantine
rcvd_unit_qty RK_ORDER_ITM QUANTITY_RECEIVED No Not Yet Available
tsf_po_link_id
POVirtualDtl * * * *
cost_source
est_in_stock_date

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:POVirtualDtl
Tag Name Table Name Column Name API Req Description
location_type
location
qty_ordered

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PORef.xsd
Tag Name Table Name Column Name API Req Description
PODtlRef TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PODtlRef
Tag Name Table Name Column Name API Req Description
order_no TBD TBD Not Yet Available Not Yet Available
physical_location TBD TBD Not Yet Available Not Yet Available
item TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
PrcChg * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChg
Tag Name Table Name Column Name API Req Description
location RK_PRICE_CHANGE id_str_rt Yes Not Yet Available
loc_type HARDCODED TBD No Not Yet Available
item ARTS_ID TBD No Not Yet Available
change_type HARDCODED TBD No Not Yet Available
PrcChgDtl * * * *
PrcChgRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChgDtl
Tag Name Table Name Column Name API Req Description
unit_retail ENTERED TBD No Not Yet Available
new_uom AS_ITM_RTL_STR LU_UOM No Not Yet Available
effective_date TBD TBD No Not Yet Available
end_date TBD TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChgRef
Tag Name Table Name Column Name API Req Description
change_id TBD TBD Not Yet Available Not Yet Available
promo_comp_id TBD TBD Not Yet Available Not Yet Available
promo_id TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChgExcDesc.xsd
Tag Name Table Name Column Name API Req Description
status_code
loc
loc_type
search_limit_no
dept
class
subclass
PrcChgExcDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcChgExcDtl
Tag Name Table Name Column Name API Req Description
item
price_change_type
NewUnitRetail * * * *
new_selling_uom
from_effective_date
to_effective_date
from_end_date
to_end_date
status
CurruentUnitRetail * * * *
current_selling_uom
BasisUnitRetail * * * *
basis_uom
promotion_id
promotion_comp_id

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:NewUnitRetail
Tag Name Table Name Column Name API Req Description
MoneyType * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:BasisUnitRetail
Tag Name Table Name Column Name API Req Description
MoneyType * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:CurrentUnitRetail
Tag Name Table Name Column Name API Req Description
MoneyType * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:MoneyType
Tag Name Table Name Column Name API Req Description
decimal_value
currency_code

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcInqDesc.xsd
Tag Name Table Name Column Name API Req Description
PrcInqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcInqDtl
Tag Name Table Name Column Name API Req Description
status_code
item
location
location_type
pricing_date TBD TBD Not Yet Available Not Yet Available
selling_unit_retail AS_ITM_RTL_STR UNIT_RETAIL No Not Yet Available
selling_uom
multi_units
multi_unit_retail
multi_selling_uom
currency_code AS_ITM_RTL_STR UNIT_RETAIL No Not Yet Available
price_type TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcInqReq.xsd
Tag Name Table Name Column Name API Req Description
PrcInqReqDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcInqReqDtl
Tag Name Table Name Column Name API Req Description
item ARTS_ID TBD No Not Yet Available
location ARTS_ID TBD No Not Yet Available
location_type HARDCODED TBD No Not Yet Available
pricing_date TBD TBD No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcZoneGrpDesc.xsd
Tag Name Table Name Column Name API Req Description
zone_group_id RK_PRICE_ZONE ZONE_GROUP_ID Yes Not Yet Available
PriceZone * * * *
pricing_level RK_PRICE_ZONE PRICING_LEVEL No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PriceZone
Tag Name Table Name Column Name API Req Description
zone_id RK_PRICE_ZONE ZONE_ID Yes Not Yet Available
currency_code RK_PRICE_ZONE CURRENCY_CODE No Not Yet Available
PrcZoneGrpSt * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcZoneGrpSt
Tag Name Table Name Column Name API Req Description
store RK_PRICE_ZONE ID_STR_RT No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrczoneGrpRef.xsd
Tag Name Table Name Column Name API Req Description
zone_group_id * * * *
PriceZoneRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PriceZoneRef
Tag Name Table Name Column Name API Req Description
zone_id * * * *
PrcZoneGrpStRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrcZoneGrpStRef
Tag Name Table Name Column Name API Req Description
store * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location RK_PRICE_CHANGE TBD No Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
PrmPrcChgDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDtl
Tag Name Table Name Column Name API Req Description
promo_id TBD TBD Not Yet Available Not Yet Available
promo_name TBD TBD Not Yet Available Not Yet Available
promo_description TBD TBD Not Yet Available Not Yet Available
promo_comp_id TBD TBD Not Yet Available Not Yet Available
promo_comp_desc TBD TBD Not Yet Available Not Yet Available
promo_comp_detail_id TBD TBD Not Yet Available Not Yet Available
apply_order TBD TBD Not Yet Available Not Yet Available
start_date TBD TBD Not Yet Available Not Yet Available
end_date TBD TBD Not Yet Available Not Yet Available
PrmPrcChgSmp * * * *
PrmPrcChgThr * * * *
PrmPrcChgBuyGet * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgSmp
Tag Name Table Name Column Name API Req Description
item RK_PRICE_CHANGE TBD No Not Yet Available
promo_selling_retail TBD TBD Not Yet Available Not Yet Available
promo_selling_uom TBD TBD Not Yet Available Not Yet Available
prm_chg_type TBD TBD Not Yet Available Not Yet Available
prm_chg_value TBD TBD Not Yet Available Not Yet Available
prm_chg_uom TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThr
Tag Name Table Name Column Name API Req Description
item * * * *
threshold_id * * * *
threshold_name * * * *
qualification_type
threshold_type * * * *
prm_chg_type * * * *
PrmPrcChgThrDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThrDtl
Tag Name Table Name Column Name API Req Description
threshold_value * * * *
prm_chg_value * * * *
prm_chg_uom * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgBuyGet
Tag Name Table Name Column Name API Req Description
prm_chg_type * * * *
prm_chg_value * * * *
prm_chg_uom * * * *
buy_qty * * * *
all_ind * * * *
PrmPrcChgGetItem * * * *
PrmPrcChgBuyItem * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgGetItem
Tag Name Table Name Column Name API Req Description
item * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgBuyItem
Tag Name Table Name Column Name API Req Description
item * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgRef
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
location * * * *
loc_type * * * *


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
PrmPrcChgDtlref * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
promo_comp_detail_id * * * *
PrmPrcChgSmpDtlRef rpm_future_retail item * *
PrmPrcChgThrDtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgSmpDtlRef
Tag Name Table Name Column Name API Req Description
item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:PrmPrcChgThrDtlRef
Tag Name Table Name Column Name API Req Description
item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RcvUnitAdjDesc.xsd
Tag Name Table Name Column Name API Req Description
loc TR_LTM_ICD_MR ID_STR_RT No Not Yet Available
loc_type
RcvUnitAdjDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RcvUnitAdjDtl
Tag Name Table Name Column Name API Req Description
po_nbr
asn_nbr
item TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
container_id
unit_qty TR_LTM_ICD_MR QU_ITM No Not Yet Available
from_disposition
to_disposition

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ReceiptDesc.xsd
Tag Name Table Name Column Name API Req Description
appt_nbr sim use hard code value 0 TBD No Not Yet Available
Receipt * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:Receipt
Tag Name Table Name Column Name API Req Description
dc_dest_id DO_CTL_INV ID_STR_RT No Not Yet Available
po_nbr DO_CTL_INV ORDER_ID No Not Yet Available
document_type
asn_nbr DO_CTL_INV APPLIED_ASN_NUM No Not Yet Available
ReceiptDtl * * * *
ReceiptCartonDtl * * * *
receipt_type
from_loc
from_loc_type

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ReceiptDtl
Tag Name Table Name Column Name API Req Description
item_id TR_LTM_ICD_MR ID_ICD No Not Yet Available
unit_qty TR_LTM_ICD_MR QU_ITM No Not Yet Available
receipt_xactn_type
receipt_date DO_CTL_INV TS_CMPL No Not Yet Available
receipt_nbr DO_CTL_INV REFERENCE_ID_ICD No Not Yet Available
dest_id
container_id TR_LTM_ICD_MR CONTAINER_ID No Not Yet Available
distro_nbr
distro_doc_type
to_disposition
from_disposition
to_wip
from_wip
to_trouble
from_trouble
user_id DO_CTL_INV ID_ORGR_ICD No Not Yet Available
dummy_carton_ind
tampered_carton_ind
unit_cost TR_LTM_ICD_MR TC_UN_BS No Not Yet Available
shipped_qty TR_LTM_ICD_MR QTY_SHIPPED No Not Yet Available
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:ReceiptCartonDtl
Tag Name Table Name Column Name API Req Description
carton_status_ind
container_id
dest_id
receipt_xactn_type
receipt_date
receipt_nbr
user_id
to_disposition
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RegPrcChgDesc.xsd
Tag Name Table Name Column Name API Req Description
location RK_PRICE_CHANGE ID_STR_RT Yes Not Yet Available
loc_type TBD TBD Not Yet Available Not Yet Available
RegPrcChgDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RegPrcChgDtl
Tag Name Table Name Column Name API Req Description
price_change_id RK_PRICE_CHANGE CHANGE_ID No Not Yet Available
item RK_PRICE_CHANGE ID_ITM No Not Yet Available
effective_date RK_PRICE_CHANGE EFFECTIVE_DATE Yes Not Yet Available
selling_retail_changed_ind
selling_unit_retail RK_PRICE_CHANGE NEW_PRICE Yes Not Yet Available
selling_uom RK_PRICE_CHANGE NEW_SELLING_UOM No Not Yet Available
selling_currency
multi_unit_changed_ind
multi_units
multi_unit_retail
multi_unit_retail_currency
multi_selling_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RegPrcChgRef.xsd
Tag Name Table Name Column Name API Req Description
location * * * *
loc_type * * * *
RegPrcChgDtlRef * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RegPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
price_change_id * * * *
item * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id TBD TBD Not Yet Available Not Yet Available
rtv_id TBD TBD Not Yet Available Not Yet Available
item_id
rtn_auth_nbr TBD TBD Not Yet Available Not Yet Available
unit_qty
container_qty
vendor_nbr
ship_address1 TBD TBD Not Yet Available Not Yet Available
ship_address2 TBD TBD Not Yet Available Not Yet Available
ship_address3
state TBD TBD Not Yet Available Not Yet Available
city TBD TBD Not Yet Available Not Yet Available
shipto_zip TBD TBD Not Yet Available Not Yet Available
country TBD TBD Not Yet Available Not Yet Available
from_disposition
to_disposition
creation_ts TBD TBD Not Yet Available Not Yet Available
unit_cost
reason
comments TBD TBD Not Yet Available Not Yet Available
rtv_order_no
weight
weight_uom
RTVDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVDtl
Tag Name Table Name Column Name API Req Description
item_id TBD TBD Not Yet Available Not Yet Available
unit_qty TBD TBD Not Yet Available Not Yet Available
container_qty
from_disposition TBD TBD Not Yet Available Not Yet Available
to_disposition
unit_cost
reason TBD TBD Not Yet Available Not Yet Available
weight
weight_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVReqDesc.xsd
Tag Name Table Name Column Name API Req Description
rtv_order_no DO_CTL_INV ID_ICD Yes Not Yet Available
supplier DO_CTL_INV ID_PRTY_TO_ICD No Not Yet Available
status_ind
loc DO_CTL_INV ID_STR_RT No Not Yet Available
loc_type
physical_loc
total_order_amt
ship_to_addr_line1
ship_to_addr_line2
ship_to_addr_line3
ship_to_city
state
ship_to_country_code
ship_to_postal_code
ret_auth_nbr DO_CTL_INV AUTHORIZATION_NUM No Not Yet Available
ret_courier
freight_charge
creation_date DO_CTL_INV TS_CRT_ICD No Not Yet Available
completed_date
handling_pct
handling_cost
ext_ref_no
comment_desc DO_CTL_INV COMMENT_DESC No Not Yet Available
RTVReqDtl * * * *
not_after_date DO_CTL_INV NOT_AFTER_DATE No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVReqDtl
Tag Name Table Name Column Name API Req Description
seq_no TBD TBD Not Yet Available Not Yet Available
item TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
shipment
inv_status
rtv_qty TR_LTM_ICD_MR QU_UN_SHP No Not Yet Available
unit_cost
reason TR_LTM_ICD_MR RC_CHN No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVReqRef.xsd
Tag Name Table Name Column Name API Req Description
rtv_order_no * * * *
RTVReqDtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:RTVReqDtlRef
Tag Name Table Name Column Name API Req Description
seq_no * * * *
item * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SODesc.xsd
Tag Name Table Name Column Name API Req Description
distro_nbr RK_ALLOCATIONS ALLOCATION_ID Yes mapped to DO_CTL_INV.ID_ICD as well.Not Yet Available
document_type
dc_dest_id RK_ALLOCATIONS WAREHOUSE_ID No mapped to DO_CTL_INV.ID_PRTY_TO_ICD as well. Not Yet Available
order_type
pick_not_before_date DO_CTL_INV NOT_AFTER_DATE No Not Yet Available
pick_not_after_date RK_ALLOCATIONS DELIVERY_DATE No Not Yet Available
priority
event_code
event_description
carrier_code
carrier_service_code
route
ship_address_desc
ship_address1
ship_address2
ship_address3
ship_address4
ship_address5
ship_city
ship_state
ship_zip
ship_country_id
bill_address_desc
bill_address1
bill_address2
bill_address3
bill_address4
bill_address5
bill_city
bill_state
bill_zip
bill_country_id
break_by_distro
rollback_allocation
cartonization
consumer_direct
message
chute_type
po_nbr
parent_customer_order
pick_complete
order_line_costs
container_type
amount1
amount2
amount3
amount4
amount5
amount6
sub_total
gift_cost_total
promotion_total
total
tax_total
shipping_total
order_uda1
order_uda2
order_uda3
order_uda4
order_uda5
order_uda6
order_uda7
order_uda8
order_uda9
order_uda10
dl_comment
ship_date
SODtlDesc * * * *
not_after_date
distro_parent_nbr
exp_dc_date
approval_id
approval_date
from_loc_tsf_entity
to_loc_tsf_entity
inv_type
so_status
delivery_date

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SODtlDesc
Tag Name Table Name Column Name API Req Description
dest_id RK_ALLOCATIONS STORE_ID No mapped to TR_LTM_ICD_MR.ID_STR_RT as well, Not Yet Available
item_id RK_ALLOCATIONS ITEM_ID No mapped to TR_LTM_ICD_MR.ID_ITM as well. Not Yet Available
requested_unit_qty RK_ALLOCATIONS QUANTITY No mapped to TR_LTM_ICD_MR.QU_ITM as well.Not Yet Available
retail_price
selling_uom
ticket_type
priority
store_ord_mult
expedite_flag
order_line_nbr
amount1
amount2
amount3
amount4
amount5
amount6
tax_percent
item_status
component_ticketing_distro_nbr
in_store_date
total
gift_cost
shipping
promotion
sub_total
tax
order_detail_uda1
order_detail_uda2
order_detail_uda3
order_detail_uda4
order_detail_uda5
SODtlTcktDesc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SODtlTcktDesc
Tag Name Table Name Column Name API Req Description
distro_nbr
document_type
item_id
dest_id
component_item_id
retail_price
selling_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SORef.xsd
Tag Name Table Name Column Name API Req Description
distro_nbr * * * *
document_type * * * *
dc_dest_id * * * *
SODtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SODtlRef
Tag Name Table Name Column Name API Req Description
dest_id * * * *
item_id * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SOStatusDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id
distro_nbr DO_CTL_INV ID_ICD Yes Not Yet Available
distro_document_type
SOStatusDtl * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:SOStatusDtl
Tag Name Table Name Column Name API Req Description
cust_order_nbr
dest_id
item_id TR_LTM_ICD_MR ID_ITM Yes Not Yet Available
order_line_nbr
unit_qty TR_LTM_ICD_MR QU_UN_SHP No Not Yet Available
status
user_id
updated_date

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StkCountSchDesc.xsd
Tag Name Table Name Column Name API Req Description
cycle_count RK_STK_CT STK_CT_ID Yes Not Yet Available
cycle_count_desc RK_STK_CT DESCRIPTION No Not Yet Available
location_type TBD TBD Not Yet Available Not Yet Available
stocktake_date RK_STK_CT START_DATE No Not Yet Available
stocktake_type TBD TBD Not Yet Available Not Yet Available
StkCountSchProd * * * *
StkCountSchLoc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StkCountSchProd
Tag Name Table Name Column Name API Req Description
dept RK_STK_CT_GRP_MH MH_ID Yes Not Yet Available
class RK_STK_CT_GRP_MH MH_ID Yes Not Yet Available
subclass RK_STK_CT_GRP_MH MH_ID Yes Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StkCountSchLoc
Tag Name Table Name Column Name API Req Description
location RK_STK_CT_STORE ID_STR_RT No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StkCountSchRef.xsd
Tag Name Table Name Column Name API Req Description
cycle_count

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StoreDesc.xsd
Tag Name Table Name Column Name API Req Description
store PA_STR_RTL ID_STR_RT No Not Yet Available
store_name PA_ORGN NM_ORGN No Not Yet Available
store_name10
store_name3
store_add1
store_add2
store_city PA_ORGN ID_GRP_MSG No Not Yet Available
county
state PA_ORGN ID_GRP_MSG No Not Yet Available
country_id PA_ORGN ID_GRP_MSG No Not Yet Available
store_pcode
store_class
store_mgr_name
store_open_date PA_STR_RTL DC_OPN_RT_STR No Not Yet Available
store_close_date PA_STR_RTL DC_CL_RT_STR No Not Yet Available
acquired_date
remodel_date
fax_number
phone_number
email
total_square_ft PA_STR_RTL QU_SZ_STR No Not Yet Available
selling_square_ft PA_STR_RTL QU_SZ_AR_SL No Not Yet Available
linear_distance
stockholding_ind
channel_id
store_format
mall_name
district
district_name
promo_zone
promo_desc
transfer_zone PA_STR_RTL ID_TSF_ZONE No Not Yet Available
description
default_wh
stop_order_days
start_order_days
currency_code PA_STR_RTL TY_CNY No Not Yet Available
lang
integrated_pos_ind
orig_currency_code
duns_number
duns_loc
AddrDesc * * * See layout below.
pricing_loc
pricing_loc_curr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AddrDesc
Tag Name Table Name Column Name API Req Description
addr LO_ADS_NSTD TBD No Not Yet Available
addr_type
primary_addr_type_ind
primary_addr_ind
add_1 LO_ADS_NSTD A1_ADS No Not Yet Available
add_2 LO_ADS_NSTD A2_ADS No Not Yet Available
add_3
city LO_ADS_NSTD CITY No Not Yet Available
state LO_ADS_NSTD TE_NM No Not Yet Available
country_id LO_ADS_NSTD CO_NM No Not Yet Available
post LO_ADS_NSTD PC_NM No Not Yet Available
contact_name
contact_phone LO_PH TA_PH No Not Yet Available
contact_telex LO_PH TA_PH No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_fax LO_PH TA_PH No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_email LO_EML_ADS EM_ADS Yes Not Yet Available
oracle_vendor_site_id
county

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:StoreRef.xsd
Tag Name Table Name Column Name API Req Description
store * * * *
AddrRef * * No See layout below.

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AddrRef
Tag Name Table Name Column Name API Req Description
addr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:TsfDesc.xsd
Tag Name Table Name Column Name API Req Description
tsf_no
doc_type
physical_from_loc
from_loc_type
from_loc
physical_to_loc
to_loc_type
to_loc
tsf_type
pick_not_before_date
pick_not_after_date
default_order_type
priority
break_by_distro
delivery_date
cust_name
deliver_add1
deliver_add2
deliver_city
deliver_state
deliver_post
deliver_country_id
message
TsfDtl * * * Child node - see layout below.
tsf_parent_no
exp_dc_date
approval_id
approval_date
from_loc_tsf_entity
to_loc_tsf_entity
inv_type
tsf_status
not_after_date
context_type
context_value

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:TsfDtl
Tag Name Table Name Column Name API Req Description
item
tsf_qty
price
selling_uom
priority
expedite_flag
store_ord_mult
tsf_po_link_no
ticket_type_id
TsfDtlTckt * * * Child Node - see layout below.
inv_status

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:TsfDtlTckt
Tag Name Table Name Column Name API Req Description
comp_item
comp_price
comp_selling_uom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:TsfRef.xsd
Tag Name Table Name Column Name API Req Description
tsf_no
doc_type
physical_from_loc
from_loc
physical_to_loc
to_loc
TsfDtlRef * * * Child Node - see below.

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:TsfDtlRef
Tag Name Table Name Column Name API Req Description
item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:VendorAddrRef.xsd
Tag Name Table Name Column Name API Req Description
supplier TBD TBD Not Yet Available Not Yet Available
seq_no
address_type TBD TBD Not Yet Available Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:VendorDesc.xsd
Tag Name Table Name Column Name API Req Description
VendorHdrDesc * * * *
VendorAddrDesc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:VendorHdrDesc
Tag Name Table Name Column Name API Req Description
supplier PA_SPR ID_SPR Yes Not Yet Available
sup_name PA_SPR NM_SPR No Not Yet Available
contact_name
contact_phone
contact_fax
contact_pager
sup_status PA_SPR STATUS No Not Yet Available
qc_ind
qc_pct
qc_freq
vc_ind PA_SPR VC_IND No Not Yet Available
vc_pct PA_SPR VC_PCT No Not Yet Available
vc_freq
currency_code PA_SPR CURRENCY_CODE No Not Yet Available
lang
terms
freight_terms
ret_allow_ind PA_SPR ST_RETURNS_ALLOWED No Not Yet Available
ret_auth_req PA_SPR ST_RETURN_NUM_IND No Not Yet Available
ret_min_dol_amt
ret_courier
handling_pct
edi_po_ind
edi_po_chg
edi_po_confirm
edi_asn
edi_sales_rpt_freq
edi_supp_available_ind
edi_contract_ind
edi_invc_ind
cost_chg_pct_var
cost_chg_amt_var
replen_approval_ind
ship_method
payment_method
contact_telex
contact_email
settlement_code
pre_mark_ind
auto_appr_invc_ind
dbt_memo_code
freight_charge_ind
auto_appr_dbt_memo_ind
inv_mgmt_lvl
backorder_ind
vat_region
prepay_invc_ind
service_perf_req_ind
invc_pay_loc
invc_receive_loc
addinvc_gross_net
delivery_policy
comment_desc
default_item_lead_time
duns_number PA_SPR DU_SPR No Not Yet Available
duns_loc
bracket_costing_ind
vmi_order_status
end_date_active PA_RO_PRTY DC_RO_PRTY_EP No Not Yet Available
dsd_supplier_ind PA_SPR ST_CRT_PO_IND No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:VendorAddrDesc
Tag Name Table Name Column Name API Req Description
module
key_value_1
key_value_2
seq_no
addr_type
primary_addr_ind
add_1 LO_ADS_NSTD A1_ADS No Not Yet Available
add_2 LO_ADS_NSTD A2_ADS No Not Yet Available
add_3 LO_ADS_NSTD A2_ADS No Not Yet Available
city LO_ADS_NSTD CITY No Not Yet Available
state LO_ADS_NSTD TE_NM No Not Yet Available
country_id LO_ADS_NSTD CO_NM No Not Yet Available
post LO_ADS_NSTD PC_NM No Not Yet Available
contact_name PA_PRS LN_PRS Yes Not Yet Available
contact_phone LO_PH TA_PH No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_telex
contact_fax LO_PH TA_PH No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_email LO_EML_ADS EM_ADS Yes Not Yet Available
oracle_vendor_site_id
OracleOUDesc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:OracleOUDesc
Tag Name Table Name Column Name API Req Description
OUDtlDesc * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:OUDtlDesc
Tag Name Table Name Column Name API Req Description
ou_id
site_id

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:VendorRef.xsd
Tag Name Table Name Column Name API Req Description
supplier

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WHDesc.xsd
Tag Name Table Name Column Name API Req Description
wh LO_ADS_NSTD TBD No Not Yet Available
wh_name TBD TBD Not Yet Available Not Yet Available
wh_add1 TBD TBD Not Yet Available Not Yet Available
wh_add2 TBD TBD Not Yet Available Not Yet Available
wh_city TBD TBD Not Yet Available Not Yet Available
county TBD TBD Not Yet Available Not Yet Available
state TBD TBD Not Yet Available Not Yet Available
country_id TBD TBD Not Yet Available Not Yet Available
wh_pcode
email TBD TBD Not Yet Available Not Yet Available
stockholding_ind
channel_id
currency_code
duns_number
duns_loc
physical_wh
break_pack_ind
redist_wh_ind
delivery_policy
contact_person
dest_fax
phone_nbr
default_route
default_carrier_code
default_service_code
expedite_route
expedite_carrier_code
expedite_service_code
bol_upload_type
bol_print_type
lead_time
distance_to_dest
drop_trailers_accepted_flag
rcv_dock_available_flag
container_type
mld_default_route
unit_pick_container_type
dest_seq_nbr
owning_dc
AddrDesc * * * *
pricing_loc
pricing_loc_curr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AddrDesc
Tag Name Table Name Column Name API Req Description
addr
addr_type
primary_addr_type_ind
primary_addr_ind
add_1
add_2
add_3
city
state
country_id
post
contact_name
contact_phone
contact_telex
contact_fax
contact_email
oracle_vendor_site_id
county

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WHRef.xsd
Tag Name Table Name Column Name API Req Description
wh * * * *
AddrRef * * * *

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:AddrRef
Tag Name Table Name Column Name API Req Description
addr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutDesc.xsd
Tag Name Table Name Column Name API Req Description
wo_id
dc_dest_id
distro_nbr
WOOutDtl
distro_parent_nbr
WOOutXForm
WOOutPacking
inv_type

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutDtl
Tag Name Table Name Column Name API Req Description
dest_id
item_id
wip_seq_nbr
wip_code
personalization
instructions
order_line_nbr
auto_complete
WOOutActivity
inv_status

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutActivity
Tag Name Table Name Column Name API Req Description
activity_id
activity_cost
comments

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutXForm
Tag Name Table Name Column Name API Req Description
from_item
to_item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutPacking
Tag Name Table Name Column Name API Req Description
WOOutPackTo
WOOutPackFrom

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutPackTo
Tag Name Table Name Column Name API Req Description
to_item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutPackFrom
Tag Name Table Name Column Name API Req Description
from_item

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutRef.xsd
Tag Name Table Name Column Name API Req Description
wo_id
dc_dest_id
distro_nbr
WOOutDtlRef
distro_parent_nbr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOOutDtlRef
Tag Name Table Name Column Name API Req Description
dest_id
item_id
wip_seq_nbr
order_line_nbr

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:node
RIB Mappings Report Release: 13.0.0
Tag Name Table Name Column Name API Req Description
field table_name column_nam required perm_desc


Oracle Portal
Retail Integration Bus Mappings Report    Release: 13.0.0

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOStatusDesc.xsd
Tag Name Table Name Column Name API Req Description
wo_id
distro_nbr
distro_doc_type
distro_parent_nbr
distro_parent_type
item
wh
loc_type
location
seq_no
wip_code
instructions
complete_date
completed_qty
completed_ind
WOStatusInvAdj

Application Name: Store Inventory Management
Version 13.0.0
XML-Schema or Node Name:WOStatusInvAdj
Tag Name Table Name Column Name API Req Description
from_disposition
to_disposition
unit_qty