Powered by InfoCaptor


Previous Page   Next Page

Blanket Purchase Order Distributions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_BKT_PO_DISTRIBUTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accrual Account IDUnique identifier for Accrual AccountBlanket Purchase Order Distributions.Accrual Account IDACCRUAL_ACCOUNT_IDACCRUAL_ACCOUNT_ID114295
Accrual Account Num Blanket Purchase Order Distributions.Accrual Account NumACCRUAL_ACCOUNT_NUMACCRUAL_ACCOUNT_NUM275754
Accrue On Receipt Flag Blanket Purchase Order Distributions.Accrue On Receipt FlagACCRUE_ON_RECEIPT_FLAGACCRUE_ON_RECEIPT_FLAG275746
Accrued Flag Blanket Purchase Order Distributions.Accrued FlagACCRUED_FLAGACCRUED_FLAG275747
Amount Cancelled Blanket Purchase Order Distributions.Amount CancelledAMOUNT_CANCELLEDAMOUNT_CANCELLED275766
Amount Delivered Blanket Purchase Order Distributions.Amount DeliveredAMOUNT_DELIVEREDAMOUNT_DELIVERED275765
Amount Ordered Blanket Purchase Order Distributions.Amount OrderedAMOUNT_ORDEREDAMOUNT_ORDERED275764
Bill Of Material Resource Blanket Purchase Order Distributions.Bill Of Material ResourceBILL_OF_MATERIAL_RESOURCEBILL_OF_MATERIAL_RESOURCE119837
Bill Of Material Resource IDUnique identifier for Bill Of Material ResourceBlanket Purchase Order Distributions.Bill Of Material Resource IDBILL_OF_MATERIAL_RESOURCE_IDBILL_OF_MATERIAL_RESOURCE_ID119844
Billed Amount Blanket Purchase Order Distributions.Billed AmountBILLED_AMOUNTBILLED_AMOUNT119787
Billed Quantity Blanket Purchase Order Distributions.Billed QuantityBILLED_QUANTITYBILLED_QUANTITY119792
Blanket PO Document NumberBlanket Purchase Order Document NumberBlanket Purchase Order Distributions.Blanket PO Document NumberBLANKET_PO_DOCUMENT_NUMBERBLANKET_PO_DOCUMENT_NUMBER119980
Blanket PO IDUnique identifier for Blanket Purchase OrderBlanket Purchase Order Distributions.Blanket PO IDBLANKET_PO_IDBLANKET_PO_ID119985
Blanket Release IDUnique identifier for Blanket ReleaseBlanket Purchase Order Distributions.Blanket Release IDBLANKET_RELEASE_IDBLANKET_RELEASE_ID119992
Budget Account IDUnique identifier for Budget AccountBlanket Purchase Order Distributions.Budget Account IDBUDGET_ACCOUNT_IDBUDGET_ACCOUNT_ID120283
Budget Account Num Blanket Purchase Order Distributions.Budget Account NumBUDGET_ACCOUNT_NUMBUDGET_ACCOUNT_NUM275753
Cancelled Quantity Blanket Purchase Order Distributions.Cancelled QuantityCANCELLED_QUANTITYCANCELLED_QUANTITY121451
Charge Account IDUnique identifier for Charge AccountBlanket Purchase Order Distributions.Charge Account IDCHARGE_ACCOUNT_IDCHARGE_ACCOUNT_ID121913
Charge Account Num Blanket Purchase Order Distributions.Charge Account NumCHARGE_ACCOUNT_NUMCHARGE_ACCOUNT_NUM275752
Created By Blanket Purchase Order Distributions.Created ByCREATED_BYCREATED_BY125212
Created Date Blanket Purchase Order Distributions.Created DateCREATED_DATECREATED_DATE125387
Created Date - Day Blanket Purchase Order Distributions.Created Date CREATED_DATE_DAY171197
Created Date - Month Blanket Purchase Order Distributions.Created Date CREATED_DATE_MONTH171351
Created Date - Quarter Blanket Purchase Order Distributions.Created Date CREATED_DATE_QUARTER171505
Created Date - Year Blanket Purchase Order Distributions.Created Date CREATED_DATE_YEAR171659
Currency Conversion RateThe currency exchange rate.Blanket Purchase Order Distributions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127112
Currency Conversion Rate DateDate upon which to obtain the currency conversion rateBlanket Purchase Order Distributions.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127133
Currency Conversion Rate Date - Day Blanket Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174010
Currency Conversion Rate Date - Month Blanket Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174050
Currency Conversion Rate Date - Quarter Blanket Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174090
Currency Conversion Rate Date - Year Blanket Purchase Order Distributions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174130
Deliver To Location Blanket Purchase Order Distributions.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128993
Deliver To Location IDUnique identifier for Deliver To LocationBlanket Purchase Order Distributions.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129003
Deliver To Person Blanket Purchase Order Distributions.Deliver To PersonDELIVER_TO_PERSONDELIVER_TO_PERSON129014
Deliver To Person IDUnique identifier for Deliver To PersonBlanket Purchase Order Distributions.Deliver To Person IDDELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID129022
Delivered Quantity Blanket Purchase Order Distributions.Delivered QuantityDELIVERED_QUANTITYDELIVERED_QUANTITY128944
Dest Charge Account Id Blanket Purchase Order Distributions.Dest Charge Account IdDEST_CHARGE_ACCOUNT_IDDEST_CHARGE_ACCOUNT_ID275756
Dest Variance Account Id Blanket Purchase Order Distributions.Dest Variance Account IdDEST_VARIANCE_ACCOUNT_IDDEST_VARIANCE_ACCOUNT_ID275758
Destination Organization Code Blanket Purchase Order Distributions.Destination Organization CodeDESTINATION_ORGANIZATION_CODEDESTINATION_ORGANIZATION_CODE129884
Destination Organization IDUnique identifier for Destination OrganizationBlanket Purchase Order Distributions.Destination Organization IDDESTINATION_ORGANIZATION_IDDESTINATION_ORGANIZATION_ID129893
Destination Organization Name Blanket Purchase Order Distributions.Destination Organization NameDESTINATION_ORGANIZATION_NAMEDESTINATION_ORGANIZATION_NAME129902
Destination Subinventory Blanket Purchase Order Distributions.Destination SubinventoryDESTINATION_SUBINVENTORYDESTINATION_SUBINVENTORY129911
Destination Type Blanket Purchase Order Distributions.Destination TypeDESTINATION_TYPEDESTINATION_TYPE275751
Distribution NumberSequence number of the distributionBlanket Purchase Order Distributions.Distribution NumberDISTRIBUTION_NUMBERDISTRIBUTION_NUMBER130238
Dst Chrg Account Num Blanket Purchase Order Distributions.Dst Chrg Account NumDST_CHRG_ACCOUNT_NUMDST_CHRG_ACCOUNT_NUM275757
Dst Var Account Num Blanket Purchase Order Distributions.Dst Var Account NumDST_VAR_ACCOUNT_NUMDST_VAR_ACCOUNT_NUM275759
Encumbered Amount Blanket Purchase Order Distributions.Encumbered AmountENCUMBERED_AMOUNTENCUMBERED_AMOUNT132676
Encumbered Flag Blanket Purchase Order Distributions.Encumbered FlagENCUMBERED_FLAGENCUMBERED_FLAG275749
Expenditure Item DateDate upon which project work was incurredBlanket Purchase Order Distributions.Expenditure Item DateEXPENDITURE_ITEM_DATEEXPENDITURE_ITEM_DATE133986
Expenditure Item Date - Day Blanket Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_DAY179221
Expenditure Item Date - Month Blanket Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_MONTH179237
Expenditure Item Date - Quarter Blanket Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_QUARTER179253
Expenditure Item Date - Year Blanket Purchase Order Distributions.Expenditure Item Date EXPENDITURE_ITEM_DATE_YEAR179269
Expenditure Organization Code Blanket Purchase Order Distributions.Expenditure Organization CodeEXPENDITURE_ORGANIZATION_CODEEXPENDITURE_ORGANIZATION_CODE133997
Expenditure Organization IDUnique identifier for Expenditure OrganizationBlanket Purchase Order Distributions.Expenditure Organization IDEXPENDITURE_ORGANIZATION_IDEXPENDITURE_ORGANIZATION_ID134014
Expenditure Organization Name Blanket Purchase Order Distributions.Expenditure Organization NameEXPENDITURE_ORGANIZATION_NAMEEXPENDITURE_ORGANIZATION_NAME134021
Funds Check Failure Type Blanket Purchase Order Distributions.Funds Check Failure TypeFUNDS_CHECK_FAILURE_TYPEFUNDS_CHECK_FAILURE_TYPE275750
GL Cancel DateGeneral Ledger Cancel DateBlanket Purchase Order Distributions.GL Cancel DateGL_CANCEL_DATEGL_CANCEL_DATE135201
GL Cancel Date - Day Blanket Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_DAY180779
GL Cancel Date - Month Blanket Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_MONTH180789
GL Cancel Date - Quarter Blanket Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_QUARTER180799
GL Cancel Date - Year Blanket Purchase Order Distributions.GL Cancel Date GL_CANCEL_DATE_YEAR180809
GL Closed DateGeneral Ledger Closed DateBlanket Purchase Order Distributions.GL Closed DateGL_CLOSED_DATEGL_CLOSED_DATE135208
GL Closed Date - Day Blanket Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_DAY180819
GL Closed Date - Month Blanket Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_MONTH180831
GL Closed Date - Quarter Blanket Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_QUARTER180843
GL Closed Date - Year Blanket Purchase Order Distributions.GL Closed Date GL_CLOSED_DATE_YEAR180855
GL Encumbered DateGeneral Ledger Encumbered DateBlanket Purchase Order Distributions.GL Encumbered DateGL_ENCUMBERED_DATEGL_ENCUMBERED_DATE135224
GL Encumbered Date - Day Blanket Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_DAY180909
GL Encumbered Date - Month Blanket Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_MONTH180921
GL Encumbered Date - Quarter Blanket Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_QUARTER180933
GL Encumbered Date - Year Blanket Purchase Order Distributions.GL Encumbered Date GL_ENCUMBERED_DATE_YEAR180945
GL Encumbered Period NameGeneral Ledger Encumbered Period NameBlanket Purchase Order Distributions.GL Encumbered Period NameGL_ENCUMBERED_PERIOD_NAMEGL_ENCUMBERED_PERIOD_NAME135230
Last Updated By Blanket Purchase Order Distributions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139792
Last Updated Date Blanket Purchase Order Distributions.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139966
Last Updated Date - Day Blanket Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_DAY182880
Last Updated Date - Month Blanket Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_MONTH183042
Last Updated Date - Quarter Blanket Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_QUARTER183204
Last Updated Date - Year Blanket Purchase Order Distributions.Last Updated Date LAST_UPDATED_DATE_YEAR183366
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Blanket Purchase Order Distributions.Line NumberLINE_NUMBERLINE_NUMBER144735
Oke Contract Deliverable Id Blanket Purchase Order Distributions.Oke Contract Deliverable IdOKE_CONTRACT_DELIVERABLE_IDOKE_CONTRACT_DELIVERABLE_ID275761
Oke Contract Deliverable Num Blanket Purchase Order Distributions.Oke Contract Deliverable NumOKE_CONTRACT_DELIVERABLE_NUMOKE_CONTRACT_DELIVERABLE_NUM275763
Oke Contract Line Id Blanket Purchase Order Distributions.Oke Contract Line IdOKE_CONTRACT_LINE_IDOKE_CONTRACT_LINE_ID275760
Oke Contract Line Num Blanket Purchase Order Distributions.Oke Contract Line NumOKE_CONTRACT_LINE_NUMOKE_CONTRACT_LINE_NUM275762
Operating Unit IDUnique identifier for Operating UnitBlanket Purchase Order Distributions.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149530
Operating Unit Name Blanket Purchase Order Distributions.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149578
Ordered Quantity Blanket Purchase Order Distributions.Ordered QuantityORDERED_QUANTITYORDERED_QUANTITY149758
PO Line IDUnique identifier for Purchase Order LineBlanket Purchase Order Distributions.PO Line IDPO_LINE_IDPO_LINE_ID155047
Po Distribution IDUnique identifier for Purchase Order DistributionBlanket Purchase Order Distributions.Po Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155013
Po Shipment IDUnique identifier for Purchase Order ShipmentBlanket Purchase Order Distributions.Po Shipment IDPO_SHIPMENT_IDPO_SHIPMENT_ID155097
Prevent Encumbrance Flag Blanket Purchase Order Distributions.Prevent Encumbrance FlagPREVENT_ENCUMBRANCE_FLAGPREVENT_ENCUMBRANCE_FLAG275748
Project Expenditure TypeExpenditure type defined in Oracle Projects denoting expenditure category, revenue category, and expenditure type classesBlanket Purchase Order Distributions.Project Expenditure TypePROJECT_EXPENDITURE_TYPEPROJECT_EXPENDITURE_TYPE156402
Project IDIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Blanket Purchase Order Distributions.Project IDPROJECT_IDPROJECT_ID156504
Project Name Blanket Purchase Order Distributions.Project NamePROJECT_NAMEPROJECT_NAME156587
Release Number Blanket Purchase Order Distributions.Release NumberRELEASE_NUMBERRELEASE_NUMBER158454
Requisition Distribution IDUnique identifier for Requisition DistributionBlanket Purchase Order Distributions.Requisition Distribution IDREQUISITION_DISTRIBUTION_IDREQUISITION_DISTRIBUTION_ID158814
Requisition Distribution Number Blanket Purchase Order Distributions.Requisition Distribution NumberREQ_DISTRIBUTION_NUMBERREQ_DISTRIBUTION_NUMBER158858
Requisition Document Number Blanket Purchase Order Distributions.Requisition Document NumberREQ_DOCUMENT_NUMBERREQ_DOCUMENT_NUMBER158865
Requisition Line Number Blanket Purchase Order Distributions.Requisition Line NumberREQ_LINE_NUMBERREQ_LINE_NUMBER158871
Set Of Books IDThe unique identification number assigned to a set of books.Blanket Purchase Order Distributions.Set Of Books IDSET_OF_BOOKS_IDSET_OF_BOOKS_ID161525
Set Of Books NameThe set of books name.Blanket Purchase Order Distributions.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161585
Shipment Number Blanket Purchase Order Distributions.Shipment NumberSHIPMENT_NUMBERSHIPMENT_NUMBER161680
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.Blanket Purchase Order Distributions.Task IDTASK_IDTASK_ID164604
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.Blanket Purchase Order Distributions.Task NumberTASK_NUMBERTASK_NUMBER164677
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Blanket Purchase Order Distributions.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167048
Unencumbered Amount Blanket Purchase Order Distributions.Unencumbered AmountUNENCUMBERED_AMOUNTUNENCUMBERED_AMOUNT166224
Unencumbered Quantity Blanket Purchase Order Distributions.Unencumbered QuantityUNENCUMBERED_QUANTITYUNENCUMBERED_QUANTITY166230
Variance Account IDUnique identifier for Variance AccountBlanket Purchase Order Distributions.Variance Account IDVARIANCE_ACCOUNT_IDVARIANCE_ACCOUNT_ID167390
Variance Account Num Blanket Purchase Order Distributions.Variance Account NumVARIANCE_ACCOUNT_NUMVARIANCE_ACCOUNT_NUM275755
WIP Entity IDUnique identifier for Work in Process EntityBlanket Purchase Order Distributions.WIP Entity IDWIP_ENTITY_IDWIP_ENTITY_ID167819
WIP Job NameWork in Process Job NameBlanket Purchase Order Distributions.WIP Job NameWIP_JOB_NAMEWIP_JOB_NAME167829
WIP Line CodeWork in Process Line CodeBlanket Purchase Order Distributions.WIP Line CodeWIP_LINE_CODEWIP_LINE_CODE167839
WIP Line IDUnique identifier for Work in Process LineBlanket Purchase Order Distributions.WIP Line IDWIP_LINE_IDWIP_LINE_ID167849
WIP Operation Sequence NumberWork in Process Operation Sequence NumberBlanket Purchase Order Distributions.WIP Operation Sequence NumberWIP_OPERATION_SEQUENCE_NUMBERWIP_OPERATION_SEQUENCE_NUMBER167860
WIP Repetitive Schedule IDUnique identifier for Work in Process Repetitive ScheduleBlanket Purchase Order Distributions.WIP Repetitive Schedule IDWIP_REPETITIVE_SCHEDULE_IDWIP_REPETITIVE_SCHEDULE_ID167873
WIP Resource Sequence NumberWork in Process Resource Sequence NumberBlanket Purchase Order Distributions.WIP Resource Sequence NumberWIP_RESOURCE_SEQUENCE_NUMBERWIP_RESOURCE_SEQUENCE_NUMBER167882
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto