Misc (Sub Inventory) Inventory Transfer |
This transaction is triggered when material has been issued from a Kanban card to another location code (or locator).
In Ultriva there are two types of transactions that relates to adhoc inventory movement.
Issues
MoveInventory
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
ULTRIVA field | Oracle Lookup | Lookup Field | Field/Value | Oracle Field |
|---|---|---|---|---|
NA | NA | NA | mtl_material_transactions_s.NEXTVAL | TRANSACTION_INTERFACE_ID |
UNIT_OF_MEASURE | mtl_units_of_measure | UOM_CODE = TRIM(p_unit_of_measure) OR unit_of_measure = TRIM(p_unit_of_measure) | unit_of_measure | TRANSACTION_UOM |
ACTION_DATE | NA | NA | NA | TRANSACTION_DATE |
NA | NA | NA | 'UEKXFER' | SOURCE_CODE |
NA | NA | NA | -1 | SOURCE_LINE_ID |
NA | NA | NA | -1 | SOURCE_HEADER_ID |
NA | NA | NA | 1 | PROCESS_FLAG |
NA | NA | NA | 3 | TRANSACTION_MODE |
NA | NA | NA | 2 | LOCK_FLAG |
FROM_ISSUE_LOCATION | mtl_item_locations_kfv | organization_id = p_ship_to_org_id AND subinventory_code = p_subinventory AND nvl(disable_date,sysdate+1) > sysdate AND concatenated_segments = p_locator | inventory_location_id | LOCATOR_ID |
NA | NA | NA | SYSDATE | LAST_UPDATE_DATE |
TRANSACTION_BY | fnd_user | upper(user_name) = upper(TRANSACTION_BY) | user_id | LAST_UPDATED_BY |
NA | NA | NA | SYSDATE | CREATION_DATE |
TRANSACTION_BY | fnd_user | upper(user_name) = upper(TRANSACTION_BY) | user_id | CREATED_BY |
ITEM_NUM | mtl_system_items_kfv | concatenated_segments = TRIM(p_item_num) AND organization_id = p_ship_to_organization_id | NA | INVENTORY_ITEM_ID |
FROM_SUBINVENTORY | NA | NA | NA | SUBINVENTORY_CODE |
FROM_BUSINESS_CODE | NA | NA | NA | ORGANIZATION_ID |
Quantity | NA | NA | NA | TRANSACTION_QUANTITY |
Quantity | NA | NA | NA | PRIMARY_QUANTITY |
SUB INVENTORY | mtl_transaction_types | UPPER(transaction_type_name) = UPPER(p_transaction_type_name) | transaction_type_id | TRANSACTION_TYPE_ID |
ISSUED_TO_SUBINVENTORY | NA | NA | NA | TRANSFER_SUBINVENTORY |
ISSUED_ LOCATION_CODE | mtl_item_locations_kfv | organization_id = p_ship_to_org_id AND subinventory_code = p_subinventory AND nvl(disable_date,sysdate+1) > sysdate AND concatenated_segments = p_locator | inventory_location_id | TRANSFER_LOCATOR |
Ultriva Staging Table's Primary Key field | NA | NA | NA | ATTRIBUTE1 |
KANBAN_RELEASE_ID | NA | NA | NA | ATTRIBUTE2 |
KANBAN_RELEASE_ID | NA | NA | NA | ATTRIBUTE3 |
ITEM_REVISION | NA | NA | NA | REVISION |
KANBAN_RELEASE_ID | NA | NA | NA | TRANSACTION_REFERENCE |
Ultriva Staging Table's Primary Key field | NA | NA | NA | SHIPMENT_NUMBER |