Powered by InfoCaptor


Previous Page   Next Page

Blanket Purchase Orders
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_BKT_PURCHASE_ORDERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Due DateDate by which the supplier should accept the documentBlanket Purchase Orders.Acceptance Due DateACCEPTANCE_DUE_DATEACCEPTANCE_DUE_DATE114033
Acceptance Due Date - Day Blanket Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_DAY168249
Acceptance Due Date - Month Blanket Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_MONTH168263
Acceptance Due Date - Quarter Blanket Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_QUARTER168277
Acceptance Due Date - Year Blanket Purchase Orders.Acceptance Due Date ACCEPTANCE_DUE_DATE_YEAR168291
Acceptance Required Flag Blanket Purchase Orders.Acceptance Required FlagACCEPTANCE_REQUIRED_FLAGACCEPTANCE_REQUIRED_FLAG275873
Acknowledgement Date Blanket Purchase Orders.Acknowledgement DateACKNOWLEDGEMENT_DATEACKNOWLEDGEMENT_DATE275880
Acknowledgement Type Blanket Purchase Orders.Acknowledgement TypeACKNOWLEDGEMENT_TYPEACKNOWLEDGEMENT_TYPE275879
Agreed Amount Blanket Purchase Orders.Agreed AmountAGREED_AMOUNTAGREED_AMOUNT115398
Amount Limit Blanket Purchase Orders.Amount LimitAMOUNT_LIMITAMOUNT_LIMIT115902
Approval Date Blanket Purchase Orders.Approval DateAPPROVAL_DATEAPPROVAL_DATE116323
Approval Date - Day Blanket Purchase Orders.Approval Date APPROVAL_DATE_DAY169033
Approval Date - Month Blanket Purchase Orders.Approval Date APPROVAL_DATE_MONTH169067
Approval Date - Quarter Blanket Purchase Orders.Approval Date APPROVAL_DATE_QUARTER169101
Approval Date - Year Blanket Purchase Orders.Approval Date APPROVAL_DATE_YEAR169135
Authorization Status Blanket Purchase Orders.Authorization StatusAUTHORIZATION_STATUSAUTHORIZATION_STATUS275865
BOL Blanket Purchase Orders.BOLBOLBOL275878
Bill To Location Blanket Purchase Orders.Bill To LocationBILL_TO_LOCATIONBILL_TO_LOCATION119932
Bill To Location IDUnique identifier for Bill To LocationBlanket Purchase Orders.Bill To Location IDBILL_TO_LOCATION_IDBILL_TO_LOCATION_ID119940
Blanket Purchase Order IDUnique identifier for Blanket Purchase OrderBlanket Purchase Orders.Blanket Purchase Order IDBLANKET_PO_IDBLANKET_PO_ID119990
Buyer Employee Number Blanket Purchase Orders.Buyer Employee NumberBUYER_EMPLOYEE_NUMBERBUYER_EMPLOYEE_NUMBER121227
Buyer IDUnique identifier for BuyerBlanket Purchase Orders.Buyer IDBUYER_IDBUYER_ID121240
Buyer Name Blanket Purchase Orders.Buyer NameBUYER_NAMEBUYER_NAME121252
Cancel Flag Blanket Purchase Orders.Cancel FlagCANCEL_FLAGCANCEL_FLAG275866
Carrier Blanket Purchase Orders.CarrierCARRIERCARRIER121565
Carrier Description Blanket Purchase Orders.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121578
Carrier Organization Code Blanket Purchase Orders.Carrier Organization CodeCARRIER_ORGANIZATION_CODECARRIER_ORGANIZATION_CODE121604
Carrier Organization IDUnique identifier for Carrier OrganizationBlanket Purchase Orders.Carrier Organization IDCARRIER_ORGANIZATION_IDCARRIER_ORGANIZATION_ID121614
Closed Date Blanket Purchase Orders.Closed DateCLOSED_DATECLOSED_DATE122179
Closed Date - Day Blanket Purchase Orders.Closed Date CLOSED_DATE_DAY170521
Closed Date - Month Blanket Purchase Orders.Closed Date CLOSED_DATE_MONTH170559
Closed Date - Quarter Blanket Purchase Orders.Closed Date CLOSED_DATE_QUARTER170597
Closed Date - Year Blanket Purchase Orders.Closed Date CLOSED_DATE_YEAR170637
Closure Status Blanket Purchase Orders.Closure StatusCLOSURE_STATUSCLOSURE_STATUS275867
Confirming Order Flag Blanket Purchase Orders.Confirming Order FlagCONFIRMING_ORDER_FLAGCONFIRMING_ORDER_FLAG275874
Consume Req Demand Flag Blanket Purchase Orders.Consume Req Demand FlagCONSUME_REQ_DEMAND_FLAGCONSUME_REQ_DEMAND_FLAG275885
Conterms Articles Upd Date Blanket Purchase Orders.Conterms Articles Upd DateCONTERMS_ARTICLES_UPD_DATECONTERMS_ARTICLES_UPD_DATE275888
Conterms Deliv Upd Date Blanket Purchase Orders.Conterms Deliv Upd DateCONTERMS_DELIV_UPD_DATECONTERMS_DELIV_UPD_DATE275889
Conterms Exist Flag Blanket Purchase Orders.Conterms Exist FlagCONTERMS_EXIST_FLAGCONTERMS_EXIST_FLAG275887
Context Blanket Purchase Orders.ContextCONTEXTCONTEXT275877
Created By Blanket Purchase Orders.Created ByCREATED_BYCREATED_BY125217
Created Date Blanket Purchase Orders.Created DateCREATED_DATECREATED_DATE125392
Created Date - Day Blanket Purchase Orders.Created Date CREATED_DATE_DAY171207
Created Date - Month Blanket Purchase Orders.Created Date CREATED_DATE_MONTH171361
Created Date - Quarter Blanket Purchase Orders.Created Date CREATED_DATE_QUARTER171515
Created Date - Year Blanket Purchase Orders.Created Date CREATED_DATE_YEAR171669
CurrencyThe currency for an account balance.Blanket Purchase Orders.CurrencyCURRENCYCURRENCY126948
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Blanket Purchase Orders.Currency CodeCURRENCY_CODECURRENCY_CODE127049
Currency Conversion RateThe currency exchange rate.Blanket Purchase Orders.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127113
Currency Conversion Rate DateDate upon which to obtain the currency conversion rateBlanket Purchase Orders.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127134
Currency Conversion Rate Date - Day Blanket Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174012
Currency Conversion Rate Date - Month Blanket Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174052
Currency Conversion Rate Date - Quarter Blanket Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174092
Currency Conversion Rate Date - Year Blanket Purchase Orders.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174132
Currency Conversion Rate Type Blanket Purchase Orders.Currency Conversion Rate TypeCURRENCY_CONVERSION_RATE_TYPECURRENCY_CONVERSION_RATE_TYPE127154
DescriptionThe accounting period description.Blanket Purchase Orders.DescriptionDESCRIPTIONDESCRIPTION129824
Document Creation Method Blanket Purchase Orders.Document Creation MethodDOCUMENT_CREATION_METHODDOCUMENT_CREATION_METHOD275890
Document NumberThe journal entry document number.Blanket Purchase Orders.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130344
EDI Type Blanket Purchase Orders.EDI TypeEDI_TYPEEDI_TYPE275882
Edi Processed FlagElectronic Data Interchange (EDI) Processed flagBlanket Purchase Orders.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG130721
Edi Processed StatusElectronic Data Interchange (EDI) Processed StatusBlanket Purchase Orders.Edi Processed StatusEDI_PROCESSED_STATUSEDI_PROCESSED_STATUS130727
End Effective DateThe date after which an account becomes inactive.Blanket Purchase Orders.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133123
End Effective Date - Day Blanket Purchase Orders.End Effective Date END_EFFECTIVE_DATE_DAY178625
End Effective Date - Month Blanket Purchase Orders.End Effective Date END_EFFECTIVE_DATE_MONTH178721
End Effective Date - Quarter Blanket Purchase Orders.End Effective Date END_EFFECTIVE_DATE_QUARTER178817
End Effective Date - Year Blanket Purchase Orders.End Effective Date END_EFFECTIVE_DATE_YEAR178913
Error Message Blanket Purchase Orders.Error MessageERROR_MESSAGEERROR_MESSAGE275881
Firm Status Blanket Purchase Orders.Firm StatusFIRM_STATUSFIRM_STATUS275868
Free On Board Point Blanket Purchase Orders.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT275872
Freight Term Blanket Purchase Orders.Freight TermFREIGHT_TERMFREIGHT_TERM275871
Frozen Flag Blanket Purchase Orders.Frozen FlagFROZEN_FLAGFROZEN_FLAG275869
Global Agreement Flag Blanket Purchase Orders.Global Agreement FlagGLOBAL_AGREEMENT_FLAGGLOBAL_AGREEMENT_FLAG275884
Hold Flag Blanket Purchase Orders.Hold FlagHOLD_FLAGHOLD_FLAG275870
Last Printed Date Blanket Purchase Orders.Last Printed DateLAST_PRINTED_DATELAST_PRINTED_DATE138586
Last Printed Date - Day Blanket Purchase Orders.Last Printed Date LAST_PRINTED_DATE_DAY182372
Last Printed Date - Month Blanket Purchase Orders.Last Printed Date LAST_PRINTED_DATE_MONTH182392
Last Printed Date - Quarter Blanket Purchase Orders.Last Printed Date LAST_PRINTED_DATE_QUARTER182412
Last Printed Date - Year Blanket Purchase Orders.Last Printed Date LAST_PRINTED_DATE_YEAR182432
Last Updated By Blanket Purchase Orders.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139797
Last Updated Date Blanket Purchase Orders.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139971
Last Updated Date - Day Blanket Purchase Orders.Last Updated Date LAST_UPDATED_DATE_DAY182890
Last Updated Date - Month Blanket Purchase Orders.Last Updated Date LAST_UPDATED_DATE_MONTH183052
Last Updated Date - Quarter Blanket Purchase Orders.Last Updated Date LAST_UPDATED_DATE_QUARTER183214
Last Updated Date - Year Blanket Purchase Orders.Last Updated Date LAST_UPDATED_DATE_YEAR183376
Minimum Release AmountThe minimum amount buyers can release for each releaseBlanket Purchase Orders.Minimum Release AmountMINIMUM_RELEASE_AMOUNTMINIMUM_RELEASE_AMOUNT147156
Modus Order Number Blanket Purchase Orders.Modus Order NumberMODUS_ORDER_NUMBERMODUS_ORDER_NUMBER275883
Operating Unit IDUnique identifier for Operating UnitBlanket Purchase Orders.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149535
Operating Unit Name Blanket Purchase Orders.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149583
Pay On Blanket Purchase Orders.Pay OnPAY_ONPAY_ON275876
Payment Terms IDUnique identifier for Payment TermsBlanket Purchase Orders.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152263
Payment Terms Name Blanket Purchase Orders.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152279
Pending Signature Flag Blanket Purchase Orders.Pending Signature FlagPENDING_SIGNATURE_FLAGPENDING_SIGNATURE_FLAG275886
Price Update Tolerance Blanket Purchase Orders.Price Update TolerancePRICE_UPDATE_TOLERANCEPRICE_UPDATE_TOLERANCE155392
Print CountNumber of times batch ticket was printed.Blanket Purchase Orders.Print CountPRINT_COUNTPRINT_COUNT155637
Rate Type Description Blanket Purchase Orders.Rate Type DescriptionRATE_TYPE_DESCRIPTIONRATE_TYPE_DESCRIPTION157639
Rate Type Name Blanket Purchase Orders.Rate Type NameRATE_TYPE_NAMERATE_TYPE_NAME157654
Receiver NoteNote to receiverBlanket Purchase Orders.Receiver NoteRECEIVER_NOTERECEIVER_NOTE158057
Revised Date Blanket Purchase Orders.Revised DateREVISED_DATEREVISED_DATE159497
Revision NumberDocument revision numberBlanket Purchase Orders.Revision NumberREVISION_NUMBERREVISION_NUMBER159533
Ship To Location Blanket Purchase Orders.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161917
Ship To Location IDUnique identifier for Ship To LocationBlanket Purchase Orders.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161944
Start Effective DateThe date on which an account becomes active.Blanket Purchase Orders.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163281
Start Effective Date - Day Blanket Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_DAY191151
Start Effective Date - Month Blanket Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_MONTH191237
Start Effective Date - Quarter Blanket Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_QUARTER191323
Start Effective Date - Year Blanket Purchase Orders.Start Effective Date START_EFFECTIVE_DATE_YEAR191409
Supplier Contact IDUnique identifier for Supplier ContactBlanket Purchase Orders.Supplier Contact IDSUPPLIER_CONTACT_IDSUPPLIER_CONTACT_ID164176
Supplier Contact Name Blanket Purchase Orders.Supplier Contact NameSUPPLIER_CONTACT_NAMESUPPLIER_CONTACT_NAME164186
Supplier IDUnique identifier for SupplierBlanket Purchase Orders.Supplier IDSUPPLIER_IDSUPPLIER_ID164209
Supplier Name Blanket Purchase Orders.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164253
Supplier NoteNote to supplierBlanket Purchase Orders.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164270
Supplier Order Number Blanket Purchase Orders.Supplier Order NumberSUPPLIER_ORDER_NUMBERSUPPLIER_ORDER_NUMBER164284
Supplier Site Blanket Purchase Orders.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164302
Supplier Site IDUnique identifier for Supplier SiteBlanket Purchase Orders.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164326
Supply Agreement Flag Blanket Purchase Orders.Supply Agreement FlagSUPPLY_AGREEMENT_FLAGSUPPLY_AGREEMENT_FLAG275875
Ussgl Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Blanket Purchase Orders.Ussgl Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167052
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Blanket Purchase Orders -> Blanket Purcahse Order ReleasesBlanket Purchase Orders.Blanket Purchase Order ID = Blanket Purcahse Order Releases.Blanket Purchase Order IDAlways exist in master folderNoneNo
Blanket Purchase Orders -> Blanket Purchase Order DistributionsBlanket Purchase Orders.Blanket Purchase Order ID = Blanket Purchase Order Distributions.Blanket PO IDAlways exist in master folderNoneNo
Blanket Purchase Orders -> Blanket Purchase Order Line Price BreaksBlanket Purchase Orders.Blanket Purchase Order ID = Blanket Purchase Order Line Price Breaks.Blanket Purchase Order IDAlways exist in master folderNoneNo
Blanket Purchase Orders -> Blanket Purchase Order ShipmentsBlanket Purchase Orders.Blanket Purchase Order ID = Blanket Purchase Order Shipments.Blanket Purchase Order IDAlways exist in master folderNoneNo