DW_INV_MTL_TXNS_LOT_SERIAL_CF

This table stores every material transaction performed in inventory

Details

Module: Inventory Management

Key Columns

TRANSACTION_ID, SERIAL_NUMBER, 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 This column is for Oracle Internal use only. 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