Powered by InfoCaptor


Previous Page   Next Page

Purchase Order Distributions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PO_DISTRIBUTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accrual Account IDUnique identifier for Accrual AccountPurchase Order Distributions.Accrual Account IDACCRUAL_ACCOUNT_IDACCRUAL_ACCOUNT_ID114298
Accrual Account Num Purchase Order Distributions.Accrual Account NumACCRUAL_ACCOUNT_NUMACCRUAL_ACCOUNT_NUM276136
Accrue On Receipt Flag Purchase Order Distributions.Accrue On Receipt FlagACCRUE_ON_RECEIPT_FLAGACCRUE_ON_RECEIPT_FLAG276128
Accrued Flag Purchase Order Distributions.Accrued FlagACCRUED_FLAGACCRUED_FLAG276129
Amount Cancelled Purchase Order Distributions.Amount CancelledAMOUNT_CANCELLEDAMOUNT_CANCELLED276150
Amount Delivered Purchase Order Distributions.Amount DeliveredAMOUNT_DELIVEREDAMOUNT_DELIVERED276149
Amount Ordered Purchase Order Distributions.Amount OrderedAMOUNT_ORDEREDAMOUNT_ORDERED276148
Bill Of Material Resource Purchase Order Distributions.Bill Of Material ResourceBILL_OF_MATERIAL_RESOURCEBILL_OF_MATERIAL_RESOURCE119840
Bill Of Material Resource IDUnique identifier for Bill Of Material ResourcePurchase Order Distributions.Bill Of Material Resource IDBILL_OF_MATERIAL_RESOURCE_IDBILL_OF_MATERIAL_RESOURCE_ID119847
Billed Amount Purchase Order Distributions.Billed AmountBILLED_AMOUNTBILLED_AMOUNT119790
Billed Quantity Purchase Order Distributions.Billed QuantityBILLED_QUANTITYBILLED_QUANTITY119798
Budget Account IDUnique identifier for Budget AccountPurchase Order Distributions.Budget Account IDBUDGET_ACCOUNT_IDBUDGET_ACCOUNT_ID120286
Budget Account Num Purchase Order Distributions.Budget Account NumBUDGET_ACCOUNT_NUMBUDGET_ACCOUNT_NUM276135
Cancelled Quantity Purchase Order Distributions.Cancelled QuantityCANCELLED_QUANTITYCANCELLED_QUANTITY121457
Charge Account IDUnique identifier for Charge AccountPurchase Order Distributions.Charge Account IDCHARGE_ACCOUNT_IDCHARGE_ACCOUNT_ID121917
Charge Account Num Purchase Order Distributions.Charge Account NumCHARGE_ACCOUNT_NUMCHARGE_ACCOUNT_NUM276134
Created By Purchase Order Distributions.Created ByCREATED_BYCREATED_BY125232
Created Date Purchase Order Distributions.Created DateCREATED_DATECREATED_DATE125407
Created Date - Day Purchase Order Distributions.Created Date CREATED_DATE_DAY171237
Created Date - Month Purchase Order Distributions.Created Date CREATED_DATE_MONTH171391
Created Date - Quarter Purchase Order Distributions.Created Date CREATED_DATE_QUARTER171545
Created Date - Year Purchase Order Distributions.Created Date CREATED_DATE_YEAR171699
Currency Conversion RateThe currency exchange rate.Purchase Order Distributions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127125
Currency Conversion Rate DateDate upon which to obtain the currency conversion ratePurchase Order Distributions.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127146
Currency Conversion Rate Date - Day Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174034
Currency Conversion Rate Date - Month Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174074
Currency Conversion Rate Date - Quarter Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174114
Currency Conversion Rate Date - Year Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174154
Deliver To Location Purchase Order Distributions.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128997
Deliver To Location IDUnique identifier for Deliver To LocationPurchase Order Distributions.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129007
Deliver To Person Purchase Order Distributions.Deliver To PersonDELIVER_TO_PERSONDELIVER_TO_PERSON129018
Deliver To Person IDUnique identifier for Deliver To PersonPurchase Order Distributions.Deliver To Person IDDELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID129026
Delivered Quantity Purchase Order Distributions.Delivered QuantityDELIVERED_QUANTITYDELIVERED_QUANTITY128947
Dest Charge Account Id Purchase Order Distributions.Dest Charge Account IdDEST_CHARGE_ACCOUNT_IDDEST_CHARGE_ACCOUNT_ID276138
Dest Variance Account Id Purchase Order Distributions.Dest Variance Account IdDEST_VARIANCE_ACCOUNT_IDDEST_VARIANCE_ACCOUNT_ID276140
Destination Organization Code Purchase Order Distributions.Destination Organization CodeDESTINATION_ORGANIZATION_CODEDESTINATION_ORGANIZATION_CODE129888
Destination Organization IDUnique identifier for Destination OrganizationPurchase Order Distributions.Destination Organization IDDESTINATION_ORGANIZATION_IDDESTINATION_ORGANIZATION_ID129897
Destination Organization Name Purchase Order Distributions.Destination Organization NameDESTINATION_ORGANIZATION_NAMEDESTINATION_ORGANIZATION_NAME129906
Destination Subinventory Purchase Order Distributions.Destination SubinventoryDESTINATION_SUBINVENTORYDESTINATION_SUBINVENTORY129915
Destination Type Purchase Order Distributions.Destination TypeDESTINATION_TYPEDESTINATION_TYPE276133
Distribution NumberSequence number of the distributionPurchase Order Distributions.Distribution NumberDISTRIBUTION_NUMBERDISTRIBUTION_NUMBER130242
Distribution Type Purchase Order Distributions.Distribution TypeDISTRIBUTION_TYPEDISTRIBUTION_TYPE276127
Drop Ship Flag Purchase Order Distributions.Drop Ship FlagDROP_SHIP_FLAGDROP_SHIP_FLAG276146
Dst Chrg Account Num Purchase Order Distributions.Dst Chrg Account NumDST_CHRG_ACCOUNT_NUMDST_CHRG_ACCOUNT_NUM276139
Dst Var Account Num Purchase Order Distributions.Dst Var Account NumDST_VAR_ACCOUNT_NUMDST_VAR_ACCOUNT_NUM276141
Encumbered Amount Purchase Order Distributions.Encumbered AmountENCUMBERED_AMOUNTENCUMBERED_AMOUNT132680
Encumbered Flag Purchase Order Distributions.Encumbered FlagENCUMBERED_FLAGENCUMBERED_FLAG276131
Expenditure Item DateDate upon which project work was incurredPurchase Order Distributions.Expenditure Item DateEXPENDITURE_ITEM_DATEEXPENDITURE_ITEM_DATE133989
Expenditure Item Date - Day Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_DAY179227
Expenditure Item Date - Month Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_MONTH179243
Expenditure Item Date - Quarter Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_QUARTER179259
Expenditure Item Date - Year Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_YEAR179275
Expenditure Organization Code Purchase Order Distributions.Expenditure Organization CodeEXPENDITURE_ORGANIZATION_CODEEXPENDITURE_ORGANIZATION_CODE134000
Expenditure Organization IDUnique identifier for Expenditure OrganizationPurchase Order Distributions.Expenditure Organization IDEXPENDITURE_ORGANIZATION_IDEXPENDITURE_ORGANIZATION_ID134017
Expenditure Organization Name Purchase Order Distributions.Expenditure Organization NameEXPENDITURE_ORGANIZATION_NAMEEXPENDITURE_ORGANIZATION_NAME134024
Funds Check Failure Type Purchase Order Distributions.Funds Check Failure TypeFUNDS_CHECK_FAILURE_TYPEFUNDS_CHECK_FAILURE_TYPE276132
GL Cancel DateGeneral Ledger Cancel DatePurchase Order Distributions.GL Cancel DateGL_CANCEL_DATEGL_CANCEL_DATE135204
GL Cancel Date - Day Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_DAY180785
GL Cancel Date - Month Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_MONTH180795
GL Cancel Date - Quarter Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_QUARTER180805
GL Cancel Date - Year Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_YEAR180815
GL Closed DateGeneral Ledger Closed DatePurchase Order Distributions.GL Closed DateGL_CLOSED_DATEGL_CLOSED_DATE135211
GL Closed Date - Day Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_DAY180825
GL Closed Date - Month Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_MONTH180837
GL Closed Date - Quarter Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_QUARTER180849
GL Closed Date - Year Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_YEAR180861
GL Encumbered DateGeneral Ledger Encumbered DatePurchase Order Distributions.GL Encumbered DateGL_ENCUMBERED_DATEGL_ENCUMBERED_DATE135227
GL Encumbered Date - Day Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_DAY180915
GL Encumbered Date - Month Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_MONTH180927
GL Encumbered Date - Quarter Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_QUARTER180939
GL Encumbered Date - Year Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_YEAR180951
GL Encumbered Period NameGeneral Ledger Encumbered Period NamePurchase Order Distributions.GL Encumbered Period NameGL_ENCUMBERED_PERIOD_NAMEGL_ENCUMBERED_PERIOD_NAME135233
Last Updated By Purchase Order Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139812
Last Updated Date Purchase Order Distributions.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139986
Last Updated Date - Day Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_DAY182920
Last Updated Date - Month Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_MONTH183082
Last Updated Date - Quarter Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_QUARTER183244
Last Updated Date - Year Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_YEAR183406
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Purchase Order Distributions.Line NumberLINE_NUMBERLINE_NUMBER144746
Oke Contract Deliverable Id Purchase Order Distributions.Oke Contract Deliverable IdOKE_CONTRACT_DELIVERABLE_IDOKE_CONTRACT_DELIVERABLE_ID276143
Oke Contract Deliverable Num Purchase Order Distributions.Oke Contract Deliverable NumOKE_CONTRACT_DELIVERABLE_NUMOKE_CONTRACT_DELIVERABLE_NUM276145
Oke Contract Line Id Purchase Order Distributions.Oke Contract Line IdOKE_CONTRACT_LINE_IDOKE_CONTRACT_LINE_ID276142
Oke Contract Line Num Purchase Order Distributions.Oke Contract Line NumOKE_CONTRACT_LINE_NUMOKE_CONTRACT_LINE_NUM276144
Operating Unit IDUnique identifier for Operating UnitPurchase Order Distributions.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149548
Operating Unit Name Purchase Order Distributions.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149596
Ordered Quantity Purchase Order Distributions.Ordered QuantityORDERED_QUANTITYORDERED_QUANTITY149765
Prevent Encumbrance Flag Purchase Order Distributions.Prevent Encumbrance FlagPREVENT_ENCUMBRANCE_FLAGPREVENT_ENCUMBRANCE_FLAG276130
Project Expenditure TypeExpenditure type defined in Oracle Projects denoting expenditure category, revenue category, and expenditure type classesPurchase Order Distributions.Project Expenditure TypePROJECT_EXPENDITURE_TYPEPROJECT_EXPENDITURE_TYPE156405
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Purchase Order Distributions.Project IDPROJECT_IDPROJECT_ID156507
Project Name Purchase Order Distributions.Project NamePROJECT_NAMEPROJECT_NAME156590
Purchase Order Distribution IDUnique identifier for Purchase Order DistributionPurchase Order Distributions.Purchase Order Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155018
Purchase Order Document Number Purchase Order Distributions.Purchase Order Document NumberPO_DOCUMENT_NUMBERPO_DOCUMENT_NUMBER155025
Purchase Order IDUnique identifier for Purchase OrderPurchase Order Distributions.Purchase Order IDPURCHASE_ORDER_IDPURCHASE_ORDER_ID157054
Purchase Order Line IDUnique identifier for Purchase Order LinePurchase Order Distributions.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155058
Purchase Order Shipment IDUnique identifier for Purchase Order ShipmentPurchase Order Distributions.Purchase Order Shipment IDPO_SHIPMENT_IDPO_SHIPMENT_ID155105
Release IDUnique identifier for ReleasePurchase Order Distributions.Release IDRELEASE_IDRELEASE_ID158452
Release Number Purchase Order Distributions.Release NumberRELEASE_NUMBERRELEASE_NUMBER158460
Requisition Distribution IDUnique identifier for Requisition DistributionPurchase Order Distributions.Requisition Distribution IDREQUISITION_DISTRIBUTION_IDREQUISITION_DISTRIBUTION_ID158817
Requisition Distribution Number Purchase Order Distributions.Requisition Distribution NumberREQ_DISTRIBUTION_NUMBERREQ_DISTRIBUTION_NUMBER158862
Requisition Document Number Purchase Order Distributions.Requisition Document NumberREQ_DOCUMENT_NUMBERREQ_DOCUMENT_NUMBER158868
Requisition Line Number Purchase Order Distributions.Requisition Line NumberREQ_LINE_NUMBERREQ_LINE_NUMBER158874
Sales Order Update Date Purchase Order Distributions.Sales Order Update DateSALES_ORDER_UPDATE_DATESALES_ORDER_UPDATE_DATE276147
Set Of Books IDThe unique identification number assigned to a set of books.Purchase Order Distributions.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161533
Set Of Books NameThe set of books name.Purchase Order Distributions.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161593
Shipment Number Purchase Order Distributions.Shipment NumberSHIPMENT_NUMBERSHIPMENT_NUMBER161689
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.Purchase Order Distributions.Task IDTASK_IDTASK_ID164607
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.Purchase Order Distributions.Task NumberTASK_NUMBERTASK_NUMBER164680
Unencumbered Amount Purchase Order Distributions.Unencumbered AmountUNENCUMBERED_AMOUNTUNENCUMBERED_AMOUNT166228
Unencumbered Quantity Purchase Order Distributions.Unencumbered QuantityUNENCUMBERED_QUANTITYUNENCUMBERED_QUANTITY166233
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Purchase Order Distributions.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167065
Variance Account IDUnique identifier for Variance AccountPurchase Order Distributions.Variance Account IDVARIANCE_ACCOUNT_IDVARIANCE_ACCOUNT_ID167393
Variance Account Num Purchase Order Distributions.Variance Account NumVARIANCE_ACCOUNT_NUMVARIANCE_ACCOUNT_NUM276137
WIP Entity IDUnique identifier for Work in Process EntityPurchase Order Distributions.WIP Entity IDWIP_ENTITY_IDWIP_ENTITY_ID167822
WIP Job NameWork in Process Job NamePurchase Order Distributions.WIP Job NameWIP_JOB_NAMEWIP_JOB_NAME167832
WIP Line CodeWork in Process Line CodePurchase Order Distributions.WIP Line CodeWIP_LINE_CODEWIP_LINE_CODE167842
WIP Line IDUnique identifier for Work in Process LinePurchase Order Distributions.WIP Line IDWIP_LINE_IDWIP_LINE_ID167852
WIP Operation Sequence NumberWork in Process Operation Sequence NumberPurchase Order Distributions.WIP Operation Sequence NumberWIP_OPERATION_SEQUENCE_NUMBERWIP_OPERATION_SEQUENCE_NUMBER167863
WIP Repetitive Schedule IDUnique identifier for Work in Process Repetitive SchedulePurchase Order Distributions.WIP Repetitive Schedule IDWIP_REPETITIVE_SCHEDULE_IDWIP_REPETITIVE_SCHEDULE_ID167876
WIP Resource Sequence NumberWork in Process Resource Sequence NumberPurchase Order Distributions.WIP Resource Sequence NumberWIP_RESOURCE_SEQUENCE_NUMBERWIP_RESOURCE_SEQUENCE_NUMBER167885
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
PO Distributions -> Multiple Currency Purchase Order DistributionsPurchase Order Distributions.Purchase Order Distribution ID = Multiple Currency Purchase Order Distributions.Purchase Order Distribution IDAlways exist in master folderNoneNo
Purchase Order Distributions -> Inbound Shipment LinesPurchase Order Distributions.Purchase Order Distribution ID = Inbound Shipment Lines.Purchase Order Distribution IDMight not exist in master folderOuter join on master No
Purchase Order Distributions -> Receiving TransactionsPurchase Order Distributions.Purchase Order Distribution ID = Receiving Transactions.Purchase Order Distribution IDMight not exist in master folderOuter join on master No