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