Powered by InfoCaptor


Previous Page   Next Page

Planned Purchase Order Distributions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PLAN_PO_DISTRIBUTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accrual Account IDUnique identifier for Accrual AccountPlanned Purchase Order Distributions.Accrual Account IDACCRUAL_ACCOUNT_IDACCRUAL_ACCOUNT_ID114296
Accrual Account Num Planned Purchase Order Distributions.Accrual Account NumACCRUAL_ACCOUNT_NUMACCRUAL_ACCOUNT_NUM275936
Accrue On Receipt Flag Planned Purchase Order Distributions.Accrue On Receipt FlagACCRUE_ON_RECEIPT_FLAGACCRUE_ON_RECEIPT_FLAG275928
Accrued Flag Planned Purchase Order Distributions.Accrued FlagACCRUED_FLAGACCRUED_FLAG275929
Bill Of Material Resource Planned Purchase Order Distributions.Bill Of Material ResourceBILL_OF_MATERIAL_RESOURCEBILL_OF_MATERIAL_RESOURCE119838
Bill Of Material Resource IDUnique identifier for Bill Of Material ResourcePlanned Purchase Order Distributions.Bill Of Material Resource IDBILL_OF_MATERIAL_RESOURCE_IDBILL_OF_MATERIAL_RESOURCE_ID119845
Billed Amount Planned Purchase Order Distributions.Billed AmountBILLED_AMOUNTBILLED_AMOUNT119788
Billed Quantity Planned Purchase Order Distributions.Billed QuantityBILLED_QUANTITYBILLED_QUANTITY119794
Budget Account IDUnique identifier for Budget AccountPlanned Purchase Order Distributions.Budget Account IDBUDGET_ACCOUNT_IDBUDGET_ACCOUNT_ID120284
Budget Account Num Planned Purchase Order Distributions.Budget Account NumBUDGET_ACCOUNT_NUMBUDGET_ACCOUNT_NUM275935
Cancelled Quantity Planned Purchase Order Distributions.Cancelled QuantityCANCELLED_QUANTITYCANCELLED_QUANTITY121453
Charge Account IDUnique identifier for Charge AccountPlanned Purchase Order Distributions.Charge Account IDCHARGE_ACCOUNT_IDCHARGE_ACCOUNT_ID121915
Charge Account Num Planned Purchase Order Distributions.Charge Account NumCHARGE_ACCOUNT_NUMCHARGE_ACCOUNT_NUM275934
Created By Planned Purchase Order Distributions.Created ByCREATED_BYCREATED_BY125223
Created Date Planned Purchase Order Distributions.Created DateCREATED_DATECREATED_DATE125398
Created Date - Day Planned Purchase Order Distributions.Created Date CREATED_DATE_DAY171219
Created Date - Month Planned Purchase Order Distributions.Created Date CREATED_DATE_MONTH171373
Created Date - Quarter Planned Purchase Order Distributions.Created Date CREATED_DATE_QUARTER171527
Created Date - Year Planned Purchase Order Distributions.Created Date CREATED_DATE_YEAR171681
Currency Conversion RateThe currency exchange rate.Planned Purchase Order Distributions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127120
Currency Conversion Rate DateDate upon which to obtain the currency conversion ratePlanned Purchase Order Distributions.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127141
Deliver To Location Planned Purchase Order Distributions.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128995
Deliver To Location IDUnique identifier for Deliver To LocationPlanned Purchase Order Distributions.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129005
Deliver To Person Planned Purchase Order Distributions.Deliver To PersonDELIVER_TO_PERSONDELIVER_TO_PERSON129016
Deliver To Person IDUnique identifier for Deliver To PersonPlanned Purchase Order Distributions.Deliver To Person IDDELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID129024
Delivered Quantity Planned Purchase Order Distributions.Delivered QuantityDELIVERED_QUANTITYDELIVERED_QUANTITY128945
Dest Charge Account Id Planned Purchase Order Distributions.Dest Charge Account IdDEST_CHARGE_ACCOUNT_IDDEST_CHARGE_ACCOUNT_ID275938
Dest Variance Account Id Planned Purchase Order Distributions.Dest Variance Account IdDEST_VARIANCE_ACCOUNT_IDDEST_VARIANCE_ACCOUNT_ID275940
Destination Organization Code Planned Purchase Order Distributions.Destination Organization CodeDESTINATION_ORGANIZATION_CODEDESTINATION_ORGANIZATION_CODE129886
Destination Organization IDUnique identifier for Destination OrganizationPlanned Purchase Order Distributions.Destination Organization IDDESTINATION_ORGANIZATION_IDDESTINATION_ORGANIZATION_ID129895
Destination Organization Name Planned Purchase Order Distributions.Destination Organization NameDESTINATION_ORGANIZATION_NAMEDESTINATION_ORGANIZATION_NAME129904
Destination Subinventory Planned Purchase Order Distributions.Destination SubinventoryDESTINATION_SUBINVENTORYDESTINATION_SUBINVENTORY129913
Destination Type Planned Purchase Order Distributions.Destination TypeDESTINATION_TYPEDESTINATION_TYPE275933
Distribution NumberSequence number of the distributionPlanned Purchase Order Distributions.Distribution NumberDISTRIBUTION_NUMBERDISTRIBUTION_NUMBER130240
Dst Chrg Account Num Planned Purchase Order Distributions.Dst Chrg Account NumDST_CHRG_ACCOUNT_NUMDST_CHRG_ACCOUNT_NUM275939
Dst Var Account Num Planned Purchase Order Distributions.Dst Var Account NumDST_VAR_ACCOUNT_NUMDST_VAR_ACCOUNT_NUM275941
Encumbered Amount Planned Purchase Order Distributions.Encumbered AmountENCUMBERED_AMOUNTENCUMBERED_AMOUNT132678
Encumbered Flag Planned Purchase Order Distributions.Encumbered FlagENCUMBERED_FLAGENCUMBERED_FLAG275931
Expenditure Item DateDate upon which project work was incurredPlanned Purchase Order Distributions.Expenditure Item DateEXPENDITURE_ITEM_DATEEXPENDITURE_ITEM_DATE133987
Expenditure Item Date - Day Planned Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_DAY179223
Expenditure Item Date - Month Planned Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_MONTH179239
Expenditure Item Date - Quarter Planned Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_QUARTER179255
Expenditure Item Date - Year Planned Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_YEAR179271
Expenditure Organization Code Planned Purchase Order Distributions.Expenditure Organization CodeEXPENDITURE_ORGANIZATION_CODEEXPENDITURE_ORGANIZATION_CODE133998
Expenditure Organization IDUnique identifier for Expenditure OrganizationPlanned Purchase Order Distributions.Expenditure Organization IDEXPENDITURE_ORGANIZATION_IDEXPENDITURE_ORGANIZATION_ID134015
Expenditure Organization Name Planned Purchase Order Distributions.Expenditure Organization NameEXPENDITURE_ORGANIZATION_NAMEEXPENDITURE_ORGANIZATION_NAME134022
Funds Check Failure Type Planned Purchase Order Distributions.Funds Check Failure TypeFUNDS_CHECK_FAILURE_TYPEFUNDS_CHECK_FAILURE_TYPE275932
GL Cancel DateGeneral Ledger Cancel DatePlanned Purchase Order Distributions.GL Cancel DateGL_CANCEL_DATEGL_CANCEL_DATE135202
GL Cancel Date - Day Planned Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_DAY180781
GL Cancel Date - Month Planned Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_MONTH180791
GL Cancel Date - Quarter Planned Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_QUARTER180801
GL Cancel Date - Year Planned Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_YEAR180811
GL Closed DateGeneral Ledger Closed DatePlanned Purchase Order Distributions.GL Closed DateGL_CLOSED_DATEGL_CLOSED_DATE135209
GL Closed Date - Day Planned Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_DAY180821
GL Closed Date - Month Planned Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_MONTH180833
GL Closed Date - Quarter Planned Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_QUARTER180845
GL Closed Date - Year Planned Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_YEAR180857
GL Encumbered DateGeneral Ledger Encumbered DatePlanned Purchase Order Distributions.GL Encumbered DateGL_ENCUMBERED_DATEGL_ENCUMBERED_DATE135225
GL Encumbered Date - Day Planned Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_DAY180911
GL Encumbered Date - Month Planned Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_MONTH180923
GL Encumbered Date - Quarter Planned Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_QUARTER180935
GL Encumbered Date - Year Planned Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_YEAR180947
GL Encumbered Period NameGeneral Ledger Encumbered Period NamePlanned Purchase Order Distributions.GL Encumbered Period NameGL_ENCUMBERED_PERIOD_NAMEGL_ENCUMBERED_PERIOD_NAME135231
Last Updated By Planned Purchase Order Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139803
Last Updated Date Planned Purchase Order Distributions.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139977
Last Updated Date - Day Planned Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_DAY182902
Last Updated Date - Month Planned Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_MONTH183064
Last Updated Date - Quarter Planned Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_QUARTER183226
Last Updated Date - Year Planned Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_YEAR183388
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Planned Purchase Order Distributions.Line NumberLINE_NUMBERLINE_NUMBER144741
Oke Contract Deliverable Id Planned Purchase Order Distributions.Oke Contract Deliverable IdOKE_CONTRACT_DELIVERABLE_IDOKE_CONTRACT_DELIVERABLE_ID275943
Oke Contract Deliverable Num Planned Purchase Order Distributions.Oke Contract Deliverable NumOKE_CONTRACT_DELIVERABLE_NUMOKE_CONTRACT_DELIVERABLE_NUM275945
Oke Contract Line Id Planned Purchase Order Distributions.Oke Contract Line IdOKE_CONTRACT_LINE_IDOKE_CONTRACT_LINE_ID275942
Oke Contract Line Num Planned Purchase Order Distributions.Oke Contract Line NumOKE_CONTRACT_LINE_NUMOKE_CONTRACT_LINE_NUM275944
Operating Unit IDUnique identifier for Operating UnitPlanned Purchase Order Distributions.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149539
Operating Unit Name Planned Purchase Order Distributions.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149587
Ordered Quantity Planned Purchase Order Distributions.Ordered QuantityORDERED_QUANTITYORDERED_QUANTITY149760
Planned Purchase Order Document Number Planned Purchase Order Distributions.Planned Purchase Order Document NumberPLANNED_PO_DOCUMENT_NUMBERPLANNED_PO_DOCUMENT_NUMBER154201
Planned Purchase Order IDUnique identifier for Planned Purchase OrderPlanned Purchase Order Distributions.Planned Purchase Order IDPLANNED_PO_IDPLANNED_PO_ID154207
Prevent Encumbrance Flag Planned Purchase Order Distributions.Prevent Encumbrance FlagPREVENT_ENCUMBRANCE_FLAGPREVENT_ENCUMBRANCE_FLAG275930
Project Expenditure TypeExpenditure type defined in Oracle Projects denoting expenditure category, revenue category, and expenditure type classesPlanned Purchase Order Distributions.Project Expenditure TypePROJECT_EXPENDITURE_TYPEPROJECT_EXPENDITURE_TYPE156403
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Planned Purchase Order Distributions.Project IDPROJECT_IDPROJECT_ID156505
Project Name Planned Purchase Order Distributions.Project NamePROJECT_NAMEPROJECT_NAME156588
Purchase Order Distribution IDUnique identifier for Purchase Order DistributionPlanned Purchase Order Distributions.Purchase Order Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155016
Purchase Order Line IDUnique identifier for Purchase Order LinePlanned Purchase Order Distributions.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155053
Purchase Order Shipment IDUnique identifier for Purchase Order ShipmentPlanned Purchase Order Distributions.Purchase Order Shipment IDPO_SHIPMENT_IDPO_SHIPMENT_ID155101
Requisition Distribution IDUnique identifier for Requisition DistributionPlanned Purchase Order Distributions.Requisition Distribution IDREQUISITION_DISTRIBUTION_IDREQUISITION_DISTRIBUTION_ID158815
Requisition Distribution Number Planned Purchase Order Distributions.Requisition Distribution NumberREQ_DISTRIBUTION_NUMBERREQ_DISTRIBUTION_NUMBER158860
Requisition Document Number Planned Purchase Order Distributions.Requisition Document NumberREQ_DOCUMENT_NUMBERREQ_DOCUMENT_NUMBER158866
Requisition Line Number Planned Purchase Order Distributions.Requisition Line NumberREQ_LINE_NUMBERREQ_LINE_NUMBER158872
Set Of Books IDThe unique identification number assigned to a set of books.Planned Purchase Order Distributions.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161531
Set Of Books NameThe set of books name.Planned Purchase Order Distributions.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161591
Shipment Number Planned Purchase Order Distributions.Shipment NumberSHIPMENT_NUMBERSHIPMENT_NUMBER161685
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.Planned Purchase Order Distributions.Task IDTASK_IDTASK_ID164605
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.Planned Purchase Order Distributions.Task NumberTASK_NUMBERTASK_NUMBER164678
Unencumbered Amount Planned Purchase Order Distributions.Unencumbered AmountUNENCUMBERED_AMOUNTUNENCUMBERED_AMOUNT166226
Unencumbered Quantity Planned Purchase Order Distributions.Unencumbered QuantityUNENCUMBERED_QUANTITYUNENCUMBERED_QUANTITY166231
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Planned Purchase Order Distributions.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167056
Variance Account IDUnique identifier for Variance AccountPlanned Purchase Order Distributions.Variance Account IDVARIANCE_ACCOUNT_IDVARIANCE_ACCOUNT_ID167391
Variance Account Num Planned Purchase Order Distributions.Variance Account NumVARIANCE_ACCOUNT_NUMVARIANCE_ACCOUNT_NUM275937
WIP Entity IDUnique identifier for Work in Process EntityPlanned Purchase Order Distributions.WIP Entity IDWIP_ENTITY_IDWIP_ENTITY_ID167820
WIP Job NameWork in Process Job NamePlanned Purchase Order Distributions.WIP Job NameWIP_JOB_NAMEWIP_JOB_NAME167830
WIP Line CodeWork in Process Line CodePlanned Purchase Order Distributions.WIP Line CodeWIP_LINE_CODEWIP_LINE_CODE167840
WIP Line IDUnique identifier for Work in Process LinePlanned Purchase Order Distributions.WIP Line IDWIP_LINE_IDWIP_LINE_ID167850
WIP Operation Sequence NumberWork in Process Operation Sequence NumberPlanned Purchase Order Distributions.WIP Operation Sequence NumberWIP_OPERATION_SEQUENCE_NUMBERWIP_OPERATION_SEQUENCE_NUMBER167861
WIP Repetitive Schedule IDUnique identifier for Work in Process Repetitive SchedulePlanned Purchase Order Distributions.WIP Repetitive Schedule IDWIP_REPETITIVE_SCHEDULE_IDWIP_REPETITIVE_SCHEDULE_ID167874
WIP Resource Sequence NumberWork in Process Resource Sequence NumberPlanned Purchase Order Distributions.WIP Resource Sequence NumberWIP_RESOURCE_SEQUENCE_NUMBERWIP_RESOURCE_SEQUENCE_NUMBER167883
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto