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, 2024, Oracle and/or its affiliates.