 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Store Inventory Management |
Version 13.0.1 |
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 | Yes | Contains the location that the shipment will be delivered to. |
| from_location | DO_CTL_INV | ID_PRTY_FM_ICD | Yes | For transfer and return to warehouse shipments, this field will hold the location from which the shipment was sourced. |
| asn_nbr | DO_CTL_INV | ASN_NUM | No | Holds the bill of lading number associated with a shipment |
| asn_type | n/a | n/a | No | Specifies the type of ASN. 'C' - Container, 'I' - Item |
| container_qty | n/a | n/a | No | Contains the number of boxes associated with the shipment |
| bol_nbr | DO_CTL_INV | ID_ICD | No | Holds the transaction or return sequence number on the message from the transfer shipment confirmation process. |
| shipment_date | DO_CTL_INV | DC_SPRC_ACT_SHP | No | This field contains the date the transfer or return was shipped |
| est_arr_date | n/a | n/a | No | Populated with null value by SIM |
| ship_address1 | n/a | n/a | No | Populated with an empty value by SIM |
| ship_address2 | n/a | n/a | No | Populated with an empty value by SIM |
| ship_address3 | n/a | n/a | No | Populated with an empty value by SIM |
| ship_address4 | n/a | n/a | No | Populated with an empty value by SIM |
| ship_address5 | n/a | n/a | No | Populated with an empty value by SIM |
| ship_city | n/a | n/a | No | Populated with an empty value by SIM |
| ship_state | n/a | n/a | No | Populated with an empty value by SIM |
| ship_zip | n/a | n/a | No | Populated with an empty value by SIM |
| ship_country_id | n/a | n/a | No | Populated with an empty value by SIM |
| trailer_nbr | n/a | n/a | No | Populated with an empty value by SIM |
| seal_nbr | n/a | n/a | No | Populated with an empty value by SIM |
| carrier_code | n/a | n/a | No | Populated with an empty value by SIM |
| transshipment_nbr | n/a | n/a | No | Populated with an empty value by SIM |
| ASNOutDistro | * | * | * | * |
| comments | DO_CTL_INV | COMMENT_DESC | No | Not Yet Available |
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:ASNOutDistro |
| Tag Name | Table Name | Column Name | API Req | Description |
| distro_nbr | DO_CTL_INV | ID_ICD | Yes | Specifies the transfer or return number associated with the shipment/item/carton. |
| distro_doc_type | n/a | n/a | Yes | Specifiy the distro doc type for the transfer or return. 'T' - Transfer, 'C' - Customer Order, 'D' - distro, 'V'-Vendor |
| customer_order_nbr | n/a | n/a | No | Populated with empty value by SIM |
| consumer_direct | n/a | n/a | No | Populated with empty value by SIM |
| ASNOutCtn | * | * | * | * |
| comments | n/a | n/a | No | Not used by SIM |
| Application Name: Store Inventory Management |
Version 13.0.1 |
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 | n/a | n/a | No | Populated with empty value by SIM |
| 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.1 |
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 |