Powered by InfoCaptor


Previous Page   Next Page

Planned Purchase Order Releases
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PLAN_PO_RELEASESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Due Date Planned Purchase Order Releases.Acceptance Due DateACCEPTANCE_DUE_DATEACCEPTANCE_DUE_DATE114034
Acceptance Due Date - Day Planned Purchase Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_DAY168251
Acceptance Due Date - Month Planned Purchase Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_MONTH168265
Acceptance Due Date - Quarter Planned Purchase Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_QUARTER168279
Acceptance Due Date - Year Planned Purchase Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_YEAR168293
Acceptance Required Flag Planned Purchase Order Releases.Acceptance Required FlagACCEPTANCE_REQUIRED_FLAGACCEPTANCE_REQUIRED_FLAG275997
Acknowledgement Date Planned Purchase Order Releases.Acknowledgement DateACKNOWLEDGEMENT_DATEACKNOWLEDGEMENT_DATE276003
Acknowledgement Type Planned Purchase Order Releases.Acknowledgement TypeACKNOWLEDGEMENT_TYPEACKNOWLEDGEMENT_TYPE276002
Approval Date Planned Purchase Order Releases.Approval DateAPPROVAL_DATEAPPROVAL_DATE116325
Approval Date - Day Planned Purchase Order Releases.Approval Date APPROVAL_DATE_DAY169037
Approval Date - Month Planned Purchase Order Releases.Approval Date APPROVAL_DATE_MONTH169071
Approval Date - Quarter Planned Purchase Order Releases.Approval Date APPROVAL_DATE_QUARTER169105
Approval Date - Year Planned Purchase Order Releases.Approval Date APPROVAL_DATE_YEAR169139
Authorization Status Planned Purchase Order Releases.Authorization StatusAUTHORIZATION_STATUSAUTHORIZATION_STATUS275991
Buyer Employee Number Planned Purchase Order Releases.Buyer Employee NumberBUYER_EMPLOYEE_NUMBERBUYER_EMPLOYEE_NUMBER121229
Buyer IDUnique identifier for BuyerPlanned Purchase Order Releases.Buyer IDBUYER_IDBUYER_ID121242
Buyer Name Planned Purchase Order Releases.Buyer NameBUYER_NAMEBUYER_NAME121254
Cancel Flag Planned Purchase Order Releases.Cancel FlagCANCEL_FLAGCANCEL_FLAG275992
Cancelled By Planned Purchase Order Releases.Cancelled ByCANCELLED_BYCANCELLED_BY121427
Cancelled By Employee Name Planned Purchase Order Releases.Cancelled By Employee NameCANCELLED_BY_EMPLOYEE_NAMECANCELLED_BY_EMPLOYEE_NAME121433
Cancelled By Employee Number Planned Purchase Order Releases.Cancelled By Employee NumberCANCELLED_BY_EMPLOYEE_NUMBERCANCELLED_BY_EMPLOYEE_NUMBER121439
Cbc Accounting Date Planned Purchase Order Releases.Cbc Accounting DateCBC_ACCOUNTING_DATECBC_ACCOUNTING_DATE276006
Closure Status Planned Purchase Order Releases.Closure StatusCLOSURE_STATUSCLOSURE_STATUS275993
Context Planned Purchase Order Releases.ContextCONTEXTCONTEXT275999
Created By Planned Purchase Order Releases.Created ByCREATED_BYCREATED_BY125226
Created Date Planned Purchase Order Releases.Created DateCREATED_DATECREATED_DATE125401
Created Date - Day Planned Purchase Order Releases.Created Date CREATED_DATE_DAY171225
Created Date - Month Planned Purchase Order Releases.Created Date CREATED_DATE_MONTH171379
Created Date - Quarter Planned Purchase Order Releases.Created Date CREATED_DATE_QUARTER171533
Created Date - Year Planned Purchase Order Releases.Created Date CREATED_DATE_YEAR171687
CurrencyThe currency for an account balance.Planned Purchase Order Releases.CurrencyCURRENCYCURRENCY126950
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Planned Purchase Order Releases.Currency CodeCURRENCY_CODECURRENCY_CODE127051
EDI Type Planned Purchase Order Releases.EDI TypeEDI_TYPEEDI_TYPE276005
Edi Processed FlagElectronic Data Interchange (EDI) Processed flagPlanned Purchase Order Releases.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG130722
Error Message Planned Purchase Order Releases.Error MessageERROR_MESSAGEERROR_MESSAGE276004
Firm Status Planned Purchase Order Releases.Firm StatusFIRM_STATUSFIRM_STATUS275994
Frozen Flag Planned Purchase Order Releases.Frozen FlagFROZEN_FLAGFROZEN_FLAG275995
Hold Flag Planned Purchase Order Releases.Hold FlagHOLD_FLAGHOLD_FLAG275996
Last Printed Date Planned Purchase Order Releases.Last Printed DateLAST_PRINTED_DATELAST_PRINTED_DATE138587
Last Printed Date - Day Planned Purchase Order Releases.Last Printed Date LAST_PRINTED_DATE_DAY182374
Last Printed Date - Month Planned Purchase Order Releases.Last Printed Date LAST_PRINTED_DATE_MONTH182394
Last Printed Date - Quarter Planned Purchase Order Releases.Last Printed Date LAST_PRINTED_DATE_QUARTER182414
Last Printed Date - Year Planned Purchase Order Releases.Last Printed Date LAST_PRINTED_DATE_YEAR182434
Last Updated By Planned Purchase Order Releases.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139806
Last Updated Date Planned Purchase Order Releases.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139980
Last Updated Date - Day Planned Purchase Order Releases.Last Updated Date LAST_UPDATED_DATE_DAY182908
Last Updated Date - Month Planned Purchase Order Releases.Last Updated Date LAST_UPDATED_DATE_MONTH183070
Last Updated Date - Quarter Planned Purchase Order Releases.Last Updated Date LAST_UPDATED_DATE_QUARTER183232
Last Updated Date - Year Planned Purchase Order Releases.Last Updated Date LAST_UPDATED_DATE_YEAR183394
Modus Order Number Planned Purchase Order Releases.Modus Order NumberMODUS_ORDER_NUMBERMODUS_ORDER_NUMBER276001
OPM Organization Planned Purchase Order Releases.OPM OrganizationOPM_ORGANIZATIONOPM_ORGANIZATION276000
Operating Unit IDUnique identifier for Operating UnitPlanned Purchase Order Releases.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149542
Operating Unit Name Planned Purchase Order Releases.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149590
Pay On Planned Purchase Order Releases.Pay OnPAY_ONPAY_ON275998
Payment Card IDUnique identifier for Payment CardPlanned Purchase Order Releases.Payment Card IDPCARD_IDPCARD_ID152636
Payment Card Number Planned Purchase Order Releases.Payment Card NumberPCARD_NUMBERPCARD_NUMBER152640
Planned Purchase Order Document Number Planned Purchase Order Releases.Planned Purchase Order Document NumberPLANNED_PO_DOCUMENT_NUMBERPLANNED_PO_DOCUMENT_NUMBER154204
Planned Purchase Order IDUnique identifier for Planned Purchase OrderPlanned Purchase Order Releases.Planned Purchase Order IDPLANNED_PO_IDPLANNED_PO_ID154210
Planned Purchase Order Release IDUnique identifier for Planned Purchase Order ReleasePlanned Purchase Order Releases.Planned Purchase Order Release IDPLANNED_PO_RELEASE_IDPLANNED_PO_RELEASE_ID154214
Print CountNumber of times batch ticket was printed.Planned Purchase Order Releases.Print CountPRINT_COUNTPRINT_COUNT155638
Release Date Planned Purchase Order Releases.Release DateRELEASE_DATERELEASE_DATE158451
Release Date - Day Planned Purchase Order Releases.Release Date RELEASE_DATE_DAY189652
Release Date - Month Planned Purchase Order Releases.Release Date RELEASE_DATE_MONTH189656
Release Date - Quarter Planned Purchase Order Releases.Release Date RELEASE_DATE_QUARTER189660
Release Date - Year Planned Purchase Order Releases.Release Date RELEASE_DATE_YEAR189664
Release NumberSequence number of the releasePlanned Purchase Order Releases.Release NumberRELEASE_NUMBERRELEASE_NUMBER158457
Revised Date Planned Purchase Order Releases.Revised DateREVISED_DATEREVISED_DATE159498
Revision NumberDocument revision numberPlanned Purchase Order Releases.Revision NumberREVISION_NUMBERREVISION_NUMBER159534
Supplier IDUnique identifier for SupplierPlanned Purchase Order Releases.Supplier IDSUPPLIER_IDSUPPLIER_ID164212
Supplier Name Planned Purchase Order Releases.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164256
Supplier NoteNote to supplierPlanned Purchase Order Releases.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164272
Supplier Site Planned Purchase Order Releases.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164303
Supplier Site IDUnique identifier for Supplier SitePlanned Purchase Order Releases.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164327
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Planned Purchase Order Releases.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167059
Vendor Order Num Planned Purchase Order Releases.Vendor Order NumVENDOR_ORDER_NUMVENDOR_ORDER_NUM276007
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Planned PO Releases -> Planned PO Scheduled Shipment DistributionsPlanned Purchase Order Releases.Planned Purchase Order Release ID = Planned Purchase Order Scheduled Shipment Distributions.Planned Release IDAlways exist in master folderNoneNo
Planned PO Releases -> Planned Purchase Order Scheduled ShipmentsPlanned Purchase Order Releases.Planned Purchase Order Release ID = Planned Purhase Order Scheduled Shipments.Planned Release IDAlways exist in master folderNoneNo
Planned Purchase Order Releases -> Inbound Shipment LinesPlanned Purchase Order Releases.Planned Purchase Order Release ID = Inbound Shipment Lines.Purchase Order Release NumberMight not exist in master folderOuter join on master No
Planned Purchase Order Releases -> Purchase Order DistributionsPlanned Purchase Order Releases.Planned Purchase Order Release ID = Purchase Order Distributions.Release IDMight not exist in master folderOuter join on master No
Planned Purchase Order Releases -> Purchase Order Line ShipmentsPlanned Purchase Order Releases.Planned Purchase Order Release ID = Purchase Order Line Shipments.Release IDMight not exist in master folderOuter join on master No
Planned Purchase Order Releases -> Receiving TransactionsPlanned Purchase Order Releases.Planned Purchase Order Release ID = Receiving Transactions.Purchase Order Release IDMight not exist in master folderOuter join on master No