Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNInDesc.xsd
Tag Name Table Name Column Name API Req Description
asn_type
container_qty
bol_nbr


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNINDesc.xsd
Tag Name Table Name Column Name API Req Description
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNInDesc.xsd
Tag Name Table Name Column Name API Req Description
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNINDesc.xsd
Tag Name Table Name Column Name API Req Description
vendor_nbr DO_CTL_INV ID_PRTY_FM_ICD No Not Yet Available


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNInDesc.xsd
Tag Name Table Name Column Name API Req Description
ship_pay_method
ASNInPO * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNINDesc.xsd
Tag Name Table Name Column Name API Req Description
comments DO_CTL_INV COMMENT_DESC No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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 Yes Contains the location that the shipment will be delivered to.
from_location DO_CTL_INV ID_PRTY_FM_ICD Yes For transfer and return to warehouse shipments, this field will hold the location from which the shipment was sourced.
asn_nbr DO_CTL_INV ASN_NUM No Holds the bill of lading number associated with a shipment
asn_type n/a n/a No Specifies the type of ASN. 'C' - Container, 'I' - Item
container_qty n/a n/a No Contains the number of boxes associated with the shipment
bol_nbr DO_CTL_INV ID_ICD No Holds the transaction or return sequence number on the message from the transfer shipment confirmation process.
shipment_date DO_CTL_INV DC_SPRC_ACT_SHP No This field contains the date the transfer or return was shipped
est_arr_date n/a n/a No Populated with null value by SIM
ship_address1 n/a n/a No Populated with an empty value by SIM
ship_address2 n/a n/a No Populated with an empty value by SIM
ship_address3 n/a n/a No Populated with an empty value by SIM
ship_address4 n/a n/a No Populated with an empty value by SIM
ship_address5 n/a n/a No Populated with an empty value by SIM
ship_city n/a n/a No Populated with an empty value by SIM
ship_state n/a n/a No Populated with an empty value by SIM
ship_zip n/a n/a No Populated with an empty value by SIM
ship_country_id n/a n/a No Populated with an empty value by SIM
trailer_nbr n/a n/a No Populated with an empty value by SIM
seal_nbr n/a n/a No Populated with an empty value by SIM
carrier_code n/a n/a No Populated with an empty value by SIM
transshipment_nbr n/a n/a No Populated with an empty value by SIM
ASNOutDistro * * * *
comments DO_CTL_INV COMMENT_DESC No Not Yet Available

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ASNOutDistro
Tag Name Table Name Column Name API Req Description
distro_nbr DO_CTL_INV ID_ICD Yes Specifies the transfer or return number associated with the shipment/item/carton.
distro_doc_type n/a n/a Yes Specifiy the distro doc type for the transfer or return. 'T' - Transfer, 'C' - Customer Order, 'D' - distro, 'V'-Vendor
customer_order_nbr n/a n/a No Populated with empty value by SIM
consumer_direct n/a n/a No Populated with empty value by SIM
ASNOutCtn * * * *
comments n/a n/a No Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
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 n/a n/a No Populated with empty value by SIM
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:ClrPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
clearance_id
item


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:DSDDealsDesc.xsd
Tag Name Table Name Column Name API Req Description
DSDDeals n/a n/a No Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:DSDDeals
Tag Name Table Name Column Name API Req Description
order_no n/a n/a Yes Not used by SIM
supplier n/a n/a Yes Not used by SIM
store n/a n/a Yes Not used by SIM
dept n/a n/a No Not used by SIM
currency_code n/a n/a Yes Not used by SIM
paid_ind n/a n/a Yes Not used by SIM
ext_ref_no n/a n/a No Not used by SIM
proof_of_delivery_no n/a n/a No Not used by SIM
payment_ref_no n/a n/a No Not used by SIM
payment_date n/a n/a No Not used by SIM
deals_ind n/a n/a Yes Not used by SIM
shipment n/a n/a No Not used by SIM
invc_id n/a n/a No Not used by SIM
invc_ind n/a n/a Yes Not used by SIM
vdate n/a n/a Yes Not used by SIM
qty_sum n/a n/a No Not used by SIM
cost_sum n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:InvAdjustDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id DO_CTL_INV ID_STR_RT Yes Contains the location where the inventory adjustment occurred
InvAdjustDtl * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:InvAdjustDtl
Tag Name Table Name Column Name API Req Description
item_id TR_LTM_ICD_MR ID_ITM Yes Identifies the item on the inventory adjustment
adjustment_reason_code TR_LTM_ICD_MR RC_CHN No Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types.
unit_qty TR_LTM_ICD_MR QU_ITM Yes Contains the quantity the inventory was adjusted by.
transshipment_nbr n/a n/a No Populated with an empty value by SIM
from_disposition n/a n/a No Used to determine if the adjustment quantity is negative or positive.
to_disposition n/a n/a No Used to determine if the adjustment quantity is negative or positive.
from_trouble_code n/a n/a No Populated with an empty value by SIM
to_trouble_code n/a n/a No Populated with an empty value by SIM
from_wip_code n/a n/a No Populated with an empty value by SIM
to_wip_code n/a n/a No Populated with an empty value by SIM
transaction_code n/a n/a Yes Populated with 0 by SIM
user_id n/a n/a Yes Contains the user id for the user making the inventory adjustme
create_date DO_CTL_INV TS_CRT_ICD Yes Contains the date on which the inventory adjustment occurred
po_nbr n/a n/a No Populated with an empty value by SIM
doc_type n/a n/a No Populated with an empty value by SIM
aux_reason_code n/a n/a No Populated with an empty value by SIM
weight n/a n/a No Not used by SIM
weight_uom n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:InvReqDesc.xsd
Tag Name Table Name Column Name API Req Description
request_id RK_ITEM_REQUEST REQUEST_ID Yes An identifier which represents the inventory request
store RK_ITEM_REQUEST STORE_ID Yes The store id which is requesting the item
request_type n/a n/a Yes Defines the request type. Valid values are: 'IR' (Inventory Request) and 'SO' (Store Order)
InvReqItem * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:InvReqItem
Tag Name Table Name Column Name API Req Description
item RK_ITEM_REQUEST_LINE_ITEM ITEM_ID Yes Unique alphanumeric value that identifies the item to be requested.
qty_rqst RK_ITEM_REQUEST_LINE_ITEM QUANTITY Yes The quantity for the item being requested.
uop n/a n/a Yes Unit of Purchase - used for conversion
need_date RK_ITEM_REQUEST REQ_DELIVERY_DATE Yes The date that the store needs the item by.


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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.1
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.1
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.1
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.1
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.1
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.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:ItemLocVirtRef
Tag Name Table Name Column Name API Req Description
loc * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemSupCtyDesc
Tag Name Table Name Column Name API Req Description
item n/a n/a Yes Not used by SIM
supplier n/a n/a Yes Not used by SIM
origin_country_id n/a n/a Yes Not used by SIM
primary_supp_ind n/a n/a Yes Not used by SIM
primary_country_ind n/a n/a Yes Not used by SIM
unit_cost n/a n/a Yes Not used by SIM
lead_time n/a n/a No Not used by SIM
pickup_lead_time n/a n/a No Not used by SIM
supp_pack_size n/a n/a Yes Not used by SIM
inner_pack_size n/a n/a Yes Not used by SIM
round_lvl n/a n/a Yes Not used by SIM
min_order_qty n/a n/a No Not used by SIM
max_order_qty n/a n/a No Not used by SIM
packing_method n/a n/a Yes Not used by SIM
default_uop n/a n/a Yes Not used by SIM
ti n/a n/a Yes Not used by SIM
hi n/a n/a Yes Not used by SIM
cost_uom n/a n/a No Not used by SIM
tolerance_type n/a n/a No Not used by SIM
max_tolerance n/a n/a No Not used by SIM
min_tolerance n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemSupDesc
Tag Name Table Name Column Name API Req Description
item n/a n/a Yes Not used by SIM
supplier n/a n/a Yes Not used by SIM
primary_supp_ind n/a n/a Yes Not used by SIM
vpn n/a n/a No Not used by SIM
supp_label n/a n/a No Not used by SIM
consignment_rate n/a n/a No Not used by SIM
supp_diff_1 n/a n/a No Not used by SIM
supp_diff_2 n/a n/a No Not used by SIM
supp_diff_3 n/a n/a No Not used by SIM
supp_diff_4 n/a n/a No Not used by SIM
pallet_name n/a n/a No Not used by SIM
case_name n/a n/a No Not used by SIM
inner_name n/a n/a No Not used by SIM
supp_discontinue_date n/a n/a No Not used by SIM
direct_ship_ind n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemTcktDesc
Tag Name Table Name Column Name API Req Description
item n/a n/a Yes Not used by SIM
ticket_type_id n/a n/a Yes Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemUPCDesc
Tag Name Table Name Column Name API Req Description
item_id n/a n/a Yes Not used by SIM
item_parent n/a n/a No Not used by SIM
primary_ref_item_ind n/a n/a No Not used by SIM
format_id n/a n/a No Not used by SIM
prefix n/a n/a No Not used by SIM
item_number_type n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
XML-Schema or Node Name:LocPODtlsRspDtl
Tag Name Table Name Column Name API Req Description
item * * * *
pack_size * * * *
ordered_quantity * * * *
unit_cost * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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 * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:MrchHrClsDesc
Tag Name Table Name Column Name API Req Description
class n/a n/a Yes Not used by SIM
class_name n/a n/a Yes Not used by SIM
class_vat_ind n/a n/a No Not used by SIM
dept n/a n/a Yes Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:MrchHrDeptDesc
Tag Name Table Name Column Name API Req Description
dept n/a n/a Yes Not used by SIM
dept_name n/a n/a No Not used by SIM
buyer n/a n/a No Not used by SIM
purchase_type n/a n/a No Not used by SIM
total_market_amt n/a n/a No Not used by SIM
merch n/a n/a No Not used by SIM
group_no n/a n/a No Not used by SIM
bud_mkup n/a n/a No Not used by SIM
profit_calc_type n/a n/a No Not used by SIM
markup_calc_type n/a n/a No Not used by SIM
otb_calc_type n/a n/a No Not used by SIM
max_avg_counter n/a n/a No Not used by SIM
avg_tolerance_pct n/a n/a No Not used by SIM
bud_int n/a n/a No Not used by SIM
dept_vat_incl_ind n/a n/a No Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:MrchHrSclsDesc
Tag Name Table Name Column Name API Req Description
subclass n/a n/a Yes Not used by SIM
subclass_name n/a n/a Yes Not used by SIM
class n/a n/a Yes Not used by SIM
dept n/a n/a Yes Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:PODesc.xsd
Tag Name Table Name Column Name API Req Description
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.1
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.1
XML-Schema or Node Name:POVirtualDtl
Tag Name Table Name Column Name API Req Description
location_type
location
qty_ordered


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:NewUnitRetail
Tag Name Table Name Column Name API Req Description
MoneyType * * * *

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

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

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:PrcZoneGrpStRef
Tag Name Table Name Column Name API Req Description
store * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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.1
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.1
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.1
XML-Schema or Node Name:PrmPrcChgGetItem
Tag Name Table Name Column Name API Req Description
item * * * *

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:PrmPrcChgRef
Tag Name Table Name Column Name API Req Description
location * * * *
loc_type * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:PrmPrcChgSmpDtlRef
Tag Name Table Name Column Name API Req Description
item

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:node
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.1

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

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ListGroup
Tag Name Table Name Column Name API Req Description
listgroup_id null null null null
ListDtl * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ListDtl
Tag Name Table Name Column Name API Req Description
listdtl_id null null null null
reward_application null null null null
description null null null null
DiscountLadder * * * *
ItemList * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:LocationList
Tag Name Table Name Column Name API Req Description
location null null null null
loc_type null null null null

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:PromotionDesc
Tag Name Table Name Column Name API Req Description
promo_id null null null null
promo_name null null null null
promo_description null null null null
promo_comp_id null null null null
promo_comp_desc null null null null
promo_comp_type null null null null
promo_dtl_id null null null null
apply_order null null null null
start_date null null null null
end_date null null null null
exception_parent_id null null null null
LocationList * * * *
ListGroup * * * *
ItemLocSimpleRetail * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:DiscountLadder
Tag Name Table Name Column Name API Req Description
chg_type null null null null
chg_amt null null null null
chg_currency null null null null
chg_percent null null null null
chg_selling_uom null null null null
qual_type null null null null
qual_value null null null null

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemList
Tag Name Table Name Column Name API Req Description
item_num null null null null

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemLocSimpleRetail
Tag Name Table Name Column Name API Req Description
item_num null null null null
location null null null null
selling_retail null null null null
selling_uom null null null null

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:PromotionRef
Tag Name Table Name Column Name API Req Description
promo_id null null null null
promo_comp_id null null null null
promo_dtl_id null null null null
LocationListRef * * * *
ListGroupRef * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ListGroupRef
Tag Name Table Name Column Name API Req Description
listgroup_id null null null null
ListDtlRef * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ListDtlRef
Tag Name Table Name Column Name API Req Description
listdtl_id null null null null
ItemListRef * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ItemListRef
Tag Name Table Name Column Name API Req Description
item_num null null null null

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:LocationListRef
Tag Name Table Name Column Name API Req Description
location null null null null


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ReceiptDesc.xsd
Tag Name Table Name Column Name API Req Description
appt_nbr n/a n/a No Not used by SIM
Receipt * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:Receipt
Tag Name Table Name Column Name API Req Description
dc_dest_id DO_CTL_INV ID_STR_RT Yes The receiving store number
po_nbr DO_CTL_INV ORDER_ID No Specified the unique identifier of the purchase order, allocation or transfer
document_type n/a n/a Yes Specified whether the receipt is for an allocation 'A', purchase order 'P', or transfer 'T'. Types 'D' and 'V' are also valid document types that are treated the same as transfers.
asn_nbr DO_CTL_INV APPLIED_ASN_NUM No Used to relate the receipt message to the previous ASN message. this field is required for doc types 'A' and 'T', not required for doc_type 'P'
ReceiptDtl * * * *
ReceiptCartonDtl * * * *
receipt_type n/a n/a No This fied is required when receiving a transfer or allocation to determine if the receipt is at the 'BL' (BOL) level or 'SK' (SKU) level. It is not used for a PO receipt
from_loc n/a n/a No Not used by SIM
from_loc_type n/a n/a No Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ReceiptDtl
Tag Name Table Name Column Name API Req Description
item_id TR_LTM_ICD_MR ID_ICD Yes Specifieds the item on the allocation, purchase order, or transfer that has been received.
unit_qty TR_LTM_ICD_MR QU_ITM Yes Contains the quantity received for the allocation, purchase order, or transfer.
receipt_xactn_type n/a n/a Yes Specifies whether the receipt detail line item is for a 'R'eceipt, 'T'ransshipment, or 'A'djustment. For purchase order receiving, Transshipments are not allowed. For stock order (ie. Allocation and Transfer) receiving, Transshipments are handled the same way as 'R'eceipt type.
receipt_date DO_CTL_INV TS_CMPL No Identifies the date the transaction was written
receipt_nbr DO_CTL_INV REFERENCE_ID_ICD No An externally generated numerical identifier corresponding to the successful reception of the item at the location.
dest_id DO_CTL_INV ID_STR_RT No Specifies the receiving store of the Purchase order. Only used for doc_type of 'P'.
container_id TR_LTM_ICD_MR CONTAINER_ID No Identifies the Carton number for shipments originating from the Advance Shipment Notification process as carton shipments
distro_nbr n/a n/a No Not used by SIM
distro_doc_type n/a n/a No Not used by SIM
to_disposition n/a n/a No This value is used to determine if the inventory availability.
from_disposition n/a n/a No This value is used to determine inventory availability. It is not used by SIM.
to_wip n/a n/a No Not used by SIM
from_wip n/a n/a No Not used by SIM
to_trouble n/a n/a No Not used by SIM
from_trouble n/a n/a No Not used by SIM
user_id DO_CTL_INV ID_ORGR_ICD No Identifies the point of origin for this inventory control document. An originator may be a program (for automatically generated documents) or a person
dummy_carton_ind n/a n/a No Not used by SIM
tampered_carton_ind n/a n/a No Not used by SIM
unit_cost TR_LTM_ICD_MR TC_UN_BS No Only used for doc_type of 'P'. Specifies the unit_cost for the item on the order
shipped_qty TR_LTM_ICD_MR QTY_SHIPPED No The number of the items shipped which was specified by the ASN
weight n/a n/a No Not used by SIM
weight_uom n/a n/a No Not used by SIM

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:ReceiptCartonDtl
Tag Name Table Name Column Name API Req Description
carton_status_ind n/a n/a Yes Not used by SIM
container_id n/a n/a Yes Not used by SIM
dest_id n/a n/a No Not used by SIM
receipt_xactn_type n/a n/a Yes Not used by SIM
receipt_date n/a n/a Yes Not used by SIM
receipt_nbr n/a n/a No Not used by SIM
user_id n/a n/a No Not used by SIM
to_disposition n/a n/a No Not used by SIM
weight n/a n/a No Not used by SIM
weight_uom n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:RegPrcChgDtlRef
Tag Name Table Name Column Name API Req Description
price_change_id * * * *
item * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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 Yes 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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:RTVReqDtlRef
Tag Name Table Name Column Name API Req Description
seq_no * * * *
item * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:SODtlRef
Tag Name Table Name Column Name API Req Description
dest_id * * * *
item_id * * * *


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:SOStatusDesc.xsd
Tag Name Table Name Column Name API Req Description
dc_dest_id DO_CTL_INV ID_PRTY_TO_ICD No Contains the location number of the stock order receiving location
distro_nbr DO_CTL_INV ID_ICD Yes Contains the stock order number. this is inventory control document number for a transfer or return in SIM
distro_document_type n/a n/a Yes Specifies whether the stock order status pertains to an allocation 'A', or transfer 'T'. Types 'D'C Created Stock Order,'C'ustomer Order, and 'V'irtual Distro are also valid document types but will be ignored by the RMS API.
SOStatusDtl * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:SOStatusDtl
Tag Name Table Name Column Name API Req Description
cust_order_nbr n/a n/a No Not used by SIM
dest_id
item_id TR_LTM_ICD_MR ID_ITM Yes An identifier which represents an ITEM.
order_line_nbr n/a n/a No Not used by SIM
unit_qty TR_LTM_ICD_MR QU_UN_SHP No The difference beween the number of ITEM units shipped versus the receiving count for the given ITEM. This is subtracted from the document-line-item-unit-count to yield an over/under variance between what a supplier said was shipped and what was counted and received at by the store's staff.
status n/a n/a Yes The status of the stock order. Valid values are: 'DS' - Details Selected, 'DU' - Details Un-Selected, 'NI' - Line Cancellation, 'PP' - Distributed, 'PU' - Un-Distributed, 'RS' - Return To Stock, 'EX' - Expired, 'SR' - Store Reassign, 'SC' - Store Cancellation.
user_id n/a n/a No Not used by SIM
updated_date n/a n/a No Not used by SIM


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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 Contains the number which uniquely identifies the stock count
cycle_count_desc RK_STK_CT DESCRIPTION No Contains a description of the stock count
location_type n/a n/a Yes Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse.
stocktake_date RK_STK_CT START_DATE Yes Contains the date on which the stock or cycle count even will take place
stocktake_type n/a n/a Yes Contains a value which indicates the type of stock take. Valid values are 'B' -Both Unit and Dollar and 'U' - Unit only. However the RIB interface only allows 'B'.
StkCountSchProd * * * *
StkCountSchLoc * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:StkCountSchProd
Tag Name Table Name Column Name API Req Description
dept RK_STK_CT_GRP_MH MH_ID Yes Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments.
class RK_STK_CT_GRP_MH MH_ID No Contains the class number where the cycle count will occur.
subclass RK_STK_CT_GRP_MH MH_ID No Contains the subclass number where the cycle count will occur.

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:StkCountSchLoc
Tag Name Table Name Column Name API Req Description
location RK_STK_CT_STORE ID_STR_RT No Contains the store or wh number on the stock count.


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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_type * * Yes *
org_unit_type * * No *
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:AddrRef
Tag Name Table Name Column Name API Req Description
addr


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
XML-Schema or Node Name:TsfDtlTckt
Tag Name Table Name Column Name API Req Description
comp_item
comp_price
comp_selling_uom


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:TsfDtlRef
Tag Name Table Name Column Name API Req Description
item


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
XML-Schema or Node Name:OracleOUDesc
Tag Name Table Name Column Name API Req Description
OUDtlDesc * * * *

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:AddrRef
Tag Name Table Name Column Name API Req Description
addr


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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.1
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.1
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.1
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.1
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.1
XML-Schema or Node Name:WOOutPackFrom
Tag Name Table Name Column Name API Req Description
from_item


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
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


Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
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.1
XML-Schema or Node Name:WOStatusInvAdj
Tag Name Table Name Column Name API Req Description
from_disposition
to_disposition
unit_qty