Powered by InfoCaptor


Previous Page   Next Page

Manufacturing Resource Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WIPFG_MFG_RESOURCE_TXNSUnknown
NoneNone.WIPFG_MFG_RESOURCE_TXNSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acct Period IdAccounting period identifierManufacturing Resource Transactions.Acct Period IdACCT_PERIOD_IDACCT_PERIOD_ID114427
ActivityThe activity performed in the operation.Manufacturing Resource Transactions.ActivityACTIVITYACTIVITY114629
Activity IdActivity Id. Repetitive tasks performed within an organisation.Manufacturing Resource Transactions.Activity IdACTIVITY_IDACTIVITY_ID114725
Actual Resource RateActual rate of resourceManufacturing Resource Transactions.Actual Resource RateACTUAL_RESOURCE_RATEACTUAL_RESOURCE_RATE114904
Autocharge Type Manufacturing Resource Transactions.Autocharge TypeAUTOCHARGE_TYPEAUTOCHARGE_TYPE118631
Basis Manufacturing Resource Transactions.BasisBASISBASIS119347
Completion Transaction IdOriginating completion transaction in MTL_MATERIAL_TRANSACTIONSManufacturing Resource Transactions.Completion Transaction IdCOMPLETION_TRANSACTION_IDCOMPLETION_TRANSACTION_ID122908
Created ByStandard Who column.Manufacturing Resource Transactions.Created ByCREATED_BYCREATED_BY124822
Creation Date Manufacturing Resource Transactions.Creation DateCREATION_DATECREATION_DATE126256
CurrencyThe currency for an account balance.Manufacturing Resource Transactions.CurrencyCURRENCYCURRENCY126943
Currency Actual Resource RateActual resource rate converted for the currency codeManufacturing Resource Transactions.Currency Actual Resource RateCURRENCY_ACTUAL_RESOURCE_RATECURRENCY_ACTUAL_RESOURCE_RATE126959
Currency Conversion DateThe currency conversion date.Manufacturing Resource Transactions.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127097
Currency Conversion Date - Day Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_DAY173966
Currency Conversion Date - Month Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_MONTH173978
Currency Conversion Date - Quarter Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_QUARTER173990
Currency Conversion Date - Year Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_YEAR174002
Currency Conversion RateThe currency exchange rate.Manufacturing Resource Transactions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127108
Currency Conversion TypeThe type of currency exchange rate.Manufacturing Resource Transactions.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127177
DepartmentDepartment codeManufacturing Resource Transactions.DepartmentDEPARTMENTDEPARTMENT129126
Department IdDepartment identifierManufacturing Resource Transactions.Department IdDEPARTMENT_IDDEPARTMENT_ID129178
Employee IdEmployee identifierManufacturing Resource Transactions.Employee IdEMPLOYEE_IDEMPLOYEE_ID131880
Employee NameEmpolyee nameManufacturing Resource Transactions.Employee NameEMPLOYEE_NAMEEMPLOYEE_NAME131888
Item Manufacturing Resource Transactions.ItemPRIMARY_ITEMPRIMARY_ITEM273897
Last Update Date Manufacturing Resource Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140777
LineLine nameManufacturing Resource Transactions.LineLINELINE144573
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Manufacturing Resource Transactions.Line IdLINE_IDLINE_ID144649
Mfg Order IdWIP job or repetitive assembly identifierManufacturing Resource Transactions.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147063
Mfg Order NameWIP job or repetitive assembly name or flow schedule reference codeManufacturing Resource Transactions.Mfg Order NameMFG_ORDER_NAMEMFG_ORDER_NAME147074
Move Transaction IdMove transaction identifierManufacturing Resource Transactions.Move Transaction IdMOVE_TRANSACTION_IDMOVE_TRANSACTION_ID147474
Operation Sequence NumberOperation sequence number within a routingManufacturing Resource Transactions.Operation Sequence NumberOPERATION_SEQUENCE_NUMBEROPERATION_SEQUENCE_NUMBER149668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Resource Transactions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150166
Organization Id Manufacturing Resource Transactions.Organization IdORGANIZATION_IDORGANIZATION_ID150433
Organization Name Manufacturing Resource Transactions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150730
Period NameThe name of an accounting period.Manufacturing Resource Transactions.Period NamePERIOD_NAMEPERIOD_NAME153131
Primary Item IdInventory item identifier of the assembly the job or schedule createsManufacturing Resource Transactions.Primary Item IdPRIMARY_ITEM_IDPRIMARY_ITEM_ID155531
Primary Item Number Manufacturing Resource Transactions.Primary Item NumberPRIMARY_ITEM_NUMBERPRIMARY_ITEM_NUMBER155536
Primary QuantityQuantity transacted expressed in the primary unit of measureManufacturing Resource Transactions.Primary QuantityPRIMARY_QUANTITYPRIMARY_QUANTITY155558
Primary UOMPrimary unit of measureManufacturing Resource Transactions.Primary UOMPRIMARY_UOMPRIMARY_UOM155595
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Manufacturing Resource Transactions.Project IdPROJECT_IDPROJECT_ID156475
Project NameUser-defined name that uniquely identifies the projectManufacturing Resource Transactions.Project NamePROJECT_NAMEPROJECT_NAME156565
Project Number Manufacturing Resource Transactions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156646
ReasonReason nameManufacturing Resource Transactions.ReasonREASONREASON157896
Reason IdReason identifierManufacturing Resource Transactions.Reason IdREASON_IDREASON_ID157952
Resource IdThe unique identifier of the resource.Manufacturing Resource Transactions.Resource IdRESOURCE_IDRESOURCE_ID159033
Resource NameResource codeManufacturing Resource Transactions.Resource NameRESOURCE_NAMERESOURCE_NAME159134
Resource Required AmountRate per assembly or amount per job/scheduleManufacturing Resource Transactions.Resource Required AmountRESOURCE_REQUIRED_AMOUNTRESOURCE_REQUIRED_AMOUNT159168
Resource Sequence Number Manufacturing Resource Transactions.Resource Sequence NumberRESOURCE_SEQUENCE_NUMBERRESOURCE_SEQUENCE_NUMBER159178
SourceCode of the source system that generated the transaction record (null if created by Oracle Work in Process)Manufacturing Resource Transactions.SourceSOURCESOURCE162314
Source Line IdIdentifier used by the source transaction record (null if created by Oracle Work in Process)Manufacturing Resource Transactions.Source Line IdSOURCE_LINE_IDSOURCE_LINE_ID162441
Standard Rate FlagWhether or not the resource is charged at the standard rateManufacturing Resource Transactions.Standard Rate FlagSTANDARD_RATE_FLAGSTANDARD_RATE_FLAG162858
Standard Resource RateStandard rate of resourceManufacturing Resource Transactions.Standard Resource RateSTANDARD_RESOURCE_RATESTANDARD_RESOURCE_RATE162862
Task IdIdentifier 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 Resource Transactions.Task IdTASK_IDTASK_ID164598
Task NameUser-defined short name of the taskManufacturing Resource Transactions.Task NameTASK_NAMETASK_NAME164639
Task NumberUser-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 Resource Transactions.Task NumberTASK_NUMBERTASK_NUMBER164673
Transaction Date Manufacturing Resource Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165651
Transaction Date - Day Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_DAY192341
Transaction Date - Month Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_MONTH192395
Transaction Date - Quarter Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_QUARTER192449
Transaction Date - Year Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_YEAR192503
Transaction IdExternal payment/receipt identifier.Manufacturing Resource Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165700
Transaction Quantity Manufacturing Resource Transactions.Transaction QuantityTRANSACTION_QUANTITYTRANSACTION_QUANTITY165773
Transaction ReferenceTransaction reference descriptive textManufacturing Resource Transactions.Transaction ReferenceTRANSACTION_REFERENCETRANSACTION_REFERENCE165805
Transaction TypeType of the external cash transaction, either payment or receipt.Manufacturing Resource Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165845
Transaction UOMUnit of measure used in the transactionManufacturing Resource Transactions.Transaction UOMTRANSACTION_UOMTRANSACTION_UOM165882
Updated By Manufacturing Resource Transactions.Updated ByUPDATED_BYUPDATED_BY166521
Acct Period IdAccounting period identifierManufacturing Resource Transactions.Acct Period IdACCT_PERIOD_IDACCT_PERIOD_ID114427
ActivityThe activity performed in the operation.Manufacturing Resource Transactions.ActivityACTIVITYACTIVITY114629
Activity IdActivity Id. Repetitive tasks performed within an organisation.Manufacturing Resource Transactions.Activity IdACTIVITY_IDACTIVITY_ID114725
Actual Resource RateActual rate of resourceManufacturing Resource Transactions.Actual Resource RateACTUAL_RESOURCE_RATEACTUAL_RESOURCE_RATE114904
Autocharge Type Manufacturing Resource Transactions.Autocharge TypeAUTOCHARGE_TYPEAUTOCHARGE_TYPE118631
Basis Manufacturing Resource Transactions.BasisBASISBASIS119347
Completion Transaction IdOriginating completion transaction in MTL_MATERIAL_TRANSACTIONSManufacturing Resource Transactions.Completion Transaction IdCOMPLETION_TRANSACTION_IDCOMPLETION_TRANSACTION_ID122908
Created ByStandard Who column.Manufacturing Resource Transactions.Created ByCREATED_BYCREATED_BY124822
Creation Date Manufacturing Resource Transactions.Creation DateCREATION_DATECREATION_DATE126256
CurrencyThe currency for an account balance.Manufacturing Resource Transactions.CurrencyCURRENCYCURRENCY126943
Currency Actual Resource RateActual resource rate converted for the currency codeManufacturing Resource Transactions.Currency Actual Resource RateCURRENCY_ACTUAL_RESOURCE_RATECURRENCY_ACTUAL_RESOURCE_RATE126959
Currency Conversion DateThe currency conversion date.Manufacturing Resource Transactions.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127097
Currency Conversion Date - Day Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_DAY173966
Currency Conversion Date - Month Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_MONTH173978
Currency Conversion Date - Quarter Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_QUARTER173990
Currency Conversion Date - Year Manufacturing Resource Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_YEAR174002
Currency Conversion RateThe currency exchange rate.Manufacturing Resource Transactions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127108
Currency Conversion TypeThe type of currency exchange rate.Manufacturing Resource Transactions.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127177
DepartmentDepartment codeManufacturing Resource Transactions.DepartmentDEPARTMENTDEPARTMENT129126
Department IdDepartment identifierManufacturing Resource Transactions.Department IdDEPARTMENT_IDDEPARTMENT_ID129178
Employee IdEmployee identifierManufacturing Resource Transactions.Employee IdEMPLOYEE_IDEMPLOYEE_ID131880
Employee NameEmpolyee nameManufacturing Resource Transactions.Employee NameEMPLOYEE_NAMEEMPLOYEE_NAME131888
Item Manufacturing Resource Transactions.ItemPRIMARY_ITEMPRIMARY_ITEM273897
Last Update Date Manufacturing Resource Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140777
LineLine nameManufacturing Resource Transactions.LineLINELINE144573
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Manufacturing Resource Transactions.Line IdLINE_IDLINE_ID144649
Mfg Order IdWIP job or repetitive assembly identifierManufacturing Resource Transactions.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147063
Mfg Order NameWIP job or repetitive assembly name or flow schedule reference codeManufacturing Resource Transactions.Mfg Order NameMFG_ORDER_NAMEMFG_ORDER_NAME147074
Move Transaction IdMove transaction identifierManufacturing Resource Transactions.Move Transaction IdMOVE_TRANSACTION_IDMOVE_TRANSACTION_ID147474
Operation Sequence NumberOperation sequence number within a routingManufacturing Resource Transactions.Operation Sequence NumberOPERATION_SEQUENCE_NUMBEROPERATION_SEQUENCE_NUMBER149668
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Resource Transactions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150166
Organization Id Manufacturing Resource Transactions.Organization IdORGANIZATION_IDORGANIZATION_ID150433
Organization Name Manufacturing Resource Transactions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150730
Period NameThe name of an accounting period.Manufacturing Resource Transactions.Period NamePERIOD_NAMEPERIOD_NAME153131
Primary Item IdInventory item identifier of the assembly the job or schedule createsManufacturing Resource Transactions.Primary Item IdPRIMARY_ITEM_IDPRIMARY_ITEM_ID155531
Primary Item Number Manufacturing Resource Transactions.Primary Item NumberPRIMARY_ITEM_NUMBERPRIMARY_ITEM_NUMBER155536
Primary QuantityQuantity transacted expressed in the primary unit of measureManufacturing Resource Transactions.Primary QuantityPRIMARY_QUANTITYPRIMARY_QUANTITY155558
Primary UOMPrimary unit of measureManufacturing Resource Transactions.Primary UOMPRIMARY_UOMPRIMARY_UOM155595
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Manufacturing Resource Transactions.Project IdPROJECT_IDPROJECT_ID156475
Project NameUser-defined name that uniquely identifies the projectManufacturing Resource Transactions.Project NamePROJECT_NAMEPROJECT_NAME156565
Project Number Manufacturing Resource Transactions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156646
ReasonReason nameManufacturing Resource Transactions.ReasonREASONREASON157896
Reason IdReason identifierManufacturing Resource Transactions.Reason IdREASON_IDREASON_ID157952
Resource IdThe unique identifier of the resource.Manufacturing Resource Transactions.Resource IdRESOURCE_IDRESOURCE_ID159033
Resource NameResource codeManufacturing Resource Transactions.Resource NameRESOURCE_NAMERESOURCE_NAME159134
Resource Required AmountRate per assembly or amount per job/scheduleManufacturing Resource Transactions.Resource Required AmountRESOURCE_REQUIRED_AMOUNTRESOURCE_REQUIRED_AMOUNT159168
Resource Sequence Number Manufacturing Resource Transactions.Resource Sequence NumberRESOURCE_SEQUENCE_NUMBERRESOURCE_SEQUENCE_NUMBER159178
SourceCode of the source system that generated the transaction record (null if created by Oracle Work in Process)Manufacturing Resource Transactions.SourceSOURCESOURCE162314
Source Line IdIdentifier used by the source transaction record (null if created by Oracle Work in Process)Manufacturing Resource Transactions.Source Line IdSOURCE_LINE_IDSOURCE_LINE_ID162441
Standard Rate FlagWhether or not the resource is charged at the standard rateManufacturing Resource Transactions.Standard Rate FlagSTANDARD_RATE_FLAGSTANDARD_RATE_FLAG162858
Standard Resource RateStandard rate of resourceManufacturing Resource Transactions.Standard Resource RateSTANDARD_RESOURCE_RATESTANDARD_RESOURCE_RATE162862
Task IdIdentifier 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 Resource Transactions.Task IdTASK_IDTASK_ID164598
Task NameUser-defined short name of the taskManufacturing Resource Transactions.Task NameTASK_NAMETASK_NAME164639
Task NumberUser-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 Resource Transactions.Task NumberTASK_NUMBERTASK_NUMBER164673
Transaction Date Manufacturing Resource Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165651
Transaction Date - Day Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_DAY192341
Transaction Date - Month Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_MONTH192395
Transaction Date - Quarter Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_QUARTER192449
Transaction Date - Year Manufacturing Resource Transactions.Transaction Date TRANSACTION_DATE_YEAR192503
Transaction IdExternal payment/receipt identifier.Manufacturing Resource Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165700
Transaction Quantity Manufacturing Resource Transactions.Transaction QuantityTRANSACTION_QUANTITYTRANSACTION_QUANTITY165773
Transaction ReferenceTransaction reference descriptive textManufacturing Resource Transactions.Transaction ReferenceTRANSACTION_REFERENCETRANSACTION_REFERENCE165805
Transaction TypeType of the external cash transaction, either payment or receipt.Manufacturing Resource Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165845
Transaction UOMUnit of measure used in the transactionManufacturing Resource Transactions.Transaction UOMTRANSACTION_UOMTRANSACTION_UOM165882
Updated By Manufacturing Resource Transactions.Updated ByUPDATED_BYUPDATED_BY166521
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto