 |
Retail Integration Bus Mappings Report
Release: 13.0.0 |
 |
|
| Application Name: Store Inventory Management |
Version 13.0.0 |
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.0 |
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.0 |
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 |