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     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.    
SOURCE_DOCUMENT_CODE VARCHAR2 32     This column stores the source document code for the receiving transactions. Maps to lookup_type is RCV_SOURCE_DOCUMENT_TYPE.    
TRANSACTION_TYPE VARCHAR2 32     Receiving transaction type. Maps to lookup_type is RCV_TRANSACTION_TYPE.    
TRANSACTION_DATE DATE       This column stores the transaction date for the receiving transactions.    
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.    
LOCATOR_ID NUMBER 38 0   This column stores the destination locator unique identifier for the receiving transaction.    
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.    
DESTINATION_TYPE_CODE VARCHAR2 32     This column stores the destination type code when the receiving transaction is created.    
LOCATION_ID NUMBER 38 0   This column stores the deliver or receive to location unique identifier.    
DELIVER_TO_PERSON_ID NUMBER 38 0   This column stores the deliver to person, or requester, unique identifier.    
EMPLOYEE_ID NUMBER 38 0   This column stores the Unique identifier for the person who created the receiving transaction.    
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.    
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.    
QUANTITY NUMBER       This column stores the destination subinventory name for deliver transaction type.    
UOM_CODE VARCHAR2 16     This column stores the unit of measure code for the receiving transaction.    
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.    
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.    
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.    
PROJECT_ID NUMBER 38 0   Identifier of the project corresponding to the source document and is propagated to the inventory transactions.    
TASK_ID NUMBER 38 0   Identifier of the task corresponding to the source document and is propagated to the inventory transactions.    
SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the item locator.    
INSPECTION_STATUS_CODE VARCHAR2 32     This column stores the inspection status code. Valid Values are NOT INSPECTED, ACCEPTED, REJECTED.    
REASON_ID NUMBER 38 0   This column stores the inventory transaction reason unique identifier.    
COUNTRY_OF_ORIGIN_CODE VARCHAR2 16     This column stores the code for the country of manufacture.    

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