Powered by InfoCaptor


Previous Page   Next Page

Outside Processing Manufacturing Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WIPFG_OSP_MFG_TXNSUnknown
NoneNone.WIPFG_OSP_MFG_TXNSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acct Period IdAccounting period identifierOutside Processing Manufacturing Transactions.Acct Period IdACCT_PERIOD_IDACCT_PERIOD_ID114429
ActivityThe activity performed in the operation.Outside Processing Manufacturing Transactions.ActivityACTIVITYACTIVITY114631
Activity IdActivity Id. Repetitive tasks performed within an organisation.Outside Processing Manufacturing Transactions.Activity IdACTIVITY_IDACTIVITY_ID114727
Actual Resource RateActual rate of resourceOutside Processing Manufacturing Transactions.Actual Resource RateACTUAL_RESOURCE_RATEACTUAL_RESOURCE_RATE114906
Assembly Item Number Outside Processing Manufacturing Transactions.Assembly Item NumberASSEMBLY_ITEM_NUMBERASSEMBLY_ITEM_NUMBER116533
Autocharge Type Outside Processing Manufacturing Transactions.Autocharge TypeAUTOCHARGE_TYPEAUTOCHARGE_TYPE118633
Basis Outside Processing Manufacturing Transactions.BasisBASISBASIS119349
Completion Transaction IdOriginating completion transaction in MTL_MATERIAL_TRANSACTIONSOutside Processing Manufacturing Transactions.Completion Transaction IdCOMPLETION_TRANSACTION_IDCOMPLETION_TRANSACTION_ID122910
Created ByStandard Who column.Outside Processing Manufacturing Transactions.Created ByCREATED_BYCREATED_BY124824
Creation Date Outside Processing Manufacturing Transactions.Creation DateCREATION_DATECREATION_DATE126257
CurrencyThe currency for an account balance.Outside Processing Manufacturing Transactions.CurrencyCURRENCYCURRENCY126945
Currency Actual Resource RateActual resource rate converted for the currency codeOutside Processing Manufacturing Transactions.Currency Actual Resource RateCURRENCY_ACTUAL_RESOURCE_RATECURRENCY_ACTUAL_RESOURCE_RATE126961
Currency Conversion DateThe currency conversion date.Outside Processing Manufacturing Transactions.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127099
Currency Conversion Date - Day Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_DAY173970
Currency Conversion Date - Month Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_MONTH173982
Currency Conversion Date - Quarter Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_QUARTER173994
Currency Conversion Date - Year Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_YEAR174006
Currency Conversion RateThe currency exchange rate.Outside Processing Manufacturing Transactions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127110
Currency Conversion TypeThe type of currency exchange rate.Outside Processing Manufacturing Transactions.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127179
DepartmentDepartment codeOutside Processing Manufacturing Transactions.DepartmentDEPARTMENTDEPARTMENT129128
Department IdDepartment identifierOutside Processing Manufacturing Transactions.Department IdDEPARTMENT_IDDEPARTMENT_ID129180
Item Outside Processing Manufacturing Transactions.ItemASSEMBLY_ITEMASSEMBLY_ITEM273901
Item 1 Outside Processing Manufacturing Transactions.Item 1PURCHASED_ITEMPURCHASED_ITEM273902
Last Update Date Outside Processing Manufacturing Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140778
LineLine nameOutside Processing Manufacturing Transactions.LineLINELINE144575
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Outside Processing Manufacturing Transactions.Line IdLINE_IDLINE_ID144651
Mfg Order IdWIP job or repetitive assembly identifierOutside Processing Manufacturing Transactions.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147065
Mfg Order NameWIP job or repetitive assembly name or flow schedule reference codeOutside Processing Manufacturing Transactions.Mfg Order NameMFG_ORDER_NAMEMFG_ORDER_NAME147076
Move Transaction IdMove transaction identifierOutside Processing Manufacturing Transactions.Move Transaction IdMOVE_TRANSACTION_IDMOVE_TRANSACTION_ID147476
Operation Sequence NumberOperation sequence number within a routingOutside Processing Manufacturing Transactions.Operation Sequence NumberOPERATION_SEQ_NUMOPERATION_SEQ_NUM149676
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Outside Processing Manufacturing Transactions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150168
Organization Id Outside Processing Manufacturing Transactions.Organization IdORGANIZATION_IDORGANIZATION_ID150435
Organization Name Outside Processing Manufacturing Transactions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150732
PO Header IdPurchase order header identifierOutside Processing Manufacturing Transactions.PO Header IdPO_HEADER_IDPO_HEADER_ID155034
PO LineLine numberOutside Processing Manufacturing Transactions.PO LinePO_LINEPO_LINE155039
PO Line IdPurchase order line identifierOutside Processing Manufacturing Transactions.PO Line IdPO_LINE_IDPO_LINE_ID155044
PO Line Item IdItem unique identifierOutside Processing Manufacturing Transactions.PO Line Item IdPO_LINE_ITEM_IDPO_LINE_ITEM_ID155066
PO NumberDocument numberOutside Processing Manufacturing Transactions.PO NumberPO_NUMBERPO_NUMBER155085
PO Operating Unit NameName of the organizationOutside Processing Manufacturing Transactions.PO Operating Unit NamePO_OPERATING_UNIT_NAMEPO_OPERATING_UNIT_NAME155089
PO TypeType of the documentOutside Processing Manufacturing Transactions.PO TypePO_TYPEPO_TYPE155115
Period NameThe name of an accounting period.Outside Processing Manufacturing Transactions.Period NamePERIOD_NAMEPERIOD_NAME153133
Primary Item IdInventory item identifier of the assembly the job or schedule createsOutside Processing Manufacturing Transactions.Primary Item IdPRIMARY_ITEM_IDPRIMARY_ITEM_ID155533
Primary QuantityQuantity transacted expressed in the primary unit of measureOutside Processing Manufacturing Transactions.Primary QuantityPRIMARY_QUANTITYPRIMARY_QUANTITY155560
Primary UOMPrimary unit of measureOutside Processing Manufacturing Transactions.Primary UOMPRIMARY_UOMPRIMARY_UOM155597
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Outside Processing Manufacturing Transactions.Project IdPROJECT_IDPROJECT_ID156477
Project NameUser-defined name that uniquely identifies the projectOutside Processing Manufacturing Transactions.Project NamePROJECT_NAMEPROJECT_NAME156567
Project Number Outside Processing Manufacturing Transactions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156648
Purchased Item Number Outside Processing Manufacturing Transactions.Purchased Item NumberPURCHASED_ITEM_NUMBERPURCHASED_ITEM_NUMBER157038
ReasonReason nameOutside Processing Manufacturing Transactions.ReasonREASONREASON157898
Reason IdReason identifierOutside Processing Manufacturing Transactions.Reason IdREASON_IDREASON_ID157954
Receiving Transaction IdReceiving transaction identifierOutside Processing Manufacturing Transactions.Receiving Transaction IdRCV_TRANSACTION_IDRCV_TRANSACTION_ID157757
Resource IdThe unique identifier of the resource.Outside Processing Manufacturing Transactions.Resource IdRESOURCE_IDRESOURCE_ID159035
Resource NameResource codeOutside Processing Manufacturing Transactions.Resource NameRESOURCE_NAMERESOURCE_NAME159136
Resource Required AmountRate per assembly or amount per job/scheduleOutside Processing Manufacturing Transactions.Resource Required AmountRESOURCE_REQUIRED_AMOUNTRESOURCE_REQUIRED_AMOUNT159170
Resource Sequence Number Outside Processing Manufacturing Transactions.Resource Sequence NumberRESOURCE_SEQ_NUMRESOURCE_SEQ_NUM159181
SourceCode of the source system that generated the transaction record (null if created by Oracle Work in Process)Outside Processing Manufacturing Transactions.SourceSOURCESOURCE162316
Source Line IdIdentifier used by the source transaction record (null if created by Oracle Work in Process)Outside Processing Manufacturing Transactions.Source Line IdSOURCE_LINE_IDSOURCE_LINE_ID162443
Standard Rate FlagWhether or not the resource is charged at teh standard rateOutside Processing Manufacturing Transactions.Standard Rate FlagSTANDARD_RATE_FLAGSTANDARD_RATE_FLAG162860
Standard Resource RateStandard rate of resourceOutside Processing Manufacturing Transactions.Standard Resource RateSTANDARD_RESOURCE_RATESTANDARD_RESOURCE_RATE162864
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.Outside Processing Manufacturing Transactions.Task IdTASK_IDTASK_ID164600
Task NameUser-defined short name of the taskOutside Processing Manufacturing Transactions.Task NameTASK_NAMETASK_NAME164641
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.Outside Processing Manufacturing Transactions.Task NumberTASK_NUMBERTASK_NUMBER164675
Transaction Date Outside Processing Manufacturing Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165653
Transaction Date - Day Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_DAY192345
Transaction Date - Month Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_MONTH192399
Transaction Date - Quarter Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_QUARTER192453
Transaction Date - Year Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_YEAR192507
Transaction IdExternal payment/receipt identifier.Outside Processing Manufacturing Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165702
Transaction Quantity Outside Processing Manufacturing Transactions.Transaction QuantityTRANSACTION_QUANTITYTRANSACTION_QUANTITY165775
Transaction ReferenceTransaction reference descriptive textOutside Processing Manufacturing Transactions.Transaction ReferenceTRANSACTION_REFERENCETRANSACTION_REFERENCE165807
Transaction TypeType of the external cash transaction, either payment or receipt.Outside Processing Manufacturing Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165846
Transaction UOMUnit of measure used in the transactionOutside Processing Manufacturing Transactions.Transaction UOMTRANSACTION_UOMTRANSACTION_UOM165884
Updated By Outside Processing Manufacturing Transactions.Updated ByUPDATED_BYUPDATED_BY166523
Acct Period IdAccounting period identifierOutside Processing Manufacturing Transactions.Acct Period IdACCT_PERIOD_IDACCT_PERIOD_ID114429
ActivityThe activity performed in the operation.Outside Processing Manufacturing Transactions.ActivityACTIVITYACTIVITY114631
Activity IdActivity Id. Repetitive tasks performed within an organisation.Outside Processing Manufacturing Transactions.Activity IdACTIVITY_IDACTIVITY_ID114727
Actual Resource RateActual rate of resourceOutside Processing Manufacturing Transactions.Actual Resource RateACTUAL_RESOURCE_RATEACTUAL_RESOURCE_RATE114906
Assembly Item Number Outside Processing Manufacturing Transactions.Assembly Item NumberASSEMBLY_ITEM_NUMBERASSEMBLY_ITEM_NUMBER116533
Autocharge Type Outside Processing Manufacturing Transactions.Autocharge TypeAUTOCHARGE_TYPEAUTOCHARGE_TYPE118633
Basis Outside Processing Manufacturing Transactions.BasisBASISBASIS119349
Completion Transaction IdOriginating completion transaction in MTL_MATERIAL_TRANSACTIONSOutside Processing Manufacturing Transactions.Completion Transaction IdCOMPLETION_TRANSACTION_IDCOMPLETION_TRANSACTION_ID122910
Created ByStandard Who column.Outside Processing Manufacturing Transactions.Created ByCREATED_BYCREATED_BY124824
Creation Date Outside Processing Manufacturing Transactions.Creation DateCREATION_DATECREATION_DATE126257
CurrencyThe currency for an account balance.Outside Processing Manufacturing Transactions.CurrencyCURRENCYCURRENCY126945
Currency Actual Resource RateActual resource rate converted for the currency codeOutside Processing Manufacturing Transactions.Currency Actual Resource RateCURRENCY_ACTUAL_RESOURCE_RATECURRENCY_ACTUAL_RESOURCE_RATE126961
Currency Conversion DateThe currency conversion date.Outside Processing Manufacturing Transactions.Currency Conversion DateCURRENCY_CONVERSION_DATECURRENCY_CONVERSION_DATE127099
Currency Conversion Date - Day Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_DAY173970
Currency Conversion Date - Month Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_MONTH173982
Currency Conversion Date - Quarter Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_QUARTER173994
Currency Conversion Date - Year Outside Processing Manufacturing Transactions.Currency Conversion Date CURRENCY_CONVERSION_DATE_YEAR174006
Currency Conversion RateThe currency exchange rate.Outside Processing Manufacturing Transactions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127110
Currency Conversion TypeThe type of currency exchange rate.Outside Processing Manufacturing Transactions.Currency Conversion TypeCURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_TYPE127179
DepartmentDepartment codeOutside Processing Manufacturing Transactions.DepartmentDEPARTMENTDEPARTMENT129128
Department IdDepartment identifierOutside Processing Manufacturing Transactions.Department IdDEPARTMENT_IDDEPARTMENT_ID129180
Item Outside Processing Manufacturing Transactions.ItemASSEMBLY_ITEMASSEMBLY_ITEM273901
Item 1 Outside Processing Manufacturing Transactions.Item 1PURCHASED_ITEMPURCHASED_ITEM273902
Last Update Date Outside Processing Manufacturing Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140778
LineLine nameOutside Processing Manufacturing Transactions.LineLINELINE144575
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Outside Processing Manufacturing Transactions.Line IdLINE_IDLINE_ID144651
Mfg Order IdWIP job or repetitive assembly identifierOutside Processing Manufacturing Transactions.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147065
Mfg Order NameWIP job or repetitive assembly name or flow schedule reference codeOutside Processing Manufacturing Transactions.Mfg Order NameMFG_ORDER_NAMEMFG_ORDER_NAME147076
Move Transaction IdMove transaction identifierOutside Processing Manufacturing Transactions.Move Transaction IdMOVE_TRANSACTION_IDMOVE_TRANSACTION_ID147476
Operation Sequence NumberOperation sequence number within a routingOutside Processing Manufacturing Transactions.Operation Sequence NumberOPERATION_SEQ_NUMOPERATION_SEQ_NUM149676
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Outside Processing Manufacturing Transactions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150168
Organization Id Outside Processing Manufacturing Transactions.Organization IdORGANIZATION_IDORGANIZATION_ID150435
Organization Name Outside Processing Manufacturing Transactions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150732
PO Header IdPurchase order header identifierOutside Processing Manufacturing Transactions.PO Header IdPO_HEADER_IDPO_HEADER_ID155034
PO LineLine numberOutside Processing Manufacturing Transactions.PO LinePO_LINEPO_LINE155039
PO Line IdPurchase order line identifierOutside Processing Manufacturing Transactions.PO Line IdPO_LINE_IDPO_LINE_ID155044
PO Line Item IdItem unique identifierOutside Processing Manufacturing Transactions.PO Line Item IdPO_LINE_ITEM_IDPO_LINE_ITEM_ID155066
PO NumberDocument numberOutside Processing Manufacturing Transactions.PO NumberPO_NUMBERPO_NUMBER155085
PO Operating Unit NameName of the organizationOutside Processing Manufacturing Transactions.PO Operating Unit NamePO_OPERATING_UNIT_NAMEPO_OPERATING_UNIT_NAME155089
PO TypeType of the documentOutside Processing Manufacturing Transactions.PO TypePO_TYPEPO_TYPE155115
Period NameThe name of an accounting period.Outside Processing Manufacturing Transactions.Period NamePERIOD_NAMEPERIOD_NAME153133
Primary Item IdInventory item identifier of the assembly the job or schedule createsOutside Processing Manufacturing Transactions.Primary Item IdPRIMARY_ITEM_IDPRIMARY_ITEM_ID155533
Primary QuantityQuantity transacted expressed in the primary unit of measureOutside Processing Manufacturing Transactions.Primary QuantityPRIMARY_QUANTITYPRIMARY_QUANTITY155560
Primary UOMPrimary unit of measureOutside Processing Manufacturing Transactions.Primary UOMPRIMARY_UOMPRIMARY_UOM155597
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Outside Processing Manufacturing Transactions.Project IdPROJECT_IDPROJECT_ID156477
Project NameUser-defined name that uniquely identifies the projectOutside Processing Manufacturing Transactions.Project NamePROJECT_NAMEPROJECT_NAME156567
Project Number Outside Processing Manufacturing Transactions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156648
Purchased Item Number Outside Processing Manufacturing Transactions.Purchased Item NumberPURCHASED_ITEM_NUMBERPURCHASED_ITEM_NUMBER157038
ReasonReason nameOutside Processing Manufacturing Transactions.ReasonREASONREASON157898
Reason IdReason identifierOutside Processing Manufacturing Transactions.Reason IdREASON_IDREASON_ID157954
Receiving Transaction IdReceiving transaction identifierOutside Processing Manufacturing Transactions.Receiving Transaction IdRCV_TRANSACTION_IDRCV_TRANSACTION_ID157757
Resource IdThe unique identifier of the resource.Outside Processing Manufacturing Transactions.Resource IdRESOURCE_IDRESOURCE_ID159035
Resource NameResource codeOutside Processing Manufacturing Transactions.Resource NameRESOURCE_NAMERESOURCE_NAME159136
Resource Required AmountRate per assembly or amount per job/scheduleOutside Processing Manufacturing Transactions.Resource Required AmountRESOURCE_REQUIRED_AMOUNTRESOURCE_REQUIRED_AMOUNT159170
Resource Sequence Number Outside Processing Manufacturing Transactions.Resource Sequence NumberRESOURCE_SEQ_NUMRESOURCE_SEQ_NUM159181
SourceCode of the source system that generated the transaction record (null if created by Oracle Work in Process)Outside Processing Manufacturing Transactions.SourceSOURCESOURCE162316
Source Line IdIdentifier used by the source transaction record (null if created by Oracle Work in Process)Outside Processing Manufacturing Transactions.Source Line IdSOURCE_LINE_IDSOURCE_LINE_ID162443
Standard Rate FlagWhether or not the resource is charged at teh standard rateOutside Processing Manufacturing Transactions.Standard Rate FlagSTANDARD_RATE_FLAGSTANDARD_RATE_FLAG162860
Standard Resource RateStandard rate of resourceOutside Processing Manufacturing Transactions.Standard Resource RateSTANDARD_RESOURCE_RATESTANDARD_RESOURCE_RATE162864
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.Outside Processing Manufacturing Transactions.Task IdTASK_IDTASK_ID164600
Task NameUser-defined short name of the taskOutside Processing Manufacturing Transactions.Task NameTASK_NAMETASK_NAME164641
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.Outside Processing Manufacturing Transactions.Task NumberTASK_NUMBERTASK_NUMBER164675
Transaction Date Outside Processing Manufacturing Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165653
Transaction Date - Day Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_DAY192345
Transaction Date - Month Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_MONTH192399
Transaction Date - Quarter Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_QUARTER192453
Transaction Date - Year Outside Processing Manufacturing Transactions.Transaction Date TRANSACTION_DATE_YEAR192507
Transaction IdExternal payment/receipt identifier.Outside Processing Manufacturing Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165702
Transaction Quantity Outside Processing Manufacturing Transactions.Transaction QuantityTRANSACTION_QUANTITYTRANSACTION_QUANTITY165775
Transaction ReferenceTransaction reference descriptive textOutside Processing Manufacturing Transactions.Transaction ReferenceTRANSACTION_REFERENCETRANSACTION_REFERENCE165807
Transaction TypeType of the external cash transaction, either payment or receipt.Outside Processing Manufacturing Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165846
Transaction UOMUnit of measure used in the transactionOutside Processing Manufacturing Transactions.Transaction UOMTRANSACTION_UOMTRANSACTION_UOM165884
Updated By Outside Processing Manufacturing Transactions.Updated ByUPDATED_BYUPDATED_BY166523
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto