| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Acct Period Id | Accounting period identifier | Manufacturing Transactions.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114428 |
| Activity | The activity performed in the operation. | Manufacturing Transactions.Activity | ACTIVITY | ACTIVITY | 114630 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Transactions.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114726 |
| Actual Resource Rate | Actual rate of resource | Manufacturing Transactions.Actual Resource Rate | ACTUAL_RESOURCE_RATE | ACTUAL_RESOURCE_RATE | 114905 |
| Assembly Item Number | | Manufacturing Transactions.Assembly Item Number | ASSEMBLY_ITEM_NUMBER | ASSEMBLY_ITEM_NUMBER | 116532 |
| Autocharge Type | | Manufacturing Transactions.Autocharge Type | AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | 118632 |
| Basis | | Manufacturing Transactions.Basis | BASIS | BASIS | 119348 |
| Completion Transaction Id | Originating completion transaction in MTL_MATERIAL_TRANSACTIONS | Manufacturing Transactions.Completion Transaction Id | COMPLETION_TRANSACTION_ID | COMPLETION_TRANSACTION_ID | 122909 |
| Cost Update Id | Identifier of the cost update process that updated the record | Manufacturing Transactions.Cost Update Id | COST_UPDATE_ID | COST_UPDATE_ID | 123799 |
| Created By | Standard Who column. | Manufacturing Transactions.Created By | CREATED_BY | CREATED_BY | 124823 |
| Created Date | | Manufacturing Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125378 |
| Created Date - Day | | Manufacturing Transactions.Created Date | | CREATED_DATE_DAY | 171189 |
| Created Date - Month | | Manufacturing Transactions.Created Date | | CREATED_DATE_MONTH | 171343 |
| Created Date - Quarter | | Manufacturing Transactions.Created Date | | CREATED_DATE_QUARTER | 171497 |
| Created Date - Year | | Manufacturing Transactions.Created Date | | CREATED_DATE_YEAR | 171651 |
| Currency | The currency for an account balance. | Manufacturing Transactions.Currency | CURRENCY | CURRENCY | 126944 |
| Currency Actual Resource Rate | Actual resource rate converted for the currency code | Manufacturing Transactions.Currency Actual Resource Rate | CURRENCY_ACTUAL_RESOURCE_RATE | CURRENCY_ACTUAL_RESOURCE_RATE | 126960 |
| Currency Conversion Date | The currency conversion date. | Manufacturing Transactions.Currency Conversion Date | CURRENCY_CONVERSION_DATE | CURRENCY_CONVERSION_DATE | 127098 |
| Currency Conversion Date - Day | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_DAY | 173968 |
| Currency Conversion Date - Month | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_MONTH | 173980 |
| Currency Conversion Date - Quarter | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_QUARTER | 173992 |
| Currency Conversion Date - Year | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_YEAR | 174004 |
| Currency Conversion Rate | The currency exchange rate. | Manufacturing Transactions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127109 |
| Currency Conversion Type | The type of currency exchange rate. | Manufacturing Transactions.Currency Conversion Type | CURRENCY_CONVERSION_TYPE | CURRENCY_CONVERSION_TYPE | 127178 |
| Department | Department code | Manufacturing Transactions.Department | DEPARTMENT | DEPARTMENT | 129127 |
| Department Id | Department identifier | Manufacturing Transactions.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129179 |
| Employee Id | Employee identifier | Manufacturing Transactions.Employee Id | EMPLOYEE_ID | EMPLOYEE_ID | 131881 |
| Employee Name | Empolyee name | Manufacturing Transactions.Employee Name | EMPLOYEE_NAME | EMPLOYEE_NAME | 131889 |
| Item | | Manufacturing Transactions.Item | ASSEMBLY_ITEM | ASSEMBLY_ITEM | 273899 |
| Item 1 | | Manufacturing Transactions.Item 1 | PURCHASED_ITEM | PURCHASED_ITEM | 273900 |
| Line | Line name | Manufacturing Transactions.Line | LINE | LINE | 144574 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Manufacturing Transactions.Line Id | LINE_ID | LINE_ID | 144650 |
| Mfg Order Id | WIP job or repetitive assembly identifier | Manufacturing Transactions.Mfg Order Id | MFG_ORDER_ID | MFG_ORDER_ID | 147064 |
| Mfg Order Name | WIP job or repetitive assembly name or flow schedule reference code | Manufacturing Transactions.Mfg Order Name | MFG_ORDER_NAME | MFG_ORDER_NAME | 147075 |
| Move Transaction Id | Move transaction identifier | Manufacturing Transactions.Move Transaction Id | MOVE_TRANSACTION_ID | MOVE_TRANSACTION_ID | 147475 |
| Operation Sequence Number | Operation sequence number within a routing | Manufacturing Transactions.Operation Sequence Number | OPERATION_SEQUENCE_NUMBER | OPERATION_SEQUENCE_NUMBER | 149669 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Transactions.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150167 |
| Organization Id | | Manufacturing Transactions.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150434 |
| Organization Name | | Manufacturing Transactions.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150731 |
| PO Header Id | Purchase order header identifier | Manufacturing Transactions.PO Header Id | PO_HEADER_ID | PO_HEADER_ID | 155033 |
| PO Line | Line number | Manufacturing Transactions.PO Line | PO_LINE | PO_LINE | 155038 |
| PO Line Id | Purchase order line identifier | Manufacturing Transactions.PO Line Id | PO_LINE_ID | PO_LINE_ID | 155043 |
| PO Number | Document number | Manufacturing Transactions.PO Number | PO_NUMBER | PO_NUMBER | 155084 |
| PO Operating Unit Name | Name of the organization | Manufacturing Transactions.PO Operating Unit Name | PO_OPERATING_UNIT_NAME | PO_OPERATING_UNIT_NAME | 155088 |
| PO Type | Type of the document | Manufacturing Transactions.PO Type | PO_TYPE | PO_TYPE | 155114 |
| Period Name | The name of an accounting period. | Manufacturing Transactions.Period Name | PERIOD_NAME | PERIOD_NAME | 153132 |
| Primary Item Id | Inventory item identifier of the assembly the job or schedule creates | Manufacturing Transactions.Primary Item Id | PRIMARY_ITEM_ID | PRIMARY_ITEM_ID | 155532 |
| Primary Quantity | Quantity transacted expressed in the primary unit of measure | Manufacturing Transactions.Primary Quantity | PRIMARY_QUANTITY | PRIMARY_QUANTITY | 155559 |
| Primary UOM | Primary unit of measure | Manufacturing Transactions.Primary UOM | PRIMARY_UOM | PRIMARY_UOM | 155596 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Manufacturing Transactions.Project Id | PROJECT_ID | PROJECT_ID | 156476 |
| Project Name | User-defined name that uniquely identifies the project | Manufacturing Transactions.Project Name | PROJECT_NAME | PROJECT_NAME | 156566 |
| Project Number | | Manufacturing Transactions.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156647 |
| Purchased Item Number | | Manufacturing Transactions.Purchased Item Number | PURCHASED_ITEM_NUMBER | PURCHASED_ITEM_NUMBER | 157037 |
| Reason | Reason name | Manufacturing Transactions.Reason | REASON | REASON | 157897 |
| Reason Id | Reason identifier | Manufacturing Transactions.Reason Id | REASON_ID | REASON_ID | 157953 |
| Receiving Transaction Id | Receiving transaction identifier | Manufacturing Transactions.Receiving Transaction Id | RCV_TRANSACTION_ID | RCV_TRANSACTION_ID | 157756 |
| Resource Id | The unique identifier of the resource. | Manufacturing Transactions.Resource Id | RESOURCE_ID | RESOURCE_ID | 159034 |
| Resource Name | Resource code | Manufacturing Transactions.Resource Name | RESOURCE_NAME | RESOURCE_NAME | 159135 |
| Resource Required Amount | Rate per assembly or amount per job/schedule | Manufacturing Transactions.Resource Required Amount | RESOURCE_REQUIRED_AMOUNT | RESOURCE_REQUIRED_AMOUNT | 159169 |
| Resource Sequence Number | | Manufacturing Transactions.Resource Sequence Number | RESOURCE_SEQUENCE_NUMBER | RESOURCE_SEQUENCE_NUMBER | 159179 |
| Source | Code of the source system that generated the transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source | SOURCE | SOURCE | 162315 |
| Source Line Id | Identifier used by the source transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source Line Id | SOURCE_LINE_ID | SOURCE_LINE_ID | 162442 |
| Standard Rate Flag | Whether or not the resource is charged at the standard rate | Manufacturing Transactions.Standard Rate Flag | STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | 162859 |
| Standard Resource Rate | Standard rate of resource | Manufacturing Transactions.Standard Resource Rate | STANDARD_RESOURCE_RATE | STANDARD_RESOURCE_RATE | 162863 |
| 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. | Manufacturing Transactions.Task Id | TASK_ID | TASK_ID | 164599 |
| Task Name | User-defined short name of the task | Manufacturing Transactions.Task Name | TASK_NAME | TASK_NAME | 164640 |
| 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. | Manufacturing Transactions.Task Number | TASK_NUMBER | TASK_NUMBER | 164674 |
| Transaction Date | | Manufacturing Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165652 |
| Transaction Date - Day | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192343 |
| Transaction Date - Month | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192397 |
| Transaction Date - Quarter | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192451 |
| Transaction Date - Year | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192505 |
| Transaction Id | External payment/receipt identifier. | Manufacturing Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165701 |
| Transaction Quantity | | Manufacturing Transactions.Transaction Quantity | TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | 165774 |
| Transaction Reference | Transaction reference descriptive text | Manufacturing Transactions.Transaction Reference | TRANSACTION_REFERENCE | TRANSACTION_REFERENCE | 165806 |
| Transaction Type | | Manufacturing Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 273898 |
| Transaction UOM | Unit of measure used in the transaction | Manufacturing Transactions.Transaction UOM | TRANSACTION_UOM | TRANSACTION_UOM | 165883 |
| Updated By | | Manufacturing Transactions.Updated By | UPDATED_BY | UPDATED_BY | 166522 |
| Updated Date | | Manufacturing Transactions.Updated Date | UPDATED_DATE | UPDATED_DATE | 166535 |
| Updated Date - Day | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_DAY | 192697 |
| Updated Date - Month | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_MONTH | 192713 |
| Updated Date - Quarter | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_QUARTER | 192729 |
| Updated Date - Year | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_YEAR | 192745 |
| Acct Period Id | Accounting period identifier | Manufacturing Transactions.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114428 |
| Activity | The activity performed in the operation. | Manufacturing Transactions.Activity | ACTIVITY | ACTIVITY | 114630 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Transactions.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114726 |
| Actual Resource Rate | Actual rate of resource | Manufacturing Transactions.Actual Resource Rate | ACTUAL_RESOURCE_RATE | ACTUAL_RESOURCE_RATE | 114905 |
| Assembly Item Number | | Manufacturing Transactions.Assembly Item Number | ASSEMBLY_ITEM_NUMBER | ASSEMBLY_ITEM_NUMBER | 116532 |
| Autocharge Type | | Manufacturing Transactions.Autocharge Type | AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | 118632 |
| Basis | | Manufacturing Transactions.Basis | BASIS | BASIS | 119348 |
| Completion Transaction Id | Originating completion transaction in MTL_MATERIAL_TRANSACTIONS | Manufacturing Transactions.Completion Transaction Id | COMPLETION_TRANSACTION_ID | COMPLETION_TRANSACTION_ID | 122909 |
| Cost Update Id | Identifier of the cost update process that updated the record | Manufacturing Transactions.Cost Update Id | COST_UPDATE_ID | COST_UPDATE_ID | 123799 |
| Created By | Standard Who column. | Manufacturing Transactions.Created By | CREATED_BY | CREATED_BY | 124823 |
| Created Date | | Manufacturing Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125378 |
| Created Date - Day | | Manufacturing Transactions.Created Date | | CREATED_DATE_DAY | 171189 |
| Created Date - Month | | Manufacturing Transactions.Created Date | | CREATED_DATE_MONTH | 171343 |
| Created Date - Quarter | | Manufacturing Transactions.Created Date | | CREATED_DATE_QUARTER | 171497 |
| Created Date - Year | | Manufacturing Transactions.Created Date | | CREATED_DATE_YEAR | 171651 |
| Currency | The currency for an account balance. | Manufacturing Transactions.Currency | CURRENCY | CURRENCY | 126944 |
| Currency Actual Resource Rate | Actual resource rate converted for the currency code | Manufacturing Transactions.Currency Actual Resource Rate | CURRENCY_ACTUAL_RESOURCE_RATE | CURRENCY_ACTUAL_RESOURCE_RATE | 126960 |
| Currency Conversion Date | The currency conversion date. | Manufacturing Transactions.Currency Conversion Date | CURRENCY_CONVERSION_DATE | CURRENCY_CONVERSION_DATE | 127098 |
| Currency Conversion Date - Day | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_DAY | 173968 |
| Currency Conversion Date - Month | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_MONTH | 173980 |
| Currency Conversion Date - Quarter | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_QUARTER | 173992 |
| Currency Conversion Date - Year | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_YEAR | 174004 |
| Currency Conversion Rate | The currency exchange rate. | Manufacturing Transactions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127109 |
| Currency Conversion Type | The type of currency exchange rate. | Manufacturing Transactions.Currency Conversion Type | CURRENCY_CONVERSION_TYPE | CURRENCY_CONVERSION_TYPE | 127178 |
| Department | Department code | Manufacturing Transactions.Department | DEPARTMENT | DEPARTMENT | 129127 |
| Department Id | Department identifier | Manufacturing Transactions.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129179 |
| Employee Id | Employee identifier | Manufacturing Transactions.Employee Id | EMPLOYEE_ID | EMPLOYEE_ID | 131881 |
| Employee Name | Empolyee name | Manufacturing Transactions.Employee Name | EMPLOYEE_NAME | EMPLOYEE_NAME | 131889 |
| Item | | Manufacturing Transactions.Item | ASSEMBLY_ITEM | ASSEMBLY_ITEM | 273899 |
| Item 1 | | Manufacturing Transactions.Item 1 | PURCHASED_ITEM | PURCHASED_ITEM | 273900 |
| Line | Line name | Manufacturing Transactions.Line | LINE | LINE | 144574 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Manufacturing Transactions.Line Id | LINE_ID | LINE_ID | 144650 |
| Mfg Order Id | WIP job or repetitive assembly identifier | Manufacturing Transactions.Mfg Order Id | MFG_ORDER_ID | MFG_ORDER_ID | 147064 |
| Mfg Order Name | WIP job or repetitive assembly name or flow schedule reference code | Manufacturing Transactions.Mfg Order Name | MFG_ORDER_NAME | MFG_ORDER_NAME | 147075 |
| Move Transaction Id | Move transaction identifier | Manufacturing Transactions.Move Transaction Id | MOVE_TRANSACTION_ID | MOVE_TRANSACTION_ID | 147475 |
| Operation Sequence Number | Operation sequence number within a routing | Manufacturing Transactions.Operation Sequence Number | OPERATION_SEQUENCE_NUMBER | OPERATION_SEQUENCE_NUMBER | 149669 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Transactions.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150167 |
| Organization Id | | Manufacturing Transactions.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150434 |
| Organization Name | | Manufacturing Transactions.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150731 |
| PO Header Id | Purchase order header identifier | Manufacturing Transactions.PO Header Id | PO_HEADER_ID | PO_HEADER_ID | 155033 |
| PO Line | Line number | Manufacturing Transactions.PO Line | PO_LINE | PO_LINE | 155038 |
| PO Line Id | Purchase order line identifier | Manufacturing Transactions.PO Line Id | PO_LINE_ID | PO_LINE_ID | 155043 |
| PO Number | Document number | Manufacturing Transactions.PO Number | PO_NUMBER | PO_NUMBER | 155084 |
| PO Operating Unit Name | Name of the organization | Manufacturing Transactions.PO Operating Unit Name | PO_OPERATING_UNIT_NAME | PO_OPERATING_UNIT_NAME | 155088 |
| PO Type | Type of the document | Manufacturing Transactions.PO Type | PO_TYPE | PO_TYPE | 155114 |
| Period Name | The name of an accounting period. | Manufacturing Transactions.Period Name | PERIOD_NAME | PERIOD_NAME | 153132 |
| Primary Item Id | Inventory item identifier of the assembly the job or schedule creates | Manufacturing Transactions.Primary Item Id | PRIMARY_ITEM_ID | PRIMARY_ITEM_ID | 155532 |
| Primary Quantity | Quantity transacted expressed in the primary unit of measure | Manufacturing Transactions.Primary Quantity | PRIMARY_QUANTITY | PRIMARY_QUANTITY | 155559 |
| Primary UOM | Primary unit of measure | Manufacturing Transactions.Primary UOM | PRIMARY_UOM | PRIMARY_UOM | 155596 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Manufacturing Transactions.Project Id | PROJECT_ID | PROJECT_ID | 156476 |
| Project Name | User-defined name that uniquely identifies the project | Manufacturing Transactions.Project Name | PROJECT_NAME | PROJECT_NAME | 156566 |
| Project Number | | Manufacturing Transactions.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156647 |
| Purchased Item Number | | Manufacturing Transactions.Purchased Item Number | PURCHASED_ITEM_NUMBER | PURCHASED_ITEM_NUMBER | 157037 |
| Reason | Reason name | Manufacturing Transactions.Reason | REASON | REASON | 157897 |
| Reason Id | Reason identifier | Manufacturing Transactions.Reason Id | REASON_ID | REASON_ID | 157953 |
| Receiving Transaction Id | Receiving transaction identifier | Manufacturing Transactions.Receiving Transaction Id | RCV_TRANSACTION_ID | RCV_TRANSACTION_ID | 157756 |
| Resource Id | The unique identifier of the resource. | Manufacturing Transactions.Resource Id | RESOURCE_ID | RESOURCE_ID | 159034 |
| Resource Name | Resource code | Manufacturing Transactions.Resource Name | RESOURCE_NAME | RESOURCE_NAME | 159135 |
| Resource Required Amount | Rate per assembly or amount per job/schedule | Manufacturing Transactions.Resource Required Amount | RESOURCE_REQUIRED_AMOUNT | RESOURCE_REQUIRED_AMOUNT | 159169 |
| Resource Sequence Number | | Manufacturing Transactions.Resource Sequence Number | RESOURCE_SEQUENCE_NUMBER | RESOURCE_SEQUENCE_NUMBER | 159179 |
| Source | Code of the source system that generated the transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source | SOURCE | SOURCE | 162315 |
| Source Line Id | Identifier used by the source transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source Line Id | SOURCE_LINE_ID | SOURCE_LINE_ID | 162442 |
| Standard Rate Flag | Whether or not the resource is charged at the standard rate | Manufacturing Transactions.Standard Rate Flag | STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | 162859 |
| Standard Resource Rate | Standard rate of resource | Manufacturing Transactions.Standard Resource Rate | STANDARD_RESOURCE_RATE | STANDARD_RESOURCE_RATE | 162863 |
| 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. | Manufacturing Transactions.Task Id | TASK_ID | TASK_ID | 164599 |
| Task Name | User-defined short name of the task | Manufacturing Transactions.Task Name | TASK_NAME | TASK_NAME | 164640 |
| 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. | Manufacturing Transactions.Task Number | TASK_NUMBER | TASK_NUMBER | 164674 |
| Transaction Date | | Manufacturing Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165652 |
| Transaction Date - Day | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192343 |
| Transaction Date - Month | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192397 |
| Transaction Date - Quarter | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192451 |
| Transaction Date - Year | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192505 |
| Transaction Id | External payment/receipt identifier. | Manufacturing Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165701 |
| Transaction Quantity | | Manufacturing Transactions.Transaction Quantity | TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | 165774 |
| Transaction Reference | Transaction reference descriptive text | Manufacturing Transactions.Transaction Reference | TRANSACTION_REFERENCE | TRANSACTION_REFERENCE | 165806 |
| Transaction Type | | Manufacturing Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 273898 |
| Transaction UOM | Unit of measure used in the transaction | Manufacturing Transactions.Transaction UOM | TRANSACTION_UOM | TRANSACTION_UOM | 165883 |
| Updated By | | Manufacturing Transactions.Updated By | UPDATED_BY | UPDATED_BY | 166522 |
| Updated Date | | Manufacturing Transactions.Updated Date | UPDATED_DATE | UPDATED_DATE | 166535 |
| Updated Date - Day | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_DAY | 192697 |
| Updated Date - Month | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_MONTH | 192713 |
| Updated Date - Quarter | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_QUARTER | 192729 |
| Updated Date - Year | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_YEAR | 192745 |
| Acct Period Id | Accounting period identifier | Manufacturing Transactions.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114428 |
| Activity | The activity performed in the operation. | Manufacturing Transactions.Activity | ACTIVITY | ACTIVITY | 114630 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Transactions.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114726 |
| Actual Resource Rate | Actual rate of resource | Manufacturing Transactions.Actual Resource Rate | ACTUAL_RESOURCE_RATE | ACTUAL_RESOURCE_RATE | 114905 |
| Assembly Item Number | | Manufacturing Transactions.Assembly Item Number | ASSEMBLY_ITEM_NUMBER | ASSEMBLY_ITEM_NUMBER | 116532 |
| Autocharge Type | | Manufacturing Transactions.Autocharge Type | AUTOCHARGE_TYPE | AUTOCHARGE_TYPE | 118632 |
| Basis | | Manufacturing Transactions.Basis | BASIS | BASIS | 119348 |
| Completion Transaction Id | Originating completion transaction in MTL_MATERIAL_TRANSACTIONS | Manufacturing Transactions.Completion Transaction Id | COMPLETION_TRANSACTION_ID | COMPLETION_TRANSACTION_ID | 122909 |
| Cost Update Id | Identifier of the cost update process that updated the record | Manufacturing Transactions.Cost Update Id | COST_UPDATE_ID | COST_UPDATE_ID | 123799 |
| Created By | Standard Who column. | Manufacturing Transactions.Created By | CREATED_BY | CREATED_BY | 124823 |
| Created Date | | Manufacturing Transactions.Created Date | CREATED_DATE | CREATED_DATE | 125378 |
| Created Date - Day | | Manufacturing Transactions.Created Date | | CREATED_DATE_DAY | 171189 |
| Created Date - Month | | Manufacturing Transactions.Created Date | | CREATED_DATE_MONTH | 171343 |
| Created Date - Quarter | | Manufacturing Transactions.Created Date | | CREATED_DATE_QUARTER | 171497 |
| Created Date - Year | | Manufacturing Transactions.Created Date | | CREATED_DATE_YEAR | 171651 |
| Currency | The currency for an account balance. | Manufacturing Transactions.Currency | CURRENCY | CURRENCY | 126944 |
| Currency Actual Resource Rate | Actual resource rate converted for the currency code | Manufacturing Transactions.Currency Actual Resource Rate | CURRENCY_ACTUAL_RESOURCE_RATE | CURRENCY_ACTUAL_RESOURCE_RATE | 126960 |
| Currency Conversion Date | The currency conversion date. | Manufacturing Transactions.Currency Conversion Date | CURRENCY_CONVERSION_DATE | CURRENCY_CONVERSION_DATE | 127098 |
| Currency Conversion Date - Day | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_DAY | 173968 |
| Currency Conversion Date - Month | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_MONTH | 173980 |
| Currency Conversion Date - Quarter | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_QUARTER | 173992 |
| Currency Conversion Date - Year | | Manufacturing Transactions.Currency Conversion Date | | CURRENCY_CONVERSION_DATE_YEAR | 174004 |
| Currency Conversion Rate | The currency exchange rate. | Manufacturing Transactions.Currency Conversion Rate | CURRENCY_CONVERSION_RATE | CURRENCY_CONVERSION_RATE | 127109 |
| Currency Conversion Type | The type of currency exchange rate. | Manufacturing Transactions.Currency Conversion Type | CURRENCY_CONVERSION_TYPE | CURRENCY_CONVERSION_TYPE | 127178 |
| Department | Department code | Manufacturing Transactions.Department | DEPARTMENT | DEPARTMENT | 129127 |
| Department Id | Department identifier | Manufacturing Transactions.Department Id | DEPARTMENT_ID | DEPARTMENT_ID | 129179 |
| Employee Id | Employee identifier | Manufacturing Transactions.Employee Id | EMPLOYEE_ID | EMPLOYEE_ID | 131881 |
| Employee Name | Empolyee name | Manufacturing Transactions.Employee Name | EMPLOYEE_NAME | EMPLOYEE_NAME | 131889 |
| Item | | Manufacturing Transactions.Item | ASSEMBLY_ITEM | ASSEMBLY_ITEM | 273899 |
| Item 1 | | Manufacturing Transactions.Item 1 | PURCHASED_ITEM | PURCHASED_ITEM | 273900 |
| Line | Line name | Manufacturing Transactions.Line | LINE | LINE | 144574 |
| Line Id | The number of the Line ID that is associated to the enrollment through OM or OTA. | Manufacturing Transactions.Line Id | LINE_ID | LINE_ID | 144650 |
| Mfg Order Id | WIP job or repetitive assembly identifier | Manufacturing Transactions.Mfg Order Id | MFG_ORDER_ID | MFG_ORDER_ID | 147064 |
| Mfg Order Name | WIP job or repetitive assembly name or flow schedule reference code | Manufacturing Transactions.Mfg Order Name | MFG_ORDER_NAME | MFG_ORDER_NAME | 147075 |
| Move Transaction Id | Move transaction identifier | Manufacturing Transactions.Move Transaction Id | MOVE_TRANSACTION_ID | MOVE_TRANSACTION_ID | 147475 |
| Operation Sequence Number | Operation sequence number within a routing | Manufacturing Transactions.Operation Sequence Number | OPERATION_SEQUENCE_NUMBER | OPERATION_SEQUENCE_NUMBER | 149669 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Transactions.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150167 |
| Organization Id | | Manufacturing Transactions.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150434 |
| Organization Name | | Manufacturing Transactions.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150731 |
| PO Header Id | Purchase order header identifier | Manufacturing Transactions.PO Header Id | PO_HEADER_ID | PO_HEADER_ID | 155033 |
| PO Line | Line number | Manufacturing Transactions.PO Line | PO_LINE | PO_LINE | 155038 |
| PO Line Id | Purchase order line identifier | Manufacturing Transactions.PO Line Id | PO_LINE_ID | PO_LINE_ID | 155043 |
| PO Number | Document number | Manufacturing Transactions.PO Number | PO_NUMBER | PO_NUMBER | 155084 |
| PO Operating Unit Name | Name of the organization | Manufacturing Transactions.PO Operating Unit Name | PO_OPERATING_UNIT_NAME | PO_OPERATING_UNIT_NAME | 155088 |
| PO Type | Type of the document | Manufacturing Transactions.PO Type | PO_TYPE | PO_TYPE | 155114 |
| Period Name | The name of an accounting period. | Manufacturing Transactions.Period Name | PERIOD_NAME | PERIOD_NAME | 153132 |
| Primary Item Id | Inventory item identifier of the assembly the job or schedule creates | Manufacturing Transactions.Primary Item Id | PRIMARY_ITEM_ID | PRIMARY_ITEM_ID | 155532 |
| Primary Quantity | Quantity transacted expressed in the primary unit of measure | Manufacturing Transactions.Primary Quantity | PRIMARY_QUANTITY | PRIMARY_QUANTITY | 155559 |
| Primary UOM | Primary unit of measure | Manufacturing Transactions.Primary UOM | PRIMARY_UOM | PRIMARY_UOM | 155596 |
| Project Id | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects. | Manufacturing Transactions.Project Id | PROJECT_ID | PROJECT_ID | 156476 |
| Project Name | User-defined name that uniquely identifies the project | Manufacturing Transactions.Project Name | PROJECT_NAME | PROJECT_NAME | 156566 |
| Project Number | | Manufacturing Transactions.Project Number | PROJECT_NUMBER | PROJECT_NUMBER | 156647 |
| Purchased Item Number | | Manufacturing Transactions.Purchased Item Number | PURCHASED_ITEM_NUMBER | PURCHASED_ITEM_NUMBER | 157037 |
| Reason | Reason name | Manufacturing Transactions.Reason | REASON | REASON | 157897 |
| Reason Id | Reason identifier | Manufacturing Transactions.Reason Id | REASON_ID | REASON_ID | 157953 |
| Receiving Transaction Id | Receiving transaction identifier | Manufacturing Transactions.Receiving Transaction Id | RCV_TRANSACTION_ID | RCV_TRANSACTION_ID | 157756 |
| Resource Id | The unique identifier of the resource. | Manufacturing Transactions.Resource Id | RESOURCE_ID | RESOURCE_ID | 159034 |
| Resource Name | Resource code | Manufacturing Transactions.Resource Name | RESOURCE_NAME | RESOURCE_NAME | 159135 |
| Resource Required Amount | Rate per assembly or amount per job/schedule | Manufacturing Transactions.Resource Required Amount | RESOURCE_REQUIRED_AMOUNT | RESOURCE_REQUIRED_AMOUNT | 159169 |
| Resource Sequence Number | | Manufacturing Transactions.Resource Sequence Number | RESOURCE_SEQUENCE_NUMBER | RESOURCE_SEQUENCE_NUMBER | 159179 |
| Source | Code of the source system that generated the transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source | SOURCE | SOURCE | 162315 |
| Source Line Id | Identifier used by the source transaction record (null if created by Oracle Work in Process) | Manufacturing Transactions.Source Line Id | SOURCE_LINE_ID | SOURCE_LINE_ID | 162442 |
| Standard Rate Flag | Whether or not the resource is charged at the standard rate | Manufacturing Transactions.Standard Rate Flag | STANDARD_RATE_FLAG | STANDARD_RATE_FLAG | 162859 |
| Standard Resource Rate | Standard rate of resource | Manufacturing Transactions.Standard Resource Rate | STANDARD_RESOURCE_RATE | STANDARD_RESOURCE_RATE | 162863 |
| 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. | Manufacturing Transactions.Task Id | TASK_ID | TASK_ID | 164599 |
| Task Name | User-defined short name of the task | Manufacturing Transactions.Task Name | TASK_NAME | TASK_NAME | 164640 |
| 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. | Manufacturing Transactions.Task Number | TASK_NUMBER | TASK_NUMBER | 164674 |
| Transaction Date | | Manufacturing Transactions.Transaction Date | TRANSACTION_DATE | TRANSACTION_DATE | 165652 |
| Transaction Date - Day | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_DAY | 192343 |
| Transaction Date - Month | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_MONTH | 192397 |
| Transaction Date - Quarter | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_QUARTER | 192451 |
| Transaction Date - Year | | Manufacturing Transactions.Transaction Date | | TRANSACTION_DATE_YEAR | 192505 |
| Transaction Id | External payment/receipt identifier. | Manufacturing Transactions.Transaction Id | TRANSACTION_ID | TRANSACTION_ID | 165701 |
| Transaction Quantity | | Manufacturing Transactions.Transaction Quantity | TRANSACTION_QUANTITY | TRANSACTION_QUANTITY | 165774 |
| Transaction Reference | Transaction reference descriptive text | Manufacturing Transactions.Transaction Reference | TRANSACTION_REFERENCE | TRANSACTION_REFERENCE | 165806 |
| Transaction Type | | Manufacturing Transactions.Transaction Type | TRANSACTION_TYPE | TRANSACTION_TYPE | 273898 |
| Transaction UOM | Unit of measure used in the transaction | Manufacturing Transactions.Transaction UOM | TRANSACTION_UOM | TRANSACTION_UOM | 165883 |
| Updated By | | Manufacturing Transactions.Updated By | UPDATED_BY | UPDATED_BY | 166522 |
| Updated Date | | Manufacturing Transactions.Updated Date | UPDATED_DATE | UPDATED_DATE | 166535 |
| Updated Date - Day | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_DAY | 192697 |
| Updated Date - Month | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_MONTH | 192713 |
| Updated Date - Quarter | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_QUARTER | 192729 |
| Updated Date - Year | | Manufacturing Transactions.Updated Date | | UPDATED_DATE_YEAR | 192745 |