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