Powered by InfoCaptor


Previous Page   Next Page

Planned Purchase Orders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PLAN_PURCHASE_ORDERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Due DateDate by which the supplier should accept the documentPlanned Purchase Orders.Acceptance Due DateACCEPTANCE_DUE_DATEACCEPTANCE_DUE_DATE114035
Acceptance Due Date - Day Planned Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_DAY168253
Acceptance Due Date - Month Planned Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_MONTH168267
Acceptance Due Date - Quarter Planned Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_QUARTER168281
Acceptance Due Date - Year Planned Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_YEAR168295
Acceptance Required Flag Planned Purchase Orders.Acceptance Required FlagACCEPTANCE_REQUIRED_FLAGACCEPTANCE_REQUIRED_FLAG276058
Acknowledgement Date Planned Purchase Orders.Acknowledgement DateACKNOWLEDGEMENT_DATEACKNOWLEDGEMENT_DATE276064
Acknowledgement Type Planned Purchase Orders.Acknowledgement TypeACKNOWLEDGEMENT_TYPEACKNOWLEDGEMENT_TYPE276063
Agreed Amount Planned Purchase Orders.Agreed AmountAGREED_AMOUNTAGREED_AMOUNT115399
Amount Limit Planned Purchase Orders.Amount LimitAMOUNT_LIMITAMOUNT_LIMIT115903
Approval Date Planned Purchase Orders.Approval DateAPPROVAL_DATEAPPROVAL_DATE116327
Approval Date - Day Planned Purchase Orders.Approval Date APPROVAL_DATE_DAY169041
Approval Date - Month Planned Purchase Orders.Approval Date APPROVAL_DATE_MONTH169075
Approval Date - Quarter Planned Purchase Orders.Approval Date APPROVAL_DATE_QUARTER169109
Approval Date - Year Planned Purchase Orders.Approval Date APPROVAL_DATE_YEAR169143
Authorization Status Planned Purchase Orders.Authorization StatusAUTHORIZATION_STATUSAUTHORIZATION_STATUS276050
BOL Planned Purchase Orders.BOLBOLBOL276062
Bill To Location Planned Purchase Orders.Bill To LocationBILL_TO_LOCATIONBILL_TO_LOCATION119933
Bill To Location IDUnique identifier for Bill To LocationPlanned Purchase Orders.Bill To Location IDBILL_TO_LOCATION_IDBILL_TO_LOCATION_ID119941
Buyer Employee Number Planned Purchase Orders.Buyer Employee NumberBUYER_EMPLOYEE_NUMBERBUYER_EMPLOYEE_NUMBER121230
Buyer IDUnique identifier for BuyerPlanned Purchase Orders.Buyer IDBUYER_IDBUYER_ID121243
Buyer Name Planned Purchase Orders.Buyer NameBUYER_NAMEBUYER_NAME121255
Cancel Flag Planned Purchase Orders.Cancel FlagCANCEL_FLAGCANCEL_FLAG276051
Carrier Planned Purchase Orders.CarrierCARRIERCARRIER121567
Carrier Description Planned Purchase Orders.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121580
Carrier Organization Code Planned Purchase Orders.Carrier Organization CodeCARRIER_ORGANIZATION_CODECARRIER_ORGANIZATION_CODE121605
Carrier Organization IDUnique identifier for Carrier OrganizationPlanned Purchase Orders.Carrier Organization IDCARRIER_ORGANIZATION_IDCARRIER_ORGANIZATION_ID121615
Cbc Accounting Date Planned Purchase Orders.Cbc Accounting DateCBC_ACCOUNTING_DATECBC_ACCOUNTING_DATE276068
Closed Date Planned Purchase Orders.Closed DateCLOSED_DATECLOSED_DATE122183
Closed Date - Day Planned Purchase Orders.Closed Date CLOSED_DATE_DAY170529
Closed Date - Month Planned Purchase Orders.Closed Date CLOSED_DATE_MONTH170567
Closed Date - Quarter Planned Purchase Orders.Closed Date CLOSED_DATE_QUARTER170605
Closed Date - Year Planned Purchase Orders.Closed Date CLOSED_DATE_YEAR170645
Closure Status Planned Purchase Orders.Closure StatusCLOSURE_STATUSCLOSURE_STATUS276052
Confirming Order Flag Planned Purchase Orders.Confirming Order FlagCONFIRMING_ORDER_FLAGCONFIRMING_ORDER_FLAG276059
Context Planned Purchase Orders.ContextCONTEXTCONTEXT276061
Created By Planned Purchase Orders.Created ByCREATED_BYCREATED_BY125229
Created Date Planned Purchase Orders.Created DateCREATED_DATECREATED_DATE125404
Created Date - Day Planned Purchase Orders.Created Date CREATED_DATE_DAY171231
Created Date - Month Planned Purchase Orders.Created Date CREATED_DATE_MONTH171385
Created Date - Quarter Planned Purchase Orders.Created Date CREATED_DATE_QUARTER171539
Created Date - Year Planned Purchase Orders.Created Date CREATED_DATE_YEAR171693
CurrencyThe currency for an account balance.Planned Purchase Orders.CurrencyCURRENCYCURRENCY126951
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Planned Purchase Orders.Currency CodeCURRENCY_CODECURRENCY_CODE127052
Currency Conversion RateThe currency exchange rate.Planned Purchase Orders.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127122
Currency Conversion Rate DateDate upon which to obtain the currency conversion ratePlanned Purchase Orders.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127143
Currency Conversion Rate Date - Day Planned Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174028
Currency Conversion Rate Date - Month Planned Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174068
Currency Conversion Rate Date - Quarter Planned Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174108
Currency Conversion Rate Date - Year Planned Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174148
Currency Conversion Rate Type Planned Purchase Orders.Currency Conversion Rate TypeCURRENCY_CONVERSION_RATE_TYPECURRENCY_CONVERSION_RATE_TYPE127160
DescriptionThe accounting period description.Planned Purchase Orders.DescriptionDESCRIPTIONDESCRIPTION129826
Document Creation Method Planned Purchase Orders.Document Creation MethodDOCUMENT_CREATION_METHODDOCUMENT_CREATION_METHOD276069
Document NumberThe journal entry document number.Planned Purchase Orders.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130346
EDI Type Planned Purchase Orders.EDI TypeEDI_TYPEEDI_TYPE276066
Electronic Data Interchange Processed FlagElectronic Data Interchange (EDI) Processed flagPlanned Purchase Orders.Electronic Data Interchange Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG130723
Electronic Data Interchange Processed StatusElectronic Data Interchange (EDI) Processed StatusPlanned Purchase Orders.Electronic Data Interchange Processed StatusEDI_PROCESSED_STATUSEDI_PROCESSED_STATUS130728
End Effective DateThe date after which an account becomes inactive.Planned Purchase Orders.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133125
End Effective Date - Day Planned Purchase Orders.End Effective Date END_EFFECTIVE_DATE_DAY178629
End Effective Date - Month Planned Purchase Orders.End Effective Date END_EFFECTIVE_DATE_MONTH178725
End Effective Date - Quarter Planned Purchase Orders.End Effective Date END_EFFECTIVE_DATE_QUARTER178821
End Effective Date - Year Planned Purchase Orders.End Effective Date END_EFFECTIVE_DATE_YEAR178917
Error Message Planned Purchase Orders.Error MessageERROR_MESSAGEERROR_MESSAGE276065
Firm Status Planned Purchase Orders.Firm StatusFIRM_STATUSFIRM_STATUS276053
Free On Board Point Planned Purchase Orders.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276057
Freight Term Planned Purchase Orders.Freight TermFREIGHT_TERMFREIGHT_TERM276056
Frozen Flag Planned Purchase Orders.Frozen FlagFROZEN_FLAGFROZEN_FLAG276054
Hold Flag Planned Purchase Orders.Hold FlagHOLD_FLAGHOLD_FLAG276055
Last Printed Date Planned Purchase Orders.Last Printed DateLAST_PRINTED_DATELAST_PRINTED_DATE138588
Last Printed Date - Day Planned Purchase Orders.Last Printed Date LAST_PRINTED_DATE_DAY182376
Last Printed Date - Month Planned Purchase Orders.Last Printed Date LAST_PRINTED_DATE_MONTH182396
Last Printed Date - Quarter Planned Purchase Orders.Last Printed Date LAST_PRINTED_DATE_QUARTER182416
Last Printed Date - Year Planned Purchase Orders.Last Printed Date LAST_PRINTED_DATE_YEAR182436
Last Updated By Planned Purchase Orders.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139809
Last Updated Date Planned Purchase Orders.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139983
Last Updated Date - Day Planned Purchase Orders.Last Updated Date LAST_UPDATED_DATE_DAY182914
Last Updated Date - Month Planned Purchase Orders.Last Updated Date LAST_UPDATED_DATE_MONTH183076
Last Updated Date - Quarter Planned Purchase Orders.Last Updated Date LAST_UPDATED_DATE_QUARTER183238
Last Updated Date - Year Planned Purchase Orders.Last Updated Date LAST_UPDATED_DATE_YEAR183400
Minimum Release AmountThe minimum amount buyers can release for each releasePlanned Purchase Orders.Minimum Release AmountMINIMUM_RELEASE_AMOUNTMINIMUM_RELEASE_AMOUNT147158
Modus Order Number Planned Purchase Orders.Modus Order NumberMODUS_ORDER_NUMBERMODUS_ORDER_NUMBER276067
Operating Unit IDUnique identifier for Operating UnitPlanned Purchase Orders.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149545
Operating Unit Name Planned Purchase Orders.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149593
Pay On Planned Purchase Orders.Pay OnPAY_ONPAY_ON276060
Payment Terms IDUnique identifier for Payment TermsPlanned Purchase Orders.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152265
Payment Terms Name Planned Purchase Orders.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152281
Planned Purchase Order IDUnique identifier for Planned Purchase OrderPlanned Purchase Orders.Planned Purchase Order IDPLANNED_PO_IDPLANNED_PO_ID154213
Print CountNumber of times batch ticket was printed.Planned Purchase Orders.Print CountPRINT_COUNTPRINT_COUNT155639
Rate Type Description Planned Purchase Orders.Rate Type DescriptionRATE_TYPE_DESCRIPTIONRATE_TYPE_DESCRIPTION157645
Rate Type Name Planned Purchase Orders.Rate Type NameRATE_TYPE_NAMERATE_TYPE_NAME157660
Receiver NoteNote to receiverPlanned Purchase Orders.Receiver NoteRECEIVER_NOTERECEIVER_NOTE158058
Revised Date Planned Purchase Orders.Revised DateREVISED_DATEREVISED_DATE159499
Revision NumberDocument revision numberPlanned Purchase Orders.Revision NumberREVISION_NUMBERREVISION_NUMBER159535
Ship To Location Planned Purchase Orders.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161922
Ship To Location IDUnique identifier for Ship To LocationPlanned Purchase Orders.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161949
Start Effective DateThe date on which an account becomes active.Planned Purchase Orders.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163283
Start Effective Date - Day Planned Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_DAY191155
Start Effective Date - Month Planned Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_MONTH191241
Start Effective Date - Quarter Planned Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_QUARTER191327
Start Effective Date - Year Planned Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_YEAR191413
Supplier Contact IDUnique identifier for Supplier ContactPlanned Purchase Orders.Supplier Contact IDSUPPLIER_CONTACT_IDSUPPLIER_CONTACT_ID164177
Supplier Contact Name Planned Purchase Orders.Supplier Contact NameSUPPLIER_CONTACT_NAMESUPPLIER_CONTACT_NAME164187
Supplier IDUnique identifier for SupplierPlanned Purchase Orders.Supplier IDSUPPLIER_IDSUPPLIER_ID164213
Supplier Name Planned Purchase Orders.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164257
Supplier NoteNote to supplierPlanned Purchase Orders.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164273
Supplier Site Planned Purchase Orders.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164304
Supplier Site IDUnique identifier for Supplier SitePlanned Purchase Orders.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164328
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Planned Purchase Orders.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167062
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Planned PO -> Planned Purchase Order Scheduled Shipment DistributionsPlanned Purchase Orders.Planned Purchase Order ID = Planned Purchase Order Scheduled Shipment Distributions.Planned Purchase Order IDAlways exist in master folderNoneNo
Planned Purchase Orders -> Planned Purchase Order Line ShipmentsPlanned Purchase Orders.Planned Purchase Order ID = Planned Purchase Order Line Shipments.Planned Purchase Order IDAlways exist in master folderNoneNo
Planned Purchase Orders -> Planned Purchase Order ReleasesPlanned Purchase Orders.Planned Purchase Order ID = Planned Purchase Order Releases.Planned Purchase Order IDAlways exist in master folderNoneNo
Planned Purchase Orders -> Planned Purchase Order Scheduled ShipmentsPlanned Purchase Orders.Planned Purchase Order ID = Planned Purhase Order Scheduled Shipments.Planned Purchase Order IDAlways exist in master folderNoneNo