My Oracle Support Banner

Values of TRAN_TYPE_ID Field In SIM RK_INV_ADJUSTMENT Table (Doc ID 1456774.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.1 and later
Information in this document applies to any platform.

Goal

The tran_type_id has the following mappings, however there's no information in the available documentation explaining how records are inserted in the RK_INV_ADJUSTMENT table with different tran_type_ids.


For example, tran type ids 2, 3 and 4 are related to creating, dispatching and receiving transfer as listed below but creating, dispatching and receiving a transfer do not result in creating records in RK_INV_ADJUSTMENT table with tran_type_id = 2, 3 or 4.

Tran_type_id mapping:


0 - Warehouse Delivery Receipt,
1 - Direct Delivery Receipt,
2 - Create Transfer,
3 - Dispatch Transfer,
4 - Receive Transfer,
5 - Receipt Adjustment,
6 - Create Return,
7 - Dispatch Return,
8 - Inventory Adjustment,
9 - Stock Count,
10 - Stock Re-Count,
11 - Stock Count Authorized,
12 - Manual,
13 - POS Sale,
14 - POS Return,
15 - POS Sale Void,
16 - POS Return Void,
17 - UIN Web Service,
18 - Customer Order
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.