| XSD Element Name | 
                          XSD Element Data Type | 
                          XSD Min Occurs | 
                          XSD Max Occurs | 
                          XSD Element Description | 
                          Mapping for StrItmRef in SIM application. | 
                         
                        
                          | SIM's Table Name | 
                          SIM's Column Name | 
                          Integration API(RIB or/and RSB or/and RSL) | 
                          SIM's Column Length | 
                          Is Column Required in SIM's API? | 
                          SIM's API Description | 
                         
                        
                          | item_id | 
                          varchar225 | 
                          1 | 
                          1 | 
                          Sku number | 
                          ITEM | 
                          ITEM_ID | 
                          VARCHAR2 | 
                          25 | 
                          Yes | 
                          the retailers sku or unique item identifier for items sold or returned. this field is required by sim. | 
                         
                        
                          | store_id | 
                          number10 | 
                          1 | 
                          1 | 
                          Store identifier. | 
                          STORE_ITEM | 
                          STORE_ID | 
                          NUMBER | 
                          10,0 | 
                          Yes | 
                          the unique identifier of the location that is holding the item. | 
                         
                      
                    
                   
                 |