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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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
Tag Name
Table Name
Column Name
API Req
Description
field
table_name
column_nam
required
perm_desc
RIB Mappings Report Release: 13.0.0
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