DW_INV_MTL_TXNS_LOT_SERIAL_CF

This table stores every material transaction performed in inventory

Details

Module: Inventory Management

Key Columns

SERIAL_NUMBER, TRANSACTION_ID, LOT_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRANSACTION_ID NUMBER 38 0 True Primary key of the inventory transaction.    
LOT_NUMBER VARCHAR2 128   True This number identifies an inventory lot.    
SERIAL_NUMBER VARCHAR2 128   True This stores the item unit number    
SOURCE_RECORD_ID VARCHAR2 512     System Generated    
ORGANIZATION_ID NUMBER 38 0   This identifies the inventory organization. DW_INTERNAL_ORG_D ORGANIZATION_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID NUMBER 38 0   Profit Center Business Unit Id of the Inventory Organization. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
BUSINESS_UNIT_ID NUMBER 38 0   This identifies the business unit DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEGAL_ENTITY_ID NUMBER 38 0   This identifies the legal entity for the business unit DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PRIMARY_LEDGER_ID NUMBER 38 0   Primary ledger of the organization DW_LEDGER_D LEDGER_ID
INVENTORY_ITEM_ID NUMBER 38 0   This identifies the inventory item. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
SUBINVENTORY_CODE VARCHAR2 16     Transaction secondary inventory DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME
SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the location of the subinventory DW_WORKER_LOCATION_D LOCATION_ID
LOCATOR_ID NUMBER 38 0   This identifies the item locator. DW_INV_LOCATOR_D INVENTORY_LOCATION_ID
TRANSACTION_UOM VARCHAR2 16     This is the user preferred unit of measure for this transaction. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
SECONDARY_UOM_CODE VARCHAR2 16     Secondary unit of measure that may have been used to do the material transaction DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CREATION_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
CREATION_DATE DATE       Who column: indicates the date and time of the creation of the row. DW_DAY_D CALENDAR_DATE
LAST_UPDATE_TIMESTAMP TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATE_DATE DATE       Who column: indicates the date and time of the last update of the row. DW_DAY_D CALENDAR_DATE
TRANSACTION_SET_ID NUMBER 38 0   This identifies the transaction group.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row. DW_USER_D USERNAME
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who created the row. DW_USER_D USERNAME
TRANSACTION_TYPE_ID NUMBER 38 0   Identifies the transaction type. DW_INV_TRANSACTION_TYPES_TL TRANSACTION_TYPE_ID
TRANSACTION_ACTION_ID NUMBER 38 0   Identifies the transaction action. DW_INV_TRNX_ACTION_LKP_TL INV_TRANSACTION_ACTION_CODE
REASON_ID NUMBER 38 0   This identifies the transaction reason.    
TRANSACTION_SOURCE_TYPE_ID NUMBER 38 0   Transaction source type identifier DW_INV_TXN_SOURCE_TYPES_TL TRANSACTION_SOURCE_TYPE_ID
ERROR_EXPLANATION VARCHAR2 256     This is the error explanation text.    
TRANSFER_LEGAL_ENTITY_ID NUMBER 38 0   This identifies the legal entity for the transferring business unit DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
TRANSFER_BU_ID NUMBER 38 0   This identifies the transferring business unit DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
TRANSFER_ORGANIZATION_ID NUMBER 38 0   Transfer opposing organization id DW_INTERNAL_ORG_D ORGANIZATION_ID
TRANSFER_SUBINVENTORY VARCHAR2 16     Transfer transaction opposing subinventory DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME
XFR_SUBINVENTORY_LOCATION_ID NUMBER 38 0   This identifies the location of the transferring subinventory DW_WORKER_LOCATION_D LOCATION_ID
TRANSFER_LOCATOR_ID NUMBER 38 0   Transfer transaction opposing locator id DW_INV_LOCATOR_D INVENTORY_LOCATION_ID
OWNING_TP_TYPE NUMBER 38 0   Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. DW_INV_OWNING_TYPE_LKP_TL INV_OWNING_TYPE_CODE
OWNING_ORGANIZATION_ID NUMBER 38 0   This identifies the owning organization or entity. DW_INTERNAL_ORG_D ORGANIZATION_ID
OWNING_SUPPLIER_SITE_ID NUMBER 38 0   This identifies the owning supplier site identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
OWNING_PARTY_ID NUMBER 38 0   Vendor organization Identifier DW_PARTY_D PARTY_ID
TRANSFER_OWNING_TP_TYPE NUMBER 38 0   Transfer Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. DW_INV_OWNING_TYPE_LKP_TL INV_OWNING_TYPE_CODE
XFR_OWNING_ORGANIZATION_ID NUMBER 38 0   Transfer owning organization identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
XFR_OWNING_SUPPLIER_SITE_ID NUMBER 38 0   Transfer owning supplier site identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
XFR_OWNING_PARTY_ID NUMBER 38 0   Transfer vendor organization Identifier DW_PARTY_D PARTY_ID
TRANSACTION_TIMESTAMP TIMESTAMP       This is the date when the transaction was processed.    
TRANSACTION_DATE DATE       This is the date when the transaction was processed. DW_DAY_D CALENDAR_DATE
CONSUMPTION_LINE_ID NUMBER 38 0   This is a foreign key to INV_CONS_ADVICE_LINES.CONSUMPTION_LINE_ID    
PARENT_TRANSACTION_ID NUMBER 38 0   This identifies the parent transaction in this table.    
PRIMARY_QUANTITY NUMBER       Transaction quantity in terms of primary uom of the item    
SECONDARY_TRANSACTION_QUANTITY NUMBER       This is the secondary transaction quantity.    
TRANSACTION_QUANTITY NUMBER       This is the transaction quantity in the user's preferred unit of measure.    
DEPARTMENT_ID NUMBER 38 0   This identifies the department name of the user DW_DEPARTMENT_D DEPARTMENT_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Name of the accounting calendar. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. Examples are Weekly, Monthly, Quarterly. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
LOT_PRIMARY_QUANTITY NUMBER       Transacted Quantity, in the item's primary unit of measure    
LOT_SEC_TRANSACTION_QUANTITY NUMBER       This is the secondary transaction quantity.    
LOT_TRANSACTION_QUANTITY NUMBER       Transaction quantity, in the user's current unit of measure    
DETAILED_PRIMARY_QUANTITY NUMBER       Derived transaction quantity for aggregation at lot/serial level    
SOURCE_LINE NUMBER 38 0   User entered source line identifier for outside transactions    
PJC_PROJECT_ID NUMBER 38 0   Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0   Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0   Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE DATE       Date on which a project-related transaction is incurred DW_DAY_D CALENDAR_DATE
PJC_ORGANIZATION_ID NUMBER 38 0   Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID

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