Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAdjustDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:InvAdjustDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For InvAdjustDesc
Table Name Column Name API Type Column Length API Required API Description
dc_dest_id varchar210 1 1 Description is not available. DO_CTL_INV ID_STR_RT null null Yes Contains the location where the inventory adjustment occurred
InvAdjustDtl * 1 unbounded Description is not available.
ExtOfInvAdjustDesc:ExtOfInvAdjustDesc * 0 1 Provide an extension hook to customize InvAdjustDesc. NA NA NA NA NA NA

XML-Schema Name:InvAdjustDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For InvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description
item_id varchar225 1 1 Description is not available. TR_LTM_ICD_MR ID_ITM null null Yes Identifies the item on the inventory adjustment
adjustment_reason_code number4 0 1 Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types. TR_LTM_ICD_MR RC_CHN null null No Contains the reason for inventory adjustment. This field will only have a value for saleable inventory types.
unit_qty number12_4 1 1 Description is not available. TR_LTM_ICD_MR QU_ITM null null Yes Contains the quantity the inventory was adjusted by.
transshipment_nbr varchar230 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
from_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. n/a n/a null null No Used to determine if the adjustment quantity is negative or positive.
to_disposition varchar24 0 1 Used to fetch the inv_status. Also used to determine if the adjustment quantity is negative or positive. n/a n/a null null No Used to determine if the adjustment quantity is negative or positive.
from_trouble_code varchar29 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
to_trouble_code varchar29 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
from_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
to_wip_code varchar29 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
transaction_code number4 0 1 Description is not available. n/a n/a null null Yes Populated with 0 by SIM
user_id varchar230 1 1 Description is not available. n/a n/a null null Yes Contains the user id for the user making the inventory adjustme
create_date xs:dateTime 1 1 Description is not available. DO_CTL_INV TS_CRT_ICD null null Yes Contains the date on which the inventory adjustment occurred
po_nbr varchar210 0 1 Either a PO or transfer associated to the inventory adjustment based on the doc_type. n/a n/a null null No Populated with an empty value by SIM
doc_type varchar21 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
aux_reason_code varchar24 0 1 Description is not available. n/a n/a null null No Populated with an empty value by SIM
weight number12_4 0 1 Description is not available. n/a n/a null null No Not used by SIM
weight_uom varchar24 0 1 Description is not available. n/a n/a null null No Not used by SIM
ExtOfInvAdjustDesc:ExtOfInvAdjustDtl * 0 1 Provide an extension hook to customize InvAdjustDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfInvAdjustDtl Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfInvAdjustDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfInvAdjustDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfInvAdjustDesc
Table Name Column Name API Type Column Length API Required API Description