# DW_RCV_TRANSACTIONS_CF

This is table stores information about all transactions that have been performed once the goods have been received. This will store data for all receipt sources

## Details

Module: Purchasing

## Key Columns

TRANSACTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
TRANSACTION_ID | NUMBER | 38 | 0 | True | This column stores the unique identifier for the current receiving transaction row. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
SHIPMENT_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the receiving shipment receiving receipt header unique identifier |  |
RECEIPT_NUMBER | VARCHAR2 | 32 |  |  | This column stores the receipt number for the receiving shipment receipt header row. |  |
SHIPMENT_LINE_ID | NUMBER | 38 | 0 |  | This column stores the receiving shipment receiving receipt line unique identifier |  |
LINE_NUM | NUMBER | 38 | 0 |  | This column stores the number corresponding to the shipment line. |  |
ITEM_ID | NUMBER | 38 | 0 |  | This column stores the inventory item unique identifier of the document for which the receiving shipment receipt line is created. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_DESCRIPTION | VARCHAR2 | 256 |  |  | This column stores the purchase order line item description for PO receipts. For other documents, it stores the inventory item description. |  |
ITEM_REVISION | VARCHAR2 | 32 |  |  | This column stores the revision number of the inventory item. |  |
SOURCE_DOCUMENT_CODE | VARCHAR2 | 32 |  |  | This column stores the source document code for the receiving transactions. | DW_RCV_SOURCE_DOCUMENT_TYPE_D_TL | CODE
TRANSACTION_TYPE | VARCHAR2 | 32 |  |  | This column stores Receiving transaction type. | DW_RCV_TRANSACTION_TYPE_D_TL | RCV_TRANSACTION_TYPE_CODE
TRANSACTION_DATE | DATE |  |  |  | This column stores the transaction date for the receiving transactions. | DW_DAY_D | CALENDAR_DATE
ORGANIZATION_ID | NUMBER | 38 | 0 |  | This column stores Receiving organization unique identifier where the receiving transaction is created. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
SUBINVENTORY | VARCHAR2 | 16 |  |  | This column stores the destination subinventory name for the receiving transaction.#2 | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
LOCATOR_ID | NUMBER | 38 | 0 |  | This column stores the destination locator unique identifier for the receiving transaction. | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | This column stores the destination type code when the receiving transaction is created. | DW_RCV_DESTINATION_TYPE_D_TL | CODE
LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the deliver or receive to location unique identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
DELIVER_TO_PERSON_ID | NUMBER | 38 | 0 |  | This column stores the deliver to person, or requester, unique identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
EMPLOYEE_ID | NUMBER | 38 | 0 |  | This column stores the Unique identifier for the person who created the receiving transaction. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
QUANTITY | NUMBER |  |  |  | This column stores the receiving Transaction quantity |  |
UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the unit of measure code for the receiving transaction. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PRIMARY_QUANTITY | NUMBER |  |  |  | Receiving Transaction quantity in terms of the item's primary unit of measure. |  |
PRIMARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the primary unit of measure code of the item in the receiving organization. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SECONDARY_QUANTITY | NUMBER |  |  |  | This column stores the receiving transaction quantity in the item's secondary unit of measure. |  |
SECONDARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the secondary unit of measure code of the inventory item. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PARENT_TRANSACTION_ID | NUMBER | 38 | 0 |  | This column stores the unique identifier of the parent receiving transaction. |  |
DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the deliver to location unique identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project corresponding to the source document and is propagated to the inventory transactions. | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task corresponding to the source document and is propagated to the inventory transactions. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 |  | This identifies the item locator. | DW_WORKER_LOCATION_D | LOCATION_ID
INSPECTION_STATUS_CODE | VARCHAR2 | 32 |  |  | This column stores the inspection status code. | DW_RCV_INSPECTION_STATUS_D_TL | RCV_INSPECTION_STATUS_CODE
REASON_ID | NUMBER | 38 | 0 |  | This column stores the inventory transaction reason unique identifier. | DW_INV_TRANSACTION_REASONS_D_TL | REASON_ID
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | This column stores the code for the country of manufacture. | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE
AMOUNT | NUMBER |  |  |  | This column stores amounts for fixed price lines. |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | This column stores currency code for a transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE

## Notes

#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D.#2 In these cases in addition to the Subinventory Name column, ORGANIZATION_ID column should also be used for join with DW_INV_SUBINVENTORY_D.

Copyright © 2019, 2025, Oracle and/or its affiliates.