| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Acct Period Id | Account period identifier | Overhead Manufacturing Transactions.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114430 |
| Assembly Item Number | | Overhead Manufacturing Transactions.Assembly Item Number | ASSEMBLY_ITEM_NUMBER | ASSEMBLY_ITEM_NUMBER | 116534 |
| Autocharge Type | | Overhead Manufacturing Transactions.Autocharge Type | AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | 118634 |
| Basis | | Overhead Manufacturing Transactions.Basis | BASIS | BASIS | 119350 |
| Completion Transaction Id | Originating completion transaction in MTL_MATERIAL_TRANSACTIONS | Overhead Manufacturing Transactions.Completion Transaction Id | COMPLETION_TRANSACTION_ID | COMPLETION_TRANSACTION_ID | 122911 |
| Created By | Standard Who column. | Overhead Manufacturing Transactions.Created By | CREATED_BY | CREATED_BY | 124825 |
| Created Date | | Overhead Manufacturing Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125379 |
| Created Date - Day | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_DAY | 171191 |
| Created Date - Month | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_MONTH | 171345 |
| Created Date - Quarter | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_QUARTER | 171499 |
| Created Date - Year | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_YEAR | 171653 |
| Currency | The currency for an account balance. | Overhead Manufacturing Transactions.Currency | CURRENCY | CURRENCY | 126946 |
| Currency Conversion Date | The currency conversion date. | Overhead Manufacturing Transactions.Currency Conversion Date | CURRENCY_CONVERSION_DATE | CURRENCY_CONVERSION_DATE | 127100 |
| Currency Conversion Date - Day | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_DAY | 173972 |
| Currency Conversion Date - Month | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_MONTH | 173984 |
| Currency Conversion Date - Quarter | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_QUARTER | 173996 |
| Currency Conversion Date - Year | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_YEAR | 174008 |
| Currency Conversion Rate | The currency exchange rate. | Overhead Manufacturing Transactions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127111 |
| Currency Conversion Type | The type of currency exchange rate. | Overhead Manufacturing Transactions.Currency Conversion Type | CURRENCY_CONVERSION_TYPE | CURRENCY_CONVERSION_TYPE | 127180 |
| Department | Department code | Overhead Manufacturing Transactions.Department | DEPARTMENT | DEPARTMENT | 129129 |
| Department Id | Department identifier | Overhead Manufacturing Transactions.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129181 |
| Item | | Overhead Manufacturing Transactions.Item | ASSEMBLY_ITEM | ASSEMBLY_ITEM | 273903 |
| Line | Line name | Overhead Manufacturing Transactions.Line | LINE | LINE | 144576 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Overhead Manufacturing Transactions.Line Id | LINE_ID | LINE_ID | 144652 |
| Mfg Order Id | WIP line identifier | Overhead Manufacturing Transactions.Mfg Order Id | MFG_ORDER_ID | MFG_ORDER_ID | 147066 |
| Mfg Order Name | WIP job or repetitive assembly name or flow schedule reference code | Overhead Manufacturing Transactions.Mfg Order Name | MFG_ORDER_NAME | MFG_ORDER_NAME | 147077 |
| Move Transaction Id | Shop floor move identifier | Overhead Manufacturing Transactions.Move Transaction Id | MOVE_TRANSACTION_ID | MOVE_TRANSACTION_ID | 147477 |
| Operation Sequence Number | Operation sequence number within a routing | Overhead Manufacturing Transactions.Operation Sequence Number | OPERATION_SEQUENCE_NUMBER | OPERATION_SEQUENCE_NUMBER | 149670 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Overhead Manufacturing Transactions.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150169 |
| Organization Id | | Overhead Manufacturing Transactions.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150436 |
| Organization Name | | Overhead Manufacturing Transactions.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150733 |
| Period Name | The name of an accounting period. | Overhead Manufacturing Transactions.Period Name | PERIOD_NAME | PERIOD_NAME | 153134 |
| Primary Item Id | Inventory item identifier of the assembly the job or schedule creates | Overhead Manufacturing Transactions.Primary Item Id | PRIMARY_ITEM_ID | PRIMARY_ITEM_ID | 155534 |
| Primary Quantity | Quantity transacted expressed in the primary unit of measure | Overhead Manufacturing Transactions.Primary Quantity | PRIMARY_QUANTITY | PRIMARY_QUANTITY | 155561 |
| Primary UOM | Primary unit of measure | Overhead Manufacturing Transactions.Primary UOM | PRIMARY_UOM | PRIMARY_UOM | 155598 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Overhead Manufacturing Transactions.Project Id | PROJECT_ID | PROJECT_ID | 156478 |
| Project Name | User-defined name that uniquely identifies the project | Overhead Manufacturing Transactions.Project Name | PROJECT_NAME | PROJECT_NAME | 156568 |
| Project Number | | Overhead Manufacturing Transactions.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156649 |
| Reason | Reason name | Overhead Manufacturing Transactions.Reason | REASON | REASON | 157899 |
| Reason Id | Reason identifier | Overhead Manufacturing Transactions.Reason Id | REASON_ID | REASON_ID | 157955 |
| Source | Code of the source system that generated the transaction record (null if created by Oracle Work in Process) | Overhead Manufacturing Transactions.Source | SOURCE | SOURCE | 162317 |
| Source Line Id | Id for the source of external transaction records | Overhead Manufacturing Transactions.Source Line Id | SOURCE_LINE_ID | SOURCE_LINE_ID | 162444 |
| Standard Rate Flag | Whether or not the resource is charged at the standard rate | Overhead Manufacturing Transactions.Standard Rate Flag | STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | 162861 |
| Task Id | Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | Overhead Manufacturing Transactions.Task Id | TASK_ID | TASK_ID | 164601 |
| Task Name | User-defined short name of the task | Overhead Manufacturing Transactions.Task Name | TASK_NAME | TASK_NAME | 164642 |
| Task Number | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. | Overhead Manufacturing Transactions.Task Number | TASK_NUMBER | TASK_NUMBER | 164676 |
| Transaction Date | | Overhead Manufacturing Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165654 |
| Transaction Date - Day | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192347 |
| Transaction Date - Month | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192401 |
| Transaction Date - Quarter | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192455 |
| Transaction Date - Year | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192509 |
| Transaction Id | External payment/receipt identifier. | Overhead Manufacturing Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165703 |
| Transaction Quantity | | Overhead Manufacturing Transactions.Transaction Quantity | TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | 165776 |
| Transaction Reference | Transaction reference descriptive text | Overhead Manufacturing Transactions.Transaction Reference | TRANSACTION_REFERENCE | TRANSACTION_REFERENCE | 165808 |
| Transaction Type | Type of the external cash transaction, either payment or receipt. | Overhead Manufacturing Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 165847 |
| Transaction UOM | Unit of measure used in the transaction | Overhead Manufacturing Transactions.Transaction UOM | TRANSACTION_UOM | TRANSACTION_UOM | 165885 |
| Updated By | | Overhead Manufacturing Transactions.Updated By | UPDATED_BY | UPDATED_BY | 166524 |
| Updated Date | | Overhead Manufacturing Transactions.Updated Date | UPDATED_DATE | UPDATED_DATE | 166536 |
| Updated Date - Day | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_DAY | 192699 |
| Updated Date - Month | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_MONTH | 192715 |
| Updated Date - Quarter | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_QUARTER | 192731 |
| Updated Date - Year | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_YEAR | 192747 |
| Acct Period Id | Account period identifier | Overhead Manufacturing Transactions.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114430 |
| Assembly Item Number | | Overhead Manufacturing Transactions.Assembly Item Number | ASSEMBLY_ITEM_NUMBER | ASSEMBLY_ITEM_NUMBER | 116534 |
| Autocharge Type | | Overhead Manufacturing Transactions.Autocharge Type | AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | 118634 |
| Basis | | Overhead Manufacturing Transactions.Basis | BASIS | BASIS | 119350 |
| Completion Transaction Id | Originating completion transaction in MTL_MATERIAL_TRANSACTIONS | Overhead Manufacturing Transactions.Completion Transaction Id | COMPLETION_TRANSACTION_ID | COMPLETION_TRANSACTION_ID | 122911 |
| Created By | Standard Who column. | Overhead Manufacturing Transactions.Created By | CREATED_BY | CREATED_BY | 124825 |
| Created Date | | Overhead Manufacturing Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125379 |
| Created Date - Day | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_DAY | 171191 |
| Created Date - Month | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_MONTH | 171345 |
| Created Date - Quarter | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_QUARTER | 171499 |
| Created Date - Year | | Overhead Manufacturing Transactions.Created Date | | CREATED_DATE_YEAR | 171653 |
| Currency | The currency for an account balance. | Overhead Manufacturing Transactions.Currency | CURRENCY | CURRENCY | 126946 |
| Currency Conversion Date | The currency conversion date. | Overhead Manufacturing Transactions.Currency Conversion Date | CURRENCY_CONVERSION_DATE | CURRENCY_CONVERSION_DATE | 127100 |
| Currency Conversion Date - Day | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_DAY | 173972 |
| Currency Conversion Date - Month | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_MONTH | 173984 |
| Currency Conversion Date - Quarter | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_QUARTER | 173996 |
| Currency Conversion Date - Year | | Overhead Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_YEAR | 174008 |
| Currency Conversion Rate | The currency exchange rate. | Overhead Manufacturing Transactions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127111 |
| Currency Conversion Type | The type of currency exchange rate. | Overhead Manufacturing Transactions.Currency Conversion Type | CURRENCY_CONVERSION_TYPE | CURRENCY_CONVERSION_TYPE | 127180 |
| Department | Department code | Overhead Manufacturing Transactions.Department | DEPARTMENT | DEPARTMENT | 129129 |
| Department Id | Department identifier | Overhead Manufacturing Transactions.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129181 |
| Item | | Overhead Manufacturing Transactions.Item | ASSEMBLY_ITEM | ASSEMBLY_ITEM | 273903 |
| Line | Line name | Overhead Manufacturing Transactions.Line | LINE | LINE | 144576 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Overhead Manufacturing Transactions.Line Id | LINE_ID | LINE_ID | 144652 |
| Mfg Order Id | WIP line identifier | Overhead Manufacturing Transactions.Mfg Order Id | MFG_ORDER_ID | MFG_ORDER_ID | 147066 |
| Mfg Order Name | WIP job or repetitive assembly name or flow schedule reference code | Overhead Manufacturing Transactions.Mfg Order Name | MFG_ORDER_NAME | MFG_ORDER_NAME | 147077 |
| Move Transaction Id | Shop floor move identifier | Overhead Manufacturing Transactions.Move Transaction Id | MOVE_TRANSACTION_ID | MOVE_TRANSACTION_ID | 147477 |
| Operation Sequence Number | Operation sequence number within a routing | Overhead Manufacturing Transactions.Operation Sequence Number | OPERATION_SEQUENCE_NUMBER | OPERATION_SEQUENCE_NUMBER | 149670 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Overhead Manufacturing Transactions.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150169 |
| Organization Id | | Overhead Manufacturing Transactions.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150436 |
| Organization Name | | Overhead Manufacturing Transactions.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150733 |
| Period Name | The name of an accounting period. | Overhead Manufacturing Transactions.Period Name | PERIOD_NAME | PERIOD_NAME | 153134 |
| Primary Item Id | Inventory item identifier of the assembly the job or schedule creates | Overhead Manufacturing Transactions.Primary Item Id | PRIMARY_ITEM_ID | PRIMARY_ITEM_ID | 155534 |
| Primary Quantity | Quantity transacted expressed in the primary unit of measure | Overhead Manufacturing Transactions.Primary Quantity | PRIMARY_QUANTITY | PRIMARY_QUANTITY | 155561 |
| Primary UOM | Primary unit of measure | Overhead Manufacturing Transactions.Primary UOM | PRIMARY_UOM | PRIMARY_UOM | 155598 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Overhead Manufacturing Transactions.Project Id | PROJECT_ID | PROJECT_ID | 156478 |
| Project Name | User-defined name that uniquely identifies the project | Overhead Manufacturing Transactions.Project Name | PROJECT_NAME | PROJECT_NAME | 156568 |
| Project Number | | Overhead Manufacturing Transactions.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156649 |
| Reason | Reason name | Overhead Manufacturing Transactions.Reason | REASON | REASON | 157899 |
| Reason Id | Reason identifier | Overhead Manufacturing Transactions.Reason Id | REASON_ID | REASON_ID | 157955 |
| Source | Code of the source system that generated the transaction record (null if created by Oracle Work in Process) | Overhead Manufacturing Transactions.Source | SOURCE | SOURCE | 162317 |
| Source Line Id | Id for the source of external transaction records | Overhead Manufacturing Transactions.Source Line Id | SOURCE_LINE_ID | SOURCE_LINE_ID | 162444 |
| Standard Rate Flag | Whether or not the resource is charged at the standard rate | Overhead Manufacturing Transactions.Standard Rate Flag | STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | 162861 |
| Task Id | Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task. | Overhead Manufacturing Transactions.Task Id | TASK_ID | TASK_ID | 164601 |
| Task Name | User-defined short name of the task | Overhead Manufacturing Transactions.Task Name | TASK_NAME | TASK_NAME | 164642 |
| Task Number | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. | Overhead Manufacturing Transactions.Task Number | TASK_NUMBER | TASK_NUMBER | 164676 |
| Transaction Date | | Overhead Manufacturing Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165654 |
| Transaction Date - Day | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192347 |
| Transaction Date - Month | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192401 |
| Transaction Date - Quarter | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192455 |
| Transaction Date - Year | | Overhead Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192509 |
| Transaction Id | External payment/receipt identifier. | Overhead Manufacturing Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165703 |
| Transaction Quantity | | Overhead Manufacturing Transactions.Transaction Quantity | TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | 165776 |
| Transaction Reference | Transaction reference descriptive text | Overhead Manufacturing Transactions.Transaction Reference | TRANSACTION_REFERENCE | TRANSACTION_REFERENCE | 165808 |
| Transaction Type | Type of the external cash transaction, either payment or receipt. | Overhead Manufacturing Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 165847 |
| Transaction UOM | Unit of measure used in the transaction | Overhead Manufacturing Transactions.Transaction UOM | TRANSACTION_UOM | TRANSACTION_UOM | 165885 |
| Updated By | | Overhead Manufacturing Transactions.Updated By | UPDATED_BY | UPDATED_BY | 166524 |
| Updated Date | | Overhead Manufacturing Transactions.Updated Date | UPDATED_DATE | UPDATED_DATE | 166536 |
| Updated Date - Day | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_DAY | 192699 |
| Updated Date - Month | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_MONTH | 192715 |
| Updated Date - Quarter | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_QUARTER | 192731 |
| Updated Date - Year | | Overhead Manufacturing Transactions.Updated Date | | UPDATED_DATE_YEAR | 192747 |