Powered by InfoCaptor


Previous Page   Next Page

Blanket Purcahse Order Releases
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_BKT_PO_RELEASESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Due DateDate by which the supplier should accept the blanket releaseBlanket Purcahse Order Releases.Acceptance Due DateACCEPTANCE_DUE_DATEACCEPTANCE_DUE_DATE114032
Acceptance Due Date - Day Blanket Purcahse Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_DAY168247
Acceptance Due Date - Month Blanket Purcahse Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_MONTH168261
Acceptance Due Date - Quarter Blanket Purcahse Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_QUARTER168275
Acceptance Due Date - Year Blanket Purcahse Order Releases.Acceptance Due Date ACCEPTANCE_DUE_DATE_YEAR168289
Acceptance Required Flag Blanket Purcahse Order Releases.Acceptance Required FlagACCEPTANCE_REQUIRED_FLAGACCEPTANCE_REQUIRED_FLAG275817
Acknowledgement Date Blanket Purcahse Order Releases.Acknowledgement DateACKNOWLEDGEMENT_DATEACKNOWLEDGEMENT_DATE275823
Acknowledgement Type Blanket Purcahse Order Releases.Acknowledgement TypeACKNOWLEDGEMENT_TYPEACKNOWLEDGEMENT_TYPE275822
Approval Date Blanket Purcahse Order Releases.Approval DateAPPROVAL_DATEAPPROVAL_DATE116321
Approval Date - Day Blanket Purcahse Order Releases.Approval Date APPROVAL_DATE_DAY169029
Approval Date - Month Blanket Purcahse Order Releases.Approval Date APPROVAL_DATE_MONTH169063
Approval Date - Quarter Blanket Purcahse Order Releases.Approval Date APPROVAL_DATE_QUARTER169097
Approval Date - Year Blanket Purcahse Order Releases.Approval Date APPROVAL_DATE_YEAR169131
Authorization Status Blanket Purcahse Order Releases.Authorization StatusAUTHORIZATION_STATUSAUTHORIZATION_STATUS275811
Blanket Purchase Order Document Number Blanket Purcahse Order Releases.Blanket Purchase Order Document NumberBLANKET_PO_DOCUMENT_NUMBERBLANKET_PO_DOCUMENT_NUMBER119983
Blanket Purchase Order IDUnique identifier for Blanket Purchase OrderBlanket Purcahse Order Releases.Blanket Purchase Order IDBLANKET_PO_IDBLANKET_PO_ID119988
Blanket Purchase Order Release IDUnique identifier for Blanket Purchase Order ReleaseBlanket Purcahse Order Releases.Blanket Purchase Order Release IDBLANKET_PO_RELEASE_IDBLANKET_PO_RELEASE_ID119991
Buyer Employee Number Blanket Purcahse Order Releases.Buyer Employee NumberBUYER_EMPLOYEE_NUMBERBUYER_EMPLOYEE_NUMBER121226
Buyer IDUnique identifier for BuyerBlanket Purcahse Order Releases.Buyer IDBUYER_IDBUYER_ID121239
Buyer Name Blanket Purcahse Order Releases.Buyer NameBUYER_NAMEBUYER_NAME121251
Cancel Flag Blanket Purcahse Order Releases.Cancel FlagCANCEL_FLAGCANCEL_FLAG275812
Cancelled By Blanket Purcahse Order Releases.Cancelled ByCANCELLED_BYCANCELLED_BY121425
Cancelled By Employee Name Blanket Purcahse Order Releases.Cancelled By Employee NameCANCELLED_BY_EMPLOYEE_NAMECANCELLED_BY_EMPLOYEE_NAME121431
Cancelled By Employee Number Blanket Purcahse Order Releases.Cancelled By Employee NumberCANCELLED_BY_EMPLOYEE_NUMBERCANCELLED_BY_EMPLOYEE_NUMBER121437
Cbc Accounting Date Blanket Purcahse Order Releases.Cbc Accounting DateCBC_ACCOUNTING_DATECBC_ACCOUNTING_DATE275829
Change Requested By Blanket Purcahse Order Releases.Change Requested ByCHANGE_REQUESTED_BYCHANGE_REQUESTED_BY275832
Closure Status Blanket Purcahse Order Releases.Closure StatusCLOSURE_STATUSCLOSURE_STATUS275813
Consigned Consum Flag Blanket Purcahse Order Releases.Consigned Consum FlagCONSIGNED_CONSUM_FLAGCONSIGNED_CONSUM_FLAG275831
Context Blanket Purcahse Order Releases.ContextCONTEXTCONTEXT275819
Created By Blanket Purcahse Order Releases.Created ByCREATED_BYCREATED_BY125215
Created Date Blanket Purcahse Order Releases.Created DateCREATED_DATECREATED_DATE125390
Created Date - Day Blanket Purcahse Order Releases.Created Date CREATED_DATE_DAY171203
Created Date - Month Blanket Purcahse Order Releases.Created Date CREATED_DATE_MONTH171357
Created Date - Quarter Blanket Purcahse Order Releases.Created Date CREATED_DATE_QUARTER171511
Created Date - Year Blanket Purcahse Order Releases.Created Date CREATED_DATE_YEAR171665
CurrencyThe currency for an account balance.Blanket Purcahse Order Releases.CurrencyCURRENCYCURRENCY126947
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Blanket Purcahse Order Releases.Currency CodeCURRENCY_CODECURRENCY_CODE127048
EDI Type Blanket Purcahse Order Releases.EDI TypeEDI_TYPEEDI_TYPE275825
Edi Processed FlagElectronic Data Interchange (EDI) Processed flagBlanket Purcahse Order Releases.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG130720
Error Message Blanket Purcahse Order Releases.Error MessageERROR_MESSAGEERROR_MESSAGE275824
Firm Status Blanket Purcahse Order Releases.Firm StatusFIRM_STATUSFIRM_STATUS275814
Frozen Flag Blanket Purcahse Order Releases.Frozen FlagFROZEN_FLAGFROZEN_FLAG275815
Hold Flag Blanket Purcahse Order Releases.Hold FlagHOLD_FLAGHOLD_FLAG275816
Last Printed Date Blanket Purcahse Order Releases.Last Printed DateLAST_PRINTED_DATELAST_PRINTED_DATE138585
Last Printed Date - Day Blanket Purcahse Order Releases.Last Printed Date LAST_PRINTED_DATE_DAY182370
Last Printed Date - Month Blanket Purcahse Order Releases.Last Printed Date LAST_PRINTED_DATE_MONTH182390
Last Printed Date - Quarter Blanket Purcahse Order Releases.Last Printed Date LAST_PRINTED_DATE_QUARTER182410
Last Printed Date - Year Blanket Purcahse Order Releases.Last Printed Date LAST_PRINTED_DATE_YEAR182430
Last Updated By Blanket Purcahse Order Releases.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139795
Last Updated Date Blanket Purcahse Order Releases.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139969
Last Updated Date - Day Blanket Purcahse Order Releases.Last Updated Date LAST_UPDATED_DATE_DAY182886
Last Updated Date - Month Blanket Purcahse Order Releases.Last Updated Date LAST_UPDATED_DATE_MONTH183048
Last Updated Date - Quarter Blanket Purcahse Order Releases.Last Updated Date LAST_UPDATED_DATE_QUARTER183210
Last Updated Date - Year Blanket Purcahse Order Releases.Last Updated Date LAST_UPDATED_DATE_YEAR183372
Modus Order Number Blanket Purcahse Order Releases.Modus Order NumberMODUS_ORDER_NUMBERMODUS_ORDER_NUMBER275821
OPM Organization Blanket Purcahse Order Releases.OPM OrganizationOPM_ORGANIZATIONOPM_ORGANIZATION275820
Operating Unit IDUnique identifier for Operating UnitBlanket Purcahse Order Releases.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149533
Operating Unit Name Blanket Purcahse Order Releases.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149581
Pay On Blanket Purcahse Order Releases.Pay OnPAY_ONPAY_ON275818
Payment Card IDUnique identifier for Payment CardBlanket Purcahse Order Releases.Payment Card IDPCARD_IDPCARD_ID152635
Payment Card Number Blanket Purcahse Order Releases.Payment Card NumberPCARD_NUMBERPCARD_NUMBER152639
Print CountNumber of times batch ticket was printed.Blanket Purcahse Order Releases.Print CountPRINT_COUNTPRINT_COUNT155636
Release Date Blanket Purcahse Order Releases.Release DateRELEASE_DATERELEASE_DATE158450
Release Date - Day Blanket Purcahse Order Releases.Release Date RELEASE_DATE_DAY189650
Release Date - Month Blanket Purcahse Order Releases.Release Date RELEASE_DATE_MONTH189654
Release Date - Quarter Blanket Purcahse Order Releases.Release Date RELEASE_DATE_QUARTER189658
Release Date - Year Blanket Purcahse Order Releases.Release Date RELEASE_DATE_YEAR189662
Release NumberSequence number of the releaseBlanket Purcahse Order Releases.Release NumberRELEASE_NUMBERRELEASE_NUMBER158455
Revised Date Blanket Purcahse Order Releases.Revised DateREVISED_DATEREVISED_DATE159496
Revision NumberDocument revision numberBlanket Purcahse Order Releases.Revision NumberREVISION_NUMBERREVISION_NUMBER159532
Supplier IDUnique identifier for SupplierBlanket Purcahse Order Releases.Supplier IDSUPPLIER_IDSUPPLIER_ID164208
Supplier Name Blanket Purcahse Order Releases.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164252
Supplier NoteNote to supplierBlanket Purcahse Order Releases.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164269
Supplier Site Blanket Purcahse Order Releases.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164301
Supplier Site IDUnique identifier for Supplier SiteBlanket Purcahse Order Releases.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164325
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Blanket Purcahse Order Releases.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167050
Vendor Order Num Blanket Purcahse Order Releases.Vendor Order NumVENDOR_ORDER_NUMVENDOR_ORDER_NUM275830
Xml Change Send Date Blanket Purcahse Order Releases.Xml Change Send DateXML_CHANGE_SEND_DATEXML_CHANGE_SEND_DATE275828
Xml Flag Blanket Purcahse Order Releases.Xml FlagXML_FLAGXML_FLAG275826
Xml Send Date Blanket Purcahse Order Releases.Xml Send DateXML_SEND_DATEXML_SEND_DATE275827
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Blanket Purcahse Order Releases -> Blanket Purchase Order DistributionsBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Blanket Purchase Order Distributions.Blanket Release IDAlways exist in master folderNoneNo
Blanket Purcahse Order Releases -> Blanket Purchase Order ShipmentsBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Blanket Purchase Order Shipments.Blanket Release IDMight not exist in master folderOuter join on master No
Blanket Purcahse Order Releases -> Inbound Shipment LinesBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Inbound Shipment Lines.Purchase Order Release IDMight not exist in master folderOuter join on master No
Blanket Purcahse Order Releases -> Purchase Order DistributionsBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Purchase Order Distributions.Release IDMight not exist in master folderOuter join on master No
Blanket Purcahse Order Releases -> Purchase Order Line ShipmentsBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Purchase Order Line Shipments.Release IDMight not exist in master folderOuter join on master No
Blanket Purcahse Order Releases -> Receiving TransactionsBlanket Purcahse Order Releases.Blanket Purchase Order Release ID = Receiving Transactions.Purchase Order Release IDMight not exist in master folderOuter join on master No