FND Design Data [Home] [Help]

Table: WMS_DISPATCHED_TASKS_HISTORY

Product: WMS - Warehouse Management
Description: History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed
Implementation/DBA Data: TableWMS.WMS_DISPATCHED_TASKS_HISTORY
Primary Key: WMS_DISPATCHED_TASKS_HIST_PK
  1. ColumnTASK_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TableMTL_MATERIAL_TRANSACTIONS WMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_ID
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TableMTL_SERIAL_NUMBERS WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_INSTANCE
WMS_DISPATCHED_TASKS_HISTORY.EQUIPMENT_ID
WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TableMTL_PARAMETERS WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TableBOM_RESOURCES WMS_DISPATCHED_TASKS_HISTORY.PERSON_RESOURCE_ID
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TableBOM_RESOURCES WMS_DISPATCHED_TASKS_HISTORY.MACHINE_RESOURCE_ID
WMS_DISPATCHED_TASKS_HISTORY FK Joins to TablePER_ALL_PEOPLE_F WMS_DISPATCHED_TASKS_HISTORY.PERSON_ID
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_START_DATE
WMS_DISPATCHED_TASKS_HISTORY.EFFECTIVE_END_DATE