 |
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 |